【UPDATE】同步数据任务增加批次号记录

huangjiayang

2025-05-10 f5f7804cd9856e70c7678121a63e11320adf81c5

【UPDATE】同步数据任务增加批次号记录

 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>

 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>

 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>

 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>

 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>