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