package cn.iocoder.yudao.module.mes.service.qc.ipqc; import cn.hutool.core.util.ObjUtil; import cn.hutool.core.util.ObjectUtil; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productproduce.MesWmProductProduceLineDO; import cn.iocoder.yudao.module.mes.enums.wm.MesWmQualityStatusEnum; import cn.iocoder.yudao.framework.common.util.object.BeanUtils; import cn.iocoder.yudao.module.mes.controller.admin.qc.ipqc.vo.MesQcIpqcPageReqVO; import cn.iocoder.yudao.module.mes.controller.admin.qc.ipqc.vo.MesQcIpqcSaveReqVO; import cn.iocoder.yudao.module.mes.dal.dataobject.md.workstation.MesMdWorkstationDO; import cn.iocoder.yudao.module.mes.dal.dataobject.pro.route.MesProRouteProductDO; import cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskDO; import cn.iocoder.yudao.module.mes.dal.dataobject.pro.workorder.MesProWorkOrderDO; import cn.iocoder.yudao.module.mes.dal.dataobject.pro.feedback.MesProFeedbackDO; import cn.iocoder.yudao.module.mes.dal.dataobject.qc.defectrecord.MesQcDefectRecordDO; import cn.iocoder.yudao.module.mes.dal.dataobject.qc.ipqc.MesQcIpqcDO; import cn.iocoder.yudao.module.mes.dal.dataobject.qc.template.MesQcTemplateItemDO; import cn.iocoder.yudao.module.mes.dal.mysql.qc.ipqc.MesQcIpqcMapper; import cn.iocoder.yudao.module.mes.enums.qc.MesQcDefectLevelEnum; import cn.iocoder.yudao.module.mes.enums.qc.MesQcStatusEnum; import cn.iocoder.yudao.module.mes.enums.qc.MesQcTypeEnum; import cn.iocoder.yudao.module.mes.enums.MesBizTypeConstants; import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService; import cn.iocoder.yudao.module.mes.service.md.workstation.MesMdWorkstationService; import cn.iocoder.yudao.module.mes.service.pro.feedback.MesProFeedbackService; import cn.iocoder.yudao.module.mes.service.pro.route.MesProRouteProcessService; import cn.iocoder.yudao.module.mes.service.pro.route.MesProRouteProductService; import cn.iocoder.yudao.module.mes.service.pro.task.MesProTaskService; import cn.iocoder.yudao.module.mes.service.pro.workorder.MesProWorkOrderService; import cn.iocoder.yudao.module.mes.service.qc.defectrecord.MesQcDefectRecordService; import cn.iocoder.yudao.module.mes.service.qc.indicatorresult.MesQcIndicatorResultService; import cn.iocoder.yudao.module.mes.service.qc.template.MesQcTemplateItemService; import cn.iocoder.yudao.module.mes.service.wm.productproduce.MesWmProductProduceLineService; import cn.iocoder.yudao.module.system.api.user.AdminUserApi; import jakarta.annotation.Resource; import org.springframework.context.annotation.Lazy; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.validation.annotation.Validated; import java.math.BigDecimal; import java.math.RoundingMode; import java.util.List; import java.util.Objects; import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception; import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*; /** * MES 过程检验单(IPQC) Service 实现类 * * @author 芋道源码 */ @Service @Validated public class MesQcIpqcServiceImpl implements MesQcIpqcService { @Resource private MesQcIpqcMapper ipqcMapper; @Resource private MesQcTemplateItemService templateItemService; @Resource private MesQcIpqcLineService ipqcLineService; @Resource @Lazy private MesProWorkOrderService workOrderService; @Resource @Lazy private MesMdWorkstationService workstationService; @Resource @Lazy private MesMdItemService itemService; @Resource @Lazy private MesQcDefectRecordService defectRecordService; @Resource @Lazy private MesProRouteProductService routeProductService; @Resource @Lazy private MesProRouteProcessService routeProcessService; @Resource @Lazy private MesProTaskService taskService; @Resource @Lazy private MesProFeedbackService feedbackService; @Resource @Lazy private MesQcIndicatorResultService indicatorResultService; @Resource @Lazy private MesWmProductProduceLineService productProduceLineService; @Resource private AdminUserApi adminUserApi; @Override @Transactional(rollbackFor = Exception.class) public Long createIpqc(MesQcIpqcSaveReqVO createReqVO) { // 1.1 校验数据 MesMdWorkstationDO workstation = validateIpqcSaveData(createReqVO); // 1.2 校验工单存在 MesProWorkOrderDO workOrder = workOrderService.validateWorkOrderExists(createReqVO.getWorkOrderId()); // 1.3 根据产品 + 检验类型自动匹配模板 MesQcTemplateItemDO templateItem = templateItemService.getRequiredTemplateByItemIdAndType( workOrder.getProductId(), MesQcTypeEnum.IPQC.getType()); Long templateId = templateItem.getTemplateId(); // 1.4 获取来源单据编号 String sourceDocCode = validateAndGetSourceDocCode( createReqVO.getSourceDocType(), createReqVO.getSourceDocId(), createReqVO.getSourceLineId()); // 2. 插入主表 MesQcIpqcDO ipqc = BeanUtils.toBean(createReqVO, MesQcIpqcDO.class) .setItemId(workOrder.getProductId()) .setProcessId(getProcessId(workOrder.getProductId(), workstation.getProcessId())) .setTemplateId(templateId) .setSourceDocCode(sourceDocCode) .setStatus(MesQcStatusEnum.DRAFT.getStatus()); ipqcMapper.insert(ipqc); // 3. 从模板指标自动生成检验行 ipqcLineService.createLinesFromTemplate(ipqc.getId(), templateId); return ipqc.getId(); } @Override public void updateIpqc(MesQcIpqcSaveReqVO updateReqVO) { // 1.1 校验存在 + 草稿状态 validateIpqcStatusPrepare(updateReqVO.getId()); // 1.2 校验数据 MesMdWorkstationDO workstation = validateIpqcSaveData(updateReqVO); // 2. 更新主表 MesQcIpqcDO existIpqc = validateIpqcExists(updateReqVO.getId()); MesQcIpqcDO updateObj = BeanUtils.toBean(updateReqVO, MesQcIpqcDO.class); updateObj.setSourceDocType(null).setSourceDocId(null).setSourceLineId(null); // 不允许修改来源单据 updateObj.setTemplateId(null); // 不允许修改模板 updateObj.setItemId(null); // 不允许修改物料 updateObj.setWorkOrderId(null); // 不允许修改工单 updateObj.setProcessId(getProcessId(existIpqc.getItemId(), workstation.getProcessId())); ipqcMapper.updateById(updateObj); } private MesMdWorkstationDO validateIpqcSaveData(MesQcIpqcSaveReqVO reqVO) { // 校验编号唯一 validateIpqcCodeUnique(reqVO.getId(), reqVO.getCode()); // 校验工位、检测人员存在 MesMdWorkstationDO workstation = workstationService.validateWorkstationExists(reqVO.getWorkstationId()); adminUserApi.validateUser(reqVO.getInspectorUserId()); // 校验工单存在 MesProWorkOrderDO workOrder = workOrderService.validateWorkOrderConfirmed(reqVO.getWorkOrderId()); if (reqVO.getItemId() != null && ObjUtil.notEqual(reqVO.getItemId(), workOrder.getProductId())) { throw exception(PRO_WORK_ORDER_PRODUCT_MISMATCH); } if (reqVO.getProcessId() != null && ObjUtil.notEqual(workstation.getProcessId(), reqVO.getProcessId())) { throw exception(PRO_WORKSTATION_PROCESS_MISMATCH); } // 校验任务关系(如果指定了任务) if (reqVO.getTaskId() != null) { MesProTaskDO task = taskService.validateTaskNotFinished(reqVO.getTaskId()); validateTaskRelation(task, workstation, workOrder, reqVO); } return workstation; } private void validateTaskRelation(MesProTaskDO task, MesMdWorkstationDO workstation, MesProWorkOrderDO workOrder, MesQcIpqcSaveReqVO reqVO) { if (ObjUtil.notEqual(task.getWorkOrderId(), workOrder.getId())) { throw exception(PRO_TASK_WORK_ORDER_MISMATCH); } if (ObjUtil.notEqual(task.getWorkstationId(), workstation.getId())) { throw exception(PRO_TASK_WORKSTATION_MISMATCH); } Long expectedProcessId = reqVO.getProcessId() != null ? reqVO.getProcessId() : workstation.getProcessId(); if (expectedProcessId != null && ObjUtil.notEqual(task.getProcessId(), expectedProcessId)) { throw exception(PRO_TASK_ROUTE_PROCESS_MISMATCH); } if (ObjUtil.notEqual(task.getItemId(), workOrder.getProductId())) { throw exception(PRO_TASK_ITEM_MISMATCH); } } @Override @Transactional(rollbackFor = Exception.class) public void finishIpqc(Long id) { // 1.1 校验存在 + 草稿状态 MesQcIpqcDO ipqc = validateIpqcStatusPrepare(id); // 1.2 校验检测结论必填 if (ipqc.getCheckResult() == null) { throw exception(QC_IPQC_CHECK_RESULT_EMPTY); } // 1.3 校验至少存在一条检测结果 indicatorResultService.validateIndicatorResultExistsByQcIdAndType(id, MesQcTypeEnum.IPQC.getType()); // 2. 更新状态为已完成 ipqcMapper.updateById(new MesQcIpqcDO() .setId(id).setStatus(MesQcStatusEnum.FINISHED.getStatus())); // 3. 回写来源单据 writeBackSourceDoc(ipqc); } /** * 回写来源单据(IPQC 完成后) * *
当来源为报工时,拆分待检产出行、完成产出入库、回写报工状态和任务/工单进度 * * @param ipqc 过程检验单 */ private void writeBackSourceDoc(MesQcIpqcDO ipqc) { if (ipqc.getSourceDocType() == null) { return; } if (ipqc.getSourceDocId() == null) { throw new IllegalArgumentException( "IPQC 单[" + ipqc.getId() + "] sourceDocType 非空但 sourceDocId 为空"); } if (Objects.equals(ipqc.getSourceDocType(), MesBizTypeConstants.PRO_FEEDBACK)) { feedbackService.updateProFeedbackWhenIpqcFinish(ipqc.getSourceDocId(), ipqc.getSourceLineId(), ObjectUtil.defaultIfNull(ipqc.getQualifiedQuantity(), BigDecimal.ZERO), ObjectUtil.defaultIfNull(ipqc.getUnqualifiedQuantity(), BigDecimal.ZERO), ObjectUtil.defaultIfNull(ipqc.getLaborScrapQuantity(), BigDecimal.ZERO), ObjectUtil.defaultIfNull(ipqc.getMaterialScrapQuantity(), BigDecimal.ZERO), ObjectUtil.defaultIfNull(ipqc.getOtherScrapQuantity(), BigDecimal.ZERO)); } else { throw new IllegalArgumentException( "IPQC 单[" + ipqc.getId() + "] sourceDocType=" + ipqc.getSourceDocType() + " 无法识别,无法回写来源单据"); } } @Override @Transactional(rollbackFor = Exception.class) public void deleteIpqc(Long id) { // 1. 校验存在 + 草稿状态 validateIpqcStatusPrepare(id); // 2.1 删除主表 ipqcMapper.deleteById(id); // 2.2 级联删除行 ipqcLineService.deleteListByIpqcId(id); // 2.3 级联删除缺陷记录 defectRecordService.deleteListByQcTypeAndQcId(MesQcTypeEnum.IPQC.getType(), id); } @Override public MesQcIpqcDO validateIpqcExists(Long id) { MesQcIpqcDO ipqc = ipqcMapper.selectById(id); if (ipqc == null) { throw exception(QC_IPQC_NOT_EXISTS); } return ipqc; } /** * 校验过程检验单存在且为草稿状态 * * @param id 过程检验单 ID * @return 过程检验单 */ private MesQcIpqcDO validateIpqcStatusPrepare(Long id) { MesQcIpqcDO ipqc = validateIpqcExists(id); if (ObjUtil.notEqual(ipqc.getStatus(), MesQcStatusEnum.DRAFT.getStatus())) { throw exception(QC_IPQC_NOT_PREPARE); } return ipqc; } private void validateIpqcCodeUnique(Long id, String code) { MesQcIpqcDO ipqc = ipqcMapper.selectByCode(code); if (ipqc == null) { return; } if (ObjUtil.notEqual(ipqc.getId(), id)) { throw exception(QC_IPQC_CODE_DUPLICATE); } } private String validateAndGetSourceDocCode(Integer sourceDocType, Long sourceDocId, Long sourceLineId) { if (sourceDocType == null || sourceDocId == null) { return null; } if (Objects.equals(sourceDocType, MesBizTypeConstants.PRO_FEEDBACK)) { MesProFeedbackDO feedback = feedbackService.validateFeedbackExists(sourceDocId); // 校验 sourceLineId 必填 if (sourceLineId == null) { throw exception(QC_IPQC_SOURCE_LINE_REQUIRED); } // 校验 sourceLineId 存在,且属于该报工的产出行 MesWmProductProduceLineDO targetLine = productProduceLineService .validateProductProduceLineExists(sourceLineId); if (ObjUtil.notEqual(targetLine.getFeedbackId(), sourceDocId)) { throw exception(QC_IPQC_SOURCE_LINE_NOT_BELONG); } // 校验该产出行为待检验状态 if (ObjUtil.notEqual(targetLine.getQualityStatus(), MesWmQualityStatusEnum.PENDING.getStatus())) { throw exception(QC_IPQC_SOURCE_LINE_NOT_PENDING); } return feedback.getCode(); } // 未知来源类型应报错,而不是静默忽略 throw exception(QC_IPQC_SOURCE_DOC_TYPE_UNKNOWN); } /** * 推导工序 ID * *
通过产品 → 工艺路线产品 → 工艺路线 → 校验工位工序是否在该路线中 *
如果工位的工序在路线中,则返回该 processId;否则返回 null
*
* @param productId 产品 ID(工单产品)
* @param workstationProcessId 工位关联的工序 ID
* @return 推导出的工序 ID,无法推导时返回 null
*/
private Long getProcessId(Long productId, Long workstationProcessId) {
if (productId == null || workstationProcessId == null) {
return null;
}
// 1. 产品 → 工艺路线
MesProRouteProductDO routeProduct = routeProductService.getRouteProductByItemId(productId);
if (routeProduct == null) {
return null;
}
// 2. 校验工位的工序是否在该路线中
if (routeProcessService.getRouteProcessByRouteIdAndProcessId(
routeProduct.getRouteId(), workstationProcessId) == null) {
return null;
}
return workstationProcessId;
}
@Override
public MesQcIpqcDO getIpqc(Long id) {
return ipqcMapper.selectById(id);
}
@Override
public PageResult