package cn.iocoder.yudao.module.mes.service.wm.stocktaking.task; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.util.ObjUtil; import cn.hutool.core.util.StrUtil; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.framework.common.util.object.BeanUtils; import cn.iocoder.yudao.module.mes.controller.admin.wm.stocktaking.task.vo.MesWmStockTakingTaskPageReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.stocktaking.task.vo.MesWmStockTakingTaskSaveReqVO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.stocktaking.task.MesWmStockTakingTaskDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.stocktaking.task.MesWmStockTakingTaskLineDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.stocktaking.task.MesWmStockTakingTaskResultDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.stocktaking.plan.MesWmStockTakingPlanDO; import cn.iocoder.yudao.module.mes.dal.mysql.wm.stocktaking.task.MesWmStockTakingTaskMapper; import cn.iocoder.yudao.module.mes.enums.MesBizTypeConstants; import cn.iocoder.yudao.module.mes.enums.md.autocode.MesMdAutoCodeRuleCodeEnum; import cn.iocoder.yudao.module.mes.enums.wm.MesWmStockTakingTaskStatusEnum; import cn.iocoder.yudao.module.mes.enums.wm.MesWmTransactionTypeEnum; import cn.iocoder.yudao.module.mes.service.md.autocode.MesMdAutoCodeRecordService; import cn.iocoder.yudao.module.mes.service.wm.materialstock.MesWmMaterialStockService; import cn.iocoder.yudao.module.mes.service.wm.stocktaking.plan.MesWmStockTakingPlanService; 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.system.api.approval.ApprovalConfigApi; 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.context.annotation.Lazy; import org.springframework.security.core.Authentication; import org.springframework.security.core.context.SecurityContextHolder; 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.util.List; import java.util.Map; import java.util.Set; 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.framework.common.util.collection.CollectionUtils.convertMap; import static cn.iocoder.yudao.framework.security.core.util.SecurityFrameworkUtils.getLoginUserId; import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*; /** * MES 盘点任务 Service 实现类 * * @author 超级管理员 */ @Service @Validated @Slf4j public class MesWmStockTakingTaskServiceImpl implements MesWmStockTakingTaskService { /** * 盘点结果审批的业务类型编码 * * 与 system_approval_config.biz_type 对应,审核人在「系统管理 - 审批配置」中维护。 */ private static final String STOCK_TAKING_RESULT_APPROVE_BIZ_TYPE = "stock_taking_result_approve"; @Resource private MesWmStockTakingTaskMapper stockTakingTaskMapper; @Resource private MesWmMaterialStockService materialStockService; @Resource private MesWmStockTakingPlanService stockTakingPlanService; @Lazy @Resource private MesWmStockTakingTaskLineService stockTakingTaskLineService; @Lazy @Resource private MesWmStockTakingTaskResultService stockTakingTaskResultService; @Resource private MesWmTransactionService wmTransactionService; @Resource private MesMdAutoCodeRecordService mesMdAutoCodeRecordService; @Resource private AdminUserApi adminUserApi; @Resource private ApprovalConfigApi approvalConfigApi; @Override @Transactional(rollbackFor = Exception.class) public Long createStockTakingTask(MesWmStockTakingTaskSaveReqVO createReqVO) { // 1.1 校验 code 唯一 validateStockTakingTaskCodeUnique(null, createReqVO.getCode()); // 1.2 校验方案存在 adminUserApi.validateUser(createReqVO.getUserId()); // 1.3 校验方案可用(如果有 planId) if (createReqVO.getPlanId() != null) { stockTakingPlanService.validateStockTakingPlanEnabled(createReqVO.getPlanId()); } // 2. 插入任务 MesWmStockTakingTaskDO task = BeanUtils.toBean(createReqVO, MesWmStockTakingTaskDO.class) .setStatus(MesWmStockTakingTaskStatusEnum.PREPARE.getStatus()); stockTakingTaskMapper.insert(task); // 3. 根据方案生成盘点明细行(仅当有 plan 时) if (task.getPlanId() != null) { stockTakingTaskLineService.generateStockTakingLines(task, true); } return task.getId(); } @Override @Transactional(rollbackFor = Exception.class) public Long createStockTakingTaskFromPlan(Long planId) { // 1. 校验方案存在、已启用且开启定期自动生成 MesWmStockTakingPlanDO plan = stockTakingPlanService.validateStockTakingPlanEnabled(planId); if (!Boolean.TRUE.equals(plan.getAutoGenerate())) { throw exception(WM_STOCK_TAKING_PLAN_NOT_AUTO_GENERATE); } // 2. 自动生成任务编码(规则:盘点任务编码) String code = mesMdAutoCodeRecordService.generateAutoCode( MesMdAutoCodeRuleCodeEnum.WM_STOCK_TAKING_CODE.getCode()); // 3. 复用创建逻辑生成草稿任务(内部校验编码唯一、方案可用,并按方案生成盘点明细行) Long taskId = createStockTakingTask(new MesWmStockTakingTaskSaveReqVO() .setCode(code) .setName(plan.getName()) .setTakingDate(LocalDateTime.now()) .setType(plan.getType()) .setUserId(getCurrentUserId()) .setPlanId(planId) .setStartTime(plan.getStartTime()) .setEndTime(plan.getEndTime()) .setBlindFlag(plan.getBlindFlag()) .setFrozen(plan.getFrozen()) .setRemark("方案定期自动生成")); // 4. 回写本次生成时间,避免同一周期重复生成(与创建同事务) stockTakingPlanService.updateStockTakingPlanLastGenerateTime(planId, LocalDateTime.now()); return taskId; } @Override @Transactional(rollbackFor = Exception.class) public void updateStockTakingTask(MesWmStockTakingTaskSaveReqVO updateReqVO) { // 1.1 校验任务存在且为草稿状态 validateStockTakingTaskExistsAndPrepare(updateReqVO.getId()); // 1.2 校验 code 唯一 validateStockTakingTaskCodeUnique(updateReqVO.getId(), updateReqVO.getCode()); // 1.3 校验方案存在 adminUserApi.validateUser(updateReqVO.getUserId()); // 1.4 校验方案可用(如果有 planId) if (updateReqVO.getPlanId() != null) { stockTakingPlanService.validateStockTakingPlanEnabled(updateReqVO.getPlanId()); } // 2. 更新任务 MesWmStockTakingTaskDO updateObj = BeanUtils.toBean(updateReqVO, MesWmStockTakingTaskDO.class); stockTakingTaskMapper.updateById(updateObj); // 3. 重新生成盘点明细行(仅当有 plan 时) if (updateObj.getPlanId() != null) { stockTakingTaskLineService.generateStockTakingLines(updateObj, false); } } @Override @Transactional(rollbackFor = Exception.class) public void deleteStockTakingTask(Long id) { // 1. 校验任务存在且为草稿状态 validateStockTakingTaskExistsAndPrepare(id); // 2. 删除任务和明细 stockTakingTaskResultService.deleteStockTakingTaskResultByTaskId(id); stockTakingTaskLineService.deleteStockTakingTaskLineByTaskId(id); stockTakingTaskMapper.deleteById(id); } @Override @Transactional(rollbackFor = Exception.class) public void submitStockTakingTask(Long id) { // 1.1 校验任务存在且为草稿状态 MesWmStockTakingTaskDO task = validateStockTakingTaskExistsAndPrepare(id); // 1.2 检查要盘点的内容 List lines = stockTakingTaskLineService.getStockTakingTaskLineListByTaskId(id); if (CollUtil.isEmpty(lines)) { throw exception(WM_STOCK_TAKING_TASK_NO_LINE); } // 2. 更新任务状态为盘点中,并清空审核标记 stockTakingTaskMapper.submitAndResetAuditInfo(id, MesWmStockTakingTaskStatusEnum.APPROVING.getStatus()); // 3. 根据冻结标识,对物资进行冻结 if (Boolean.TRUE.equals(task.getFrozen())) { updateMaterialStockFrozen(lines, true); } } @Override @Transactional(rollbackFor = Exception.class) public void submitStockTakingResultApproval(Long id) { // 1.1 校验任务存在且处于盘点中状态 MesWmStockTakingTaskDO task = validateStockTakingTaskExistsAndApproving(id); // 1.2 校验本轮结果审批未提交过(避免重复提交) if (isResultApprovalPending(task)) { throw exception(WM_STOCK_TAKING_TASK_ALREADY_SUBMIT_APPROVAL); } // 1.3 校验至少有一条盘点结果 List results = stockTakingTaskResultService.getStockTakingTaskResultListByTaskId(id); if (CollUtil.isEmpty(results)) { throw exception(WM_STOCK_TAKING_TASK_NO_RESULT); } // 1.4 校验审批配置已启用且配置了有效审核人(未配置时抛出带明确提示的业务异常) approvalConfigApi.validateApprovalEnabledAndGetApprovers(STOCK_TAKING_RESULT_APPROVE_BIZ_TYPE); // 2. 记录提交时间并清空上一轮审核结果(任务保持盘点中,等待审核) stockTakingTaskMapper.markResultApprovalSubmitted(id); } @Override public Set getStockTakingTaskApproverUserIds() { return approvalConfigApi.getApproverUserIds(STOCK_TAKING_RESULT_APPROVE_BIZ_TYPE); } @Override @Transactional(rollbackFor = Exception.class) public void auditStockTakingResult(Long id, Boolean pass, String reviewRemark) { // 1. 校验任务存在 MesWmStockTakingTaskDO task = validateStockTakingTaskExists(id); // 2. 校验处于盘点中(含结果审批中)状态 if (!MesWmStockTakingTaskStatusEnum.APPROVING.getStatus().equals(task.getStatus())) { throw exception(WM_STOCK_TAKING_TASK_NOT_APPROVING); } // 3. 校验本轮结果审批已提交且尚未审核 if (!isResultApprovalPending(task)) { throw exception(WM_STOCK_TAKING_TASK_RESULT_NOT_SUBMITTED); } // 4. 校验当前登录用户是该业务类型的审核人(或签:任一人均可审核) Long userId = getLoginUserId(); approvalConfigApi.validateApprover(STOCK_TAKING_RESULT_APPROVE_BIZ_TYPE, userId); // 5. 审核不通过:必须填写原因,任务保持盘点中,可修改实盘后重新提交结果审批 if (!Boolean.TRUE.equals(pass)) { if (StrUtil.isBlank(reviewRemark)) { throw exception(WM_STOCK_TAKING_TASK_REJECT_REASON_REQUIRED); } stockTakingTaskMapper.auditStockTakingTask(id, MesWmStockTakingTaskStatusEnum.APPROVING.getStatus(), userId, getUserNickname(userId), reviewRemark); return; } // 6. 审核通过:先置为已完成并记录审核人与审核意见 stockTakingTaskMapper.auditStockTakingTask(id, MesWmStockTakingTaskStatusEnum.FINISHED.getStatus(), userId, getUserNickname(userId), reviewRemark); // 7. 解冻库存:须在差异核销前解冻,否则核销事务会被库存冻结校验拦截 if (Boolean.TRUE.equals(task.getFrozen())) { updateMaterialStockFrozen(stockTakingTaskLineService.getStockTakingTaskLineListByTaskId(id), false); } // 8. 自动核销盘点差异:盘盈入库 / 盘亏出库,同事务内更新库存台账;任一步失败整体回滚,任务回退为盘点中 doProcessStockTakingDifference(task); } /** * 判断本轮盘点结果审批是否已提交且尚未审核 * * 任务状态 2(盘点中)同时承载「盘点中」与「盘点结果审批中」两个阶段, * 以 reviewTime 非空且 reviewerId 为空作为「已提交、等待审核」的判定条件; * 审核不通过后 reviewerId 非空,任务回到可重新提交结果审批的状态。 * * @param task 盘点任务 * @return 是否处于结果审批中 */ private boolean isResultApprovalPending(MesWmStockTakingTaskDO task) { return task.getReviewerId() == null && task.getReviewTime() != null; } /** * 获取用户昵称 * * @param userId 用户编号 * @return 昵称,用户不存在时返回 null */ private String getUserNickname(Long userId) { if (userId == null) { return null; } AdminUserRespDTO user = adminUserApi.getUser(userId); return user == null ? null : user.getNickname(); } private Long getCurrentUserId() { Authentication authentication = SecurityContextHolder.getContext().getAuthentication(); if (authentication != null && authentication.getPrincipal() instanceof Long) { return (Long) authentication.getPrincipal(); } return 1L; // 默认用户 } @Override @Transactional(rollbackFor = Exception.class) public void cancelStockTakingTask(Long id) { MesWmStockTakingTaskDO task = validateStockTakingTaskExists(id); if (MesWmStockTakingTaskStatusEnum.FINISHED.getStatus().equals(task.getStatus()) || MesWmStockTakingTaskStatusEnum.CANCELED.getStatus().equals(task.getStatus())) { throw exception(WM_STOCK_TAKING_TASK_CANNOT_CANCEL); } task.setStatus(MesWmStockTakingTaskStatusEnum.CANCELED.getStatus()); stockTakingTaskMapper.updateById(task); // 取消后清空审核标记,避免残留审批标记影响后续重新开始盘点 stockTakingTaskMapper.clearAuditInfo(id); if (Boolean.TRUE.equals(task.getFrozen())) { updateMaterialStockFrozen(stockTakingTaskLineService.getStockTakingTaskLineListByTaskId(id), false); } } @Override public MesWmStockTakingTaskDO getStockTakingTask(Long id) { return stockTakingTaskMapper.selectById(id); } @Override public MesWmStockTakingTaskDO validateStockTakingTaskExists(Long id) { MesWmStockTakingTaskDO task = stockTakingTaskMapper.selectById(id); if (task == null) { throw exception(WM_STOCK_TAKING_TASK_NOT_EXISTS); } return task; } @Override public MesWmStockTakingTaskDO validateStockTakingTaskExistsAndPrepare(Long id) { MesWmStockTakingTaskDO task = validateStockTakingTaskExists(id); if (ObjUtil.notEqual(MesWmStockTakingTaskStatusEnum.PREPARE.getStatus(), task.getStatus())) { throw exception(WM_STOCK_TAKING_TASK_NOT_PREPARE); } return task; } @Override public MesWmStockTakingTaskDO validateStockTakingTaskExistsAndApproving(Long id) { MesWmStockTakingTaskDO task = validateStockTakingTaskExists(id); if (ObjUtil.notEqual(MesWmStockTakingTaskStatusEnum.APPROVING.getStatus(), task.getStatus())) { throw exception(WM_STOCK_TAKING_TASK_NOT_APPROVING); } return task; } @Override public PageResult getStockTakingTaskPage(MesWmStockTakingTaskPageReqVO pageReqVO) { return stockTakingTaskMapper.selectPage(pageReqVO); } private void updateMaterialStockFrozen(List lines, boolean frozen) { if (CollUtil.isEmpty(lines)) { return; } List materialStockIds = convertList(lines, MesWmStockTakingTaskLineDO::getMaterialStockId, line -> line.getMaterialStockId() != null); materialStockService.updateMaterialStockFrozen(materialStockIds, frozen); } private void validateStockTakingTaskCodeUnique(Long id, String code) { MesWmStockTakingTaskDO task = stockTakingTaskMapper.selectByCode(code); if (task == null) { return; } if (ObjUtil.notEqual(task.getId(), id)) { throw exception(WM_STOCK_TAKING_TASK_CODE_DUPLICATE); } } /** * 自动核销盘点差异:按盘点结果逐行生成 IN/OUT 库存事务更新库存台账 * *

仅由 {@link #auditStockTakingResult} 的审核通过分支在同事务内调用; * 失败整体回滚,任务回退为盘点中状态,避免重复调整。 * * @param task 已置为已完成、已解冻的盘点任务 */ private void doProcessStockTakingDifference(MesWmStockTakingTaskDO task) { // 1. 获取盘点结果列表 List results = stockTakingTaskResultService.getStockTakingTaskResultListByTaskId(task.getId()); if (CollUtil.isEmpty(results)) { return; // 无盘点结果,无需处理 } // 2. 建立 行号 -> 盘点行 映射:以盘点行(库存快照)为准回填库存编号与维度, // 避免出库核销按 (物料+位置+批次) 组合键匹配到其它供应商/库位的账面行而扣错库存 Map lineMap = convertMap( stockTakingTaskLineService.getStockTakingTaskLineListByTaskId(task.getId()), MesWmStockTakingTaskLineDO::getId); // 3. 遍历结果,处理差异 for (MesWmStockTakingTaskResultDO result : results) { BigDecimal bookQuantity = result.getQuantity(); // 账面数量 BigDecimal takingQuantity = result.getTakingQuantity(); // 盘点数量 if (takingQuantity == null || bookQuantity == null) { continue; } // 计算差异:盘点数量 - 账面数量(盘盈为正、盘亏为负) BigDecimal difference = takingQuantity.subtract(bookQuantity); if (difference.compareTo(BigDecimal.ZERO) == 0) { continue; // 无差异,跳过 } MesWmStockTakingTaskLineDO line = result.getLineId() != null ? lineMap.get(result.getLineId()) : null; // 4. 创建库存调整事务:盘盈传正数入库;盘亏直接传负数出库(createTransaction 校验出库数量必须为负) MesWmTransactionSaveReqDTO transaction = new MesWmTransactionSaveReqDTO() .setType(difference.compareTo(BigDecimal.ZERO) > 0 ? MesWmTransactionTypeEnum.IN.getType() : MesWmTransactionTypeEnum.OUT.getType()) .setQuantity(difference) .setItemId(line != null ? line.getItemId() : result.getItemId()) .setBatchId(line != null ? line.getBatchId() : result.getBatchId()) .setBatchCode(line != null ? line.getBatchCode() : result.getBatchCode()) .setWarehouseId(line != null ? line.getWarehouseId() : result.getWarehouseId()) .setLocationId(line != null ? line.getLocationId() : result.getLocationId()) .setAreaId(line != null ? line.getAreaId() : result.getAreaId()) .setMaterialStockId(line != null ? line.getMaterialStockId() : result.getMaterialStockId()) .setBizId(task.getId()) .setBizCode(task.getCode()) .setBizLineId(result.getLineId()) .setBizType(MesBizTypeConstants.WM_STOCK_TAKING); wmTransactionService.createTransaction(transaction); } } }