From a206f3d07100ea5288a019737f58af9405edb3d2 Mon Sep 17 00:00:00 2001
From: huangjiayang <5265313@qq.com>
Date: 星期一, 12 五月 2025 19:15:44 +0800
Subject: [PATCH] 【UPDATE】钣金计划缺口报表，钣金计划冗余报表增加删除标识查询
---
aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml | 2 +-
aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireMapper.xml | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml
index b53581e..0575604 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanMapper.xml
@@ -300,7 +300,7 @@
</update>
<select id="selectPlateRedundantOrderList" parameterType="ApsPlatePlan" resultMap="ApsPlatePlanResult">
select document_number, item_number, production_quantity, unmatched_quantity, plant, production_base, plan_start_day, plan_end_day, order_create_time
- from aps_plate_plan where unmatched_quantity>0 and professional_affiliation!='0'
+ from aps_plate_plan where unmatched_quantity>0 and professional_affiliation!='0' and del_flag='0'
<if test="documentNumber != null and documentNumber != ''">
and document_number like '%' || #{documentNumber} || '%'
</if>
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireMapper.xml
index 92ccff6..9e28066 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireMapper.xml
@@ -180,7 +180,7 @@
select id, require_track_id, bom_line_code, bom_line_level,
match_state, match_mode, unmatched_demand_amount, start_date,
complete_date, demand_date, org_code, production_base
- from aps_plate_standard_require where unmatched_demand_amount>0
+ from aps_plate_standard_require where unmatched_demand_amount>0 and del_flag='0'
<if test="requireTrackId != null and requireTrackId != ''"> and require_track_id like '%' || #{requireTrackId} || '%'</if>
<if test="bomLineCode != null and bomLineCode != ''"> and bom_line_code like '%' || #{bomLineCode} || '%'</if>
</select>
--
Gitblit v1.9.3