From 521cb19f79a6a05b3fbab7403956bf039820a740 Mon Sep 17 00:00:00 2001
From: zhanghl <253316343@qq.com>
Date: 星期三, 23 四月 2025 10:40:19 +0800
Subject: [PATCH] 定时任务增加 钣金批量保存
---
aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java | 3 +
aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml | 29 ++++++++++++++
aps-modules/aps-job/src/main/java/com/aps/job/controller/ApsWorkOrderJobController.java | 9 ++++
aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobMapper.java | 9 ++++
aps-modules/aps-job/src/main/java/com/aps/job/task/RyTask.java | 9 ++++
aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java | 10 +++++
6 files changed, 69 insertions(+), 0 deletions(-)
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/controller/ApsWorkOrderJobController.java b/aps-modules/aps-job/src/main/java/com/aps/job/controller/ApsWorkOrderJobController.java
index f0caf2f..a776bea 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/controller/ApsWorkOrderJobController.java
+++ b/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();
+ }
}
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobMapper.java b/aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobMapper.java
index 7028ad8..b8928d1 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobMapper.java
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/mapper/ApsWorkOrderJobMapper.java
@@ -80,4 +80,13 @@
* 鎵归噺鎻掑叆闆朵欢璁″垝宸ュ崟
* */
int batchInsertPartPlan();
+
+ /**
+ * 鎵归噺鍒犻櫎閽ｉ噾宸ュ崟鏁版嵁
+ * */
+ int deleteAllPlatePlan();
+ /**
+ * 鎵归噺鎻掑叆閽ｉ噾璁″垝宸ュ崟
+ * */
+ int batchInsertPlatePlan();
}
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java b/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java
index acf7468..2189b5e 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java
+++ b/aps-modules/aps-job/src/main/java/com/aps/job/service/IApsWorkOrderJobService.java
@@ -75,4 +75,7 @@
@Transactional
void syncPartOrderData();
+
+ @Transactional
+ void syncPlateOrderData();
}
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java b/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java
index e7ef207..53fdccc 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/service/impl/ApsWorkOrderJobServiceImpl.java
+++ b/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();
+ }
+
}
diff --git a/aps-modules/aps-job/src/main/java/com/aps/job/task/RyTask.java b/aps-modules/aps-job/src/main/java/com/aps/job/task/RyTask.java
index 89b40a4..4d784b3 100644
--- a/aps-modules/aps-job/src/main/java/com/aps/job/task/RyTask.java
+++ b/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()
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml
index 3ce7c26..a4ceb8c 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml
+++ b/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>
\ No newline at end of file
--
Gitblit v1.9.3