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