#

luxiaotao1123

2023-01-29 075c3d255020a1a76f3efe566fedcd479e109bec

#

 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)