定时任务增加 钣金批量保存

zhanghl

2025-04-23 521cb19f79a6a05b3fbab7403956bf039820a740

定时任务增加 钣金批量保存

 aps-modules/aps-job/src/main/java/com/aps/job/controller/ApsWorkOrderJobController.java

@@ -89,4 +89,13 @@
        apsWorkOrderJobService.syncPartOrderData();
        return success();
    }
    /**
     * 同步零件工单
     * */
    @PostMapping("/batchInsertPlateOrderJob")
    public AjaxResult batchInsertPlateOrderJob()
    {
        apsWorkOrderJobService.syncPlateOrderData();
        return success();
    }
}

 aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobMapper.java

@@ -80,4 +80,13 @@
     * 批量插入零件计划工单
     * */
    int batchInsertPartPlan();

    /**
     * 批量删除钣金工单数据
     * */
    int deleteAllPlatePlan();
    /**
     * 批量插入钣金计划工单
     * */
    int batchInsertPlatePlan();
}

 aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java

@@ -75,4 +75,7 @@

    @Transactional
    void syncPartOrderData();

    @Transactional
    void syncPlateOrderData();
}

 aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java

@@ -333,4 +333,14 @@
        apsWorkOrderJobMapper.batchInsertPartPlan();
    }

    /**
     * 同步钣金工单信息
     * */
    @Transactional
    @Override
    public void syncPlateOrderData() {
        apsWorkOrderJobMapper.deleteAllPlatePlan();
        apsWorkOrderJobMapper.batchInsertPlatePlan();
    }

}

 aps-modules/aps-job/src/main/java/com/aps/job/task/RyTask.java

@@ -60,6 +60,15 @@
    }

    /**
     * 每日同步零件工单数据
     * */
    public void  syncPlateOrderData ()
    {

        iApsWorkOrderJobService.syncPlateOrderData();
    }

    /**
     * 每日同步所有工单数据
     * */
    public void syncWorkOrderData()

 aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml

@@ -322,4 +322,33 @@
             or mainitem_code like 'M14%'or mainitem_code like 'M15%' or mainitem_code like 'F%' or mainitem_code like 'Z%')
        );
    </insert>
    <delete id="deleteAllPlatePlan" >
        delete from aps_plate_plan where del_flag in ('0','1')
    </delete>
    <insert id="batchInsertPlatePlan">
        insert into aps_plate_plan
        (
            document_number,main_part_number,main_part_drawing_number,
            customer,business_type,requirement_type,
            document_status,item_number,drawing_no,
            version_number,production_quantity,good_products_quantity,
            process_number,work_center,department,
            plan_start_day,plan_end_day,next_process_deparment,
            is_suspended,is_outsourcing,account,
            id,create_time,del_flag,plant,order_status
        )
        select
            doc_no,mainitem_code,mainitem_figure,
            customer_name,business_type,demand_type,
            doc_status,item_code,item_figure,
            item_figure_version,pruduct_qty,work_qty,
            op_num,work_center,dept,
            start_date,complete_date,next_dept,
            is_hold_release,is_out_source,org_code,
            order_id,now(),'0',org_code,doc_status
        from aps_work_order_job
        where ( doc_status in (0,1,2,4)
                and (mainitem_code like 'M03%' or mainitem_code like 'M04%'or mainitem_code like 'A75%')
              );
    </insert>
</mapper>