| | |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.Objects; |
| | |
| | | ProcessInspectMapper processInspectMapper; |
| | | |
| | | @Resource |
| | | MaterialMapper materialMapper; |
| | | |
| | | @Resource |
| | | StandardService standardService; |
| | | |
| | | @Resource |
| | | SpecificationsService specificationsService; |
| | | |
| | | @Resource |
| | | ProductService productService; |
| | | ManualProductService manualProductService; |
| | | |
| | | @Resource |
| | | InspectionItemMapper inspectionItemMapper; |
| | |
| | | BeanUtils.copyProperties(processInspectVo, processInspect); |
| | | processInspectMapper.insert(processInspect); |
| | | /*批量新增过程检验项目表*/ |
| | | //获取型号id |
| | | Integer specificationId = getSpecificationId(processInspectVo.getMaterial(), processInspectVo.getMaterialCode(), processInspectVo.getSpecificationsModel()); |
| | | //查询标准BOM技术指标中该型号工艺下最新版本的检验项目 |
| | | Integer ver = productService.selectVerByPro(specificationId).get(0);//该型号下技术指标最新版本 |
| | | List<Product> productList = productService.selProByVerSpe(processInspectVo.getTechnologyId(), ver); |
| | | List<InspectionItem> inspectionItemList = productList.stream().map(product -> { |
| | | List<ManualProduct> manualProductList = manualProductService.selByMtid(processInspectVo.getMtId()); |
| | | List<InspectionItem> inspectionItemList = manualProductList.stream().map(manualProduct -> { |
| | | InspectionItem inspectionItem = new InspectionItem(); |
| | | BeanUtils.copyProperties(product, inspectionItem); |
| | | BeanUtils.copyProperties(manualProduct, inspectionItem); |
| | | inspectionItem.setCreateTime(new Date()); |
| | | inspectionItem.setUpdateTime(new Date()); |
| | | inspectionItem.setInspectId(processInspect.getId()); |
| | | inspectionItem.setType(1); |
| | | return inspectionItem; |
| | |
| | | //上报(更新检验状态) |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public String updateProcessInspectsById(Integer id) { |
| | | public String updateProcessInspectsById(Integer id, Integer number) { |
| | | /*更新检验单里面的检验结论*/ |
| | | //先判断检验结果 |
| | | List<Integer> results = inspectionItemMapper.getResult(id,1); |
| | | List<Integer> results = inspectionItemMapper.getResult(id, 1); |
| | | int count = 0; |
| | | for (Integer result : results) { |
| | | if (result != null && result == 1) { |
| | |
| | | } else return "项目未检验完!"; |
| | | /*如果检验结论为不合格,则需要新增不合格检验单*/ |
| | | if (processInspect.getResult() == 0) { |
| | | //查询该检验单哪些检验项目不合格 |
| | | List<InspectionItem> inspectionItemList = inspectionItemMapper.selectList(Wrappers.<InspectionItem>query() |
| | | .eq("inspect_id", id) |
| | | .eq("result", 0) |
| | | .eq("type", 1)); |
| | | String msg = null; |
| | | for (InspectionItem inspectionItem : inspectionItemList) { |
| | | msg += inspectionItem.getName(); |
| | | } |
| | | InspectUnaccepted processUnaccepted = InspectUnaccepted.builder() |
| | | .reason(processInspect.getMaterial() +processInspect.getTechname()+ "不合格") //暂且定义为产品名称+工艺不合格 |
| | | .reason(processInspect.getTechname() + msg + "不合格") //定义为工艺+项目不合格 |
| | | .number(number) |
| | | .rawInspectId(id) |
| | | .type(2) //类型为过程检验 |
| | | .build(); |
| | |
| | | //分页查询过程检验单列表 |
| | | @Override |
| | | public IPage<Map<String, Object>> selectProcessInspectsList(Page<Object> page, String techfather, Integer result, String name) { |
| | | return processInspectMapper.selectProcessInspectsList(page,techfather,result,name); |
| | | return processInspectMapper.selectProcessInspectsList(page, techfather, result, name); |
| | | } |
| | | |
| | | |
| | | /*根据样品名称,样品编号,型号规格获取型号id*/ |
| | | private Integer getSpecificationId(String name, String mcode, String specification) { |
| | | //获取物料id |
| | | Material material = materialMapper.selectOne(Wrappers.<Material>query() |
| | | .eq("name", name) |
| | | .eq("code", mcode)); |
| | | if (Objects.isNull(material)) { |
| | | return null; |
| | | } |
| | | //获取规格名称和型号名称 |
| | | String[] split = specification.split("-"); |
| | | String stName = split[0]; |
| | | String spName = split[1]; |
| | | //获取规格id |
| | | Standard standard = standardService.getOne(Wrappers.<Standard>query() |
| | | .eq("name", stName) |
| | | .eq("material_id", material.getId())); |
| | | //获取型号id |
| | | Specifications specifications = specificationsService.getOne(Wrappers.<Specifications>query() |
| | | .eq("name", spName) |
| | | .eq("standard_id", standard.getId())); |
| | | return specifications.getId(); |
| | | } |
| | | |
| | | /*判断检测值是否满足标准值和内控值的要求,如果不满足则检验结论为不合格*/ |
| | | private int checkValues(String standardValueStr, String controlValueStr, String detectionValueStr) { |
| | | boolean isStandardValueSatisfied = isValueSatisfied(standardValueStr, detectionValueStr); |
| | | boolean isControlValueSatisfied = isValueSatisfied(controlValueStr, detectionValueStr); |
| | | |
| | | if (isStandardValueSatisfied && isControlValueSatisfied) { |
| | | return 1; |
| | | } else { |
| | | return 0; |
| | | } |
| | | } |
| | | |
| | | private boolean isValueSatisfied(String valueStr, String detectionValueStr) { |
| | | String substring = valueStr.substring(1, 2); |
| | | if (substring.equals("=")) { |
| | | String operator = valueStr.substring(0, 2); |
| | | Double standardValue = Double.parseDouble(valueStr.substring(2)); |
| | | Double detectionValue = Double.parseDouble(detectionValueStr); |
| | | switch (operator) { |
| | | case ">=": |
| | | return detectionValue >= standardValue; |
| | | case "<=": |
| | | return detectionValue <= standardValue; |
| | | default: |
| | | return false; |
| | | } |
| | | } else { |
| | | String operator = valueStr.substring(0, 1); |
| | | Double standardValue = Double.parseDouble(valueStr.substring(1)); |
| | | Double detectionValue = Double.parseDouble(detectionValueStr); |
| | | switch (operator) { |
| | | case ">": |
| | | return detectionValue > standardValue; |
| | | case "≥": |
| | | return detectionValue >= standardValue; |
| | | case "≤": |
| | | return detectionValue <= standardValue; |
| | | case "<": |
| | | return detectionValue < standardValue; |
| | | case "=": |
| | | return detectionValue.equals(standardValue); |
| | | default: |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |