From c74b2e7674da155fc51b1f71405ec182992fc114 Mon Sep 17 00:00:00 2001
From: wujianwei <wjw@11.com>
Date: 星期二, 30 十二月 2025 09:54:25 +0800
Subject: [PATCH] 新增api大屏查询详情接口

---
 tms/src/main/java/com/ruoyi/tms/service/impl/TmsDispatchOrderServiceImpl.java |   43 +++++++++++++++++++++++++++++++++----------
 1 files changed, 33 insertions(+), 10 deletions(-)

diff --git a/tms/src/main/java/com/ruoyi/tms/service/impl/TmsDispatchOrderServiceImpl.java b/tms/src/main/java/com/ruoyi/tms/service/impl/TmsDispatchOrderServiceImpl.java
index 7765095..4b478ad 100644
--- a/tms/src/main/java/com/ruoyi/tms/service/impl/TmsDispatchOrderServiceImpl.java
+++ b/tms/src/main/java/com/ruoyi/tms/service/impl/TmsDispatchOrderServiceImpl.java
@@ -19,6 +19,8 @@
 import com.ruoyi.system.service.ISysUserService;
 import com.ruoyi.system.service.ISystemDataNoService;
 import com.ruoyi.tms.domain.*;
+import com.ruoyi.tms.domain.vo.DpDriverDispatchItemVo;
+import com.ruoyi.tms.domain.vo.DpDriverDispatchVo;
 import com.ruoyi.tms.domain.vo.DriverDispatchVo;
 import com.ruoyi.tms.domain.vo.ServiceProviderVo;
 import com.ruoyi.tms.mapper.*;
@@ -543,7 +545,7 @@
                     // 鍑哄彂璺嚎 44,4404,440402,440402102
                     String shipperRegionCode = tmsDispatchOrder.getStartRegionCode();
                     // 鐩殑鍦拌矾绾� 81,8100,810000
-                    String receiverRegionCode = tmsDispatchOrder.getReceiverRegionCode();
+                    String receiverRegionCode = tmsDispatchOrder.getEndRegionCode();
 
                     // 鏌ヨ搴旀敹瑙勫垯
                     TmsQuoteDetail tmsQuoteDetail = tmsQuoteDetailMapper.selectOne(new LambdaQueryWrapper<TmsQuoteDetail>()
@@ -673,17 +675,28 @@
                     // 鍑哄彂璺嚎 44,4404,440402,440402102
                     String shipperRegionCode = tmsDispatchOrder.getStartRegionCode();
                     // 鐩殑鍦拌矾绾� 81,8100,810000
-                    String receiverRegionCode = tmsDispatchOrder.getReceiverRegionCode();
+                    String receiverRegionCode = tmsDispatchOrder.getEndRegionCode();
 
                     // 鏌ヨ搴旀敹瑙勫垯
-                    TmsQuoteDetail tmsQuoteDetail = tmsQuoteDetailMapper.selectOne(new LambdaQueryWrapper<TmsQuoteDetail>()
-                            .eq(TmsQuoteDetail::getVehicleProviderId, vehicleProviderId)
-                            .eq(TmsQuoteDetail::getVehicleType, actualVehicleType)
-                            .eq(TmsQuoteDetail::getStartRegionCode, shipperRegionCode)
-                            .eq(TmsQuoteDetail::getEndRegionCode, receiverRegionCode)
-                            .eq(TmsQuoteDetail::getPlanType, 1)
-                            .last("limit 1")
-                    );
+                    TmsQuoteDetail tmsQuoteDetail =
+                            tmsQuoteDetailMapper.selectOne(
+                                    new LambdaQueryWrapper<TmsQuoteDetail>()
+                                            .eq(TmsQuoteDetail::getVehicleType, actualVehicleType)
+                                            .eq(TmsQuoteDetail::getStartRegionCode, shipperRegionCode)
+                                            .eq(TmsQuoteDetail::getEndRegionCode, receiverRegionCode)
+                                            .eq(TmsQuoteDetail::getPlanType, 1)
+                                            .exists(
+                                                    "SELECT 1 " +
+                                                            "FROM tms_quote_plan tqp " +
+                                                            "WHERE tqp.id = tms_quote_detail.quote_plan_id " +
+                                                            "AND tqp.provider_id = {0} " +
+                                                            "AND tqp.plan_type = 1 " +
+                                                            "AND tqp.provider_type = 0",
+                                                    vehicleProviderId
+                                            )
+                                            .last("LIMIT 1")
+                            );
+
 
 
 
@@ -1041,4 +1054,14 @@
         }
         return AjaxResult.success();
     }
+
+    @Override
+    public List<DpDriverDispatchVo> selectDpData() {
+        return tmsDispatchOrderMapper.selectselectDpData();
+    }
+
+    @Override
+    public DpDriverDispatchItemVo selectDataByNo(String no) {
+        return tmsDispatchOrderMapper.selectDataByNo(no);
+    }
 }

--
Gitblit v1.8.0