From 41ab7abd0b0ec0fefb03b60bbaf42c02fbda666b Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期四, 23 四月 2026 15:53:16 +0800
Subject: [PATCH] feat(production): 添加生产订单与销售台账关联功能

---
 src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java |  365 +++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 357 insertions(+), 8 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 8562f46..e48509e 100644
--- a/src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductionOrderServiceImpl.java
@@ -5,6 +5,13 @@
 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.basic.dto.StorageBlobVO;
+import com.ruoyi.basic.mapper.StorageAttachmentMapper;
+import com.ruoyi.basic.mapper.StorageBlobMapper;
+import com.ruoyi.basic.pojo.StorageAttachment;
+import com.ruoyi.basic.pojo.StorageBlob;
+import com.ruoyi.basic.utils.FileUtil;
+import com.ruoyi.common.constant.StorageAttachmentConstants;
 import com.ruoyi.common.exception.ServiceException;
 import com.ruoyi.production.bean.dto.ProductionOrderDto;
 import com.ruoyi.production.bean.vo.ProductionOrderVo;
@@ -12,10 +19,15 @@
 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;
@@ -23,7 +35,13 @@
 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.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;
@@ -41,11 +59,16 @@
 
 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.stream.Collectors;
 
 @Service
@@ -60,49 +83,76 @@
     private final ProductionOrderBomMapper productionOrderBomMapper;
     private final ProductionBomStructureMapper productionBomStructureMapper;
     private final ProductionProductMainMapper productionProductMainMapper;
+    private final ProductionOrderPickMapper productionOrderPickMapper;
+    private final ProductionOrderPickRecordMapper productionOrderPickRecordMapper;
+    private final ProductionPlanMapper productionPlanMapper;
+    private final StorageAttachmentMapper storageAttachmentMapper;
+    private final StorageBlobMapper storageBlobMapper;
+    private final SalesLedgerMapper salesLedgerMapper;
+    private final SalesLedgerProductMapper salesLedgerProductMapper;
     private final TechnologyRoutingMapper technologyRoutingMapper;
     private final TechnologyRoutingOperationMapper technologyRoutingOperationMapper;
     private final TechnologyRoutingOperationParamMapper technologyRoutingOperationParamMapper;
     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) {
-        Page<ProductionOrder> entityPage = new Page<>(page.getCurrent(), page.getSize(), page.getTotal());
-        return this.page(entityPage, buildQueryWrapper(dto)).convert(item -> BeanUtil.copyProperties(item, ProductionOrderVo.class));
+        Page<ProductionOrderVo> result = (Page<ProductionOrderVo>) baseMapper.pageProductionOrder(page, dto);
+        fillProductImages(result.getRecords());
+        return result;
     }
 
     @Override
     public List<ProductionOrderVo> listProductionOrder(ProductionOrderDto dto) {
-        return BeanUtil.copyToList(this.list(buildQueryWrapper(dto)), ProductionOrderVo.class);
+        List<ProductionOrderVo> records = baseMapper.listProductionOrder(dto);
+        fillProductImages(records);
+        return records;
     }
 
     @Override
     public ProductionOrderVo getProductionOrderInfo(Long id) {
-        ProductionOrder item = this.getById(id);
-        return item == null ? null : BeanUtil.copyProperties(item, ProductionOrderVo.class);
+        ProductionOrderVo item = baseMapper.getProductionOrderInfo(id);
+        if (item == null) {
+            return null;
+        }
+        fillProductImages(java.util.Collections.singletonList(item));
+        return item;
     }
 
     @Override
     public boolean saveProductionOrder(ProductionOrder productionOrder) {
         ProductionOrder oldOrder = productionOrder.getId() == null ? null : this.getById(productionOrder.getId());
+        // 涓嬪崟鍏ュ彛缁熶竴琛ラ綈鏉ユ簮鍗曟嵁銆佽鍒掑拰宸ヨ壓淇℃伅锛岄伩鍏嶅墠绔垎鍒紶澶氬瀛楁銆�
+        validateAndFillOrder(productionOrder, oldOrder);
         if (productionOrder.getNpsNo() == null || productionOrder.getNpsNo().trim().isEmpty()) {
             productionOrder.setNpsNo(generateNextOrderNo());
         }
         if (productionOrder.getCompleteQuantity() == null) {
             productionOrder.setCompleteQuantity(BigDecimal.ZERO);
         }
+        if (productionOrder.getStatus() == null) {
+            productionOrder.setStatus(ProductOrderStatusEnum.WAIT.getCode());
+        }
         boolean saved = this.saveOrUpdate(productionOrder);
         if (!saved) {
             return false;
         }
+        syncProductionPlanIssueStatus(oldOrder, productionOrder);
         boolean needSync = productionOrder.getTechnologyRoutingId() != null
                 && (oldOrder == null
                 || !Objects.equals(oldOrder.getTechnologyRoutingId(), productionOrder.getTechnologyRoutingId())
+                || !Objects.equals(oldOrder.getProductModelId(), productionOrder.getProductModelId())
+                || compareDecimal(oldOrder.getQuantity(), productionOrder.getQuantity()) != 0
                 || productionOrderRoutingMapper.selectCount(Wrappers.<ProductionOrderRouting>lambdaQuery()
                         .eq(ProductionOrderRouting::getProductionOrderId, productionOrder.getId())) == 0);
         if (needSync) {
+            // 宸ヨ壓銆佷骇鍝佹垨鏁伴噺鍙樺寲鍚庯紝璁㈠崟蹇収蹇呴』鍜屽綋鍓嶄笅鍗曟暟鎹噸鏂板榻愩��
             syncProductionOrderSnapshot(productionOrder.getId());
+        } else {
+            // 鏈噸寤哄揩鐓ф椂锛屼篃瑕佺‘淇濆鏂欎富鍗曞拰璁㈠崟鏁伴噺淇濇寔鍚屾銆�
+            upsertOrderPick(productionOrder);
         }
         return true;
     }
@@ -113,7 +163,9 @@
             return false;
         }
         for (Long id : ids) {
+            ProductionOrder productionOrder = this.getById(id);
             clearProductionSnapshot(id);
+            releaseProductionPlanIssueStatus(productionOrder);
         }
         return this.removeByIds(ids);
     }
@@ -131,6 +183,7 @@
         if (technologyRouting == null) {
             throw new ServiceException("Technology routing not found");
         }
+        // 璁㈠崟蹇収鎸夆�滃厛娓呭悗寤衡�濆鐞嗭紝淇濊瘉宸ヨ壓璺嚎銆佸伐搴忋�佸弬鏁般�丅OM 鍏ㄩ儴鏉ヨ嚜鍚屼竴鐗堟湰銆�
         clearProductionSnapshot(productionOrderId);
 
         ProductionOrderRouting orderRouting = new ProductionOrderRouting();
@@ -149,6 +202,7 @@
                         .orderByAsc(TechnologyRoutingOperation::getDragSort)
                         .orderByAsc(TechnologyRoutingOperation::getId));
         for (TechnologyRoutingOperation sourceOperation : routingOperations) {
+            // 璁㈠崟宸ュ簭淇濆瓨鐨勬槸宸ヨ壓宸ュ簭蹇収锛屽悗缁姤宸ュ彧渚濊禆蹇収锛屼笉鍐嶇洿鎺ュ紩鐢ㄥ伐鑹轰富鏁版嵁銆�
             ProductionOrderRoutingOperation targetOperation = new ProductionOrderRoutingOperation();
             targetOperation.setProductionOrderId(productionOrder.getId());
             targetOperation.setTechnologyRoutingOperationId(sourceOperation.getId());
@@ -164,7 +218,7 @@
             task.setPlanQuantity(defaultDecimal(productionOrder.getQuantity()));
             task.setCompleteQuantity(BigDecimal.ZERO);
             task.setWorkOrderNo(generateNextTaskNo());
-            task.setStatus(1);
+            task.setStatus(2);
             productionOperationTaskMapper.insert(task);
 
             List<TechnologyRoutingOperationParam> sourceParams = technologyRoutingOperationParamMapper.selectList(
@@ -172,6 +226,7 @@
                             .eq(TechnologyRoutingOperationParam::getTechnologyRoutingOperationId, sourceOperation.getId())
                             .orderByAsc(TechnologyRoutingOperationParam::getId));
             for (TechnologyRoutingOperationParam sourceParam : sourceParams) {
+                // 宸ュ簭鎵ц鍙傛暟鍚屾牱鍋氬揩鐓э紝閬垮厤宸ヨ壓鍙傛暟璋冩暣褰卞搷宸蹭笅杈捐鍗曘��
                 ProductionOrderRoutingOperationParam targetParam = new ProductionOrderRoutingOperationParam();
                 targetParam.setProductionOrderId(productionOrder.getId());
                 targetParam.setTechnologyRoutingOperationId(targetOperation.getId());
@@ -193,6 +248,7 @@
         }
 
         syncProductionOrderBomSnapshot(productionOrder, technologyRouting);
+        upsertOrderPick(productionOrder);
         return syncedParamCount;
     }
 
@@ -209,6 +265,7 @@
                         .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());
 
         ProductionOrderBom orderBom = new ProductionOrderBom();
         orderBom.setProductionOrderId(productionOrder.getId());
@@ -216,12 +273,13 @@
         orderBom.setProductModelId(root != null ? root.getProductModelId() : productionOrder.getProductModelId());
         orderBom.setTechnologyOperationId(root == null ? null : root.getOperationId());
         orderBom.setUnitQuantity(root != null && root.getUnitQuantity() != null ? root.getUnitQuantity() : BigDecimal.ONE);
-        orderBom.setDemandedQuantity(root != null && root.getDemandedQuantity() != null ? root.getDemandedQuantity() : defaultDecimal(productionOrder.getQuantity()));
+        orderBom.setDemandedQuantity(orderQuantity);
         orderBom.setUnit(root == null ? null : root.getUnit());
         productionOrderBomMapper.insert(orderBom);
 
         Map<Long, Long> idMap = new HashMap<>();
         for (TechnologyBomStructure source : structureList) {
+            // 瀛愯妭鐐� parentId 闇�瑕佹槧灏勬垚鏂板揩鐓ц妭鐐� id锛屾墠鑳戒繚鐣欏師濮� BOM 灞傜骇銆�
             ProductionBomStructure target = new ProductionBomStructure();
             target.setProductionOrderId(productionOrder.getId());
             target.setProductionOrderBomId(orderBom.getId());
@@ -229,7 +287,7 @@
             target.setProductModelId(source.getProductModelId());
             target.setTechnologyOperationId(source.getOperationId());
             target.setUnitQuantity(source.getUnitQuantity());
-            target.setDemandedQuantity(source.getDemandedQuantity());
+            target.setDemandedQuantity(resolveBomDemandQuantity(source, orderQuantity));
             target.setUnit(source.getUnit());
             productionBomStructureMapper.insert(target);
             idMap.put(source.getId(), target.getId());
@@ -237,11 +295,19 @@
     }
 
     private void clearProductionSnapshot(Long productionOrderId) {
+        // 宸蹭骇鐢熼鏂欒褰曞悗绂佹閲嶅缓锛岄伩鍏嶅鏂�/鎶曟枡渚濇嵁涓庤鍗曞揩鐓ц劚鑺傘��
+        boolean hasPickRecord = productionOrderPickRecordMapper.selectCount(
+                Wrappers.<ProductionOrderPickRecord>lambdaQuery()
+                        .eq(ProductionOrderPickRecord::getProductionOrderId, productionOrderId)) > 0;
+        if (hasPickRecord) {
+            throw new ServiceException("Production order pick records already exist, snapshot cannot be regenerated");
+        }
         List<Long> taskIds = productionOperationTaskMapper.selectList(
                         Wrappers.<ProductionOperationTask>lambdaQuery()
                                 .eq(ProductionOperationTask::getProductionOrderId, productionOrderId))
                 .stream().map(ProductionOperationTask::getId).collect(Collectors.toList());
         if (!taskIds.isEmpty()) {
+            // 宸叉湁鎶ュ伐璁板綍璇存槑璁㈠崟宸插紑宸ワ紝姝ゆ椂涓嶅厑璁稿啀閲嶅缓蹇収銆�
             boolean started = productionProductMainMapper.selectCount(
                     Wrappers.<ProductionProductMain>lambdaQuery()
                             .in(ProductionProductMain::getProductionOperationTaskId, taskIds)) > 0;
@@ -261,6 +327,8 @@
                 .eq(ProductionBomStructure::getProductionOrderId, productionOrderId));
         productionOrderBomMapper.delete(Wrappers.<ProductionOrderBom>lambdaQuery()
                 .eq(ProductionOrderBom::getProductionOrderId, productionOrderId));
+        productionOrderPickMapper.delete(Wrappers.<ProductionOrderPick>lambdaQuery()
+                .eq(ProductionOrderPick::getProductionOrderId, productionOrderId));
     }
 
     private LambdaQueryWrapper<ProductionOrder> buildQueryWrapper(ProductionOrderDto dto) {
@@ -314,4 +382,285 @@
     private BigDecimal defaultDecimal(BigDecimal value) {
         return value == null ? BigDecimal.ZERO : value;
     }
+
+    private void validateAndFillOrder(ProductionOrder productionOrder, ProductionOrder oldOrder) {
+        if (productionOrder == null) {
+            throw new ServiceException("Production order is required");
+        }
+        fillFromSalesLedgerProduct(productionOrder);
+        fillFromProductionPlans(productionOrder);
+        if (productionOrder.getProductModelId() == null) {
+            throw new ServiceException("productModelId is required");
+        }
+        if (defaultDecimal(productionOrder.getQuantity()).compareTo(BigDecimal.ZERO) <= 0) {
+            throw new ServiceException("quantity must be greater than 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 (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");
+            }
+        }
+    }
+
+    private void fillFromSalesLedgerProduct(ProductionOrder productionOrder) {
+        if (productionOrder.getSaleLedgerProductId() == null) {
+            return;
+        }
+        // 閿�鍞槑缁嗘槸璁㈠崟鏉ユ簮鏃讹紝浠ラ攢鍞槑缁嗕负鍑嗗洖濉攢鍞彴璐︺�佷骇鍝佽鏍煎拰榛樿鏁伴噺銆�
+        SalesLedgerProduct salesLedgerProduct = salesLedgerProductMapper.selectById(productionOrder.getSaleLedgerProductId().longValue());
+        if (salesLedgerProduct == null) {
+            throw new ServiceException("Sales ledger product not found");
+        }
+        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");
+        }
+        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");
+        }
+        if (productionOrder.getQuantity() == null || productionOrder.getQuantity().compareTo(BigDecimal.ZERO) <= 0) {
+            productionOrder.setQuantity(salesLedgerProduct.getQuantity());
+        }
+        if (productionOrder.getPlanCompleteTime() == null && productionOrder.getSalesLedgerId() != null) {
+            SalesLedger salesLedger = salesLedgerMapper.selectById(productionOrder.getSalesLedgerId());
+            if (salesLedger != null && salesLedger.getDeliveryDate() != null) {
+                productionOrder.setPlanCompleteTime(salesLedger.getDeliveryDate());
+            }
+        }
+    }
+
+    private void fillFromProductionPlans(ProductionOrder productionOrder) {
+        List<Long> planIds = parsePlanIds(productionOrder.getProductionPlanIds());
+        if (planIds.isEmpty()) {
+            return;
+        }
+        // 澶氳鍒掑悎骞惰浆鍗曟椂锛屾墍鏈夎鍒掑繀椤诲睘浜庡悓涓�瑙勬牸锛屼笖鍙兘涓嬪彂涓�娆°��
+        List<ProductionPlan> productionPlans = productionPlanMapper.selectBatchIds(planIds);
+        if (productionPlans.size() != planIds.size()) {
+            throw new ServiceException("Some production plans do not exist");
+        }
+        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");
+        }
+        if (Boolean.TRUE.equals(productionPlans.stream().anyMatch(item -> Boolean.TRUE.equals(item.getIssued())))) {
+            throw new ServiceException("Selected production plans already issued");
+        }
+        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");
+        }
+        if (productionOrder.getQuantity() == null || productionOrder.getQuantity().compareTo(BigDecimal.ZERO) <= 0) {
+            productionOrder.setQuantity(productionPlans.stream()
+                    .map(ProductionPlan::getQtyRequired)
+                    .reduce(BigDecimal.ZERO, BigDecimal::add));
+        }
+        if (productionOrder.getPlanCompleteTime() == null) {
+            LocalDate planCompleteTime = productionPlans.stream()
+                    .map(this::resolvePlanCompleteDate)
+                    .filter(Objects::nonNull)
+                    .min(Comparator.naturalOrder())
+                    .orElse(null);
+            productionOrder.setPlanCompleteTime(planCompleteTime);
+        }
+        productionOrder.setProductionPlanIds(formatPlanIds(planIds));
+    }
+
+    private void syncProductionPlanIssueStatus(ProductionOrder oldOrder, ProductionOrder newOrder) {
+        // 鍙鐞嗘湰娆″閲忓彉鍖栵紝閬垮厤鏃犲叧璁″垝琚噸澶嶅啓鐘舵�併��
+        Set<Long> oldIds = new LinkedHashSet<>(parsePlanIds(oldOrder == null ? null : oldOrder.getProductionPlanIds()));
+        Set<Long> newIds = new LinkedHashSet<>(parsePlanIds(newOrder == null ? null : newOrder.getProductionPlanIds()));
+        Set<Long> toRelease = new LinkedHashSet<>(oldIds);
+        toRelease.removeAll(newIds);
+        Set<Long> toIssue = new LinkedHashSet<>(newIds);
+        toIssue.removeAll(oldIds);
+        if (!toRelease.isEmpty()) {
+            updatePlanIssuedFlag(new ArrayList<>(toRelease), false);
+        }
+        if (!toIssue.isEmpty()) {
+            updatePlanIssuedFlag(new ArrayList<>(toIssue), true);
+        }
+    }
+
+    private void releaseProductionPlanIssueStatus(ProductionOrder productionOrder) {
+        if (productionOrder == null) {
+            return;
+        }
+        List<Long> planIds = parsePlanIds(productionOrder.getProductionPlanIds());
+        if (!planIds.isEmpty()) {
+            updatePlanIssuedFlag(planIds, false);
+        }
+    }
+
+    private void updatePlanIssuedFlag(List<Long> planIds, boolean issued) {
+        if (planIds == null || planIds.isEmpty()) {
+            return;
+        }
+        List<ProductionPlan> plans = productionPlanMapper.selectBatchIds(planIds);
+        for (ProductionPlan plan : plans) {
+            ProductionPlan update = new ProductionPlan();
+            update.setId(plan.getId());
+            update.setIssued(issued);
+            productionPlanMapper.updateById(update);
+        }
+    }
+
+    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 BigDecimal resolveBomDemandQuantity(TechnologyBomStructure source, BigDecimal orderQuantity) {
+        // 宸ヨ壓 BOM 涓殑闇�姹傞噺鎸夆�滃崟浠堕渶姹� * 璁㈠崟鏁伴噺鈥濆睍寮�鎴愯鍗曠骇闇�姹傘��
+        BigDecimal baseQuantity = source.getDemandedQuantity() != null ? source.getDemandedQuantity() : source.getUnitQuantity();
+        baseQuantity = baseQuantity == null ? BigDecimal.ZERO : baseQuantity;
+        if (baseQuantity.compareTo(BigDecimal.ZERO) <= 0) {
+            return BigDecimal.ZERO;
+        }
+        return baseQuantity.multiply(orderQuantity);
+    }
+
+    private List<Long> parsePlanIds(String productionPlanIds) {
+        if (productionPlanIds == null || productionPlanIds.trim().isEmpty()) {
+            return new ArrayList<>();
+        }
+        String normalized = productionPlanIds.replace("[", "").replace("]", "").trim();
+        if (normalized.isEmpty()) {
+            return new ArrayList<>();
+        }
+        return java.util.Arrays.stream(normalized.split(","))
+                .map(String::trim)
+                .filter(item -> !item.isEmpty())
+                .map(Long::valueOf)
+                .distinct()
+                .collect(Collectors.toList());
+    }
+
+    private String formatPlanIds(List<Long> planIds) {
+        if (planIds == null || planIds.isEmpty()) {
+            return null;
+        }
+        return planIds.stream()
+                .distinct()
+                .map(String::valueOf)
+                .collect(Collectors.joining(",", "[", "]"));
+    }
+
+    private LocalDate resolvePlanCompleteDate(ProductionPlan productionPlan) {
+        if (productionPlan == null) {
+            return null;
+        }
+        if (productionPlan.getPromisedDeliveryDate() != null) {
+            return productionPlan.getPromisedDeliveryDate().toLocalDate();
+        }
+        if (productionPlan.getRequiredDate() != null) {
+            return productionPlan.getRequiredDate().toLocalDate();
+        }
+        return null;
+    }
+
+    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)
+                .distinct()
+                .collect(Collectors.toList());
+        if (productModelIds.isEmpty()) {
+            return;
+        }
+
+        List<StorageAttachment> attachments = storageAttachmentMapper.selectList(
+                Wrappers.<StorageAttachment>lambdaQuery()
+                        .in(StorageAttachment::getRecordId, productModelIds)
+                        .eq(StorageAttachment::getApplication, StorageAttachmentConstants.StorageAttachmentImage)
+                        .eq(StorageAttachment::getDeleted, 0L)
+                        .orderByAsc(StorageAttachment::getId));
+        if (attachments == null || attachments.isEmpty()) {
+            return;
+        }
+
+        Map<Long, List<StorageAttachment>> attachmentMap = attachments.stream()
+                .collect(Collectors.groupingBy(StorageAttachment::getRecordId, java.util.LinkedHashMap::new, Collectors.toList()));
+        List<Long> blobIds = attachments.stream()
+                .map(StorageAttachment::getStorageBlobId)
+                .filter(Objects::nonNull)
+                .distinct()
+                .collect(Collectors.toList());
+        if (blobIds.isEmpty()) {
+            return;
+        }
+
+        Map<Long, StorageBlob> blobMap = storageBlobMapper.selectBatchIds(blobIds).stream()
+                .filter(Objects::nonNull)
+                .collect(Collectors.toMap(StorageBlob::getId, item -> item));
+        for (ProductionOrderVo record : records) {
+            List<StorageAttachment> modelAttachments = attachmentMap.get(record.getProductModelId());
+            if (modelAttachments == null || modelAttachments.isEmpty()) {
+                continue;
+            }
+            List<StorageBlobVO> images = modelAttachments.stream()
+                    .map(StorageAttachment::getStorageBlobId)
+                    .map(blobMap::get)
+                    .filter(Objects::nonNull)
+                    .map(this::toStorageBlobVO)
+                    .collect(Collectors.toList());
+            if (!images.isEmpty()) {
+                record.setProductImages(images);
+            }
+        }
+    }
+
+    private StorageBlobVO toStorageBlobVO(StorageBlob blob) {
+        StorageBlobVO vo = BeanUtil.copyProperties(blob, StorageBlobVO.class);
+        vo.setPreviewURL(fileUtil.buildSignedPreviewUrl(vo));
+        vo.setDownloadURL(fileUtil.buildSignedDownloadUrl(vo));
+        return vo;
+    }
 }

--
Gitblit v1.9.3