【UPDATE】钣金计划缺口报表，钣金计划冗余报表增加删除标识查询

huangjiayang

2025-05-12 a206f3d07100ea5288a019737f58af9405edb3d2

【UPDATE】钣金计划缺口报表，钣金计划冗余报表增加删除标识查询

 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>

 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>