package cn.iocoder.yudao.module.erp.service.sale; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.util.ObjectUtil; 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.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.product.ErpProductDO; 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.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.service.finance.ErpAccountService; import cn.iocoder.yudao.module.erp.service.product.ErpProductService; import cn.iocoder.yudao.module.system.api.user.AdminUserApi; 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.util.Collection; import java.util.Collections; 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.*; // TODO 芋艿:记录操作日志 /** * ERP 销售订单 Service 实现类 * * @author 芋道源码 */ @Service @Validated public class ErpSaleOrderServiceImpl implements ErpSaleOrderService { @Resource private ErpSaleOrderMapper saleOrderMapper; @Resource private ErpSaleOrderItemMapper saleOrderItemMapper; @Resource private ErpNoRedisDAO noRedisDAO; @Resource private ErpProductService productService; @Resource private ErpCustomerService customerService; @Resource private ErpAccountService accountService; @Resource private AdminUserApi adminUserApi; @Override @Transactional(rollbackFor = Exception.class) public Long createSaleOrder(ErpSaleOrderSaveReqVO createReqVO) { // 1.1 校验订单项的有效性 List saleOrderItems = validateSaleOrderItems(createReqVO.getItems()); // 1.2 校验客户 customerService.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())); calculateTotalPrice(saleOrder, saleOrderItems); saleOrderMapper.insert(saleOrder); // 2.2 插入订单项 saleOrderItems.forEach(o -> o.setOrderId(saleOrder.getId())); saleOrderItemMapper.insertBatch(saleOrderItems); 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 校验客户 customerService.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); calculateTotalPrice(updateObj, saleOrderItems); saleOrderMapper.updateById(updateObj); // 2.2 更新订单项 updateSaleOrderItemList(updateReqVO.getId(), saleOrderItems); } 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 存在销售出库单,无法反审核 if (!approve && saleOrder.getOutCount().compareTo(BigDecimal.ZERO) > 0) { throw exception(SALE_ORDER_PROCESS_FAIL_EXISTS_OUT); } // 1.4 存在销售退货单,无法反审核 if (!approve && saleOrder.getReturnCount().compareTo(BigDecimal.ZERO) > 0) { throw exception(SALE_ORDER_PROCESS_FAIL_EXISTS_RETURN); } // 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); } } private List validateSaleOrderItems(List list) { // 1. 校验产品存在 List productList = productService.validProductList( convertSet(list, ErpSaleOrderSaveReqVO.Item::getProductId)); Map productMap = convertMap(productList, ErpProductDO::getId); // 2. 转化为 ErpSaleOrderItemDO 列表 return convertList(list, o -> BeanUtils.toBean(o, ErpSaleOrderItemDO.class, item -> { item.setProductUnitId(productMap.get(item.getProductId()).getUnitId()); 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.deleteBatchIds(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, productService.getProduct(item.getProductId()).getName(), 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 public void updateSaleOrderReturnCount(Long orderId, Map returnCountMap) { List orderItems = saleOrderItemMapper.selectListByOrderId(orderId); // 1. 更新每个销售订单项 orderItems.forEach(item -> { BigDecimal returnCount = returnCountMap.getOrDefault(item.getId(), BigDecimal.ZERO); if (item.getReturnCount().equals(returnCount)) { return; } if (returnCount.compareTo(item.getOutCount()) > 0) { throw exception(SALE_ORDER_ITEM_RETURN_FAIL_OUT_EXCEED, productService.getProduct(item.getProductId()).getName(), item.getOutCount()); } saleOrderItemMapper.updateById(new ErpSaleOrderItemDO().setId(item.getId()).setReturnCount(returnCount)); }); // 2. 更新销售订单 BigDecimal totalReturnCount = getSumValue(returnCountMap.values(), value -> value, BigDecimal::add, BigDecimal.ZERO); saleOrderMapper.updateById(new ErpSaleOrderDO().setId(orderId).setReturnCount(totalReturnCount)); } @Override @Transactional(rollbackFor = Exception.class) public void deleteSaleOrder(List ids) { // 1. 校验不处于已审批 List saleOrders = saleOrderMapper.selectBatchIds(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 删除订单 saleOrderMapper.deleteById(saleOrder.getId()); // 2.2 删除订单项 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) { return saleOrderMapper.selectPage(pageReqVO); } // ==================== 订单项 ==================== @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); } }