From e6b9b8f2264cfa75fd87049c9b9217d6d1bc69c7 Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@63.com> Date: 星期四, 01 九月 2022 12:59:58 +0800 Subject: [PATCH] # --- src/main/resources/mapper/LocDetlMapper.xml | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml index 085db6c..60a5ffa 100644 --- a/src/main/resources/mapper/LocDetlMapper.xml +++ b/src/main/resources/mapper/LocDetlMapper.xml @@ -200,7 +200,7 @@ select no = 1, b.bay1 as bay, - count(1) as count + sum(anfme) as count from asr_loc_detl a left join asr_loc_mast b on a.loc_no = b.loc_no where 1=1 @@ -213,7 +213,7 @@ select no = 2, b.bay1, - count(1) as count + sum(anfme) as count from asr_loc_detl a left join asr_loc_mast b on a.loc_no = b.loc_no where 1=1 @@ -240,6 +240,7 @@ and b.row1 >= 18 and b.row1 <= 30 </if> + and a.matnr = #{matnr} and b.bay1 = #{bay} and b.loc_sts = 'F' order by b.row1 asc -- Gitblit v1.9.1