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