From 2d94ddd240fca69ebbc4b0570abb30c803db7754 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期五, 13 三月 2026 11:33:44 +0800
Subject: [PATCH] fix: 区分基础数据与生产计划数据查询

---
 src/main/java/com/ruoyi/production/service/ProductMaterialService.java          |    2 
 src/main/java/com/ruoyi/production/service/impl/ProductMaterialServiceImpl.java |  424 ++++++++++++++++++++++------------------------------
 src/main/java/com/ruoyi/production/controller/ProductMaterialController.java    |    4 
 3 files changed, 182 insertions(+), 248 deletions(-)

diff --git a/src/main/java/com/ruoyi/production/controller/ProductMaterialController.java b/src/main/java/com/ruoyi/production/controller/ProductMaterialController.java
index 82acc3e..2c27907 100644
--- a/src/main/java/com/ruoyi/production/controller/ProductMaterialController.java
+++ b/src/main/java/com/ruoyi/production/controller/ProductMaterialController.java
@@ -45,8 +45,8 @@
     @GetMapping("/list")
     @ApiOperation("鐗╂枡鏁版嵁绫诲埆鏁版嵁闆嗗悎")
     @Log(title = "鐗╂枡鏁版嵁绫诲埆鏁版嵁闆嗗悎", businessType = BusinessType.OTHER)
-    public AjaxResult productMaterialList() {
-        List<ProductMaterialGroupDto> productMaterialMap = productMaterialService.ProductMaterialList();
+    public AjaxResult productMaterialList(@RequestParam("type") Integer type) {
+        List<ProductMaterialGroupDto> productMaterialMap = productMaterialService.ProductMaterialList(type);
         return AjaxResult.success(productMaterialMap);
     }
 
diff --git a/src/main/java/com/ruoyi/production/service/ProductMaterialService.java b/src/main/java/com/ruoyi/production/service/ProductMaterialService.java
index 14098c6..75a32cc 100644
--- a/src/main/java/com/ruoyi/production/service/ProductMaterialService.java
+++ b/src/main/java/com/ruoyi/production/service/ProductMaterialService.java
@@ -21,7 +21,7 @@
 
     void syncProductMaterialJob();
 
-    List<ProductMaterialGroupDto> ProductMaterialList();
+    List<ProductMaterialGroupDto> ProductMaterialList(Integer type);
 
     void addProductMaterial(ProductMaterial productMaterial);
 
diff --git a/src/main/java/com/ruoyi/production/service/impl/ProductMaterialServiceImpl.java b/src/main/java/com/ruoyi/production/service/impl/ProductMaterialServiceImpl.java
index 154f7d4..6446f4e 100644
--- a/src/main/java/com/ruoyi/production/service/impl/ProductMaterialServiceImpl.java
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductMaterialServiceImpl.java
@@ -58,9 +58,15 @@
     private ProductMaterialSkuService productMaterialSkuService;
 
     /**
-     * 鍚屾閿侊紝闃叉鎵嬪姩鍜屽畾鏃朵换鍔″悓鏃舵墽琛�
+     * 鍚屾閿�
      */
     private final ReentrantLock syncLock = new ReentrantLock();
+
+    /**
+     * config缂撳瓨
+     */
+    private final Map<String, Integer> configCache = new HashMap<>();
+
 
     @Override
     @Transactional(rollbackFor = Exception.class)
@@ -75,345 +81,226 @@
     }
 
     /**
-     * 鍚屾鏁版嵁
+     * 鍚屾鐗╂枡鏁版嵁
      */
     @Transactional(rollbackFor = Exception.class)
-    public void syncProductMaterialData(Integer dataSyncType) {
+    public void syncProductMaterialData(Integer syncType) {
         if (!syncLock.tryLock()) {
-            log.warn("鍚屾姝e湪杩涜涓紝鏈 {} 鍚屾璇锋眰琚烦杩�", dataSyncType == 1 ? "鎵嬪姩" : "瀹氭椂浠诲姟");
+            log.warn("鍚屾浠诲姟姝e湪鎵ц锛屾湰娆¤姹傝烦杩�");
             return;
         }
-
         try {
-            // 鑾峰彇 AccessToken
             String accessToken = getAccessToken();
             if (StringUtils.isEmpty(accessToken)) {
                 return;
             }
-
-            // 鑾峰彇鏈湴鏈�鍚庡悓姝ユ椂闂�
             LocalDateTime lastSyncTime = getLastSyncTime();
-            log.info("寮�濮嬬墿鏂欑紪鐮佸閲忓悓姝ワ紝鏈湴鏈�鍚庝慨鏀规椂闂�: {}", lastSyncTime);
+            log.info("寮�濮嬪悓姝ョ墿鏂欙紝鏈湴鏈�鍚庢椂闂� {}", lastSyncTime);
 
-            int pageNumber = 1;
-            int pageSize = 50;
+            int page = 1;
+            int size = 50;
             boolean hasMore = true;
-            int totalSynced = 0;
+            int total = 0;
 
             while (hasMore) {
-                // 鏌ヨ鍙傛暟
-                JSONObject searchParam = buildSearchParam(lastSyncTime, pageNumber, pageSize);
+                JSONObject param = buildSearchParam(lastSyncTime, page, size);
+                String res = HttpUtils.sendPostJson(
+                        aliDingConfig.getSearchFormDataUrl(),
+                        param.toJSONString(),
+                        StandardCharsets.UTF_8.name(),
+                        null,
+                        accessToken
+                );
 
-                // 璋冪敤瀹滄惌鎺ュ彛鎷夊彇鏁版嵁
-                String dataRes = HttpUtils.sendPostJson(aliDingConfig.getSearchFormDataUrl(), searchParam.toJSONString(), StandardCharsets.UTF_8.name(), null, accessToken);
-
-                if (StringUtils.isEmpty(dataRes)) {
-                    log.warn("绗� {} 椤垫媺鍙栨暟鎹负绌�", pageNumber);
+                JSONObject result = JSON.parseObject(res);
+                JSONArray dataArr = result.getJSONArray("data");
+                Integer totalCount = result.getInteger("totalCount");
+                if (CollectionUtils.isEmpty(dataArr)) {
                     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<ProductMaterialSku> list = parseProductMaterials(dataArr, totalCount);
-                if (!list.isEmpty()) {
-                    // 澶勭悊鏇存柊鎴栨柊澧�
-                    int affected = processSaveOrUpdate(list);
-                    totalSynced += affected;
-                }
-
-                // 鍒ゆ柇鏄惁杩樻湁涓嬩竴椤�
-                hasMore = (pageNumber * pageSize) < totalCount;
-                pageNumber++;
-
-                log.info("姝e湪鍚屾绗� {} 椤碉紝褰撳墠宸插悓姝� {}/{}", pageNumber - 1, totalSynced, totalCount);
+                List<ProductMaterialSku> list = parseProductMaterials(dataArr);
+                int affected = processSaveOrUpdate(list);
+                total += affected;
+                hasMore = page * size < totalCount;
+                page++;
+                log.info("鍚屾杩涘害 {} / {}", total, totalCount);
             }
-
-            log.info("鐗╂枡鏁版嵁鍚屾瀹屾垚锛屽叡鍚屾 {} 鏉℃暟鎹�", totalSynced);
+            log.info("鐗╂枡鍚屾瀹屾垚 鍏� {} 鏉�", total);
         } catch (Exception e) {
-            log.error("鍚屾鐗╂枡缂栫爜寮傚父", 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() {
-        LambdaQueryWrapper<ProductMaterialSku> queryWrapper = new LambdaQueryWrapper<>();
-        queryWrapper.orderByDesc(ProductMaterialSku::getFormModifiedTime).last("LIMIT 1");
-        ProductMaterialSku lastRecord = productMaterialSkuService.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.getMaterialCodeFormUuid());
-        searchParam.put("currentPage", pageNumber);
-        searchParam.put("pageSize", pageSize);
-
-        JSONArray searchConditions = new JSONArray();
-        JSONObject statusCondition = new JSONObject();
-        statusCondition.put("key", "processInstanceStatus");
-        JSONArray statusValueArray = new JSONArray();
-        statusValueArray.add("COMPLETED");
-        statusCondition.put("value", statusValueArray);
-        statusCondition.put("type", "ARRAY");
-        statusCondition.put("operator", "in");
-        statusCondition.put("componentName", "SelectField");
-        searchConditions.add(statusCondition);
-
-        JSONObject resultCondition = new JSONObject();
-        resultCondition.put("key", "processApprovedResult");
-        JSONArray resultValueArray = new JSONArray();
-        resultValueArray.add("agree");
-        resultCondition.put("value", resultValueArray);
-        resultCondition.put("type", "ARRAY");
-        resultCondition.put("operator", "in");
-        resultCondition.put("componentName", "SelectField");
-        searchConditions.add(resultCondition);
-
-        searchParam.put("searchFieldJson", searchConditions.toJSONString());
-        searchParam.put("orderConfigJson", "{\"gmt_modified\":\"+\"}");
-
-        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<ProductMaterialSku> parseProductMaterials(JSONArray dataArr, Integer totalCount) {
+    private List<ProductMaterialSku> parseProductMaterials(JSONArray arr) {
         List<ProductMaterialSku> 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");
-
-            JSONObject originator = item.getJSONObject("originator");
-            String originatorName = originator != null && originator.containsKey("userName") ? originator.getJSONObject("userName").getString("nameInChinese") : "鏈煡";
+        for (int i = 0; i < arr.size(); i++) {
+            JSONObject item = arr.getJSONObject(i);
             JSONObject formData = item.getJSONObject("formData");
-            //  澶勭悊鐗╂枡涓昏〃鏁版嵁
+
+            String materialName = formData.getString("textField_l92f36f5");
             ProductMaterial material = new ProductMaterial();
-            material.setMaterialName(formData.getString("textField_l92f36f5"));
+            material.setMaterialName(materialName);
             material.setBaseUnit(formData.getString("textField_la147lnw"));
-            material.setRemark(formData.getString("textareaField_l92f36f9"));
-
-            String materialType = formData.getString("selectField_l92f36fb");
-            String inventoryCat = formData.getString("selectField_la154noy");
-            material.setMaterialTypeId(getOrCreateConfigId(materialType, MaterialConfigTypeEnum.MATERIAL_TYPE.name()));
-            material.setInventoryCategoryId(getOrCreateConfigId(inventoryCat, MaterialConfigTypeEnum.INVENTORY_CAT.name()));
-
+            String type = formData.getString("selectField_l92f36fb");
+            String inventory = formData.getString("selectField_la154noy");
+            material.setMaterialTypeId(getOrCreateConfigId(type, MaterialConfigTypeEnum.MATERIAL_TYPE.name()));
+            material.setInventoryCategoryId(getOrCreateConfigId(inventory, MaterialConfigTypeEnum.INVENTORY_CAT.name()));
             Long materialId = getOrCreateMaterial(material);
-
-            //  澶勭悊鐗╂枡瑙勬牸鏁版嵁
             ProductMaterialSku sku = new ProductMaterialSku();
             sku.setMaterialId(materialId);
-            sku.setFormInstanceId(formInstanceId);
-            sku.setIdentifierCode(formData.getString("textField_l92h77ju"));
             sku.setMaterialCode(formData.getString("textField_l92f36f2"));
             sku.setSpecification(formData.getString("textField_l92f36f6"));
-            sku.setSupplyType(formData.getString("selectField_la14k51j"));
-            sku.setOriginatorName(originatorName);
-            sku.setOriginatorOrg("瀹佸涓垱缁胯兘瀹炰笟闆嗗洟鏈夐檺鍏徃");
+            sku.setIdentifierCode(formData.getString("textField_l92h77ju"));
             sku.setFormModifiedTime(parseUtcTime(item.getString("modifiedTimeGMT")));
             sku.setCreateTime(now);
             sku.setUpdateTime(now);
-
             list.add(sku);
         }
         return list;
     }
 
     private Long getOrCreateMaterial(ProductMaterial material) {
-        LambdaQueryWrapper<ProductMaterial> queryWrapper = new LambdaQueryWrapper<>();
-        queryWrapper.eq(ProductMaterial::getMaterialName, material.getMaterialName());
-
-        ProductMaterial exist = this.getOne(queryWrapper);
+        ProductMaterial exist = this.getOne(
+                new LambdaQueryWrapper<ProductMaterial>()
+                        .eq(ProductMaterial::getMaterialName, material.getMaterialName())
+        );
         if (exist == null) {
             material.setCreateTime(LocalDateTime.now());
             material.setUpdateTime(LocalDateTime.now());
             this.save(material);
             return material.getId();
-        } else {
-            // 濡傛灉宸插瓨鍦紝浣嗗叧閿睘鎬у彂鐢熷彉鍖栵紝鍒欒繘琛屾洿鏂帮紙浠ュ疁鎼暟鎹负鍑嗭級
-            boolean needUpdate = false;
-            if (material.getMaterialTypeId() != null && !material.getMaterialTypeId().equals(exist.getMaterialTypeId())) {
-                exist.setMaterialTypeId(material.getMaterialTypeId());
-                needUpdate = true;
-            }
-            if (material.getInventoryCategoryId() != null && !material.getInventoryCategoryId().equals(exist.getInventoryCategoryId())) {
-                exist.setInventoryCategoryId(material.getInventoryCategoryId());
-                needUpdate = true;
-            }
-            if (StringUtils.isNotEmpty(material.getBaseUnit()) && !material.getBaseUnit().equals(exist.getBaseUnit())) {
-                exist.setBaseUnit(material.getBaseUnit());
-                needUpdate = true;
-            }
-            if (needUpdate) {
-                exist.setUpdateTime(LocalDateTime.now());
-                this.updateById(exist);
-            }
-            return exist.getId();
         }
+
+        return exist.getId();
     }
+
 
     private Integer getOrCreateConfigId(String name, String type) {
         if (StringUtils.isEmpty(name)) {
             return null;
         }
-        ProductMaterialConfig config = productMaterialConfigService.getOne(new LambdaQueryWrapper<ProductMaterialConfig>().eq(ProductMaterialConfig::getConfigName, name).eq(ProductMaterialConfig::getConfigType, type));
+        String key = type + "_" + name;
+        if (configCache.containsKey(key)) {
+            return configCache.get(key);
+        }
+        ProductMaterialConfig config = productMaterialConfigService.getOne(new LambdaQueryWrapper<ProductMaterialConfig>()
+                .eq(ProductMaterialConfig::getConfigName, name)
+                .eq(ProductMaterialConfig::getConfigType, type));
         if (config == null) {
             config = new ProductMaterialConfig();
             config.setConfigName(name);
             config.setConfigType(type);
             productMaterialConfigService.save(config);
         }
+        configCache.put(key, config.getId());
         return config.getId();
     }
 
     private int processSaveOrUpdate(List<ProductMaterialSku> list) {
-        if (list == null || list.isEmpty()) {
+        if (CollectionUtils.isEmpty(list)) {
             return 0;
         }
         int affected = 0;
-
         for (ProductMaterialSku sku : list) {
 
-            LambdaQueryWrapper<ProductMaterialSku> wrapper = new LambdaQueryWrapper<>();
-            wrapper.eq(ProductMaterialSku::getMaterialId, sku.getMaterialId())
-                    .eq(ProductMaterialSku::getSpecification, sku.getSpecification());
+            ProductMaterialSku exist = productMaterialSkuService.getOne(new LambdaQueryWrapper<ProductMaterialSku>()
+                    .eq(ProductMaterialSku::getMaterialId, sku.getMaterialId())
+                    .eq(ProductMaterialSku::getSpecification, sku.getSpecification()));
 
-            if (StringUtils.isNotEmpty(sku.getMaterialCode())) {
-                wrapper.eq(ProductMaterialSku::getMaterialCode, sku.getMaterialCode());
-            } else {
-                wrapper.isNull(ProductMaterialSku::getMaterialCode);
-            }
-
-            ProductMaterialSku exist = productMaterialSkuService.getOne(wrapper);
             if (exist == null) {
                 productMaterialSkuService.save(sku);
                 affected++;
-                log.info("鏂板鐗╂枡瑙勬牸 {}", sku.getSpecification());
-            } else {
-                if (exist.getFormModifiedTime() == null || !exist.getFormModifiedTime().equals(sku.getFormModifiedTime())) {
-                    sku.setId(exist.getId());
-                    sku.setCreateTime(exist.getCreateTime());
-                    productMaterialSkuService.updateById(sku);
-
-                    affected++;
-                    log.info("鏇存柊鐗╂枡瑙勬牸 {}", sku.getSpecification());
-                }
+            } else if (!Objects.equals(exist.getFormModifiedTime(), sku.getFormModifiedTime())) {
+                sku.setId(exist.getId());
+                sku.setCreateTime(exist.getCreateTime());
+                productMaterialSkuService.updateById(sku);
+                affected++;
             }
         }
         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
-    public List<ProductMaterialGroupDto> ProductMaterialList() {
-
-        List<ProductMaterialConfig> materialConfigList = productMaterialConfigService.list(new LambdaQueryWrapper<ProductMaterialConfig>()
-                .eq(ProductMaterialConfig::getConfigType, MaterialConfigTypeEnum.MATERIAL_TYPE.name()));
-
-        List<ProductMaterialGroupDto> productMaterialMap = new ArrayList<>();
-        if (materialConfigList == null || materialConfigList.isEmpty()) {
-            return productMaterialMap;
+    public List<ProductMaterialGroupDto> ProductMaterialList(Integer type) {
+        List<ProductMaterialConfig> configList = productMaterialConfigService.list(new LambdaQueryWrapper<ProductMaterialConfig>()
+                .eq(ProductMaterialConfig::getConfigType, MaterialConfigTypeEnum.MATERIAL_TYPE.name())
+        );
+        if (CollectionUtils.isEmpty(configList)) {
+            return new ArrayList<>();
         }
-        for (ProductMaterialConfig materialConfig : materialConfigList) {
+        List<ProductMaterialGroupDto> result = new ArrayList<>();
+        Map<Integer, List<ProductMaterialDto>> materialMap = new HashMap<>();
+        if (type != null && type == 2) {
+            List<ProductMaterial> materialList = this.list(new LambdaQueryWrapper<ProductMaterial>()
+                    .select(
+                            ProductMaterial::getId,
+                            ProductMaterial::getMaterialTypeId,
+                            ProductMaterial::getInventoryCategoryId,
+                            ProductMaterial::getMaterialName
+                    )
+            );
+            materialMap = materialList.stream()
+                    .map(this::convert)
+                    .collect(Collectors.groupingBy(ProductMaterialDto::getMaterialTypeId));
+        }
+
+        for (ProductMaterialConfig config : configList) {
             ProductMaterialGroupDto dto = new ProductMaterialGroupDto();
-            dto.setConfigId(materialConfig.getId());
-            dto.setConfigName(materialConfig.getConfigName());
-            productMaterialMap.add(dto);
+            dto.setConfigId(config.getId());
+            dto.setConfigName(config.getConfigName());
+            if (type != null && type == 2) {
+                dto.setMaterialList(materialMap.getOrDefault(config.getId(), new ArrayList<>()));
+            }
+            result.add(dto);
         }
-        return productMaterialMap;
+        return result;
     }
+
 
     @Override
     public List<ProductMaterialGroupDto> productMaterialListByQuery(String materialName, Integer materialTypeId) {
+
         if (StringUtils.isEmpty(materialName) && materialTypeId == null) {
-            return new ArrayList<>(0);
+            return new ArrayList<>();
         }
-        // 鏌ヨ鐗╂枡绫诲瀷閰嶇疆
-        List<ProductMaterialConfig> materialConfigList = productMaterialConfigService.list(new LambdaQueryWrapper<ProductMaterialConfig>()
+
+        LambdaQueryWrapper<ProductMaterial> wrapper = new LambdaQueryWrapper<>();
+        //  鍙煡璇㈤渶瑕佺殑瀛楁鏁版嵁
+        wrapper.select(
+                ProductMaterial::getId,
+                ProductMaterial::getMaterialTypeId,
+                ProductMaterial::getInventoryCategoryId,
+                ProductMaterial::getMaterialName
+        );
+        if (StringUtils.isNotEmpty(materialName)) {
+            wrapper.like(ProductMaterial::getMaterialName, materialName);
+        }
+        if (materialTypeId != null) {
+            wrapper.eq(ProductMaterial::getMaterialTypeId, materialTypeId);
+        }
+        List<ProductMaterial> materials = this.list(wrapper);
+        if (CollectionUtils.isEmpty(materials)) {
+            return new ArrayList<>();
+        }
+        Map<Integer, List<ProductMaterialDto>> map = materials.stream()
+                .map(this::convert)
+                .collect(Collectors.groupingBy(ProductMaterialDto::getMaterialTypeId));
+
+        List<ProductMaterialConfig> configList = productMaterialConfigService.list(new LambdaQueryWrapper<ProductMaterialConfig>()
                 .eq(ProductMaterialConfig::getConfigType, MaterialConfigTypeEnum.MATERIAL_TYPE.name()));
 
         List<ProductMaterialGroupDto> result = new ArrayList<>();
-        if (CollectionUtils.isEmpty(materialConfigList)) {
-            return result;
-        }
-        LambdaQueryWrapper<ProductMaterial> wrapper;
-        for (ProductMaterialConfig materialConfig : materialConfigList) {
-            wrapper = new LambdaQueryWrapper<>();
-            //  鎸囧畾闇�瑕佺殑瀛楁
-            wrapper.select(
-                    ProductMaterial::getId,
-                    ProductMaterial::getMaterialTypeId,
-                    ProductMaterial::getInventoryCategoryId,
-                    ProductMaterial::getMaterialName
-            );
-            if (StringUtils.isNotEmpty(materialName)) {
-                wrapper.eq(ProductMaterial::getMaterialTypeId, materialConfig.getId())
-                        .like(ProductMaterial::getMaterialName, materialName);
-            } else {
-                if (!materialConfig.getId().equals(materialTypeId)) {
-                    continue;
-                }
-                wrapper.eq(ProductMaterial::getMaterialTypeId, materialTypeId);
-            }
-            List<ProductMaterial> materialList = list(wrapper);
-            if (CollectionUtils.isEmpty(materialList)) {
+        for (ProductMaterialConfig config : configList) {
+            List<ProductMaterialDto> dtoList = map.get(config.getId());
+            if (CollectionUtils.isEmpty(dtoList)) {
                 continue;
             }
-
-            List<ProductMaterialDto> dtoList = materialList.stream().map(m -> {
-                ProductMaterialDto dto = new ProductMaterialDto();
-                dto.setId(m.getId());
-                dto.setMaterialTypeId(m.getMaterialTypeId());
-                dto.setInventoryCategoryId(m.getInventoryCategoryId());
-                dto.setMaterialName(m.getMaterialName());
-                return dto;
-            }).collect(Collectors.toList());
             ProductMaterialGroupDto dto = new ProductMaterialGroupDto();
-            dto.setConfigId(materialConfig.getId());
-            dto.setConfigName(materialConfig.getConfigName());
+            dto.setConfigId(config.getId());
+            dto.setConfigName(config.getConfigName());
             dto.setMaterialList(dtoList);
             result.add(dto);
         }
@@ -469,6 +356,7 @@
         log.info("鍒犻櫎鐗╂枡鎴愬姛 ids={}", ids);
     }
 
+
     private void validateProductMaterial(ProductMaterial productMaterial, boolean requireId) {
         if (productMaterial == null) {
             throw new ServiceException("鍙傛暟涓嶈兘涓虹┖");
@@ -492,4 +380,50 @@
         }
         return this.count(queryWrapper) > 0;
     }
-}
+
+    private ProductMaterialDto convert(ProductMaterial m) {
+        ProductMaterialDto dto = new ProductMaterialDto();
+        dto.setId(m.getId());
+        dto.setMaterialName(m.getMaterialName());
+        dto.setMaterialTypeId(m.getMaterialTypeId());
+        dto.setInventoryCategoryId(m.getInventoryCategoryId());
+        return dto;
+    }
+
+    private LocalDateTime parseUtcTime(String utc) {
+        if (StringUtils.isEmpty(utc)) {
+            return null;
+        }
+        try {
+            return OffsetDateTime.parse(utc).toLocalDateTime();
+        } catch (DateTimeParseException e) {
+            log.warn("鏃堕棿瑙f瀽澶辫触 {}", utc);
+            return null;
+        }
+    }
+
+    private String getAccessToken() {
+        String params = "appkey=" + aliDingConfig.getAppKey() + "&appsecret=" + aliDingConfig.getAppSecret();
+        String res = HttpUtils.sendGet(aliDingConfig.getAccessTokenUrl(), params);
+        JSONObject obj = JSON.parseObject(res);
+        return obj.getString("access_token");
+    }
+
+    private LocalDateTime getLastSyncTime() {
+        ProductMaterialSku last = productMaterialSkuService.getOne(new LambdaQueryWrapper<ProductMaterialSku>()
+                .orderByDesc(ProductMaterialSku::getFormModifiedTime)
+                .last("limit 1"));
+        return last == null ? null : last.getFormModifiedTime();
+    }
+
+    private JSONObject buildSearchParam(LocalDateTime lastTime, int page, int size) {
+        JSONObject obj = new JSONObject();
+        obj.put("appType", aliDingConfig.getAppType());
+        obj.put("systemToken", aliDingConfig.getSystemToken());
+        obj.put("formUuid", aliDingConfig.getMaterialCodeFormUuid());
+        obj.put("currentPage", page);
+        obj.put("pageSize", size);
+
+        return obj;
+    }
+}
\ No newline at end of file

--
Gitblit v1.9.3