From c7b6fb8f2303e4a35f92b18c1f2ef664dabb4905 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期二, 10 三月 2026 17:59:08 +0800
Subject: [PATCH] feat: 添加同步记录,手动与自动不能同时拉取数据

---
 src/main/java/com/ruoyi/productionPlan/pojo/ProductionPlan.java                    |    5 
 src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java |  322 +++++++++++++++++++++++++++++++++--------------------
 doc/宁夏-中盛建材.sql                                                                    |   15 --
 src/main/resources/mapper/productionPlan/ProductionPlanMapper.xml                  |    1 
 src/main/java/com/ruoyi/productionPlan/task/ProductionPlanTask.java                |   17 ++
 5 files changed, 223 insertions(+), 137 deletions(-)

diff --git "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
index 0c8b704..1cb4a4f 100644
--- "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
+++ "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
@@ -3,44 +3,32 @@
 CREATE TABLE production_plan
 (
     id                 BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '涓婚敭',
-
     form_instance_id   VARCHAR(64) COMMENT '琛ㄥ崟瀹炰緥ID',
     serial_no          VARCHAR(50) COMMENT '娴佹按鍙�',
-
     apply_no           VARCHAR(100) COMMENT '鐢宠鍗曠紪鍙�',
     customer_name      VARCHAR(200) COMMENT '瀹㈡埛鍚嶇О',
-
     material_code      VARCHAR(100) COMMENT '鐗╂枡缂栫爜',
     product_name       VARCHAR(200) COMMENT '浜у搧鍚嶇О',
     product_spec       VARCHAR(200) COMMENT '浜у搧瑙勬牸',
-
     length             INT COMMENT '闀�',
     width              INT COMMENT '瀹�',
     height             INT COMMENT '楂�',
-
     quantity           INT COMMENT '鍧楁暟',
+    total_count        INT COMMENT '姝ゆ缁熻鏁伴噺',
     volume             DECIMAL(10, 4) COMMENT '鏂规暟',
-
     strength           VARCHAR(50) COMMENT '寮哄害',
-
     start_date         DATETIME COMMENT '寮�濮嬫棩鏈�',
     end_date           DATETIME COMMENT '缁撴潫鏃ユ湡',
-
     submitter          VARCHAR(100) COMMENT '鎻愪氦浜�',
     submit_org         VARCHAR(200) COMMENT '鎻愪氦浜虹粍缁�',
-
     remark_one         TEXT COMMENT '澶囨敞1',
     remark_two         TEXT COMMENT '澶囨敞2',
-
     creator_name       VARCHAR(100) COMMENT '鍒涘缓浜�',
     modifier_name      VARCHAR(100) COMMENT '淇敼浜�',
-
     form_created_time  DATETIME COMMENT '琛ㄥ崟鍒涘缓鏃堕棿',
     form_modified_time DATETIME COMMENT '琛ㄥ崟淇敼鏃堕棿',
-
     data_sync_type     TINYINT  DEFAULT 1 COMMENT '鏁版嵁鍚屾绫诲瀷锛�1=鎵嬪姩 2=瀹氭椂浠诲姟',
     data_source_type   TINYINT  DEFAULT 1 COMMENT '鏁版嵁鏉ユ簮绫诲瀷锛�1=閿�鍞鍗� 2=閿�鍞娴�',
-
     create_time        DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '鏁版嵁搴撳垱寤烘椂闂�',
     update_time        DATETIME COMMENT '鏁版嵁搴撴洿鏂版椂闂�',
 
@@ -48,7 +36,6 @@
     INDEX idx_serial_no (serial_no),
     INDEX idx_form_instance_id (form_instance_id),
     INDEX idx_material_code (material_code)
-
 ) ENGINE = InnoDB
   DEFAULT CHARSET = utf8mb4 COMMENT ='閿�鍞敓浜ц鍒�';
 
diff --git a/src/main/java/com/ruoyi/productionPlan/pojo/ProductionPlan.java b/src/main/java/com/ruoyi/productionPlan/pojo/ProductionPlan.java
index 9de571a..45bbda3 100644
--- a/src/main/java/com/ruoyi/productionPlan/pojo/ProductionPlan.java
+++ b/src/main/java/com/ruoyi/productionPlan/pojo/ProductionPlan.java
@@ -168,4 +168,9 @@
      */
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
     private LocalDateTime updateTime;
+
+    /**
+     * 褰撳墠鏇存柊鏁伴噺
+     */
+    private Integer totalCount;
 }
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java b/src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java
index 9911a70..9cdd367 100644
--- a/src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java
+++ b/src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java
@@ -3,6 +3,7 @@
 import com.alibaba.fastjson2.JSON;
 import com.alibaba.fastjson2.JSONArray;
 import com.alibaba.fastjson2.JSONObject;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
@@ -23,9 +24,11 @@
 import java.time.LocalDateTime;
 import java.time.OffsetDateTime;
 import java.time.ZoneId;
+import java.time.format.DateTimeFormatter;
 import java.time.format.DateTimeParseException;
 import java.util.ArrayList;
 import java.util.List;
+import java.util.concurrent.locks.ReentrantLock;
 
 /**
  * <br>
@@ -46,6 +49,11 @@
 
     @Autowired
     private ProductionPlanMapper productionPlanMapper;
+
+    /**
+     * 鍚屾閿侊紝纭繚鎵嬪姩鍜屽畾鏃朵换鍔′笉鍚屾椂鎵ц
+     */
+    private final ReentrantLock syncLock = new ReentrantLock();
 
     @Override
     public IPage<ProductionPlanDto> listPage(Page page, ProductionPlanDto productionPlanDto) {
@@ -73,146 +81,214 @@
      */
     @Transactional(rollbackFor = Exception.class)
     public void syncProdData(Integer dataSyncType) {
+        if (!syncLock.tryLock()) {
+            log.warn("鍚屾姝e湪杩涜涓紝鏈 {} 鍚屾璇锋眰琚烦杩�", dataSyncType == 1 ? "鎵嬪姩" : "瀹氭椂浠诲姟");
+            return;
+        }
+
         try {
-            //  鑾峰彇AccessToken
-            String params = "appkey=" + aliDingConfig.getAppKey()
-                    + "&appsecret=" + aliDingConfig.getAppSecret();
-
-            String tokenRes = HttpUtils.sendGet(aliDingConfig.getAccessTokenUrl(), params);
-
-            JSONObject tokenObj = JSON.parseObject(tokenRes);
-
-            String accessToken = tokenObj.getString("access_token");
+            //  鑾峰彇 AccessToken
+            String accessToken = getAccessToken();
             if (StringUtils.isEmpty(accessToken)) {
-                log.error("鑾峰彇閽夐拤AccessToken澶辫触: {}", tokenRes);
                 return;
             }
 
-            log.info("鑾峰彇AccessToken鎴愬姛: {}", accessToken);
+            //  鑾峰彇鏈湴鏈�鍚庡悓姝ユ椂闂�
+            LocalDateTime lastSyncTime = getLastSyncTime();
+            log.info("寮�濮嬪閲忓悓姝ワ紝鏈湴鏈�鍚庝慨鏀规椂闂�: {}", lastSyncTime);
 
-            //  鏌ヨ琛ㄥ崟鏁版嵁
-            JSONObject searchParam = new JSONObject();
-            searchParam.put("appType", aliDingConfig.getAppType());
-            searchParam.put("systemToken", aliDingConfig.getSystemToken());
-            searchParam.put("userId", aliDingConfig.getUserId());
-            searchParam.put("formUuid", aliDingConfig.getFormUuid());
+            int pageNumber = 1;
+            int pageSize = 50;
+            boolean hasMore = true;
+            int totalSynced = 0;
 
-            String dataRes = HttpUtils.sendPostJson(
-                    aliDingConfig.getSearchFormDataUrl(),
-                    searchParam.toJSONString(),
-                    StandardCharsets.UTF_8.name(),
-                    null,
-                    accessToken
-            );
+            while (hasMore) {
+                //  鏌ヨ鍙傛暟
+                JSONObject searchParam = buildSearchParam(lastSyncTime, pageNumber, pageSize);
 
-            if (StringUtils.isEmpty(dataRes)) {
-                log.error("鎷夊彇瀹滄惌鏁版嵁涓虹┖");
-                return;
-            }
+                //  璋冪敤瀹滄惌鎺ュ彛鎷夊彇鏁版嵁
+                String dataRes = HttpUtils.sendPostJson(
+                        aliDingConfig.getSearchFormDataUrl(),
+                        searchParam.toJSONString(),
+                        StandardCharsets.UTF_8.name(),
+                        null,
+                        accessToken
+                );
 
-            JSONObject resultObj = JSON.parseObject(dataRes);
-            JSONArray dataArr = resultObj.getJSONArray("data");
-
-            if (dataArr == null || dataArr.isEmpty()) {
-                log.warn("娌℃湁鑾峰彇鍒拌〃鍗曟暟鎹�");
-                return;
-            }
-
-            List<ProductionPlan> list = new ArrayList<>();
-
-            //  瑙f瀽琛ㄥ崟
-            for (int i = 0; i < dataArr.size(); i++) {
-
-                JSONObject item = dataArr.getJSONObject(i);
-
-                String formInstanceId = item.getString("formInstanceId");
-                String serialNo = item.getString("serialNo");
-                // 鍙戣捣浜�
-                JSONObject originator = item.getJSONObject("originator");
-                String originatorName = originator.getJSONObject("userName").getString("nameInChinese");
-
-                JSONObject formData = item.getJSONObject("formData");
-                // 鏄庣粏琛�
-                JSONArray tableArr = formData.getJSONArray("tableField_l7fytfcn");
-                if (tableArr == null || tableArr.isEmpty()) {
-                    continue;
+                if (StringUtils.isEmpty(dataRes)) {
+                    log.warn("绗� {} 椤垫媺鍙栨暟鎹负绌�", pageNumber);
+                    break;
                 }
 
-                //  瑙f瀽鏄庣粏
-                for (int j = 0; j < tableArr.size(); j++) {
-                    JSONObject row = tableArr.getJSONObject(j);
-                    ProductionPlan plan = new ProductionPlan();
+                JSONObject resultObj = JSON.parseObject(dataRes);
+                JSONArray dataArr = resultObj.getJSONArray("data");
+                Integer totalCount = resultObj.getInteger("totalCount");
 
-                    // 琛ㄥ崟淇℃伅
-                    plan.setFormInstanceId(formInstanceId);
-                    plan.setSerialNo(serialNo);
-
-                    // 琛ㄥご瀛楁
-                    plan.setApplyNo(formData.getString("textField_l7fytfco"));
-                    plan.setCustomerName(formData.getString("textField_lbkozohg"));
-
-                    // 鏄庣粏瀛楁
-                    plan.setMaterialCode(row.getString("textField_l9xo62q5"));
-                    plan.setProductName(row.getString("textField_l9xo62q7"));
-                    plan.setProductSpec(row.getString("textField_l9xo62q8"));
-                    plan.setLength(row.getInteger("numberField_lb7lgatg_value"));
-                    plan.setWidth(row.getInteger("numberField_lb7lgath_value"));
-                    plan.setHeight(row.getInteger("numberField_lb7lgati_value"));
-                    plan.setQuantity(row.getInteger("numberField_lb7lgatj_value"));
-                    plan.setVolume(row.getBigDecimal("numberField_l7fytfd3_value"));
-                    plan.setStrength(row.getString("radioField_m9urarr2_id"));
-
-                    // 鏃ユ湡鍖洪棿
-                    JSONArray dateArr = row.getJSONArray("cascadeDateField_lfxqqluw");
-
-                    if (dateArr != null && dateArr.size() == 2) {
-                        long start = Long.parseLong(dateArr.getString(0));
-                        long end = Long.parseLong(dateArr.getString(1));
-
-                        plan.setStartDate(Instant.ofEpochMilli(start)
-                                .atZone(ZoneId.systemDefault())
-                                .toLocalDateTime());
-
-                        plan.setEndDate(Instant.ofEpochMilli(end)
-                                .atZone(ZoneId.systemDefault())
-                                .toLocalDateTime());
-                    }
-
-                    // 鎻愪氦浜�
-                    plan.setSubmitter(originatorName);
-                    // 缁勭粐
-                    plan.setSubmitOrg("瀹佸涓垱缁胯兘瀹炰笟闆嗗洟鏈夐檺鍏徃");
-                    // 澶囨敞
-                    plan.setRemarkOne(formData.getString("textareaField_l7fytfcy"));
-                    plan.setRemarkTwo(formData.getString("textField_l7fytfcx"));
-                    // 鍒涘缓浜�
-                    plan.setCreatorName(originatorName);
-                    // 淇敼浜�
-                    JSONObject modifyUser = item.getJSONObject("modifyUser");
-                    if (modifyUser != null) {
-                        plan.setModifierName(modifyUser.getJSONObject("userName").getString("nameInChinese"));
-                    }
-                    // 琛ㄥ崟鏃堕棿
-                    plan.setFormCreatedTime(parseUtcTime(item.getString("createdTimeGMT")));
-                    plan.setFormModifiedTime(parseUtcTime(item.getString("modifiedTimeGMT")));
-                    // 鍚屾淇℃伅
-                    plan.setDataSyncType(dataSyncType);
-                    plan.setDataSourceType(1);
-                    // 鏁版嵁搴撴椂闂�
-                    LocalDateTime now = LocalDateTime.now();
-                    plan.setCreateTime(now);
-                    plan.setUpdateTime(now);
-
-                    list.add(plan);
+                if (dataArr == null || dataArr.isEmpty()) {
+                    log.info("娌℃湁鏇村鏂版暟鎹渶瑕佸悓姝�");
+                    break;
                 }
+
+                //  瑙f瀽骞朵繚瀛樻暟鎹�
+                List<ProductionPlan> list = parseProductionPlans(dataArr, dataSyncType, totalCount);
+                if (!list.isEmpty()) {
+                    //  澶勭悊鏇存柊鎴栨柊澧�
+                    processSaveOrUpdate(list);
+                    totalSynced += list.size();
+                }
+
+                //  鍒ゆ柇鏄惁杩樻湁涓嬩竴椤�
+                hasMore = (pageNumber * pageSize) < totalCount;
+                pageNumber++;
+
+                log.info("姝e湪鍚屾绗� {} 椤碉紝褰撳墠宸插悓姝� {}/{}", pageNumber - 1, totalSynced, totalCount);
             }
 
-            if (!list.isEmpty()) {
-                saveBatch(list);
-            }
-            log.info("鐢熶骇璁″垝鍚屾瀹屾垚锛屽叡 {} 鏉�", list.size());
+            log.info("鏁版嵁鍚屾瀹屾垚锛屽叡鍚屾 {} 鏉℃暟鎹�", totalSynced);
         } catch (Exception e) {
             log.error("鍚屾鐢熶骇璁″垝寮傚父", e);
+        } finally {
+            // 閲婃斁閿�
+            syncLock.unlock();
+        }
+    }
+
+    private String getAccessToken() {
+        String params = "appkey=" + aliDingConfig.getAppKey()
+                + "&appsecret=" + aliDingConfig.getAppSecret();
+        String tokenRes = HttpUtils.sendGet(aliDingConfig.getAccessTokenUrl(), params);
+        JSONObject tokenObj = JSON.parseObject(tokenRes);
+        String accessToken = tokenObj.getString("access_token");
+        if (StringUtils.isEmpty(accessToken)) {
+            log.error("鑾峰彇閽夐拤AccessToken澶辫触: {}", tokenRes);
+        }
+        return accessToken;
+    }
+
+    private LocalDateTime getLastSyncTime() {
+        // 鏌ヨ鏈湴鏁版嵁搴撲腑 formModifiedTime 鏈�澶х殑璁板綍
+        LambdaQueryWrapper<ProductionPlan> queryWrapper = new LambdaQueryWrapper<>();
+        queryWrapper.orderByDesc(ProductionPlan::getFormModifiedTime).last("LIMIT 1");
+        ProductionPlan lastRecord = this.getOne(queryWrapper);
+        return lastRecord != null ? lastRecord.getFormModifiedTime() : null;
+    }
+
+    private JSONObject buildSearchParam(LocalDateTime lastSyncTime, int pageNumber, int pageSize) {
+        JSONObject searchParam = new JSONObject();
+        searchParam.put("appType", aliDingConfig.getAppType());
+        searchParam.put("systemToken", aliDingConfig.getSystemToken());
+        searchParam.put("userId", aliDingConfig.getUserId());
+        searchParam.put("formUuid", aliDingConfig.getFormUuid());
+        searchParam.put("pageSize", pageSize);
+        searchParam.put("pageNumber", pageNumber);
+
+        // 榛樿鎸変慨鏀规椂闂村崌搴忔帓搴忥紝纭繚鍒嗛〉鎷夊彇鏁版嵁鐨勮繛缁��
+        // "+" 琛ㄧず鍗囧簭锛�"gmt_modified" 鏄畼鏂瑰唴缃瓧娈�
+        searchParam.put("orderConfigJson", "{\"gmt_modified\":\"+\"}");
+
+        // 璁剧疆淇敼鏃堕棿绛涢�夊尯闂� (鏍煎紡蹇呴』涓簓yyy-MM-dd HH:mm:ss)
+        if (lastSyncTime != null) {
+            // 璧峰鏃堕棿锛氫笂娆″悓姝ュ埌鐨勬渶鍚庝竴鏉℃暟鎹殑淇敼鏃堕棿
+            String startTime = lastSyncTime.plusSeconds(1).atZone(ZoneId.systemDefault())
+                    .format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
+            searchParam.put("modifiedFromTimeGMT", startTime);
+        }
+
+        // 鎴鏃堕棿锛氬綋鍓嶆椂闂达紝纭繚鑾峰彇鏈�鏂扮殑宸蹭慨鏀�/宸叉柊澧炴暟鎹�
+        String endTime = LocalDateTime.now().atZone(ZoneId.systemDefault())
+                .format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
+        searchParam.put("modifiedToTimeGMT", endTime);
+
+        return searchParam;
+    }
+
+    private List<ProductionPlan> parseProductionPlans(JSONArray dataArr, Integer dataSyncType, Integer totalCount) {
+        List<ProductionPlan> list = new ArrayList<>();
+        LocalDateTime now = LocalDateTime.now();
+
+        for (int i = 0; i < dataArr.size(); i++) {
+            JSONObject item = dataArr.getJSONObject(i);
+            String formInstanceId = item.getString("formInstanceId");
+            String serialNo = item.getString("serialNo");
+
+            JSONObject originator = item.getJSONObject("originator");
+            String originatorName = originator != null && originator.containsKey("userName")
+                    ? originator.getJSONObject("userName").getString("nameInChinese") : "鏈煡";
+
+            JSONObject formData = item.getJSONObject("formData");
+            JSONArray tableArr = formData.getJSONArray("tableField_l7fytfcn");
+            if (tableArr == null || tableArr.isEmpty()) {
+                continue;
+            }
+
+            for (int j = 0; j < tableArr.size(); j++) {
+                JSONObject row = tableArr.getJSONObject(j);
+                ProductionPlan plan = new ProductionPlan();
+
+                plan.setFormInstanceId(formInstanceId);
+                plan.setSerialNo(serialNo);
+                plan.setApplyNo(formData.getString("textField_l7fytfco"));
+                plan.setCustomerName(formData.getString("textField_lbkozohg"));
+
+                plan.setMaterialCode(row.getString("textField_l9xo62q5"));
+                plan.setProductName(row.getString("textField_l9xo62q7"));
+                plan.setProductSpec(row.getString("textField_l9xo62q8"));
+                plan.setLength(row.getInteger("numberField_lb7lgatg_value"));
+                plan.setWidth(row.getInteger("numberField_lb7lgath_value"));
+                plan.setHeight(row.getInteger("numberField_lb7lgati_value"));
+                plan.setQuantity(row.getInteger("numberField_lb7lgatj_value"));
+                plan.setVolume(row.getBigDecimal("numberField_l7fytfd3_value"));
+                plan.setStrength(row.getString("radioField_m9urarr2_id"));
+
+                JSONArray dateArr = row.getJSONArray("cascadeDateField_lfxqqluw");
+                if (dateArr != null && dateArr.size() == 2) {
+                    try {
+                        long start = Long.parseLong(dateArr.getString(0));
+                        long end = Long.parseLong(dateArr.getString(1));
+                        plan.setStartDate(Instant.ofEpochMilli(start).atZone(ZoneId.systemDefault()).toLocalDateTime());
+                        plan.setEndDate(Instant.ofEpochMilli(end).atZone(ZoneId.systemDefault()).toLocalDateTime());
+                    } catch (Exception e) {
+                        log.warn("瑙f瀽鏃ユ湡澶辫触: {}", dateArr);
+                    }
+                }
+
+                plan.setSubmitter(originatorName);
+                plan.setSubmitOrg("瀹佸涓垱缁胯兘瀹炰笟闆嗗洟鏈夐檺鍏徃");
+                plan.setRemarkOne(formData.getString("textareaField_l7fytfcy"));
+                plan.setRemarkTwo(formData.getString("textField_l7fytfcx"));
+                plan.setCreatorName(originatorName);
+
+                JSONObject modifyUser = item.getJSONObject("modifyUser");
+                if (modifyUser != null && modifyUser.containsKey("userName")) {
+                    plan.setModifierName(modifyUser.getJSONObject("userName").getString("nameInChinese"));
+                }
+
+                plan.setFormCreatedTime(parseUtcTime(item.getString("createdTimeGMT")));
+                plan.setFormModifiedTime(parseUtcTime(item.getString("modifiedTimeGMT")));
+                plan.setDataSyncType(dataSyncType);
+                plan.setDataSourceType(1);
+                plan.setCreateTime(now);
+                plan.setUpdateTime(now);
+                plan.setTotalCount(totalCount);
+
+                list.add(plan);
+            }
+        }
+        return list;
+    }
+
+    private void processSaveOrUpdate(List<ProductionPlan> list) {
+        for (ProductionPlan plan : list) {
+            LambdaQueryWrapper<ProductionPlan> queryWrapper = new LambdaQueryWrapper<>();
+            queryWrapper.eq(ProductionPlan::getFormInstanceId, plan.getFormInstanceId())
+                    .eq(ProductionPlan::getMaterialCode, plan.getMaterialCode());
+            ProductionPlan existing = this.getOne(queryWrapper);
+            if (existing != null) {
+                plan.setId(existing.getId());
+                this.updateById(plan);
+            } else {
+                this.save(plan);
+            }
         }
     }
 
diff --git a/src/main/java/com/ruoyi/productionPlan/task/ProductionPlanTask.java b/src/main/java/com/ruoyi/productionPlan/task/ProductionPlanTask.java
index 8bbae72..4e91c43 100644
--- a/src/main/java/com/ruoyi/productionPlan/task/ProductionPlanTask.java
+++ b/src/main/java/com/ruoyi/productionPlan/task/ProductionPlanTask.java
@@ -1,5 +1,11 @@
 package com.ruoyi.productionPlan.task;
 
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.scheduling.annotation.Scheduled;
+import org.springframework.stereotype.Component;
+
+import com.ruoyi.productionPlan.service.ProductionPlanService;
+
 /**
  * <br>
  * 閿�鍞敓浜ч渶姹傚畾鏃朵换鍔�
@@ -9,5 +15,16 @@
  * @version 1.0
  * @since 2026/03/09 17:02
  */
+
+
+@Component
 public class ProductionPlanTask {
+
+    @Autowired
+    private ProductionPlanService productionPlanService;
+
+    @Scheduled(cron = "0 0 * * * ?")
+    public void syncProdDataJob() {
+        productionPlanService.syncProdDataJob();
+    }
 }
diff --git a/src/main/resources/mapper/productionPlan/ProductionPlanMapper.xml b/src/main/resources/mapper/productionPlan/ProductionPlanMapper.xml
index 22812ac..1fc9456 100644
--- a/src/main/resources/mapper/productionPlan/ProductionPlanMapper.xml
+++ b/src/main/resources/mapper/productionPlan/ProductionPlanMapper.xml
@@ -34,6 +34,7 @@
         <result property="dataSourceType" column="data_source_type"/>
         <result property="createTime" column="create_time"/>
         <result property="updateTime" column="update_time"/>
+        <result property="totalCount" column="total_count"/>
     </resultMap>
 
 

--
Gitblit v1.9.3