package cn.iocoder.yudao.module.mes.service.wm.itemconsume; import cn.hutool.core.collection.CollUtil; import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockListReqVO; import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdItemDO; import cn.iocoder.yudao.module.mes.dal.dataobject.mdm.MesMdmItemDO; import cn.iocoder.yudao.module.mes.dal.dataobject.pro.feedback.MesProFeedbackDO; import cn.iocoder.yudao.module.mes.dal.dataobject.pro.workorder.MesProWorkOrderBomDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.itemconsume.MesWmItemConsumeDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.itemconsume.MesWmItemConsumeDetailDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.itemconsume.MesWmItemConsumeLineDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.materialstock.MesWmMaterialStockDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseAreaDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseLocationDO; import cn.iocoder.yudao.module.mes.dal.mysql.wm.itemconsume.MesWmItemConsumeMapper; import cn.iocoder.yudao.module.mes.dal.mysql.wm.materialstock.MesWmMaterialStockMapper; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.mes.enums.MesBizTypeConstants; import cn.iocoder.yudao.module.mes.enums.wm.MesWmItemConsumeStatusEnum; import cn.iocoder.yudao.module.mes.enums.wm.MesWmTransactionTypeEnum; import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService; import cn.iocoder.yudao.module.mes.service.mdm.MesMdmItemService; import cn.iocoder.yudao.module.mes.service.pro.workorder.MesProWorkOrderBomService; import cn.iocoder.yudao.module.mes.service.wm.materialstock.MesWmMaterialStockService; import cn.iocoder.yudao.module.mes.service.wm.transaction.MesWmTransactionService; import cn.iocoder.yudao.module.mes.service.wm.transaction.dto.MesWmTransactionSaveReqDTO; import cn.iocoder.yudao.module.mes.service.wm.warehouse.MesWmWarehouseAreaService; import cn.iocoder.yudao.module.mes.service.wm.warehouse.MesWmWarehouseLocationService; import cn.iocoder.yudao.module.mes.service.wm.warehouse.MesWmWarehouseService; import jakarta.annotation.Resource; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.validation.annotation.Validated; import java.math.BigDecimal; import java.time.LocalDateTime; import java.util.ArrayList; import java.util.List; import java.util.Map; import java.util.HashMap; import java.util.stream.Collectors; import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception; import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertList; import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.PRO_FEEDBACK_ROUTE_PROCESS_INVALID; import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.WM_ITEM_CONSUME_STOCK_INSUFFICIENT; /** * MES 物料消耗记录 Service 实现类 * * @author 超级管理员 */ @Service @Validated public class MesWmItemConsumeServiceImpl implements MesWmItemConsumeService { @Resource private MesWmItemConsumeMapper itemConsumeMapper; @Resource private MesWmItemConsumeLineService itemConsumeLineService; @Resource private MesWmItemConsumeDetailService itemConsumeDetailService; @Resource private MesProWorkOrderBomService workOrderBomService; @Resource private MesWmTransactionService wmTransactionService; @Resource private MesWmWarehouseService warehouseService; @Resource private MesWmWarehouseLocationService locationService; @Resource private MesWmWarehouseAreaService areaService; @Resource private MesWmMaterialStockService materialStockService; @Resource private MesWmMaterialStockMapper materialStockMapper; @Autowired private MesMdItemService mesMdItemService; @Override @Transactional(rollbackFor = Exception.class) public MesWmItemConsumeDO generateItemConsume(MesProFeedbackDO feedback) { // 1.1 校验工单编号有效 if (feedback.getWorkOrderId() == null) { throw exception(PRO_FEEDBACK_ROUTE_PROCESS_INVALID); } // 1.2 只查询当前倒冲工序的投料 BOM,避免重复扣减其他工序的物料 List boms = workOrderBomService.getWorkOrderBomListByWorkOrderIdAndProcessId( feedback.getWorkOrderId(), feedback.getProcessId()); if (CollUtil.isEmpty(boms)) { return null; } // 1.3 获取虚拟线边库信息 MesWmWarehouseDO virtualWarehouse = warehouseService.getWarehouseByCode(MesWmWarehouseDO.WIP_VIRTUAL_WAREHOUSE); MesWmWarehouseLocationDO virtualLocation = locationService.getWarehouseLocationByCode( MesWmWarehouseLocationDO.WIP_VIRTUAL_LOCATION); MesWmWarehouseAreaDO virtualArea = areaService.getWarehouseAreaByCode(MesWmWarehouseAreaDO.WIP_VIRTUAL_AREA); // 2.1 生成消耗单头 MesWmItemConsumeDO consume = MesWmItemConsumeDO.builder() .workOrderId(feedback.getWorkOrderId()).taskId(feedback.getTaskId()) .workstationId(feedback.getWorkstationId()).processId(feedback.getProcessId()) .feedbackId(feedback.getId()).consumeDate(LocalDateTime.now()) .status(MesWmItemConsumeStatusEnum.PREPARE.getStatus()).build(); itemConsumeMapper.insert(consume); // 2.2 批量生成消耗行(消耗数量 = BOM 用料比例 × 报工数量) List lines = convertList(boms, bom -> MesWmItemConsumeLineDO.builder() .consumeId(consume.getId()).itemId(bom.getItemId()) .quantity(bom.getQuantity().multiply(feedback.getFeedbackQuantity())).build()); itemConsumeLineService.createItemConsumeLineBatch(lines); // 3. 按线边库 FIFO 生成消耗明细 List allDetails = new ArrayList<>(); Map allocations = new HashMap<>(); // 以库存 ID 固定顺序加锁,并重新读取冻结/占用数据。审批的外层事务持续持锁至扣减完成。 Map> stocksByItem = new HashMap<>(); for (MesWmItemConsumeLineDO line : lines) { if (stocksByItem.containsKey(line.getItemId())) continue; MesMdItemDO item = mesMdItemService.validateItemExists(line.getItemId()); Long stockItemId = item.getMdmItemId() != null ? item.getMdmItemId() : item.getId(); MesWmMaterialStockListReqVO query = new MesWmMaterialStockListReqVO().setItemId(stockItemId) .setWarehouseId(virtualWarehouse.getId()).setLocationId(virtualLocation.getId()).setAreaId(virtualArea.getId()); stocksByItem.put(line.getItemId(), materialStockService.getMaterialStockList(query)); } Map lockedStocks = new HashMap<>(); stocksByItem.values().stream().flatMap(List::stream).map(MesWmMaterialStockDO::getId) .filter(java.util.Objects::nonNull).distinct().sorted().forEach(id -> { MesWmMaterialStockDO locked = materialStockMapper.selectOne(new LambdaQueryWrapperX() .eq(MesWmMaterialStockDO::getId, id).last("FOR UPDATE")); if (locked != null) lockedStocks.put(id, locked); }); for (MesWmItemConsumeLineDO line : lines) { generateDetailForLine(line, consume.getId(), virtualWarehouse, virtualLocation, virtualArea, allDetails, allocations, stocksByItem.get(line.getItemId()).stream().map(s -> lockedStocks.get(s.getId())) .filter(java.util.Objects::nonNull).toList()); } if (CollUtil.isNotEmpty(allDetails)) { itemConsumeDetailService.createItemConsumeDetailBatch(allDetails); } return consume; } /** * 为单条消耗行按 FIFO 分配线边库批次,生成消耗明细 * * 规则: * 1. 查询该物料在虚拟线边库中的库存记录,按入库时间升序(FIFO) * 2. 依次从各批次分配,直到消耗量满足 * 3. 扣除冻结、占用及本次已分配量后不足时中止报工审批 */ private void generateDetailForLine(MesWmItemConsumeLineDO line, Long consumeId, MesWmWarehouseDO warehouse, MesWmWarehouseLocationDO location, MesWmWarehouseAreaDO area, List allDetails, Map allocations, List lockedStocks) { // 查询该物料在线边库中的库存(按 receiptTime 升序 = FIFO;已排除 quantity = 0) MesMdItemDO item = mesMdItemService.validateItemExists(line.getItemId()); Long stockItemId = item.getMdmItemId() != null ? item.getMdmItemId() : item.getId(); List stocks = lockedStocks .stream().filter(s -> java.util.Objects.equals(s.getItemId(), stockItemId) && java.util.Objects.equals(s.getWarehouseId(), warehouse.getId()) && java.util.Objects.equals(s.getLocationId(), location.getId()) && java.util.Objects.equals(s.getAreaId(), area.getId()) && !Boolean.TRUE.equals(s.getFrozen()) && s.getQuantity() != null && s.getQuantity().compareTo(BigDecimal.ZERO) > 0).collect(Collectors.toList()); // 按 FIFO 依次从各批次分配 BigDecimal remaining = line.getQuantity(); for (MesWmMaterialStockDO stock : stocks) { if (remaining.compareTo(BigDecimal.ZERO) <= 0) { break; } BigDecimal available = stock.getQuantity() .subtract(stock.getFrozenQuantity() == null ? BigDecimal.ZERO : stock.getFrozenQuantity()) .subtract(stock.getReservedQuantity() == null ? BigDecimal.ZERO : stock.getReservedQuantity()) .subtract(allocations.getOrDefault(stock.getId(), BigDecimal.ZERO)); if (available.signum() <= 0) continue; BigDecimal allocate = available.min(remaining); allDetails.add(buildDetail(consumeId, line.getId(), stock.getId(), line.getItemId(), allocate, stock.getBatchId(), stock.getBatchCode(), warehouse, location, area)); remaining = remaining.subtract(allocate); allocations.merge(stock.getId(), allocate, BigDecimal::add); } if (remaining.compareTo(BigDecimal.ZERO) > 0) { throw exception(WM_ITEM_CONSUME_STOCK_INSUFFICIENT, item.getName()); } } private static MesWmItemConsumeDetailDO buildDetail(Long consumeId, Long lineId, Long materialStockId, Long itemId, BigDecimal quantity, Long batchId, String batchCode, MesWmWarehouseDO warehouse, MesWmWarehouseLocationDO location, MesWmWarehouseAreaDO area) { return MesWmItemConsumeDetailDO.builder() .consumeId(consumeId).lineId(lineId).materialStockId(materialStockId) .itemId(itemId).quantity(quantity) .batchId(batchId).batchCode(batchCode) .warehouseId(warehouse.getId()).locationId(location.getId()).areaId(area.getId()) .build(); } @Override @Transactional(rollbackFor = Exception.class) public void finishItemConsume(Long consumeId) { // 1. 查询消耗明细(detail 级别,包含精确的批次/仓库信息) List details = itemConsumeDetailService .getItemConsumeDetailListByConsumeId(consumeId); // 2. 遍历明细,创建库存事务(按批次精确扣减线边库) for (MesWmItemConsumeDetailDO detail : details) { MesMdItemDO item = mesMdItemService.validateItemExists(detail.getItemId()); wmTransactionService.createTransaction(new MesWmTransactionSaveReqDTO() .setType(MesWmTransactionTypeEnum.OUT.getType()) .setItemId(item.getMdmItemId() != null ? item.getMdmItemId() : item.getId()) .setQuantity(detail.getQuantity().negate()) .setBatchId(detail.getBatchId()).setBatchCode(detail.getBatchCode()) .setWarehouseId(detail.getWarehouseId()) .setLocationId(detail.getLocationId()) .setAreaId(detail.getAreaId()) .setMaterialStockId(detail.getMaterialStockId()) .setCheckFlag(true) .setBizType(MesBizTypeConstants.WM_ITEM_CONSUME) .setBizId(consumeId) .setBizCode("") .setBizLineId(detail.getLineId())); } // 3. 更新消耗单状态为已完成 itemConsumeMapper.updateById(MesWmItemConsumeDO.builder() .id(consumeId).status(MesWmItemConsumeStatusEnum.FINISHED.getStatus()).build()); } @Override public MesWmItemConsumeDO getByFeedbackId(Long feedbackId) { return itemConsumeMapper.selectByFeedbackId(feedbackId); } }