huangjiayang
2025-05-13 ce34bb17c5e41f13b170ad9fa7e580030f0ec63c
【UPDATE】钣金工单计划新增字段
已修改2个文件
9 ■■■■ 文件已修改
aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java
@@ -304,6 +304,9 @@
                order.setOpStatus(jsonObject.getString("OpStatus"));
                order.setNextOpName(jsonObject.getString("NextOpName"));
                order.setLowOrderCode(jsonObject.getString("LowLevelCode"));
                order.setOrderCreateTime(jsonObject.getDate("CreatedOn"));
                order.setApproveOn(jsonObject.getDate("ApproveOn"));
                order.setStartWorkDate(jsonObject.getDate("StartDatetime"));
                jobs.add(order);
                orderIds.add(order.getOrderId());
            } catch (Exception e) {
aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml
@@ -407,7 +407,7 @@
            plan_start_day,plan_end_day,next_process_deparment,
            is_suspended,is_outsourcing,account,
            id,create_time,del_flag,plant,order_status,std_op,op_status,next_op_name,
            professional_affiliation,order_create_time
            professional_affiliation,order_create_time,approve_on,start_work_date
        )
        select
            doc_no,mainitem_code,mainitem_figure,
@@ -419,7 +419,9 @@
            is_hold_release,is_out_source,org_code,
            cast(order_id as bigint) as id,now(),'0',org_code,doc_status,std_op,op_status,next_op_name,
            (case when low_order_code='0' then 'main' else 'sub' end ) as professional_affiliation,
            order_create_time
            order_create_time,
            approve_on,
            start_work_date
        from aps_work_order_job
        where ( doc_status in (0,1,2,4) and is_hold_release='0'
                and (item_code like 'M03%' or item_code like 'M04%'or item_code like 'A75%')