From 133151cb69a6dfbca1d47c10f1ca9eca581a8502 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期一, 13 三月 2023 11:00:04 +0800
Subject: [PATCH] 提交需要处理的记录查询,测试用; 回退对物料表中对类别的划分,维持原样 物料编码+型号确定唯一
---
src/main/java/com/whyc/service/ProductBomHistoryService.java | 20 ++++++++++++++++++++
1 files changed, 20 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/ProductBomHistoryService.java b/src/main/java/com/whyc/service/ProductBomHistoryService.java
index 53c735b..08c597a 100644
--- a/src/main/java/com/whyc/service/ProductBomHistoryService.java
+++ b/src/main/java/com/whyc/service/ProductBomHistoryService.java
@@ -691,4 +691,24 @@
}
return new Response().setII(1,bl,withOutDwg.replace(fileDirName,""),"鍘熷鏂囦欢鐩稿璺緞");
}
+
+ public void getFixItem() {
+ List<ProductBomHistory> bomHistoryList = mapper.selectList(null);
+ Map<Integer, List<ProductBomHistory>> productMap = bomHistoryList.stream().collect(Collectors.groupingBy(ProductBomHistory::getProductId));
+ Set<Integer> productIdSet = productMap.keySet();
+ List<ProductBomHistory> needToDealWith = new LinkedList<>();
+ for (Integer productId : productIdSet) {
+ List<ProductBomHistory> bomList = productMap.get(productId);
+ Map<Integer, List<ProductBomHistory>> materialIdMap = bomList.stream().collect(Collectors.groupingBy(ProductBomHistory::getMaterialId));
+ Set<Integer> materialIdSet = materialIdMap.keySet();
+ for (Integer materialId : materialIdSet) {
+ List<ProductBomHistory> temp = materialIdMap.get(materialId);
+ if(temp.size()!=1){
+ System.err.println("闇�瑕佹墜鍔ㄥ鐞嗙殑productBomHistory鍜宲roductBom:"+productId+",鐗╂枡id:"+materialId);
+ needToDealWith.add(temp.get(0));
+ }
+ }
+ }
+ System.err.println("鍙兘闇�瑕佸鐞嗙殑鏉℃暟涓�:"+needToDealWith.size());
+ }
}
--
Gitblit v1.9.1