From b9e9cde65890851f4ca2d7b4809b802b88937ddf Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期三, 01 四月 2026 23:05:48 +0800
Subject: [PATCH] feat:同步状态优化
---
ruoyi-system/src/main/java/com/ruoyi/system/service/impl/LegacyTransferSyncServiceImpl.java | 2 +-
ruoyi-system/src/main/resources/mapper/system/LegacyTransferSyncMapper.xml | 9 ++++++++-
2 files changed, 9 insertions(+), 2 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/LegacyTransferSyncServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/LegacyTransferSyncServiceImpl.java
index 78d9033..997cc28 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/LegacyTransferSyncServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/LegacyTransferSyncServiceImpl.java
@@ -91,7 +91,7 @@
String endDateStr = DateUtils.parseDateToStr("yyyy-MM-dd", new Date());
// Keyset娓告爣鍒嗛〉浠� SQL Server 鎷夊彇杞繍鍗曟暟鎹紝姣忛〉 10 鏉★紝璧颁富閿储寮曞交搴曡閬胯秴鏃�
- final int PAGE_SIZE = 10;
+ final int PAGE_SIZE = 5;
long lastId = 0L; // 娓告爣锛氳褰曚笂涓�椤垫渶鍚庝竴鏉＄殑 ServiceOrdID锛岄娆′紶 0
int successCount = 0;
diff --git a/ruoyi-system/src/main/resources/mapper/system/LegacyTransferSyncMapper.xml b/ruoyi-system/src/main/resources/mapper/system/LegacyTransferSyncMapper.xml
index 7c66e74..6dbccfb 100644
--- a/ruoyi-system/src/main/resources/mapper/system/LegacyTransferSyncMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/LegacyTransferSyncMapper.xml
@@ -105,7 +105,14 @@
b.DispatchOrdNo,
b.DispatchOrdClass
FROM ServiceOrder AS a
- LEFT JOIN DispatchOrd b ON a.ServiceOrdID = b.ServiceOrdIDDt
+ OUTER APPLY (
+ SELECT TOP 1
+ DispatchOrd_NS_Time, DispatchOrdTraStreet, DispatchOrdStartDate,
+ DispatchOrdActualDate, DispatchOrdReturnDate, DispatchOrdTraEnd,
+ DispatchOrdState, DispatchOrdID, DispatchOrdCarID, DispatchOrdNo, DispatchOrdClass
+ FROM DispatchOrd b
+ WHERE b.ServiceOrdIDDt = a.ServiceOrdID
+ ) b
WHERE a.ServiceOrdState <= 3
AND a.ServiceOrd_CC_Time between #{startDate} and #{endDate}
AND a.ServiceOrdID > #{lastId}
--
Gitblit v1.9.1