From 932b89aff065d3e7a6da133f5f70d828e7e14c0f Mon Sep 17 00:00:00 2001
From: pjb <pjb123456>
Date: 星期五, 04 七月 2025 18:08:32 +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 8efb41d..b34945b 100644
--- a/src/main/resources/mapper/WrkMastMapper.xml
+++ b/src/main/resources/mapper/WrkMastMapper.xml
@@ -69,19 +69,13 @@
</resultMap>
<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>
<select id="selectByLocNo" resultMap="BaseResultMap">
--
Gitblit v1.9.1