光纤接头损耗

zss

2024-07-13 95e3d91f19763a7d96c0f084bf8fcd31ea8e5896

光纤接头损耗

 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java

@@ -550,6 +550,7 @@
        if (count == 0 && num == 5) {
            List<InsUnPass> insUnPasses = new ArrayList<>();
            /*样品下的项目只要有一个项目不合格则检验结果为0,否则为1*/
            //这里的insSamples是订单下的所有样品包括("/")
            List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId));
            for (InsSample insSample : insSamples) {
                List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getInsSampleId, insSample.getId()).eq(InsProduct::getState, 1));
@@ -581,6 +582,7 @@
            insUnPassService.saveBatch(insUnPasses);
            InsOrder insOrder = insOrderMapper.selectById(orderId);
            Map<String, String> user = insProductMapper.selectUserById(insOrder.getUserId());
            //samples是不包括带有"/"的样品
            List<SampleProductDto> samples = insSampleMapper.selectSampleProductListByOrderId(orderId);
            InsReport insReport = new InsReport();
            insReport.setCode(insOrder.getEntrustCode());
@@ -593,6 +595,7 @@
            String[] monthNames = {"January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"};
            AtomicReference<String> resultCh = new AtomicReference<>("");
            AtomicReference<String> resultEn = new AtomicReference<>("");
            /*基础报告(根据绘制的原始记录模版形成)*/
            samples.forEach(a -> {
                Set<Integer> set = new HashSet<>();
                Map<Integer, String> map2 = new HashMap<>();
@@ -889,6 +892,616 @@
                    });
                });
            });
            /*光纤接头损耗的报告样式*/
            //查询订单下所有样品的检验项目,如果有光纤接头损耗则重新构建表格
            List<Map<String, Object>> tables4 = new ArrayList<>();
            List<InsProduct> insProducts0 = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery()
                    .eq(InsProduct::getState, 1)
                    .in(InsProduct::getInsSampleId, insSamples.stream().map(InsSample::getId).distinct().collect(Collectors.toList())));
            if (insProducts0.stream().map(InsProduct::getInspectionItem).collect(Collectors.toList()).contains("光纤接头损耗")) {
                //清空原有的基础表格
                tables.clear();
                //去重的检验项目
                List<String> filteredProducts = insProducts0.stream().map(insProduct -> {
                    return (insProduct.getInspectionItem() + "," + insProduct.getInspectionItemEn() + "," + insProduct.getInspectionItemSubclass() + "," + insProduct.getInspectionItemSubclassEn() + "," + insProduct.getTell());
                }).distinct().collect(Collectors.toList());
                //检验项目的总数量(去重)
                long size = filteredProducts.size();
                long number = 10;
                long number2 = 7;
                long index = 1;
                //检验结果报告(当检验项目超过10个新建表)
                for (long i = 0; i < size; i++) {
                    if (i % number == 0) {
                        List<RowRenderData> rows = new ArrayList<>();
                        //表格的行数  √ ✖ ✔
                        for (int j = 0; j < number + 3; j++) {
                            RowRenderData rowRenderData = new RowRenderData();
                            RowStyle rowStyle = new RowStyle();
                            rowStyle.setHeight(40);
                            rowRenderData.setRowStyle(rowStyle);
                            List<CellRenderData> cells = new ArrayList<>();
                            //表格的列数
                            for (int k = 0; k < 6; k++) {
                                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 (k < 4) {
                                        //前4列
                                        textRenderData.setText("规格型号@Type∑11");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    } else {
                                        //后2列
                                        textRenderData.setText(insSamples.get(0).getModel() + "∑12");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }

                                }
                                else if (j == 1) {
                                    //第二行
                                    if (k == 0) {
                                        //第一列
                                        textRenderData.setText("序号@No.∑13");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    } else if (k == 1) {
                                        //第二列
                                        textRenderData.setText("检验项目@Test Item∑14");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    } else if (k == 2 || k == 3) {
                                        //第三四列
                                        textRenderData.setText("标准要求@Requirement∑15");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    } else if (k == 4) {
                                        //第五列
                                        textRenderData.setText("检验结果@Test result∑16");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    } else {
                                        //第六列
                                        textRenderData.setText("结论@Conclusion∑17");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                }
                                else if (j == number + 2) {
                                    //最后一行
                                    if (k == 0 || k == 1) {
                                        //前两列
                                        textRenderData.setText("备注∑18");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    } else {
                                        textRenderData.setText("“✔”表示项目合格，“✖”表示项目不合格@“✔”indicates test Item is qualified，“✖”indicates test Item is unqualified∑19");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                }
                                else {
                                    if (k == 0) {
                                        //第一列
                                        textRenderData.setText((j - 1) + "");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else if (k == 1) {
                                        //第二列
                                        String insProduct = filteredProducts.get((int) ((j - 2) + 10 * (index - 1)));
                                        String[] split = insProduct.split(",");
                                        if (ObjectUtils.isEmpty(split[1]) || split[1].equals("")) {
                                            textRenderData.setText(split[0]);
                                        } else {
                                            textRenderData.setText(split[0] + "@" + split[1]);
                                        }
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else if (k == 2) {
                                        //第三列
                                        //先判断检验项是否有子类
                                        String insProduct = filteredProducts.get((int) ((j - 2) + 10 * (index - 1)));
                                        String[] split = insProduct.split(",");
                                        if (ObjectUtils.isEmpty(split[2]) || split[2].equals("")) {
                                            //如果没有子类
                                            textRenderData.setText(split[4] + "∑2" + j);//要求描述
                                        } else {
                                            //如果有子类
                                            //还要判断是否有英文
                                            if (ObjectUtils.isEmpty(split[3]) || split[3].equals("")) {
                                                textRenderData.setText(split[2]);//检验子项
                                            } else {
                                                textRenderData.setText(split[2] + "@" + split[3]);//检验子项+英文
                                            }
                                        }
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else if (k == 3) {
                                        //第四列
                                        //先判断检验项是否有子类
                                        String insProduct = filteredProducts.get((int) ((j - 2) + 10 * (index - 1)));
                                        String[] split = insProduct.split(",");
                                        if (ObjectUtils.isEmpty(split[2]) || split[2].equals("")) {
                                            //如果没有子类
                                            textRenderData.setText(split[4] + "∑2" + j);//要求描述
                                        } else {
                                            //如果有子类
                                            textRenderData.setText(split[4]);//要求描述
                                        }
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else if (k == 4) {
                                        //第五列
                                        String insProduct = filteredProducts.get((int) ((j - 2) + 10 * (index - 1)));
                                        String[] split = insProduct.split(",");
                                        //查询所有样品该检验项的检验结果(最终值)
                                        List<InsProduct> products = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery()
                                                .eq(InsProduct::getState, 1)
                                                .eq(InsProduct::getInspectionItem, split[0])
                                                .eq(InsProduct::getInspectionItemSubclass, split[2])
                                                .in(InsProduct::getInsSampleId, insSamples.stream().map(InsSample::getId).distinct().collect(Collectors.toList())));
                                        //获取最小值和最大值
                                        Optional<String> max = products.stream().map(InsProduct::getLastValue)
                                                .filter(value -> !value.isEmpty())
                                                .max(String::compareTo);
                                        Optional<String> min = products.stream().map(InsProduct::getLastValue)
                                                .filter(value -> !value.isEmpty())
                                                .min(String::compareTo);
                                        textRenderData.setText(min+"-"+max);//检验结果
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else {
                                        //最后一列
                                        String insProduct = filteredProducts.get((int) ((j - 2) + 10 * (index - 1)));
                                        String[] split = insProduct.split(",");
                                        //查询所有样品该检验项的检验结论(ins_result)
                                        List<InsProduct> products = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery()
                                                .eq(InsProduct::getState, 1)
                                                .eq(InsProduct::getInspectionItem, split[0])
                                                .eq(InsProduct::getInspectionItemSubclass, split[2])
                                                .in(InsProduct::getInsSampleId, insSamples.stream().map(InsSample::getId).distinct().collect(Collectors.toList())));
                                        List<Integer> result = products.stream().map(InsProduct::getInsResult).distinct().collect(Collectors.toList());
                                        if (result.size() == 1 && result.contains(1)) {
                                            //合格
                                            textRenderData.setText("✔");
                                        }else {
                                            //不合格
                                            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()) {
                         /* for (CellRenderData cell : row.getCells()) {
                              System.out.print(cell.getParagraphs().get(0).getContents());
                          }
                          System.out.println("");*/
                            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(14);
                        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);
                        table.put("report", insReport);
                        table.put("index", index);
                        tables.add(table);
                        index++;
                    }
                }
                long index4 = 1;
                //检验报告报告(当检验项目超过7个新建表)
                for (long j = 0; j < size; j++) {
                    if (j%number2==0){
                        List<RowRenderData> rows = new ArrayList<>();
                        //表格的行数(根据样品数量来)
                        for (int i = 0; i < samples.size() + 2; i++) {
                            RowRenderData rowRenderData = new RowRenderData();
                            RowStyle rowStyle = new RowStyle();
                            rowStyle.setHeight(40);
                            rowRenderData.setRowStyle(rowStyle);
                            List<CellRenderData> cells = new ArrayList<>();
                            //表格的列数
                            for (int k = 0; k < 8; k++) {
                                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 (i==0){
                                    //第一行
                                    if (k==0){
                                        //第一列
                                        textRenderData.setText("样品编号@Sample number∑30");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else {
                                        //第二列
                                        String product = filteredProducts.get((int) ((k - 1) + (index4 - 1) * 7));
                                        String[] split = product.split(",");
                                        if (ObjectUtils.isEmpty(split[2])||split[2].equals("")){
                                            if (ObjectUtils.isEmpty(split[1]) || split[1].equals("")){
                                                textRenderData.setText(split[0]+"∑3"+k);
                                            }else {
                                                textRenderData.setText(split[0]+"@"+split[1]+"∑3"+k);
                                            }
                                        }else {
                                            if (ObjectUtils.isEmpty(split[1]) || split[1].equals("")){
                                                textRenderData.setText(split[0]);
                                            }else {
                                                textRenderData.setText(split[0]+"@"+split[1]);
                                            }
                                        }
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                }
                                else if (i==1){
                                    //第二行
                                    if (k==0){
                                        //第一列
                                        textRenderData.setText("样品编号@Sample number∑30");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else {
                                        //第二列
                                        String product = filteredProducts.get((int) ((k - 1) + (index4 - 1) * 7));
                                        String[] split = product.split(",");
                                        if (ObjectUtils.isEmpty(split[2])||split[2].equals("")){
                                            if (ObjectUtils.isEmpty(split[1]) || split[1].equals("")){
                                                textRenderData.setText(split[0]+"∑3"+k);
                                            }else {
                                                textRenderData.setText(split[0]+"@"+split[1]+"∑3"+k);
                                            }
                                        }else {
                                            if (ObjectUtils.isEmpty(split[3]) || split[3].equals("")){
                                                textRenderData.setText(split[2]);
                                            }else {
                                                textRenderData.setText(split[2]+"@"+split[3]);
                                            }
                                        }
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                }
                                else {
                                    if (k==0){
                                        //第一列
                                        textRenderData.setText(samples.get(i-2).getSampleCode());
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else {
                                        //根据样品编号和项目去查询最终值
                                        String product = filteredProducts.get((int) ((k - 1) + (index4 - 1) * 7));
                                        String[] split = product.split(",");
                                        InsProduct insProduct = insProductMapper.selectOne(Wrappers.<InsProduct>lambdaQuery()
                                                .eq(InsProduct::getState, 1)
                                                .eq(InsProduct::getInsSampleId, samples.get(i - 2).getId())
                                                .eq(InsProduct::getInspectionItem, split[0])
                                                .eq(InsProduct::getInspectionItemSubclass, split[2]));
                                        if (ObjectUtils.isEmpty(insProduct)){
                                            //可能根据正常的样品编号和光纤接头损耗的项目查不到对应的项目,则需要根据"/"来查
                                            List<InsSample> sampleList = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().like(InsSample::getSampleCode, samples.get(i - 2).getSampleCode()));
                                            List<InsProduct> products = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery()
                                                    .eq(InsProduct::getState, 1)
                                                    .in(InsProduct::getInsSampleId, sampleList.stream().map(InsSample::getId).collect(Collectors.toList()))
                                                    .eq(InsProduct::getInspectionItem, split[0])
                                                    .eq(InsProduct::getInspectionItemSubclass, split[2]));
                                            insProduct=products.get(0);
                                        }
                                        textRenderData.setText(insProduct.getLastValue());
                                        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()) {
                                /*for (CellRenderData cell : row.getCells()) {
                                    System.out.print(cell.getParagraphs().get(0).getContents());
                                }
                                System.out.println("");*/
                            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(14);
                        tableStyle.setLeftBorder(borderStyle);
                        tableStyle.setTopBorder(borderStyle);
                        tableStyle.setRightBorder(borderStyle);
                        tableStyle.setBottomBorder(borderStyle);
                        tableRenderData.setTableStyle(tableStyle);
                        Map<String, Object> table = new HashMap<>();
                        table.put("table4", tableRenderData);
                        table.put("report", insReport);
                        table.put("index4", index4);
                        tables4.add(table);
                        index4++;
                    }
                }
                //光纤接头损耗的报告还是tables4
                //查询样品(只查询带"/")的数量
                List<InsSample> sampleList = insSamples.stream().filter(insSample -> insSample.getSampleCode().contains("/")).collect(Collectors.toList());
                //过滤出光纤接头损耗的检验项目
                List<String> strings = filteredProducts.stream().filter(s -> s.contains("光纤接头损耗")).distinct().collect(Collectors.toList());
                for (int i = 0; i < sampleList.size(); i++) {
                    if (i%16==0){
                        //样品数量超过16需要新增表格
                        List<RowRenderData> rows = new ArrayList<>();
                        //表格的行数
                        for (int j = 0; j < 17; j++) {
                            RowRenderData rowRenderData = new RowRenderData();
                            RowStyle rowStyle = new RowStyle();
                            rowStyle.setHeight(40);
                            rowRenderData.setRowStyle(rowStyle);
                            List<CellRenderData> cells = new ArrayList<>();
                            //表格的列数
                            for (int k = 0; k < 6; k++) {
                                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 (k==0){
                                        //第一列
                                        textRenderData.setText("光纤类型@Fiber type");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }else if (k==1 || k==2){
                                        //第二 三列
                                        textRenderData.setText("样品编号@Sample number");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }else {
                                        String[] split = strings.get(k - 3).split(",");
                                        if (ObjectUtils.isEmpty(split[3])|| split[3].equals("")){
                                            textRenderData.setText(split[2]);
                                        }else {
                                            textRenderData.setText(split[2]+"@"+split[3]);
                                        }
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                }
                                else {
                                    if (k==0){
                                        //第一列
                                        textRenderData.setText(sampleList.get(0).getSampleCode()+"∑44");
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else if (k==1){
                                        //第二列
                                        textRenderData.setText(sampleList.get(j-1).getSampleCode().split("/")[0]);
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else if (k==2){
                                        //第三列
                                        textRenderData.setText(sampleList.get(j-1).getSampleCode().split("/")[1]);
                                        renderData.add(textRenderData);
                                        paragraphRenderData.setContents(renderData);
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else {
                                        //根据对应的样品编号和检验项目查询对应数据(最终值)
                                        String[] split = strings.get(k - 3).split(",");
                                        InsProduct insProduct = insProductMapper.selectOne(Wrappers.<InsProduct>lambdaQuery()
                                                .eq(InsProduct::getState, 1)
                                                .eq(InsProduct::getInsSampleId, sampleList.get(j - 1).getId())
                                                .eq(InsProduct::getInspectionItem, split[0])
                                                .eq(InsProduct::getInspectionItemSubclass, split[2]));
                                        textRenderData.setText(insProduct.getLastValue());
                                        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()) {
                                /*for (CellRenderData cell : row.getCells()) {
                                    System.out.print(cell.getParagraphs().get(0).getContents());
                                }
                                System.out.println("");*/
                            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(14);
                        tableStyle.setLeftBorder(borderStyle);
                        tableStyle.setTopBorder(borderStyle);
                        tableStyle.setRightBorder(borderStyle);
                        tableStyle.setBottomBorder(borderStyle);
                        tableRenderData.setTableStyle(tableStyle);
                        Map<String, Object> table = new HashMap<>();
                        table.put("table4", tableRenderData);
                        table.put("report", insReport);
                        table.put("index4", index4+1);
                        tables4.add(table);
                        index4++;
                    }
                }
                tables4.forEach(table4 -> {
                    table4.put("tableSize4", tables4.size());
                });

            }
            String url;
            try {
                InputStream inputStream = this.getClass().getResourceAsStream("/static/report-template.docx");
@@ -952,6 +1565,8 @@
                resultCh.set("依据委托要求，所检项目均符合要求。");
                resultEn.set("According to commissioned requirements, all the tested items meet the requirements.");
            }


            /*光纤配置的检验报告*/
            //先判断是否有光纤配置
            List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery()
@@ -1142,10 +1757,10 @@
                            tableRenderData.setRows(rows);
                            int countSize = tableRenderData.getRows().get(0).getCells().size();
                            for (RowRenderData row : tableRenderData.getRows()) {
                                for (CellRenderData cell : row.getCells()) {
                                /*for (CellRenderData cell : row.getCells()) {
                                    System.out.print(cell.getParagraphs().get(0).getContents());
                                }
                                System.out.println("");
                                System.out.println("");*/
                                if (row.getCells().size() != countSize) {
                                    throw new ErrorException("每行单元格不相等");
                                }
@@ -1300,8 +1915,7 @@
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else if (j == 1) {
                                    } else if (j == 1) {
                                        //第二行
                                        if (k == 0) {
                                            //第一列
@@ -1314,8 +1928,7 @@
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else if (j == 2) {
                                    } else if (j == 2) {
                                        //第三行
                                        if (k == 0) {
                                            //第一列
@@ -1347,8 +1960,7 @@
                                                }
                                            }
                                        }
                                    }
                                    else if (j == 3) {
                                    } else if (j == 3) {
                                        //第四行
                                        if (k == 0) {
                                            //第一列
@@ -1384,8 +1996,7 @@
                                                }
                                            }
                                        }
                                    }
                                    else if (j == 4) {
                                    } else if (j == 4) {
                                        //第五行
                                        if (k == 0) {
                                            //第一列
@@ -1418,8 +2029,7 @@
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                    }
                                    else if (j == size2 + 5) {
                                    } else if (j == size2 + 5) {
                                        //倒数第三行
                                        if (k == 0) {
                                            //第一列
@@ -1496,8 +2106,7 @@
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                    }
                                    else if (j == size2 + 6) {
                                    } else if (j == size2 + 6) {
                                        //倒数第二行
                                        if (k == 0) {
                                            //第一列
@@ -1542,8 +2151,7 @@
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                    }
                                    else if (j == size2 + 7) {
                                    } else if (j == size2 + 7) {
                                        //倒数第一行
                                        textRenderData.setText("“|∆ α|”表示附加衰减绝对值∑111111");
                                        renderData.add(textRenderData);
@@ -1551,8 +2159,7 @@
                                        paragraphRenderDataList.add(paragraphRenderData);
                                        cellRenderData.setParagraphs(paragraphRenderDataList);
                                        cells.add(cellRenderData);
                                    }
                                    else {
                                    } else {
                                        //其余填写检验值的内容
                                        if (k == 0) {
                                            //第一列填写色标
@@ -1634,8 +2241,7 @@
                                            paragraphRenderDataList.add(paragraphRenderData);
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                        else if (j == 1) {
                                        } else if (j == 1) {
                                            //第二行
                                            if (k == 0) {
                                                //第一列
@@ -1648,8 +2254,7 @@
                                            paragraphRenderDataList.add(paragraphRenderData);
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                        else if (j == 2) {
                                        } else if (j == 2) {
                                            //第三行
                                            if (k == 0) {
                                                //第一列
@@ -1681,8 +2286,7 @@
                                                    }
                                                }
                                            }
                                        }
                                        else if (j == 3) {
                                        } else if (j == 3) {
                                            //第四行
                                            if (k == 0) {
                                                //第一列
@@ -1718,8 +2322,7 @@
                                                    }
                                                }
                                            }
                                        }
                                        else if (j == 4) {
                                        } else if (j == 4) {
                                            //第五行
                                            if (k == 0) {
                                                //第一列
@@ -1752,8 +2355,7 @@
                                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                                cells.add(cellRenderData);
                                            }
                                        }
                                        else if (j == size2 + 5) {
                                        } else if (j == size2 + 5) {
                                            //倒数第三行
                                            if (k == 0) {
                                                //第一列
@@ -1830,8 +2432,7 @@
                                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                                cells.add(cellRenderData);
                                            }
                                        }
                                        else if (j == size2 + 6) {
                                        } else if (j == size2 + 6) {
                                            //倒数第二行
                                            if (k == 0) {
                                                //第一列
@@ -1876,8 +2477,7 @@
                                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                                cells.add(cellRenderData);
                                            }
                                        }
                                        else if (j == size2 + 7) {
                                        } else if (j == size2 + 7) {
                                            //倒数第一行
                                            textRenderData.setText("“|∆ α|”表示附加衰减绝对值∑111111");
                                            renderData.add(textRenderData);
@@ -1885,8 +2485,7 @@
                                            paragraphRenderDataList.add(paragraphRenderData);
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                        else {
                                        } else {
                                            //其余填写检验值的内容
                                            if (k == 0) {
                                                //第一列填写色标
@@ -1923,8 +2522,7 @@
                                            }
                                        }
                                    }
                                }
                                else if (i == size1 - 1) {
                                } else if (i == size1 - 1) {
                                    //最后一次循环的列数,那么列数包括20℃(2 * (size-nm.size())+1)
                                    for (long k = 0; k < 2 * (size - nm.size()) + 1; k++) {
                                        CellRenderData cellRenderData = new CellRenderData();
@@ -1962,8 +2560,7 @@
                                            paragraphRenderDataList.add(paragraphRenderData);
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                        else if (j == 1) {
                                        } else if (j == 1) {
                                            //第二行
                                            if (k == 0) {
                                                //第一列
@@ -1976,8 +2573,7 @@
                                            paragraphRenderDataList.add(paragraphRenderData);
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                        else if (j == 2) {
                                        } else if (j == 2) {
                                            //第三行
                                            if (k == 0) {
                                                //第一列
@@ -2001,8 +2597,7 @@
                                                    }
                                                }
                                            }
                                        }
                                        else if (j == 3) {
                                        } else if (j == 3) {
                                            //第四行
                                            if (k == 0) {
                                                //第一列
@@ -2026,8 +2621,7 @@
                                                    }
                                                }
                                            }
                                        }
                                        else if (j == 4) {
                                        } else if (j == 4) {
                                            //第五行
                                            if (k == 0) {
                                                //第一列
@@ -2052,8 +2646,7 @@
                                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                                cells.add(cellRenderData);
                                            }
                                        }
                                        else if (j == size2 + 5) {
                                        } else if (j == size2 + 5) {
                                            //倒数第三行
                                            if (k == 0) {
                                                //第一列
@@ -2107,8 +2700,7 @@
                                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                                cells.add(cellRenderData);
                                            }
                                        }
                                        else if (j == size2 + 6) {
                                        } else if (j == size2 + 6) {
                                            //倒数第二行
                                            if (k == 0) {
                                                //第一列
@@ -2146,8 +2738,7 @@
                                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                                cells.add(cellRenderData);
                                            }
                                        }
                                        else if (j == size2 + 7) {
                                        } else if (j == size2 + 7) {
                                            //倒数第一行
                                            textRenderData.setText("“|∆ α|”表示附加衰减绝对值∑111111");
                                            renderData.add(textRenderData);
@@ -2155,8 +2746,7 @@
                                            paragraphRenderDataList.add(paragraphRenderData);
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                        else {
                                        } else {
                                            //其余填写检验值的内容
                                            if (k == 0) {
                                                //第一列填写色标
@@ -2185,8 +2775,7 @@
                                            }
                                        }
                                    }
                                }
                                else {
                                } else {
                                    //其余循环的列数,,那么列数不包括20℃+20℃(常温)(2 * (size- 2*nm.size()) +1)
                                    for (long k = 0; k < 2 * (size - 2 * nm.size()) + 1; k++) {
                                        CellRenderData cellRenderData = new CellRenderData();
@@ -2212,7 +2801,7 @@
                                            } else if (k > (2 * (size - 2 * nm.size()) + 1) / 4 && k <= (2 * (size - 2 * nm.size()) + 1) / 2) {
                                                //第二列
                                                textRenderData.setText(sample.getSampleCode() + "∑998");
                                            } else if (k >(2 * (size - 2 * nm.size()) + 1) / 2 && k< 2 * (size - 2 * nm.size())) {
                                            } else if (k > (2 * (size - 2 * nm.size()) + 1) / 2 && k < 2 * (size - 2 * nm.size())) {
                                                //第三列
                                                textRenderData.setText("规格型号@Type∑999");
                                            } else {
@@ -2224,8 +2813,7 @@
                                            paragraphRenderDataList.add(paragraphRenderData);
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                        else if (j == 1) {
                                        } else if (j == 1) {
                                            //第二行
                                            if (k == 0) {
                                                //第一列
@@ -2238,8 +2826,7 @@
                                            paragraphRenderDataList.add(paragraphRenderData);
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                        else if (j == 2) {
                                        } else if (j == 2) {
                                            //第三行
                                            if (k == 0) {
                                                //第一列
@@ -2263,8 +2850,7 @@
                                                    }
                                                }
                                            }
                                        }
                                        else if (j == 3) {
                                        } else if (j == 3) {
                                            //第四行
                                            if (k == 0) {
                                                //第一列
@@ -2288,8 +2874,7 @@
                                                    }
                                                }
                                            }
                                        }
                                        else if (j == 4) {
                                        } else if (j == 4) {
                                            //第五行
                                            if (k == 0) {
                                                //第一列
@@ -2314,8 +2899,7 @@
                                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                                cells.add(cellRenderData);
                                            }
                                        }
                                        else if (j == size2 + 5) {
                                        } else if (j == size2 + 5) {
                                            //倒数第三行
                                            if (k == 0) {
                                                //第一列
@@ -2369,8 +2953,7 @@
                                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                                cells.add(cellRenderData);
                                            }
                                        }
                                        else if (j == size2 + 6) {
                                        } else if (j == size2 + 6) {
                                            //倒数第二行
                                            if (k == 0) {
                                                //第一列
@@ -2408,8 +2991,7 @@
                                                cellRenderData.setParagraphs(paragraphRenderDataList);
                                                cells.add(cellRenderData);
                                            }
                                        }
                                        else if (j == size2 + 7) {
                                        } else if (j == size2 + 7) {
                                            //倒数第一行
                                            textRenderData.setText("“|∆ α|”表示附加衰减绝对值∑111111");
                                            renderData.add(textRenderData);
@@ -2417,8 +2999,7 @@
                                            paragraphRenderDataList.add(paragraphRenderData);
                                            cellRenderData.setParagraphs(paragraphRenderDataList);
                                            cells.add(cellRenderData);
                                        }
                                        else {
                                        } else {
                                            //其余填写检验值的内容
                                            if (k == 0) {
                                                //第一列填写色标
@@ -2458,10 +3039,10 @@
                        tableRenderData.setRows(rows);
                        int countSize = tableRenderData.getRows().get(0).getCells().size();
                        for (RowRenderData row : tableRenderData.getRows()) {
                            for (CellRenderData cell : row.getCells()) {
                            /*for (CellRenderData cell : row.getCells()) {
                                System.out.print(cell.getParagraphs().get(0).getContents());
                            }
                            System.out.println("");
                            System.out.println("");*/
                            if (row.getCells().size() != countSize) {
                                throw new ErrorException("每行单元格不相等");
                            }
@@ -2481,8 +3062,6 @@
                        Map<String, Object> table = new HashMap<>();
                        table.put("table3", tableRenderData);
                        table.put("report", insReport);
                        table.put("sample_number", sample.getSampleCode());
                        table.put("type", sample.getModel());
                        table.put("index3", index3);
                        tables3.add(table);
                        index3++;
@@ -2530,6 +3109,8 @@
                        put("tableSize2", tables2.size());
                        put("tables3", tables3);
                        put("tableSize3", tables3.size());
                        put("tables4", tables4);
                        put("tableSize4", tables4.size());
                        put("standardMethod", (standardMethod2.toString().equals("null") ? "" : standardMethod2));
                        put("deviceList", finalDeviceList);
                        put("twoCode", Pictures.ofLocal(codePath).create());

 inspect-server/src/main/resources/static/report-template.docx

Binary files differ