From 9e3add37778b45bc28bb932ceaa23bba3ff2810a Mon Sep 17 00:00:00 2001 From: zjj <3272660260@qq.com> Date: 星期二, 20 六月 2023 09:11:28 +0800 Subject: [PATCH] #平库库存数量问题优化 --- src/main/resources/mapper/ManLocDetlMapper.xml | 8 +++----- 1 files changed, 3 insertions(+), 5 deletions(-) diff --git a/src/main/resources/mapper/ManLocDetlMapper.xml b/src/main/resources/mapper/ManLocDetlMapper.xml index 985cd8b..e1fef14 100644 --- a/src/main/resources/mapper/ManLocDetlMapper.xml +++ b/src/main/resources/mapper/ManLocDetlMapper.xml @@ -77,7 +77,7 @@ </if> </sql> - <select id="listByPage" resultMap="BaseResultMap"> + <select id="listByPage" resultMap="BaseResultMap" parameterType="java.util.Map"> select * from ( SELECT @@ -88,8 +88,7 @@ LEFT JOIN man_mat mm ON mld.matnr = mm.matnr LEFT JOIN man_tag mt ON mm.tag_id = mt.id WHERE 1=1 - AND (CHARINDEX(','+#{node_id}+',', ','+mn.path+',') > 0 OR mn.id = #{node_id}) - AND (CHARINDEX(','+#{tag_id}+',', ','+mt.path+',') > 0 OR mt.id = #{tag_id}) + AND (CHARINDEX(#{node_id}, mn.path) > 0 OR mn.id = #{node_id}) <include refid="locDetlCondition"></include> ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize}) </select> @@ -102,8 +101,7 @@ LEFT JOIN man_mat mm ON mld.matnr = mm.matnr LEFT JOIN man_tag mt ON mm.tag_id = mt.id WHERE 1=1 - AND (CHARINDEX(','+#{node_id}+',', ','+mn.path+',') > 0 OR mn.id = #{node_id}) - AND (CHARINDEX(','+#{tag_id}+',', ','+mt.path+',') > 0 OR mt.id = #{tag_id}) + AND (CHARINDEX(#{node_id}, mn.path) > 0 OR mn.id = #{node_id}) <include refid="locDetlCondition"></include> </select> -- Gitblit v1.9.1