From 7c1e701b523bc54dc2decffac6e8f5a0e3987b98 Mon Sep 17 00:00:00 2001 From: hongjli <3117313295@qq.com> Date: 星期五, 23 五月 2025 09:26:34 +0800 Subject: [PATCH] 补充关联不到工艺路线的料号保存至气体异常料号报表 --- aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingRouteStatServiceImpl.java | 46 +++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 45 insertions(+), 1 deletions(-) diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingRouteStatServiceImpl.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingRouteStatServiceImpl.java index eb9f304..ce61324 100644 --- a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingRouteStatServiceImpl.java +++ b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsGasPipingRouteStatServiceImpl.java @@ -6,10 +6,12 @@ import com.aps.common.core.utils.uuid.IdUtils; import com.aps.common.security.utils.SecurityUtils; import com.aps.core.domain.*; +import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireError; import com.aps.core.mapper.*; import com.aps.core.service.IApsGasMaterialUsageService; import com.aps.core.service.IApsGasPipingRouteStatService; import com.aps.core.service.IApsStandardProcessService; +import com.aps.core.mapper.ApsPlateStandardRequireErrorMapper; import jakarta.servlet.http.HttpServletResponse; import lombok.extern.slf4j.Slf4j; import org.apache.poi.ss.usermodel.*; @@ -58,6 +60,9 @@ @Autowired private IApsStandardProcessService apsStandardProcessService; + + @Autowired + private ApsPlateStandardRequireErrorMapper apsPlateStandardRequireErrorMapper; /** * 鏌ヨ姘斾綋绠¤矾浜ц兘璐熻浇缁熻 @@ -1117,6 +1122,12 @@ // 澶勭悊鎵嬪伐姘斾綋宸ュ崟鏁版嵁 - 浣跨敤鑱斿悎鏌ヨ鑾峰彇鎵�鏈夌浉鍏虫暟鎹� List<Map<String, Object>> moDataList = apsGasPipingRouteStatMapper.selectMoRouteData(); + // 鑾峰彇鎵�鏈夌殑MO鏁版嵁锛岀敤浜庢鏌ュ摢浜汳O娌℃湁鍏宠仈鍒板伐鑹鸿矾绾� + List<Map<String, Object>> allMoData = apsGasPipingRouteStatMapper.selectAllMoData(); + + // 璁板綍宸插叧鑱斿伐鑹鸿矾绾跨殑MO缂栧彿 + Set<String> processedMoSet = new HashSet<>(); + // 鎸夊伐鍗曞彿鍒嗙粍锛屼究浜庡鐞嗗悓涓�宸ュ崟鐨勪笉鍚屽伐搴� Map<String, List<Map<String, Object>>> moGroups = moDataList.stream() .collect(Collectors.groupingBy(data -> data.get("work_order_no").toString())); @@ -1124,6 +1135,9 @@ // 澶勭悊姣忎釜宸ュ崟鐨勫伐鑹鸿矾绾� for (String workOrderNo : moGroups.keySet()) { List<Map<String, Object>> workOrderData = moGroups.get(workOrderNo); + + // 鏍囪璇ュ伐鍗曞凡澶勭悊 + processedMoSet.add(workOrderNo); // 鎸夊伐搴忓彿鎺掑簭 workOrderData.sort((a, b) -> { @@ -1202,6 +1216,36 @@ statList.addAll(processList); } + } + + // 澶勭悊娌℃湁鍏宠仈鍒板伐鑹鸿矾绾跨殑MO鏁版嵁 + List<ApsPlateStandardRequireError> errorList = new ArrayList<>(); + for (Map<String, Object> moData : allMoData) { + String workOrderNo = moData.get("mo").toString(); + // 濡傛灉璇ュ伐鍗曟病鏈夎澶勭悊杩囷紝璇存槑娌℃湁鍏宠仈鍒板伐鑹鸿矾绾� + if (!processedMoSet.contains(workOrderNo)) { + ApsPlateStandardRequireError error = ApsPlateStandardRequireError.builder() + .id(Long.valueOf(IdUtils.fastSimpleUUID().hashCode())) + .batchNumber(batchNumber) + .requireId(IdUtil.getSnowflakeNextId()) + .docNum(workOrderNo) + .itemNum(moData.get("material_code").toString()) + .orgCode(moData.get("factory").toString()) + .message("鏍囧噯宸ヨ壓璺嚎涓嶅瓨鍦�") + .delFlag("0") + .build(); + + // 璁剧疆鍩虹被灞炴�� + error.setCreateBy(SecurityUtils.getUsername()); + error.setCreateTime(truncateToSeconds(DateUtils.getNowDate())); + + errorList.add(error); + } + } + + // 鎵归噺鎻掑叆寮傚父鏁版嵁 + if (!errorList.isEmpty()) { + apsPlateStandardRequireErrorMapper.batchInsert(errorList); } // 鎵归噺鎻掑叆鏁版嵁 @@ -1580,7 +1624,7 @@ rowEntry.put(rowGroupValue, rowDetail); plantTable.add(rowEntry); } - + result.put("plantTable", plantTable); result.put("timePoints", timePoints); result.put("rowGroupBy", rowGroupBy); -- Gitblit v1.9.3