package cn.iocoder.yudao.module.erp.service.sale; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.util.ObjectUtil; import cn.hutool.core.util.StrUtil; import cn.iocoder.yudao.framework.common.exception.ServiceException; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.framework.common.util.number.MoneyUtils; import cn.iocoder.yudao.framework.common.util.object.BeanUtils; import cn.iocoder.yudao.module.crm.api.customer.CrmCustomerApi; import cn.iocoder.yudao.module.crm.api.contract.CrmContractApi; import cn.iocoder.yudao.module.crm.api.customer.dto.CrmCustomerRespDTO; import cn.iocoder.yudao.module.erp.controller.admin.sale.vo.order.ErpSaleOrderImportExcelVO; import cn.iocoder.yudao.module.erp.controller.admin.sale.vo.order.ErpSaleOrderImportReqVO; import cn.iocoder.yudao.module.erp.controller.admin.sale.vo.order.ErpSaleOrderImportRespVO; import cn.iocoder.yudao.module.erp.controller.admin.sale.vo.order.ErpSaleOrderPageReqVO; import cn.iocoder.yudao.module.erp.controller.admin.sale.vo.order.ErpSaleOrderSaveReqVO; import cn.iocoder.yudao.module.erp.dal.dataobject.finance.ErpAccountDO; import cn.iocoder.yudao.module.erp.dal.dataobject.sale.ErpSaleOrderDO; import cn.iocoder.yudao.module.erp.dal.dataobject.sale.ErpSaleOrderItemDO; import cn.iocoder.yudao.module.erp.dal.mysql.finance.ErpAccountMapper; import cn.iocoder.yudao.module.erp.dal.mysql.sale.ErpSaleOrderItemMapper; import cn.iocoder.yudao.module.erp.dal.mysql.sale.ErpSaleOrderMapper; import cn.iocoder.yudao.module.erp.dal.redis.no.ErpNoRedisDAO; import cn.iocoder.yudao.module.erp.enums.ErpAuditStatus; import cn.iocoder.yudao.module.erp.api.sale.enums.ErpSaleOrderOutStatusEnum; import cn.iocoder.yudao.module.erp.service.finance.ErpAccountService; import cn.iocoder.yudao.module.mdm.api.item.MdmItemApi; import cn.iocoder.yudao.module.mdm.api.item.dto.MdmItemRespDTO; import cn.iocoder.yudao.module.mdm.api.unit.MdmUnitMeasureApi; import cn.iocoder.yudao.module.mdm.api.unit.dto.MdmUnitMeasureRespDTO; import cn.iocoder.yudao.module.mes.api.mps.MesProMpsApi; import cn.iocoder.yudao.module.mes.api.mps.dto.MesProMpsCreateReqDTO; import cn.iocoder.yudao.module.mes.api.mps.dto.MesProMpsRespDTO; import cn.iocoder.yudao.module.system.api.storage.StorageAttachmentApi; import cn.iocoder.yudao.module.system.api.user.AdminUserApi; import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO; import jakarta.annotation.Resource; import lombok.extern.slf4j.Slf4j; 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.time.format.DateTimeFormatter; import java.util.ArrayList; import java.util.Collection; import java.util.Collections; 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.*; import static cn.iocoder.yudao.module.erp.enums.ErrorCodeConstants.*; /** * ERP 销售订单 Service 实现类 * * @author 超级管理员 */ @Service @Validated @Slf4j public class ErpSaleOrderServiceImpl implements ErpSaleOrderService { private static final Integer MPS_STATUS_CANCELED = 3; @Resource private ErpSaleOrderMapper saleOrderMapper; @Resource private ErpSaleOrderItemMapper saleOrderItemMapper; @Resource private ErpNoRedisDAO noRedisDAO; @Resource private CrmCustomerApi customerApi; @Resource private CrmContractApi contractApi; @Resource private ErpAccountService accountService; @Resource private AdminUserApi adminUserApi; @Resource private MdmItemApi mdmItemApi; @Resource private MdmUnitMeasureApi mdmUnitMeasureApi; @Resource private ErpAccountMapper accountMapper; @Resource private MesProMpsApi mpsApi; @Resource private StorageAttachmentApi storageAttachmentApi; @Override @Transactional(rollbackFor = Exception.class) public Long createSaleOrder(ErpSaleOrderSaveReqVO createReqVO) { // 1.1 校验订单项的有效性 List saleOrderItems = validateSaleOrderItems(createReqVO.getItems()); // 1.2 校验客户(使用 CRM 客户 API) customerApi.validateCustomer(createReqVO.getCustomerId()); // 1.3 校验结算账户 if (createReqVO.getAccountId() != null) { accountService.validateAccount(createReqVO.getAccountId()); } // 1.4 校验销售人员 if (createReqVO.getSaleUserId() != null) { adminUserApi.validateUser(createReqVO.getSaleUserId()); } // 1.5 生成订单号,并校验唯一性 String no = noRedisDAO.generate(ErpNoRedisDAO.SALE_ORDER_NO_PREFIX); if (saleOrderMapper.selectByNo(no) != null) { throw exception(SALE_ORDER_NO_EXISTS); } // 2.1 插入订单 ErpSaleOrderDO saleOrder = BeanUtils.toBean(createReqVO, ErpSaleOrderDO.class, in -> in .setNo(no).setStatus(ErpAuditStatus.PROCESS.getStatus()) .setDepositPrice(ObjectUtil.defaultIfNull(createReqVO.getDepositPrice(), BigDecimal.ZERO)) .setOutCount(BigDecimal.ZERO).setOutStatus(ErpSaleOrderOutStatusEnum.NOT_OUT.getStatus())); calculateTotalPrice(saleOrder, saleOrderItems); saleOrderMapper.insert(saleOrder); // 2.2 插入订单项 saleOrderItems.forEach(o -> o.setOrderId(saleOrder.getId())); saleOrderItemMapper.insertBatch(saleOrderItems); // 2.3 绑定附件 storageAttachmentApi.bindAttachments("file", "erp_sale_order", saleOrder.getId(), createReqVO.getBlobIds()); return saleOrder.getId(); } @Override @Transactional(rollbackFor = Exception.class) public void updateSaleOrder(ErpSaleOrderSaveReqVO updateReqVO) { // 1.1 校验存在 ErpSaleOrderDO saleOrder = validateSaleOrderExists(updateReqVO.getId()); if (ErpAuditStatus.APPROVE.getStatus().equals(saleOrder.getStatus())) { throw exception(SALE_ORDER_UPDATE_FAIL_APPROVE, saleOrder.getNo()); } // 1.2 校验客户(使用 CRM 客户 API) customerApi.validateCustomer(updateReqVO.getCustomerId()); // 1.3 校验结算账户 if (updateReqVO.getAccountId() != null) { accountService.validateAccount(updateReqVO.getAccountId()); } // 1.4 校验销售人员 if (updateReqVO.getSaleUserId() != null) { adminUserApi.validateUser(updateReqVO.getSaleUserId()); } // 1.5 校验订单项的有效性 List saleOrderItems = validateSaleOrderItems(updateReqVO.getItems()); // 2.1 更新订单 ErpSaleOrderDO updateObj = BeanUtils.toBean(updateReqVO, ErpSaleOrderDO.class); updateObj.setDepositPrice(ObjectUtil.defaultIfNull(updateReqVO.getDepositPrice(), BigDecimal.ZERO)); calculateTotalPrice(updateObj, saleOrderItems); saleOrderMapper.updateById(updateObj); // 2.2 更新订单项 updateSaleOrderItemList(updateReqVO.getId(), saleOrderItems); // 2.3 更新附件 storageAttachmentApi.updateAttachments("file", "erp_sale_order", updateReqVO.getId(), updateReqVO.getBlobIds()); } private void calculateTotalPrice(ErpSaleOrderDO saleOrder, List saleOrderItems) { saleOrder.setTotalCount(getSumValue(saleOrderItems, ErpSaleOrderItemDO::getCount, BigDecimal::add)); saleOrder.setTotalProductPrice(getSumValue(saleOrderItems, ErpSaleOrderItemDO::getTotalPrice, BigDecimal::add, BigDecimal.ZERO)); saleOrder.setTotalTaxPrice(getSumValue(saleOrderItems, ErpSaleOrderItemDO::getTaxPrice, BigDecimal::add, BigDecimal.ZERO)); saleOrder.setTotalPrice(saleOrder.getTotalProductPrice().add(saleOrder.getTotalTaxPrice())); // 计算优惠价格 if (saleOrder.getDiscountPercent() == null) { saleOrder.setDiscountPercent(BigDecimal.ZERO); } saleOrder.setDiscountPrice(MoneyUtils.priceMultiplyPercent(saleOrder.getTotalPrice(), saleOrder.getDiscountPercent())); saleOrder.setTotalPrice(saleOrder.getTotalPrice().subtract(saleOrder.getDiscountPrice())); } @Override @Transactional(rollbackFor = Exception.class) public void updateSaleOrderStatus(Long id, Integer status) { boolean approve = ErpAuditStatus.APPROVE.getStatus().equals(status); // 1.1 校验存在 ErpSaleOrderDO saleOrder = validateSaleOrderExists(id); // 1.2 校验状态 if (saleOrder.getStatus().equals(status)) { throw exception(approve ? SALE_ORDER_APPROVE_FAIL : SALE_ORDER_PROCESS_FAIL); } // 1.3 存在销售出库单,无法反审核 BigDecimal outCount = saleOrder.getOutCount() != null ? saleOrder.getOutCount() : BigDecimal.ZERO; if (!approve && outCount.compareTo(BigDecimal.ZERO) > 0) { throw exception(SALE_ORDER_PROCESS_FAIL_EXISTS_OUT); } // 2. 更新状态 int updateCount = saleOrderMapper.updateByIdAndStatus(id, saleOrder.getStatus(), new ErpSaleOrderDO().setStatus(status)); if (updateCount == 0) { throw exception(approve ? SALE_ORDER_APPROVE_FAIL : SALE_ORDER_PROCESS_FAIL); } // 3. 审核通过时,为需要生产的明细创建 MPS if (approve) { createMpsForSaleOrder(id, saleOrder); } } /** * 为销售订单中需要生产的明细创建 MPS * * @param orderId 销售订单编号 * @param saleOrder 销售订单 */ private void createMpsForSaleOrder(Long orderId, ErpSaleOrderDO saleOrder) { List items = saleOrderItemMapper.selectListByOrderId(orderId); if (CollUtil.isEmpty(items)) { return; } int createdCount = 0; int reusedCount = 0; for (ErpSaleOrderItemDO item : items) { if (item.getNeedProduction() == null || item.getNeedProduction() != 1) { continue; } // 同一销售明细只保留一条有效 MPS,避免反审核后再次审核产生重复计划 MesProMpsRespDTO existingMps = mpsApi.getMpsBySaleOrderItemId(item.getId()); if (existingMps != null && ObjectUtil.notEqual(existingMps.getStatus(), MPS_STATUS_CANCELED)) { if (ObjectUtil.notEqual(item.getMpsId(), existingMps.getId())) { saleOrderItemMapper.updateById(new ErpSaleOrderItemDO() .setId(item.getId()) .setMpsId(existingMps.getId())); } reusedCount++; log.info("[createMpsForSaleOrder] 销售订单明细({}) 已存在有效 MPS({}),跳过重复创建", item.getId(), existingMps.getId()); continue; } // 与销售订单审核共用事务;任一明细创建失败都会回滚审核状态和本次已创建的 MPS Long mpsId = createMpsForSaleOrderItem(saleOrder, item); saleOrderItemMapper.updateById(new ErpSaleOrderItemDO() .setId(item.getId()) .setMpsId(mpsId)); createdCount++; } log.info("[createMpsForSaleOrder] 销售订单({}) 审核完成,创建 MPS {} 条,复用 MPS {} 条", orderId, createdCount, reusedCount); } /** * 为销售订单明细创建 MPS */ private Long createMpsForSaleOrderItem(ErpSaleOrderDO saleOrder, ErpSaleOrderItemDO item) { // 获取 MDM 物料信息(用于获取产品名称) String productName = null; try { MdmItemRespDTO mdmItem = mdmItemApi.getItem(item.getProductId()).getCheckedData(); if (mdmItem != null) { productName = mdmItem.getName(); } } catch (Exception e) { log.warn("[createMpsForSaleOrderItem] 获取 MDM 物料信息失败,productId={}", item.getProductId(), e); } MesProMpsCreateReqDTO createReqDTO = new MesProMpsCreateReqDTO(); createReqDTO.setSaleOrderId(saleOrder.getId()); createReqDTO.setSaleOrderNo(saleOrder.getNo()); createReqDTO.setSaleOrderItemId(item.getId()); createReqDTO.setMdmItemId(item.getProductId()); createReqDTO.setProductName(productName); createReqDTO.setQuantity(item.getCount()); createReqDTO.setClientId(saleOrder.getCustomerId()); createReqDTO.setRequestDate(formatRequestDate(saleOrder.getOrderTime())); createReqDTO.setRemark("自动生成,来自销售订单:" + saleOrder.getNo()); Long mpsId = mpsApi.createMps(createReqDTO); log.info("[createMpsForSaleOrderItem] MPS 创建成功,mpsId={}, saleOrderItemId={}", mpsId, item.getId()); return mpsId; } /** * 格式化需求日期 */ private String formatRequestDate(LocalDateTime dateTime) { if (dateTime == null) { return null; } return dateTime.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); } @Override @Transactional(rollbackFor = Exception.class) public void cancelSaleOrder(Long id) { // 1.1 校验存在 ErpSaleOrderDO saleOrder = validateSaleOrderExists(id); // 1.2 校验状态:只有已审核的订单才能作废 if (!ErpAuditStatus.APPROVE.getStatus().equals(saleOrder.getStatus())) { throw exception(SALE_ORDER_CANCEL_FAIL_NOT_APPROVE, saleOrder.getNo()); } // 1.3 存在销售出库单,无法作废 BigDecimal outCount = saleOrder.getOutCount() != null ? saleOrder.getOutCount() : BigDecimal.ZERO; if (outCount.compareTo(BigDecimal.ZERO) > 0) { throw exception(SALE_ORDER_CANCEL_FAIL_EXISTS_OUT); } // 2. 更新状态为已作废 int updateCount = saleOrderMapper.updateByIdAndStatus(id, saleOrder.getStatus(), new ErpSaleOrderDO().setStatus(ErpAuditStatus.CANCEL.getStatus())); if (updateCount == 0) { throw exception(SALE_ORDER_CANCEL_FAIL); } // 3. 同步更新关联合同状态为已作废 if (saleOrder.getContractId() != null) { contractApi.updateContractStatus(saleOrder.getContractId(), 50).getCheckedData(); // 50 = 已作废 } } @Override @Transactional(rollbackFor = Exception.class) public void enableSaleOrder(Long id) { // 1.1 校验存在 ErpSaleOrderDO saleOrder = validateSaleOrderExists(id); // 1.2 校验状态:只有已作废的订单才能重新启用 if (!ErpAuditStatus.CANCEL.getStatus().equals(saleOrder.getStatus())) { throw exception(SALE_ORDER_ENABLE_FAIL_NOT_CANCEL, saleOrder.getNo()); } // 2. 更新状态为已审核 int updateCount = saleOrderMapper.updateByIdAndStatus(id, saleOrder.getStatus(), new ErpSaleOrderDO().setStatus(ErpAuditStatus.APPROVE.getStatus())); if (updateCount == 0) { throw exception(SALE_ORDER_ENABLE_FAIL); } // 3. 同步更新关联合同状态为审核通过 if (saleOrder.getContractId() != null) { contractApi.updateContractStatus(saleOrder.getContractId(), 20).getCheckedData(); // 20 = 审核通过 } } private List validateSaleOrderItems(List list) { // 转化为 ErpSaleOrderItemDO 列表(产品验证已移除) return convertList(list, o -> BeanUtils.toBean(o, ErpSaleOrderItemDO.class, item -> { item.setTotalPrice(MoneyUtils.priceMultiply(item.getProductPrice(), item.getCount())); if (item.getTotalPrice() == null) { return; } if (item.getTaxPercent() != null) { item.setTaxPrice(MoneyUtils.priceMultiplyPercent(item.getTotalPrice(), item.getTaxPercent())); } })); } private void updateSaleOrderItemList(Long id, List newList) { // 第一步,对比新老数据,获得添加、修改、删除的列表 List oldList = saleOrderItemMapper.selectListByOrderId(id); List> diffList = diffList(oldList, newList, // id 不同,就认为是不同的记录 (oldVal, newVal) -> oldVal.getId().equals(newVal.getId())); // 第二步,批量添加、修改、删除 if (CollUtil.isNotEmpty(diffList.get(0))) { diffList.get(0).forEach(o -> o.setOrderId(id)); saleOrderItemMapper.insertBatch(diffList.get(0)); } if (CollUtil.isNotEmpty(diffList.get(1))) { saleOrderItemMapper.updateBatch(diffList.get(1)); } if (CollUtil.isNotEmpty(diffList.get(2))) { saleOrderItemMapper.deleteByIds(convertList(diffList.get(2), ErpSaleOrderItemDO::getId)); } } @Override public void updateSaleOrderOutCount(Long id, Map outCountMap) { List orderItems = saleOrderItemMapper.selectListByOrderId(id); // 1. 更新每个销售订单项 orderItems.forEach(item -> { BigDecimal outCount = outCountMap.getOrDefault(item.getId(), BigDecimal.ZERO); if (item.getOutCount().equals(outCount)) { return; } if (outCount.compareTo(item.getCount()) > 0) { throw exception(SALE_ORDER_ITEM_OUT_FAIL_PRODUCT_EXCEED, "产品ID:" + item.getProductId(), item.getCount()); } saleOrderItemMapper.updateById(new ErpSaleOrderItemDO().setId(item.getId()).setOutCount(outCount)); }); // 2. 更新销售订单 BigDecimal totalOutCount = getSumValue(outCountMap.values(), value -> value, BigDecimal::add, BigDecimal.ZERO); saleOrderMapper.updateById(new ErpSaleOrderDO().setId(id).setOutCount(totalOutCount)); } @Override @Transactional(rollbackFor = Exception.class) public void deleteSaleOrder(List ids) { // 1. 校验不处于已审批 List saleOrders = saleOrderMapper.selectByIds(ids); if (CollUtil.isEmpty(saleOrders)) { return; } saleOrders.forEach(saleOrder -> { if (ErpAuditStatus.APPROVE.getStatus().equals(saleOrder.getStatus())) { throw exception(SALE_ORDER_DELETE_FAIL_APPROVE, saleOrder.getNo()); } }); // 2. 遍历删除,并记录操作日志 saleOrders.forEach(saleOrder -> { // 2.1 删除附件 storageAttachmentApi.deleteAttachmentsByRecord("erp_sale_order", saleOrder.getId()); // 2.2 删除订单 saleOrderMapper.deleteById(saleOrder.getId()); // 2.3 删除订单项 saleOrderItemMapper.deleteByOrderId(saleOrder.getId()); }); } private ErpSaleOrderDO validateSaleOrderExists(Long id) { ErpSaleOrderDO saleOrder = saleOrderMapper.selectById(id); if (saleOrder == null) { throw exception(SALE_ORDER_NOT_EXISTS); } return saleOrder; } @Override public ErpSaleOrderDO getSaleOrder(Long id) { return saleOrderMapper.selectById(id); } @Override public ErpSaleOrderDO validateSaleOrder(Long id) { ErpSaleOrderDO saleOrder = validateSaleOrderExists(id); if (ObjectUtil.notEqual(saleOrder.getStatus(), ErpAuditStatus.APPROVE.getStatus())) { throw exception(SALE_ORDER_NOT_APPROVE); } return saleOrder; } @Override public PageResult getSaleOrderPage(ErpSaleOrderPageReqVO pageReqVO) { List permittedCustomerIds = customerApi.getPermittedCustomerIds(); return saleOrderMapper.selectPage(pageReqVO, permittedCustomerIds); } // ==================== 订单项 ==================== @Override public List getSaleOrderItemListByOrderId(Long orderId) { return saleOrderItemMapper.selectListByOrderId(orderId); } @Override public List getSaleOrderItemListByOrderIds(Collection orderIds) { if (CollUtil.isEmpty(orderIds)) { return Collections.emptyList(); } return saleOrderItemMapper.selectListByOrderIds(orderIds); } @Override public void updateSaleOrderOutStatus(Long orderId) { // 1. 获取销售订单 ErpSaleOrderDO order = validateSaleOrderExists(orderId); // 2. 获取销售订单明细 List items = saleOrderItemMapper.selectListByOrderId(orderId); if (CollUtil.isEmpty(items)) { return; } // 3. 计算出库状态 int outStatus = calculateOutStatus(items); // 4. 更新销售订单出库状态 saleOrderMapper.updateById(new ErpSaleOrderDO() .setId(orderId).setOutStatus(outStatus)); } /** * 计算出库状态 * * @param items 销售订单明细列表 * @return 出库状态 */ private int calculateOutStatus(List items) { boolean allOut = true; boolean anyOut = false; for (ErpSaleOrderItemDO item : items) { BigDecimal count = item.getCount() != null ? item.getCount() : BigDecimal.ZERO; BigDecimal outCount = item.getOutCount() != null ? item.getOutCount() : BigDecimal.ZERO; if (outCount.compareTo(BigDecimal.ZERO) > 0) { anyOut = true; } if (outCount.compareTo(count) < 0) { allOut = false; } } if (allOut) { return ErpSaleOrderOutStatusEnum.ALL_OUT.getStatus(); } else if (anyOut) { return ErpSaleOrderOutStatusEnum.PART_OUT.getStatus(); } else { return ErpSaleOrderOutStatusEnum.NOT_OUT.getStatus(); } } @Override public ErpSaleOrderImportRespVO importSaleOrderList(List importOrders, ErpSaleOrderImportReqVO importReqVO) { // 1. 校验非空(过滤完全空白的行) importOrders = filterList(importOrders, item -> StrUtil.isNotBlank(item.getProductCode())); if (CollUtil.isEmpty(importOrders)) { throw exception(SALE_ORDER_IMPORT_LIST_IS_EMPTY); } // 2. 按「单号」分组:相同单号的多行合并成一张销售订单;单号为空时每行各自成一张订单 List> groups = new ArrayList<>(); Map groupIndexMap = new LinkedHashMap<>(); int rowIndex = 0; for (ErpSaleOrderImportExcelVO row : importOrders) { rowIndex++; String groupKey = StrUtil.isNotBlank(row.getNo()) ? row.getNo() : ("__row_" + rowIndex); Integer index = groupIndexMap.get(groupKey); if (index == null) { index = groups.size(); groupIndexMap.put(groupKey, index); groups.add(new ArrayList<>()); } groups.get(index).add(row); } // 3. 逐组合并创建销售订单 ErpSaleOrderImportRespVO respVO = ErpSaleOrderImportRespVO.builder() .createSaleOrderNos(new ArrayList<>()) .failureSaleOrderNos(new LinkedHashMap<>()) .build(); for (List group : groups) { String groupKey = StrUtil.isNotBlank(group.get(0).getNo()) ? group.get(0).getNo() : "第" + (importOrders.indexOf(group.get(0)) + 1) + "行"; try { ErpSaleOrderSaveReqVO createReqVO = buildSaleOrderImportSaveReqVO(group); Long orderId = createSaleOrder(createReqVO); respVO.getCreateSaleOrderNos().add(saleOrderMapper.selectById(orderId).getNo()); } catch (ServiceException ex) { respVO.getFailureSaleOrderNos().put(groupKey, ex.getMessage()); } } return respVO; } /** * 将同一张销售订单的多行明细转换成创建 Request VO */ private ErpSaleOrderSaveReqVO buildSaleOrderImportSaveReqVO(List group) { ErpSaleOrderImportExcelVO first = group.get(0); // 1. 校验并解析客户 if (StrUtil.isBlank(first.getCustomerName())) { throw exception(SALE_ORDER_IMPORT_CUSTOMER_NOT_EXISTS, ""); } CrmCustomerRespDTO customer = customerApi.getCustomerByName(first.getCustomerName()); if (customer == null) { throw exception(SALE_ORDER_IMPORT_CUSTOMER_NOT_EXISTS, first.getCustomerName()); } if (first.getOrderTime() == null) { throw exception(SALE_ORDER_IMPORT_ORDER_TIME_REQUIRED); } // 2. 解析结算账户(可选) Long accountId = null; if (StrUtil.isNotBlank(first.getAccountName())) { ErpAccountDO account = accountMapper.selectByName(first.getAccountName()); if (account == null) { throw exception(SALE_ORDER_IMPORT_ACCOUNT_NOT_EXISTS, first.getAccountName()); } accountId = account.getId(); } // 3. 解析销售员(可选) Long saleUserId = null; if (StrUtil.isNotBlank(first.getSaleUserName())) { List users = adminUserApi.getUserListByNickname(first.getSaleUserName()); if (CollUtil.isEmpty(users)) { throw exception(SALE_ORDER_IMPORT_SALE_USER_NOT_EXISTS, first.getSaleUserName()); } saleUserId = users.get(0).getId(); } // 4. 组装明细 List items = new ArrayList<>(); for (ErpSaleOrderImportExcelVO row : group) { MdmItemRespDTO product = mdmItemApi.getItemByCode(row.getProductCode()).getCheckedData(); if (product == null) { throw exception(SALE_ORDER_IMPORT_PRODUCT_NOT_EXISTS, row.getProductCode()); } MdmUnitMeasureRespDTO unit = mdmUnitMeasureApi.getUnitMeasureByCode(row.getProductUnitCode()).getCheckedData(); if (unit == null) { throw exception(SALE_ORDER_IMPORT_UNIT_NOT_EXISTS, row.getProductUnitCode()); } ErpSaleOrderSaveReqVO.Item item = new ErpSaleOrderSaveReqVO.Item() .setProductId(product.getId()) .setProductUnitId(unit.getId()) .setProductPrice(row.getProductPrice()) .setCount(row.getCount()) .setTaxPercent(row.getTaxPercent()) .setNeedProduction(row.getNeedProduction()) .setRemark(row.getItemRemark()); items.add(item); } // 5. 组装主表 ErpSaleOrderSaveReqVO createReqVO = new ErpSaleOrderSaveReqVO() .setCustomerId(customer.getId()) .setOrderTime(first.getOrderTime()) .setSaleUserId(saleUserId) .setAccountId(accountId) .setDiscountPercent(ObjectUtil.defaultIfNull(first.getDiscountPercent(), BigDecimal.ZERO)) .setDepositPrice(ObjectUtil.defaultIfNull(first.getDepositPrice(), BigDecimal.ZERO)) .setRemark(first.getRemark()) .setItems(items); return createReqVO; } }