From 7e8edd4b59fb22146b90d01ca38f75148f3fd774 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期一, 20 四月 2026 17:57:18 +0800
Subject: [PATCH] feat(bom): 添加BOM管理功能模块,工序 管理,基础 - 新增CustomerPrivatePoolMapper.xml实现客户私池映射 - 添加SysLoginController支持登录验证和用户信息获取 - 创建TechnologyBomController提供BOM的增删改查接口 - 定义TechnologyBomDto数据传输对象 - 实现TechnologyBomMapper和相关XML映射文件 - 开发TechnologyBomService业务逻辑层 - 添加TechnologyBomStructure结构管理功能 - 集成Excel导入导出BOM数据功能 - 实现BOM结构树形展示和维护功能

---
 src/main/java/com/ruoyi/technology/service/impl/TechnologyRoutingServiceImpl.java |  114 ++++++++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 97 insertions(+), 17 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 91ffbbf..62b74e6 100644
--- a/src/main/java/com/ruoyi/technology/service/impl/TechnologyRoutingServiceImpl.java
+++ b/src/main/java/com/ruoyi/technology/service/impl/TechnologyRoutingServiceImpl.java
@@ -1,53 +1,85 @@
 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;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+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.technology.service.TechnologyRoutingService;
-import org.springframework.beans.factory.annotation.Autowired;
+import lombok.RequiredArgsConstructor;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 
 import java.time.LocalDate;
 import java.time.format.DateTimeFormatter;
+import java.util.LinkedHashMap;
 import java.util.List;
+import java.util.Map;
 
 @Service
 @Transactional(rollbackFor = Exception.class)
+@RequiredArgsConstructor
 public class TechnologyRoutingServiceImpl extends ServiceImpl<TechnologyRoutingMapper, TechnologyRouting> implements TechnologyRoutingService {
 
-    @Autowired
-    private TechnologyRoutingMapper technologyRoutingMapper;
+    private final TechnologyRoutingMapper technologyRoutingMapper;
 
-    @Autowired
-    private TechnologyRoutingOperationMapper technologyRoutingOperationMapper;
+    private final TechnologyRoutingOperationMapper technologyRoutingOperationMapper;
+
+    private final TechnologyBomStructureMapper technologyBomStructureMapper;
+
+    private final TechnologyOperationMapper technologyOperationMapper;
 
     @Override
-    public IPage<TechnologyRouting> pageTechnologyRouting(Page<TechnologyRouting> page, TechnologyRouting technologyRouting) {
+    public IPage<TechnologyRoutingVo> pageTechnologyRouting(Page<TechnologyRoutingDto> page, TechnologyRoutingDto technologyRoutingDto) {
         LambdaQueryWrapper<TechnologyRouting> queryWrapper = Wrappers.lambdaQuery();
-        queryWrapper.eq(technologyRouting.getId() != null, TechnologyRouting::getId, technologyRouting.getId())
-                .eq(technologyRouting.getProductModelId() != null, TechnologyRouting::getProductModelId, technologyRouting.getProductModelId())
-                .eq(technologyRouting.getBomId() != null, TechnologyRouting::getBomId, technologyRouting.getBomId())
-                .like(isNotBlank(technologyRouting.getProcessRouteCode()), TechnologyRouting::getProcessRouteCode, technologyRouting.getProcessRouteCode())
-                .like(isNotBlank(technologyRouting.getDescription()), TechnologyRouting::getDescription, technologyRouting.getDescription())
+        queryWrapper.eq(technologyRoutingDto.getId() != null, TechnologyRouting::getId, technologyRoutingDto.getId())
+                .eq(technologyRoutingDto.getProductModelId() != null, TechnologyRouting::getProductModelId, technologyRoutingDto.getProductModelId())
+                .eq(technologyRoutingDto.getBomId() != null, TechnologyRouting::getBomId, technologyRoutingDto.getBomId())
+                .like(isNotBlank(technologyRoutingDto.getProcessRouteCode()), TechnologyRouting::getProcessRouteCode, technologyRoutingDto.getProcessRouteCode())
+                .like(isNotBlank(technologyRoutingDto.getDescription()), TechnologyRouting::getDescription, technologyRoutingDto.getDescription())
                 .orderByDesc(TechnologyRouting::getId);
-        return this.page(page, queryWrapper);
+        Page<TechnologyRouting> entityPage = new Page<>(page.getCurrent(), page.getSize(), page.getTotal());
+        return this.page(entityPage, queryWrapper).convert(item -> BeanUtil.copyProperties(item, TechnologyRoutingVo.class));
+    }
+
+    @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) {
-        this.save(technologyRouting);
-        if (!isNotBlank(technologyRouting.getProcessRouteCode())) {
-            technologyRouting.setProcessRouteCode(buildProcessRouteCode(technologyRouting.getId()));
-            technologyRoutingMapper.updateById(technologyRouting);
-        }
+        String code = OrderUtils.countTodayByCreateTime(technologyRoutingMapper, "GYLX", "process_route_code");
+        technologyRouting.setProcessRouteCode(code);
+        // 甯﹀叆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
@@ -60,6 +92,54 @@
         return this.removeByIds(ids);
     }
 
+    /**
+     * 鎸夊綋鍓嶉�夋嫨鐨� BOM 閲嶅缓宸ヨ壓璺嚎宸ュ簭锛�
+     * 1. 鍏堝垹闄よ宸ヨ壓璺嚎涓嬪凡鏈夊伐搴�
+     * 2. 璇诲彇 BOM 缁撴瀯涓殑 operation_id
+     * 3. 鎸� BOM 鍑虹幇椤哄簭鍘婚噸鍚庨噸鏂板啓鍏ュ伐鑹鸿矾绾垮伐搴忚〃
+     */
+    private void syncRoutingOperationsByBom(TechnologyRouting technologyRouting) {
+        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)
+                        .orderByAsc(TechnologyBomStructure::getId)
+        );
+        if (bomStructures.isEmpty()) {
+            return;
+        }
+
+        // 鍚屼竴涓� BOM 涓彲鑳介噸澶嶅紩鐢ㄧ浉鍚屽伐搴忥紝杩欓噷鎸夐娆″嚭鐜伴『搴忓幓閲嶃��
+        Map<Long, TechnologyBomStructure> uniqueOperationMap = new LinkedHashMap<>();
+        for (TechnologyBomStructure bomStructure : bomStructures) {
+            uniqueOperationMap.putIfAbsent(bomStructure.getOperationId(), bomStructure);
+        }
+
+        int dragSort = 1;
+        for (TechnologyBomStructure bomStructure : uniqueOperationMap.values()) {
+            TechnologyRoutingOperation routingOperation = new TechnologyRoutingOperation();
+            routingOperation.setTechnologyRoutingId(technologyRouting.getId());
+            routingOperation.setProductModelId(technologyRouting.getProductModelId());
+            routingOperation.setTechnologyOperationId(bomStructure.getOperationId());
+            routingOperation.setDragSort(dragSort++);
+            routingOperation.setIsQuality(getOperationQuality(bomStructure.getOperationId()));
+            technologyRoutingOperationMapper.insert(routingOperation);
+        }
+    }
+
+    /**
+     * 璐ㄦ鏍囪瘑浠ュ伐搴忓熀纭�琛ㄥ畾涔変负鍑嗐��
+     */
+    private Boolean getOperationQuality(Long operationId) {
+        TechnologyOperation technologyOperation = technologyOperationMapper.selectById(operationId);
+        return technologyOperation != null ? technologyOperation.getIsQuality() : null;
+    }
+
     private String buildProcessRouteCode(Long id) {
         String dateStr = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd"));
         String idStr = String.format("%06d", id);

--
Gitblit v1.9.3