package cn.iocoder.yudao.module.mes.service.wm.productissue; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.util.ObjUtil; import cn.hutool.core.util.StrUtil; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.framework.common.util.collection.CollectionUtils; import cn.iocoder.yudao.framework.common.util.object.BeanUtils; import cn.iocoder.yudao.framework.common.util.object.ObjectUtils; import cn.iocoder.yudao.module.mes.controller.admin.wm.productissue.vo.MesWmProductIssueImportExcelVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.productissue.vo.MesWmProductIssueImportRespVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.productissue.vo.MesWmProductIssuePageReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.productissue.vo.MesWmProductIssueSaveReqVO; import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdItemDO; import cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskDO; import cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskIssueDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productissue.MesWmProductIssueDetailDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productissue.MesWmProductIssueDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productissue.MesWmProductIssueLineDO; import cn.iocoder.yudao.module.mes.dal.mysql.pro.task.MesProTaskIssueMapper; import cn.iocoder.yudao.module.mes.dal.mysql.wm.productissue.MesWmProductIssueMapper; import cn.iocoder.yudao.module.mes.enums.MesBizTypeConstants; import cn.iocoder.yudao.module.mes.enums.wm.MesWmProductIssueStatusEnum; import cn.iocoder.yudao.module.mes.enums.wm.MesWmProductIssueTypeEnum; import cn.iocoder.yudao.module.mes.enums.wm.MesWmStockReserveBizTypeEnum; 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.md.workstation.MesMdWorkstationService; import cn.iocoder.yudao.module.mes.service.pro.task.MesProTaskIssueService; import cn.iocoder.yudao.module.mes.service.pro.task.MesProTaskService; import cn.iocoder.yudao.module.mes.service.pro.workorder.MesProWorkOrderService; import cn.iocoder.yudao.module.mes.service.wm.stockreserve.MesWmStockReserveService; 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 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 jakarta.annotation.Resource; 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.LinkedHashMap; import java.util.List; import java.util.Map; import java.util.concurrent.atomic.AtomicInteger; import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception; import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*; /** * MES 领料出库单 Service 实现类 */ @Service @Validated public class MesWmProductIssueServiceImpl implements MesWmProductIssueService { @Resource private MesWmProductIssueMapper issueMapper; @Resource private MesWmProductIssueLineService issueLineService; @Resource private MesWmProductIssueDetailService issueDetailService; @Resource private MesMdWorkstationService workstationService; @Resource private MesProWorkOrderService workOrderService; @Resource private MesProTaskService taskService; @Resource private MesProTaskIssueService taskIssueService; @Resource private MesProTaskIssueMapper taskIssueMapper; @Resource private MesMdItemService mdmItemService; @Resource private MesWmTransactionService wmTransactionService; @Resource private MesWmWarehouseService warehouseService; @Resource private MesWmWarehouseLocationService locationService; @Resource private MesWmWarehouseAreaService areaService; @Resource private MesWmStockReserveService stockReserveService; @Override @Transactional(rollbackFor = Exception.class) public Long createProductIssue(MesWmProductIssueSaveReqVO createReqVO) { // 1. 校验关联数据 validateProductIssueSaveData(createReqVO); // 2. 从 task 自动带入 workOrderId 和 workstationId MesProTaskDO task = taskService.validateTaskExists(createReqVO.getTaskId()); if (createReqVO.getWorkOrderId() == null) { createReqVO.setWorkOrderId(task.getWorkOrderId()); } if (createReqVO.getWorkstationId() == null) { createReqVO.setWorkstationId(task.getWorkstationId()); } // 3. 插入主表 MesWmProductIssueDO issue = BeanUtils.toBean(createReqVO, MesWmProductIssueDO.class); issue.setStatus(MesWmProductIssueStatusEnum.PREPARE.getStatus()); if (issue.getIssueType() == null) { issue.setIssueType(MesWmProductIssueTypeEnum.NORMAL.getType()); } issueMapper.insert(issue); return issue.getId(); } @Override @Transactional(rollbackFor = Exception.class) public void updateProductIssue(MesWmProductIssueSaveReqVO updateReqVO) { // 1.1 校验存在 + 准备中状态 validateProductIssueExistsAndPrepare(updateReqVO.getId()); // 1.2 校验关联数据 validateProductIssueSaveData(updateReqVO); // 2. 从 task 自动带入 workOrderId 和 workstationId MesProTaskDO task = taskService.validateTaskExists(updateReqVO.getTaskId()); if (updateReqVO.getWorkOrderId() == null) { updateReqVO.setWorkOrderId(task.getWorkOrderId()); } if (updateReqVO.getWorkstationId() == null) { updateReqVO.setWorkstationId(task.getWorkstationId()); } // 3. 更新主表 MesWmProductIssueDO updateObj = BeanUtils.toBean(updateReqVO, MesWmProductIssueDO.class); issueMapper.updateById(updateObj); } @Override @Transactional(rollbackFor = Exception.class) public void deleteProductIssue(Long id) { // 1. 校验存在 + 准备中状态 validateProductIssueExistsAndPrepare(id); // 2.1 级联删除明细 issueDetailService.deleteProductIssueDetailByIssueId(id); // 2.2 级联删除行 issueLineService.deleteProductIssueLineByIssueId(id); // 2.3 删除主表 issueMapper.deleteById(id); } @Override public MesWmProductIssueDO getProductIssue(Long id) { return issueMapper.selectById(id); } @Override public PageResult getProductIssuePage(MesWmProductIssuePageReqVO pageReqVO) { return issueMapper.selectPage(pageReqVO); } @Override @Transactional(rollbackFor = Exception.class) public void submitProductIssue(Long id) { // 校验存在 + 草稿状态 validateProductIssueExistsAndPrepare(id); // 校验至少有一条行 List lines = issueLineService.getProductIssueLineListByIssueId(id); if (CollUtil.isEmpty(lines)) { throw exception(WM_PRODUCT_ISSUE_NO_LINE); } // 提交(草稿 → 待拣货) issueMapper.updateById(new MesWmProductIssueDO() .setId(id).setStatus(MesWmProductIssueStatusEnum.APPROVING.getStatus())); } @Override @Transactional(rollbackFor = Exception.class) public void stockProductIssue(Long id) { // 校验存在 MesWmProductIssueDO issue = validateProductIssueExists(id); if (ObjUtil.notEqual(MesWmProductIssueStatusEnum.APPROVING.getStatus(), issue.getStatus())) { throw exception(WM_PRODUCT_ISSUE_STATUS_INVALID); } // 校验拣货明细闭环:行数量 = 明细数量 if (!checkProductIssueQuantity(id)) { throw exception(WM_PRODUCT_ISSUE_DETAIL_QUANTITY_MISMATCH); } // 创建库存占用(按明细占用库存) List details = issueDetailService.getProductIssueDetailListByIssueId(id); for (MesWmProductIssueDetailDO detail : details) { if (detail.getMaterialStockId() != null && detail.getQuantity() != null) { stockReserveService.createReserve( detail.getMaterialStockId(), MesWmStockReserveBizTypeEnum.PRODUCT_ISSUE.getType(), id, issue.getCode(), detail.getId(), detail.getItemId(), detail.getQuantity() ); } } // 执行拣货(待拣货 → 待执行领出) issueMapper.updateById(new MesWmProductIssueDO() .setId(id).setStatus(MesWmProductIssueStatusEnum.APPROVED.getStatus())); } @Override @Transactional(rollbackFor = Exception.class) public void finishProductIssue(Long id) { // 1. 校验存在 MesWmProductIssueDO issue = validateProductIssueExists(id); if (ObjUtil.notEqual(MesWmProductIssueStatusEnum.APPROVED.getStatus(), issue.getStatus())) { throw exception(WM_PRODUCT_ISSUE_STATUS_INVALID); } // 校验至少有一条明细 List details = issueDetailService.getProductIssueDetailListByIssueId(id); if (CollUtil.isEmpty(details)) { throw exception(WM_PRODUCT_ISSUE_NO_DETAIL); } // 校验行数量 = 明细数量 if (!checkProductIssueQuantity(id)) { throw exception(WM_PRODUCT_ISSUE_DETAIL_QUANTITY_MISMATCH); } // 2. 确认占用转出库(释放占用量) stockReserveService.confirmReserveToOutbound(MesWmStockReserveBizTypeEnum.PRODUCT_ISSUE.getType(), id); // 3. 遍历所有明细,创建库存事务(扣减库存 + 记录流水) createTransactionList(issue); // 4. 自动创建任务投料记录 createTaskIssueRecords(issue); // 5. 更新出库单状态 + 领料日期 issueMapper.updateById(new MesWmProductIssueDO() .setId(id).setStatus(MesWmProductIssueStatusEnum.FINISHED.getStatus()) .setIssueDate(LocalDateTime.now())); } private void createTransactionList(MesWmProductIssueDO issue) { // 1. 查询虚拟线边库 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. 遍历明细,每条明细产生 OUT(实际仓库扣减)+ IN(虚拟线边库增加) List details = issueDetailService.getProductIssueDetailListByIssueId(issue.getId()); for (MesWmProductIssueDetailDO detail : details) { // 2.1 先从实际仓库出库(库存减少) Long outTransactionId = wmTransactionService.createTransaction(new MesWmTransactionSaveReqDTO() .setType(MesWmTransactionTypeEnum.OUT.getType()).setItemId(detail.getItemId()) .setQuantity(detail.getQuantity().negate()) // 库存减少 .setBatchId(detail.getBatchId()).setBatchCode(detail.getBatchCode()).setMaterialStockId(detail.getMaterialStockId()) .setWarehouseId(detail.getWarehouseId()).setLocationId(detail.getLocationId()).setAreaId(detail.getAreaId()) .setBizType(MesBizTypeConstants.WM_ISSUE).setBizId(issue.getId()) .setBizCode(issue.getCode()).setBizLineId(detail.getLineId())); // 2.2 再入虚拟线边库(库存增加) wmTransactionService.createTransaction(new MesWmTransactionSaveReqDTO() .setType(MesWmTransactionTypeEnum.IN.getType()).setItemId(detail.getItemId()) .setQuantity(detail.getQuantity()) // 库存增加 .setBatchId(detail.getBatchId()).setBatchCode(detail.getBatchCode()) .setWarehouseId(virtualWarehouse.getId()).setLocationId(virtualLocation.getId()).setAreaId(virtualArea.getId()) .setBizType(MesBizTypeConstants.WM_ISSUE).setBizId(issue.getId()) .setBizCode(issue.getCode()).setBizLineId(detail.getLineId()) .setRelatedTransactionId(outTransactionId)); // 关联出库事务 } } /** * 领料出库完成时,自动创建任务投料记录 * 按行遍历,每行创建一条 task_issue 记录 */ private void createTaskIssueRecords(MesWmProductIssueDO issue) { List lines = issueLineService.getProductIssueLineListByIssueId(issue.getId()); if (CollUtil.isEmpty(lines)) { return; } // 批量查询物料信息(获取 unitMeasureId) Map itemMap = mdmItemService.getItemMap( CollectionUtils.convertSet(lines, MesWmProductIssueLineDO::getItemId)); // 获取明细列表,用于提取 batchCode List details = issueDetailService.getProductIssueDetailListByIssueId(issue.getId()); Map> detailMapByLineId = CollectionUtils.convertMultiMap( details, MesWmProductIssueDetailDO::getLineId); for (MesWmProductIssueLineDO line : lines) { // 行的 taskId 优先,否则取主表的 taskId Long taskId = line.getTaskId() != null ? line.getTaskId() : issue.getTaskId(); if (taskId == null) { continue; } // 获取物料单位 MesMdItemDO item = itemMap.get(line.getItemId()); Long unitMeasureId = item != null ? item.getUnitMeasureId() : null; // 获取批次号:取该行第一个明细的 batchCode String batchCode = null; List lineDetails = detailMapByLineId.get(line.getId()); if (CollUtil.isNotEmpty(lineDetails)) { MesWmProductIssueDetailDO firstDetail = lineDetails.get(0); batchCode = firstDetail.getBatchCode(); } // 创建任务投料记录 MesProTaskIssueDO taskIssue = MesProTaskIssueDO.builder() .taskId(taskId) .workOrderId(issue.getWorkOrderId()) .workstationId(issue.getWorkstationId()) .sourceDocType("PRODUCT_ISSUE") .sourceDocId(issue.getId()) .sourceLineId(line.getId()) .sourceDocCode(issue.getCode()) .batchCode(batchCode) .itemId(line.getItemId()) .unitMeasureId(unitMeasureId) .issuedQuantity(line.getQuantity()) .availableQuantity(line.getQuantity()) // 初始全可用 .usedQuantity(BigDecimal.ZERO) .build(); taskIssueMapper.insert(taskIssue); } } @Override @Transactional(rollbackFor = Exception.class) public void cancelProductIssue(Long id) { // 校验存在 MesWmProductIssueDO issue = validateProductIssueExists(id); // 已完成和已取消不允许取消 if (ObjectUtils.equalsAny(issue.getStatus(), MesWmProductIssueStatusEnum.FINISHED.getStatus(), MesWmProductIssueStatusEnum.CANCELED.getStatus())) { throw exception(WM_PRODUCT_ISSUE_CANCEL_NOT_ALLOWED); } // 释放库存占用 stockReserveService.releaseReserve(MesWmStockReserveBizTypeEnum.PRODUCT_ISSUE.getType(), id); // 删除通过该领料单创建的任务投料记录 taskIssueService.deleteTaskIssueBySourceDoc("PRODUCT_ISSUE", id); // 取消 issueMapper.updateById(new MesWmProductIssueDO() .setId(id).setStatus(MesWmProductIssueStatusEnum.CANCELED.getStatus())); } @Override public Boolean checkProductIssueQuantity(Long id) { List lines = issueLineService.getProductIssueLineListByIssueId(id); for (MesWmProductIssueLineDO line : lines) { List details = issueDetailService.getProductIssueDetailListByLineId(line.getId()); BigDecimal totalDetailQty = CollectionUtils.getSumValue(details, MesWmProductIssueDetailDO::getQuantity, BigDecimal::add, BigDecimal.ZERO); if (line.getQuantity() != null && totalDetailQty.compareTo(line.getQuantity()) != 0) { return false; } } return true; } @Override public MesWmProductIssueDO validateProductIssueExists(Long id) { MesWmProductIssueDO issue = issueMapper.selectById(id); if (issue == null) { throw exception(WM_PRODUCT_ISSUE_NOT_EXISTS); } return issue; } /** * 校验领料出库单存在且为准备中状态 */ @Override public MesWmProductIssueDO validateProductIssueExistsAndPrepare(Long id) { MesWmProductIssueDO issue = validateProductIssueExists(id); if (ObjUtil.notEqual(MesWmProductIssueStatusEnum.PREPARE.getStatus(), issue.getStatus())) { throw exception(WM_PRODUCT_ISSUE_STATUS_INVALID); } return issue; } /** * 校验编码唯一性 */ private void validateCodeUnique(Long id, String code) { MesWmProductIssueDO issue = issueMapper.selectByCode(code); if (issue == null) { return; } if (ObjUtil.notEqual(id, issue.getId())) { throw exception(WM_PRODUCT_ISSUE_CODE_DUPLICATE); } } /** * 校验保存时的关联数据 */ private void validateProductIssueSaveData(MesWmProductIssueSaveReqVO reqVO) { validateCodeUnique(reqVO.getId(), reqVO.getCode()); // 校验 task 存在 MesProTaskDO task = taskService.validateTaskExists(reqVO.getTaskId()); // 校验 task 关联的工单已确认 Long workOrderId = reqVO.getWorkOrderId() != null ? reqVO.getWorkOrderId() : task.getWorkOrderId(); if (workOrderId != null) { workOrderService.validateWorkOrderConfirmed(workOrderId); } if (reqVO.getWorkstationId() != null) { workstationService.validateWorkstationExistsAndEnable(reqVO.getWorkstationId()); } } @Override @Transactional(rollbackFor = Exception.class) public MesWmProductIssueImportRespVO importProductIssueList(List importList, boolean updateSupport) { if (CollUtil.isEmpty(importList)) { throw exception(WM_PRODUCT_ISSUE_IMPORT_LIST_IS_EMPTY); } MesWmProductIssueImportRespVO respVO = MesWmProductIssueImportRespVO.builder() .createCodes(new ArrayList<>()).updateCodes(new ArrayList<>()) .failureCodes(new LinkedHashMap<>()).build(); AtomicInteger index = new AtomicInteger(1); importList.forEach(importItem -> { int currentIndex = index.getAndIncrement(); String code = importItem.getCode(); String key = StrUtil.blankToDefault(code, "第 " + currentIndex + " 行"); if (StrUtil.isBlank(code)) { respVO.getFailureCodes().put(key, "单号不能为空"); return; } if (StrUtil.isBlank(importItem.getName())) { respVO.getFailureCodes().put(key, "名称不能为空"); return; } MesWmProductIssueDO existing = issueMapper.selectByCode(code); if (existing != null && updateSupport) { if (!MesWmProductIssueStatusEnum.PREPARE.getStatus().equals(existing.getStatus())) { respVO.getFailureCodes().put(key, "单据非草稿状态,不允许覆盖更新"); return; } MesWmProductIssueDO updateObj = BeanUtils.toBean(importItem, MesWmProductIssueDO.class); updateObj.setId(existing.getId()); updateObj.setStatus(existing.getStatus()); issueMapper.updateById(updateObj); respVO.getUpdateCodes().add(code); } else if (existing != null) { respVO.getFailureCodes().put(key, "单号已存在:" + code); } else { MesWmProductIssueDO createObj = BeanUtils.toBean(importItem, MesWmProductIssueDO.class); createObj.setId(null); createObj.setStatus(MesWmProductIssueStatusEnum.PREPARE.getStatus()); issueMapper.insert(createObj); respVO.getCreateCodes().add(code); } }); return respVO; } }