| | |
| | | } |
| | | |
| | | @Override |
| | | public MesQcTemplateItemDO getRequiredTemplateByItemIdAndType(Long itemId, Integer qcType) { |
| | | List<MesQcTemplateItemDO> templateItems = getTemplateItemList(itemId, qcType, null, null); |
| | | public MesQcTemplateItemDO getRequiredTemplateByItemIdAndType(Long mdmItemId, Integer qcType) { |
| | | List<MesQcTemplateItemDO> templateItems = getTemplateItemList(mdmItemId, qcType, null, null); |
| | | if (CollUtil.isEmpty(templateItems)) { |
| | | throw exception(QC_NO_TEMPLATE); |
| | | } |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<MesQcTemplateItemDO> getTemplateItemList(Long itemId, Integer qcType, Long workOrderId, Long taskId) { |
| | | // 1. 解析真实产品物料 ID:任务优先,其次工单,最后直接用入参 |
| | | Long resolvedItemId = itemId; |
| | | public List<MesQcTemplateItemDO> getTemplateItemList(Long mdmItemId, Integer qcType, Long workOrderId, Long taskId) { |
| | | // 1. 解析 MDM 产品物料 ID:任务优先,其次工单;两者存的是 MES 物料 ID,需转换为 MDM 物料 ID。 |
| | | // 未传工单/任务时,入参本身即 MDM 物料 ID(质检单前端选择的就是 MDM 物料) |
| | | Long resolvedMdmItemId; |
| | | if (taskId != null) { |
| | | resolvedItemId = proTaskService.validateTaskExists(taskId).getItemId(); |
| | | resolvedMdmItemId = convertMesItemIdToMdmItemId(proTaskService.validateTaskExists(taskId).getItemId()); |
| | | } else if (workOrderId != null) { |
| | | resolvedItemId = proWorkOrderService.validateWorkOrderExists(workOrderId).getProductId(); |
| | | resolvedMdmItemId = convertMesItemIdToMdmItemId( |
| | | proWorkOrderService.validateWorkOrderExists(workOrderId).getProductId()); |
| | | } else { |
| | | resolvedMdmItemId = mdmItemId; |
| | | } |
| | | if (resolvedItemId == null) { |
| | | if (resolvedMdmItemId == null) { |
| | | return Collections.emptyList(); |
| | | } |
| | | // 2. mes_md_item.id 转 mdm_item.id(产品关联表存的是 mdm 物料) |
| | | MesMdItemDO item = mesMdItemService.getItem(resolvedItemId); |
| | | if (item == null || item.getMdmItemId() == null) { |
| | | return Collections.emptyList(); |
| | | } |
| | | // 3. 查出该物料关联的所有产品关联 |
| | | List<MesQcTemplateItemDO> templateItems = templateItemMapper.selectListByItemId(item.getMdmItemId()); |
| | | // 2. 查出该物料关联的所有产品关联 |
| | | List<MesQcTemplateItemDO> templateItems = templateItemMapper.selectListByItemId(resolvedMdmItemId); |
| | | if (CollUtil.isEmpty(templateItems)) { |
| | | return Collections.emptyList(); |
| | | } |
| | | // 4. 过滤:方案启用且检测种类包含 qcType,返回全部匹配项 |
| | | // 3. 过滤:方案启用且检测种类包含 qcType,返回全部匹配项 |
| | | List<MesQcTemplateDO> templates = templateService.getTemplateList( |
| | | convertSet(templateItems, MesQcTemplateItemDO::getTemplateId)); |
| | | Set<Long> matchedTemplateIds = templates.stream() |
| | |
| | | .collect(Collectors.toList()); |
| | | } |
| | | |
| | | /** |
| | | * MES 物料 ID 转 MDM 物料 ID |
| | | * |
| | | * @param mesItemId MES 物料 ID(mes_md_item.id) |
| | | * @return MDM 物料 ID(mdm_item.id);MES 物料不存在或未关联 MDM 物料时返回 null |
| | | */ |
| | | private Long convertMesItemIdToMdmItemId(Long mesItemId) { |
| | | if (mesItemId == null) { |
| | | return null; |
| | | } |
| | | MesMdItemDO item = mesMdItemService.getItem(mesItemId); |
| | | return item != null ? item.getMdmItemId() : null; |
| | | } |
| | | |
| | | } |