From 4c8144cc2785cdb8c5529c6c59a8901a33ec06bb Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期五, 24 四月 2026 17:55:00 +0800
Subject: [PATCH] feat:1.生产计划下发 2.订单-工艺路线,bom,工序

---
 src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java |  179 +++++++++++++++++++++++++++++++++--------------------------
 1 files changed, 99 insertions(+), 80 deletions(-)

diff --git a/src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java b/src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java
index e48509e..b05665f 100644
--- a/src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java
@@ -2,6 +2,7 @@
 
 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;
@@ -15,60 +16,24 @@
 import com.ruoyi.common.exception.ServiceException;
 import com.ruoyi.production.bean.dto.ProductionOrderDto;
 import com.ruoyi.production.bean.vo.ProductionOrderVo;
-import com.ruoyi.production.mapper.ProductionBomStructureMapper;
-import com.ruoyi.production.mapper.ProductionOperationTaskMapper;
-import com.ruoyi.production.mapper.ProductionOrderBomMapper;
-import com.ruoyi.production.mapper.ProductionOrderMapper;
-import com.ruoyi.production.mapper.ProductionOrderPickMapper;
-import com.ruoyi.production.mapper.ProductionOrderPickRecordMapper;
-import com.ruoyi.production.mapper.ProductionOrderRoutingMapper;
-import com.ruoyi.production.mapper.ProductionOrderRoutingOperationMapper;
-import com.ruoyi.production.mapper.ProductionOrderRoutingOperationParamMapper;
-import com.ruoyi.production.mapper.ProductionPlanMapper;
-import com.ruoyi.production.mapper.ProductionProductMainMapper;
-import com.ruoyi.production.pojo.ProductionOrderPick;
-import com.ruoyi.production.pojo.ProductionOrderPickRecord;
-import com.ruoyi.production.pojo.ProductionBomStructure;
-import com.ruoyi.production.pojo.ProductionOperationTask;
-import com.ruoyi.production.pojo.ProductionOrder;
-import com.ruoyi.production.pojo.ProductionOrderBom;
-import com.ruoyi.production.pojo.ProductionOrderRouting;
-import com.ruoyi.production.pojo.ProductionOrderRoutingOperation;
-import com.ruoyi.production.pojo.ProductionOrderRoutingOperationParam;
-import com.ruoyi.production.pojo.ProductionPlan;
-import com.ruoyi.production.pojo.ProductionProductMain;
 import com.ruoyi.production.enums.ProductOrderStatusEnum;
+import com.ruoyi.production.mapper.*;
+import com.ruoyi.production.pojo.*;
+import com.ruoyi.production.service.ProductionOrderService;
 import com.ruoyi.sales.mapper.SalesLedgerMapper;
 import com.ruoyi.sales.mapper.SalesLedgerProductMapper;
 import com.ruoyi.sales.pojo.SalesLedger;
 import com.ruoyi.sales.pojo.SalesLedgerProduct;
-import com.ruoyi.production.service.ProductionOrderService;
-import com.ruoyi.technology.mapper.TechnologyBomMapper;
-import com.ruoyi.technology.mapper.TechnologyBomStructureMapper;
-import com.ruoyi.technology.mapper.TechnologyRoutingMapper;
-import com.ruoyi.technology.mapper.TechnologyRoutingOperationMapper;
-import com.ruoyi.technology.mapper.TechnologyRoutingOperationParamMapper;
-import com.ruoyi.technology.pojo.TechnologyBom;
-import com.ruoyi.technology.pojo.TechnologyBomStructure;
-import com.ruoyi.technology.pojo.TechnologyRouting;
-import com.ruoyi.technology.pojo.TechnologyRoutingOperation;
-import com.ruoyi.technology.pojo.TechnologyRoutingOperationParam;
+import com.ruoyi.technology.mapper.*;
+import com.ruoyi.technology.pojo.*;
 import lombok.RequiredArgsConstructor;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 
 import java.math.BigDecimal;
 import java.time.LocalDate;
-import java.time.LocalDateTime;
 import java.time.format.DateTimeFormatter;
-import java.util.ArrayList;
-import java.util.Comparator;
-import java.util.HashMap;
-import java.util.LinkedHashSet;
-import java.util.List;
-import java.util.Map;
-import java.util.Objects;
-import java.util.Set;
+import java.util.*;
 import java.util.stream.Collectors;
 
 @Service
@@ -93,12 +58,13 @@
     private final TechnologyRoutingMapper technologyRoutingMapper;
     private final TechnologyRoutingOperationMapper technologyRoutingOperationMapper;
     private final TechnologyRoutingOperationParamMapper technologyRoutingOperationParamMapper;
+    private final TechnologyOperationMapper technologyOperationMapper;
     private final TechnologyBomMapper technologyBomMapper;
     private final TechnologyBomStructureMapper technologyBomStructureMapper;
     private final FileUtil fileUtil;
 
     @Override
-    public com.baomidou.mybatisplus.core.metadata.IPage<ProductionOrderVo> pageProductionOrder(Page<ProductionOrderDto> page, ProductionOrderDto dto) {
+    public IPage<ProductionOrderVo> pageProductionOrder(Page<ProductionOrderDto> page, ProductionOrderDto dto) {
         Page<ProductionOrderVo> result = (Page<ProductionOrderVo>) baseMapper.pageProductionOrder(page, dto);
         fillProductImages(result.getRecords());
         return result;
@@ -171,20 +137,64 @@
     }
 
     @Override
+    public Integer bindingRoute(ProductionOrderDto productionOrderDto) {
+        if (productionOrderDto == null || productionOrderDto.getId() == null) {
+            throw new ServiceException("鐢熶骇璁㈠崟ID涓嶈兘涓虹┖");
+        }
+        ProductionOrder productionOrder = this.getById(productionOrderDto.getId());
+        if (productionOrder == null) {
+            throw new ServiceException("鐢熶骇璁㈠崟涓嶅瓨鍦�");
+        }
+
+        Long targetRoutingId = productionOrderDto.getTechnologyRoutingId() == null
+                ? productionOrder.getTechnologyRoutingId()
+                : productionOrderDto.getTechnologyRoutingId();
+        if (targetRoutingId == null) {
+            throw new ServiceException("宸ヨ壓璺嚎ID涓嶈兘涓虹┖");
+        }
+        TechnologyRouting targetRouting = technologyRoutingMapper.selectById(targetRoutingId);
+        if (targetRouting == null) {
+            throw new ServiceException("宸ヨ壓璺嚎涓嶅瓨鍦�");
+        }
+        if (productionOrder.getProductModelId() != null
+                && !Objects.equals(productionOrder.getProductModelId(), targetRouting.getProductModelId())) {
+            throw new ServiceException("宸ヨ壓璺嚎涓庣敓浜ц鍗曚骇鍝佽鏍间笉鍖归厤");
+        }
+
+        if (ProductOrderStatusEnum.isStarted(productionOrder.getStatus())
+                && !Objects.equals(productionOrder.getTechnologyRoutingId(), targetRoutingId)) {
+            throw new ServiceException("鐢熶骇璁㈠崟宸插紑宸ワ紝涓嶈兘淇敼宸ヨ壓璺嚎");
+        }
+
+        if (!Objects.equals(productionOrder.getTechnologyRoutingId(), targetRoutingId)) {
+            ProductionOrder update = new ProductionOrder();
+            update.setId(productionOrder.getId());
+            update.setTechnologyRoutingId(targetRoutingId);
+            if (!this.updateById(update)) {
+                throw new ServiceException("缁戝畾宸ヨ壓璺嚎澶辫触");
+            }
+        }
+
+        // 缁戝畾璺嚎浠呴噸寤鸿鍗曚晶蹇収鏁版嵁
+        return syncProductionOrderSnapshot(productionOrder.getId());
+    }
+
+    @Override
     public int syncProductionOrderSnapshot(Long productionOrderId) {
         ProductionOrder productionOrder = this.getById(productionOrderId);
         if (productionOrder == null) {
-            throw new ServiceException("Production order not found");
+            throw new ServiceException("鐢熶骇璁㈠崟涓嶅瓨鍦�");
         }
         if (productionOrder.getTechnologyRoutingId() == null) {
-            throw new ServiceException("technologyRoutingId is required");
+            throw new ServiceException("宸ヨ壓璺嚎ID涓嶈兘涓虹┖");
         }
         TechnologyRouting technologyRouting = technologyRoutingMapper.selectById(productionOrder.getTechnologyRoutingId());
         if (technologyRouting == null) {
-            throw new ServiceException("Technology routing not found");
+            throw new ServiceException("宸ヨ壓璺嚎涓嶅瓨鍦�");
         }
         // 璁㈠崟蹇収鎸夆�滃厛娓呭悗寤衡�濆鐞嗭紝淇濊瘉宸ヨ壓璺嚎銆佸伐搴忋�佸弬鏁般�丅OM 鍏ㄩ儴鏉ヨ嚜鍚屼竴鐗堟湰銆�
         clearProductionSnapshot(productionOrderId);
+        ProductionOrderBom orderBom = syncProductionOrderBomSnapshot(productionOrder, technologyRouting);
 
         ProductionOrderRouting orderRouting = new ProductionOrderRouting();
         orderRouting.setProductionOrderId(productionOrder.getId());
@@ -193,6 +203,7 @@
         orderRouting.setProcessRouteCode(technologyRouting.getProcessRouteCode());
         orderRouting.setDescription(technologyRouting.getDescription());
         orderRouting.setBomId(technologyRouting.getBomId());
+        orderRouting.setOrderBomId(orderBom == null ? null : orderBom.getId());
         productionOrderRoutingMapper.insert(orderRouting);
 
         int syncedParamCount = 0;
@@ -201,6 +212,13 @@
                         .eq(TechnologyRoutingOperation::getTechnologyRoutingId, technologyRouting.getId())
                         .orderByAsc(TechnologyRoutingOperation::getDragSort)
                         .orderByAsc(TechnologyRoutingOperation::getId));
+        Map<Long, String> operationNameMap = technologyOperationMapper.selectBatchIds(
+                        routingOperations.stream()
+                                .map(TechnologyRoutingOperation::getTechnologyOperationId)
+                                .filter(Objects::nonNull)
+                                .collect(Collectors.toSet()))
+                .stream()
+                .collect(Collectors.toMap(TechnologyOperation::getId, TechnologyOperation::getName, (a, b) -> a));
         for (TechnologyRoutingOperation sourceOperation : routingOperations) {
             // 璁㈠崟宸ュ簭淇濆瓨鐨勬槸宸ヨ壓宸ュ簭蹇収锛屽悗缁姤宸ュ彧渚濊禆蹇収锛屼笉鍐嶇洿鎺ュ紩鐢ㄥ伐鑹轰富鏁版嵁銆�
             ProductionOrderRoutingOperation targetOperation = new ProductionOrderRoutingOperation();
@@ -210,6 +228,7 @@
             targetOperation.setProductModelId(sourceOperation.getProductModelId());
             targetOperation.setDragSort(sourceOperation.getDragSort());
             targetOperation.setIsQuality(sourceOperation.getIsQuality());
+            targetOperation.setOperationName(operationNameMap.get(sourceOperation.getTechnologyOperationId()));
             productionOrderRoutingOperationMapper.insert(targetOperation);
 
             ProductionOperationTask task = new ProductionOperationTask();
@@ -247,18 +266,17 @@
             }
         }
 
-        syncProductionOrderBomSnapshot(productionOrder, technologyRouting);
         upsertOrderPick(productionOrder);
         return syncedParamCount;
     }
 
-    private void syncProductionOrderBomSnapshot(ProductionOrder productionOrder, TechnologyRouting technologyRouting) {
+    private ProductionOrderBom syncProductionOrderBomSnapshot(ProductionOrder productionOrder, TechnologyRouting technologyRouting) {
         if (technologyRouting.getBomId() == null) {
-            return;
+            return null;
         }
         TechnologyBom technologyBom = technologyBomMapper.selectById(technologyRouting.getBomId());
         if (technologyBom == null) {
-            throw new ServiceException("Technology BOM not found");
+            throw new ServiceException("宸ヨ壓BOM涓嶅瓨鍦�");
         }
         List<TechnologyBomStructure> structureList = technologyBomStructureMapper.selectList(
                 Wrappers.<TechnologyBomStructure>lambdaQuery()
@@ -292,6 +310,7 @@
             productionBomStructureMapper.insert(target);
             idMap.put(source.getId(), target.getId());
         }
+        return orderBom;
     }
 
     private void clearProductionSnapshot(Long productionOrderId) {
@@ -300,7 +319,7 @@
                 Wrappers.<ProductionOrderPickRecord>lambdaQuery()
                         .eq(ProductionOrderPickRecord::getProductionOrderId, productionOrderId)) > 0;
         if (hasPickRecord) {
-            throw new ServiceException("Production order pick records already exist, snapshot cannot be regenerated");
+            throw new ServiceException("鐢熶骇璁㈠崟宸插瓨鍦ㄩ鏂欒褰曪紝涓嶈兘閲嶆柊鐢熸垚蹇収");
         }
         List<Long> taskIds = productionOperationTaskMapper.selectList(
                         Wrappers.<ProductionOperationTask>lambdaQuery()
@@ -312,7 +331,7 @@
                     Wrappers.<ProductionProductMain>lambdaQuery()
                             .in(ProductionProductMain::getProductionOperationTaskId, taskIds)) > 0;
             if (started) {
-                throw new ServiceException("Production order already started, snapshot cannot be regenerated");
+                throw new ServiceException("鐢熶骇璁㈠崟宸插紑宸ワ紝涓嶈兘閲嶆柊鐢熸垚蹇収");
             }
             productionOperationTaskMapper.delete(Wrappers.<ProductionOperationTask>lambdaQuery()
                     .eq(ProductionOperationTask::getProductionOrderId, productionOrderId));
@@ -385,56 +404,56 @@
 
     private void validateAndFillOrder(ProductionOrder productionOrder, ProductionOrder oldOrder) {
         if (productionOrder == null) {
-            throw new ServiceException("Production order is required");
+            throw new ServiceException("鐢熶骇璁㈠崟涓嶈兘涓虹┖");
         }
         fillFromSalesLedgerProduct(productionOrder);
         fillFromProductionPlans(productionOrder);
         if (productionOrder.getProductModelId() == null) {
-            throw new ServiceException("productModelId is required");
+            throw new ServiceException("浜у搧瑙勬牸ID涓嶈兘涓虹┖");
         }
         if (defaultDecimal(productionOrder.getQuantity()).compareTo(BigDecimal.ZERO) <= 0) {
-            throw new ServiceException("quantity must be greater than 0");
+            throw new ServiceException("涓嬪崟鏁伴噺蹇呴』澶т簬0");
         }
-        if (productionOrder.getTechnologyRoutingId() == null) {
-            // 鏈樉寮忔寚瀹氬伐鑹鸿矾绾挎椂锛屾寜浜у搧瑙勬牸閫夋渶鏂颁竴鏉″伐鑹轰綔涓洪粯璁よ矾绾裤��
-            TechnologyRouting technologyRouting = technologyRoutingMapper.selectOne(
-                    Wrappers.<TechnologyRouting>lambdaQuery()
-                            .eq(TechnologyRouting::getProductModelId, productionOrder.getProductModelId())
-                            .orderByDesc(TechnologyRouting::getId)
-                            .last("limit 1"));
-            if (technologyRouting == null) {
-                throw new ServiceException("No technology routing found for the product model");
-            }
-            productionOrder.setTechnologyRoutingId(technologyRouting.getId());
-        }
+//        if (productionOrder.getTechnologyRoutingId() == null) {
+//            // 鏈樉寮忔寚瀹氬伐鑹鸿矾绾挎椂锛屾寜浜у搧瑙勬牸閫夋渶鏂颁竴鏉″伐鑹轰綔涓洪粯璁よ矾绾裤��
+//            TechnologyRouting technologyRouting = technologyRoutingMapper.selectOne(
+//                    Wrappers.<TechnologyRouting>lambdaQuery()
+//                            .eq(TechnologyRouting::getProductModelId, productionOrder.getProductModelId())
+//                            .orderByDesc(TechnologyRouting::getId)
+//                            .last("limit 1"));
+//            if (technologyRouting == null) {
+//                throw new ServiceException("鏈壘鍒拌浜у搧瑙勬牸瀵瑰簲鐨勫伐鑹鸿矾绾�");
+//            }
+//            productionOrder.setTechnologyRoutingId(technologyRouting.getId());
+//        }
         if (oldOrder != null && ProductOrderStatusEnum.isStarted(oldOrder.getStatus())) {
             // 寮�宸ュ悗鍙厑璁镐慨姝i潪鏍稿績瀛楁锛屾牳蹇冪敓浜т緷鎹攣瀹氥��
             if (!Objects.equals(oldOrder.getProductModelId(), productionOrder.getProductModelId())
                     || !Objects.equals(oldOrder.getTechnologyRoutingId(), productionOrder.getTechnologyRoutingId())
                     || compareDecimal(oldOrder.getQuantity(), productionOrder.getQuantity()) != 0) {
-                throw new ServiceException("Started production orders cannot modify product, routing or quantity");
+                throw new ServiceException("鐢熶骇璁㈠崟宸插紑宸ワ紝涓嶈兘淇敼浜у搧銆佸伐鑹鸿矾绾挎垨鏁伴噺");
             }
         }
     }
 
     private void fillFromSalesLedgerProduct(ProductionOrder productionOrder) {
-        if (productionOrder.getSaleLedgerProductId() == null) {
+        if (productionOrder.getSalesLedgerProductId() == null) {
             return;
         }
         // 閿�鍞槑缁嗘槸璁㈠崟鏉ユ簮鏃讹紝浠ラ攢鍞槑缁嗕负鍑嗗洖濉攢鍞彴璐︺�佷骇鍝佽鏍煎拰榛樿鏁伴噺銆�
-        SalesLedgerProduct salesLedgerProduct = salesLedgerProductMapper.selectById(productionOrder.getSaleLedgerProductId().longValue());
+        SalesLedgerProduct salesLedgerProduct = salesLedgerProductMapper.selectById(productionOrder.getSalesLedgerProductId().longValue());
         if (salesLedgerProduct == null) {
-            throw new ServiceException("Sales ledger product not found");
+            throw new ServiceException("閿�鍞彴璐︿骇鍝佷笉瀛樺湪");
         }
         if (productionOrder.getSalesLedgerId() == null) {
             productionOrder.setSalesLedgerId(salesLedgerProduct.getSalesLedgerId());
         } else if (!Objects.equals(productionOrder.getSalesLedgerId(), salesLedgerProduct.getSalesLedgerId())) {
-            throw new ServiceException("salesLedgerId does not match the sales ledger product");
+            throw new ServiceException("閿�鍞彴璐D涓庨攢鍞彴璐︿骇鍝佷笉涓�鑷�");
         }
         if (productionOrder.getProductModelId() == null) {
             productionOrder.setProductModelId(salesLedgerProduct.getProductModelId());
         } else if (!Objects.equals(productionOrder.getProductModelId(), salesLedgerProduct.getProductModelId())) {
-            throw new ServiceException("productModelId does not match the sales ledger product");
+            throw new ServiceException("浜у搧瑙勬牸ID涓庨攢鍞彴璐︿骇鍝佷笉涓�鑷�");
         }
         if (productionOrder.getQuantity() == null || productionOrder.getQuantity().compareTo(BigDecimal.ZERO) <= 0) {
             productionOrder.setQuantity(salesLedgerProduct.getQuantity());
@@ -455,22 +474,22 @@
         // 澶氳鍒掑悎骞惰浆鍗曟椂锛屾墍鏈夎鍒掑繀椤诲睘浜庡悓涓�瑙勬牸锛屼笖鍙兘涓嬪彂涓�娆°��
         List<ProductionPlan> productionPlans = productionPlanMapper.selectBatchIds(planIds);
         if (productionPlans.size() != planIds.size()) {
-            throw new ServiceException("Some production plans do not exist");
+            throw new ServiceException("閮ㄥ垎鐢熶骇璁″垝涓嶅瓨鍦�");
         }
         Set<Long> productModelIds = productionPlans.stream()
                 .map(ProductionPlan::getProductModelId)
                 .collect(Collectors.toSet());
         if (productModelIds.size() > 1) {
-            throw new ServiceException("Selected production plans must belong to the same product model");
+            throw new ServiceException("鎵�閫夌敓浜ц鍒掑繀椤诲睘浜庡悓涓�浜у搧瑙勬牸");
         }
-        if (Boolean.TRUE.equals(productionPlans.stream().anyMatch(item -> Boolean.TRUE.equals(item.getIssued())))) {
-            throw new ServiceException("Selected production plans already issued");
+        if (productionPlans.stream().anyMatch(item -> item.getStatus() != null && item.getStatus() == 2)) {
+            throw new ServiceException("鎵�閫夌敓浜ц鍒掑凡涓嬪彂");
         }
         ProductionPlan firstPlan = productionPlans.get(0);
         if (productionOrder.getProductModelId() == null) {
             productionOrder.setProductModelId(firstPlan.getProductModelId());
         } else if (!Objects.equals(productionOrder.getProductModelId(), firstPlan.getProductModelId())) {
-            throw new ServiceException("productModelId does not match the production plans");
+            throw new ServiceException("浜у搧瑙勬牸ID涓庣敓浜ц鍒掍笉涓�鑷�");
         }
         if (productionOrder.getQuantity() == null || productionOrder.getQuantity().compareTo(BigDecimal.ZERO) <= 0) {
             productionOrder.setQuantity(productionPlans.stream()
@@ -591,10 +610,10 @@
             return null;
         }
         if (productionPlan.getPromisedDeliveryDate() != null) {
-            return productionPlan.getPromisedDeliveryDate().toLocalDate();
+            return productionPlan.getPromisedDeliveryDate();
         }
         if (productionPlan.getRequiredDate() != null) {
-            return productionPlan.getRequiredDate().toLocalDate();
+            return productionPlan.getRequiredDate();
         }
         return null;
     }

--
Gitblit v1.9.3