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.check.ErpStockCheckPageReqVO; import cn.iocoder.yudao.module.erp.controller.admin.stock.vo.check.ErpStockCheckSaveReqVO; import cn.iocoder.yudao.module.erp.dal.dataobject.product.ErpProductDO; import cn.iocoder.yudao.module.erp.dal.dataobject.stock.ErpStockCheckDO; import cn.iocoder.yudao.module.erp.dal.dataobject.stock.ErpStockCheckItemDO; import cn.iocoder.yudao.module.erp.dal.mysql.stock.ErpStockCheckItemMapper; import cn.iocoder.yudao.module.erp.dal.mysql.stock.ErpStockCheckMapper; 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.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 ErpStockCheckServiceImpl implements ErpStockCheckService { @Resource private ErpStockCheckMapper stockCheckMapper; @Resource private ErpStockCheckItemMapper stockCheckItemMapper; @Resource private ErpNoRedisDAO noRedisDAO; @Resource private ErpProductService productService; @Resource private ErpWarehouseService warehouseService; @Resource private ErpStockRecordService stockRecordService; @Override @Transactional(rollbackFor = Exception.class) public Long createStockCheck(ErpStockCheckSaveReqVO createReqVO) { // 1.1 校验盘点项的有效性 List stockCheckItems = validateStockCheckItems(createReqVO.getItems()); // 1.2 生成盘点单号,并校验唯一性 String no = noRedisDAO.generate(ErpNoRedisDAO.STOCK_CHECK_NO_PREFIX); if (stockCheckMapper.selectByNo(no) != null) { throw exception(STOCK_CHECK_NO_EXISTS); } // 2.1 插入盘点单 ErpStockCheckDO stockCheck = BeanUtils.toBean(createReqVO, ErpStockCheckDO.class, in -> in .setNo(no).setStatus(ErpAuditStatus.PROCESS.getStatus()) .setTotalCount(getSumValue(stockCheckItems, ErpStockCheckItemDO::getCount, BigDecimal::add)) .setTotalPrice(getSumValue(stockCheckItems, ErpStockCheckItemDO::getTotalPrice, BigDecimal::add, BigDecimal.ZERO))); stockCheckMapper.insert(stockCheck); // 2.2 插入盘点单项 stockCheckItems.forEach(o -> o.setCheckId(stockCheck.getId())); stockCheckItemMapper.insertBatch(stockCheckItems); return stockCheck.getId(); } @Override @Transactional(rollbackFor = Exception.class) public void updateStockCheck(ErpStockCheckSaveReqVO updateReqVO) { // 1.1 校验存在 ErpStockCheckDO stockCheck = validateStockCheckExists(updateReqVO.getId()); if (ErpAuditStatus.APPROVE.getStatus().equals(stockCheck.getStatus())) { throw exception(STOCK_CHECK_UPDATE_FAIL_APPROVE, stockCheck.getNo()); } // 1.2 校验盘点项的有效性 List stockCheckItems = validateStockCheckItems(updateReqVO.getItems()); // 2.1 更新盘点单 ErpStockCheckDO updateObj = BeanUtils.toBean(updateReqVO, ErpStockCheckDO.class, in -> in .setTotalCount(getSumValue(stockCheckItems, ErpStockCheckItemDO::getCount, BigDecimal::add)) .setTotalPrice(getSumValue(stockCheckItems, ErpStockCheckItemDO::getTotalPrice, BigDecimal::add))); stockCheckMapper.updateById(updateObj); // 2.2 更新盘点单项 updateStockCheckItemList(updateReqVO.getId(), stockCheckItems); } @Override @Transactional(rollbackFor = Exception.class) public void updateStockCheckStatus(Long id, Integer status) { boolean approve = ErpAuditStatus.APPROVE.getStatus().equals(status); // 1.1 校验存在 ErpStockCheckDO stockCheck = validateStockCheckExists(id); // 1.2 校验状态 if (stockCheck.getStatus().equals(status)) { throw exception(approve ? STOCK_CHECK_APPROVE_FAIL : STOCK_CHECK_PROCESS_FAIL); } // 2. 更新状态 int updateCount = stockCheckMapper.updateByIdAndStatus(id, stockCheck.getStatus(), new ErpStockCheckDO().setStatus(status)); if (updateCount == 0) { throw exception(approve ? STOCK_CHECK_APPROVE_FAIL : STOCK_CHECK_PROCESS_FAIL); } // 3. 变更库存 List stockCheckItems = stockCheckItemMapper.selectListByCheckId(id); stockCheckItems.forEach(stockCheckItem -> { // 没有盈亏,不用出入库 if (stockCheckItem.getCount().compareTo(BigDecimal.ZERO) == 0) { return; } // 10;12;-2() BigDecimal count = approve ? stockCheckItem.getCount(): stockCheckItem.getCount().negate(); Integer bizType; if (approve) { bizType = count.compareTo(BigDecimal.ZERO) > 0 ? ErpStockRecordBizTypeEnum.CHECK_MORE_IN.getType() : ErpStockRecordBizTypeEnum.CHECK_LESS_OUT.getType(); } else { bizType = count.compareTo(BigDecimal.ZERO) > 0 ? ErpStockRecordBizTypeEnum.CHECK_MORE_IN_CANCEL.getType() : ErpStockRecordBizTypeEnum.CHECK_LESS_OUT_CANCEL.getType(); } stockRecordService.createStockRecord(new ErpStockRecordCreateReqBO( stockCheckItem.getProductId(), stockCheckItem.getWarehouseId(), count, bizType, stockCheckItem.getCheckId(), stockCheckItem.getId(), stockCheck.getNo())); }); } private List validateStockCheckItems(List list) { // 1.1 校验产品存在 List productList = productService.validProductList( convertSet(list, ErpStockCheckSaveReqVO.Item::getProductId)); Map productMap = convertMap(productList, ErpProductDO::getId); // 1.2 校验仓库存在 warehouseService.validWarehouseList(convertSet(list, ErpStockCheckSaveReqVO.Item::getWarehouseId)); // 2. 转化为 ErpStockCheckItemDO 列表 return convertList(list, o -> BeanUtils.toBean(o, ErpStockCheckItemDO.class, item -> item .setProductUnitId(productMap.get(item.getProductId()).getUnitId()) .setTotalPrice(MoneyUtils.priceMultiply(item.getProductPrice(), item.getCount())))); } private void updateStockCheckItemList(Long id, List newList) { // 第一步,对比新老数据,获得添加、修改、删除的列表 List oldList = stockCheckItemMapper.selectListByCheckId(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.setCheckId(id)); stockCheckItemMapper.insertBatch(diffList.get(0)); } if (CollUtil.isNotEmpty(diffList.get(1))) { stockCheckItemMapper.updateBatch(diffList.get(1)); } if (CollUtil.isNotEmpty(diffList.get(2))) { stockCheckItemMapper.deleteBatchIds(convertList(diffList.get(2), ErpStockCheckItemDO::getId)); } } @Override @Transactional(rollbackFor = Exception.class) public void deleteStockCheck(List ids) { // 1. 校验不处于已审批 List stockChecks = stockCheckMapper.selectBatchIds(ids); if (CollUtil.isEmpty(stockChecks)) { return; } stockChecks.forEach(stockCheck -> { if (ErpAuditStatus.APPROVE.getStatus().equals(stockCheck.getStatus())) { throw exception(STOCK_CHECK_DELETE_FAIL_APPROVE, stockCheck.getNo()); } }); // 2. 遍历删除,并记录操作日志 stockChecks.forEach(stockCheck -> { // 2.1 删除盘点单 stockCheckMapper.deleteById(stockCheck.getId()); // 2.2 删除盘点单项 stockCheckItemMapper.deleteByCheckId(stockCheck.getId()); }); } private ErpStockCheckDO validateStockCheckExists(Long id) { ErpStockCheckDO stockCheck = stockCheckMapper.selectById(id); if (stockCheck == null) { throw exception(STOCK_CHECK_NOT_EXISTS); } return stockCheck; } @Override public ErpStockCheckDO getStockCheck(Long id) { return stockCheckMapper.selectById(id); } @Override public PageResult getStockCheckPage(ErpStockCheckPageReqVO pageReqVO) { return stockCheckMapper.selectPage(pageReqVO); } // ==================== 盘点项 ==================== @Override public List getStockCheckItemListByCheckId(Long checkId) { return stockCheckItemMapper.selectListByCheckId(checkId); } @Override public List getStockCheckItemListByCheckIds(Collection checkIds) { if (CollUtil.isEmpty(checkIds)) { return Collections.emptyList(); } return stockCheckItemMapper.selectListByCheckIds(checkIds); } }