From f088078e626e16b28d69cdbcbf514b30f1dcefe7 Mon Sep 17 00:00:00 2001
From: buhuazhen <hua100783@gmail.com>
Date: 星期三, 22 四月 2026 11:51:58 +0800
Subject: [PATCH] refactor(production): 优化生产订单及工单号生成逻辑

---
 src/main/java/com/ruoyi/production/service/impl/ProductOrderServiceImpl.java |   64 +++++++++++++-------------------
 1 files changed, 26 insertions(+), 38 deletions(-)

diff --git a/src/main/java/com/ruoyi/production/service/impl/ProductOrderServiceImpl.java b/src/main/java/com/ruoyi/production/service/impl/ProductOrderServiceImpl.java
index 8a1099c..81ac09e 100644
--- a/src/main/java/com/ruoyi/production/service/impl/ProductOrderServiceImpl.java
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductOrderServiceImpl.java
@@ -7,16 +7,16 @@
 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.enums.StockOutQualifiedRecordTypeEnum;
-import com.ruoyi.common.enums.StockInUnQualifiedRecordTypeEnum;
 import com.ruoyi.procurementrecord.utils.StockUtils;
 import com.ruoyi.production.dto.ProductOrderDto;
 import com.ruoyi.production.dto.ProductStructureDto;
 import com.ruoyi.production.mapper.*;
 import com.ruoyi.production.pojo.*;
 import com.ruoyi.production.service.ProductOrderService;
+import com.ruoyi.production.service.ProductProcessService;
+import com.ruoyi.production.service.ProductWorkOrderService;
 import com.ruoyi.quality.mapper.QualityInspectMapper;
-import com.ruoyi.quality.pojo.QualityInspect;
+import lombok.RequiredArgsConstructor;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 
@@ -24,44 +24,37 @@
 import java.time.LocalDate;
 import java.time.format.DateTimeFormatter;
 import java.util.List;
+import java.util.Map;
 import java.util.stream.Collectors;
 
 @Service
+@RequiredArgsConstructor
 public class ProductOrderServiceImpl extends ServiceImpl<ProductOrderMapper, ProductOrder> implements ProductOrderService {
 
+    private final ProductWorkOrderService productWorkOrderService;
+    private final ProductProcessService productProcessService;
     @Autowired
     private ProductOrderMapper productOrderMapper;
-
     @Autowired
     private ProcessRouteMapper processRouteMapper;
-
     @Autowired
     private ProductProcessRouteMapper productProcessRouteMapper;
-
     @Autowired
     private ProcessRouteItemMapper processRouteItemMapper;
-
     @Autowired
     private ProductProcessRouteItemMapper productProcessRouteItemMapper;
-
     @Autowired
     private ProductWorkOrderMapper productWorkOrderMapper;
-
     @Autowired
     private ProductionProductMainMapper productionProductMainMapper;
-
     @Autowired
     private ProductionProductOutputMapper productionProductOutputMapper;
-
     @Autowired
     private ProductionProductInputMapper productionProductInputMapper;
-
     @Autowired
     private QualityInspectMapper qualityInspectMapper;
-
     @Autowired
     private SalesLedgerProductionAccountingMapper salesLedgerProductionAccountingMapper;
-
     @Autowired
     private StockUtils stockUtils;
 
@@ -82,8 +75,12 @@
         productProcessRouteMapper.insert(productProcessRoute);
         //鏂板鐢熶骇璁㈠崟涓嬬殑宸ヨ壓璺嚎瀛愯〃
         List<ProcessRouteItem> processRouteItems = processRouteItemMapper.selectList(new QueryWrapper<ProcessRouteItem>().lambda().eq(ProcessRouteItem::getRouteId, processRoute.getId()));
+        Map<Long, ProductProcess> productProcessMap = productProcessService
+                .list(new LambdaQueryWrapper<ProductProcess>().in(ProductProcess::getId, processRouteItems.stream().map(ProcessRouteItem::getProcessId).collect(Collectors.toList())))
+                .stream()
+                .collect(Collectors.toMap(ProductProcess::getId, productProcess -> productProcess));
+
         // 鐢熸垚褰撳墠鏃ユ湡鐨勫墠缂�锛氬勾鏈堟棩
-        String datePrefix = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd"));
         for (ProcessRouteItem processRouteItem : processRouteItems) {
             ProductProcessRouteItem productProcessRouteItem = new ProductProcessRouteItem();
             productProcessRouteItem.setProductModelId(processRouteItem.getProductModelId());
@@ -93,28 +90,13 @@
             productProcessRouteItem.setDragSort(processRouteItem.getDragSort());
             int insert = productProcessRouteItemMapper.insert(productProcessRouteItem);
             if (insert > 0) {
-                // 鏌ヨ浠婃棩宸插瓨鍦ㄧ殑鏈�澶у伐鍗曞彿
-                ProductWorkOrder lastWorkOrder = productWorkOrderMapper.selectMax(datePrefix);
-                int sequenceNumber = 1; // 榛樿搴忓彿
-                if (lastWorkOrder != null && lastWorkOrder.getWorkOrderNo() != null) {
-                    String lastNo = lastWorkOrder.getWorkOrderNo().toString();
-                    if (lastNo.startsWith(datePrefix)) {
-                        String seqStr = lastNo.substring(datePrefix.length());
-                        try {
-                            sequenceNumber = Integer.parseInt(seqStr) + 1;
-                        } catch (NumberFormatException e) {
-                            sequenceNumber = 1;
-                        }
-                    }
-                }
-                // 鐢熸垚瀹屾暣鐨勫伐鍗曞彿
-                String workOrderNoStr = "GD" + String.format("%s%03d", datePrefix, sequenceNumber);
+
                 ProductWorkOrder productWorkOrder = new ProductWorkOrder();
                 productWorkOrder.setProductProcessRouteItemId(productProcessRouteItem.getId());
                 productWorkOrder.setProductOrderId(productOrder.getId());
                 ProductOrder order = productOrderMapper.selectById(productOrder.getId());
                 productWorkOrder.setPlanQuantity(order.getQuantity());
-                productWorkOrder.setWorkOrderNo(workOrderNoStr);
+                productWorkOrder.setWorkOrderNo(productWorkOrderService.generateProductWorkOrder(null, productProcessMap.getOrDefault(productProcessRouteItem.getProcessId(), new ProductProcess()).getName(), productOrder.getNpsNo()));
                 productWorkOrder.setStatus(1);
                 productWorkOrderMapper.insert(productWorkOrder);
             }
@@ -149,11 +131,11 @@
         //濡傛灉宸茬粡寮�濮嬬敓浜�,涓嶈兘鍒犻櫎
         //鏌ヨ鐢熶骇璁㈠崟涓嬬殑宸ュ崟
         List<ProductWorkOrder> productWorkOrders = productWorkOrderMapper.selectList(Wrappers.<ProductWorkOrder>lambdaQuery().in(ProductWorkOrder::getProductOrderId, ids));
-        if (productWorkOrders.size()>0){
+        if (productWorkOrders.size() > 0) {
             //鍒ゆ柇鏄惁鏈夋姤宸ユ暟鎹�
             List<ProductionProductMain> productionProductMains = productionProductMainMapper.selectList(Wrappers.<ProductionProductMain>lambdaQuery()
                     .in(ProductionProductMain::getWorkOrderId, productWorkOrders.stream().map(ProductWorkOrder::getId).collect(Collectors.toList())));
-            if (productionProductMains.size()>0){
+            if (productionProductMains.size() > 0) {
                 throw new RuntimeException("鐢熶骇璁㈠崟宸茬粡寮�濮嬬敓浜�,涓嶈兘鍒犻櫎");
             }
             //鍒犻櫎宸ュ崟
@@ -184,8 +166,16 @@
     }
 
     public String generateNextOrderNo(String datePrefix) {
-        String maxOrderNo = getMaxOrderNoByDate(datePrefix);
+        return "SC" + datePrefix + formatOrderSequence(datePrefix);
+    }
+
+    public String generateNextOrderByContractNo(String datePrefix, String contractNo) {
+        return contractNo + formatOrderSequence(datePrefix);
+    }
+
+    private String formatOrderSequence(String datePrefix) {
         int sequence = 1; // 榛樿璧峰搴忓彿
+        String maxOrderNo = getMaxOrderNoByDate(datePrefix);
         if (maxOrderNo != null && !maxOrderNo.isEmpty()) {
             // 鎻愬彇娴佹按鍙烽儴鍒嗭紙鍋囪鏍煎紡涓� SC + 鏃ユ湡 + 娴佹按鍙凤級
             String sequenceStr = maxOrderNo.substring(("SC" + datePrefix).length());
@@ -196,9 +186,7 @@
                 sequence = 1;
             }
         }
-        // 鐢熸垚鏂拌鍗曞彿
-        return "SC" + datePrefix + String.format("%04d", sequence);
+        return String.format("%04d", sequence);
     }
-
 
 }

--
Gitblit v1.9.3