From 44a4cf6610d7227c83b5f5f1cf661b75ebbd42a3 Mon Sep 17 00:00:00 2001
From: pjb <pjb123456>
Date: 星期日, 10 八月 2025 14:31:55 +0800
Subject: [PATCH] 判断没在罐装线里空桶数量
---
src/main/resources/mapper/WrkMastMapper.xml | 20 +++++++-------------
1 files changed, 7 insertions(+), 13 deletions(-)
diff --git a/src/main/resources/mapper/WrkMastMapper.xml b/src/main/resources/mapper/WrkMastMapper.xml
index cd03793..890883e 100644
--- a/src/main/resources/mapper/WrkMastMapper.xml
+++ b/src/main/resources/mapper/WrkMastMapper.xml
@@ -165,19 +165,13 @@
select wrk_no wrkNo,ctn_type ctnType,Pdc_type pdcType,loc_no locNo from asr_wrk_mast where sta_no = 1050 and wrk_sts in(2,9,10) order by io_time desc
</select>
<select id="selectInGzxCount" resultType="java.lang.Integer">
- SELECT
- count(DISTINCT m.wrk_no)
- FROM
- asr_wrk_mast m
- LEFT JOIN asr_bas_devp d ON
- m.wrk_no = d.wrk_no
- WHERE
- (m.wrk_sts IN (2, 9 ,10,14)
- AND m.sta_no = #{site}
- AND d.wrk_no IS NOT NULL)
- OR (m.wrk_sts IN(10,11,12,14)
- AND m.sta_no = #{site}
- AND d.wrk_no IS NULL)
+ select
+ count(*)
+ from
+ asr_wrk_mast m
+ where
+ m.sta_no = #{site}
+ and (m.whs_type is null or EXISTS (select 1 from asr_bas_devp d where d.wrk_no = m.wrk_no))
</select>
</mapper>
--
Gitblit v1.9.1