From 31f3dcc7c566174cbdec4f41a9a96e58a1be9a4e Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期二, 17 十二月 2024 16:20:12 +0800 Subject: [PATCH] 统计2.0+首页2.0+检验下单型号过滤修改 --- inspect-server/src/main/java/com/yuanchu/mom/utils/WordUtils.java | 76 ++++++++++++++++++++------------------ 1 files changed, 40 insertions(+), 36 deletions(-) diff --git a/inspect-server/src/main/java/com/yuanchu/mom/utils/WordUtils.java b/inspect-server/src/main/java/com/yuanchu/mom/utils/WordUtils.java index 8924bde..0eebbe8 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/utils/WordUtils.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/utils/WordUtils.java @@ -106,6 +106,7 @@ InsSample insSample = insSampleMapper.selectById(insOrderState.getInsSampleId()); //鏌ヨ椤圭洰 List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery() + .eq(InsProduct::getState,1) .eq(InsProduct::getInsSampleId, insSample.getId()) .eq(InsProduct::getSonLaboratory, "鐢佃矾璇曢獙")); //鑾峰彇鏈�澶х鍙f暟閲�,瑙掑害鏁伴噺,棰戞鏁伴噺 @@ -117,7 +118,8 @@ frequencys.forEach(s -> { int ports = 0;//绔彛鏁� int angles = 0;//瑙掑害鏁� - for (InsProductResult2 insProductResult2 : insProductResult2s) { + List<InsProductResult2> productResult2s = insProductResult2s.stream().filter(insProductResult2 -> insProductResult2.getFrequency().equals(s)).collect(Collectors.toList()); + for (InsProductResult2 insProductResult2 : productResult2s) { if (insProductMapper.selectById(insProductResult2.getInsProductId()).getInspectionItemSubclass().equals("鐢靛帇椹绘尝姣�") && insProductResult2.getPort().split(",").length > ports) { ports = insProductResult2.getPort().split(",").length; } @@ -126,7 +128,7 @@ } } //棰戠偣鏁� - long often = insProductResult2s.stream().filter(insProductResult2 -> insProductResult2.getFrequency().equals(s)) + long often = productResult2s.stream().filter(insProductResult2 -> insProductResult2.getFrequency().equals(s)) .filter(insProductResult2 -> insProductMapper.selectById(insProductResult2.getInsProductId()).getInspectionItemSubclass().equals("浜掕皟") ).filter(insProductResult2 -> ObjectUtils.isNotEmpty(insProductResult2.getOften())).distinct().count(); @@ -153,7 +155,7 @@ aa += (angles + 1) * portRow; } if (inspectionItemSubclass.contains("鍚屾瀬鍖栭殧绂诲害")) { - List<InsProductResult2> result2s = insProductResult2s.stream().filter(insProductResult2 -> + List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 -> insProductMapper.selectById(insProductResult2.getInsProductId()) .getInspectionItemSubclass().equals("鍚屾瀬鍖栭殧绂诲害") && insProductResult2.getFrequency().equals(s) ).collect(Collectors.toList()); @@ -161,7 +163,7 @@ aa += (angles + 1) * (length % (ports > 8 ? 4 : (ports + 1) / 2) == 0 ? length / (ports > 8 ? 4 : (ports + 1) / 2) : length / (ports > 8 ? 4 : (ports + 1) / 2) + 1); } if (inspectionItemSubclass.contains("寮傛瀬鍖栭殧绂诲害")) { - List<InsProductResult2> result2s = insProductResult2s.stream().filter(insProductResult2 -> + List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 -> insProductMapper.selectById(insProductResult2.getInsProductId()) .getInspectionItemSubclass().equals("寮傛瀬鍖栭殧绂诲害") && insProductResult2.getFrequency().equals(s) ).collect(Collectors.toList()); @@ -178,7 +180,7 @@ aa += (angles + 1); } if (inspectionItemSubclass.contains("骞呭害鍋忓樊")) { - List<InsProductResult2> result2s = insProductResult2s.stream().filter(insProductResult2 -> + List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 -> insProductMapper.selectById(insProductResult2.getInsProductId()) .getInspectionItemSubclass().equals("骞呭害鍋忓樊")&& insProductResult2.getFrequency().equals(s) ).collect(Collectors.toList()); @@ -186,7 +188,7 @@ aa += (angles + 1) * (length % 8 == 0 ? length / 8 : length / 8 + 1); } if (inspectionItemSubclass.contains("鏈�澶х浉浣嶅亸宸�")) { - List<InsProductResult2> result2s = insProductResult2s.stream().filter(insProductResult2 -> + List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 -> insProductMapper.selectById(insProductResult2.getInsProductId()) .getInspectionItemSubclass().equals("鏈�澶х浉浣嶅亸宸�")&& insProductResult2.getFrequency().equals(s) ).collect(Collectors.toList()); @@ -245,7 +247,7 @@ index.getAndIncrement(); } List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鐢靛帇椹绘尝姣�")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //鐢靛帇椹绘尝姣旀墍鍦ㄨ @@ -347,7 +349,7 @@ List<InsProduct> products = insProducts.stream() .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鍚屾瀬鍖栭殧绂诲害")) .collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //鍚屾瀬鍖栭殧绂诲害鎵�鍦ㄨ @@ -439,7 +441,7 @@ List<InsProduct> products = insProducts.stream() .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("寮傛瀬鍖栭殧绂诲害")) .collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //寮傛瀬鍖栭殧绂诲害鎵�鍦ㄨ @@ -530,7 +532,7 @@ List<InsProduct> products = insProducts.stream() .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("浜掕皟")) .collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //浜掕皟鎵�鍦ㄨ @@ -623,7 +625,7 @@ index.getAndIncrement(); } List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鐢靛帇椹绘尝姣�")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //鐢靛帇椹绘尝姣旀墍鍦ㄨ @@ -720,7 +722,7 @@ } if (inspectionItemSubclass.contains("鍚屾瀬鍖栭殧绂诲害")) { List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鍚屾瀬鍖栭殧绂诲害")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); int length = result2s.get(0).getPort().split(",").length; @@ -843,7 +845,7 @@ } if (inspectionItemSubclass.contains("寮傛瀬鍖栭殧绂诲害")) { List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("寮傛瀬鍖栭殧绂诲害")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); int length = result2s.get(0).getPort().split(",").length; @@ -969,7 +971,7 @@ index.getAndIncrement(); } List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("浜掕皟")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //浜掕皟鎵�鍦ㄨ @@ -1066,7 +1068,7 @@ index.getAndIncrement(); } List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鏈�澶ц�﹀悎搴�")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //鏈�澶ц�﹀悎搴︽墍鍦ㄨ @@ -1159,7 +1161,7 @@ index.getAndIncrement(); } List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鏈�灏忚�﹀悎搴�")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //鏈�灏忚�﹀悎搴︽墍鍦ㄨ @@ -1248,7 +1250,7 @@ } if (inspectionItemSubclass.contains("骞呭害鍋忓樊")) { List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("骞呭害鍋忓樊")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); int length = result2s.get(0).getPort().split(",").length; @@ -1354,7 +1356,7 @@ } if (inspectionItemSubclass.contains("鏈�澶х浉浣嶅亸宸�")) { List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鏈�澶х浉浣嶅亸宸�")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); int length = result2s.get(0).getPort().split(",").length; @@ -2336,6 +2338,7 @@ //鏌ヨ椤圭洰 List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery() + .eq(InsProduct::getState,1) .eq(InsProduct::getInsSampleId, insSample.getId()) .eq(InsProduct::getSonLaboratory, "鐢佃矾璇曢獙")); //鑾峰彇鏈�澶х鍙f暟閲�,瑙掑害鏁伴噺,棰戞鏁伴噺 @@ -2347,7 +2350,8 @@ frequencys.forEach(s -> { int ports = 0;//绔彛鏁� int angles = 0;//瑙掑害鏁� - for (InsProductResult2 insProductResult2 : insProductResult2s) { + List<InsProductResult2> productResult2s = insProductResult2s.stream().filter(insProductResult2 -> insProductResult2.getFrequency().equals(s)).collect(Collectors.toList()); + for (InsProductResult2 insProductResult2 : productResult2s) { if (insProductMapper.selectById(insProductResult2.getInsProductId()).getInspectionItemSubclass().equals("鐢靛帇椹绘尝姣�") && insProductResult2.getPort().split(",").length > ports) { ports = insProductResult2.getPort().split(",").length; } @@ -2356,7 +2360,7 @@ } } //棰戠偣鏁� - long often = insProductResult2s.stream().filter(insProductResult2 -> insProductResult2.getFrequency().equals(s)) + long often = productResult2s.stream().filter(insProductResult2 -> insProductResult2.getFrequency().equals(s)) .filter(insProductResult2 -> insProductMapper.selectById(insProductResult2.getInsProductId()).getInspectionItemSubclass().equals("浜掕皟") ).filter(insProductResult2 -> ObjectUtils.isNotEmpty(insProductResult2.getOften())).distinct().count(); @@ -2383,7 +2387,7 @@ aa += (angles + 1) * portRow; } if (inspectionItemSubclass.contains("鍚屾瀬鍖栭殧绂诲害")) { - List<InsProductResult2> result2s = insProductResult2s.stream().filter(insProductResult2 -> + List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 -> insProductMapper.selectById(insProductResult2.getInsProductId()) .getInspectionItemSubclass().equals("鍚屾瀬鍖栭殧绂诲害")&& insProductResult2.getFrequency().equals(s) ).collect(Collectors.toList()); @@ -2391,7 +2395,7 @@ aa += (angles + 1) * (length % (ports > 8 ? 4 : (ports + 1) / 2) == 0 ? length / (ports > 8 ? 4 : (ports + 1) / 2) : length / (ports > 8 ? 4 : (ports + 1) / 2) + 1); } if (inspectionItemSubclass.contains("寮傛瀬鍖栭殧绂诲害")) { - List<InsProductResult2> result2s = insProductResult2s.stream().filter(insProductResult2 -> + List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 -> insProductMapper.selectById(insProductResult2.getInsProductId()) .getInspectionItemSubclass().equals("寮傛瀬鍖栭殧绂诲害")&& insProductResult2.getFrequency().equals(s) ).collect(Collectors.toList()); @@ -2408,7 +2412,7 @@ aa += (angles + 1); } if (inspectionItemSubclass.contains("骞呭害鍋忓樊")) { - List<InsProductResult2> result2s = insProductResult2s.stream().filter(insProductResult2 -> + List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 -> insProductMapper.selectById(insProductResult2.getInsProductId()) .getInspectionItemSubclass().equals("骞呭害鍋忓樊")&& insProductResult2.getFrequency().equals(s) ).collect(Collectors.toList()); @@ -2416,7 +2420,7 @@ aa += (angles + 1) * (length % 8 == 0 ? length / 8 : length / 8 + 1); } if (inspectionItemSubclass.contains("鏈�澶х浉浣嶅亸宸�")) { - List<InsProductResult2> result2s = insProductResult2s.stream().filter(insProductResult2 -> + List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 -> insProductMapper.selectById(insProductResult2.getInsProductId()) .getInspectionItemSubclass().equals("鏈�澶х浉浣嶅亸宸�")&& insProductResult2.getFrequency().equals(s) ).collect(Collectors.toList()); @@ -2475,7 +2479,7 @@ index.getAndIncrement(); } List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鐢靛帇椹绘尝姣�")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //鐢靛帇椹绘尝姣旀墍鍦ㄨ @@ -2577,7 +2581,7 @@ List<InsProduct> products = insProducts.stream() .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鍚屾瀬鍖栭殧绂诲害")) .collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //鍚屾瀬鍖栭殧绂诲害鎵�鍦ㄨ @@ -2669,7 +2673,7 @@ List<InsProduct> products = insProducts.stream() .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("寮傛瀬鍖栭殧绂诲害")) .collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //寮傛瀬鍖栭殧绂诲害鎵�鍦ㄨ @@ -2760,7 +2764,7 @@ List<InsProduct> products = insProducts.stream() .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("浜掕皟")) .collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //浜掕皟鎵�鍦ㄨ @@ -2853,7 +2857,7 @@ index.getAndIncrement(); } List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鐢靛帇椹绘尝姣�")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //鐢靛帇椹绘尝姣旀墍鍦ㄨ @@ -2950,7 +2954,7 @@ } if (inspectionItemSubclass.contains("鍚屾瀬鍖栭殧绂诲害")) { List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鍚屾瀬鍖栭殧绂诲害")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); int length = result2s.get(0).getPort().split(",").length; @@ -3073,7 +3077,7 @@ } if (inspectionItemSubclass.contains("寮傛瀬鍖栭殧绂诲害")) { List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("寮傛瀬鍖栭殧绂诲害")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); int length = result2s.get(0).getPort().split(",").length; @@ -3199,7 +3203,7 @@ index.getAndIncrement(); } List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("浜掕皟")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //浜掕皟鎵�鍦ㄨ @@ -3296,7 +3300,7 @@ index.getAndIncrement(); } List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鏈�澶ц�﹀悎搴�")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //鏈�澶ц�﹀悎搴︽墍鍦ㄨ @@ -3389,7 +3393,7 @@ index.getAndIncrement(); } List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鏈�灏忚�﹀悎搴�")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); //鏈�灏忚�﹀悎搴︽墍鍦ㄨ @@ -3478,7 +3482,7 @@ } if (inspectionItemSubclass.contains("骞呭害鍋忓樊")) { List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("骞呭害鍋忓樊")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); int length = result2s.get(0).getPort().split(",").length; @@ -3584,7 +3588,7 @@ } if (inspectionItemSubclass.contains("鏈�澶х浉浣嶅亸宸�")) { List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鏈�澶х浉浣嶅亸宸�")).collect(Collectors.toList()); - List<InsProductResult2> result2s = insProductResult2s.stream() + List<InsProductResult2> result2s = productResult2s.stream() .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId())) .collect(Collectors.toList()); int length = result2s.get(0).getPort().split(",").length; -- Gitblit v1.9.3