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