package cn.iocoder.yudao.module.mes.service.wm.itemreceipt; 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.itemreceipt.vo.MesWmItemReceiptPageReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.itemreceipt.vo.MesWmItemReceiptImportExcelVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.itemreceipt.vo.MesWmItemReceiptSaveReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.itemreceipt.vo.line.MesWmItemReceiptLineSaveReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.vo.MesWmDocImportRespVO; import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdItemDO; import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService; import cn.iocoder.yudao.module.srm.api.supplier.dto.SrmSupplierRespDTO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.arrivalnotice.MesWmArrivalNoticeDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.itemreceipt.MesWmItemReceiptDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.itemreceipt.MesWmItemReceiptDetailDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.itemreceipt.MesWmItemReceiptLineDO; import cn.iocoder.yudao.module.mes.dal.mysql.wm.itemreceipt.MesWmItemReceiptMapper; import cn.iocoder.yudao.module.mes.enums.MesBizTypeConstants; import cn.iocoder.yudao.module.mes.enums.wm.MesWmItemReceiptStatusEnum; import cn.iocoder.yudao.module.mes.enums.wm.MesWmTransactionTypeEnum; import cn.iocoder.yudao.module.bpm.enums.task.BpmTaskStatusEnum; import cn.iocoder.yudao.module.mes.service.qc.iqc.MesQcIqcService; import cn.iocoder.yudao.module.mes.service.wm.arrivalnotice.MesWmArrivalNoticeService; import cn.iocoder.yudao.module.mes.service.wm.arrivalnotice.MesWmArrivalNoticeLineService; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.arrivalnotice.MesWmArrivalNoticeLineDO; 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.bpm.api.task.BpmProcessInstanceApi; import cn.iocoder.yudao.module.bpm.api.task.dto.BpmProcessInstanceCreateReqDTO; import cn.iocoder.yudao.module.erp.api.purchase.ErpPurchaseOrderApi; import cn.iocoder.yudao.module.srm.api.supplier.SrmSupplierApi; import cn.iocoder.yudao.module.mdm.api.item.MdmItemApi; import cn.iocoder.yudao.module.mdm.api.item.dto.MdmItemRespDTO; import org.springframework.security.core.Authentication; import org.springframework.security.core.context.SecurityContextHolder; import jakarta.annotation.Resource; import org.springframework.context.annotation.Lazy; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.validation.annotation.Validated; import lombok.extern.slf4j.Slf4j; import java.math.BigDecimal; import java.time.LocalDate; import java.time.LocalDateTime; import java.util.ArrayList; import java.util.Collection; import java.util.HashMap; import java.util.LinkedHashMap; import java.util.List; import java.util.Map; 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.*; /** * MES 采购入库单 Service 实现类 */ @Service @Validated @Slf4j public class MesWmItemReceiptServiceImpl implements MesWmItemReceiptService { @Resource private MesWmItemReceiptMapper itemReceiptMapper; @Resource private MesWmItemReceiptLineService itemReceiptLineService; @Resource private MesWmItemReceiptDetailService itemReceiptDetailService; @Resource @Lazy private MesWmArrivalNoticeService arrivalNoticeService; @Resource @Lazy private SrmSupplierApi srmSupplierApi; @Resource @Lazy private MesQcIqcService iqcService; @Resource private MesWmTransactionService wmTransactionService; @Resource private MesWmArrivalNoticeLineService arrivalNoticeLineService; @Resource @Lazy private MesMdItemService mdItemService; @Resource private BpmProcessInstanceApi processInstanceApi; @Resource private ErpPurchaseOrderApi purchaseOrderApi; @Resource private MdmItemApi mdmItemApi; @Override public Long createItemReceipt(MesWmItemReceiptSaveReqVO createReqVO) { // 校验数据 validateItemReceiptSaveData(createReqVO); // 插入 MesWmItemReceiptDO receipt = BeanUtils.toBean(createReqVO, MesWmItemReceiptDO.class); receipt.setStatus(MesWmItemReceiptStatusEnum.PREPARE.getStatus()); itemReceiptMapper.insert(receipt); return receipt.getId(); } @Override public void updateItemReceipt(MesWmItemReceiptSaveReqVO updateReqVO) { // 校验存在 + 草稿状态 validateItemReceiptExistsAndDraft(updateReqVO.getId()); // 校验数据 validateItemReceiptSaveData(updateReqVO); // 更新 MesWmItemReceiptDO updateObj = BeanUtils.toBean(updateReqVO, MesWmItemReceiptDO.class); itemReceiptMapper.updateById(updateObj); } private void validateItemReceiptSaveData(MesWmItemReceiptSaveReqVO reqVO) { // 校验编码唯一 validateCodeUnique(reqVO.getId(), reqVO.getCode()); // 校验供应商存在(采购入库使用 ERP 供应商) srmSupplierApi.getSupplier(reqVO.getVendorId()); // 校验到货通知单存在 if (reqVO.getNoticeId() != null) { MesWmArrivalNoticeDO notice = arrivalNoticeService.validateArrivalNoticeReadyForReceipt(reqVO.getNoticeId()); if (ObjUtil.notEqual(notice.getVendorId(), reqVO.getVendorId())) { throw exception(WM_ARRIVAL_NOTICE_VENDOR_MISMATCH); } } // 校验来料检验单存在 if (reqVO.getIqcId() != null) { iqcService.validateIqcExists(reqVO.getIqcId()); } } @Override @Transactional(rollbackFor = Exception.class) public void deleteItemReceipt(Long id) { // 校验存在 + 草稿状态 validateItemReceiptExistsAndDraft(id); // 级联删除明细和行 itemReceiptDetailService.deleteItemReceiptDetailByReceiptId(id); itemReceiptLineService.deleteItemReceiptLineByReceiptId(id); // 删除 itemReceiptMapper.deleteById(id); } @Override public MesWmItemReceiptDO getItemReceipt(Long id) { return itemReceiptMapper.selectById(id); } @Override public PageResult getItemReceiptPage(MesWmItemReceiptPageReqVO pageReqVO) { return itemReceiptMapper.selectPage(pageReqVO); } @Override @Transactional(rollbackFor = Exception.class) public void submitItemReceipt(Long id) { // 校验存在 + 草稿状态 validateItemReceiptExistsAndDraft(id); // 校验至少有一条行 List lines = itemReceiptLineService.getItemReceiptLineListByReceiptId(id); if (CollUtil.isEmpty(lines)) { throw exception(WM_ITEM_RECEIPT_NO_LINE); } // 校验物料批次管理:如果物料开启批次管理,则明细的批次号不能为空 validateBatchManagement(lines); // 提交(草稿 → 待上架) itemReceiptMapper.updateById(new MesWmItemReceiptDO() .setId(id).setStatus(MesWmItemReceiptStatusEnum.APPROVING.getStatus())); } /** * 校验物料批次管理:如果物料开启批次管理,则行的批次号不能为空 */ private void validateBatchManagement(List lines) { // 获取所有物料ID List itemIds = CollectionUtils.convertList(lines, MesWmItemReceiptLineDO::getItemId); Map itemMap = mdmItemApi.getItemMap(itemIds); // 遍历每一行,检查物料是否开启批次管理 for (MesWmItemReceiptLineDO line : lines) { MdmItemRespDTO item = itemMap.get(line.getItemId()); if (item == null) { continue; } // 如果物料开启批次管理,检查行上的批次号是否为空 if (Boolean.TRUE.equals(item.getIsBatchManaged()) && line.getBatchId() == null) { throw exception(WM_ITEM_RECEIPT_BATCH_REQUIRED, item.getCode(), item.getName()); } } } @Override @Transactional(rollbackFor = Exception.class) public void stockItemReceipt(Long id) { // 校验存在 MesWmItemReceiptDO receipt = validateItemReceiptExists(id); if (ObjUtil.notEqual(MesWmItemReceiptStatusEnum.APPROVING.getStatus(), receipt.getStatus())) { throw exception(WM_ITEM_RECEIPT_STATUS_ERROR); } // 校验每行明细数量之和是否等于行入库数量 List lines = itemReceiptLineService.getItemReceiptLineListByReceiptId(id); if (CollUtil.isEmpty(lines)) { throw exception(WM_ITEM_RECEIPT_NO_LINE); } for (MesWmItemReceiptLineDO line : lines) { List details = itemReceiptDetailService.getItemReceiptDetailListByLineId(line.getId()); BigDecimal totalDetailQty = CollectionUtils.getSumValue(details, MesWmItemReceiptDetailDO::getQuantity, BigDecimal::add, BigDecimal.ZERO); if (line.getReceivedQuantity() == null || totalDetailQty.compareTo(line.getReceivedQuantity()) != 0) { throw exception(WM_ITEM_RECEIPT_DETAIL_QUANTITY_MISMATCH); } } // 执行上架(待上架 → 待入库) itemReceiptMapper.updateById(new MesWmItemReceiptDO() .setId(id).setStatus(MesWmItemReceiptStatusEnum.APPROVED.getStatus())); } @Override @Transactional(rollbackFor = Exception.class) public void finishItemReceipt(Long id) { // 1. 校验存在 MesWmItemReceiptDO receipt = validateItemReceiptExists(id); if (ObjUtil.notEqual(MesWmItemReceiptStatusEnum.APPROVED.getStatus(), receipt.getStatus())) { throw exception(WM_ITEM_RECEIPT_STATUS_ERROR); } // 2. 遍历所有明细,创建库存事务(增加库存 + 记录流水) createTransactionList(receipt); // 3. 更新入库单状态 itemReceiptMapper.updateById(new MesWmItemReceiptDO() .setId(id).setStatus(MesWmItemReceiptStatusEnum.FINISHED.getStatus())); // 4. 更新关联的到货通知单状态 if (receipt.getNoticeId() != null) { arrivalNoticeService.finishArrivalNotice(receipt.getNoticeId()); } // 5. 回写 ERP 采购订单的入库数量 updateErpPurchaseOrderInCount(receipt); } /** * 回写 ERP 采购订单的入库数量 */ private void updateErpPurchaseOrderInCount(MesWmItemReceiptDO receipt) { // 1. 确定采购订单 ID:优先从入库单头取(从到货通知单带入),其次从行反查 Long purchaseOrderId = receipt.getPurchaseOrderId(); if (purchaseOrderId == null && receipt.getNoticeId() != null) { // 从关联的到货通知单获取采购订单 ID MesWmArrivalNoticeDO notice = arrivalNoticeService.getArrivalNotice(receipt.getNoticeId()); if (notice != null) { purchaseOrderId = notice.getPurchaseOrderId(); } } // 2. 获取入库单行,按 purchaseOrderItemId 更新入库数量 List lines = itemReceiptLineService.getItemReceiptLineListByReceiptId(receipt.getId()); if (CollUtil.isNotEmpty(lines)) { for (MesWmItemReceiptLineDO line : lines) { if (line.getPurchaseOrderItemId() != null && line.getReceivedQuantity() != null) { purchaseOrderApi.updateOrderItemInCount(line.getPurchaseOrderItemId(), line.getReceivedQuantity()); // 如果还没拿到 purchaseOrderId,从明细项反查 if (purchaseOrderId == null) { cn.iocoder.yudao.module.erp.api.purchase.dto.ErpPurchaseOrderItemRespDTO itemDTO = purchaseOrderApi.getPurchaseOrderItem(line.getPurchaseOrderItemId()).getCheckedData(); if (itemDTO != null && itemDTO.getOrderId() != null) { purchaseOrderId = itemDTO.getOrderId(); } } } } } else if (receipt.getNoticeId() != null) { // 兜底:入库行为空时,从到货通知单行回写入库数量 List noticeLines = arrivalNoticeLineService .getArrivalNoticeLineListByNoticeId(receipt.getNoticeId()); for (MesWmArrivalNoticeLineDO noticeLine : noticeLines) { if (noticeLine.getPurchaseOrderItemId() != null) { // 使用合格数量(有 IQC 时为合格数量,否则为到货数量) BigDecimal qty = noticeLine.getQualifiedQuantity() != null ? noticeLine.getQualifiedQuantity() : noticeLine.getArrivalQuantity(); if (qty != null && qty.compareTo(BigDecimal.ZERO) > 0) { purchaseOrderApi.updateOrderItemInCount(noticeLine.getPurchaseOrderItemId(), qty); } } } } // 3. 更新采购订单的入库状态 if (purchaseOrderId != null) { purchaseOrderApi.updateOrderInStatus(purchaseOrderId); } } private void createTransactionList(MesWmItemReceiptDO receipt) { List details = itemReceiptDetailService.getItemReceiptDetailListByReceiptId(receipt.getId()); // 获取所有行信息,用于获取批次号 List lines = itemReceiptLineService.getItemReceiptLineListByReceiptId(receipt.getId()); Map lineMap = CollectionUtils.convertMap(lines, MesWmItemReceiptLineDO::getId); wmTransactionService.createTransactionList(convertList(details, detail -> { // 从行上获取批次信息(如果明细没有批次号) MesWmItemReceiptLineDO line = lineMap.get(detail.getLineId()); Long batchId = detail.getBatchId() != null ? detail.getBatchId() : (line != null ? line.getBatchId() : null); String batchCode = line != null ? line.getBatchCode() : null; return new MesWmTransactionSaveReqDTO() .setType(MesWmTransactionTypeEnum.IN.getType()).setItemId(detail.getItemId()) .setQuantity(detail.getQuantity()) .setBatchId(batchId).setBatchCode(batchCode) .setWarehouseId(detail.getWarehouseId()).setLocationId(detail.getLocationId()).setAreaId(detail.getAreaId()) .setVendorId(receipt.getVendorId()).setReceiptTime(receipt.getReceiptDate()) .setBizType(MesBizTypeConstants.WM_ITEM_RECEIPT_IN).setBizId(receipt.getId()) .setBizCode(receipt.getCode()).setBizLineId(detail.getLineId()); })); } @Override @Transactional(rollbackFor = Exception.class) public void cancelItemReceipt(Long id) { // 校验存在 MesWmItemReceiptDO receipt = validateItemReceiptExists(id); // 已完成和已取消不允许取消 if (ObjectUtils.equalsAny(receipt.getStatus(), MesWmItemReceiptStatusEnum.FINISHED.getStatus(), MesWmItemReceiptStatusEnum.CANCELED.getStatus())) { throw exception(WM_ITEM_RECEIPT_CANCEL_NOT_ALLOWED); } // 取消 itemReceiptMapper.updateById(new MesWmItemReceiptDO() .setId(id).setStatus(MesWmItemReceiptStatusEnum.CANCELED.getStatus())); } @Override public MesWmItemReceiptDO validateItemReceiptEditable(Long id) { MesWmItemReceiptDO receipt = validateItemReceiptExists(id); if (ObjUtil.notEqual(receipt.getStatus(), MesWmItemReceiptStatusEnum.PREPARE.getStatus()) && ObjUtil.notEqual(receipt.getStatus(), MesWmItemReceiptStatusEnum.APPROVING.getStatus())) { throw exception(WM_ITEM_RECEIPT_STATUS_NOT_PREPARE); } return receipt; } private MesWmItemReceiptDO validateItemReceiptExists(Long id) { MesWmItemReceiptDO receipt = itemReceiptMapper.selectById(id); if (receipt == null) { throw exception(WM_ITEM_RECEIPT_NOT_EXISTS); } return receipt; } /** * 校验采购入库单存在且为草稿状态 */ private MesWmItemReceiptDO validateItemReceiptExistsAndDraft(Long id) { MesWmItemReceiptDO receipt = validateItemReceiptExists(id); if (ObjUtil.notEqual(MesWmItemReceiptStatusEnum.PREPARE.getStatus(), receipt.getStatus())) { throw exception(WM_ITEM_RECEIPT_STATUS_NOT_PREPARE); } return receipt; } private void validateCodeUnique(Long id, String code) { MesWmItemReceiptDO receipt = itemReceiptMapper.selectByCode(code); if (receipt == null) { return; } if (ObjUtil.notEqual(id, receipt.getId())) { throw exception(WM_ITEM_RECEIPT_CODE_DUPLICATE); } } @Override public Long getItemReceiptCountByVendorId(Long vendorId) { return itemReceiptMapper.selectCountByVendorId(vendorId); } @Override public List getItemReceiptListByVendorId(Long vendorId) { return itemReceiptMapper.selectListByVendorId(vendorId); } @Override public List getItemReceiptList(Collection ids) { return itemReceiptMapper.selectByIds(ids); } @Override @Transactional(rollbackFor = Exception.class) public Long generateItemReceiptFromArrivalNotice(Long arrivalNoticeId) { // 1. 校验到货通知单存在且状态为待入库 MesWmArrivalNoticeDO notice = arrivalNoticeService.validateArrivalNoticeReadyForReceipt(arrivalNoticeId); // 2. 校验是否已生成过入库单(防止重复生成) MesWmItemReceiptDO existReceipt = itemReceiptMapper.selectByNoticeId(arrivalNoticeId); if (existReceipt != null) { throw exception(WM_ITEM_RECEIPT_ALREADY_EXISTS); } // 3. 获取到货通知单行 List lines = arrivalNoticeLineService.getArrivalNoticeLineListByNoticeId(arrivalNoticeId); if (CollUtil.isEmpty(lines)) { throw exception(WM_ARRIVAL_NOTICE_NO_LINE); } // 4. 生成入库单编码 String code = generateItemReceiptCode(); // 5. 创建入库单主表 MesWmItemReceiptDO receipt = new MesWmItemReceiptDO(); receipt.setCode(code); receipt.setName(notice.getName() + "入库单"); receipt.setNoticeId(arrivalNoticeId); receipt.setPurchaseOrderId(notice.getPurchaseOrderId()); receipt.setPurchaseOrderCode(notice.getPurchaseOrderCode()); receipt.setVendorId(notice.getVendorId()); receipt.setReceiptDate(java.time.LocalDateTime.now()); // 入库时间为当前时间 receipt.setStatus(MesWmItemReceiptStatusEnum.PREPARE.getStatus()); itemReceiptMapper.insert(receipt); // 6. 遍历行创建入库单行 for (MesWmArrivalNoticeLineDO noticeLine : lines) { MesWmItemReceiptLineDO receiptLine = new MesWmItemReceiptLineDO(); receiptLine.setReceiptId(receipt.getId()); receiptLine.setArrivalNoticeLineId(noticeLine.getId()); receiptLine.setPurchaseOrderItemId(noticeLine.getPurchaseOrderItemId()); receiptLine.setItemId(noticeLine.getItemId()); // 使用合格数量(如果有 IQC 则是合格数量,否则是到货数量) receiptLine.setReceivedQuantity(noticeLine.getQualifiedQuantity() != null ? noticeLine.getQualifiedQuantity() : noticeLine.getArrivalQuantity()); itemReceiptLineService.createItemReceiptLineFromArrivalNoticeLine(receiptLine); } return receipt.getId(); } @Override @Transactional(rollbackFor = Exception.class) public void submitItemReceiptApproval(Long id, String processDefinitionKey) { // 1. 校验存在 + 草稿状态 validateItemReceiptExistsAndDraft(id); // 2. 创建 BPM 流程实例 Long userId = getCurrentUserId(); // 全局免审批:业务校验通过后直接执行审批通过逻辑,无需流程模型。 if (processInstanceApi.isGlobalAutoApprove()) { itemReceiptMapper.updateById(new MesWmItemReceiptDO() .setId(id) .setStatus(MesWmItemReceiptStatusEnum.APPROVING.getStatus()) .setProcessInstanceId("")); updateItemReceiptAuditStatus(id, cn.iocoder.yudao.module.bpm.enums.task.BpmProcessInstanceStatusEnum.APPROVE.getStatus()); return; } String processInstanceId = processInstanceApi.createProcessInstance(userId, new BpmProcessInstanceCreateReqDTO() .setProcessDefinitionKey(processDefinitionKey) .setBusinessKey(String.valueOf(id))); // 3. 更新入库单状态为审批中 itemReceiptMapper.updateById(new MesWmItemReceiptDO() .setId(id) .setStatus(MesWmItemReceiptStatusEnum.APPROVING.getStatus()) .setProcessInstanceId(processInstanceId)); } @Override @Transactional(rollbackFor = Exception.class) public void updateItemReceiptAuditStatus(Long id, Integer bpmResult) { // 1. 校验存在 MesWmItemReceiptDO receipt = validateItemReceiptExists(id); if (!MesWmItemReceiptStatusEnum.APPROVING.getStatus().equals(receipt.getStatus())) { log.warn("[updateItemReceiptAuditStatus] 入库单({}) 不处于审批中状态", id); return; } // 2. 根据审批结果更新状态 Integer newStatus = convertBpmResultToReceiptStatus(bpmResult); if (newStatus != null) { itemReceiptMapper.updateById(new MesWmItemReceiptDO() .setId(id).setStatus(newStatus)); } } /** * 转换 BPM 审批结果为入库单状态 */ private Integer convertBpmResultToReceiptStatus(Integer bpmResult) { if (BpmTaskStatusEnum.APPROVE.getStatus().equals(bpmResult)) { return MesWmItemReceiptStatusEnum.APPROVED.getStatus(); } else if (BpmTaskStatusEnum.REJECT.getStatus().equals(bpmResult)) { return MesWmItemReceiptStatusEnum.PREPARE.getStatus(); } else if (BpmTaskStatusEnum.CANCEL.getStatus().equals(bpmResult)) { return MesWmItemReceiptStatusEnum.CANCELED.getStatus(); } return null; } /** * 获取当前用户 ID */ private Long getCurrentUserId() { Authentication authentication = SecurityContextHolder.getContext().getAuthentication(); if (authentication != null && authentication.getPrincipal() instanceof Long) { return (Long) authentication.getPrincipal(); } return 1L; // 默认用户 } /** * 生成入库单编码 */ private String generateItemReceiptCode() { // TODO: 使用编码规则服务生成编码 return "IR" + System.currentTimeMillis(); } // ==================== 批量导入 ==================== @Override @Transactional(rollbackFor = Exception.class) public MesWmDocImportRespVO importItemReceiptList(List importList) { MesWmDocImportRespVO respVO = MesWmDocImportRespVO.empty(); if (CollUtil.isEmpty(importList)) { return respVO; } // 1. 按「入库单编码」归并成单据 + 明细行 Map> grouped = new LinkedHashMap<>(); int index = 0; for (MesWmItemReceiptImportExcelVO row : importList) { index++; String code = StrUtil.trim(row.getReceiptCode()); if (StrUtil.isBlank(code)) { respVO.getFailureCodes().put("第 " + index + " 行", "入库单编码不能为空"); continue; } grouped.computeIfAbsent(code, k -> new ArrayList<>()).add(row); } // 2. 预加载供应商,按名称建索引 // 注意:getSupplierSimpleList() 只返回特定状态的供应商,可能缺少历史/停用供应商, // 因此这里以「供应商名称」逐行兜底查询(见 resolveVendorId)。 Map vendorMap = new HashMap<>(); try { List suppliers = srmSupplierApi.getSupplierSimpleList().getCheckedData(); if (CollUtil.isNotEmpty(suppliers)) { suppliers.forEach(s -> { if (StrUtil.isNotBlank(s.getName())) { vendorMap.put(s.getName().trim(), s.getId()); } }); } } catch (Exception e) { log.warn("[importItemReceiptList][加载供应商简洁列表失败,将逐行查询]", e); } // 3. 逐张单据处理 for (Map.Entry> entry : grouped.entrySet()) { String code = entry.getKey(); List rows = entry.getValue(); MesWmItemReceiptImportExcelVO head = rows.get(0); try { // 3.1 校验供应商 String vendorName = StrUtil.trim(head.getVendorName()); Long vendorId = vendorName == null ? null : vendorMap.get(vendorName); if (vendorId == null && vendorName != null) { // 兜底:简洁列表可能未覆盖该供应商,按名称查询 SrmSupplierRespDTO supplier = findSupplierByName(vendorName); if (supplier != null) { vendorId = supplier.getId(); vendorMap.put(vendorName, vendorId); } } if (vendorId == null) { respVO.getFailureCodes().put(code, "供应商[" + vendorName + "]不存在"); continue; } // 3.2 校验日期与编码 LocalDateTime receiptDate = parseImportDateTime(head.getReceiptDate()); if (receiptDate == null) { respVO.getFailureCodes().put(code, "入库日期不能为空或格式不正确(支持 yyyy-MM-dd / yyyy-MM-dd HH:mm:ss)"); continue; } if (itemReceiptMapper.selectByCode(code) != null) { respVO.getFailureCodes().put(code, "入库单编码已存在"); continue; } // 3.3 创建单据头 MesWmItemReceiptSaveReqVO saveReqVO = new MesWmItemReceiptSaveReqVO(); saveReqVO.setCode(code); saveReqVO.setName(StrUtil.blankToDefault(StrUtil.trim(head.getReceiptName()), code)); saveReqVO.setVendorId(vendorId); saveReqVO.setReceiptDate(receiptDate); saveReqVO.setPurchaseOrderCode(StrUtil.trim(head.getPurchaseOrderCode())); saveReqVO.setRemark(StrUtil.trim(head.getRemark())); Long receiptId = createItemReceipt(saveReqVO); // 3.4 逐行创建明细 for (MesWmItemReceiptImportExcelVO row : rows) { createItemReceiptLineByImport(receiptId, row, respVO, code); } respVO.getCreateCodes().add(code); } catch (Exception e) { respVO.getFailureCodes().put(code, e.getMessage() == null ? "导入失败" : e.getMessage()); } } return respVO; } /** * 导入时创建单行明细;失败只记录不抛出,避免影响整张单据的其它行 */ private void createItemReceiptLineByImport(Long receiptId, MesWmItemReceiptImportExcelVO row, MesWmDocImportRespVO respVO, String receiptCode) { String itemCode = StrUtil.trim(row.getItemCode()); MesMdItemDO item = itemCode == null ? null : mdItemService.getItemByCode(itemCode); if (item == null) { respVO.getFailureCodes().put(receiptCode, "物料编码[" + itemCode + "]不存在,该行已跳过"); return; } if (row.getReceivedQuantity() == null || row.getReceivedQuantity().signum() <= 0) { respVO.getFailureCodes().put(receiptCode, "物料[" + itemCode + "]入库数量必须大于 0,该行已跳过"); return; } try { MesWmItemReceiptLineSaveReqVO lineReqVO = new MesWmItemReceiptLineSaveReqVO(); lineReqVO.setReceiptId(receiptId); lineReqVO.setItemId(item.getId()); lineReqVO.setReceivedQuantity(row.getReceivedQuantity()); lineReqVO.setProductionDate(parseImportDateTime(row.getProductionDate())); lineReqVO.setExpireDate(parseImportDateTime(row.getExpireDate())); lineReqVO.setLotNumber(StrUtil.trim(row.getLotNumber())); lineReqVO.setRemark(StrUtil.trim(row.getRemark())); itemReceiptLineService.createItemReceiptLine(lineReqVO); } catch (Exception e) { respVO.getFailureCodes().put(receiptCode, "物料[" + itemCode + "]明细创建失败:" + e.getMessage()); } } /** * 按名称查找供应商(兜底) * * getSupplierSimpleList() 只返回已通过准入审批的供应商, * 历史导入或未走准入流程的供应商不在其中,因此退化为全量匹配。 */ private SrmSupplierRespDTO findSupplierByName(String name) { try { var simple = srmSupplierApi.getSupplierSimpleList(); if (simple != null && CollUtil.isNotEmpty(simple.getCheckedData())) { SrmSupplierRespDTO hit = simple.getCheckedData().stream() .filter(s -> name.equals(StrUtil.trim(s.getName()))) .findFirst().orElse(null); if (hit != null) { return hit; } } } catch (Exception e) { log.warn("[findSupplierByName][简洁列表查询失败,改用全量]", e); } try { var all = srmSupplierApi.getSupplierAllList(); if (all != null && CollUtil.isNotEmpty(all.getCheckedData())) { return all.getCheckedData().stream() .filter(s -> name.equals(StrUtil.trim(s.getName()))) .findFirst().orElse(null); } } catch (Exception e) { log.warn("[findSupplierByName][全量列表查询失败]", e); } return null; } /** * 解析导入日期,支持 yyyy-MM-dd 与 yyyy-MM-dd HH:mm:ss,失败返回 null */ private LocalDateTime parseImportDateTime(String text) { if (StrUtil.isBlank(text)) { return null; } String value = text.trim().replace('/', '-'); try { if (value.length() <= 10) { return LocalDate.parse(value).atStartOfDay(); } return LocalDateTime.parse(value.replace(' ', 'T')); } catch (Exception e) { return null; } } }