package cn.iocoder.yudao.module.mes.service.wm.productsales; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.util.ObjUtil; import cn.hutool.core.util.StrUtil; import cn.iocoder.yudao.framework.common.enums.CommonStatusEnum; import cn.iocoder.yudao.framework.common.exception.ServiceException; 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.crm.api.customer.dto.CrmCustomerRespDTO; import cn.iocoder.yudao.module.mes.controller.admin.wm.productsales.vo.MesWmProductSalesImportExcelVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.productsales.vo.MesWmProductSalesImportRespVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.productsales.vo.MesWmProductSalesPageReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.productsales.vo.MesWmProductSalesSaveReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.productsales.vo.MesWmProductSalesShippingReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.productsales.vo.line.MesWmProductSalesLineSaveReqVO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.batch.MesWmBatchDO; import cn.iocoder.yudao.module.mes.enums.md.autocode.MesMdAutoCodeRuleCodeEnum; import cn.iocoder.yudao.module.mes.service.md.autocode.MesMdAutoCodeRecordService; import cn.iocoder.yudao.module.mes.service.wm.batch.MesWmBatchService; import cn.iocoder.yudao.module.mdm.api.item.MdmItemApi; import cn.iocoder.yudao.module.mdm.api.item.dto.MdmItemRespDTO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.salesnotice.MesWmSalesNoticeDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productsales.MesWmProductSalesDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productsales.MesWmProductSalesDetailDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productsales.MesWmProductSalesLineDO; import cn.iocoder.yudao.module.mes.dal.mysql.wm.productsales.MesWmProductSalesMapper; import cn.iocoder.yudao.module.mes.dal.mysql.wm.productsales.MesWmProductSalesLineMapper; import cn.iocoder.yudao.module.mes.enums.MesBizTypeConstants; import cn.iocoder.yudao.module.mes.enums.wm.MesWmProductSalesStatusEnum; import cn.iocoder.yudao.module.mes.enums.wm.MesWmQualityStatusEnum; import cn.iocoder.yudao.module.mes.enums.wm.MesWmSalesNoticeStatusEnum; import cn.iocoder.yudao.module.mes.enums.wm.MesWmStockReserveBizTypeEnum; import cn.iocoder.yudao.module.mes.enums.wm.MesWmTransactionTypeEnum; import cn.iocoder.yudao.module.crm.api.customer.CrmCustomerApi; import cn.iocoder.yudao.module.mes.service.wm.materialstock.MesWmMaterialStockService; import cn.iocoder.yudao.module.mes.service.wm.salesnotice.MesWmSalesNoticeService; 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.qc.oqc.MesQcOqcService; import cn.iocoder.yudao.module.erp.api.sale.ErpSaleOrderApi; import cn.iocoder.yudao.module.erp.api.sale.enums.ErpSaleOrderOutStatusEnum; import jakarta.annotation.Resource; import lombok.extern.slf4j.Slf4j; import org.springframework.context.annotation.Lazy; import org.springframework.stereotype.Service; import org.springframework.transaction.PlatformTransactionManager; import org.springframework.transaction.annotation.Transactional; import org.springframework.transaction.support.TransactionTemplate; import org.springframework.validation.annotation.Validated; import java.math.BigDecimal; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; import java.util.ArrayList; 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 实现类 * * @author 超级管理员 */ @Service @Validated @Slf4j public class MesWmProductSalesServiceImpl implements MesWmProductSalesService { @Resource private MesWmProductSalesMapper productSalesMapper; @Resource private MesWmProductSalesLineMapper productSalesLineMapper; @Resource private MesWmProductSalesLineService productSalesLineService; @Resource private MesWmProductSalesDetailService productSalesDetailService; @Resource private CrmCustomerApi customerApi; @Resource private MesWmSalesNoticeService salesNoticeService; @Resource private MesWmTransactionService wmTransactionService; @Resource private MesWmMaterialStockService materialStockService; @Resource private MesWmStockReserveService stockReserveService; @Resource @Lazy private MesQcOqcService oqcService; @Resource private ErpSaleOrderApi saleOrderApi; @Resource private MdmItemApi mdmItemApi; @Resource private MesWmBatchService batchService; @Resource private MesMdAutoCodeRecordService autoCodeRecordService; @Resource private PlatformTransactionManager transactionManager; @Override public Long createProductSales(MesWmProductSalesSaveReqVO createReqVO) { // 校验数据 validateProductSalesSaveData(null, createReqVO); // 插入 MesWmProductSalesDO sales = BeanUtils.toBean(createReqVO, MesWmProductSalesDO.class); sales.setStatus(MesWmProductSalesStatusEnum.PREPARE.getStatus()); productSalesMapper.insert(sales); return sales.getId(); } @Override public void updateProductSales(MesWmProductSalesSaveReqVO updateReqVO) { // 校验存在 + 草稿状态 validateProductSalesExistsAndDraft(updateReqVO.getId()); // 校验数据 validateProductSalesSaveData(updateReqVO.getId(), updateReqVO); // 更新 MesWmProductSalesDO updateObj = BeanUtils.toBean(updateReqVO, MesWmProductSalesDO.class); productSalesMapper.updateById(updateObj); } @Override @Transactional(rollbackFor = Exception.class) public void deleteProductSales(Long id) { // 校验存在 + 草稿状态 validateProductSalesExistsAndDraft(id); // 级联删除明细和行 productSalesDetailService.deleteProductSalesDetailBySalesId(id); productSalesLineService.deleteProductSalesLineBySalesId(id); // 删除 productSalesMapper.deleteById(id); } @Override public MesWmProductSalesDO getProductSales(Long id) { return productSalesMapper.selectById(id); } @Override public PageResult getProductSalesPage(MesWmProductSalesPageReqVO pageReqVO) { List permittedClientIds = customerApi.getPermittedCustomerIds(); return productSalesMapper.selectPage(pageReqVO, permittedClientIds); } @Override @Transactional(rollbackFor = Exception.class) public void submitProductSales(Long id) { // 校验存在 + 草稿状态 validateProductSalesExistsAndDraft(id); // 校验至少有一条行 List lines = productSalesLineService.getProductSalesLineListBySalesId(id); if (CollUtil.isEmpty(lines)) { throw exception(WM_PRODUCT_SALES_LINES_EMPTY); } // 校验每行出库数量 > 0 for (MesWmProductSalesLineDO line : lines) { if (line.getQuantity() == null || BigDecimal.ZERO.compareTo(line.getQuantity()) >= 0) { throw exception(WM_PRODUCT_SALES_LINE_QUANTITY_INVALID); } } // 获取出库单信息 MesWmProductSalesDO sales = productSalesMapper.selectById(id); // 检查所有行的 oqcCheckFlag:如果有需要 OQC 检验的行,进入待检测状态 boolean needOqc = CollectionUtils.anyMatch(lines, line -> Boolean.TRUE.equals(line.getOqcCheckFlag())); if (needOqc) { // 为需要 OQC 检验且尚未创建检验单的明细创建 OQC 检验单 List oqcLines = CollectionUtils.filterList(lines, line -> Boolean.TRUE.equals(line.getOqcCheckFlag()) && line.getOqcId() == null); for (MesWmProductSalesLineDO line : oqcLines) { // 直接调用,让异常抛出,保证数据一致性 Long oqcId = oqcService.createOqcFromProductSales( sales.getId(), line, sales.getCode(), sales.getClientId()); // 更新出库明细的 oqcId productSalesLineMapper.updateById(new MesWmProductSalesLineDO() .setId(line.getId()) .setOqcId(oqcId)); } // 批量初始化 OQC 行的质量状态为"待检验" List oqcLineIds = convertList( CollectionUtils.filterList(lines, line -> Boolean.TRUE.equals(line.getOqcCheckFlag())), MesWmProductSalesLineDO::getId); productSalesLineService.updateProductSalesLineQualityStatus(oqcLineIds, MesWmQualityStatusEnum.PENDING.getStatus()); // 需要检验,进入待检测 productSalesMapper.updateById(new MesWmProductSalesDO() .setId(id).setStatus(MesWmProductSalesStatusEnum.CONFIRMED.getStatus())); return; } // 不需要检验,直接进入待拣货 productSalesMapper.updateById(new MesWmProductSalesDO() .setId(id).setStatus(MesWmProductSalesStatusEnum.APPROVING.getStatus())); } @Override public boolean checkProductSalesQuantity(Long id) { // 校验每行明细数量之和是否等于行出库数量 List lines = productSalesLineService.getProductSalesLineListBySalesId(id); for (MesWmProductSalesLineDO line : lines) { List details = productSalesDetailService.getProductSalesDetailListByLineId(line.getId()); if (CollUtil.isEmpty(details)) { return false; } BigDecimal totalDetailQty = CollectionUtils.getSumValue(details, MesWmProductSalesDetailDO::getQuantity, BigDecimal::add, BigDecimal.ZERO); if (line.getQuantity() != null && totalDetailQty.compareTo(line.getQuantity()) != 0) { return false; } } return true; } @Override @Transactional(rollbackFor = Exception.class) public void stockProductSales(Long id) { // 校验存在 MesWmProductSalesDO sales = validateProductSalesExists(id); if (ObjUtil.notEqual(MesWmProductSalesStatusEnum.APPROVING.getStatus(), sales.getStatus())) { throw exception(WM_PRODUCT_SALES_CANNOT_PICK); } // 校验每行至少有拣货明细,并校验库存充足 List lines = productSalesLineService.getProductSalesLineListBySalesId(id); for (MesWmProductSalesLineDO line : lines) { List details = productSalesDetailService.getProductSalesDetailListByLineId(line.getId()); if (CollUtil.isEmpty(details)) { throw exception(WM_PRODUCT_SALES_DETAILS_EMPTY); } // 校验库存充足并创建占用 for (MesWmProductSalesDetailDO detail : details) { materialStockService.validateSelectedStock( detail.getMaterialStockId(), detail.getItemId(), detail.getBatchId(), detail.getBatchCode(), detail.getWarehouseId(), detail.getLocationId(), detail.getAreaId(), detail.getQuantity() ); // 创建库存占用 stockReserveService.createReserve( detail.getMaterialStockId(), MesWmStockReserveBizTypeEnum.PRODUCT_SALES.getType(), id, sales.getCode(), detail.getId(), detail.getItemId(), detail.getQuantity() ); } } // 执行拣货(待拣货 → 待填写运单) productSalesMapper.updateById(new MesWmProductSalesDO() .setId(id).setStatus(MesWmProductSalesStatusEnum.SHIPPING.getStatus())); // 回写 ERP 销售订单出库状态为"部分出库"(表示已拣货/占用) if (sales.getSaleOrderId() != null) { saleOrderApi.updateOrderOutStatusTo(sales.getSaleOrderId(), ErpSaleOrderOutStatusEnum.PART_OUT.getStatus()); } } @Override @Transactional(rollbackFor = Exception.class) public void shippingProductSales(MesWmProductSalesShippingReqVO reqVO) { // 校验存在 MesWmProductSalesDO sales = validateProductSalesExists(reqVO.getId()); if (ObjUtil.notEqual(MesWmProductSalesStatusEnum.SHIPPING.getStatus(), sales.getStatus())) { throw exception(WM_PRODUCT_SALES_CANNOT_SHIPPING); } // 填写运单(待填写运单 → 待执行出库) productSalesMapper.updateById(new MesWmProductSalesDO() .setId(reqVO.getId()) .setCarrier(reqVO.getCarrier()) .setShippingNumber(reqVO.getShippingNumber()) .setStatus(MesWmProductSalesStatusEnum.APPROVED.getStatus())); } @Override @Transactional(rollbackFor = Exception.class) public void finishProductSales(Long id) { // 1. 校验存在 MesWmProductSalesDO sales = validateProductSalesExists(id); if (ObjUtil.notEqual(MesWmProductSalesStatusEnum.APPROVED.getStatus(), sales.getStatus())) { throw exception(WM_PRODUCT_SALES_CANNOT_FINISH); } // 2. 确认占用转出库(释放占用量) stockReserveService.confirmReserveToOutbound(MesWmStockReserveBizTypeEnum.PRODUCT_SALES.getType(), id); // 3. 遍历所有明细,创建库存事务(扣减库存 + 记录流水) createTransactionList(sales); // 4. 更新出库单状态 productSalesMapper.updateById(new MesWmProductSalesDO() .setId(id).setStatus(MesWmProductSalesStatusEnum.FINISHED.getStatus())); // 5. 更新关联的发货通知单出库数量和状态 if (sales.getNoticeId() != null) { updateSalesNoticeOutCount(sales); } // 6. 回写 ERP 销售订单的出库数量和状态 updateErpSaleOrderOutCount(sales); } /** * 更新发货通知单的出库数量和状态 */ private void updateSalesNoticeOutCount(MesWmProductSalesDO sales) { // 获取出库单行 List lines = productSalesLineService.getProductSalesLineListBySalesId(sales.getId()); if (CollUtil.isEmpty(lines)) { return; } // 遍历行,按 noticeLineId 更新出库数量 for (MesWmProductSalesLineDO line : lines) { if (line.getNoticeLineId() != null && line.getQuantity() != null) { salesNoticeService.updateSalesNoticeLineOutCount(line.getNoticeLineId(), line.getQuantity()); } } } /** * 回写 ERP 销售订单的出库数量和状态 */ private void updateErpSaleOrderOutCount(MesWmProductSalesDO sales) { // 获取出库单行 List lines = productSalesLineService.getProductSalesLineListBySalesId(sales.getId()); if (CollUtil.isEmpty(lines)) { return; } // 用于存储销售订单 ID,避免重复更新 Long saleOrderId = null; // 遍历行,按 saleOrderItemId 更新出库数量 for (MesWmProductSalesLineDO line : lines) { if (line.getSaleOrderItemId() != null && line.getQuantity() != null) { saleOrderApi.updateOrderItemOutCount(line.getSaleOrderItemId(), line.getQuantity()); // 获取销售订单 ID(从第一个有效的明细项获取) if (saleOrderId == null) { cn.iocoder.yudao.module.erp.api.sale.dto.ErpSaleOrderItemRespDTO itemDTO = saleOrderApi.getSaleOrderItem(line.getSaleOrderItemId()).getCheckedData(); if (itemDTO != null && itemDTO.getOrderId() != null) { saleOrderId = itemDTO.getOrderId(); } } } } // 更新销售订单的出库状态 if (saleOrderId != null) { saleOrderApi.updateOrderOutStatus(saleOrderId); } } private void createTransactionList(MesWmProductSalesDO sales) { List details = productSalesDetailService.getProductSalesDetailListBySalesId(sales.getId()); wmTransactionService.createTransactionList(convertList(details, detail -> new MesWmTransactionSaveReqDTO() .setType(MesWmTransactionTypeEnum.OUT.getType()).setItemId(detail.getItemId()) .setQuantity(detail.getQuantity().negate()) // 出库数量为负数 .setBatchId(detail.getBatchId()).setBatchCode(detail.getBatchCode()) .setWarehouseId(detail.getWarehouseId()).setLocationId(detail.getLocationId()).setAreaId(detail.getAreaId()) .setBizType(MesBizTypeConstants.WM_PRODUCT_SALES).setBizId(sales.getId()) .setBizCode(sales.getCode()).setBizLineId(detail.getLineId()) .setMaterialStockId(detail.getMaterialStockId()))); // 指定库存记录ID,避免重新匹配 } @Override @Transactional(rollbackFor = Exception.class) public void cancelProductSales(Long id) { // 校验存在 MesWmProductSalesDO sales = validateProductSalesExists(id); // 已完成和已取消不允许取消 if (ObjectUtils.equalsAny(sales.getStatus(), MesWmProductSalesStatusEnum.FINISHED.getStatus(), MesWmProductSalesStatusEnum.CANCELED.getStatus())) { throw exception(WM_PRODUCT_SALES_CANNOT_CANCEL); } // 释放库存占用 stockReserveService.releaseReserve(MesWmStockReserveBizTypeEnum.PRODUCT_SALES.getType(), id); // 取消 productSalesMapper.updateById(new MesWmProductSalesDO() .setId(id).setStatus(MesWmProductSalesStatusEnum.CANCELED.getStatus())); } @Override public void confirmProductSales(Long id) { // 校验存在 + 待检测状态 MesWmProductSalesDO sales = validateProductSalesExists(id); if (ObjUtil.notEqual(MesWmProductSalesStatusEnum.CONFIRMED.getStatus(), sales.getStatus())) { throw exception(WM_PRODUCT_SALES_CANNOT_CONFIRM); } // OQC 检验完成,流转到待拣货 productSalesMapper.updateById(new MesWmProductSalesDO() .setId(id).setStatus(MesWmProductSalesStatusEnum.APPROVING.getStatus())); } @Override public List getProductSalesListByClientId(Long clientId) { return productSalesMapper.selectListByClientId(clientId); } private void validateProductSalesSaveData(Long id, MesWmProductSalesSaveReqVO reqVO) { // 校验编码唯一 validateCodeUnique(id, reqVO.getCode()); // 校验客户存在 customerApi.validateCustomer(reqVO.getClientId()); // 校验发货通知单 if (reqVO.getNoticeId() != null) { MesWmSalesNoticeDO notice = salesNoticeService.validateSalesNoticeExists(reqVO.getNoticeId()); if (ObjUtil.notEqual(notice.getStatus(), MesWmSalesNoticeStatusEnum.APPROVED.getStatus())) { throw exception(WM_SALES_NOTICE_STATUS_NOT_APPROVED); } if (ObjUtil.notEqual(notice.getClientId(), reqVO.getClientId())) { throw exception(WM_SALES_NOTICE_CLIENT_MISMATCH); } } } private MesWmProductSalesDO validateProductSalesExists(Long id) { MesWmProductSalesDO sales = productSalesMapper.selectById(id); if (sales == null) { throw exception(WM_PRODUCT_SALES_NOT_EXISTS); } return sales; } /** * 校验销售出库单存在且为草稿状态 */ @Override public MesWmProductSalesDO validateProductSalesExistsAndDraft(Long id) { MesWmProductSalesDO sales = validateProductSalesExists(id); if (ObjUtil.notEqual(MesWmProductSalesStatusEnum.PREPARE.getStatus(), sales.getStatus())) { throw exception(WM_PRODUCT_SALES_NOT_PREPARE); } return sales; } private void validateCodeUnique(Long id, String code) { MesWmProductSalesDO sales = productSalesMapper.selectByCode(code); if (sales == null) { return; } if (ObjUtil.notEqual(id, sales.getId())) { throw exception(WM_PRODUCT_SALES_CODE_DUPLICATE); } } @Override public void updateStatus(Long id, Integer status) { productSalesMapper.updateById(new MesWmProductSalesDO().setId(id).setStatus(status)); } // ==================== 导入 ==================== @Override public MesWmProductSalesImportRespVO importProductSalesList(List importList) { MesWmProductSalesImportRespVO respVO = MesWmProductSalesImportRespVO.builder() .createList(new ArrayList<>()) .failureList(new LinkedHashMap<>()) .build(); if (CollUtil.isEmpty(importList)) { return respVO; } // 1. 预热“客户名称 -> 客户编号”映射(客户主数据在 CRM 模块) Map customerIdMap = new HashMap<>(); List customers = customerApi.getCustomerSimpleList(); if (CollUtil.isNotEmpty(customers)) { customers.forEach(customer -> { if (customer != null && StrUtil.isNotBlank(customer.getName())) { customerIdMap.putIfAbsent(customer.getName().trim(), customer.getId()); } }); } // 2. 按“出库单号”分组:同单号多行 = 一张出库单的多条明细;单号为空则每行独立成单 Map> orderGroups = new LinkedHashMap<>(); for (int i = 0; i < importList.size(); i++) { MesWmProductSalesImportExcelVO row = importList.get(i); if (row == null || isEmptyImportRow(row)) { continue; // 跳过空行 } String key = StrUtil.isNotBlank(row.getCode()) ? row.getCode().trim() : "__row_" + (i + 2); orderGroups.computeIfAbsent(key, k -> new ArrayList<>()).add(new ImportRow(row, i + 2)); } // 3. 逐单导入:每张单独立事务,失败的单整单回滚,不影响其它单 TransactionTemplate importTxTemplate = new TransactionTemplate(transactionManager); for (Map.Entry> entry : orderGroups.entrySet()) { List rows = entry.getValue(); String label = StrUtil.isNotBlank(rows.get(0).data().getCode()) ? rows.get(0).data().getCode().trim() : "第 " + rows.get(0).rowNum() + " 行"; try { String code = importTxTemplate.execute(status -> createProductSalesByImport(rows, customerIdMap)); respVO.getCreateList().add(code); } catch (Exception ex) { respVO.getFailureList().put(label, resolveImportErrorMessage(ex)); } } return respVO; } /** * 依据同一出库单号的多行导入数据,创建一张销售出库单(单头 + 明细) * * @return 出库单号 */ private String createProductSalesByImport(List rows, Map customerIdMap) { ImportRow headRow = rows.get(0); MesWmProductSalesImportExcelVO head = headRow.data(); String rowPrefix = "第 " + headRow.rowNum() + " 行:"; // 1. 客户(取该组首行) if (StrUtil.isBlank(head.getClientName())) { throw new IllegalArgumentException(rowPrefix + "客户名称不能为空"); } String clientName = head.getClientName().trim(); Long clientId = customerIdMap.get(clientName); if (clientId == null) { throw new IllegalArgumentException(rowPrefix + "客户名称[" + clientName + "]在 CRM 中不存在,请核对名称是否与系统客户完全一致(含全半角、空格)"); } // 2. 出库日期(留空取当天) LocalDateTime salesDate = parseImportSalesDate(head.getSalesDate(), rowPrefix); // 3. 出库单号:填了就用(校验唯一),没填自动生成 String code = StrUtil.isNotBlank(head.getCode()) ? head.getCode().trim() : autoCodeRecordService.generateAutoCode(MesMdAutoCodeRuleCodeEnum.WM_PRODUCT_SALES_CODE.getCode()); if (StrUtil.isBlank(code)) { throw new IllegalArgumentException(rowPrefix + "出库单号自动生成失败,请稍后重试,或在该列手工填写出库单号"); } if (productSalesMapper.selectByCode(code) != null) { throw new IllegalArgumentException(rowPrefix + "出库单号[" + code + "]已存在,请修改该列或清空该列由系统自动生成"); } // 4. 创建单头(草稿状态,不提交、不占用库存) MesWmProductSalesSaveReqVO saveReqVO = new MesWmProductSalesSaveReqVO(); saveReqVO.setCode(code); saveReqVO.setName(StrUtil.isNotBlank(head.getName()) ? head.getName().trim() : clientName + "-" + salesDate.toLocalDate() + " 出库"); saveReqVO.setClientId(clientId); saveReqVO.setSalesDate(salesDate); saveReqVO.setSalesOrderCode(StrUtil.trimToNull(head.getSalesOrderCode())); saveReqVO.setContactName(StrUtil.trimToNull(head.getContactName())); saveReqVO.setContactTelephone(StrUtil.trimToNull(head.getContactTelephone())); saveReqVO.setContactAddress(StrUtil.trimToNull(head.getContactAddress())); saveReqVO.setRemark(StrUtil.trimToNull(head.getRemark())); Long salesId = createProductSales(saveReqVO); // 5. 逐行创建明细 for (ImportRow row : rows) { createProductSalesLineByImport(salesId, row); } return code; } /** * 依据导入行创建一条销售出库单行 */ private void createProductSalesLineByImport(Long salesId, ImportRow row) { MesWmProductSalesImportExcelVO data = row.data(); String rowPrefix = "第 " + row.rowNum() + " 行:"; // 1. 物料编码(必填,且必须存在、启用) if (StrUtil.isBlank(data.getItemCode())) { throw new IllegalArgumentException(rowPrefix + "物料编码不能为空"); } String itemCode = data.getItemCode().trim(); MdmItemRespDTO item = mdmItemApi.getItemByCode(itemCode).getCheckedData(); if (item == null) { throw new IllegalArgumentException(rowPrefix + "物料编码[" + itemCode + "]不存在,请先到【基础数据-物料主数据】中维护该物料"); } if (!CommonStatusEnum.ENABLE.getStatus().equals(item.getStatus())) { throw new IllegalArgumentException(rowPrefix + "物料编码[" + itemCode + "-" + item.getName() + "]已停用,请先在物料主数据中启用后再导入"); } // 2. 出库数量(必填,主单位口径) if (data.getQuantity() == null) { throw new IllegalArgumentException(rowPrefix + "出库数量不能为空(物料[" + itemCode + "])"); } if (data.getQuantity().compareTo(BigDecimal.ZERO) <= 0) { throw new IllegalArgumentException(rowPrefix + "出库数量必须大于 0,当前填写为[" + data.getQuantity().toPlainString() + "](物料[" + itemCode + "])"); } // 3. 批次号(可空;填了必须是已存在且归属该物料的批次) String batchCode = StrUtil.trimToNull(data.getBatchCode()); if (batchCode != null) { MesWmBatchDO batch = batchService.getBatchByCode(batchCode); if (batch == null) { throw new IllegalArgumentException(rowPrefix + "批次号[" + batchCode + "]不存在,请先在【批次管理】中创建,或清空该行的批次号"); } if (batch.getItemId() != null && !ObjUtil.equal(batch.getItemId(), item.getId())) { String batchItemText = resolveItemText(batch.getItemId()); throw new IllegalArgumentException(rowPrefix + "批次号[" + batchCode + "]属于物料[" + batchItemText + "],与当前行物料[" + itemCode + "-" + item.getName() + "]不一致,请核对批次号或物料编码"); } } // 4. 创建行(草稿状态;物料存在性/启用、批次解析等校验由行服务统一完成) MesWmProductSalesLineSaveReqVO lineVO = new MesWmProductSalesLineSaveReqVO(); lineVO.setSalesId(salesId); lineVO.setItemId(item.getId()); lineVO.setQuantity(data.getQuantity()); lineVO.setBatchCode(batchCode); lineVO.setOqcCheckFlag(parseImportYesNo(data.getOqcCheckFlag())); lineVO.setRemark(StrUtil.trimToNull(data.getRemark())); productSalesLineService.createProductSalesLine(lineVO); } private boolean isEmptyImportRow(MesWmProductSalesImportExcelVO row) { return StrUtil.isBlank(row.getCode()) && StrUtil.isBlank(row.getClientName()) && StrUtil.isBlank(row.getItemCode()) && row.getQuantity() == null && StrUtil.isBlank(row.getName()) && StrUtil.isBlank(row.getSalesDate()); } private LocalDateTime parseImportSalesDate(String text, String rowPrefix) { if (StrUtil.isBlank(text)) { return LocalDate.now().atStartOfDay(); } String value = text.trim(); for (String pattern : new String[]{"yyyy-MM-dd HH:mm:ss", "yyyy-MM-dd HH:mm"}) { try { return LocalDateTime.parse(value, DateTimeFormatter.ofPattern(pattern)); } catch (Exception ignored) { // 继续尝试下一个格式 } } for (String pattern : new String[]{"yyyy-MM-dd", "yyyy/M/d"}) { try { return LocalDate.parse(value, DateTimeFormatter.ofPattern(pattern)).atStartOfDay(); } catch (Exception ignored) { // 继续尝试下一个格式 } } throw new IllegalArgumentException(rowPrefix + "出库日期[" + text + "]格式不正确,请使用 yyyy-MM-dd,如 2026-10-31"); } private Boolean parseImportYesNo(String text) { if (StrUtil.isBlank(text)) { return false; } String value = text.trim(); return "是".equals(value) || "1".equals(value) || "true".equalsIgnoreCase(value) || "yes".equalsIgnoreCase(value) || "需要".equals(value); } private String resolveItemText(Long itemId) { try { MdmItemRespDTO item = mdmItemApi.getItem(itemId).getCheckedData(); if (item != null) { return item.getCode() + "-" + item.getName(); } } catch (Exception ex) { log.warn("[resolveItemText][物料({}) 名称解析失败]", itemId, ex); } return "ID=" + itemId; } private String resolveImportErrorMessage(Exception ex) { if (ex instanceof ServiceException serviceException) { return serviceException.getMessage(); } return StrUtil.blankToDefault(ex.getMessage(), "导入失败"); } /** * 导入行(保留 Excel 行号,便于提示“第 N 行”) */ private record ImportRow(MesWmProductSalesImportExcelVO data, int rowNum) { } }