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 &lt;= 30
         </if>
+        and a.matnr = #{matnr}
         and b.bay1 = #{bay}
         and b.loc_sts = 'F'
         order by b.row1 asc

--
Gitblit v1.9.1