From f5f7804cd9856e70c7678121a63e11320adf81c5 Mon Sep 17 00:00:00 2001
From: huangjiayang <5265313@qq.com>
Date: 星期六, 10 五月 2025 15:51:48 +0800
Subject: [PATCH] 【UPDATE】同步数据任务增加批次号记录
---
aps-modules/aps-job/src/main/resources/mapper/job/ApsBomHeaderJobMapper.xml | 4 ++++
aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteHeaderJobMapper.xml | 4 ++++
aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteLineJobMapper.xml | 4 ++++
aps-modules/aps-job/src/main/resources/mapper/job/ApsMaterialStorageManagementJobMapper.xml | 4 ++++
aps-modules/aps-job/src/main/resources/mapper/job/ApsBomLineJobMapper.xml | 4 ++++
5 files changed, 20 insertions(+), 0 deletions(-)
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/ApsBomHeaderJobMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/ApsBomHeaderJobMapper.xml
index 1f527b8..1e0e925 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/ApsBomHeaderJobMapper.xml
+++ b/aps-modules/aps-job/src/main/resources/mapper/job/ApsBomHeaderJobMapper.xml
@@ -110,6 +110,7 @@
start_date,
end_date,
org_code,
+ create_by,
create_time
) VALUES
<foreach collection="list" item="item" separator=",">
@@ -121,6 +122,7 @@
#{item.startDate},
#{item.endDate},
#{item.orgCode},
+ #{item.createBy},
now()
)
</foreach>
@@ -136,6 +138,7 @@
start_date,
end_date,
org_code,
+ create_by,
create_time
)
SELECT
@@ -146,6 +149,7 @@
start_date,
end_date,
org_code,
+ create_by,
now()
FROM aps_bom_header_job
</insert>
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/ApsBomLineJobMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/ApsBomLineJobMapper.xml
index 84e470b..be153bf 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/ApsBomLineJobMapper.xml
+++ b/aps-modules/aps-job/src/main/resources/mapper/job/ApsBomLineJobMapper.xml
@@ -152,6 +152,7 @@
end_date,
org_code,
num,
+ create_by,
create_time
) VALUES
<foreach collection="list" item="item" separator=",">
@@ -165,6 +166,7 @@
#{item.endDate},
#{item.orgCode},
#{item.num},
+ #{item.createBy},
now()
)
</foreach>
@@ -182,6 +184,7 @@
end_date,
org_code,
num,
+ create_by,
create_time
)
SELECT
@@ -194,6 +197,7 @@
end_date,
org_code,
num,
+ create_by,
now()
FROM aps_bom_line_job
</insert>
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/ApsMaterialStorageManagementJobMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/ApsMaterialStorageManagementJobMapper.xml
index ce3ec29..edaba5a 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/ApsMaterialStorageManagementJobMapper.xml
+++ b/aps-modules/aps-job/src/main/resources/mapper/job/ApsMaterialStorageManagementJobMapper.xml
@@ -108,6 +108,7 @@
item_number,
num,
applicable_factories,
+ create_by,
create_time
) VALUES
<foreach collection="list" item="item" separator=",">
@@ -116,6 +117,7 @@
#{item.itemNumber},
#{item.num},
#{item.applicableFactories},
+ #{item.createBy},
now()
)
</foreach>
@@ -128,6 +130,7 @@
item_number,
num,
applicable_factories,
+ create_by,
create_time
)
SELECT
@@ -135,6 +138,7 @@
item_number,
num,
applicable_factories,
+ create_by,
now()
FROM aps_material_storage_management_job
</insert>
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteHeaderJobMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteHeaderJobMapper.xml
index 1930d0e..185c84b 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteHeaderJobMapper.xml
+++ b/aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteHeaderJobMapper.xml
@@ -120,6 +120,7 @@
start_date,
end_date,
org_code,
+ create_by,
create_time
) VALUES
<foreach collection="list" item="item" separator=",">
@@ -131,6 +132,7 @@
#{item.startDate},
#{item.endDate},
#{item.orgCode},
+ #{item.createBy},
now()
)
</foreach>
@@ -146,6 +148,7 @@
start_date,
end_date,
org_code,
+ create_by,
create_time
)
SELECT
@@ -156,6 +159,7 @@
start_date,
end_date,
org_code,
+ create_by,
now()
FROM aps_standard_process_route_header_job
</insert>
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteLineJobMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteLineJobMapper.xml
index f8f89f0..fcc081e 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteLineJobMapper.xml
+++ b/aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteLineJobMapper.xml
@@ -130,6 +130,7 @@
org_code,
shop_code,
standard_time,
+ create_by,
create_time
) VALUES
<foreach collection="list" item="item" separator=",">
@@ -144,6 +145,7 @@
#{item.orgCode},
#{item.shopCode},
#{item.standardTime},
+ #{item.createBy},
now()
)
</foreach>
@@ -162,6 +164,7 @@
org_code,
shop_code,
standard_time,
+ create_by,
create_time
)
SELECT
@@ -175,6 +178,7 @@
org_code,
shop_code,
standard_time,
+ create_by,
now()
FROM aps_standard_process_route_line_job
</insert>
--
Gitblit v1.9.3