钣金计划大表增加“异常状态”字段

hongjli

2025-05-14 3d191e81842cf3bcd6f841fbe2fc3d451c45ef99

钣金计划大表增加“异常状态”字段

 aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateProcessStat.java

@@ -71,6 +71,9 @@
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date computePlanEndDay;

    @Excel(name = "异常状态", width = 50)
    private String exceptionStatus;

    /** 设计工时 */

    private Long designTimes;

 aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateProcessStatMapper.xml

@@ -23,12 +23,14 @@
        <result property="createBy"    column="create_by"    />
        <result property="delFlag"    column="del_flag"    />
        <result property="warning"    column="warning"    />
        <result property="exceptionStatus"    column="exception_status"    />
    </resultMap>

    <sql id="selectApsPlateProcessStatVo">
        select id, work_order_no, process_name, num, route_process_number, current_process_number, production_quantity,
               standard_time, process_total_time, process_plan_end_day,process_plan_start_day, order_plan_end_day, design_times,
               batch_number, create_by, del_flag, warning
               batch_number, create_by, del_flag, warning,
               CASE WHEN <![CDATA[ process_plan_start_day <= NOW() OR process_plan_end_day <= NOW() ]]> THEN '是' ELSE '否' END as exception_status
        from aps_plate_process_stat
    </sql>