From f12dd0abab057e18d0e138983b280097bbfd9a6b Mon Sep 17 00:00:00 2001
From: zhangc <zc@123>
Date: 星期一, 13 一月 2025 16:07:21 +0800
Subject: [PATCH] 优化订单同步逻辑及库位查找

---
 src/main/resources/mapper/ViewStayTimeMapper.xml |   12 ++++++------
 1 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/src/main/resources/mapper/ViewStayTimeMapper.xml b/src/main/resources/mapper/ViewStayTimeMapper.xml
index a06ccd4..5965dc3 100644
--- a/src/main/resources/mapper/ViewStayTimeMapper.xml
+++ b/src/main/resources/mapper/ViewStayTimeMapper.xml
@@ -183,12 +183,12 @@
 		(
 			SELECT
 			GETDATE() AS today
-			, CONVERT(decimal, DATEDIFF(second,asr_loc_detl.appe_time, GETDATE()) / 86400.0, 9) AS stay_time
-			, dbo.asr_loc_detl.*
-			FROM asr_loc_detl
-			INNER JOIN asr_loc_mast ON asr_loc_detl.loc_no = asr_loc_mast.loc_no
+			, CONVERT(decimal, DATEDIFF(second,all_loc_detl.appe_time, GETDATE()) / 86400.0, 9) AS stay_time
+			, dbo.all_loc_detl.*
+			FROM all_loc_detl
+			INNER JOIN agv_loc_mast ON all_loc_detl.loc_no = agv_loc_mast.loc_no
 			where 1=1
-			<include refid="viewStayTimeConditionSql"></include>
+			<include refid="viewStayTimeConditionSql2"></include>
 		) t
 	) a
 </select>
@@ -210,7 +210,7 @@
 					FROM
 						all_loc_detl
 					where 1=1
-					<include refid="viewStayTimeConditionSql"></include>
+					<include refid="viewStayTimeConditionSql2"></include>
 				) t
 		) a
 </select>

--
Gitblit v1.9.1