From 0f2e16a6908f1a654284bb545e22b85b17d0e081 Mon Sep 17 00:00:00 2001
From: skyouc <958836976@qq.com>
Date: 星期六, 07 二月 2026 15:01:42 +0800
Subject: [PATCH] no message

---
 src/main/resources/mapper/LocMastMapper.xml |   22 +++++++++++++++++-----
 1 files changed, 17 insertions(+), 5 deletions(-)

diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml
index cae15d0..216d15a 100644
--- a/src/main/resources/mapper/LocMastMapper.xml
+++ b/src/main/resources/mapper/LocMastMapper.xml
@@ -83,15 +83,27 @@
         and (loc_sts = 'F' or loc_sts = 'D') and crn_no = #{crnNo}
     </select>
 
+<!--    <select id="selectLocShuttleMoveUnilateralY" resultMap="BaseResultMap">-->
+<!--        select *-->
+<!--        from [dbo].[asr_loc_mast]-->
+<!--        where 1=1-->
+<!--        and whs_type=#{whsType}-->
+<!--        and row1 > 0 and row1 &lt; 5-->
+<!--        and bay1 = #{bay}-->
+<!--        and lev1 = #{lev}-->
+<!--        and loc_sts='F'-->
+<!--        and move_status = 0-->
+<!--        order by row1-->
+<!--    </select>-->
+
     <select id="selectLocShuttleMoveUnilateralY" resultMap="BaseResultMap">
         select *
         from [dbo].[asr_loc_mast]
         where 1=1
-        and whs_type=#{whsType}
-        and row1>1 and row1 &lt; 18
-        and bay1 = #{bay}
-        and lev1 = #{lev}
-        and loc_sts='F'
+          and whs_type=#{whsType}
+          and row1 > 10 and row1 &lt; 15
+          and loc_sts='D'
+          and move_status = 0
         order by row1
     </select>
 

--
Gitblit v1.9.1