From 97f048ce14db07ee41ca05f9c7010dfe132150e4 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期二, 03 十一月 2026 11:06:59 +0800
Subject: [PATCH] feat(mes): 补生产准备检查与仓储收发存汇总接口,附 CFWJ 演示数据种子脚本

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/material/MesProMaterialRequirementServiceImpl.java |   14 ++++++++++++--
 1 files changed, 12 insertions(+), 2 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/material/MesProMaterialRequirementServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/material/MesProMaterialRequirementServiceImpl.java
index 8173707..29c15ca 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/material/MesProMaterialRequirementServiceImpl.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/material/MesProMaterialRequirementServiceImpl.java
@@ -26,6 +26,7 @@
 import java.util.ArrayList;
 import java.util.Collections;
 import java.util.HashMap;
+import java.util.HashSet;
 import java.util.LinkedHashMap;
 import java.util.List;
 import java.util.Map;
@@ -145,8 +146,16 @@
                 convertSet(itemMap.values(), MesMdItemDO::getItemTypeId));
 
         // 2. 鎵归噺鏌ヨ搴撳瓨锛屾寜 itemId 姹囨�诲彲鐢ㄩ噺锛堝湪搴� - 鍐荤粨 - 鍗犵敤锛�
+        // 搴撳瓨琛ㄥ瓨鐨勬槸 mdm_item_id锛岃�� BOM 灞曞紑寰楀埌鐨勬槸 mes_md_item.id锛岄渶瑕佸厛鎹㈢畻鍐嶆煡搴撳瓨
         Map<Long, BigDecimal> stockMap = new HashMap<>();
-        List<MesWmMaterialStockDO> stockList = materialStockMapper.selectListByItemIds(requirements.keySet());
+        Map<Long, Long> mesToMdmItemId = new HashMap<>();
+        for (MesMdItemDO item : itemMap.values()) {
+            if (item.getMdmItemId() != null) {
+                mesToMdmItemId.put(item.getId(), item.getMdmItemId());
+            }
+        }
+        List<MesWmMaterialStockDO> stockList = materialStockMapper.selectListByItemIds(
+                new HashSet<>(mesToMdmItemId.values()));
         for (MesWmMaterialStockDO stock : stockList) {
             BigDecimal available = nullToZero(stock.getQuantity())
                     .subtract(nullToZero(stock.getFrozenQuantity()))
@@ -164,7 +173,8 @@
                 continue;
             }
             BigDecimal requiredQty = entry.getValue();
-            BigDecimal stockQty = stockMap.getOrDefault(item.getId(), BigDecimal.ZERO);
+            BigDecimal stockQty = stockMap.getOrDefault(
+                    mesToMdmItemId.getOrDefault(item.getId(), item.getId()), BigDecimal.ZERO);
             BigDecimal purchaseQty = purchaseOrderQtyMap.getOrDefault(item.getId(), BigDecimal.ZERO);
             MesProWorkOrderItemRespVO vo = new MesProWorkOrderItemRespVO()
                     .setItemId(item.getId()).setQuantity(requiredQty)

--
Gitblit v1.9.3