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