From ae0844d3e506c12daf2595670a156419ca69a042 Mon Sep 17 00:00:00 2001
From: wujianwei <wjw@11.com>
Date: 星期二, 29 七月 2025 11:49:36 +0800
Subject: [PATCH] 新增调度单后端
---
service/src/main/java/com/ruoyi/cwgl/service/IDispatchOrderService.java | 1
service/src/main/java/com/ruoyi/cwgl/service/impl/DispatchOrderServiceImpl.java | 12 ++++++
service/src/main/resources/mapper/cwgl/DispatchOrderMapper.xml | 74 +++++++++++++++++++++++++++++++++++++
service/src/main/java/com/ruoyi/cwgl/mapper/DispatchOrderMapper.java | 1
service/src/main/java/com/ruoyi/cwgl/controller/DispatchOrderController.java | 2
5 files changed, 89 insertions(+), 1 deletions(-)
diff --git a/service/src/main/java/com/ruoyi/cwgl/controller/DispatchOrderController.java b/service/src/main/java/com/ruoyi/cwgl/controller/DispatchOrderController.java
index d13f333..51248a5 100644
--- a/service/src/main/java/com/ruoyi/cwgl/controller/DispatchOrderController.java
+++ b/service/src/main/java/com/ruoyi/cwgl/controller/DispatchOrderController.java
@@ -44,7 +44,7 @@
public TableDataInfo list(DispatchOrder dispatchOrder)
{
startPage();
- List<DispatchOrder> list = dispatchOrderService.selectDispatchOrderList(dispatchOrder);
+ List<DispatchOrder> list = dispatchOrderService.selectDispatchOrderList2(dispatchOrder);
return getDataTable(list);
}
diff --git a/service/src/main/java/com/ruoyi/cwgl/mapper/DispatchOrderMapper.java b/service/src/main/java/com/ruoyi/cwgl/mapper/DispatchOrderMapper.java
index 592b268..be684e3 100644
--- a/service/src/main/java/com/ruoyi/cwgl/mapper/DispatchOrderMapper.java
+++ b/service/src/main/java/com/ruoyi/cwgl/mapper/DispatchOrderMapper.java
@@ -36,6 +36,7 @@
* @return 璋冨害鍗曢泦鍚�
*/
public List<DispatchOrder> selectDispatchOrderList(DispatchOrder dispatchOrder);
+ public List<DispatchOrder> selectDispatchOrderList2(DispatchOrder dispatchOrder);
/**
* 鏂板璋冨害鍗�
diff --git a/service/src/main/java/com/ruoyi/cwgl/service/IDispatchOrderService.java b/service/src/main/java/com/ruoyi/cwgl/service/IDispatchOrderService.java
index e7f7ab7..238e0ce 100644
--- a/service/src/main/java/com/ruoyi/cwgl/service/IDispatchOrderService.java
+++ b/service/src/main/java/com/ruoyi/cwgl/service/IDispatchOrderService.java
@@ -34,6 +34,7 @@
* @return 璋冨害鍗曢泦鍚�
*/
public List<DispatchOrder> selectDispatchOrderList(DispatchOrder dispatchOrder);
+ public List<DispatchOrder> selectDispatchOrderList2(DispatchOrder dispatchOrder);
/**
* 鏌ヨ璋冨害鍗曞垪琛� 寮傛 瀵煎嚭
diff --git a/service/src/main/java/com/ruoyi/cwgl/service/impl/DispatchOrderServiceImpl.java b/service/src/main/java/com/ruoyi/cwgl/service/impl/DispatchOrderServiceImpl.java
index 5643f03..dd052f5 100644
--- a/service/src/main/java/com/ruoyi/cwgl/service/impl/DispatchOrderServiceImpl.java
+++ b/service/src/main/java/com/ruoyi/cwgl/service/impl/DispatchOrderServiceImpl.java
@@ -73,6 +73,18 @@
{
return dispatchOrderMapper.selectDispatchOrderList(dispatchOrder);
}
+ /**
+ * 鏌ヨ璋冨害鍗曞垪琛�
+ *
+ * @param dispatchOrder 璋冨害鍗�
+ * @return 璋冨害鍗�
+ */
+ @DataSource(DataSourceType.CWSJ)
+ @Override
+ public List<DispatchOrder> selectDispatchOrderList2(DispatchOrder dispatchOrder)
+ {
+ return dispatchOrderMapper.selectDispatchOrderList(dispatchOrder);
+ }
/**
* 鏌ヨ璋冨害鍗曞垪琛� 寮傛 瀵煎嚭
diff --git a/service/src/main/resources/mapper/cwgl/DispatchOrderMapper.xml b/service/src/main/resources/mapper/cwgl/DispatchOrderMapper.xml
index c5218ba..32ee08d 100644
--- a/service/src/main/resources/mapper/cwgl/DispatchOrderMapper.xml
+++ b/service/src/main/resources/mapper/cwgl/DispatchOrderMapper.xml
@@ -86,6 +86,80 @@
order by thisTab.id desc
</select>
+ <select id="selectDispatchOrderList2" parameterType="com.ruoyi.cwgl.domain.DispatchOrder" resultMap="DispatchOrderResult">
+ SELECT
+ ts.DISPATCH_NO as 'dispatch_no',
+ ts.TRANSPORT_MODE as 'transport_mode',
+ ts.PRODUCT_ID as 'product_name',
+ bp.`NAME` as 'carrier_name',
+ location_d.NAME_TREE as 'departure_location_name',
+ -- ts.ARRIVAL_LOCATION_ID '鐩殑鍦癐D',
+ location_a.NAME_TREE as 'arrival_location_name',
+ -- ts.VEHICLE_ID '杩愯緭宸ュ叿ID',
+ vhc.LICENSE_PLATE_NUMBER as 'license_plate_number',
+ ts.VEHICLE_PLATE_ID as 'vehicle_plate_id',
+ driver_m.`NAME` as 'main_driver_name',
+ driver_a.`NAME` as 'assistant_driver_name',
+ ts.POINT_NUM as 'point_num',
+ -- ts.ELECTRONIC_LOCK '鐢靛瓙閿�',
+ -- ts.RE_WEIGHING_WEIGHT '澶嶇閲嶉噺',
+ ts.QUANTITY as 'quantity',
+ ts.ACTUAL_DEPARTURE_TIME as'actual_departure_time',
+ ts.REQUIRED_ARRIVAL_TIME as 'required_arrival_time',
+ ts.ACTUAL_ARRIVAL_TIME as 'actual_arrival_time',
+ ts.BE_RETURN as 'be_return',
+ ts.DISPATCH_QUANTITY as 'dispatch_quantity',
+ ts.DISPATCH_WEIGHT as 'dispatch_weight',
+ ts.DISPATCH_VOLUME as 'dispatch_volume',
+ -- ts.EMPTY_MILEAGE '绌鸿浇閲岀▼锛堝叕閲岋級',
+ -- ts.EMPTY_FUEL '绌鸿浇娌硅�楋紙鍗囷級',
+ -- ts.HEAVY_MILEAGE '閲嶈浇閲岀▼锛堝叕閲岋級',
+ -- ts.HEAVY_FUEL '閲嶈浇娌硅�楋紙鍗�)',
+ -- ts.BE_SCHEDULED '鏄惁鎸夌彮娆�',
+ -- ts.TRACKING_NO '蹇�掑崟鍙�',
+ -- ts.SEAL_NO '閾呭皝鍙�',
+ -- ts.SCHEDULE_NO '鐝鍙�',
+ CASE ts.`STATUS`
+ WHEN 'A' THEN '鐢熸晥'
+ WHEN 'O' THEN '鎵撳紑'
+ WHEN 'J' THEN '宸叉帴鍗�'
+ WHEN 'K' THEN '宸插埌搴�'
+ WHEN 'Z' THEN '宸茶杞�'
+ WHEN 'T' THEN '鍦ㄩ��'
+ WHEN 'F' THEN '宸插纾�'
+ WHEN 'D' THEN '宸茶繍鎶�'
+ ELSE '鏈煡鐘舵��'
+ END AS 'remark',
+ -- ts.ESTIMATED_COST '棰勪及璐圭敤',
+ -- ts.ESTIMATED_CARRIER_NUM '棰勪及鎵胯繍鍟嗘暟',
+ -- ts.ESTIMATED_COST_SAVING '棰勪及鑺傜害璐圭敤',
+ -- ts.TRANSPORT_LINE '杩愯緭绾胯矾',
+ ts.REMARK '澶囨敞'
+ -- ts.DISPATCH_PERMISSION_GROUP '璋冨害鏉冮檺鍒嗙粍',
+ -- ts.DISPATCH_GROUP '璋冨害鍒嗙粍',
+ -- ts.ROUTE_CODE '绾胯矾鍙�',
+
+ FROM
+ tms_shipment ts
+ -- 璁㈠崟琛�
+ -- LEFT JOIN oms_order ord ON ts.DISPATCH_NO = ord.DISPATCH_CODE
+ left join tms_vehicle vhc on ts.VEHICLE_ID=vhc.id
+ left join base_provider bp on bp.ID=ts.CARRIER_ID
+ -- 鍙告満琛�
+ left join tms_driver driver_m on driver_m.ID=ts.MAIN_DRIVER_ID
+ -- 鍙告満琛�
+ left join tms_driver driver_a on driver_a.ID=ts.ASSISTANT_DRIVER_ID
+ -- 鍦板尯琛�
+ left join base_location location_a on location_a.ID =ts.ARRIVAL_LOCATION_ID
+ -- 鍦板尯琛�
+ left join base_location location_d on location_d.ID =ts.DEPARTURE_LOCATION_ID
+-- where ts.CREATED_TIME >'2025-07-01 00:00:01'
+ <!-- <where>
+ <include refid="whereCondition"/>
+ </where>-->
+ order by ts.CREATED_TIME desc
+ </select>
+
<!-- 鏂板 -->
<insert id="insertDispatchOrder" parameterType="com.ruoyi.cwgl.domain.DispatchOrder" useGeneratedKeys="true" keyProperty="id">
insert into dispatch_order
--
Gitblit v1.8.0