From 1c26d05a692239825921c146348db52540261d7c Mon Sep 17 00:00:00 2001 From: JYW <2013732181@qq.com> Date: 星期三, 24 四月 2024 16:12:51 +0800 Subject: [PATCH] 2024-04-24 样品缺陷指数 --- inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java | 179 ++++++++++++++++++++++++++++++++++------------------------- 1 files changed, 103 insertions(+), 76 deletions(-) diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java index 36c8f4a..a8ba372 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java @@ -27,6 +27,8 @@ import com.yuanchu.mom.service.InsOrderService; import com.yuanchu.mom.service.StandardTemplateService; import com.yuanchu.mom.utils.GiveCode; +import com.yuanchu.mom.utils.JackSonUtil; +import com.yuanchu.mom.utils.MatrixToImageWriter; import com.yuanchu.mom.utils.QueryWrappers; import com.yuanchu.mom.vo.InsOrderPlanVO; import org.apache.poi.xwpf.usermodel.TableRowAlign; @@ -77,6 +79,9 @@ @Value("${wordUrl}") private String wordUrl; + @Value("${twoCode}") + private String twoCode; + @Resource private GiveCode giveCode; @@ -85,6 +90,9 @@ @Resource private InsProductResultMapper insProductResultMapper; + + @Resource + private InsProductUserMapper insProductUserMapper; @Override public Map<String, Object> selectInsOrderPlanList(Page page, InsOrderPlanDTO insOrderPlanDTO) { @@ -115,9 +123,9 @@ public Map<String, Object> doInsOrder(Integer id, String laboratory) { InsOrder insOrder = new InsOrder(); insOrder.setId(id); - insOrder.setInsState(1); InsOrder order = insOrderMapper.selectById(id); if (BeanUtil.isEmpty(order.getInsTime())) { + insOrder.setInsState(1); insOrder.setInsTime(LocalDateTime.now()); insOrderMapper.updateById(insOrder); } @@ -139,7 +147,6 @@ public void saveInsContext(Map<String, Object> insContext) { Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId"); CompletableFuture.supplyAsync(() -> { - AtomicInteger count = new AtomicInteger(); insContext.forEach((k, v) -> { JSONObject jo = JSON.parseObject(JSON.toJSONString(v)); InsProduct insProduct = new InsProduct(); @@ -149,39 +156,57 @@ result = new InsProductResult(); } result.setInsProductId(Integer.parseInt(k)); - JSONArray jsonArray = JSON.parseArray(JSON.toJSONString(jo.get("insValue"))); - List<Map<String, Object>> iv = new ArrayList<>(); - for (Object o : jsonArray) { - JSONObject insValue = JSON.parseObject(JSON.toJSONString(o)); - Map<String, Object> map = new HashMap<>(); - map.put("v", JSON.parseObject(JSON.toJSONString(insValue.get("v"))).get("v")); - if ((insValue.get("u") == null || insValue.get("u").equals("")) && StrUtil.isNotEmpty(JSON.parseObject(JSON.toJSONString(insValue.get("v"))).get("v").toString())) { - map.put("u", userId); - } else { - map.put("u", insValue.get("u")); + if (jo.get("insValue") != null) { + JSONArray jsonArray = JSON.parseArray(JSON.toJSONString(jo.get("insValue"))); + List<Map<String, Object>> iv = new ArrayList<>(); + for (Object o : jsonArray) { + JSONObject insValue = JSON.parseObject(JSON.toJSONString(o)); + Map<String, Object> map = new HashMap<>(); + map.put("v", JSON.parseObject(JSON.toJSONString(insValue.get("v"))).get("v")); + try { + if ((insValue.get("u") == null || insValue.get("u").equals("")) && StrUtil.isNotEmpty(JSON.parseObject(JSON.toJSONString(insValue.get("v"))).get("v").toString())) { + map.put("u", userId + ""); + } else { + map.put("u", insValue.get("u")); + } + iv.add(map); + } catch (Exception e) { + } } - iv.add(map); + result.setInsValue(JSON.toJSONString(iv)); } - result.setInsValue(JSON.toJSONString(iv)); - JSONArray jsonArray2 = JSON.parseArray(JSON.toJSONString(jo.get("comValue"))); - List<Map<String, Object>> cv = new ArrayList<>(); - for (Object o : jsonArray2) { - JSONObject comValue = JSON.parseObject(JSON.toJSONString(o)); - Map<String, Object> map = new HashMap<>(); - map.put("v", JSON.parseObject(JSON.toJSONString(comValue.get("v"))).get("v")); - cv.add(map); + if (jo.get("comValue") != null) { + JSONArray jsonArray2 = JSON.parseArray(JSON.toJSONString(jo.get("comValue"))); + List<Map<String, Object>> cv = new ArrayList<>(); + for (Object o : jsonArray2) { + JSONObject comValue = JSON.parseObject(JSON.toJSONString(o)); + Map<String, Object> map = new HashMap<>(); + map.put("v", JSON.parseObject(JSON.toJSONString(comValue.get("v"))).get("v")); + cv.add(map); + } + result.setComValue(JSON.toJSONString(cv)); } - result.setComValue(JSON.toJSONString(cv)); JSONObject resValue = JSON.parseObject(JSON.toJSONString(jo.get("resValue"))); - insProduct.setLastValue(JSON.parseObject(JSON.toJSONString(resValue.get("v"))).get("v") + ""); - JSONObject equipValue = JSON.parseObject(JSON.toJSONString(jo.get("equipValue"))); - try { - result.setEquipValue(JSON.parseObject(JSON.toJSONString(equipValue.get("v"))).get("v") + ""); - } catch (Exception ignored) { - result.setEquipValue(null); + if (resValue.get("v") != null) { + insProduct.setLastValue(JSON.parseObject(JSON.toJSONString(resValue.get("v"))).get("v") + ""); } - JSONObject insResult = JSON.parseObject(JSON.toJSONString(jo.get("insResult"))); - insProduct.setInsResult(Integer.parseInt(JSON.parseObject(JSON.toJSONString(insResult.get("v"))).get("v") + "")); + if (jo.get("equipValue") != null) { + JSONArray jsonArray2 = JSON.parseArray(JSON.toJSONString(jo.get("equipValue"))); + List<Map<String, Object>> ev = new ArrayList<>(); + for (Object o : jsonArray2) { + JSONObject equipValue = JSON.parseObject(JSON.toJSONString(o)); + Map<String, Object> map = new HashMap<>(); + map.put("v", JSON.parseObject(JSON.toJSONString(equipValue.get("v"))).get("v")); + ev.add(map); + } + result.setEquipValue(JSON.toJSONString(ev)); + } + try { + JSONObject insResult = JSON.parseObject(JSON.toJSONString(jo.get("insResult"))); + String ir = JSON.parseObject(JSON.toJSONString(insResult.get("v"))).get("v") + ""; + insProduct.setInsResult(Integer.parseInt(ir)); + } catch (Exception e) { + } if (BeanUtil.isEmpty(result.getId())) { result.setCreateUser(userId); result.setUpdateUser(userId); @@ -193,11 +218,17 @@ } insProduct.setUpdateUser(userId); insProductMapper.updateById(insProduct); - if (count.get() == 0) { - InsSample insSample = insSampleMapper.selectById(insProductMapper.selectById(insProduct.getId()).getInsSampleId()); - insSample.setInsState(1); - count.addAndGet(1); + insProductUserMapper.insert(new InsProductUser(null, userId, LocalDateTime.now(), insProduct.getId())); + InsSample insSample = insSampleMapper.selectById(insProductMapper.selectById(insProduct.getId()).getInsSampleId()); + insSample.setInsState(1); + Long l = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery() + .eq(InsProduct::getInsSampleId, insSample.getId())); + Long l1 = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery() + .eq(InsProduct::getInsSampleId, insSample.getId()).isNotNull(InsProduct::getInsResult)); + if (l == l1) { + insSample.setInsState(2); } + insSampleMapper.updateById(insSample); }); return null; }).thenAccept(res -> { @@ -238,11 +269,11 @@ samples.forEach(a -> { Set<String> templateSet = new HashSet<>(); getTemplateThing(set, map2, a); - a.getInsProduct().forEach(b->{ - String[] split = b.getMethod().replaceAll("]", "").replaceAll("\\[","").replaceAll("\"","").split(","); + a.getInsProduct().forEach(b -> { + String[] split = b.getMethod().replaceAll("]", "").replaceAll("\\[", "").replaceAll("\"", "").split(","); standardMethod.addAll(Arrays.asList(split)); - if(b.getInsProductResult()!=null){ - if(b.getInsProductResult().getEquipValue()!=null&& !Objects.equals(b.getInsProductResult().getEquipValue(), "")){ + if (b.getInsProductResult() != null) { + if (b.getInsProductResult().getEquipValue() != null && !Objects.equals(b.getInsProductResult().getEquipValue(), "")) { deviceSet.add(b.getInsProductResult().getEquipValue()); } } @@ -252,7 +283,7 @@ templateSet.add(JSON.toJSONString(b.getTemplate())); }); AtomicInteger index = new AtomicInteger(); - templateSet.forEach(tem->{ + templateSet.forEach(tem -> { Set<Integer> set2 = new HashSet<>(); List<RowRenderData> rows = new ArrayList<>(); List<TextRenderData> text = new ArrayList<>(); @@ -270,15 +301,15 @@ if ("妫�楠屽瓙椤�".equals(JSON.parseObject(JSON.toJSONString(v.get("ps"))).get("value") + "")) { int count2 = 0; for (InsProduct p : a.getInsProduct()) { - if(v.get("v").equals(p.getInspectionItemSubclass())){ - pMap.put(jo1.get("r")+"", p); + if (v.get("v").equals(p.getInspectionItemSubclass())) { + pMap.put(jo1.get("r") + "", p); break; - }else{ + } else { count2++; } } - if(count2 == a.getInsProduct().size()){ - delRSet.add(jo1.get("r")+""); + if (count2 == a.getInsProduct().size()) { + delRSet.add(jo1.get("r") + ""); } } } @@ -302,7 +333,7 @@ } JSONObject v = JSON.parseObject(JSON.toJSONString(jo1.get("v"))); InsProduct p = pMap.get(jo1.get("r") + ""); - if (p!=null && v.get("ps") != null) { + if (p != null && v.get("ps") != null) { String value = JSON.parseObject(JSON.toJSONString(v.get("ps"))).get("value") + ""; if (value.equals("瑕佹眰鍊�")) { textRenderData.setText(p.getAsk()); @@ -337,7 +368,7 @@ } else { textRenderData.setText(v.get("v") == null ? "" : v.get("v") + ""); } - } else if (p==null && v.get("ps") != null) { + } else if (p == null && v.get("ps") != null) { String value = JSON.parseObject(JSON.toJSONString(v.get("ps"))).get("value") + ""; p = pMap.get(pMap.keySet().iterator().next()); if (value.equals("鏈�缁堝��")) { @@ -414,11 +445,23 @@ for (String s : standardMethod) { standardMethod2.append("銆�").append(s); } - standardMethod2.replace(0, 1,""); - tables.forEach(table->{ + standardMethod2.replace(0, 1, ""); + tables.forEach(table -> { table.put("tableSize", tables.size() + 1); }); List<Map<String, String>> deviceList = insOrderMapper.selectDeviceList(deviceSet); + Map<String, String> codeStr = new HashMap<>(); + codeStr.put("鎶ュ憡缂栧彿", insReport.getCode()); + codeStr.put("鏍峰搧鍚嶇О", insOrder.getSample()); + codeStr.put("瑙勬牸鍨嬪彿", samples.get(0).getModel()); + codeStr.put("鍙戞斁鏃ユ湡", LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))); + String codePath; + try { + codePath = new MatrixToImageWriter().code(JackSonUtil.marshal(codeStr).replaceAll("\\{", "") + .replaceAll("}", "").replaceAll(",", "").replaceAll("\"", ""), twoCode); + } catch (Exception e) { + throw new RuntimeException(e); + } ConfigureBuilder builder = Configure.builder(); builder.useSpringEL(true); XWPFTemplate template = XWPFTemplate.compile(url, builder.build()).render( @@ -432,12 +475,15 @@ put("tableSize", tables.size() + 1); put("standardMethod", standardMethod2); put("deviceList", deviceList); + put("twoCode", Pictures.ofLocal(codePath).create()); }}); try { - String name = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yy_MM_dd_HH_mm_ss")) + ".docx"; + String name = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yy_MM_dd&HH_mm_ss")) + ".docx"; template.writeAndClose(Files.newOutputStream(Paths.get(wordUrl + "/" + name))); insReport.setUrl("/word/" + name); insReportMapper.insert(insReport); + insOrder.setState(4); + insOrderMapper.updateById(insOrder); } catch (IOException e) { throw new RuntimeException(e); } @@ -459,33 +505,10 @@ JSONObject sheet = JSON.parseObject(JSON.toJSONString(JSON.parseArray(JSON.toJSONString(JSON.parseObject(thing).get("data"))).get(0))); JSONObject config = JSON.parseObject(JSON.toJSONString(sheet.get("config"))); List<JSONObject> cellData = JSON.parseArray(JSON.toJSONString(sheet.get("celldata")), JSONObject.class); - List<JSONObject> tableData = new ArrayList<>(); Map<String, Object> style = new HashMap<>(); style.put("rowlen", config.get("rowlen")); style.put("columnlen", config.get("columnlen")); - int r = -1; - if (BeanUtil.isNotEmpty(cellData)) { - for (JSONObject o : cellData) { - JSONObject v = JSON.parseObject(JSON.toJSONString(o.get("v"))); - if (BeanUtil.isNotEmpty(v.get("ps"))) { - JSONObject ps = JSON.parseObject(JSON.toJSONString(v.get("ps"))); - if (ps.get("value").equals("妫�楠岄」") && v.get("v").equals(product.getInspectionItem())) { - tableData.add(o); - r = Integer.parseInt(o.get("r") + ""); - continue; - } - } - if (tableData.size() > 0) { - if ((Integer.parseInt(o.get("r") + "") == r + 1 || Integer.parseInt(o.get("r") + "") == r) && !(o.get("v") + "").equals("{\"ht\":\"0\"}")) { - r = Integer.parseInt(o.get("r") + ""); - tableData.add(o); - } else { - break; - } - } - } - } - product.setTemplate(tableData); + product.setTemplate(cellData); product.setStyle(style); } } @@ -495,9 +518,13 @@ public int submitPlan(Integer orderId, String laboratory) { List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId)); List<Integer> ids = insSamples.stream().map(a -> a.getId()).collect(Collectors.toList()); - List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, ids).eq(InsProduct::getSonLaboratory, laboratory).isNotNull(InsProduct::getInsResult)); - if (insProducts.size() == 0) { - return 0; + List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, ids).eq(InsProduct::getSonLaboratory, laboratory).eq(InsProduct::getState, 1).isNull(InsProduct::getInsResult)); + if (insProducts.size() > 0) { + String str = ""; + for (InsProduct product : insProducts) { + str += product.getInspectionItem()+product.getInspectionItemSubclass()+"锛�"; + } + throw new ErrorException("浠ヤ笅鏄湭妫�楠岀殑椤圭洰锛�"+str); } insOrderStateMapper.update(null, Wrappers.<InsOrderState>lambdaUpdate().eq(InsOrderState::getInsOrderId, orderId).eq(InsOrderState::getLaboratory, laboratory).set(InsOrderState::getInsTime, LocalDateTime.now()).set(InsOrderState::getInsState, 3)); return 1; -- Gitblit v1.9.3