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