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