From e22d3ca089ad03cc33a7b5f440a67415283f75d1 Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期二, 31 十二月 2024 15:18:51 +0800
Subject: [PATCH] 无源器件的报告

---
 inspect-server/src/main/java/com/yuanchu/mom/utils/WordUtils.java                      | 2126 ++++++++-----------------------------------------------
 inspect-server/src/main/java/com/yuanchu/mom/vo/InsProductResult2VO.java               |   29 
 inspect-server/src/main/java/com/yuanchu/mom/utils/DianLuUtils.java                    |   23 
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java |   24 
 inspect-server/src/main/resources/mapper/InsProductResult2Mapper.xml                   |   19 
 inspect-server/src/main/java/com/yuanchu/mom/mapper/InsProductResult2Mapper.java       |    2 
 inspect-server/src/main/resources/static/word2.docx                                    |    0 
 7 files changed, 401 insertions(+), 1,822 deletions(-)

diff --git a/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsProductResult2Mapper.java b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsProductResult2Mapper.java
index dcd9a6b..59c3fcc 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsProductResult2Mapper.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InsProductResult2Mapper.java
@@ -3,6 +3,7 @@
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.yuanchu.mom.pojo.InsProductResult;
 import com.yuanchu.mom.pojo.InsProductResult2;
+import com.yuanchu.mom.vo.InsProductResult2VO;
 import org.apache.ibatis.annotations.Param;
 
 import java.util.List;
@@ -16,6 +17,7 @@
 public interface InsProductResult2Mapper extends BaseMapper<InsProductResult2> {
     void saveBatch(@Param("result2s") List<InsProductResult2> result2s);
 
+    List<InsProductResult2VO> selectWordHang(@Param("num") Integer num, @Param("ids") List<Integer> ids);
 }
 
 
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 6a68419..3a32619 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
@@ -1192,17 +1192,21 @@
         insSampleUserMapper.insert(insSampleUser);
         /*鐢熸垚鐢佃矾璇曢獙鐨勭珯鐐规姤鍛婂苟涓婁紶鍒伴檮浠朵腑*/
         if (submitPlanDto.getLaboratory().equals("鐢佃矾璇曢獙")) {
-//            wordUtils.generateWord(submitPlanDto.getTerm(), orderState);
-            //todo 鐢佃矾绔欑偣鎶ュ憡 姝e紡搴撻儴缃叉斁寮�
-            try {
-                if (!insOrder.getSampleType().equals("鏃犳簮鍣ㄤ欢")) {
-                    wordUtils.generateWord(submitPlanDto.getTerm(), orderState);
-                }else {
-                    wordUtils.generateWord2(submitPlanDto.getTerm(), orderState);
-                }
-            } catch (Exception e) {
-                throw new ErrorException("鐢佃矾璇曢獙鐨勭珯鐐规姤鍛婄敓鎴愭湁璇�,璇疯仈绯诲紑鍙戜汉鍛樿皟鏁�!");
+            if (!insOrder.getSampleType().equals("鏃犳簮鍣ㄤ欢")) {
+                wordUtils.generateWord(submitPlanDto.getTerm(), orderState);
+            }else {
+                wordUtils.generateWord2(submitPlanDto.getTerm(), orderState);
             }
+            //todo 鐢佃矾绔欑偣鎶ュ憡 姝e紡搴撻儴缃叉斁寮�
+//            try {
+//                if (!insOrder.getSampleType().equals("鏃犳簮鍣ㄤ欢")) {
+//                    wordUtils.generateWord(submitPlanDto.getTerm(), orderState);
+//                }else {
+//                    wordUtils.generateWord2(submitPlanDto.getTerm(), orderState);
+//                }
+//            } catch (Exception e) {
+//                throw new ErrorException("鐢佃矾璇曢獙鐨勭珯鐐规姤鍛婄敓鎴愭湁璇�,璇疯仈绯诲紑鍙戜汉鍛樿皟鏁�!");
+//            }
         }
         /*鐢熸垚浜ч噺宸ユ椂*/
         //鏍¢獙濡傛灉杩欎釜浜鸿繖涓娴嬮」鐩凡缁忔坊鍔犺繃浜嗗垯涓嶉渶瑕佸啀鏂板
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/utils/DianLuUtils.java b/inspect-server/src/main/java/com/yuanchu/mom/utils/DianLuUtils.java
index ea0419d..35d5e7f 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/utils/DianLuUtils.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/utils/DianLuUtils.java
@@ -340,6 +340,7 @@
                 result2.setValue("[[" + value + "]]");
                 result2.setAngle("0掳");
                 result2.setOften(entry.getValue().stream().map(InsProductResult2::getOften).collect(Collectors.joining(",")));
+                result2.setNum(orderStates.get(0).getNum());
                 filteredList.add(result2);
             }
         }
@@ -385,7 +386,6 @@
                     }
                     insProductResult2.setInsProductId(products1.get(0).getId());//鐢靛帇椹绘尝姣�
                     insProductResult2.setFrequency(listEntry.getKey());//棰戞
-                    insProductResult2.setAngle("0掳");//瑙掑害
                     insProductResult2.setNum(orderStates.get(0).getNum());//娆℃暟
                     //鑾峰彇绔彛
                     String port = entry.getValue().stream().map(TianXianData::getPort).collect(Collectors.joining(","));
@@ -401,7 +401,6 @@
                     }
                     insProductResult2.setInsProductId(products2.get(0).getId());//鏃犳簮鍣ㄤ欢闅旂搴�
                     insProductResult2.setFrequency(listEntry.getKey());//棰戞
-                    insProductResult2.setAngle("0掳");//瑙掑害
                     insProductResult2.setNum(orderStates.get(0).getNum());//娆℃暟
                     //鑾峰彇绔彛
                     String port = entry.getValue().stream().map(TianXianData::getPort).collect(Collectors.joining(","));
@@ -417,7 +416,6 @@
                     }
                     insProductResult2.setInsProductId(products3.get(0).getId());//鎻掑叆鎹熻��
                     insProductResult2.setFrequency(listEntry.getKey());//棰戞
-                    insProductResult2.setAngle("0掳");//瑙掑害
                     insProductResult2.setNum(orderStates.get(0).getNum());//娆℃暟
                     //鑾峰彇绔彛
                     String port = entry.getValue().stream().map(TianXianData::getPort).collect(Collectors.joining(","));
@@ -433,7 +431,6 @@
                     }
                     insProductResult2.setInsProductId(products4.get(0).getId());//甯﹀唴娉㈠姩
                     insProductResult2.setFrequency(listEntry.getKey());//棰戞
-                    insProductResult2.setAngle("0掳");//瑙掑害
                     insProductResult2.setNum(orderStates.get(0).getNum());//娆℃暟
                     //鑾峰彇绔彛
                     String port = entry.getValue().stream().map(TianXianData::getPort).collect(Collectors.joining(","));
@@ -449,7 +446,6 @@
                     }
                     insProductResult2.setInsProductId(products5.get(0).getId());//甯﹀鎶戝埗
                     insProductResult2.setFrequency(listEntry.getKey());//棰戞
-                    insProductResult2.setAngle("0掳");//瑙掑害
                     insProductResult2.setNum(orderStates.get(0).getNum());//娆℃暟
                     //鑾峰彇绔彛
                     String port = entry.getValue().stream().map(TianXianData::getPort).collect(Collectors.joining(","));
@@ -463,14 +459,12 @@
                     if (products6.size() <= 0 || products7.size()<=0) {
                         throw new ErrorException("鑰﹀悎搴﹂」鐩湭鎵惧埌");
                     }
+                    /*鏈�澶ц�﹀悎搴�*/
                     insProductResult2.setFrequency(listEntry.getKey());//棰戞
-                    insProductResult2.setAngle("0掳");//瑙掑害
                     insProductResult2.setNum(orderStates.get(0).getNum());//娆℃暟
                     //鑾峰彇绔彛
                     String port = entry.getValue().stream().map(TianXianData::getPort).collect(Collectors.joining(","));
                     insProductResult2.setPort(port);//绔彛
-
-                    /*鏈�澶ц�﹀悎搴�*/
                     insProductResult2.setInsProductId(products6.get(0).getId());//鏈�澶ц�﹀悎搴�
                     //鑾峰彇妫�楠屽��
                     String value = entry.getValue().stream().map(tianXianData1 -> {
@@ -480,13 +474,18 @@
                     insProductResult2.setValue("[[" + value + "]]");//鍊�
                     insProductResult2s.add(insProductResult2);
                     /*鏈�灏忚�﹀悎搴�*/
-                    insProductResult2.setInsProductId(products7.get(0).getId());//鏈�灏忚�﹀悎搴�
+                    InsProductResult2 insProductResult22 = new InsProductResult2();
+                    insProductResult22.setFrequency(listEntry.getKey());//棰戞
+                    insProductResult22.setNum(orderStates.get(0).getNum());//娆℃暟
+                    //鑾峰彇绔彛
+                    insProductResult22.setPort(port);//绔彛
+                    insProductResult22.setInsProductId(products7.get(0).getId());//鏈�灏忚�﹀悎搴�
                     String value1 = entry.getValue().stream().map(tianXianData1 -> {
                         String input = tianXianData1.getValue().replace("[", "").replace("]", "");
                         String[] parts = input.split("--");
                         return "\"" +parts[0] + "\"" ; }).collect(Collectors.joining(","));
-                    insProductResult2.setValue("[[" + value1 + "]]");//鍊�
-                    insProductResult2s.add(insProductResult2);
+                    insProductResult22.setValue("[[" + value1 + "]]");//鍊�
+                    insProductResult2s.add(insProductResult22);
                 }
             }
         }
@@ -508,8 +507,8 @@
                     return insProductResult2.getValue().replace("[[", "").replace("]]", "");
                 }).collect(Collectors.joining(","));
                 result2.setValue("[[" + value + "]]");
-                result2.setAngle("0掳");
                 result2.setOften(entry.getValue().stream().map(InsProductResult2::getOften).collect(Collectors.joining(",")));
+                result2.setNum(orderStates.get(0).getNum());
                 filteredList.add(result2);
             }
         }
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 a95bf24..e698902 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
@@ -18,6 +18,7 @@
 import com.yuanchu.mom.exception.ErrorException;
 import com.yuanchu.mom.mapper.*;
 import com.yuanchu.mom.pojo.*;
+import com.yuanchu.mom.vo.InsProductResult2VO;
 import org.apache.commons.io.IOUtils;
 import org.apache.poi.openxml4j.util.ZipSecureFile;
 import org.apache.poi.xwpf.usermodel.*;
@@ -25,6 +26,7 @@
 import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTTcPr;
 import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTVMerge;
 import org.openxmlformats.schemas.wordprocessingml.x2006.main.STMerge;
+import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.stereotype.Component;
 
@@ -2052,7 +2054,6 @@
 
     //鐢熸垚绔欑偣鐢佃矾璇曢獙鎶ュ憡(鏃犳簮鍣ㄤ欢)
     public void generateWord2(String term, InsOrderState insOrderState) {
-        AtomicInteger lable = new AtomicInteger(1);
         AtomicInteger index = new AtomicInteger();
         String title = term + "鐢佃矾鍙傛暟";
         List<Map<String, Object>> tables = new ArrayList<>();
@@ -2065,136 +2066,43 @@
                 .eq(InsProduct::getState,1)
                 .eq(InsProduct::getInsSampleId, insSample.getId())
                 .eq(InsProduct::getSonLaboratory, "鐢佃矾璇曢獙"));
-        //鑾峰彇鏈�澶х鍙f暟閲�,瑙掑害鏁伴噺,棰戞鏁伴噺
-        List<InsProductResult2> insProductResult2s = insProductResult2Mapper.selectList(Wrappers.<InsProductResult2>lambdaQuery()
-                .eq(InsProductResult2::getNum, insOrderState.getNum())
-                .in(InsProductResult2::getInsProductId, insProducts.stream().map(InsProduct::getId).collect(Collectors.toList())));
-        //鎸夌収棰戞鍒嗚〃(鏌ヨ鎵�鏈夐娈�)
-        List<String> frequencys = insProductResult2s.stream().map(InsProductResult2::getFrequency).distinct().collect(Collectors.toList());
-        frequencys.forEach(s -> {
-            int ports = 0;//绔彛鏁�
-            int angles = 0;//瑙掑害鏁�
-            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;
-                }
-                if (insProductResult2.getAngle().split(",").length > angles) {
-                    angles = insProductResult2.getAngle().split(",").length;
+        //璁$畻琛屾暟
+        List<InsProductResult2VO> result2VOS = new ArrayList<>();
+        List<InsProductResult2VO> insProductResult2VOS = insProductResult2Mapper.selectWordHang(insOrderState.getNum(), insProducts.stream().map(InsProduct::getId).collect(Collectors.toList()));
+        for (InsProductResult2VO insProductResult2VO : insProductResult2VOS) {
+            String[] split = insProductResult2VO.getPort().split(",");
+            String value = insProductResult2VO.getValue().replace("[[", "").replace("]]", "");
+            if (split.length>1){
+                for (int i = 0; i < split.length; i++) {
+                    InsProductResult2VO insProductResult2VO1 = new InsProductResult2VO();
+                    BeanUtils.copyProperties(insProductResult2VO,insProductResult2VO1);
+                    //绔彛
+                    insProductResult2VO1.setPort(split[i]);
+                    //鍊�
+                    try{
+                        insProductResult2VO1.setValue(value.split(",")[i].replace("\"",""));
+                    }catch (Exception e){
+                        insProductResult2VO1.setValue("");
+                    }
+                    result2VOS.add(insProductResult2VO1);
                 }
             }
-            //棰戠偣鏁�
-            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();
-            List<String> inspectionItemSubclass = insProducts.stream().map(InsProduct::getInspectionItemSubclass).collect(Collectors.toList());
-            //琛屾暟
-            int aa = 0;
-            int portRow = ports % 8 == 0 ? ports / 8 : ports / 8 + 1;
-            //鍏堝垽鏂槸1绠�鍗曠増杩樻槸0澶嶆潅鐗�
-            if (insOrderState.getVersion() == 1) {
-                if (inspectionItemSubclass.contains("鐢靛帇椹绘尝姣�")) {
-                    aa += 2 * portRow;
-                }
-                if (inspectionItemSubclass.contains("鍚屾瀬鍖栭殧绂诲害")) {
-                    aa += 1 * portRow;
-                }
-                if (inspectionItemSubclass.contains("鍚屽垪闅旂搴�")) {
-                    aa += 1 * portRow;
-                }
-                if (inspectionItemSubclass.contains("绔彛闂撮殧绂诲害")) {
-                    aa += 1 * portRow;
-                }
-                if (inspectionItemSubclass.contains("寮傛瀬鍖栭殧绂诲害")) {
-                    aa += 1 * portRow;
-                }
-                if (inspectionItemSubclass.contains("浜掕皟")) {
-                    aa += (angles + 1) * portRow * often;
-                }
-            } else {
-                if (inspectionItemSubclass.contains("鐢靛帇椹绘尝姣�")) {
-                    aa += (angles + 1) * portRow;
-                }
-                if (inspectionItemSubclass.contains("鍚屾瀬鍖栭殧绂诲害")) {
-                    List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 ->
-                            insProductMapper.selectById(insProductResult2.getInsProductId())
-                                    .getInspectionItemSubclass().equals("鍚屾瀬鍖栭殧绂诲害") && insProductResult2.getFrequency().equals(s)
-                    ).collect(Collectors.toList());
-                    int length = result2s.get(0).getPort().split(",").length;
-                    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 = productResult2s.stream().filter(insProductResult2 ->
-                            insProductMapper.selectById(insProductResult2.getInsProductId())
-                                    .getInspectionItemSubclass().equals("鍚屽垪闅旂搴�") && insProductResult2.getFrequency().equals(s)
-                    ).collect(Collectors.toList());
-                    int length = result2s.get(0).getPort().split(",").length;
-                    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 = productResult2s.stream().filter(insProductResult2 ->
-                            insProductMapper.selectById(insProductResult2.getInsProductId())
-                                    .getInspectionItemSubclass().equals("绔彛闂撮殧绂诲害") && insProductResult2.getFrequency().equals(s)
-                    ).collect(Collectors.toList());
-                    int length = result2s.get(0).getPort().split(",").length;
-                    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 = productResult2s.stream().filter(insProductResult2 ->
-                            insProductMapper.selectById(insProductResult2.getInsProductId())
-                                    .getInspectionItemSubclass().equals("寮傛瀬鍖栭殧绂诲害") && insProductResult2.getFrequency().equals(s)
-                    ).collect(Collectors.toList());
-                    int length = result2s.get(0).getPort().split(",").length;
-                    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("浜掕皟")) {
-                    aa += (angles + 1) * portRow * often;
-                }
-                if (inspectionItemSubclass.contains("鏈�澶ц�﹀悎搴�")) {
-                    aa += (angles + 1);
-                }
-                if (inspectionItemSubclass.contains("鏈�灏忚�﹀悎搴�")) {
-                    aa += (angles + 1);
-                }
-                if (inspectionItemSubclass.contains("骞呭害鍋忓樊")) {
-                    List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 ->
-                            insProductMapper.selectById(insProductResult2.getInsProductId())
-                                    .getInspectionItemSubclass().equals("骞呭害鍋忓樊")&& insProductResult2.getFrequency().equals(s)
-                    ).collect(Collectors.toList());
-                    int length = result2s.get(0).getPort().split(",").length;
-                    aa += (angles + 1) * (length % 8 == 0 ? length / 8 : length / 8 + 1);
-                }
-                if (inspectionItemSubclass.contains("鏈�澶х浉浣嶅亸宸�")) {
-                    List<InsProductResult2> result2s = productResult2s.stream().filter(insProductResult2 ->
-                            insProductMapper.selectById(insProductResult2.getInsProductId())
-                                    .getInspectionItemSubclass().equals("鏈�澶х浉浣嶅亸宸�")&& insProductResult2.getFrequency().equals(s)
-                    ).collect(Collectors.toList());
-                    int length = result2s.get(0).getPort().split(",").length;
-                    aa += (angles + 1) * (length % 8 == 0 ? length / 8 : length / 8 + 1);
-                }
+            else {
+                insProductResult2VO.setValue(value.replace("\"",""));
+                result2VOS.add(insProductResult2VO);
             }
-            List<RowRenderData> rows = new ArrayList<>();
-            Set<String> itemSet = new HashSet<>();
-            int cc = 0;
-            int dd = 0;
-            int ee = 0;
-            int ff = 0;
-            int gg = 0;
-            int hh = 0;
-            int mm = 0;
-            int nn = 0;
-            int pp = 0;
-            //琛ㄦ牸鐨勮鏁�
-            for (int i = 0; i <= aa; i++) {
+        }
+        List<RowRenderData> rows = new ArrayList<>();
+        Set<String> itemSet = new HashSet<>();
+        //琛ㄦ牸鐨勮鏁�
+        for (int i = 0; i < result2VOS.size(); i++) {
                 RowRenderData rowRenderData = new RowRenderData();
                 RowStyle rowStyle = new RowStyle();
                 rowStyle.setHeight(40);
                 rowRenderData.setRowStyle(rowStyle);
                 List<CellRenderData> cells = new ArrayList<>();
                 //琛ㄦ牸鐨勫垪鏁�
-                int bb = ports > 8 ? 14 : ports + 6;
-                for (int j = 0; j < bb; j++) {
+                for (int j = 0; j < 8; j++) {
                     CellRenderData cellRenderData = new CellRenderData();
                     CellStyle cellStyle = new CellStyle();
                     cellStyle.setVertAlign(XWPFTableCell.XWPFVertAlign.CENTER);
@@ -2210,1666 +2118,102 @@
                     style.setFontFamily("瀹嬩綋");
                     style.setColor("000000");
                     textRenderData.setStyle(style);
-                    if (i == 0) {
-                        //绗竴琛�
-                        textRenderData.setText("棰戞锛�" + s + "鈭�0" + lable);
+                    if (j==0){
+                        //绗竴鍒�(搴忓彿)
+                        if (itemSet.add(result2VOS.get(i).getInspectionItemSubclass())) {
+                            index.getAndIncrement();
+                        }
+                        textRenderData.setText(index + "鈭�1" + index);
                         renderData.add(textRenderData);
                         paragraphRenderData.setContents(renderData);
                         paragraphRenderDataList.add(paragraphRenderData);
                         cellRenderData.setParagraphs(paragraphRenderDataList);
                         cells.add(cellRenderData);
-                    } else {
-                        if (insOrderState.getVersion() == 1) {
-                            //闈炵數璋冪増鏈�(绠�鍗曠増)
-                            if (inspectionItemSubclass.contains("鐢靛帇椹绘尝姣�") && i <= 2 * portRow) {
-                                cc = 2 * portRow;
-                                if (itemSet.add("鐢靛帇椹绘尝姣�")) {
-                                    index.getAndIncrement();
-                                }
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鐢靛帇椹绘尝姣�")).collect(Collectors.toList());
-                                List<InsProductResult2> result2s = productResult2s.stream()
-                                        .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId()))
-                                        .collect(Collectors.toList());
-                                //鐢靛帇椹绘尝姣旀墍鍦ㄨ
-                                if (j == 0) {
-                                    //绗竴鍒�
-                                    textRenderData.setText(index + "鈭�1" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 1) {
-                                    //绗簩鍒�
-                                    textRenderData.setText("鐢靛帇椹绘尝姣斺垜2" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 2) {
-                                    //绗笁鍒�
-                                    textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 3) {
-                                    //绗洓鍒�
-                                    textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 4) {
-                                    //绗簲鍒�
-                                    if (i % 2 == 0) {
-                                        //鏈�宸��
-                                        textRenderData.setText("鏈�宸��");
-                                    } else {
-                                        //绔彛
-                                        textRenderData.setText("绔彛");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == bb - 1) {
-                                    //鏈�鍚庝竴鍒�
-                                    if (i % 2 == 0) {
-                                        //缁撹
-                                        if (products.get(0).getInsResult() == 1) {
-                                            textRenderData.setText("鍚堟牸");
-                                        } else if (products.get(0).getInsResult() == 0) {
-                                            textRenderData.setText("涓嶅悎鏍�");
-                                        } else {
-                                            textRenderData.setText("涓嶅垽瀹�");
-                                        }
-                                    } else {
-                                        textRenderData.setText("/");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else {
-                                    //鍏朵綑鍒�
-                                    if (i % 2 == 0) {
-                                        //鏈�宸��
-                                        String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", "");
-                                        try {
-                                            textRenderData.setText(value.split(",")[(j - 5) + (i - 1) / 2 * (Math.min(ports, 8))]);
-                                        } catch (Exception e) {
-                                            textRenderData.setText("");
-                                        }
-                                    } else {
-                                        //绔彛
-                                        try {
-                                            textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 5) + (i / 2) * (Math.min(ports, 8))]);
-                                        } catch (Exception e) {
-                                            textRenderData.setText("");
-                                        }
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("鍚屾瀬鍖栭殧绂诲害") && i > cc && i <= cc + portRow) {
-                                dd = cc + portRow;
-                                if (itemSet.add("鍚屾瀬鍖栭殧绂诲害")) {
-                                    index.getAndIncrement();
-                                }
-                                List<InsProduct> products = insProducts.stream()
-                                        .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鍚屾瀬鍖栭殧绂诲害"))
-                                        .collect(Collectors.toList());
-                                List<InsProductResult2> result2s = productResult2s.stream()
-                                        .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId()))
-                                        .collect(Collectors.toList());
-                                //鍚屾瀬鍖栭殧绂诲害鎵�鍦ㄨ
-                                if (j == 0) {
-                                    //绗竴鍒�
-                                    textRenderData.setText(index + "鈭�1" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 1) {
-                                    //绗簩鍒�
-                                    textRenderData.setText("鍚屾瀬鍖栭殧绂诲害鈭�2" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 2) {
-                                    //绗笁鍒�
-                                    textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 3) {
-                                    //绗洓鍒�
-                                    textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 4) {
-                                    //绗簲鍒�
-                                    textRenderData.setText("鏈�宸��");
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == bb - 1) {
-                                    //鏈�鍚庝竴鍒�
-                                    if (products.get(0).getInsResult() == 1) {
-                                        textRenderData.setText("鍚堟牸");
-                                    } else if (products.get(0).getInsResult() == 0) {
-                                        textRenderData.setText("涓嶅悎鏍�");
-                                    } else {
-                                        textRenderData.setText("涓嶅垽瀹�");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j % 2 == 0) {
-                                    String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", "");
-                                    try {
-                                        textRenderData.setText(value.split(",")[(j - 6) / 2 + (i - cc - 1) * 4] + "鈭�5" + i + (j - 6));
-                                    } catch (Exception e) {
-                                        textRenderData.setText("");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else {
-                                    String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", "");
-                                    try {
-                                        textRenderData.setText(value.split(",")[(j - 5) / 2 + (i - cc - 1) * 4] + "鈭�5" + i + (j - 5));
-                                    } catch (Exception e) {
-                                        textRenderData.setText("");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("鍚屽垪闅旂搴�") && i > (dd == 0 ? cc : dd) && i <= (dd == 0 ? cc : dd) + portRow) {
-                                ee = (dd == 0 ? cc : dd) + portRow;
-                                if (itemSet.add("鍚屽垪闅旂搴�")) {
-                                    index.getAndIncrement();
-                                }
-                                List<InsProduct> products = insProducts.stream()
-                                        .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鍚屽垪闅旂搴�"))
-                                        .collect(Collectors.toList());
-                                List<InsProductResult2> result2s = productResult2s.stream()
-                                        .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId()))
-                                        .collect(Collectors.toList());
-                                //闅旂搴︽墍鍦ㄨ
-                                if (j == 0) {
-                                    //绗竴鍒�
-                                    textRenderData.setText(index + "鈭�1" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 1) {
-                                    //绗簩鍒�
-                                    textRenderData.setText("闅旂搴︹垜2" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 2) {
-                                    //绗笁鍒�
-                                    textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 3) {
-                                    //绗洓鍒�
-                                    textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 4) {
-                                    //绗簲鍒�
-                                    textRenderData.setText("鏈�宸��");
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == bb - 1) {
-                                    //鏈�鍚庝竴鍒�
-                                    if (products.get(0).getInsResult() == 1) {
-                                        textRenderData.setText("鍚堟牸");
-                                    } else if (products.get(0).getInsResult() == 0) {
-                                        textRenderData.setText("涓嶅悎鏍�");
-                                    } else {
-                                        textRenderData.setText("涓嶅垽瀹�");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j % 2 == 0) {
-                                    String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", "");
-                                    try {
-                                        textRenderData.setText(value.split(",")[(j - 6) / 2 + (i - (dd == 0 ? cc : dd) - 1) * 4] + "鈭�5" + i + (j - 6));
-                                    } catch (Exception e) {
-                                        textRenderData.setText("");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else {
-                                    String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", "");
-                                    try {
-                                        textRenderData.setText(value.split(",")[(j - 5) / 2 + (i - (dd == 0 ? cc : dd) - 1) * 4] + "鈭�5" + i + (j - 5));
-                                    } catch (Exception e) {
-                                        textRenderData.setText("");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("绔彛闂撮殧绂诲害") && i > (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) && i <= (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) + portRow) {
-                                ff = (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) + portRow;
-                                if (itemSet.add("绔彛闂撮殧绂诲害")) {
-                                    index.getAndIncrement();
-                                }
-                                List<InsProduct> products = insProducts.stream()
-                                        .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("绔彛闂撮殧绂诲害"))
-                                        .collect(Collectors.toList());
-                                List<InsProductResult2> result2s = productResult2s.stream()
-                                        .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId()))
-                                        .collect(Collectors.toList());
-                                //鍚屾瀬鍖栭殧绂诲害鎵�鍦ㄨ
-                                if (j == 0) {
-                                    //绗竴鍒�
-                                    textRenderData.setText(index + "鈭�1" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 1) {
-                                    //绗簩鍒�
-                                    textRenderData.setText("鍚屾瀬鍖栭殧绂诲害鈭�2" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 2) {
-                                    //绗笁鍒�
-                                    textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 3) {
-                                    //绗洓鍒�
-                                    textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 4) {
-                                    //绗簲鍒�
-                                    textRenderData.setText("鏈�宸��");
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == bb - 1) {
-                                    //鏈�鍚庝竴鍒�
-                                    if (products.get(0).getInsResult() == 1) {
-                                        textRenderData.setText("鍚堟牸");
-                                    } else if (products.get(0).getInsResult() == 0) {
-                                        textRenderData.setText("涓嶅悎鏍�");
-                                    } else {
-                                        textRenderData.setText("涓嶅垽瀹�");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j % 2 == 0) {
-                                    String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", "");
-                                    try {
-                                        textRenderData.setText(value.split(",")[(j - 6) / 2 + (i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) - 1) * 4] + "鈭�5" + i + (j - 6));
-                                    } catch (Exception e) {
-                                        textRenderData.setText("");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else {
-                                    String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", "");
-                                    try {
-                                        textRenderData.setText(value.split(",")[(j - 5) / 2 + (i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) - 1) * 4] + "鈭�5" + i + (j - 5));
-                                    } catch (Exception e) {
-                                        textRenderData.setText("");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("寮傛瀬鍖栭殧绂诲害") && i >(ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)&& i <= (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) + portRow) {
-                                gg = (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) + portRow;
-                                if (itemSet.add("寮傛瀬鍖栭殧绂诲害")) {
-                                    index.getAndIncrement();
-                                }
-                                List<InsProduct> products = insProducts.stream()
-                                        .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("寮傛瀬鍖栭殧绂诲害"))
-                                        .collect(Collectors.toList());
-                                List<InsProductResult2> result2s = productResult2s.stream()
-                                        .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId()))
-                                        .collect(Collectors.toList());
-                                //寮傛瀬鍖栭殧绂诲害鎵�鍦ㄨ
-                                if (j == 0) {
-                                    //绗竴鍒�
-                                    textRenderData.setText(index + "鈭�1" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 1) {
-                                    //绗簩鍒�
-                                    textRenderData.setText("寮傛瀬鍖栭殧绂诲害鈭�2" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 2) {
-                                    //绗笁鍒�
-                                    textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 3) {
-                                    //绗洓鍒�
-                                    textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 4) {
-                                    //绗簲鍒�
-                                    textRenderData.setText("鏈�宸��");
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == bb - 1) {
-                                    //鏈�鍚庝竴鍒�
-                                    if (products.get(0).getInsResult() == 1) {
-                                        textRenderData.setText("鍚堟牸");
-                                    } else if (products.get(0).getInsResult() == 0) {
-                                        textRenderData.setText("涓嶅悎鏍�");
-                                    } else {
-                                        textRenderData.setText("涓嶅垽瀹�");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j % 2 == 0) {
-                                    String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", "");
-                                    try {
-                                        textRenderData.setText(value.split(",")[(j - 6) / 2 + (i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) - 1) * 4] + "鈭�5" + i + (j - 6));
-                                    } catch (Exception e) {
-                                        textRenderData.setText("");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else {
-                                    String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", "");
-                                    try {
-                                        textRenderData.setText(value.split(",")[(j - 5) / 2 + (i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) - 1) * 4] + "鈭�5" + i + (j - 5));
-                                    } catch (Exception e) {
-                                        textRenderData.setText("");
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("浜掕皟") && i > (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) {
-                                if (itemSet.add("浜掕皟")) {
-                                    index.getAndIncrement();
-                                }
-                                List<InsProduct> products = insProducts.stream()
-                                        .filter(insProduct -> insProduct.getInspectionItemSubclass().equals("浜掕皟"))
-                                        .collect(Collectors.toList());
-                                List<InsProductResult2> result2s = productResult2s.stream()
-                                        .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId()))
-                                        .collect(Collectors.toList());
-                                //浜掕皟鎵�鍦ㄨ
-                                if (j == 0) {
-                                    //绗竴鍒�
-                                    textRenderData.setText(index + "鈭�1" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 1) {
-                                    //绗簩鍒�
-                                    textRenderData.setText("浜掕皟鈭�2" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 2) {
-                                    //绗笁鍒�
-                                    textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 3) {
-                                    //绗洓鍒�
-                                    textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 4) {
-                                    //绗簲鍒�
-                                    if ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) % (angles + 1) == 1) {
-                                        textRenderData.setText("瑙掑害");
-                                    } else {
-                                        textRenderData.setText(result2s.get(0).getAngle().split(",")[(i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) - 2) % (angles + 1)]);
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == bb - 1) {
-                                    //鏈�鍚庝竴鍒�
-                                    if ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) % (angles + 1) == 1) {
-                                        textRenderData.setText("/");
-                                    } else {
-                                        if (products.get(0).getInsResult() == 1) {
-                                            textRenderData.setText("鍚堟牸鈭�8" + index + ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) + (angles - 1)) / (angles + 1) - 1));
-                                        } else if (products.get(0).getInsResult() == 0) {
-                                            textRenderData.setText("涓嶅悎鏍尖垜8" + index + ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) + (angles - 1)) / (angles + 1) - 1));
-                                        } else {
-                                            textRenderData.setText("涓嶅垽瀹氣垜8" + index + ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) + (angles - 1)) / (angles + 1) - 1));
-                                        }
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else {
-                                    if ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) % (angles + 1) == 1) {
-                                        textRenderData.setText(result2s.get((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) / portRow / (angles + 1)).getOften() + "鈭�6" + i + index);
-                                    } else {
-                                        String[] value = result2s.get((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) / portRow / (angles + 2)).getValue().split("\\],\\[");
-                                        String[] split = value[(i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) - 2) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                        try {
-                                            textRenderData.setText(split[((j - 5) + ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) - 1) / (angles + 1) % portRow) * (Math.min(ports, 8)))]);
-                                        } catch (Exception e) {
-                                            textRenderData.setText("");
-                                        }
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                }
-                            }
-                        } else {
-                            //鐢佃皟鐗堟湰(澶嶆潅鐗�)
-                            if (inspectionItemSubclass.contains("鐢靛帇椹绘尝姣�") && i <= (angles + 1) * portRow) {
-                                cc = (angles + 1) * portRow;
-                                if (itemSet.add("鐢靛帇椹绘尝姣�")) {
-                                    index.getAndIncrement();
-                                }
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鐢靛帇椹绘尝姣�")).collect(Collectors.toList());
-                                List<InsProductResult2> result2s = productResult2s.stream()
-                                        .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId()))
-                                        .collect(Collectors.toList());
-                                //鐢靛帇椹绘尝姣旀墍鍦ㄨ
-                                if (j == 0) {
-                                    //绗竴鍒�
-                                    textRenderData.setText(index + "鈭�1" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 1) {
-                                    //绗簩鍒�
-                                    textRenderData.setText("鐢靛帇椹绘尝姣斺垜2" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 2) {
-                                    //绗笁鍒�
-                                    textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 3) {
-                                    //绗洓鍒�
-                                    textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 4) {
-                                    //绗簲鍒�
-                                    if (i % (angles + 1) == 1) {
-                                        //绔彛
-                                        textRenderData.setText("绔彛");
-                                    } else {
-                                        //瑙掑害
-                                        textRenderData.setText(result2s.get(0).getAngle().split(",")[(i + (angles - 1)) % (angles + 1)]);
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == bb - 1) {
-                                    //鏈�鍚庝竴鍒�
-                                    if (i % (angles + 1) == 1) {
-                                        textRenderData.setText("/");
-                                    } else {
-                                        //缁撹
-                                        if (products.get(0).getInsResult() == 1) {
-                                            textRenderData.setText("鍚堟牸鈭�8" + index + ((i + (angles - 1)) / (angles + 1) - 1));
-                                        } else if (products.get(0).getInsResult() == 0) {
-                                            textRenderData.setText("涓嶅悎鏍尖垜8" + index + ((i + (angles - 1)) / (angles + 1) - 1));
-                                        } else {
-                                            textRenderData.setText("涓嶅垽瀹氣垜8" + index + ((i + (angles - 1)) / (angles + 1) - 1));
-                                        }
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else {
-                                    //鍏朵綑鍒�
-                                    if (i % (angles + 1) == 1) {
-                                        //绔彛
-                                        try {
-                                            textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 5) + (i / (angles + 1)) * (Math.min(ports, 8))]);
-                                        } catch (Exception e) {
-                                            textRenderData.setText("");
-                                        }
-                                    } else {
-                                        //鏈�宸��
-                                        String[] value = result2s.get(0).getValue().split("\\],\\[");
-                                        String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                        try {
-                                            textRenderData.setText(split[(j - 5) + ((i + (angles - 1)) / (angles + 1) - 1) * (Math.min(ports, 8))]);
-                                        } catch (Exception e) {
-                                            textRenderData.setText("");
-                                        }
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("鍚屾瀬鍖栭殧绂诲害")) {
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鍚屾瀬鍖栭殧绂诲害")).collect(Collectors.toList());
-                                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;
-                                int portRow2 = (length % (ports > 8 ? 4 : (ports + 1) / 2) == 0 ? length / (ports > 8 ? 4 : (ports + 1) / 2) : length / (ports > 8 ? 4 : (ports + 1) / 2) + 1);
-                                int k = (angles + 1) * portRow2;
-                                if (i > cc && i <= cc + k) {
-                                    dd = cc + k;
-                                    if (itemSet.add("鍚屾瀬鍖栭殧绂诲害")) {
-                                        index.getAndIncrement();
-                                    }
-                                    //鍚屾瀬鍖栭殧绂诲害鎵�鍦ㄨ
-                                    if (j == 0) {
-                                        //绗竴鍒�
-                                        textRenderData.setText(index + "鈭�1" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 1) {
-                                        //绗簩鍒�
-                                        textRenderData.setText("鍚屾瀬鍖栭殧绂诲害鈭�2" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 2) {
-                                        //绗笁鍒�
-                                        textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 3) {
-                                        //绗洓鍒�
-                                        textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 4) {
-                                        //绗簲鍒�
-                                        if ((i - cc) % (angles + 1) == 1) {
-                                            //绔彛
-                                            textRenderData.setText("绔彛");
-                                        } else {
-                                            //瑙掑害
-                                            textRenderData.setText(result2s.get(0).getAngle().split(",")[(i + (angles - 1)) % (angles + 1)]);
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == bb - 1) {
-                                        //鏈�鍚庝竴鍒�
-                                        if ((i - cc) % (angles + 1) == 1) {
-                                            textRenderData.setText("/");
-                                        } else {
-                                            //缁撹
-                                            if (products.get(0).getInsResult() == 1) {
-                                                textRenderData.setText("鍚堟牸鈭�8" + index + ((i - cc) / (angles + 2)));
-                                            } else if (products.get(0).getInsResult() == 0) {
-                                                textRenderData.setText("涓嶅悎鏍尖垜8" + index + ((i - cc) / (angles + 2)));
-                                            } else {
-                                                textRenderData.setText("涓嶅垽瀹氣垜8" + index + ((i - cc) / (angles + 2)));
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else {
-                                        //鍏朵綑鍒�
-                                        if ((i - cc) % (angles + 1) == 1) {
-                                            //绔彛
-                                            if (j % 2 == 0) {
-                                                try {
-                                                    textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 6) / 2 + ((i - cc) / (angles + 1)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 6));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            } else {
-                                                try {
-                                                    textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 5) / 2 + ((i - cc) / (angles + 1)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 5));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            }
-
-                                        } else {
-                                            //鏈�宸��
-                                            String[] value = result2s.get(0).getValue().split("\\],\\[");
-                                            String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                            if (j % 2 == 0) {
-                                                try {
-                                                    textRenderData.setText(split[(j - 6) / 2 + ((i - cc) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 6));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            } else {
-                                                try {
-                                                    textRenderData.setText(split[(j - 5) / 2 + ((i - cc) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 5));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    }
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("鍚屽垪闅旂搴�")) {
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鍚屽垪闅旂搴�")).collect(Collectors.toList());
-                                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;
-                                int portRow2 = (length % (ports > 8 ? 4 : (ports + 1) / 2) == 0 ? length / (ports > 8 ? 4 : (ports + 1) / 2) : length / (ports > 8 ? 4 : (ports + 1) / 2) + 1);
-                                int k = (angles + 1) * portRow2;
-                                if (i > (dd == 0 ? cc : dd) && i <= (dd == 0 ? cc : dd) + k) {
-                                    ee = (dd == 0 ? cc : dd) + k;
-                                    if (itemSet.add("鍚屽垪闅旂搴�")) {
-                                        index.getAndIncrement();
-                                    }
-                                    //闅旂搴︽墍鍦ㄨ
-                                    if (j == 0) {
-                                        //绗竴鍒�
-                                        textRenderData.setText(index + "鈭�1" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 1) {
-                                        //绗簩鍒�
-                                        textRenderData.setText("闅旂搴︹垜2" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 2) {
-                                        //绗笁鍒�
-                                        textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 3) {
-                                        //绗洓鍒�
-                                        textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 4) {
-                                        //绗簲鍒�
-                                        if ((i - (dd == 0 ? cc : dd)) % (angles + 1) == 1) {
-                                            //绔彛
-                                            textRenderData.setText("绔彛");
-                                        } else {
-                                            //瑙掑害
-                                            textRenderData.setText(result2s.get(0).getAngle().split(",")[(i + (angles - 1)) % (angles + 1)]);
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == bb - 1) {
-                                        //鏈�鍚庝竴鍒�
-                                        if ((i - (dd == 0 ? cc : dd)) % (angles + 1) == 1) {
-                                            textRenderData.setText("/");
-                                        } else {
-                                            //缁撹
-                                            if (products.get(0).getInsResult() == 1) {
-                                                textRenderData.setText("鍚堟牸鈭�8" + index + ((i - (dd == 0 ? cc : dd)) / (angles + 2)));
-                                            } else if (products.get(0).getInsResult() == 0) {
-                                                textRenderData.setText("涓嶅悎鏍尖垜8" + index + ((i - (dd == 0 ? cc : dd)) / (angles + 2)));
-                                            } else {
-                                                textRenderData.setText("涓嶅垽瀹氣垜8" + index + ((i - (dd == 0 ? cc : dd)) / (angles + 2)));
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else {
-                                        //鍏朵綑鍒�
-                                        if ((i - (dd == 0 ? cc : dd)) % (angles + 1) == 1) {
-                                            //绔彛
-                                            if (j % 2 == 0) {
-                                                try {
-                                                    textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 6) / 2 + ((i - (dd == 0 ? cc : dd)) / (angles + 1)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 6));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            } else {
-                                                try {
-                                                    textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 5) / 2 + ((i - (dd == 0 ? cc : dd)) / (angles + 1)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 5));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            }
-
-                                        } else {
-                                            //鏈�宸��
-                                            String[] value = result2s.get(0).getValue().split("\\],\\[");
-                                            String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                            if (j % 2 == 0) {
-                                                try {
-                                                    textRenderData.setText(split[(j - 6) / 2 + ((i - (dd == 0 ? cc : dd)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 6));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            } else {
-                                                try {
-                                                    textRenderData.setText(split[(j - 5) / 2 + ((i - (dd == 0 ? cc : dd)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 5));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    }
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("绔彛闂撮殧绂诲害")) {
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("绔彛闂撮殧绂诲害")).collect(Collectors.toList());
-                                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;
-                                int portRow2 = (length % (ports > 8 ? 4 : (ports + 1) / 2) == 0 ? length / (ports > 8 ? 4 : (ports + 1) / 2) : length / (ports > 8 ? 4 : (ports + 1) / 2) + 1);
-                                int k = (angles + 1) * portRow2;
-                                if (i > (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) && i <= (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) + k) {
-                                    ff = (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) + k;
-                                    if (itemSet.add("绔彛闂撮殧绂诲害")) {
-                                        index.getAndIncrement();
-                                    }
-                                    //鍚屾瀬鍖栭殧绂诲害鎵�鍦ㄨ
-                                    if (j == 0) {
-                                        //绗竴鍒�
-                                        textRenderData.setText(index + "鈭�1" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 1) {
-                                        //绗簩鍒�
-                                        textRenderData.setText("绔彛闂撮殧绂诲害鈭�2" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 2) {
-                                        //绗笁鍒�
-                                        textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 3) {
-                                        //绗洓鍒�
-                                        textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 4) {
-                                        //绗簲鍒�
-                                        if ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) % (angles + 1) == 1) {
-                                            //绔彛
-                                            textRenderData.setText("绔彛");
-                                        } else {
-                                            //瑙掑害
-                                            textRenderData.setText(result2s.get(0).getAngle().split(",")[(i + (angles - 1)) % (angles + 1)]);
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == bb - 1) {
-                                        //鏈�鍚庝竴鍒�
-                                        if ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) % (angles + 1) == 1) {
-                                            textRenderData.setText("/");
-                                        } else {
-                                            //缁撹
-                                            if (products.get(0).getInsResult() == 1) {
-                                                textRenderData.setText("鍚堟牸鈭�8" + index + ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) / (angles + 2)));
-                                            } else if (products.get(0).getInsResult() == 0) {
-                                                textRenderData.setText("涓嶅悎鏍尖垜8" + index + ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) / (angles + 2)));
-                                            } else {
-                                                textRenderData.setText("涓嶅垽瀹氣垜8" + index + ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) / (angles + 2)));
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else {
-                                        //鍏朵綑鍒�
-                                        if ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) % (angles + 1) == 1) {
-                                            //绔彛
-                                            if (j % 2 == 0) {
-                                                try {
-                                                    textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 6) / 2 + ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) / (angles + 1)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 6));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            } else {
-                                                try {
-                                                    textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 5) / 2 + ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) / (angles + 1)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 5));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            }
-
-                                        } else {
-                                            //鏈�宸��
-                                            String[] value = result2s.get(0).getValue().split("\\],\\[");
-                                            String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                            if (j % 2 == 0) {
-                                                try {
-                                                    textRenderData.setText(split[(j - 6) / 2 + ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 6));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            } else {
-                                                try {
-                                                    textRenderData.setText(split[(j - 5) / 2 + ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 5));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    }
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("寮傛瀬鍖栭殧绂诲害")) {
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("寮傛瀬鍖栭殧绂诲害")).collect(Collectors.toList());
-                                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;
-                                int portRow2 = (length % (ports > 8 ? 4 : (ports + 1) / 2) == 0 ? length / (ports > 8 ? 4 : (ports + 1) / 2) : length / (ports > 8 ? 4 : (ports + 1) / 2) + 1);
-                                int k = (angles + 1) * portRow2;
-                                if (i > (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) && i <= (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) + k) {
-                                    gg = (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) + k;
-                                    if (itemSet.add("寮傛瀬鍖栭殧绂诲害")) {
-                                        index.getAndIncrement();
-                                    }
-                                    //寮傛瀬鍖栭殧绂诲害鎵�鍦ㄨ
-                                    if (j == 0) {
-                                        //绗竴鍒�
-                                        textRenderData.setText(index + "鈭�1" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 1) {
-                                        //绗簩鍒�
-                                        textRenderData.setText("寮傛瀬鍖栭殧绂诲害鈭�2" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 2) {
-                                        //绗笁鍒�
-                                        textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 3) {
-                                        //绗洓鍒�
-                                        textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 4) {
-                                        //绗簲鍒�
-                                        if ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) % (angles + 1) == 1) {
-                                            //绔彛
-                                            textRenderData.setText("绔彛");
-                                        } else {
-                                            //瑙掑害
-                                            textRenderData.setText(result2s.get(0).getAngle().split(",")[(i + (angles - 1)) % (angles + 1)]);
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == bb - 1) {
-                                        //鏈�鍚庝竴鍒�
-                                        if ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) % (angles + 1) == 1) {
-                                            textRenderData.setText("/");
-                                        } else {
-                                            //缁撹
-                                            if (products.get(0).getInsResult() == 1) {
-                                                textRenderData.setText("鍚堟牸鈭�8" + index + ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) / (angles + 2)));
-                                            } else if (products.get(0).getInsResult() == 0) {
-                                                textRenderData.setText("涓嶅悎鏍尖垜8" + index + ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) / (angles + 2)));
-                                            } else {
-                                                textRenderData.setText("涓嶅垽瀹氣垜8" + index + ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) / (angles + 2)));
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else {
-                                        //鍏朵綑鍒�
-                                        if ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) % (angles + 1) == 1) {
-                                            //绔彛
-                                            if (j % 2 == 0) {
-                                                try {
-                                                    textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 6) / 2 + ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) / (angles + 1)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 6));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            } else {
-                                                try {
-                                                    textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 5) / 2 + ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) / (angles + 1)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 5));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            }
-                                        } else {
-                                            //鏈�宸��
-                                            String[] value = result2s.get(0).getValue().split("\\],\\[");
-                                            String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                            if (j % 2 == 0) {
-                                                try {
-                                                    textRenderData.setText(split[(j - 6) / 2 + ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 6));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            } else {
-                                                try {
-                                                    textRenderData.setText(split[(j - 5) / 2 + ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)] + "鈭�5" + i + (j - 5));
-                                                } catch (Exception e) {
-                                                    textRenderData.setText("");
-                                                }
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    }
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("浜掕皟") && i > (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) && i <= ((gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) + (angles + 1) * portRow * often)) {
-                                hh = (int) ((gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) + (angles + 1) * portRow * often);
-                                if (itemSet.add("浜掕皟")) {
-                                    index.getAndIncrement();
-                                }
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("浜掕皟")).collect(Collectors.toList());
-                                List<InsProductResult2> result2s = productResult2s.stream()
-                                        .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId()))
-                                        .collect(Collectors.toList());
-                                //浜掕皟鎵�鍦ㄨ
-                                if (j == 0) {
-                                    //绗竴鍒�
-                                    textRenderData.setText(index + "鈭�1" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 1) {
-                                    //绗簩鍒�
-                                    textRenderData.setText("浜掕皟鈭�2" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 2) {
-                                    //绗笁鍒�
-                                    textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 3) {
-                                    //绗洓鍒�
-                                    textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 4) {
-                                    //绗簲鍒�
-                                    if ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) % (angles + 1) == 1) {
-                                        //瑙掑害
-                                        textRenderData.setText("瑙掑害");
-                                    } else {
-                                        //鍊�
-                                        textRenderData.setText(result2s.get(0).getAngle().split(",")[(i + (angles - 1)) % (angles + 1)]);
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == bb - 1) {
-                                    //鏈�鍚庝竴鍒�
-                                    if ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) % (angles + 1) == 1) {
-                                        textRenderData.setText("/");
-                                    } else {
-                                        //缁撹
-                                        if (products.get(0).getInsResult() == 1) {
-                                            textRenderData.setText("鍚堟牸鈭�8" + index + ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) + (angles - 1)) / (angles + 1) - 1));
-                                        } else if (products.get(0).getInsResult() == 0) {
-                                            textRenderData.setText("涓嶅悎鏍尖垜8" + index + ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) + (angles - 1)) / (angles + 1) - 1));
-                                        } else {
-                                            textRenderData.setText("涓嶅垽瀹氣垜8" + index + ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) + (angles - 1)) / (angles + 1) - 1));
-                                        }
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else {
-                                    //鍏朵綑鍒�
-                                    if ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) % (angles + 1) == 1) {
-                                        //棰戠偣
-                                        textRenderData.setText(result2s.get((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) / portRow / (angles + 1)).getOften() + "鈭�6" + i + index);
-                                    } else {
-                                        //鏈�宸��
-                                        String[] value = result2s.get((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg)) / portRow / (angles + 2)).getValue().split("\\],\\[");
-                                        String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                        try {
-                                            textRenderData.setText(split[((j - 5) + ((i - (gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg) - 1) / (angles + 1) % portRow) * (Math.min(ports, 8)))]);
-                                        } catch (Exception e) {
-                                            textRenderData.setText("");
-                                        }
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("鏈�澶ц�﹀悎搴�") && i > (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) && i <= ((hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) + (angles + 1))) {
-                                mm = ((hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) + (angles + 1));
-                                if (itemSet.add("鏈�澶ц�﹀悎搴�")) {
-                                    index.getAndIncrement();
-                                }
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鏈�澶ц�﹀悎搴�")).collect(Collectors.toList());
-                                List<InsProductResult2> result2s = productResult2s.stream()
-                                        .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId()))
-                                        .collect(Collectors.toList());
-                                //鏈�澶ц�﹀悎搴︽墍鍦ㄨ
-                                if (j == 0) {
-                                    //绗竴鍒�
-                                    textRenderData.setText(index + "鈭�1" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 1) {
-                                    //绗簩鍒�
-                                    textRenderData.setText("鏈�澶ц�﹀悎搴︹垜2" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 2) {
-                                    //绗笁鍒�
-                                    textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 3) {
-                                    //绗洓鍒�
-                                    textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 4) {
-                                    //绗簲鍒�
-                                    if ((i - (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh)) % (angles + 1) == 1) {
-                                        //瑙掑害
-                                        textRenderData.setText("瑙掑害");
-                                    } else {
-                                        //鍊�
-                                        textRenderData.setText(result2s.get(0).getAngle().split(",")[(i + (angles - 1)) % (angles + 1)]);
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == bb - 1) {
-                                    //鏈�鍚庝竴鍒�
-                                    if ((i - (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh)) % (angles + 1) == 1) {
-                                        textRenderData.setText("/");
-                                    } else {
-                                        //缁撹
-                                        if (products.get(0).getInsResult() == 1) {
-                                            textRenderData.setText("鍚堟牸鈭�8" + index);
-                                        } else if (products.get(0).getInsResult() == 0) {
-                                            textRenderData.setText("涓嶅悎鏍尖垜8" + index);
-                                        } else {
-                                            textRenderData.setText("涓嶅垽瀹氣垜8" + index);
-                                        }
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else {
-                                    //鍏朵綑鍒�
-                                    if ((i - (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh)) % (angles + 1) == 1) {
-                                        //棰戠偣
-                                        textRenderData.setText(result2s.get(0).getOften() + "鈭�6" + index);
-                                    } else {
-                                        //鏈�宸��
-                                        String[] value = result2s.get(0).getValue().split("\\],\\[");
-                                        String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                        textRenderData.setText(split[0] + "鈭�7" + i);
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("鏈�灏忚�﹀悎搴�") && i > (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) && i <= ((mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) + (angles + 1))) {
-                                nn = (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) + (angles + 1);
-                                if (itemSet.add("鏈�灏忚�﹀悎搴�")) {
-                                    index.getAndIncrement();
-                                }
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鏈�灏忚�﹀悎搴�")).collect(Collectors.toList());
-                                List<InsProductResult2> result2s = productResult2s.stream()
-                                        .filter(insProductResult2 -> insProductResult2.getFrequency().equals(s) && insProductResult2.getInsProductId().equals(products.get(0).getId()))
-                                        .collect(Collectors.toList());
-                                //鏈�灏忚�﹀悎搴︽墍鍦ㄨ
-                                if (j == 0) {
-                                    //绗竴鍒�
-                                    textRenderData.setText(index + "鈭�1" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 1) {
-                                    //绗簩鍒�
-                                    textRenderData.setText("鏈�灏忚�﹀悎搴︹垜2" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 2) {
-                                    //绗笁鍒�
-                                    textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 3) {
-                                    //绗洓鍒�
-                                    textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == 4) {
-                                    //绗簲鍒�
-                                    if ((i - (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm)) % (angles + 1) == 1) {
-                                        //瑙掑害
-                                        textRenderData.setText("瑙掑害");
-                                    } else {
-                                        //鍊�
-                                        textRenderData.setText(result2s.get(0).getAngle().split(",")[(i + (angles - 1)) % (angles + 1)]);
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else if (j == bb - 1) {
-                                    //鏈�鍚庝竴鍒�
-                                    if ((i - (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm)) % (angles + 1) == 1) {
-                                        textRenderData.setText("/");
-                                    } else {
-                                        //缁撹
-                                        if (products.get(0).getInsResult() == 1) {
-                                            textRenderData.setText("鍚堟牸鈭�8" + index);
-                                        } else if (products.get(0).getInsResult() == 0) {
-                                            textRenderData.setText("涓嶅悎鏍尖垜8" + index);
-                                        } else {
-                                            textRenderData.setText("涓嶅垽瀹氣垜8" + index);
-                                        }
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                } else {
-                                    //鍏朵綑鍒�
-                                    if ((i - (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm)) % (angles + 1) == 1) {
-                                        //棰戠偣
-                                        textRenderData.setText(result2s.get(0).getOften() + "鈭�6" + index);
-                                    } else {
-                                        //鏈�宸��
-                                        String[] value = result2s.get(0).getValue().split("\\],\\[");
-                                        String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                        textRenderData.setText(split[0] + "鈭�7" + i);
-                                    }
-                                    renderData.add(textRenderData);
-                                    paragraphRenderData.setContents(renderData);
-                                    paragraphRenderDataList.add(paragraphRenderData);
-                                    cellRenderData.setParagraphs(paragraphRenderDataList);
-                                    cells.add(cellRenderData);
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("骞呭害鍋忓樊")) {
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("骞呭害鍋忓樊")).collect(Collectors.toList());
-                                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;
-                                int portRow2 = (length % 8 == 0 ? length / 8 : length / 8 + 1);
-                                int k = (angles + 1) * portRow2;
-                                if (i > (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) && i <= (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) + k) {
-                                    pp = (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) + k;
-                                    if (itemSet.add("骞呭害鍋忓樊")) {
-                                        index.getAndIncrement();
-                                    }
-                                    //骞呭害鍋忓樊鎵�鍦ㄨ
-                                    if (j == 0) {
-                                        //绗竴鍒�
-                                        textRenderData.setText(index + "鈭�1" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 1) {
-                                        //绗簩鍒�
-                                        textRenderData.setText("骞呭害鍋忓樊鈭�2" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 2) {
-                                        //绗笁鍒�
-                                        textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 3) {
-                                        //绗洓鍒�
-                                        textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 4) {
-                                        //绗簲鍒�
-                                        if ((i - (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn)) % (angles + 1) == 1) {
-                                            //棰戞
-                                            textRenderData.setText("棰戞");
-                                        } else {
-                                            //瑙掑害
-                                            textRenderData.setText(result2s.get(0).getAngle().split(",")[(i + (angles - 1)) % (angles + 1)]);
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == bb - 1) {
-                                        //鏈�鍚庝竴鍒�
-                                        if ((i - (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn)) % (angles + 1) == 1) {
-                                            textRenderData.setText("/");
-                                        } else {
-                                            //缁撹
-                                            if (products.get(0).getInsResult() == 1) {
-                                                textRenderData.setText("鍚堟牸鈭�8" + index + ((i - (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn)) / (angles + 2)));
-                                            } else if (products.get(0).getInsResult() == 0) {
-                                                textRenderData.setText("涓嶅悎鏍尖垜8" + index + ((i - (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn)) / (angles + 2)));
-                                            } else {
-                                                textRenderData.setText("涓嶅垽瀹氣垜8" + index + ((i - (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn)) / (angles + 2)));
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else {
-                                        //鍏朵綑鍒�
-                                        if ((i - (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn)) % (angles + 1) == 1) {
-                                            //棰戞
-                                            try {
-                                                textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 5) + ((i - (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn)) / (angles + 2)) * Math.min(length, 8)]);
-                                            } catch (Exception e) {
-                                                textRenderData.setText("");
-                                            }
-                                        } else {
-                                            //鏈�宸��
-                                            String[] value = result2s.get(0).getValue().split("\\],\\[");
-                                            String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                            try {
-                                                textRenderData.setText(split[(j - 5) + ((i - (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn)) / (angles + 2)) * Math.min(length, 8)]);
-                                            } catch (Exception e) {
-                                                textRenderData.setText("");
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    }
-                                }
-                            }
-                            if (inspectionItemSubclass.contains("鏈�澶х浉浣嶅亸宸�")) {
-                                List<InsProduct> products = insProducts.stream().filter(insProduct -> insProduct.getInspectionItemSubclass().equals("鏈�澶х浉浣嶅亸宸�")).collect(Collectors.toList());
-                                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;
-                                int portRow2 = (length % 8 == 0 ? length / 8 : length / 8 + 1);
-                                int k = (angles + 1) * portRow2;
-                                if (i > (pp == 0 ? (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) : pp)) {
-                                    if (itemSet.add("鏈�澶х浉浣嶅亸宸�")) {
-                                        index.getAndIncrement();
-                                    }
-                                    //鏈�澶х浉浣嶅亸宸墍鍦ㄨ
-                                    if (j == 0) {
-                                        //绗竴鍒�
-                                        textRenderData.setText(index + "鈭�1" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 1) {
-                                        //绗簩鍒�
-                                        textRenderData.setText("鏈�澶х浉浣嶅亸宸垜2" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 2) {
-                                        //绗笁鍒�
-                                        textRenderData.setText(products.get(0).getUnit() + "鈭�3" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 3) {
-                                        //绗洓鍒�
-                                        textRenderData.setText(products.get(0).getAsk() + "鈭�4" + index);
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == 4) {
-                                        //绗簲鍒�
-                                        if ((i - (pp == 0 ? (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) : pp)) % (angles + 1) == 1) {
-                                            //棰戞
-                                            textRenderData.setText("棰戞");
-                                        } else {
-                                            //瑙掑害
-                                            textRenderData.setText(result2s.get(0).getAngle().split(",")[(i + (angles - 1)) % (angles + 1)]);
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else if (j == bb - 1) {
-                                        //鏈�鍚庝竴鍒�
-                                        if ((i - (pp == 0 ? (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) : pp)) % (angles + 1) == 1) {
-                                            textRenderData.setText("/");
-                                        } else {
-                                            //缁撹
-                                            if (products.get(0).getInsResult() == 1) {
-                                                textRenderData.setText("鍚堟牸鈭�8" + index + ((i - (pp == 0 ? (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) : pp)) / (angles + 2)));
-                                            } else if (products.get(0).getInsResult() == 0) {
-                                                textRenderData.setText("涓嶅悎鏍尖垜8" + index + ((i - (pp == 0 ? (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) : pp)) / (angles + 2)));
-                                            } else {
-                                                textRenderData.setText("涓嶅垽瀹氣垜8" + index + ((i - (pp == 0 ? (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) : pp)) / (angles + 2)));
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    } else {
-                                        //鍏朵綑鍒�
-                                        if ((i - (pp == 0 ? (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) : pp)) % (angles + 1) == 1) {
-                                            //绔彛
-                                            try {
-                                                textRenderData.setText(result2s.get(0).getPort().split(",")[(j - 5) + ((i - (pp == 0 ? (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) : pp)) / (angles + 2)) * Math.min(length, 8)]);
-                                            } catch (Exception e) {
-                                                textRenderData.setText("");
-                                            }
-                                        } else {
-                                            //鏈�宸��
-                                            String[] value = result2s.get(0).getValue().split("\\],\\[");
-                                            String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(",");
-                                            try {
-                                                textRenderData.setText(split[(j - 5) + ((i - (pp == 0 ? (nn == 0 ? (mm == 0 ? (hh==0?(gg == 0 ? (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) : gg):hh) : mm) : nn) : pp)) / (angles + 2)) * Math.min(length, 8)]);
-                                            } catch (Exception e) {
-                                                textRenderData.setText("");
-                                            }
-                                        }
-                                        renderData.add(textRenderData);
-                                        paragraphRenderData.setContents(renderData);
-                                        paragraphRenderDataList.add(paragraphRenderData);
-                                        cellRenderData.setParagraphs(paragraphRenderDataList);
-                                        cells.add(cellRenderData);
-                                    }
-                                }
-                            }
+                    }
+                    else if (j==1){
+                        //绗簩鍒�(妫�楠岄」鐩�)
+                        textRenderData.setText(result2VOS.get(i).getInspectionItemSubclass()+ "鈭�2" + index);
+                        renderData.add(textRenderData);
+                        paragraphRenderData.setContents(renderData);
+                        paragraphRenderDataList.add(paragraphRenderData);
+                        cellRenderData.setParagraphs(paragraphRenderDataList);
+                        cells.add(cellRenderData);
+                    }
+                    else if (j==2){
+                        //绗笁鍒�(鍗曚綅)
+                        textRenderData.setText(result2VOS.get(i).getUnit()+ "鈭�3" + index);
+                        renderData.add(textRenderData);
+                        paragraphRenderData.setContents(renderData);
+                        paragraphRenderDataList.add(paragraphRenderData);
+                        cellRenderData.setParagraphs(paragraphRenderDataList);
+                        cells.add(cellRenderData);
+                    }
+                    else if (j==3){
+                        //绗洓鍒�(鏍囧噯涓庤姹�)
+                        textRenderData.setText(result2VOS.get(i).getAsk());
+                        renderData.add(textRenderData);
+                        paragraphRenderData.setContents(renderData);
+                        paragraphRenderDataList.add(paragraphRenderData);
+                        cellRenderData.setParagraphs(paragraphRenderDataList);
+                        cells.add(cellRenderData);
+                    }
+                    else if (j==4){
+                        //绗簲鍒�(绔彛)
+                        try{
+                            textRenderData.setText(result2VOS.get(i).getPort());
+                        }catch (Exception e){
+                            textRenderData.setText("");
                         }
+                        renderData.add(textRenderData);
+                        paragraphRenderData.setContents(renderData);
+                        paragraphRenderDataList.add(paragraphRenderData);
+                        cellRenderData.setParagraphs(paragraphRenderDataList);
+                        cells.add(cellRenderData);
+                    }
+                    else if (j==5){
+                        //绗叚鍒�(棰戞)
+                        try{
+                            textRenderData.setText(result2VOS.get(i).getFrequency());
+                        }catch (Exception e){
+                            textRenderData.setText("");
+                        }
+                        renderData.add(textRenderData);
+                        paragraphRenderData.setContents(renderData);
+                        paragraphRenderDataList.add(paragraphRenderData);
+                        cellRenderData.setParagraphs(paragraphRenderDataList);
+                        cells.add(cellRenderData);
+                    }
+                    else if (j==6){
+                        //绗竷鍒�(妫�楠屽��)
+                        try{
+                            textRenderData.setText(result2VOS.get(i).getValue());
+                        }catch (Exception e){
+                            textRenderData.setText("");
+                        }
+                        renderData.add(textRenderData);
+                        paragraphRenderData.setContents(renderData);
+                        paragraphRenderDataList.add(paragraphRenderData);
+                        cellRenderData.setParagraphs(paragraphRenderDataList);
+                        cells.add(cellRenderData);
+                    }
+                    else {
+                        //鏈�鍚庝竴鍒�(缁撹)
+                        try{
+                            if (result2VOS.get(i).getResult().equals("1")) {
+                                textRenderData.setText("鍚堟牸");
+                            }else if (result2VOS.get(i).getResult().equals("0")){
+                                textRenderData.setText("涓嶅悎鏍�");
+                            }else {
+                                textRenderData.setText("涓嶅垽瀹�");
+                            }
+                        }catch (Exception e){
+                            textRenderData.setText("");
+                        }
+                        renderData.add(textRenderData);
+                        paragraphRenderData.setContents(renderData);
+                        paragraphRenderDataList.add(paragraphRenderData);
+                        cellRenderData.setParagraphs(paragraphRenderDataList);
+                        cells.add(cellRenderData);
                     }
                 }
                 rowRenderData.setCells(cells);
@@ -3877,33 +2221,32 @@
                     rows.add(rowRenderData);
                 }
             }
-            TableRenderData tableRenderData = new TableRenderData();
-            tableRenderData.setRows(rows);
-            int countSize = tableRenderData.getRows().get(0).getCells().size();
-            for (RowRenderData row : tableRenderData.getRows()) {
+        TableRenderData tableRenderData = new TableRenderData();
+        tableRenderData.setRows(rows);
+        int countSize = tableRenderData.getRows().get(0).getCells().size();
+        for (RowRenderData row : tableRenderData.getRows()) {
                 if (row.getCells().size() != countSize) {
                     throw new ErrorException("姣忚鍗曞厓鏍间笉鐩哥瓑");
                 }
-            }
-            TableStyle tableStyle = new TableStyle();
-            tableStyle.setWidth(XWPFTable.DEFAULT_PERCENTAGE_WIDTH);
-            tableStyle.setAlign(TableRowAlign.CENTER);
-            BorderStyle borderStyle = new BorderStyle();
-            borderStyle.setColor("000000");
-            borderStyle.setType(XWPFTable.XWPFBorderType.THICK);
-            borderStyle.setSize(4);
-            tableStyle.setLeftBorder(borderStyle);
-            tableStyle.setTopBorder(borderStyle);
-            tableStyle.setRightBorder(borderStyle);
-            tableStyle.setBottomBorder(borderStyle);
-            tableRenderData.setTableStyle(tableStyle);
-            Map<String, Object> table = new HashMap<>();
-            table.put("table", tableRenderData);
-            tables.add(table);
-            lable.getAndIncrement();
-        });
+        }
+        TableStyle tableStyle = new TableStyle();
+        tableStyle.setWidth(XWPFTable.DEFAULT_PERCENTAGE_WIDTH);
+        tableStyle.setAlign(TableRowAlign.CENTER);
+        BorderStyle borderStyle = new BorderStyle();
+        borderStyle.setColor("000000");
+        borderStyle.setType(XWPFTable.XWPFBorderType.THICK);
+        borderStyle.setSize(4);
+        tableStyle.setLeftBorder(borderStyle);
+        tableStyle.setTopBorder(borderStyle);
+        tableStyle.setRightBorder(borderStyle);
+        tableStyle.setBottomBorder(borderStyle);
+        tableRenderData.setTableStyle(tableStyle);
+        Map<String, Object> table = new HashMap<>();
+        table.put("table", tableRenderData);
+        tables.add(table);
+
         ZipSecureFile.setMinInflateRatio(0.0001);
-        InputStream inputStream = this.getClass().getResourceAsStream("/static/word1.docx");
+        InputStream inputStream = this.getClass().getResourceAsStream("/static/word2.docx");
 
         ConfigureBuilder builder = Configure.builder();
         builder.useSpringEL(true);
@@ -6597,7 +4940,190 @@
 
     //鐢佃矾鎶ュ憡鐢ㄤ簬鎬绘姤鍛婄殑鏂规硶(鏃犳簮鍣ㄤ欢)
     private void getWord2(String term, InsOrderState insOrderState,List<Map<String, Object>> tables2){
-
+        AtomicInteger index = new AtomicInteger();
+        String title = term + "鐢佃矾鍙傛暟";
+        //鏌ヨ鏍峰搧
+        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, "鐢佃矾璇曢獙"));
+        //璁$畻琛屾暟
+        List<InsProductResult2VO> result2VOS = new ArrayList<>();
+        List<InsProductResult2VO> insProductResult2VOS = insProductResult2Mapper.selectWordHang(insOrderState.getNum(), insProducts.stream().map(InsProduct::getId).collect(Collectors.toList()));
+        for (InsProductResult2VO insProductResult2VO : insProductResult2VOS) {
+            String[] split = insProductResult2VO.getPort().split(",");
+            String value = insProductResult2VO.getValue().replace("[[", "").replace("]]", "");
+            if (split.length>1){
+                for (int i = 0; i < split.length; i++) {
+                    InsProductResult2VO insProductResult2VO1 = new InsProductResult2VO();
+                    BeanUtils.copyProperties(insProductResult2VO,insProductResult2VO1);
+                    //绔彛
+                    insProductResult2VO1.setPort(split[i]);
+                    //鍊�
+                    insProductResult2VO1.setValue(value.split(",")[i].replace("\"",""));
+                    result2VOS.add(insProductResult2VO1);
+                }
+            }
+            else {
+                insProductResult2VO.setValue(value.replace("\"",""));
+                result2VOS.add(insProductResult2VO);
+            }
+        }
+        List<RowRenderData> rows = new ArrayList<>();
+        Set<String> itemSet = new HashSet<>();
+        //琛ㄦ牸鐨勮鏁�
+        for (int i = 0; i < result2VOS.size(); i++) {
+            RowRenderData rowRenderData = new RowRenderData();
+            RowStyle rowStyle = new RowStyle();
+            rowStyle.setHeight(40);
+            rowRenderData.setRowStyle(rowStyle);
+            List<CellRenderData> cells = new ArrayList<>();
+            //琛ㄦ牸鐨勫垪鏁�
+            for (int j = 0; j < 8; j++) {
+                CellRenderData cellRenderData = new CellRenderData();
+                CellStyle cellStyle = new CellStyle();
+                cellStyle.setVertAlign(XWPFTableCell.XWPFVertAlign.CENTER);
+                cellRenderData.setCellStyle(cellStyle);
+                List<ParagraphRenderData> paragraphRenderDataList = new ArrayList<>();
+                ParagraphRenderData paragraphRenderData = new ParagraphRenderData();
+                ParagraphStyle paragraphStyle = new ParagraphStyle();
+                paragraphStyle.setAlign(ParagraphAlignment.CENTER);
+                paragraphRenderData.setParagraphStyle(paragraphStyle);
+                List<RenderData> renderData = new ArrayList<>();
+                TextRenderData textRenderData = new TextRenderData();
+                Style style = new Style();
+                style.setFontFamily("瀹嬩綋");
+                style.setColor("000000");
+                textRenderData.setStyle(style);
+                if (j==0){
+                    //绗竴鍒�(搴忓彿)
+                    if (itemSet.add(result2VOS.get(i).getInspectionItemSubclass())) {
+                        index.getAndIncrement();
+                    }
+                    textRenderData.setText(index + "鈭�1" + index);
+                    renderData.add(textRenderData);
+                    paragraphRenderData.setContents(renderData);
+                    paragraphRenderDataList.add(paragraphRenderData);
+                    cellRenderData.setParagraphs(paragraphRenderDataList);
+                    cells.add(cellRenderData);
+                }
+                else if (j==1){
+                    //绗簩鍒�(妫�楠岄」鐩�)
+                    textRenderData.setText(result2VOS.get(i).getInspectionItemSubclass()+ "鈭�2" + index);
+                    renderData.add(textRenderData);
+                    paragraphRenderData.setContents(renderData);
+                    paragraphRenderDataList.add(paragraphRenderData);
+                    cellRenderData.setParagraphs(paragraphRenderDataList);
+                    cells.add(cellRenderData);
+                }
+                else if (j==2){
+                    //绗笁鍒�(鍗曚綅)
+                    textRenderData.setText(result2VOS.get(i).getUnit()+ "鈭�3" + index);
+                    renderData.add(textRenderData);
+                    paragraphRenderData.setContents(renderData);
+                    paragraphRenderDataList.add(paragraphRenderData);
+                    cellRenderData.setParagraphs(paragraphRenderDataList);
+                    cells.add(cellRenderData);
+                }
+                else if (j==3){
+                    //绗洓鍒�(鏍囧噯涓庤姹�)
+                    textRenderData.setText(result2VOS.get(i).getAsk());
+                    renderData.add(textRenderData);
+                    paragraphRenderData.setContents(renderData);
+                    paragraphRenderDataList.add(paragraphRenderData);
+                    cellRenderData.setParagraphs(paragraphRenderDataList);
+                    cells.add(cellRenderData);
+                }
+                else if (j==4){
+                    //绗簲鍒�(绔彛)
+                    try{
+                        textRenderData.setText(result2VOS.get(i).getPort());
+                    }catch (Exception e){
+                        textRenderData.setText("");
+                    }
+                    renderData.add(textRenderData);
+                    paragraphRenderData.setContents(renderData);
+                    paragraphRenderDataList.add(paragraphRenderData);
+                    cellRenderData.setParagraphs(paragraphRenderDataList);
+                    cells.add(cellRenderData);
+                }
+                else if (j==5){
+                    //绗叚鍒�(棰戞)
+                    try{
+                        textRenderData.setText(result2VOS.get(i).getFrequency());
+                    }catch (Exception e){
+                        textRenderData.setText("");
+                    }
+                    renderData.add(textRenderData);
+                    paragraphRenderData.setContents(renderData);
+                    paragraphRenderDataList.add(paragraphRenderData);
+                    cellRenderData.setParagraphs(paragraphRenderDataList);
+                    cells.add(cellRenderData);
+                }
+                else if (j==6){
+                    //绗竷鍒�(妫�楠屽��)
+                    try{
+                        textRenderData.setText(result2VOS.get(i).getValue());
+                    }catch (Exception e){
+                        textRenderData.setText("");
+                    }
+                    renderData.add(textRenderData);
+                    paragraphRenderData.setContents(renderData);
+                    paragraphRenderDataList.add(paragraphRenderData);
+                    cellRenderData.setParagraphs(paragraphRenderDataList);
+                    cells.add(cellRenderData);
+                }
+                else {
+                    //鏈�鍚庝竴鍒�(缁撹)
+                    try{
+                        if (result2VOS.get(i).getResult().equals("1")) {
+                            textRenderData.setText("鍚堟牸");
+                        }else if (result2VOS.get(i).getResult().equals("0")){
+                            textRenderData.setText("涓嶅悎鏍�");
+                        }else {
+                            textRenderData.setText("涓嶅垽瀹�");
+                        }
+                    }catch (Exception e){
+                        textRenderData.setText("");
+                    }
+                    renderData.add(textRenderData);
+                    paragraphRenderData.setContents(renderData);
+                    paragraphRenderDataList.add(paragraphRenderData);
+                    cellRenderData.setParagraphs(paragraphRenderDataList);
+                    cells.add(cellRenderData);
+                }
+            }
+            rowRenderData.setCells(cells);
+            if (rowRenderData.getCells().size() != 0) {
+                rows.add(rowRenderData);
+            }
+        }
+        TableRenderData tableRenderData = new TableRenderData();
+        tableRenderData.setRows(rows);
+        int countSize = tableRenderData.getRows().get(0).getCells().size();
+        for (RowRenderData row : tableRenderData.getRows()) {
+            if (row.getCells().size() != countSize) {
+                throw new ErrorException("姣忚鍗曞厓鏍间笉鐩哥瓑");
+            }
+        }
+        TableStyle tableStyle = new TableStyle();
+        tableStyle.setWidth(XWPFTable.DEFAULT_PERCENTAGE_WIDTH);
+        tableStyle.setAlign(TableRowAlign.CENTER);
+        BorderStyle borderStyle = new BorderStyle();
+        borderStyle.setColor("000000");
+        borderStyle.setType(XWPFTable.XWPFBorderType.THICK);
+        borderStyle.setSize(4);
+        tableStyle.setLeftBorder(borderStyle);
+        tableStyle.setTopBorder(borderStyle);
+        tableStyle.setRightBorder(borderStyle);
+        tableStyle.setBottomBorder(borderStyle);
+        tableRenderData.setTableStyle(tableStyle);
+        Map<String, Object> table2 = new HashMap<>();
+        table2.put("table2", tableRenderData);
+        table2.put("title", title);
+        tables2.add(table2);
     }
 
     // 姘村钩鍚堝苟鍗曞厓鏍�
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/vo/InsProductResult2VO.java b/inspect-server/src/main/java/com/yuanchu/mom/vo/InsProductResult2VO.java
new file mode 100644
index 0000000..07ab956
--- /dev/null
+++ b/inspect-server/src/main/java/com/yuanchu/mom/vo/InsProductResult2VO.java
@@ -0,0 +1,29 @@
+package com.yuanchu.mom.vo;
+
+import lombok.Data;
+
+//鏃犳簮鍣ㄤ欢鐨勭數璺瘯楠岀敓鎴愭姤鍛婃墍鐢�
+@Data
+public class InsProductResult2VO {
+
+    //妫�楠岄」鐩�
+    private String inspectionItemSubclass;
+
+    //鍗曚綅
+    private String unit;
+
+    //鏍囧噯瑕佹眰
+    private String ask;
+
+    //绔彛
+    private String port;
+
+    //棰戞
+    private String frequency;
+
+    //妫�楠屽��
+    private String value;
+
+    //缁撹
+    private String result;
+}
diff --git a/inspect-server/src/main/resources/mapper/InsProductResult2Mapper.xml b/inspect-server/src/main/resources/mapper/InsProductResult2Mapper.xml
index 883e299..de4be72 100644
--- a/inspect-server/src/main/resources/mapper/InsProductResult2Mapper.xml
+++ b/inspect-server/src/main/resources/mapper/InsProductResult2Mapper.xml
@@ -35,4 +35,23 @@
              #{result2.num})
         </foreach>
     </insert>
+    <select id="selectWordHang" resultType="com.yuanchu.mom.vo.InsProductResult2VO">
+        select
+        inspection_item_subclass,
+        unit,
+        ask,
+        result,
+        frequency,
+        port,
+        value,
+        result
+        from  ins_product_result_2 ipr2
+                          left join ins_product ip on ipr2.ins_product_id = ip.id
+        where num=#{num}
+          and ip.id in
+            <foreach collection="ids" separator="," item="id" open="(" close=")" >
+                #{id}
+            </foreach>
+        order by inspection_item_subclass
+    </select>
 </mapper>
diff --git a/inspect-server/src/main/resources/static/word2.docx b/inspect-server/src/main/resources/static/word2.docx
new file mode 100644
index 0000000..0ee5b6e
--- /dev/null
+++ b/inspect-server/src/main/resources/static/word2.docx
Binary files differ

--
Gitblit v1.9.3