From 2cffa027595247c136a8ee95f5f745c58cb0cce5 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期六, 09 五月 2026 13:08:12 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev_New_pro' into dev_New_pro

---
 src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java |  405 ++++++++++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 364 insertions(+), 41 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 bb56608..344800c 100644
--- a/src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java
@@ -14,15 +14,28 @@
 import com.ruoyi.basic.utils.FileUtil;
 import com.ruoyi.common.constant.StorageAttachmentConstants;
 import com.ruoyi.common.exception.ServiceException;
+import com.ruoyi.production.bean.dto.ProductionOperationTaskDto;
 import com.ruoyi.production.bean.dto.ProductionOrderDto;
+import com.ruoyi.production.bean.vo.ProductionBomStructureVo;
+import com.ruoyi.production.bean.vo.ProductionOperationTaskVo;
+import com.ruoyi.production.bean.vo.ProductionOrderPickVo;
 import com.ruoyi.production.bean.vo.ProductionOrderVo;
 import com.ruoyi.production.bean.vo.ProductionPlanVo;
+import com.ruoyi.production.bean.vo.ProductionOrderWorkOrderDetailVo;
 import com.ruoyi.production.enums.ProductOrderStatusEnum;
 import com.ruoyi.production.mapper.*;
 import com.ruoyi.production.pojo.*;
+import com.ruoyi.quality.mapper.QualityInspectFileMapper;
+import com.ruoyi.quality.mapper.QualityInspectMapper;
+import com.ruoyi.quality.mapper.QualityInspectParamMapper;
+import com.ruoyi.quality.pojo.QualityInspect;
+import com.ruoyi.quality.pojo.QualityInspectFile;
+import com.ruoyi.quality.pojo.QualityInspectParam;
 import com.ruoyi.production.service.ProductionOrderService;
 import com.ruoyi.sales.mapper.SalesLedgerMapper;
 import com.ruoyi.sales.mapper.SalesLedgerProductMapper;
+import com.ruoyi.stock.mapper.StockInventoryMapper;
+import com.ruoyi.stock.pojo.StockInventory;
 import com.ruoyi.technology.mapper.*;
 import com.ruoyi.technology.pojo.*;
 import lombok.RequiredArgsConstructor;
@@ -47,9 +60,14 @@
     private final ProductionOrderBomMapper productionOrderBomMapper;
     private final ProductionBomStructureMapper productionBomStructureMapper;
     private final ProductionProductMainMapper productionProductMainMapper;
+    private final ProductionProductOutputMapper productionProductOutputMapper;
     private final ProductionOrderPickMapper productionOrderPickMapper;
     private final ProductionOrderPickRecordMapper productionOrderPickRecordMapper;
+    private final QualityInspectMapper qualityInspectMapper;
+    private final QualityInspectParamMapper qualityInspectParamMapper;
+    private final QualityInspectFileMapper qualityInspectFileMapper;
     private final ProductionPlanMapper productionPlanMapper;
+    private final StockInventoryMapper stockInventoryMapper;
     private final StorageAttachmentMapper storageAttachmentMapper;
     private final StorageBlobMapper storageBlobMapper;
     private final SalesLedgerMapper salesLedgerMapper;
@@ -64,6 +82,7 @@
 
     @Override
     public IPage<ProductionOrderVo> pageProductionOrder(Page<ProductionOrderDto> page, ProductionOrderDto dto) {
+        // 鍒嗛〉鏌ヨ鐢熶骇璁㈠崟
         Page<ProductionOrderVo> result = (Page<ProductionOrderVo>) baseMapper.pageProductionOrder(page, dto);
         fillProductImages(result.getRecords());
         return result;
@@ -71,6 +90,7 @@
 
     @Override
     public List<ProductionOrderVo> listProductionOrder(ProductionOrderDto dto) {
+        // 鏌ヨ鐢熶骇璁㈠崟鍒楄〃
         List<ProductionOrderVo> records = baseMapper.listProductionOrder(dto);
         fillProductImages(records);
         return records;
@@ -78,6 +98,7 @@
 
     @Override
     public ProductionOrderVo getProductionOrderInfo(Long id) {
+        // 鑾峰彇鐢熶骇璁㈠崟璇︽儏
         ProductionOrderVo item = baseMapper.getProductionOrderInfo(id);
         if (item == null) {
             return null;
@@ -88,6 +109,7 @@
 
     @Override
     public boolean saveProductionOrder(ProductionOrder productionOrder) {
+        // 淇濆瓨鐢熶骇璁㈠崟
         ProductionOrder oldOrder = productionOrder.getId() == null ? null : this.getById(productionOrder.getId());
         // 涓嬪崟鍏ュ彛缁熶竴琛ラ綈鏉ユ簮鍗曟嵁銆佽鍒掑拰宸ヨ壓淇℃伅锛岄伩鍏嶅墠绔垎鍒紶澶氬瀛楁銆�
         validateAndFillOrder(productionOrder, oldOrder);
@@ -112,17 +134,14 @@
                 || productionOrderRoutingMapper.selectCount(Wrappers.<ProductionOrderRouting>lambdaQuery()
                         .eq(ProductionOrderRouting::getProductionOrderId, productionOrder.getId())) == 0);
         if (needSync) {
-            // 宸ヨ壓銆佷骇鍝佹垨鏁伴噺鍙樺寲鍚庯紝璁㈠崟蹇収蹇呴』鍜屽綋鍓嶄笅鍗曟暟鎹噸鏂板榻愩��
             syncProductionOrderSnapshot(productionOrder.getId());
-        } else {
-            // 鏈噸寤哄揩鐓ф椂锛屼篃瑕佺‘淇濆鏂欎富鍗曞拰璁㈠崟鏁伴噺淇濇寔鍚屾銆�
-            upsertOrderPick(productionOrder);
         }
         return true;
     }
 
     @Override
     public boolean removeProductionOrder(List<Long> ids) {
+        // 鍒犻櫎鐢熶骇璁㈠崟
         if (ids == null || ids.isEmpty()) {
             return false;
         }
@@ -136,6 +155,7 @@
 
     @Override
     public Integer bindingRoute(ProductionOrderDto productionOrderDto) {
+        // 涓鸿鍗曠粦瀹氬伐鑹鸿矾绾�
         if (productionOrderDto == null || productionOrderDto.getId() == null) {
             throw new ServiceException("鐢熶骇璁㈠崟ID涓嶈兘涓虹┖");
         }
@@ -179,6 +199,7 @@
 
     @Override
     public List<ProductionPlanVo> getSource(Long id) {
+        // 鏌ヨ璁㈠崟鍏宠仈鏉ユ簮璁″垝
         ProductionOrder productionOrder = baseMapper.selectById(id);
         if (productionOrder != null && productionOrder.getProductionPlanIds() != null) {
             List<Long> planIds = parsePlanIds(productionOrder.getProductionPlanIds());
@@ -189,7 +210,9 @@
 
     @Override
     public int syncProductionOrderSnapshot(Long productionOrderId) {
+        // 鍚屾璁㈠崟宸ヨ壓銆佸伐搴忋�佸弬鏁板拰BOM蹇収
         ProductionOrder productionOrder = this.getById(productionOrderId);
+        // 鍙傛暟涓庡墠缃潯浠舵牎楠�
         if (productionOrder == null) {
             throw new ServiceException("鐢熶骇璁㈠崟涓嶅瓨鍦�");
         }
@@ -204,6 +227,7 @@
         clearProductionSnapshot(productionOrderId);
         ProductionOrderBom orderBom = syncProductionOrderBomSnapshot(productionOrder, technologyRouting);
 
+        //鐢熶骇璁㈠崟宸ヨ壓璺嚎琛�
         ProductionOrderRouting orderRouting = new ProductionOrderRouting();
         orderRouting.setProductionOrderId(productionOrder.getId());
         orderRouting.setTechnologyRoutingId(technologyRouting.getId());
@@ -215,18 +239,25 @@
         productionOrderRoutingMapper.insert(orderRouting);
 
         int syncedParamCount = 0;
+        // 鏌ヨ骞跺噯澶囦笟鍔℃暟鎹�
         List<TechnologyRoutingOperation> routingOperations = technologyRoutingOperationMapper.selectList(
                 Wrappers.<TechnologyRoutingOperation>lambdaQuery()
                         .eq(TechnologyRoutingOperation::getTechnologyRoutingId, technologyRouting.getId())
-                        .orderByAsc(TechnologyRoutingOperation::getDragSort)
-                        .orderByAsc(TechnologyRoutingOperation::getId));
+                        .orderByDesc(TechnologyRoutingOperation::getDragSort)
+                        .orderByDesc(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));
+        Integer lastDragSort = routingOperations.stream()
+                .map(TechnologyRoutingOperation::getDragSort)
+                .filter(Objects::nonNull)
+                .max(Integer::compareTo)
+                .orElse(null);
         for (TechnologyRoutingOperation sourceOperation : routingOperations) {
             // 璁㈠崟宸ュ簭淇濆瓨鐨勬槸宸ヨ壓宸ュ簭蹇収锛屽悗缁姤宸ュ彧渚濊禆蹇収锛屼笉鍐嶇洿鎺ュ紩鐢ㄥ伐鑹轰富鏁版嵁銆�
             ProductionOrderRoutingOperation targetOperation = new ProductionOrderRoutingOperation();
@@ -235,19 +266,24 @@
             targetOperation.setOrderRoutingId(orderRouting.getId());
             targetOperation.setProductModelId(sourceOperation.getProductModelId());
             targetOperation.setDragSort(sourceOperation.getDragSort());
+            targetOperation.setIsProduction(sourceOperation.getIsProduction());
             targetOperation.setIsQuality(sourceOperation.getIsQuality());
             targetOperation.setOperationName(operationNameMap.get(sourceOperation.getTechnologyOperationId()));
             targetOperation.setTechnologyOperationId(sourceOperation.getTechnologyOperationId());
+            targetOperation.setType(sourceOperation.getType());
             productionOrderRoutingOperationMapper.insert(targetOperation);
 
-            ProductionOperationTask task = new ProductionOperationTask();
-            task.setTechnologyRoutingOperationId(targetOperation.getId());
-            task.setProductionOrderId(productionOrder.getId());
-            task.setPlanQuantity(defaultDecimal(productionOrder.getQuantity()));
-            task.setCompleteQuantity(BigDecimal.ZERO);
-            task.setWorkOrderNo(generateNextTaskNo());
-            task.setStatus(2);
-            productionOperationTaskMapper.insert(task);
+            boolean isLastOperation = lastDragSort != null && Objects.equals(sourceOperation.getDragSort(), lastDragSort);
+            if (isLastOperation || Boolean.TRUE.equals(targetOperation.getIsProduction())) {
+                ProductionOperationTask task = new ProductionOperationTask();
+                task.setProductionOrderRoutingOperationId(targetOperation.getId());
+                task.setProductionOrderId(productionOrder.getId());
+                task.setPlanQuantity(defaultDecimal(productionOrder.getQuantity()));
+                task.setCompleteQuantity(BigDecimal.ZERO);
+                task.setWorkOrderNo(generateNextTaskNo());
+                task.setStatus(2);
+                productionOperationTaskMapper.insert(task);
+            }
 
             List<TechnologyRoutingOperationParam> sourceParams = technologyRoutingOperationParamMapper.selectList(
                     Wrappers.<TechnologyRoutingOperationParam>lambdaQuery()
@@ -274,12 +310,11 @@
                 syncedParamCount++;
             }
         }
-
-        upsertOrderPick(productionOrder);
         return syncedParamCount;
     }
 
     private ProductionOrderBom syncProductionOrderBomSnapshot(ProductionOrder productionOrder, TechnologyRouting technologyRouting) {
+        // 鍚屾璁㈠崟BOM蹇収缁撴瀯
         if (technologyRouting.getBomId() == null) {
             return null;
         }
@@ -287,10 +322,12 @@
         if (technologyBom == null) {
             throw new ServiceException("宸ヨ壓BOM涓嶅瓨鍦�");
         }
+        // 鏌ヨ骞跺噯澶囦笟鍔℃暟鎹�
         List<TechnologyBomStructure> structureList = technologyBomStructureMapper.selectList(
                 Wrappers.<TechnologyBomStructure>lambdaQuery()
                         .eq(TechnologyBomStructure::getBomId, technologyBom.getId())
                         .orderByAsc(TechnologyBomStructure::getId));
+        // 閬嶅巻澶勭悊鏁版嵁骞剁粍瑁呯粨鏋�
         TechnologyBomStructure root = structureList.stream().filter(item -> item.getParentId() == null).findFirst().orElse(null);
         BigDecimal orderQuantity = defaultDecimal(productionOrder.getQuantity());
 
@@ -301,6 +338,7 @@
         orderBom.setRemark(technologyBom.getRemark());
         orderBom.setBomNo(technologyBom.getBomNo());
         orderBom.setVersion(technologyBom.getVersion());
+        // 鎸佷箙鍖栨垨杈撳嚭澶勭悊缁撴灉
         productionOrderBomMapper.insert(orderBom);
 
         Map<Long, Long> idMap = new HashMap<>();
@@ -322,16 +360,19 @@
     }
 
     private void clearProductionSnapshot(Long productionOrderId) {
-        // 宸蹭骇鐢熼鏂欒褰曞悗绂佹閲嶅缓锛岄伩鍏嶅鏂�/鎶曟枡渚濇嵁涓庤鍗曞揩鐓ц劚鑺傘��
+        // 娓呯悊璁㈠崟宸茬敓鎴愮殑宸ヨ壓涓嶣OM蹇収鏁版嵁
         boolean hasPickRecord = productionOrderPickRecordMapper.selectCount(
+        // 鏌ヨ骞跺噯澶囦笟鍔℃暟鎹�
                 Wrappers.<ProductionOrderPickRecord>lambdaQuery()
                         .eq(ProductionOrderPickRecord::getProductionOrderId, productionOrderId)) > 0;
+        // 鍙傛暟涓庡墠缃潯浠舵牎楠�
         if (hasPickRecord) {
             throw new ServiceException("鐢熶骇璁㈠崟宸插瓨鍦ㄩ鏂欒褰曪紝涓嶈兘閲嶆柊鐢熸垚蹇収");
         }
         List<Long> taskIds = productionOperationTaskMapper.selectList(
                         Wrappers.<ProductionOperationTask>lambdaQuery()
                                 .eq(ProductionOperationTask::getProductionOrderId, productionOrderId))
+        // 閬嶅巻澶勭悊鏁版嵁骞剁粍瑁呯粨鏋�
                 .stream().map(ProductionOperationTask::getId).collect(Collectors.toList());
         if (!taskIds.isEmpty()) {
             // 宸叉湁鎶ュ伐璁板綍璇存槑璁㈠崟宸插紑宸ワ紝姝ゆ椂涓嶅厑璁稿啀閲嶅缓蹇収銆�
@@ -359,6 +400,7 @@
     }
 
     private LambdaQueryWrapper<ProductionOrder> buildQueryWrapper(ProductionOrderDto dto) {
+        // 鎸夋潯浠跺姩鎬佹瀯寤烘暟鎹簱鏌ヨ鏉′欢
         ProductionOrder query = dto == null ? new ProductionOrder() : dto;
         return Wrappers.<ProductionOrder>lambdaQuery()
                 .eq(query.getId() != null, ProductionOrder::getId, query.getId())
@@ -369,6 +411,7 @@
     }
 
     private String generateNextOrderNo() {
+        // 鐢熸垚涓嬩竴涓敓浜ц鍗曞彿
         String datePrefix = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd"));
         String prefix = "SC" + datePrefix;
         ProductionOrder latestOrder = this.getOne(Wrappers.<ProductionOrder>lambdaQuery()
@@ -387,6 +430,7 @@
     }
 
     private String generateNextTaskNo() {
+        // 鐢熸垚涓嬩竴涓敓浜у伐鍗曞彿
         String datePrefix = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyyMMdd"));
         String prefix = "GD" + datePrefix;
         ProductionOperationTask lastTask = productionOperationTaskMapper.selectOne(
@@ -406,10 +450,12 @@
     }
 
     private BigDecimal defaultDecimal(BigDecimal value) {
+        // 灏嗙┖鏁伴噺鍏滃簳涓�0锛岄伩鍏嶇┖鎸囬拡寮傚父
         return value == null ? BigDecimal.ZERO : value;
     }
 
     private void validateAndFillOrder(ProductionOrder productionOrder, ProductionOrder oldOrder) {
+        // 鏍¢獙璁㈠崟鍙傛暟骞惰ˉ榻愰粯璁ゅ��
         if (productionOrder == null) {
             throw new ServiceException("鐢熶骇璁㈠崟涓嶈兘涓虹┖");
         }
@@ -442,7 +488,9 @@
     }
 
     private void fillFromProductionPlans(ProductionOrder productionOrder) {
+        // 浠庡叧鑱旂敓浜ц鍒掑洖濉鍗曞叧閿瓧娈�
         List<Long> planIds = parsePlanIds(productionOrder.getProductionPlanIds());
+        // 鍙傛暟涓庡墠缃潯浠舵牎楠�
         if (planIds.isEmpty()) {
             return;
         }
@@ -450,6 +498,13 @@
         List<ProductionPlan> productionPlans = productionPlanMapper.selectBatchIds(planIds);
         if (productionPlans.size() != planIds.size()) {
             throw new ServiceException("閮ㄥ垎鐢熶骇璁″垝涓嶅瓨鍦�");
+        }
+        // 閬嶅巻澶勭悊鏁版嵁骞剁粍瑁呯粨鏋�
+        Map<Long, ProductionPlan> planMap = productionPlans.stream()
+                .collect(Collectors.toMap(ProductionPlan::getId, item -> item, (left, right) -> left));
+        ProductionPlan mainPlan = planMap.get(planIds.get(0));
+        if (mainPlan == null) {
+            throw new ServiceException("涓荤敓浜ц鍒掍笉瀛樺湪");
         }
         Set<Long> productModelIds = productionPlans.stream()
                 .map(ProductionPlan::getProductModelId)
@@ -460,7 +515,7 @@
         if (productionPlans.stream().anyMatch(item -> item.getStatus() != null && item.getStatus() == 2)) {
             throw new ServiceException("鎵�閫夌敓浜ц鍒掑凡涓嬪彂");
         }
-        ProductionPlan firstPlan = productionPlans.get(0);
+        ProductionPlan firstPlan = mainPlan;
         if (productionOrder.getProductModelId() == null) {
             productionOrder.setProductModelId(firstPlan.getProductModelId());
         } else if (!Objects.equals(productionOrder.getProductModelId(), firstPlan.getProductModelId())) {
@@ -483,6 +538,7 @@
     }
 
     private void releaseProductionPlanIssueStatus(ProductionOrder productionOrder) {
+        // 鍥為��鐢熶骇璁″垝涓嬪彂鐘舵��
         if (productionOrder == null) {
             return;
         }
@@ -495,6 +551,7 @@
 
     //鐢熶骇璁㈠崟鍒犻櫎锛岀敓浜ц鍒掔殑宸蹭笅鍙戞暟閲忓搴斿彉鏇�
     private void updatePlanIssuedFlag(List<Long> planIds, BigDecimal remainingAssignedQuantity) {
+        // 鏇存柊璁″垝涓嬪彂鏍囪鍜屼笅鍙戞暟閲�
         if (planIds == null || planIds.isEmpty()) {
             return;
         }
@@ -524,6 +581,7 @@
     }
 
     private BigDecimal resolveRemainingQuantity(ProductionPlan plan) {
+        // 璁$畻褰撳墠璁″垝鎴栬褰曠殑鍓╀綑鏁伴噺
         if (plan == null) {
             return BigDecimal.ZERO;
         }
@@ -542,6 +600,7 @@
     }
 
     private int resolvePlanStatus(BigDecimal requiredQuantity, BigDecimal issuedQuantity) {
+        // 鏍规嵁闇�姹傞噺鍜屼笅鍙戦噺鎺ㄥ璁″垝鐘舵��
         if (requiredQuantity == null || requiredQuantity.compareTo(BigDecimal.ZERO) <= 0) {
             return 0;
         }
@@ -551,30 +610,8 @@
         return issuedQuantity.compareTo(requiredQuantity) < 0 ? 1 : 2;
     }
 
-    private void upsertOrderPick(ProductionOrder productionOrder) {
-        if (productionOrder == null || productionOrder.getId() == null) {
-            return;
-        }
-        // 璁㈠崟涓嬭揪鍚庤嚜鍔ㄧ敓鎴愪竴寮犲鏂欎富鍗曪紝鍚庣画棰嗘枡璁板綍閮芥寕鍦ㄨ繖寮犲崟涓娿��
-        ProductionOrderPick orderPick = productionOrderPickMapper.selectOne(
-                Wrappers.<ProductionOrderPick>lambdaQuery()
-                        .eq(ProductionOrderPick::getProductionOrderId, productionOrder.getId())
-                        .last("limit 1"));
-        if (orderPick == null) {
-            orderPick = new ProductionOrderPick();
-            orderPick.setProductionOrderId(productionOrder.getId());
-        }
-        orderPick.setProductModelId(productionOrder.getProductModelId() == null ? null : Math.toIntExact(productionOrder.getProductModelId()));
-        orderPick.setQuantity(defaultDecimal(productionOrder.getQuantity()));
-        orderPick.setRemark("涓嬪崟鑷姩鐢熸垚");
-        if (orderPick.getId() == null) {
-            productionOrderPickMapper.insert(orderPick);
-        } else {
-            productionOrderPickMapper.updateById(orderPick);
-        }
-    }
-
     private List<Long> parsePlanIds(String productionPlanIds) {
+        // 灏嗚鍒扞D瀛楃涓茶В鏋愪负Long鍒楄〃
         if (productionPlanIds == null || productionPlanIds.trim().isEmpty()) {
             return new ArrayList<>();
         }
@@ -591,6 +628,7 @@
     }
 
     private String formatPlanIds(List<Long> planIds) {
+        // 灏嗚鍒扞D闆嗗悎鏍煎紡鍖栦负[1,2,3]瀛楃涓�
         if (planIds == null || planIds.isEmpty()) {
             return null;
         }
@@ -601,6 +639,7 @@
     }
 
     private LocalDate resolvePlanCompleteDate(ProductionPlan productionPlan) {
+        // 瑙f瀽璁″垝瀹屾垚鏃ユ湡
         if (productionPlan == null) {
             return null;
         }
@@ -614,13 +653,16 @@
     }
 
     private int compareDecimal(BigDecimal left, BigDecimal right) {
+        // 瀹夊叏姣旇緝涓や釜鏁伴噺鍊煎ぇ灏�
         return defaultDecimal(left).compareTo(defaultDecimal(right));
     }
 
     private void fillProductImages(List<ProductionOrderVo> records) {
+        // 濉厖浜у搧鍥剧墖
         if (records == null || records.isEmpty()) {
             return;
         }
+        // 閬嶅巻澶勭悊鏁版嵁骞剁粍瑁呯粨鏋�
         List<Long> productModelIds = records.stream()
                 .map(ProductionOrderVo::getProductModelId)
                 .filter(Objects::nonNull)
@@ -630,6 +672,7 @@
             return;
         }
 
+        // 鏌ヨ骞跺噯澶囦笟鍔℃暟鎹�
         List<StorageAttachment> attachments = storageAttachmentMapper.selectList(
                 Wrappers.<StorageAttachment>lambdaQuery()
                         .in(StorageAttachment::getRecordId, productModelIds)
@@ -672,9 +715,289 @@
     }
 
     private StorageBlobVO toStorageBlobVO(StorageBlob blob) {
+        // 灏嗗瓨鍌ㄦ枃浠跺璞¤浆鎹负VO
         StorageBlobVO vo = BeanUtil.copyProperties(blob, StorageBlobVO.class);
         vo.setPreviewURL(fileUtil.buildSignedPreviewUrl(vo));
         vo.setDownloadURL(fileUtil.buildSignedDownloadUrl(vo));
         return vo;
     }
+
+    @Override
+    public ProductionOrderWorkOrderDetailVo getWorkOrderReportInspectDetail(ProductionOrderDto dto) {
+        // 鑾峰彇宸ュ崟璁㈠崟鎶ュ伐璐ㄦ鏄庣粏
+        Long productionOrderId = resolveProductionOrderId(dto);
+        ProductionOrderVo orderInfo = getProductionOrderInfo(productionOrderId);
+        // 鍙傛暟涓庡墠缃潯浠舵牎楠�
+        if (orderInfo == null) {
+            throw new ServiceException("鐢熶骇璁㈠崟涓嶅瓨鍦�");
+        }
+
+        ProductionOrderWorkOrderDetailVo detailVo = new ProductionOrderWorkOrderDetailVo();
+        detailVo.setProductionOrder(orderInfo);
+
+        ProductionOperationTaskDto taskQuery = new ProductionOperationTaskDto();
+        taskQuery.setProductionOrderId(productionOrderId);
+        IPage<ProductionOperationTaskVo> workOrderPage = productionOperationTaskMapper.pageProductionOperationTask(
+                new Page<ProductionOperationTaskVo>(1, -1), taskQuery);
+        List<ProductionOperationTaskVo> workOrderList = workOrderPage == null || workOrderPage.getRecords() == null
+                ? Collections.emptyList()
+        // 閬嶅巻澶勭悊鏁版嵁骞剁粍瑁呯粨鏋�
+                : workOrderPage.getRecords().stream()
+                .filter(Objects::nonNull)
+                .sorted(Comparator.comparing(ProductionOperationTaskVo::getId, Comparator.nullsLast(Comparator.naturalOrder())))
+                .toList();
+        if (workOrderList.isEmpty()) {
+            detailVo.setWorkOrderList(Collections.emptyList());
+            return detailVo;
+        }
+
+        List<Long> workOrderIdList = workOrderList.stream()
+                .map(ProductionOperationTaskVo::getId)
+                .filter(Objects::nonNull)
+                .collect(Collectors.toList());
+        List<ProductionProductMain> reportMainList = workOrderIdList.isEmpty()
+                ? Collections.emptyList()
+        // 鏌ヨ骞跺噯澶囦笟鍔℃暟鎹�
+                : productionProductMainMapper.selectList(
+                Wrappers.<ProductionProductMain>lambdaQuery()
+                        .in(ProductionProductMain::getProductionOperationTaskId, workOrderIdList)
+                        .orderByAsc(ProductionProductMain::getId));
+        Map<Long, List<ProductionProductMain>> reportMainByWorkOrderMap = new LinkedHashMap<>();
+        for (ProductionProductMain reportMain : reportMainList) {
+            if (reportMain == null || reportMain.getProductionOperationTaskId() == null) {
+                continue;
+            }
+            reportMainByWorkOrderMap.computeIfAbsent(reportMain.getProductionOperationTaskId(), key -> new ArrayList<>()).add(reportMain);
+        }
+
+        List<Long> reportMainIdList = reportMainList.stream()
+                .map(ProductionProductMain::getId)
+                .filter(Objects::nonNull)
+                .collect(Collectors.toList());
+        Map<Long, List<ProductionProductOutput>> reportOutputMap = new LinkedHashMap<>();
+        Map<Long, List<ProductionOrderRoutingOperationParam>> reportParamMap = new LinkedHashMap<>();
+        Map<Long, List<QualityInspect>> inspectMap = new LinkedHashMap<>();
+        Map<Long, List<QualityInspectParam>> inspectParamMap = new LinkedHashMap<>();
+        Map<Long, List<QualityInspectFile>> inspectFileMap = new LinkedHashMap<>();
+        if (!reportMainIdList.isEmpty()) {
+            List<ProductionProductOutput> reportOutputList = productionProductOutputMapper.selectList(
+                    Wrappers.<ProductionProductOutput>lambdaQuery()
+                            .in(ProductionProductOutput::getProductionProductMainId, reportMainIdList)
+                            .orderByAsc(ProductionProductOutput::getId));
+            for (ProductionProductOutput reportOutput : reportOutputList) {
+                if (reportOutput == null) {
+                    continue;
+                }
+                Long reportMainId = reportOutput.getProductionProductMainId() != null
+                        ? reportOutput.getProductionProductMainId()
+                        : reportOutput.getProductMainId();
+                if (reportMainId == null) {
+                    continue;
+                }
+                reportOutputMap.computeIfAbsent(reportMainId, k -> new ArrayList<>()).add(reportOutput);
+            }
+
+            List<ProductionOrderRoutingOperationParam> reportParamList = productionOrderRoutingOperationParamMapper.selectList(
+                    Wrappers.<ProductionOrderRoutingOperationParam>lambdaQuery()
+                            .in(ProductionOrderRoutingOperationParam::getProductionProductMainId, reportMainIdList)
+                            .orderByAsc(ProductionOrderRoutingOperationParam::getId));
+            for (ProductionOrderRoutingOperationParam reportParam : reportParamList) {
+                if (reportParam == null || reportParam.getProductionProductMainId() == null) {
+                    continue;
+                }
+                reportParamMap.computeIfAbsent(reportParam.getProductionProductMainId(), k -> new ArrayList<>()).add(reportParam);
+            }
+
+            List<QualityInspect> inspectList = qualityInspectMapper.selectList(
+                    Wrappers.<QualityInspect>lambdaQuery()
+                            .in(QualityInspect::getProductMainId, reportMainIdList)
+                            .orderByAsc(QualityInspect::getId));
+            for (QualityInspect inspect : inspectList) {
+                if (inspect == null || inspect.getProductMainId() == null) {
+                    continue;
+                }
+                inspectMap.computeIfAbsent(inspect.getProductMainId(), key -> new ArrayList<>()).add(inspect);
+            }
+
+            List<Long> inspectIdList = inspectList.stream()
+                    .map(QualityInspect::getId)
+                    .filter(Objects::nonNull)
+                    .collect(Collectors.toList());
+            if (!inspectIdList.isEmpty()) {
+                List<QualityInspectParam> inspectParamList = qualityInspectParamMapper.selectList(
+                        Wrappers.<QualityInspectParam>lambdaQuery()
+                                .in(QualityInspectParam::getInspectId, inspectIdList)
+                                .orderByAsc(QualityInspectParam::getId));
+                for (QualityInspectParam inspectParam : inspectParamList) {
+                    if (inspectParam == null || inspectParam.getInspectId() == null) {
+                        continue;
+                    }
+                    inspectParamMap.computeIfAbsent(inspectParam.getInspectId(), k -> new ArrayList<>()).add(inspectParam);
+                }
+
+                List<QualityInspectFile> inspectFileList = qualityInspectFileMapper.selectList(
+                        Wrappers.<QualityInspectFile>lambdaQuery()
+                                .in(QualityInspectFile::getInspectId, inspectIdList)
+                                .orderByAsc(QualityInspectFile::getId));
+                for (QualityInspectFile inspectFile : inspectFileList) {
+                    if (inspectFile == null || inspectFile.getInspectId() == null) {
+                        continue;
+                    }
+                    inspectFileMap.computeIfAbsent(inspectFile.getInspectId(), k -> new ArrayList<>()).add(inspectFile);
+                }
+            }
+        }
+
+        List<ProductionOrderWorkOrderDetailVo.WorkOrderDetail> workOrderDetailList = new ArrayList<>();
+        for (ProductionOperationTaskVo workOrder : workOrderList) {
+            ProductionOrderWorkOrderDetailVo.WorkOrderDetail workOrderDetail = new ProductionOrderWorkOrderDetailVo.WorkOrderDetail();
+            workOrderDetail.setWorkOrder(workOrder);
+
+            List<ProductionProductMain> workOrderReportMainList = reportMainByWorkOrderMap.getOrDefault(workOrder.getId(), Collections.emptyList());
+            if (workOrderReportMainList.isEmpty()) {
+                workOrderDetail.setReportList(Collections.emptyList());
+                workOrderDetail.setInspectList(Collections.emptyList());
+                workOrderDetailList.add(workOrderDetail);
+                continue;
+            }
+
+            List<ProductionOrderWorkOrderDetailVo.ReportDetail> reportDetailList = new ArrayList<>();
+            List<ProductionOrderWorkOrderDetailVo.InspectDetail> inspectDetailList = new ArrayList<>();
+            for (ProductionProductMain reportMain : workOrderReportMainList) {
+                Long reportMainId = reportMain.getId();
+
+                ProductionOrderWorkOrderDetailVo.ReportDetail reportDetail = new ProductionOrderWorkOrderDetailVo.ReportDetail();
+                reportDetail.setReportMain(reportMain);
+                reportDetail.setWorkHour(reportMain.getWorkHour());
+                reportDetail.setReportOutputList(reportOutputMap.getOrDefault(reportMainId, Collections.emptyList()));
+                reportDetail.setReportParamList(reportParamMap.getOrDefault(reportMainId, Collections.emptyList()));
+                reportDetailList.add(reportDetail);
+
+                List<QualityInspect> reportInspectList = inspectMap.getOrDefault(reportMainId, Collections.emptyList());
+                for (QualityInspect inspect : reportInspectList) {
+                    ProductionOrderWorkOrderDetailVo.InspectDetail inspectDetail = new ProductionOrderWorkOrderDetailVo.InspectDetail();
+                    inspectDetail.setReportId(reportMainId);
+                    inspectDetail.setReportNo(reportMain.getProductNo());
+                    inspectDetail.setReportMain(reportMain);
+                    inspectDetail.setWorkHour(reportMain.getWorkHour());
+                    inspectDetail.setInspect(inspect);
+                    inspectDetail.setInspectParamList(inspectParamMap.getOrDefault(inspect.getId(), Collections.emptyList()));
+                    inspectDetail.setInspectFileList(inspectFileMap.getOrDefault(inspect.getId(), Collections.emptyList()));
+                    inspectDetailList.add(inspectDetail);
+                }
+            }
+
+            workOrderDetail.setReportList(reportDetailList);
+            workOrderDetail.setInspectList(inspectDetailList);
+            workOrderDetailList.add(workOrderDetail);
+        }
+
+        detailVo.setWorkOrderList(workOrderDetailList);
+        return detailVo;
+    }
+
+    private Long resolveProductionOrderId(ProductionOrderDto dto) {
+        // 浠庡叆鍙備腑瑙f瀽鐢熶骇璁㈠崟ID骞舵牎楠�
+        if (dto == null) {
+            throw new ServiceException("璇蜂紶鍏ョ敓浜ц鍗旾D鎴栫敓浜ц鍗曞彿");
+        }
+        if (dto.getId() != null) {
+            return dto.getId();
+        }
+        if (dto.getNpsNo() == null || dto.getNpsNo().trim().isEmpty()) {
+            throw new ServiceException("璇蜂紶鍏ョ敓浜ц鍗旾D鎴栫敓浜ц鍗曞彿");
+        }
+        ProductionOrder productionOrder = baseMapper.selectOne(
+                Wrappers.<ProductionOrder>lambdaQuery()
+                        .eq(ProductionOrder::getNpsNo, dto.getNpsNo().trim())
+                        .last("limit 1"));
+        if (productionOrder == null || productionOrder.getId() == null) {
+            throw new ServiceException("鐢熶骇璁㈠崟涓嶅瓨鍦�");
+        }
+        return productionOrder.getId();
+    }
+
+    @Override
+    public List<ProductionOrderPickVo> pick(Long productionOrderId) {
+        // 鏌ヨ璁㈠崟棰嗘枡銆佹姇鏂欎笌閫�鏂欐槑缁�
+        if (productionOrderId == null) {
+            return Collections.emptyList();
+        }
+
+        // 鏌ヨ骞跺噯澶囦笟鍔℃暟鎹�
+        ProductionOrderBom orderBom = productionOrderBomMapper.selectOne(
+                Wrappers.<ProductionOrderBom>lambdaQuery()
+                        .eq(ProductionOrderBom::getProductionOrderId, productionOrderId)
+                        .orderByDesc(ProductionOrderBom::getId)
+                        .last("limit 1"));
+        if (orderBom == null || orderBom.getId() == null) {
+            return Collections.emptyList();
+        }
+
+        List<ProductionBomStructureVo> bomStructureList = productionBomStructureMapper.pickByBomId(orderBom.getId());
+        if (bomStructureList == null || bomStructureList.isEmpty()) {
+            return Collections.emptyList();
+        }
+
+        // 閬嶅巻澶勭悊鏁版嵁骞剁粍瑁呯粨鏋�
+        List<Long> productModelIds = bomStructureList.stream()
+                .map(ProductionBomStructureVo::getProductModelId)
+                .filter(Objects::nonNull)
+                .distinct()
+                .collect(Collectors.toList());
+        Map<Long, BigDecimal> stockQuantityMap = new HashMap<>();
+        Map<Long, LinkedHashSet<String>> stockBatchNoMap = new HashMap<>();
+        if (!productModelIds.isEmpty()) {
+            List<StockInventory> stockList = stockInventoryMapper.selectList(
+                    Wrappers.<StockInventory>lambdaQuery()
+                            .in(StockInventory::getProductModelId, productModelIds));
+            for (StockInventory stockItem : stockList) {
+                if (stockItem == null || stockItem.getProductModelId() == null) {
+                    continue;
+                }
+                Long productModelId = stockItem.getProductModelId();
+                stockQuantityMap.merge(productModelId, defaultDecimal(stockItem.getQualitity()), BigDecimal::add);
+                String batchNo = stockItem.getBatchNo();
+                if (batchNo != null && !batchNo.trim().isEmpty()) {
+                    stockBatchNoMap.computeIfAbsent(productModelId, key -> new LinkedHashSet<>()).add(batchNo);
+                }
+            }
+        }
+
+        Map<String, ProductionOrderPickVo> mergedPickMap = new LinkedHashMap<>();
+        for (ProductionBomStructureVo structure : bomStructureList) {
+            if (structure == null || structure.getProductModelId() == null) {
+                continue;
+            }
+            Long productModelId = structure.getProductModelId();
+            String mergeKey = String.valueOf(structure.getTechnologyOperationId()) + "#" + productModelId;
+            ProductionOrderPickVo vo = mergedPickMap.get(mergeKey);
+            if (vo == null) {
+                vo = new ProductionOrderPickVo();
+                vo.setProductModelId(productModelId);
+                vo.setOperationName(structure.getOperationName());
+                vo.setTechnologyOperationId(structure.getTechnologyOperationId());
+                vo.setProductName(structure.getProductName());
+                vo.setModel(structure.getModel());
+                vo.setDemandedQuantity(BigDecimal.ZERO);
+                vo.setUnit(structure.getUnit());
+                List<String> batchNoList = stockBatchNoMap.get(productModelId) == null
+                        ? Collections.emptyList()
+                        : new ArrayList<>(stockBatchNoMap.get(productModelId));
+                vo.setBatchNoList(batchNoList);
+                vo.setStockQuantity(stockQuantityMap.getOrDefault(productModelId, BigDecimal.ZERO));
+                vo.setBom(true);
+                mergedPickMap.put(mergeKey, vo);
+            }
+            vo.setDemandedQuantity(defaultDecimal(vo.getDemandedQuantity()).add(defaultDecimal(structure.getDemandedQuantity())));
+        }
+        return new ArrayList<>(mergedPickMap.values());
+    }
+
+    @Override
+    public int updateOrder(ProductionOrderDto productionOrderDto) {
+        // 鏇存柊鐢熶骇璁㈠崟涓绘暟鎹�
+        productionOrderDto.setStatus(5);
+        return baseMapper.updateById(productionOrderDto);
+    }
 }

--
Gitblit v1.9.3