From 6f0600ddb352b6d4ebe7a3d357c1415947bf41d6 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期四, 01 九月 2022 12:59:08 +0800
Subject: [PATCH] #
---
src/main/resources/mapper/LocDetlMapper.xml | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 77c406d..878278c 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
@@ -226,7 +226,7 @@
select
no = 3,
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
@@ -239,7 +239,7 @@
select
no = 4,
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
@@ -252,7 +252,7 @@
select
no = 5,
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
@@ -265,7 +265,7 @@
select
no = 6,
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
--
Gitblit v1.9.1