From 075c3d255020a1a76f3efe566fedcd479e109bec Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期日, 29 一月 2023 14:53:33 +0800
Subject: [PATCH] #

---
 src/main/resources/mapper/LocMastMapper.xml |   21 +++++++++++++++++++++
 1 files changed, 21 insertions(+), 0 deletions(-)

diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml
index 4cd1351..6068a56 100644
--- a/src/main/resources/mapper/LocMastMapper.xml
+++ b/src/main/resources/mapper/LocMastMapper.xml
@@ -146,9 +146,30 @@
                     #{item}
                 </foreach>
                 and loc_sts = 'O'
+
+                <if test="rowBeg != null">
+                    and row1 >= #{rowBeg}
+                </if>
+                <if test="rowEnd != null">
+                    and row1 &lt;= #{rowEnd}
+                </if>
+                <if test="bayBeg != null">
+                    and bay1 >= #{bayBeg}
+                </if>
+                <if test="bayEnd != null">
+                    and bay1 &lt;= #{bayEnd}
+                </if>
+                <if test="levBeg != null">
+                    and lev1 >= #{levBeg}
+                </if>
+                <if test="levEnd != null">
+                    and lev1 &lt;= #{levEnd}
+                </if>
+
                 <if test="locType1 != null">
                     and loc_type1 = #{locType1}
                 </if>
+
                 <choose>
                     <when test="inoutEveryday != null and inoutEveryday">
                         AND bay1 &lt; 11 and lev1 in (3,4)

--
Gitblit v1.9.1