From f3cf05b74840f57f632af858ee27aab1d937cab8 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期六, 14 三月 2026 11:47:23 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev_宁夏_中盛建材' into dev_宁夏_中盛建材

---
 src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java |  317 +++++++++++++++++++++-------------------------------
 1 files changed, 129 insertions(+), 188 deletions(-)

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 f0584d7..698199c 100644
--- a/src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java
+++ b/src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java
@@ -1,6 +1,5 @@
 package com.ruoyi.productionPlan.service.impl;
 
-import com.alibaba.fastjson2.JSON;
 import com.alibaba.fastjson2.JSONArray;
 import com.alibaba.fastjson2.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
@@ -12,14 +11,18 @@
 import com.ruoyi.common.exception.base.BaseException;
 import com.ruoyi.common.utils.StringUtils;
 import com.ruoyi.common.utils.bean.BeanUtils;
-import com.ruoyi.common.utils.http.HttpUtils;
 import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.framework.config.AliDingConfig;
+import com.ruoyi.framework.util.AliDingUtils;
+import com.ruoyi.production.pojo.ProductMaterialSku;
 import com.ruoyi.production.pojo.ProductOrder;
+import com.ruoyi.production.service.ProductMaterialService;
+import com.ruoyi.production.service.ProductMaterialSkuService;
 import com.ruoyi.production.service.ProductOrderService;
 import com.ruoyi.productionPlan.dto.ProductionPlanDto;
 import com.ruoyi.productionPlan.dto.ProductionPlanImportDto;
 import com.ruoyi.productionPlan.dto.ProductionPlanSummaryDto;
+import com.ruoyi.productionPlan.enums.DataSourceTypeEnum;
 import com.ruoyi.productionPlan.mapper.ProductOrderPlanMapper;
 import com.ruoyi.productionPlan.mapper.ProductionPlanMapper;
 import com.ruoyi.productionPlan.pojo.ProductOrderPlan;
@@ -33,15 +36,13 @@
 
 import javax.servlet.http.HttpServletResponse;
 import java.math.BigDecimal;
-import java.nio.charset.StandardCharsets;
-import java.time.*;
-import java.time.format.DateTimeFormatter;
-import java.time.format.DateTimeParseException;
+import java.time.Instant;
+import java.time.LocalDateTime;
+import java.time.ZoneId;
 import java.util.*;
 import java.util.concurrent.locks.ReentrantLock;
 import java.util.stream.Collectors;
 
-import static com.ruoyi.productionPlan.enums.DataSourceTypeEnum.PRODUCTION_FORECAST;
 
 /**
  * <br>
@@ -68,6 +69,12 @@
 
     @Autowired
     private ProductOrderPlanMapper productOrderPlanMapper;
+
+    @Autowired
+    private ProductMaterialSkuService productMaterialSkuService;
+
+    @Autowired
+    private ProductMaterialService productMaterialService;
 
     /**
      * 鍚屾閿侊紝纭繚鎵嬪姩鍜屽畾鏃朵换鍔′笉鍚屾椂鎵ц
@@ -106,52 +113,28 @@
         }
 
         //  鏌ヨ涓荤敓浜ц鍒�
-        List<ProductionPlan> plans = productionPlanMapper.selectBatchIds(productionPlanDto.getIds());
+        List<ProductionPlanDto> plans = productionPlanMapper.selectWithMaterialByIds(productionPlanDto.getIds());
 
         //  鏍¢獙鏄惁瀛樺湪涓嶅悓鐨勪骇鍝佸悕绉�
         String firstProductName = plans.get(0).getProductName();
-        if (plans.stream().anyMatch(p -> !p.getProductName().equals(firstProductName))) {
+        if (plans.stream().anyMatch(p -> p.getProductName() == null || !p.getProductName().equals(firstProductName))) {
             throw new BaseException("鍚堝苟澶辫触锛屽瓨鍦ㄤ笉鍚岀殑浜у搧鍚嶇О");
         }
 
         // 鏍¢獙鏄惁瀛樺湪涓嶅悓鐨勪骇鍝佽鏍�
-        String firstProductSpec = plans.get(0).getProductSpec();
-        if (plans.stream().anyMatch(p -> !p.getProductSpec().equals(firstProductSpec))) {
+        String firstProductSpec = plans.get(0).getSpecification();
+        if (plans.stream().anyMatch(p -> p.getSpecification() == null || !p.getSpecification().equals(firstProductSpec))) {
             throw new BaseException("鍚堝苟澶辫触锛屽瓨鍦ㄤ笉鍚岀殑浜у搧瑙勬牸");
         }
 
-
-        // 鍙犲姞鏂规暟
-        BigDecimal totalVolume = plans.stream()
-                .map(ProductionPlan::getVolume)
-                .filter(v -> v != null)
+        // 鍙犲姞鍓╀綑鏂规暟
+        BigDecimal totalRemainingVolume = plans.stream()
+                .map(ProductionPlan::getRemainingVolume)
+                .filter(Objects::nonNull)
                 .reduce(BigDecimal.ZERO, BigDecimal::add);
-        // 鍒ゆ柇涓嬪彂鏁伴噺鏄惁澶т簬绛変簬鏂规暟
-        if (productionPlanDto.getTotalAssignedQuantity().compareTo(totalVolume) > 0) {
-
-            log.warn("鎿嶄綔澶辫触锛屼笅鍙戞暟閲忎笉鑳藉ぇ浜庢柟鏁�");
-            return false;
-        }
-
-        // 鏍规嵁涓嬪彂鏁伴噺锛屼粠绗竴涓敓浜ц鍒掑紑濮嬪垎閰嶆柟鏁�
-        BigDecimal assignedVolume = BigDecimal.ZERO;
-        for (ProductionPlan plan : plans) {
-            BigDecimal volume = plan.getVolume();
-            if (volume == null) {
-                continue;
-            }
-
-            if (assignedVolume.add(volume).compareTo(productionPlanDto.getTotalAssignedQuantity()) >= 0) {
-                // 鏈�鍚庝竴涓鍒掞紝鍒嗛厤鍓╀綑鏂规暟
-                plan.setAssignedQuantity(productionPlanDto.getTotalAssignedQuantity().subtract(assignedVolume));
-                productionPlanMapper.updateById(plan);
-                break;
-            }
-
-            // 鍒嗛厤褰撳墠璁″垝鏂规暟
-            plan.setAssignedQuantity(volume);
-            productionPlanMapper.updateById(plan);
-            assignedVolume = assignedVolume.add(volume);
+        // 鍒ゆ柇涓嬪彂鏁伴噺鏄惁澶т簬绛変簬鍓╀綑鏂规暟
+        if (productionPlanDto.getTotalAssignedQuantity().compareTo(totalRemainingVolume) > 0) {
+            throw new BaseException("鎿嶄綔澶辫触锛屼笅鍙戞暟閲忎笉鑳藉ぇ浜庡墿浣欐柟鏁�");
         }
 
         // 鍒涘缓鐢熶骇璁㈠崟
@@ -160,11 +143,49 @@
         productOrder.setPlanCompleteTime(productionPlanDto.getPlanCompleteTime());
         productOrderService.addProductOrder(productOrder);
 
-        for (Long planId : productionPlanDto.getIds()) {
+        // 鏍规嵁涓嬪彂鏁伴噺锛屼粠绗竴涓敓浜ц鍒掑紑濮嬪垎閰嶆柟鏁�
+        BigDecimal assignedVolume = BigDecimal.ZERO;
+        for (ProductionPlan plan : plans) {
+            BigDecimal volume = plan.getVolume();
+            if (volume == null) {
+                continue;
+            }
+            // 璁$畻鍓╀綑鏂规暟
+            BigDecimal remainingVolume = plan.getRemainingVolume();
+            if (remainingVolume.compareTo(BigDecimal.ZERO) <= 0) {
+                continue;
+            }
+
             ProductOrderPlan productOrderPlan = new ProductOrderPlan();
             productOrderPlan.setProductOrderId(productOrder.getId());
-            productOrderPlan.setProductionPlanId(planId);
+            productOrderPlan.setProductionPlanId(plan.getId());
+
+            if (assignedVolume.add(remainingVolume).compareTo(productionPlanDto.getTotalAssignedQuantity()) >= 0) {
+                // 鏈�鍚庝竴涓鍒掞紝鍒嗛厤鍓╀綑鏂规暟
+                BigDecimal lastRemainingVolume = productionPlanDto.getTotalAssignedQuantity().subtract(assignedVolume);
+                plan.setStatus(1);
+                if (lastRemainingVolume.compareTo(BigDecimal.ZERO) <= 0) {
+                    plan.setStatus(2);
+                }
+                plan.setAssignedQuantity(plan.getAssignedQuantity().add(lastRemainingVolume));
+                productOrderPlan.setAssignedQuantity(lastRemainingVolume);
+                productionPlanMapper.updateById(plan);
+                productOrderPlanMapper.insert(productOrderPlan);
+                break;
+            }
+
+            // 鍒嗛厤褰撳墠璁″垝鏂规暟
+            plan.setStatus(1);
+            if (remainingVolume.compareTo(BigDecimal.ZERO) <= 0) {
+                plan.setStatus(2);
+            }
+            plan.setAssignedQuantity(plan.getAssignedQuantity().add(remainingVolume));
+            productOrderPlan.setAssignedQuantity(remainingVolume);
+            // 鏇存柊鐢熶骇璁″垝
+            productionPlanMapper.updateById(plan);
+            // 鍒涘缓鍏宠仈鍏崇郴
             productOrderPlanMapper.insert(productOrderPlan);
+            assignedVolume = assignedVolume.add(remainingVolume);
         }
         return true;
     }
@@ -172,7 +193,8 @@
     @Override
     @Transactional(rollbackFor = Exception.class)
     public boolean add(ProductionPlanDto productionPlanDto) {
-        productionPlanDto.setDataSourceType(PRODUCTION_FORECAST.getCode());
+        productionPlanDto.setDataSourceType(DataSourceTypeEnum.MANUAL.getCode());
+        productionPlanDto.setStatus(0);
         productionPlanMapper.insert(productionPlanDto);
         return true;
     }
@@ -180,6 +202,10 @@
     @Override
     @Transactional(rollbackFor = Exception.class)
     public boolean update(ProductionPlanDto productionPlanDto) {
+        // 宸蹭笅鍙戠姸鎬侊紝涓嶈兘缂栬緫
+        if (productionPlanDto.getStatus() != 0) {
+            throw new BaseException("宸蹭笅鍙戞垨閮ㄥ垎涓嬪彂鐘舵�侊紝涓嶈兘缂栬緫");
+        }
         // 鏌ヨ鏄惁鏈夊叧鑱旇鍗�
         boolean hasProductOrderPlan = productOrderPlanMapper.selectList(Wrappers.<ProductOrderPlan>lambdaQuery().eq(ProductOrderPlan::getProductionPlanId, productionPlanDto.getId())).stream().anyMatch(p -> p.getProductOrderId() != null);
         if (hasProductOrderPlan) {
@@ -196,6 +222,10 @@
     @Override
     @Transactional(rollbackFor = Exception.class)
     public boolean delete(List<Long> ids) {
+        // 濡傛灉瀛樺湪宸蹭笅鍙戠殑璁″垝锛屽垯涓嶈兘鍒犻櫎
+        if (productionPlanMapper.selectList(Wrappers.<ProductionPlan>lambdaQuery().in(ProductionPlan::getId, ids)).stream().anyMatch(p -> p.getStatus() == 1 || p.getStatus() == 2)) {
+            throw new BaseException("鍒犻櫎澶辫触锛屽瓨鍦ㄥ凡涓嬪彂鎴栭儴鍒嗕笅鍙戠殑璁″垝");
+        }
         // 濡傛灉鏈夊叧鑱旇鍗曪紝鍒欎笉鑳藉垹闄�
         if (productOrderPlanMapper.selectList(Wrappers.<ProductOrderPlan>lambdaQuery().in(ProductOrderPlan::getProductionPlanId, ids)).stream().anyMatch(p -> p.getProductOrderId() != null)) {
             throw new BaseException("鍒犻櫎澶辫触锛屽瓨鍦ㄥ叧鑱旇鍗�");
@@ -210,138 +240,46 @@
     @Transactional(rollbackFor = Exception.class)
     public void syncProdData(Integer dataSyncType) {
         if (!syncLock.tryLock()) {
-            log.warn("鍚屾姝e湪杩涜涓紝鏈 {} 鍚屾璇锋眰琚烦杩�", dataSyncType == 1 ? "鎵嬪姩" : "瀹氭椂浠诲姟");
+            log.warn("鍚屾姝e湪杩涜涓紝鏈 {} 鍚屾璇锋眰琚烦杩�", dataSyncType == 1 ? "鎵嬪姩鍚屾" : "瀹氭椂浠诲姟鍚屾");
             return;
         }
 
         try {
-            //  鑾峰彇 AccessToken
-            String accessToken = getAccessToken();
-            if (StringUtils.isEmpty(accessToken)) {
+            JSONArray searchConditions = new JSONArray();
+            JSONObject condition = new JSONObject();
+            condition.put("key", "processApprovedResult");
+            JSONArray valueArray = new JSONArray();
+            valueArray.add("agree");
+
+            condition.put("value", valueArray);
+            condition.put("type", "ARRAY");
+            condition.put("operator", "in");
+            condition.put("componentName", "SelectField");
+            searchConditions.add(condition);
+
+            String searchFieldJson = searchConditions.toJSONString();
+
+            JSONArray dataArr = AliDingUtils.getFormDataList(aliDingConfig, aliDingConfig.getProducePlanFormUuid(), searchFieldJson, this, ProductionPlan::getFormModifiedTime);
+
+            if (dataArr.isEmpty()) {
+                log.info("娌℃湁鏇村鏂版暟鎹渶瑕佸悓姝�");
                 return;
             }
 
-            //  鑾峰彇鏈湴鏈�鍚庡悓姝ユ椂闂�
-            LocalDateTime lastSyncTime = getLastSyncTime();
-            log.info("寮�濮嬪閲忓悓姝ワ紝鏈湴鏈�鍚庝慨鏀规椂闂�: {}", lastSyncTime);
-
-            int pageNumber = 1;
-            int pageSize = 50;
-            boolean hasMore = true;
-            int totalSynced = 0;
-
-            while (hasMore) {
-                //  鏌ヨ鍙傛暟
-                JSONObject searchParam = buildSearchParam(lastSyncTime, pageNumber, pageSize);
-
-                //  璋冪敤瀹滄惌鎺ュ彛鎷夊彇鏁版嵁
-                String dataRes = HttpUtils.sendPostJson(
-                        aliDingConfig.getSearchFormDataUrl(),
-                        searchParam.toJSONString(),
-                        StandardCharsets.UTF_8.name(),
-                        null,
-                        accessToken
-                );
-
-                if (StringUtils.isEmpty(dataRes)) {
-                    log.warn("绗� {} 椤垫媺鍙栨暟鎹负绌�", pageNumber);
-                    break;
-                }
-
-                JSONObject resultObj = JSON.parseObject(dataRes);
-                JSONArray dataArr = resultObj.getJSONArray("data");
-                Integer totalCount = resultObj.getInteger("totalCount");
-
-                if (dataArr == null || dataArr.isEmpty()) {
-                    log.info("娌℃湁鏇村鏂版暟鎹渶瑕佸悓姝�");
-                    break;
-                }
-
-                //  瑙f瀽骞朵繚瀛樻暟鎹�
-                List<ProductionPlan> list = parseProductionPlans(dataArr, dataSyncType, totalCount);
-                if (!list.isEmpty()) {
-                    //  澶勭悊鏇存柊鎴栨柊澧�
-                    int affected = processSaveOrUpdate(list);
-                    totalSynced += affected;
-                }
-
-                //  鍒ゆ柇鏄惁杩樻湁涓嬩竴椤�
-                hasMore = (pageNumber * pageSize) < totalCount;
-                pageNumber++;
-
-                log.info("姝e湪鍚屾绗� {} 椤碉紝褰撳墠宸插悓姝� {}/{}", pageNumber - 1, totalSynced, totalCount);
+            //  瑙f瀽骞朵繚瀛樻暟鎹�
+            List<ProductionPlan> list = parseProductionPlans(dataArr, dataSyncType, dataArr.size());
+            if (!list.isEmpty()) {
+                //  澶勭悊鏇存柊鎴栨柊澧�
+                int affected = processSaveOrUpdate(list);
+                log.info("鏁版嵁鍚屾瀹屾垚锛屽叡鍚屾 {} 鏉℃暟鎹�", affected);
             }
 
-            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.getProducePlanFormUuid());
-        searchParam.put("currentPage", pageNumber);
-        searchParam.put("pageSize", pageSize);
-
-        JSONArray searchConditions = new JSONArray();
-        JSONObject condition = new JSONObject();
-        condition.put("key", "processApprovedResult");
-        JSONArray valueArray = new JSONArray();
-        valueArray.add("agree");
-
-        condition.put("value", valueArray);
-        condition.put("type", "ARRAY");
-        condition.put("operator", "in");
-        condition.put("componentName", "SelectField");
-        searchConditions.add(condition);
-
-        searchParam.put("searchFieldJson", searchConditions.toJSONString());
-
-        // 榛樿鎸変慨鏀规椂闂村崌搴忔帓搴忥紝纭繚鍒嗛〉鎷夊彇鏁版嵁鐨勮繛缁��
-        // "+" 琛ㄧず鍗囧簭锛�"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) {
@@ -372,9 +310,17 @@
                 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"));
+                String materialCode = row.getString("textField_l9xo62q5");
+                // 鏍规嵁鐗╂枡缂栫爜鏌ヨ鐗╂枡淇℃伅琛紝鍏宠仈鐗╂枡ID
+                if (StringUtils.isNotEmpty(materialCode)) {
+                    LambdaQueryWrapper<ProductMaterialSku> skuQueryWrapper = new LambdaQueryWrapper<>();
+                    skuQueryWrapper.eq(ProductMaterialSku::getMaterialCode, materialCode);
+                    ProductMaterialSku sku = productMaterialSkuService.getOne(skuQueryWrapper);
+                    if (sku != null) {
+                        plan.setProductMaterialSkuId(sku.getId());
+                    }
+                }
+
                 plan.setLength(row.getInteger("numberField_lb7lgatg_value"));
                 plan.setWidth(row.getInteger("numberField_lb7lgath_value"));
                 plan.setHeight(row.getInteger("numberField_lb7lgati_value"));
@@ -417,10 +363,9 @@
                     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.setFormCreatedTime(AliDingUtils.parseUtcTime(item.getString("createdTimeGMT")));
+                plan.setFormModifiedTime(AliDingUtils.parseUtcTime(item.getString("modifiedTimeGMT")));
+                plan.setDataSourceType(DataSourceTypeEnum.DING_TALK.getCode());
                 plan.setCreateTime(now);
                 plan.setUpdateTime(now);
                 plan.setTotalCount(totalCount);
@@ -448,19 +393,19 @@
         //  Map (formInstanceId + materialCode)
         Map<String, ProductionPlan> existMap = new HashMap<>();
         for (ProductionPlan p : existList) {
-            String key = p.getFormInstanceId() + "_" + p.getMaterialCode();
+            String key = p.getFormInstanceId() + "_" + p.getProductMaterialSkuId();
             existMap.put(key, p);
         }
 
         //  閬嶅巻鍚屾鏁版嵁
         for (ProductionPlan plan : list) {
-            String key = plan.getFormInstanceId() + "_" + plan.getMaterialCode();
+            String key = plan.getFormInstanceId() + "_" + plan.getProductMaterialSkuId();
             ProductionPlan exist = existMap.get(key);
             if (exist == null) {
                 // 鏂板
                 this.save(plan);
                 affected++;
-                log.info("鏂板鏁版嵁 formInstanceId={}, materialCode={}", plan.getFormInstanceId(), plan.getMaterialCode());
+                log.info("鏂板鏁版嵁 formInstanceId={}, materialCode={}", plan.getFormInstanceId(), plan.getProductMaterialSkuId());
             } else {
                 // 鍒ゆ柇鏄惁闇�瑕佹洿鏂�
                 if (exist.getFormModifiedTime() == null || !exist.getFormModifiedTime().equals(plan.getFormModifiedTime())) {
@@ -468,24 +413,11 @@
                     plan.setCreateTime(exist.getCreateTime());
                     this.updateById(plan);
                     affected++;
-                    log.info("鏇存柊鏁版嵁 formInstanceId={}, materialCode={}", plan.getFormInstanceId(), plan.getMaterialCode());
+                    log.info("鏇存柊鏁版嵁 formInstanceId={}, materialCode={}", plan.getFormInstanceId(), plan.getProductMaterialSkuId());
                 }
             }
         }
         return affected;
-    }
-
-    private LocalDateTime parseUtcTime(String utcString) {
-        if (StringUtils.isEmpty(utcString)) {
-            return null;
-        }
-        try {
-            OffsetDateTime odt = OffsetDateTime.parse(utcString);
-            return odt.toLocalDateTime();
-        } catch (DateTimeParseException ex) {
-            log.warn("瑙f瀽鏃堕棿 {} 澶辫触: {}", utcString, ex.getMessage());
-            return null;
-        }
     }
 
     @Override
@@ -519,8 +451,17 @@
             entity.setAssignedQuantity(BigDecimal.ZERO);
             entity.setCreateTime(LocalDateTime.now());
             entity.setUpdateTime(LocalDateTime.now());
-            entity.setDataSourceType(2);
-            entity.setDataSyncType(1);
+            entity.setDataSourceType(DataSourceTypeEnum.DING_TALK.getCode());
+
+            // 鏍规嵁鐗╂枡缂栫爜濉厖鍏宠仈ID
+            if (StringUtils.isNotEmpty(dto.getMaterialCode())) {
+                LambdaQueryWrapper<ProductMaterialSku> skuQueryWrapper = new LambdaQueryWrapper<>();
+                skuQueryWrapper.eq(ProductMaterialSku::getMaterialCode, dto.getMaterialCode());
+                ProductMaterialSku sku = productMaterialSkuService.getOne(skuQueryWrapper);
+                if (sku != null) {
+                    entity.setProductMaterialSkuId(sku.getId());
+                }
+            }
 
             entityList.add(entity);
         }

--
Gitblit v1.9.3