From c30bfeb3840c69f0ad7eeb0ff713d63da7494b23 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期五, 09 十月 2026 11:49:21 +0800
Subject: [PATCH] fix: bom结构移除拖动更新
---
src/main/java/com/ruoyi/technology/service/impl/TechnologyRoutingServiceImpl.java | 200 ++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 177 insertions(+), 23 deletions(-)
diff --git a/src/main/java/com/ruoyi/technology/service/impl/TechnologyRoutingServiceImpl.java b/src/main/java/com/ruoyi/technology/service/impl/TechnologyRoutingServiceImpl.java
index 6066cb7..3a00f21 100644
--- a/src/main/java/com/ruoyi/technology/service/impl/TechnologyRoutingServiceImpl.java
+++ b/src/main/java/com/ruoyi/technology/service/impl/TechnologyRoutingServiceImpl.java
@@ -1,7 +1,6 @@
package com.ruoyi.technology.service.impl;
import cn.hutool.core.bean.BeanUtil;
-import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
@@ -10,14 +9,10 @@
import com.ruoyi.common.utils.OrderUtils;
import com.ruoyi.technology.bean.dto.TechnologyRoutingDto;
import com.ruoyi.technology.bean.vo.TechnologyRoutingVo;
-import com.ruoyi.technology.mapper.TechnologyBomStructureMapper;
-import com.ruoyi.technology.mapper.TechnologyOperationMapper;
-import com.ruoyi.technology.mapper.TechnologyRoutingMapper;
-import com.ruoyi.technology.mapper.TechnologyRoutingOperationMapper;
-import com.ruoyi.technology.pojo.TechnologyBomStructure;
-import com.ruoyi.technology.pojo.TechnologyOperation;
-import com.ruoyi.technology.pojo.TechnologyRouting;
-import com.ruoyi.technology.pojo.TechnologyRoutingOperation;
+import com.ruoyi.production.mapper.ProductionOrderRoutingMapper;
+import com.ruoyi.production.pojo.ProductionOrderRouting;
+import com.ruoyi.technology.mapper.*;
+import com.ruoyi.technology.pojo.*;
import com.ruoyi.technology.service.TechnologyRoutingService;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Service;
@@ -25,9 +20,15 @@
import java.time.LocalDate;
import java.time.format.DateTimeFormatter;
+import java.util.ArrayList;
+import java.util.Comparator;
+import java.util.HashMap;
+import java.util.HashSet;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
+import java.util.Set;
+import java.util.stream.Collectors;
@Service
@Transactional(rollbackFor = Exception.class)
@@ -41,6 +42,11 @@
private final TechnologyBomStructureMapper technologyBomStructureMapper;
private final TechnologyOperationMapper technologyOperationMapper;
+ private final TechnologyOperationParamMapper technologyOperationParamMapper;
+ private final TechnologyParamMapper technologyParamMapper;
+ private final TechnologyRoutingOperationParamMapper technologyRoutingOperationParamMapper;
+
+ private final ProductionOrderRoutingMapper productionOrderRoutingMapper;
@Override
public IPage<TechnologyRoutingVo> pageTechnologyRouting(Page<TechnologyRoutingDto> page, TechnologyRoutingDto technologyRoutingDto) {
@@ -81,6 +87,21 @@
if (ids == null || ids.isEmpty()) {
return false;
}
+ // 鍒ゆ柇鏄惁鏈夌敓浜ц鍗曠粦瀹氳宸ヨ壓璺嚎
+ Long count = productionOrderRoutingMapper.selectCount(
+ Wrappers.<ProductionOrderRouting>lambdaQuery()
+ .in(ProductionOrderRouting::getTechnologyRoutingId, ids));
+ if (count > 0) {
+ throw new ServiceException("璇ュ伐鑹鸿矾绾垮凡缁戝畾鐢熶骇璁㈠崟锛屾棤娉曞垹闄わ紒");
+ }
+ List<TechnologyRoutingOperation> routingOperationList = technologyRoutingOperationMapper.selectList(
+ Wrappers.<TechnologyRoutingOperation>lambdaQuery()
+ .in(TechnologyRoutingOperation::getTechnologyRoutingId, ids));
+ if (!routingOperationList.isEmpty()) {
+ List<Long> routingOperationIdList = routingOperationList.stream().map(TechnologyRoutingOperation::getId).collect(Collectors.toList());
+ technologyRoutingOperationParamMapper.delete(Wrappers.<TechnologyRoutingOperationParam>lambdaQuery()
+ .in(TechnologyRoutingOperationParam::getTechnologyRoutingOperationId, routingOperationIdList));
+ }
technologyRoutingOperationMapper.delete(Wrappers.<TechnologyRoutingOperation>lambdaQuery()
.in(TechnologyRoutingOperation::getTechnologyRoutingId, ids));
return this.removeByIds(ids);
@@ -93,45 +114,178 @@
* 3. 鎸� BOM 鍑虹幇椤哄簭鍘婚噸鍚庨噸鏂板啓鍏ュ伐鑹鸿矾绾垮伐搴忚〃
*/
private void syncRoutingOperationsByBom(TechnologyRouting technologyRouting) {
- technologyRoutingOperationMapper.delete(Wrappers.<TechnologyRoutingOperation>lambdaQuery()
- .eq(TechnologyRoutingOperation::getTechnologyRoutingId, technologyRouting.getId()));
+ List<TechnologyRoutingOperation> oldRoutingOperationList = technologyRoutingOperationMapper.selectList(
+ Wrappers.<TechnologyRoutingOperation>lambdaQuery()
+ .eq(TechnologyRoutingOperation::getTechnologyRoutingId, technologyRouting.getId()));
+ if (!oldRoutingOperationList.isEmpty()) {
+ List<Long> oldRoutingOperationIdList = oldRoutingOperationList.stream().map(TechnologyRoutingOperation::getId).collect(Collectors.toList());
+ technologyRoutingOperationParamMapper.delete(Wrappers.<TechnologyRoutingOperationParam>lambdaQuery()
+ .in(TechnologyRoutingOperationParam::getTechnologyRoutingOperationId, oldRoutingOperationIdList));
+ technologyRoutingOperationMapper.delete(Wrappers.<TechnologyRoutingOperation>lambdaQuery()
+ .eq(TechnologyRoutingOperation::getTechnologyRoutingId, technologyRouting.getId()));
+ }
if (technologyRouting.getBomId() == null) {
return;
}
+
List<TechnologyBomStructure> bomStructures = technologyBomStructureMapper.selectList(
Wrappers.<TechnologyBomStructure>lambdaQuery()
- .eq(TechnologyBomStructure::getBomId, Long.valueOf(technologyRouting.getBomId()))
- .isNotNull(TechnologyBomStructure::getOperationId)
+ .eq(TechnologyBomStructure::getBomId, technologyRouting.getBomId())
.orderByAsc(TechnologyBomStructure::getId)
);
if (bomStructures.isEmpty()) {
throw new ServiceException("bom浜у搧缁撴瀯涓虹┖锛�");
}
- // 鍚屼竴涓� BOM 涓彲鑳介噸澶嶅紩鐢ㄧ浉鍚屽伐搴忥紝杩欓噷鎸夐娆″嚭鐜伴『搴忓幓閲嶃��
- Map<Long, TechnologyBomStructure> uniqueOperationMap = new LinkedHashMap<>();
+ Map<Long, TechnologyBomStructure> structureById = new HashMap<>();
+ Map<Long, List<TechnologyBomStructure>> childrenByParentId = new LinkedHashMap<>();
+ List<TechnologyBomStructure> rootList = new ArrayList<>();
for (TechnologyBomStructure bomStructure : bomStructures) {
- uniqueOperationMap.putIfAbsent(bomStructure.getOperationId(), bomStructure);
+ if (bomStructure == null) {
+ continue;
+ }
+ if (bomStructure.getId() != null) {
+ structureById.put(bomStructure.getId(), bomStructure);
+ }
+ if (bomStructure.getParentId() == null || bomStructure.getParentId() == 0L) {
+ rootList.add(bomStructure);
+ } else {
+ childrenByParentId.computeIfAbsent(bomStructure.getParentId(), key -> new ArrayList<>()).add(bomStructure);
+ }
}
+ // 鍚庡簭閬嶅巻BOM
+ List<TechnologyBomStructure> orderedOperationNodes = new ArrayList<>();
+ Set<Long> visitingIds = new HashSet<>();
+ for (TechnologyBomStructure rootNode : rootList) {
+ collectOperationNodePostOrder(rootNode, childrenByParentId, orderedOperationNodes, visitingIds);
+ }
+ if (orderedOperationNodes.isEmpty()) {
+ throw new ServiceException("bom浜у搧缁撴瀯鏈厤缃秷鑰楀伐搴忥紒");
+ }
+
+ // 鍚屼竴灞傜骇锛堝悓涓�鐖惰妭鐐癸級鍐呯浉鍚屽伐搴忓悎骞朵负涓�閬撳伐搴忥紝渚嬪鍚屽眰鐨勫涓帇鎺ヤ欢鍚堝苟鎴愪竴閬撳帇鎺ワ紱
+ // 鍚堝苟鍚庣殑浣嶇疆鍙栬宸ュ簭鏈�鍚庝竴娆″嚭鐜扮殑浣嶇疆锛岀‘淇濆叾鍏ㄩ儴杈撳叆鐗╂枡鐨勫伐搴忛兘鍦ㄥ畠涔嬪墠
+ Map<String, Integer> lastPositionByKey = new HashMap<>();
+ Map<String, TechnologyBomStructure> operationNodeByKey = new LinkedHashMap<>();
+ for (int i = 0; i < orderedOperationNodes.size(); i++) {
+ TechnologyBomStructure bomStructure = orderedOperationNodes.get(i);
+ String dedupKey = buildBomOperationDedupKey(bomStructure);
+ lastPositionByKey.put(dedupKey, i);
+ operationNodeByKey.putIfAbsent(dedupKey, bomStructure);
+ }
+ List<String> sortedDedupKeys = new ArrayList<>(operationNodeByKey.keySet());
+ sortedDedupKeys.sort(Comparator.comparingInt(lastPositionByKey::get));
+
int dragSort = 1;
- for (TechnologyBomStructure bomStructure : uniqueOperationMap.values()) {
+ for (String dedupKey : sortedDedupKeys) {
+ TechnologyBomStructure bomStructure = operationNodeByKey.get(dedupKey);
TechnologyRoutingOperation routingOperation = new TechnologyRoutingOperation();
routingOperation.setTechnologyRoutingId(technologyRouting.getId());
- routingOperation.setProductModelId(technologyRouting.getProductModelId());
+ routingOperation.setProductModelId(resolveOutputProductModelId(bomStructure, structureById, technologyRouting.getProductModelId()));
routingOperation.setTechnologyOperationId(bomStructure.getOperationId());
routingOperation.setDragSort(dragSort++);
- routingOperation.setIsQuality(getOperationQuality(bomStructure.getOperationId()));
+ TechnologyOperation technologyOperation = getOperation(bomStructure.getOperationId());
+ routingOperation.setIsQuality(technologyOperation != null ? technologyOperation.getIsQuality() : null);
+ routingOperation.setIsProduction(technologyOperation != null ? technologyOperation.getIsProduction() : null);
+ routingOperation.setType(technologyOperation != null ? technologyOperation.getType() : null);
technologyRoutingOperationMapper.insert(routingOperation);
+ syncRoutingOperationParams(routingOperation.getId(), bomStructure.getOperationId());
}
}
/**
- * 璐ㄦ鏍囪瘑浠ュ伐搴忓熀纭�琛ㄥ畾涔変负鍑嗐��
+ * 鍚庡簭閬嶅巻 BOM
*/
- private Boolean getOperationQuality(Long operationId) {
- TechnologyOperation technologyOperation = technologyOperationMapper.selectById(operationId);
- return technologyOperation != null ? technologyOperation.getIsQuality() : null;
+ private void collectOperationNodePostOrder(TechnologyBomStructure node,
+ Map<Long, List<TechnologyBomStructure>> childrenByParentId,
+ List<TechnologyBomStructure> orderedOperationNodes,
+ Set<Long> visitingIds) {
+ if (node == null || node.getId() == null) {
+ return;
+ }
+ if (!visitingIds.add(node.getId())) {
+ return;
+ }
+ List<TechnologyBomStructure> children = childrenByParentId.get(node.getId());
+ if (children != null && !children.isEmpty()) {
+ for (TechnologyBomStructure child : children) {
+ collectOperationNodePostOrder(child, childrenByParentId, orderedOperationNodes, visitingIds);
+ }
+ }
+ visitingIds.remove(node.getId());
+ if (node.getOperationId() != null) {
+ orderedOperationNodes.add(node);
+ }
+ }
+
+ /**
+ * 鍘婚噸閿細鍚屼竴鐖惰妭鐐� + 鐩稿悓宸ュ簭锛堝彧鍦ㄥ悓涓�灞傜骇鍐呭悎骞讹紝涓嶅悓灞傜骇銆佷笉鍚屽垎鏀殑鐩稿悓宸ュ簭涓嶄細鍚堝苟锛夈��
+ */
+ private String buildBomOperationDedupKey(TechnologyBomStructure bomStructure) {
+ Long operationId = bomStructure == null ? null : bomStructure.getOperationId();
+ Long parentId = bomStructure == null ? null : bomStructure.getParentId();
+ return operationId + "#" + (parentId == null ? "root" : String.valueOf(parentId));
+ }
+
+ /**
+ * 宸ュ簭浜у嚭浜у搧 = 鐖惰妭鐐圭殑浜у搧锛堟湰琛岀墿鏂欑敱鐖惰妭鐐瑰眰绾х殑娑堣�楀伐搴忔秷鑰楋紝浜у嚭鐨勬槸涓婁竴灞備骇鍝侊紝
+ * 鑰屼笉鏄湰琛岀墿鏂欒嚜韬級锛涗粎褰撶埗鑺傜偣缂哄け鎴栫埗鑺傜偣娌℃湁浜у搧鏃讹紝鎵嶅洖閫�鍒版湰鑺傜偣鑷韩浜у搧銆佸啀鍥為��鍒板伐鑹鸿矾绾夸骇鍝併��
+ */
+ private Long resolveOutputProductModelId(TechnologyBomStructure bomStructure,
+ Map<Long, TechnologyBomStructure> structureById,
+ Long routingProductModelId) {
+ if (bomStructure == null) {
+ return routingProductModelId;
+ }
+ Long parentId = bomStructure.getParentId();
+ if (parentId != null && parentId != 0L && structureById != null) {
+ TechnologyBomStructure parent = structureById.get(parentId);
+ if (parent != null && parent.getProductModelId() != null) {
+ return parent.getProductModelId();
+ }
+ }
+ if (bomStructure.getProductModelId() != null) {
+ return bomStructure.getProductModelId();
+ }
+ return routingProductModelId;
+ }
+
+ private void syncRoutingOperationParams(Long technologyRoutingOperationId, Long technologyOperationId) {
+ List<TechnologyOperationParam> operationParamList = technologyOperationParamMapper.selectList(
+ Wrappers.<TechnologyOperationParam>lambdaQuery()
+ .eq(TechnologyOperationParam::getTechnologyOperationId, technologyOperationId)
+ .orderByAsc(TechnologyOperationParam::getId));
+ if (operationParamList.isEmpty()) {
+ return;
+ }
+ for (TechnologyOperationParam operationParam : operationParamList) {
+ TechnologyParam technologyParam = technologyParamMapper.selectById(operationParam.getTechnologyParamId());
+ if (technologyParam == null) {
+ continue;
+ }
+ TechnologyRoutingOperationParam snapshot = new TechnologyRoutingOperationParam();
+ snapshot.setTechnologyRoutingOperationId(technologyRoutingOperationId);
+ snapshot.setTechnologyOperationParamId(operationParam.getId());
+ snapshot.setTechnologyOperationId(operationParam.getTechnologyOperationId());
+ snapshot.setParamId(technologyParam.getId());
+ snapshot.setParamCode(technologyParam.getParamCode());
+ snapshot.setParamName(technologyParam.getParamName());
+ snapshot.setParamType(technologyParam.getParamType());
+ snapshot.setParamFormat(technologyParam.getParamFormat());
+ snapshot.setUnit(technologyParam.getUnit());
+ snapshot.setIsRequired(technologyParam.getIsRequired());
+ snapshot.setRemark(technologyParam.getRemark());
+ snapshot.setStandardValue(operationParam.getStandardValue());
+ technologyRoutingOperationParamMapper.insert(snapshot);
+ }
+ }
+
+ private TechnologyOperation getOperation(Long operationId) {
+ if (operationId == null) {
+ return null;
+ }
+ return technologyOperationMapper.selectById(operationId);
}
private String buildProcessRouteCode(Long id) {
--
Gitblit v1.9.3