From 62c29c08c3b15c77879db0476d160d50716e6b89 Mon Sep 17 00:00:00 2001
From: zhanghl <253316343@qq.com>
Date: 星期三, 16 四月 2025 17:48:01 +0800
Subject: [PATCH] 焊缝统计表-确认数据问题
---
aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsWeldSeamMapper.java | 1 +
aps-modules/aps-core/src/main/resources/mapper/core/ApsWeldSeamMapper.xml | 5 ++++-
2 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsWeldSeamMapper.java b/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsWeldSeamMapper.java
index 11e6cb0..94fb238 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsWeldSeamMapper.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/mapper/ApsWeldSeamMapper.java
@@ -71,4 +71,5 @@
public int deleteApsWeldSeamByIds(String[] ids);
List<ApsWeldSeamStatistics> weldSeamStat(List<ApsWeldSeamTemp> apsWeldSeamTemps);
+ int removeLastBatch();
}
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsWeldSeamMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsWeldSeamMapper.xml
index 453ae4d..d41ffe4 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsWeldSeamMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsWeldSeamMapper.xml
@@ -160,7 +160,10 @@
work_order_type as workOrderType,
classification,
sum(total_weld_seam) as total
- FROM aps_weld_seam
+ FROM aps_weld_seam where del_flag='0'
GROUP BY produce_year, produce_month, production_base, work_order_type, classification
</select>
+ <update id="removeLastBatch" parameterType="String">
+ update aps_weld_seam set del_flag='1' where del_flag='0'
+ </update>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3