From fcfbaa84f1fef87a958452ef83d82e140d8ddb59 Mon Sep 17 00:00:00 2001 From: Crunchy <3114200645@qq.com> Date: 星期三, 03 七月 2024 17:58:09 +0800 Subject: [PATCH] 2024-7-3 检验对象导入 40% --- inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java | 78 ++++++++++++++++++++++++++++---------- 1 files changed, 57 insertions(+), 21 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 3c96fb3..1944a41 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 @@ -25,9 +25,7 @@ import com.deepoove.poi.xwpf.WidthScalePattern; import com.yuanchu.mom.common.GetLook; import com.yuanchu.mom.common.PrintChina; -import com.yuanchu.mom.dto.ExcelDto; -import com.yuanchu.mom.dto.InsOrderPlanDTO; -import com.yuanchu.mom.dto.SampleProductDto; +import com.yuanchu.mom.dto.*; import com.yuanchu.mom.exception.ErrorException; import com.yuanchu.mom.mapper.*; import com.yuanchu.mom.pojo.*; @@ -118,7 +116,13 @@ private InsBushingService insBushingService; @Resource + private InsBushingMapper insBushingMapper; + + @Resource private InsFiberMapper insFiberMapper; + + @Resource + private InsFibersMapper insFibersMapper; @Resource private InsOrderFileMapper insOrderFileMapper; @@ -175,11 +179,8 @@ Map<String, Object> map = insOrderService.getInsOrderAndSample(id, laboratory); List<SampleProductDto> list = JSON.parseArray(JSON.toJSONString(map.get("sampleProduct")), SampleProductDto.class); for (SampleProductDto samples : list) { -// Set<Integer> set = new HashSet<>(); -// Map<Integer, String> map2 = new HashMap<>(); if (BeanUtil.isEmpty(samples.getInsProduct())) continue; samples.setBushing(insBushingService.selectBushingBySampleId(samples.getId())); -// getTemplateThing(set, map2, samples.getInsProduct()); } map.put("sampleProduct", list); return map; @@ -265,6 +266,37 @@ } } + //鍒囨崲璁板綍妯$増鏌ヨ妫�楠屽唴瀹� + @Override + public Map<String, Object> getReportModel(Integer sampleId) { + Map<String, Object> map = new HashMap<>(); + //List<Integer> insSampleIds = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId)).stream().map(InsSample::getId).collect(Collectors.toList()); + //鍏堟煡鍑哄绠� + List<InsBushing> insBushings = insBushingMapper.selectList(Wrappers.<InsBushing>lambdaQuery().eq(InsBushing::getInsSampleId, sampleId)); + List<InsFibers> fibers = new ArrayList<>(); + List<InsFiber> fiber = new ArrayList<>(); + for (InsBushing insBushing : insBushings) { + //鍐嶆煡璇㈠嚭鎵�鏈夌殑鍏夌氦甯� + List<InsFibers> insFibers = insFibersMapper.selectList(Wrappers.<InsFibers>lambdaQuery().eq(InsFibers::getInsBushingId, insBushing.getId())); + if (CollectionUtils.isNotEmpty(insFibers)) { + fibers.addAll(insFibers); + //鏌ュ嚭鍏夌氦甯︿笅鎵�鏈夌殑鍏夌氦 + List<InsFiber> fiberList = insFiberMapper.selectList(Wrappers.<InsFiber>lambdaQuery().in(InsFiber::getInsFibersId, insFibers.stream().map(InsFibers::getId).collect(Collectors.toList()))); + fiber.addAll(fiberList); + } else { + //濡傛灉濂楃涓嬫病鏈夊厜绾ゅ甫灏卞彧鏈夊厜绾や簡 + List<InsFiber> insFiberList = insFiberMapper.selectList(Wrappers.<InsFiber>lambdaQuery().eq(InsFiber::getInsBushingId, insBushing.getId())); + fiber.addAll(insFiberList); + } + } + map.put("鍏夌氦甯�",fibers); + map.put("鍏夌氦",fiber); + return map; + } + + + + @Override public void saveInsContext(Map<String, Object> insContext) { Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId"); @@ -273,9 +305,12 @@ JSONObject jo = JSON.parseObject(JSON.toJSONString(v)); InsProduct insProduct = new InsProduct(); insProduct.setId(Integer.parseInt(k)); - InsProductResult result = insProductResultMapper.selectOne(Wrappers.<InsProductResult>lambdaQuery().eq(InsProductResult::getInsProductId, insProduct.getId())); - if (BeanUtil.isEmpty(result)) { + List<InsProductResult> results = insProductResultMapper.selectList(Wrappers.<InsProductResult>lambdaQuery().eq(InsProductResult::getInsProductId, insProduct.getId())); + InsProductResult result; + if (CollectionUtils.isEmpty(results)) { result = new InsProductResult(); + } else { + result = results.get(0); } result.setInsProductId(Integer.parseInt(k)); if (jo.get("insValue") != null) { @@ -511,8 +546,9 @@ } templateSet.add(JSON.toJSONString(b.getTemplate())); } + AtomicInteger index = new AtomicInteger(); + Set<String> itemSet = new HashSet<>(); templateSet.forEach(tem -> { - AtomicInteger index = new AtomicInteger(); Set<Integer> set2 = new HashSet<>(); List<RowRenderData> rows = new ArrayList<>(); List<TextRenderData> text = new ArrayList<>(); @@ -635,7 +671,9 @@ break; } } else if (value.equals("搴忓彿")) { - index.getAndIncrement(); + if (itemSet.add(p.getInspectionItem())) { + index.getAndIncrement(); + } textRenderData.setText(index + ""); } else if (value.equals("璁$畻鍊�")) { JSONArray jsonArray = JSON.parseArray(p.getInsProductResult().getComValue()); @@ -651,14 +689,12 @@ } else if (value.equals("璇曢獙鏂规硶")) { textRenderData.setText(p.getMethodS()); } else if (value.equals("妫�楠岄」")) { - Console.log(p.getInspectionItem() + "\n" + p.getInspectionItemEn()); - textRenderData.setText(p.getInspectionItem() + "\n" + p.getInspectionItemEn()); + textRenderData.setText(p.getInspectionItem() + "\r\n" + p.getInspectionItemEn()); } else if (value.equals("妫�楠屽瓙椤�")) { - Console.log(p.getInspectionItemSubclass() + "\n" + p.getInspectionItemSubclassEn()); if (ObjectUtils.isEmpty(p.getInspectionItemSubclassEn())) { textRenderData.setText(p.getInspectionItemSubclass()); } else { - textRenderData.setText(p.getInspectionItemSubclass() + "\n" + p.getInspectionItemSubclassEn()); + textRenderData.setText(p.getInspectionItemSubclass() + "\r\n" + p.getInspectionItemSubclassEn()); } } else { textRenderData.setText(v.get("v") == null ? "" : v.get("v") + ""); @@ -861,7 +897,7 @@ //绗竴琛� if (j == 0) { //绗竴鍒� - textRenderData.setText("绠¤壊鏍嘰nPipe鈭�100"); + textRenderData.setText("绠¤壊鏍嘰r\nPipe鈭�100"); renderData.add(textRenderData); paragraphRenderData.setContents(renderData); paragraphRenderDataList.add(paragraphRenderData); @@ -869,7 +905,7 @@ cells.add(cellRenderData); } else if (j == 1) { //绗簩鍒� - textRenderData.setText("鍏夌氦鑹叉爣\nScanning Number鈭�101"); + textRenderData.setText("鍏夌氦鑹叉爣\r\nScanning Number鈭�101"); renderData.add(textRenderData); paragraphRenderData.setContents(renderData); paragraphRenderDataList.add(paragraphRenderData); @@ -877,7 +913,7 @@ cells.add(cellRenderData); } else { //椤圭洰淇℃伅 - textRenderData.setText(insProducts1.get((int) (j - 2)).getInspectionItem() + "\n" + insProducts1.get((int) (j - 2)).getInspectionItemEn() + "鈭�" + (j + 101)); + textRenderData.setText(insProducts1.get((int) (j - 2)).getInspectionItem() + "\r\n" + insProducts1.get((int) (j - 2)).getInspectionItemEn() + "鈭�" + (j + 101)); renderData.add(textRenderData); paragraphRenderData.setContents(renderData); paragraphRenderDataList.add(paragraphRenderData); @@ -888,7 +924,7 @@ //鏈夌埗瀛愰」鐩叧绯荤殑绗笁琛� if (j == 0) { //绗竴鍒� - textRenderData.setText("绠¤壊鏍嘰nPipe鈭�100"); + textRenderData.setText("绠¤壊鏍嘰r\nPipe鈭�100"); renderData.add(textRenderData); paragraphRenderData.setContents(renderData); paragraphRenderDataList.add(paragraphRenderData); @@ -896,7 +932,7 @@ cells.add(cellRenderData); } else if (j == 1) { //绗簩鍒� - textRenderData.setText("鍏夌氦鑹叉爣\nScanning Number鈭�101"); + textRenderData.setText("鍏夌氦鑹叉爣\r\nScanning Number鈭�101"); renderData.add(textRenderData); paragraphRenderData.setContents(renderData); paragraphRenderDataList.add(paragraphRenderData); @@ -906,9 +942,9 @@ //椤圭洰淇℃伅 //鍒ゆ柇鏄惁鏈夐」鐩瓙绫� if (insProducts1.get((int) (j - 2)).getInspectionItemSubclass().equals("") || insProducts1.get((int) (j - 2)).getInspectionItemSubclass() == null) { - textRenderData.setText(insProducts1.get((int) (j - 2)).getInspectionItem() + "\n" + insProducts1.get((int) (j - 2)).getInspectionItemEn() + "鈭�" + (j + 101)); + textRenderData.setText(insProducts1.get((int) (j - 2)).getInspectionItem() + "\r\n" + insProducts1.get((int) (j - 2)).getInspectionItemEn() + "鈭�" + (j + 101)); } else { - textRenderData.setText(insProducts1.get((int) (j - 2)).getInspectionItemSubclass() + "\n\n" + insProducts1.get((int) (j - 2)).getInspectionItemSubclassEn()); + textRenderData.setText(insProducts1.get((int) (j - 2)).getInspectionItemSubclass() + "\r\n" + insProducts1.get((int) (j - 2)).getInspectionItemSubclassEn()); } renderData.add(textRenderData); paragraphRenderData.setContents(renderData); -- Gitblit v1.9.3