package cn.iocoder.yudao.module.erp.service.stock; import cn.hutool.core.collection.CollUtil; 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.stock.vo.in.ErpStockInPageReqVO; import cn.iocoder.yudao.module.erp.controller.admin.stock.vo.in.ErpStockInSaveReqVO; import cn.iocoder.yudao.module.erp.dal.dataobject.product.ErpProductDO; import cn.iocoder.yudao.module.erp.dal.dataobject.stock.ErpStockInDO; import cn.iocoder.yudao.module.erp.dal.dataobject.stock.ErpStockInItemDO; import cn.iocoder.yudao.module.erp.dal.mysql.stock.ErpStockInItemMapper; import cn.iocoder.yudao.module.erp.dal.mysql.stock.ErpStockInMapper; import cn.iocoder.yudao.module.erp.dal.redis.no.ErpNoRedisDAO; import cn.iocoder.yudao.module.erp.enums.ErpAuditStatus; import cn.iocoder.yudao.module.erp.enums.stock.ErpStockRecordBizTypeEnum; import cn.iocoder.yudao.module.erp.service.product.ErpProductService; import cn.iocoder.yudao.module.erp.service.purchase.ErpSupplierService; import cn.iocoder.yudao.module.erp.service.stock.bo.ErpStockRecordCreateReqBO; 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 ErpStockInServiceImpl implements ErpStockInService { @Resource private ErpStockInMapper stockInMapper; @Resource private ErpStockInItemMapper stockInItemMapper; @Resource private ErpNoRedisDAO noRedisDAO; @Resource private ErpProductService productService; @Resource private ErpWarehouseService warehouseService; @Resource private ErpSupplierService supplierService; @Resource private ErpStockRecordService stockRecordService; @Override @Transactional(rollbackFor = Exception.class) public Long createStockIn(ErpStockInSaveReqVO createReqVO) { // 1.1 校验入库项的有效性 List stockInItems = validateStockInItems(createReqVO.getItems()); // 1.2 校验供应商 supplierService.validateSupplier(createReqVO.getSupplierId()); // 1.3 生成入库单号,并校验唯一性 String no = noRedisDAO.generate(ErpNoRedisDAO.STOCK_IN_NO_PREFIX); if (stockInMapper.selectByNo(no) != null) { throw exception(STOCK_IN_NO_EXISTS); } // 2.1 插入入库单 ErpStockInDO stockIn = BeanUtils.toBean(createReqVO, ErpStockInDO.class, in -> in .setNo(no).setStatus(ErpAuditStatus.PROCESS.getStatus()) .setTotalCount(getSumValue(stockInItems, ErpStockInItemDO::getCount, BigDecimal::add)) .setTotalPrice(getSumValue(stockInItems, ErpStockInItemDO::getTotalPrice, BigDecimal::add, BigDecimal.ZERO))); stockInMapper.insert(stockIn); // 2.2 插入入库单项 stockInItems.forEach(o -> o.setInId(stockIn.getId())); stockInItemMapper.insertBatch(stockInItems); return stockIn.getId(); } @Override @Transactional(rollbackFor = Exception.class) public void updateStockIn(ErpStockInSaveReqVO updateReqVO) { // 1.1 校验存在 ErpStockInDO stockIn = validateStockInExists(updateReqVO.getId()); if (ErpAuditStatus.APPROVE.getStatus().equals(stockIn.getStatus())) { throw exception(STOCK_IN_UPDATE_FAIL_APPROVE, stockIn.getNo()); } // 1.2 校验供应商 supplierService.validateSupplier(updateReqVO.getSupplierId()); // 1.3 校验入库项的有效性 List stockInItems = validateStockInItems(updateReqVO.getItems()); // 2.1 更新入库单 ErpStockInDO updateObj = BeanUtils.toBean(updateReqVO, ErpStockInDO.class, in -> in .setTotalCount(getSumValue(stockInItems, ErpStockInItemDO::getCount, BigDecimal::add)) .setTotalPrice(getSumValue(stockInItems, ErpStockInItemDO::getTotalPrice, BigDecimal::add))); stockInMapper.updateById(updateObj); // 2.2 更新入库单项 updateStockInItemList(updateReqVO.getId(), stockInItems); } @Override @Transactional(rollbackFor = Exception.class) public void updateStockInStatus(Long id, Integer status) { boolean approve = ErpAuditStatus.APPROVE.getStatus().equals(status); // 1.1 校验存在 ErpStockInDO stockIn = validateStockInExists(id); // 1.2 校验状态 if (stockIn.getStatus().equals(status)) { throw exception(approve ? STOCK_IN_APPROVE_FAIL : STOCK_IN_PROCESS_FAIL); } // 2. 更新状态 int updateCount = stockInMapper.updateByIdAndStatus(id, stockIn.getStatus(), new ErpStockInDO().setStatus(status)); if (updateCount == 0) { throw exception(approve ? STOCK_IN_APPROVE_FAIL : STOCK_IN_PROCESS_FAIL); } // 3. 变更库存 List stockInItems = stockInItemMapper.selectListByInId(id); Integer bizType = approve ? ErpStockRecordBizTypeEnum.OTHER_IN.getType() : ErpStockRecordBizTypeEnum.OTHER_IN_CANCEL.getType(); stockInItems.forEach(stockInItem -> { BigDecimal count = approve ? stockInItem.getCount() : stockInItem.getCount().negate(); stockRecordService.createStockRecord(new ErpStockRecordCreateReqBO( stockInItem.getProductId(), stockInItem.getWarehouseId(), count, bizType, stockInItem.getInId(), stockInItem.getId(), stockIn.getNo())); }); } private List validateStockInItems(List list) { // 1.1 校验产品存在 List productList = productService.validProductList( convertSet(list, ErpStockInSaveReqVO.Item::getProductId)); Map productMap = convertMap(productList, ErpProductDO::getId); // 1.2 校验仓库存在 warehouseService.validWarehouseList(convertSet( list, ErpStockInSaveReqVO.Item::getWarehouseId)); // 2. 转化为 ErpStockInItemDO 列表 return convertList(list, o -> BeanUtils.toBean(o, ErpStockInItemDO.class, item -> item .setProductUnitId(productMap.get(item.getProductId()).getUnitId()) .setTotalPrice(MoneyUtils.priceMultiply(item.getProductPrice(), item.getCount())))); } private void updateStockInItemList(Long id, List newList) { // 第一步,对比新老数据,获得添加、修改、删除的列表 List oldList = stockInItemMapper.selectListByInId(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.setInId(id)); stockInItemMapper.insertBatch(diffList.get(0)); } if (CollUtil.isNotEmpty(diffList.get(1))) { stockInItemMapper.updateBatch(diffList.get(1)); } if (CollUtil.isNotEmpty(diffList.get(2))) { stockInItemMapper.deleteBatchIds(convertList(diffList.get(2), ErpStockInItemDO::getId)); } } @Override @Transactional(rollbackFor = Exception.class) public void deleteStockIn(List ids) { // 1. 校验不处于已审批 List stockIns = stockInMapper.selectBatchIds(ids); if (CollUtil.isEmpty(stockIns)) { return; } stockIns.forEach(stockIn -> { if (ErpAuditStatus.APPROVE.getStatus().equals(stockIn.getStatus())) { throw exception(STOCK_IN_DELETE_FAIL_APPROVE, stockIn.getNo()); } }); // 2. 遍历删除,并记录操作日志 stockIns.forEach(stockIn -> { // 2.1 删除入库单 stockInMapper.deleteById(stockIn.getId()); // 2.2 删除入库单项 stockInItemMapper.deleteByInId(stockIn.getId()); }); } private ErpStockInDO validateStockInExists(Long id) { ErpStockInDO stockIn = stockInMapper.selectById(id); if (stockIn == null) { throw exception(STOCK_IN_NOT_EXISTS); } return stockIn; } @Override public ErpStockInDO getStockIn(Long id) { return stockInMapper.selectById(id); } @Override public PageResult getStockInPage(ErpStockInPageReqVO pageReqVO) { return stockInMapper.selectPage(pageReqVO); } // ==================== 入库项 ==================== @Override public List getStockInItemListByInId(Long inId) { return stockInItemMapper.selectListByInId(inId); } @Override public List getStockInItemListByInIds(Collection inIds) { if (CollUtil.isEmpty(inIds)) { return Collections.emptyList(); } return stockInItemMapper.selectListByInIds(inIds); } }