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 |  300 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 290 insertions(+), 10 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 2ee300a..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,20 +1,300 @@
 package com.ruoyi.technology.service.impl;
 
+import cn.hutool.core.bean.BeanUtil;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.ruoyi.technology.mapper.TechnologyRoutingMapper;
-import com.ruoyi.technology.pojo.TechnologyRouting;
+import com.ruoyi.common.exception.ServiceException;
+import com.ruoyi.common.utils.OrderUtils;
+import com.ruoyi.technology.bean.dto.TechnologyRoutingDto;
+import com.ruoyi.technology.bean.vo.TechnologyRoutingVo;
+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;
+import org.springframework.transaction.annotation.Transactional;
 
-/**
- * <p>
- * 宸ヨ壓璺嚎琛� 鏈嶅姟瀹炵幇绫�
- * </p>
- *
- * @author 鑺杞欢锛堟睙鑻忥級鏈夐檺鍏徃
- * @since 2026-04-20 10:06:33
- */
+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)
+@RequiredArgsConstructor
 public class TechnologyRoutingServiceImpl extends ServiceImpl<TechnologyRoutingMapper, TechnologyRouting> implements TechnologyRoutingService {
 
+    private final TechnologyRoutingMapper technologyRoutingMapper;
+
+    private final TechnologyRoutingOperationMapper technologyRoutingOperationMapper;
+
+    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) {
+        return technologyRoutingMapper.pageTechnologyRouting(page, technologyRoutingDto);
+    }
+
+    @Override
+    public TechnologyRoutingVo getTechnologyRoutingInfo(Long id) {
+        TechnologyRouting technologyRouting = this.getById(id);
+        if (technologyRouting == null) {
+            return null;
+        }
+        return BeanUtil.copyProperties(technologyRouting, TechnologyRoutingVo.class);
+    }
+
+    @Override
+    public Long saveTechnologyRouting(TechnologyRouting technologyRouting) {
+        String code = OrderUtils.countTodayByCreateTime(technologyRoutingMapper, "GYLX", "process_route_code");
+        technologyRouting.setProcessRouteCode(code);
+        technologyRoutingMapper.insert(technologyRouting);
+        // 甯﹀叆bom浜у搧缁撴瀯
+        syncRoutingOperationsByBom(technologyRouting);
+        return technologyRouting.getId();
+    }
+
+    @Override
+    public boolean updateTechnologyRouting(TechnologyRouting technologyRouting) {
+        boolean updated = this.updateById(technologyRouting);
+        if (updated) {
+            TechnologyRouting currentRouting = this.getById(technologyRouting.getId());
+            syncRoutingOperationsByBom(currentRouting);
+        }
+        return updated;
+    }
+
+    @Override
+    public boolean removeTechnologyRouting(List<Long> ids) {
+        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);
+    }
+
+    /**
+     * 鎸夊綋鍓嶉�夋嫨鐨� BOM 閲嶅缓宸ヨ壓璺嚎宸ュ簭锛�
+     * 1. 鍏堝垹闄よ宸ヨ壓璺嚎涓嬪凡鏈夊伐搴�
+     * 2. 璇诲彇 BOM 缁撴瀯涓殑 operation_id
+     * 3. 鎸� BOM 鍑虹幇椤哄簭鍘婚噸鍚庨噸鏂板啓鍏ュ伐鑹鸿矾绾垮伐搴忚〃
+     */
+    private void syncRoutingOperationsByBom(TechnologyRouting technologyRouting) {
+        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, technologyRouting.getBomId())
+                        .orderByAsc(TechnologyBomStructure::getId)
+        );
+        if (bomStructures.isEmpty()) {
+            throw new ServiceException("bom浜у搧缁撴瀯涓虹┖锛�");
+        }
+
+        Map<Long, TechnologyBomStructure> structureById = new HashMap<>();
+        Map<Long, List<TechnologyBomStructure>> childrenByParentId = new LinkedHashMap<>();
+        List<TechnologyBomStructure> rootList = new ArrayList<>();
+        for (TechnologyBomStructure bomStructure : bomStructures) {
+            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 (String dedupKey : sortedDedupKeys) {
+            TechnologyBomStructure bomStructure = operationNodeByKey.get(dedupKey);
+            TechnologyRoutingOperation routingOperation = new TechnologyRoutingOperation();
+            routingOperation.setTechnologyRoutingId(technologyRouting.getId());
+            routingOperation.setProductModelId(resolveOutputProductModelId(bomStructure, structureById, technologyRouting.getProductModelId()));
+            routingOperation.setTechnologyOperationId(bomStructure.getOperationId());
+            routingOperation.setDragSort(dragSort++);
+            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 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) {
+        String dateStr = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd"));
+        String idStr = String.format("%06d", id);
+        return "GYLX" + dateStr + idStr;
+    }
+
+    private boolean isNotBlank(String value) {
+        return value != null && !value.trim().isEmpty();
+    }
 }

--
Gitblit v1.9.3