| | |
| | | style.setFontFamily("宋体"); |
| | | style.setColor("000000"); |
| | | textRenderData.setStyle(style); |
| | | if (i == 1) { |
| | | if (i == 0) { |
| | | //第一行 |
| | | textRenderData.setText("频段:" + s + "∑0" + lable); |
| | | renderData.add(textRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | } |
| | | // 处理合并单元格的问题 |
| | | String path = wordUrl + "/" + url; |
| | | try { |
| | | ZipSecureFile.setMinInflateRatio(0.0001); |
| | | FileInputStream stream = new FileInputStream(path); |
| | | XWPFDocument document = new XWPFDocument(stream); |
| | | List<XWPFTable> xwpfTables = document.getTables(); |
| | | for (int i = 0; i < xwpfTables.size(); i++) { |
| | | Set<String> set1 = new HashSet<>(); |
| | | Map<String, Map<String, Integer>> maps = new HashMap<>(); |
| | | for (int j = 0; j < xwpfTables.get(i).getRows().size(); j++) { |
| | | for (int k = 0; k < xwpfTables.get(i).getRows().get(j).getTableCells().size(); k++) { |
| | | if (xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getText().indexOf("∑") > -1) { |
| | | String[] split = xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getText().split("∑"); |
| | | if (set1.add(split[1])) { |
| | | Map<String, Integer> map = new HashMap<>(); |
| | | map.put("sr", j); |
| | | map.put("sc", k); |
| | | map.put("er", j + 0); |
| | | map.put("ec", k + 0); |
| | | maps.put(split[1], map); |
| | | } else { |
| | | Map<String, Integer> map1 = maps.get(split[1]); |
| | | if (j == map1.get("sr")) { |
| | | map1.put("ec", map1.get("ec") + 1); |
| | | } else if (k == map1.get("sc")) { |
| | | map1.put("er", map1.get("er") + 1); |
| | | } |
| | | } |
| | | String str = xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getText().split("∑")[0]; |
| | | xwpfTables.get(i).getRows().get(j).getTableCells().get(k).removeParagraph(0); |
| | | xwpfTables.get(i).getRows().get(j).getTableCells().get(k).setText(str); |
| | | xwpfTables.get(i).getRows().get(j).getTableCells().get(k).setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER); |
| | | xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getParagraphArray(0).setAlignment(org.apache.poi.xwpf.usermodel.ParagraphAlignment.CENTER); |
| | | } |
| | | } |
| | | } |
| | | |
| | | // 单元格排序, 避免格式错乱 |
| | | List<Map.Entry<String, Map<String, Integer>>> entries = new ArrayList<>(maps.entrySet()); |
| | | entries.sort((o1, o2) -> o1.getValue().get("sc") - o2.getValue().get("sc")); |
| | | |
| | | // 按照顺序添加进集合 |
| | | List<String> list = new ArrayList<>(); |
| | | for (Map.Entry<String, Map<String, Integer>> entry : entries) { |
| | | list.add(entry.getKey()); |
| | | } |
| | | /*List<String> list = new ArrayList<>(); |
| | | for (String s : maps.keySet()) { |
| | | list.add(s); |
| | | }*/ |
| | | for (int a = list.size() - 1; a >= 0; a--) { |
| | | Map<String, Integer> v = maps.get(list.get(a)); |
| | | for (int j = 0; j < v.get("er") - v.get("sr") + 1; j++) { |
| | | if (v.get("ec") > v.get("sc")) { |
| | | try { |
| | | TableTools.mergeCellsHorizonal(xwpfTables.get(i), v.get("sr") + j, v.get("sc"), v.get("ec")); |
| | | } catch (Exception e) { |
| | | } |
| | | } |
| | | } |
| | | if (v.get("er") > v.get("sr")) { |
| | | try { |
| | | TableTools.mergeCellsVertically(xwpfTables.get(i), v.get("sc"), v.get("sr"), v.get("er")); |
| | | } catch (Exception e) { |
| | | } |
| | | } |
| | | } |
| | | } |
| | | FileOutputStream fileOutputStream = new FileOutputStream(path); |
| | | document.write(fileOutputStream); |
| | | fileOutputStream.close(); |
| | | } catch (FileNotFoundException e) { |
| | | throw new RuntimeException(e); |
| | | } catch (IOException e) { |
| | | throw new RuntimeException(e); |
| | | } |
| | | // try { |
| | | // ZipSecureFile.setMinInflateRatio(0.0001); |
| | | // FileInputStream stream = new FileInputStream(path); |
| | | // XWPFDocument document = new XWPFDocument(stream); |
| | | // List<XWPFTable> xwpfTables = document.getTables(); |
| | | // for (int i = 0; i < xwpfTables.size(); i++) { |
| | | // Set<String> set1 = new HashSet<>(); |
| | | // Map<String, Map<String, Integer>> maps = new HashMap<>(); |
| | | // for (int j = 0; j < xwpfTables.get(i).getRows().size(); j++) { |
| | | // for (int k = 0; k < xwpfTables.get(i).getRows().get(j).getTableCells().size(); k++) { |
| | | // if (xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getText().indexOf("∑") > -1) { |
| | | // String[] split = xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getText().split("∑"); |
| | | // if (set1.add(split[1])) { |
| | | // Map<String, Integer> map = new HashMap<>(); |
| | | // map.put("sr", j); |
| | | // map.put("sc", k); |
| | | // map.put("er", j + 0); |
| | | // map.put("ec", k + 0); |
| | | // maps.put(split[1], map); |
| | | // } else { |
| | | // Map<String, Integer> map1 = maps.get(split[1]); |
| | | // if (j == map1.get("sr")) { |
| | | // map1.put("ec", map1.get("ec") + 1); |
| | | // } else if (k == map1.get("sc")) { |
| | | // map1.put("er", map1.get("er") + 1); |
| | | // } |
| | | // } |
| | | // String str = xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getText().split("∑")[0]; |
| | | // xwpfTables.get(i).getRows().get(j).getTableCells().get(k).removeParagraph(0); |
| | | // xwpfTables.get(i).getRows().get(j).getTableCells().get(k).setText(str); |
| | | // xwpfTables.get(i).getRows().get(j).getTableCells().get(k).setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER); |
| | | // xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getParagraphArray(0).setAlignment(org.apache.poi.xwpf.usermodel.ParagraphAlignment.CENTER); |
| | | // } |
| | | // } |
| | | // } |
| | | // |
| | | // // 单元格排序, 避免格式错乱 |
| | | // List<Map.Entry<String, Map<String, Integer>>> entries = new ArrayList<>(maps.entrySet()); |
| | | // entries.sort((o1, o2) -> o1.getValue().get("sc") - o2.getValue().get("sc")); |
| | | // |
| | | // // 按照顺序添加进集合 |
| | | // List<String> list = new ArrayList<>(); |
| | | // for (Map.Entry<String, Map<String, Integer>> entry : entries) { |
| | | // list.add(entry.getKey()); |
| | | // } |
| | | // /*List<String> list = new ArrayList<>(); |
| | | // for (String s : maps.keySet()) { |
| | | // list.add(s); |
| | | // }*/ |
| | | // for (int a = list.size() - 1; a >= 0; a--) { |
| | | // Map<String, Integer> v = maps.get(list.get(a)); |
| | | // for (int j = 0; j < v.get("er") - v.get("sr") + 1; j++) { |
| | | // if (v.get("ec") > v.get("sc")) { |
| | | // try { |
| | | // TableTools.mergeCellsHorizonal(xwpfTables.get(i), v.get("sr") + j, v.get("sc"), v.get("ec")); |
| | | // } catch (Exception e) { |
| | | // } |
| | | // } |
| | | // } |
| | | // if (v.get("er") > v.get("sr")) { |
| | | // try { |
| | | // TableTools.mergeCellsVertically(xwpfTables.get(i), v.get("sc"), v.get("sr"), v.get("er")); |
| | | // } catch (Exception e) { |
| | | // } |
| | | // } |
| | | // } |
| | | // } |
| | | // FileOutputStream fileOutputStream = new FileOutputStream(path); |
| | | // document.write(fileOutputStream); |
| | | // fileOutputStream.close(); |
| | | // } catch (FileNotFoundException e) { |
| | | // throw new RuntimeException(e); |
| | | // } catch (IOException e) { |
| | | // throw new RuntimeException(e); |
| | | // } |
| | | InsOrderFile insOrderFile = new InsOrderFile(); |
| | | insOrderFile.setInsOrderId(insOrderState.getInsOrderId()); |
| | | insOrderFile.setInsSampleId(insOrderState.getInsSampleId()); |
| | |
| | | } |
| | | result2VOS.add(insProductResult2VO1); |
| | | } |
| | | } else { |
| | | } |
| | | else { |
| | | insProductResult2VO.setValue(value.replace("\"", "")); |
| | | result2VOS.add(insProductResult2VO); |
| | | } |
| | |
| | | SampleProductDto insSample = insSampleMapper.selectSampleProductListByOrderId(insReportDto1.getSampleId()); |
| | | SampleProductDto s = insSample; |
| | | List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery() |
| | | .isNotNull(InsProduct::getInsResult) |
| | | .eq(InsProduct::getInsSampleId, insSample.getId()) |
| | | .eq(InsProduct::getState, 1)); |
| | | /*首页*/ |
| | |
| | | )); |
| | | insOrderDocFiles.addAll(insOrderFiles); |
| | | radiationReportNum = insOrderFiles.size(); |
| | | // if (insOrderFiles.size() > 0) { |
| | | // int aa = 0; |
| | | // for (InsOrderFile insOrderFile : insOrderFiles) { |
| | | // try { |
| | | // XWPFDocument circuitParamsDoc = new XWPFDocument(new FileInputStream(wordUrl + "/" + insOrderFile.getFileUrl())); |
| | | // // 遍历电路参数文件的所有元素,段落和表格 |
| | | // for (IBodyElement element : circuitParamsDoc.getBodyElements()) { |
| | | // Map<String, Object> table3 = new HashMap<>(); |
| | | // TableRenderData tableData = new TableRenderData(); |
| | | // List<RowRenderData> rows = new ArrayList<>(); |
| | | // if (element instanceof XWPFTable) { |
| | | // aa += 1; |
| | | // XWPFTable tab = (XWPFTable) element; |
| | | // List<XWPFTableRow> row = tab.getRows(); |
| | | // for (int i = 0; i < row.size(); i++) { |
| | | // RowRenderData rowRenderData = new RowRenderData(); |
| | | // List<CellRenderData> cells = new ArrayList<>(); |
| | | // List<XWPFTableCell> cell = row.get(i).getTableCells(); |
| | | // for (int j = 0; j < cell.size(); j++) { |
| | | // CellRenderData cellRenderData = new CellRenderData(); |
| | | // 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); |
| | | // CTTcPr tcPr = cell.get(j).getCTTc().getTcPr(); |
| | | // if (tcPr != null) { |
| | | // //合并列 |
| | | // CTHMerge hMerge = tcPr.getHMerge(); |
| | | // if (ObjectUtils.isNotEmpty(hMerge)) { |
| | | // if (STMerge.RESTART.equals(hMerge.getVal()) || STMerge.CONTINUE.equals(hMerge.getVal())) { |
| | | // int index = j; |
| | | // String text = null; |
| | | // while (text == null || text.equals("")) { |
| | | // if (index < 0) { |
| | | // text = "/"; |
| | | // } |
| | | // text = cell.get(index).getText(); |
| | | // index--; |
| | | // } |
| | | // textRenderData.setText(text + "∑88" + aa + i); |
| | | // } |
| | | // } |
| | | // //合并行 |
| | | // CTVMerge vMerge = tcPr.getVMerge(); |
| | | // if (ObjectUtils.isNotEmpty(vMerge)) { |
| | | // if (STMerge.RESTART.equals(vMerge.getVal()) || STMerge.CONTINUE.equals(vMerge.getVal())) { |
| | | // int index = i; |
| | | // String text = null; |
| | | // while (text == null || text.equals("")) { |
| | | // if (index < 0) { |
| | | // text = "/"; |
| | | // break; |
| | | // } |
| | | // text = row.get(index).getCell(j).getText(); |
| | | // index--; |
| | | // } |
| | | // if (text.equals("合格") || text.equals("不合格")) { |
| | | // textRenderData.setText(text + "∑25" + aa + j); |
| | | // } else { |
| | | // textRenderData.setText(text + "∑22" + aa + j); |
| | | // } |
| | | // } |
| | | // } |
| | | // } else { |
| | | // textRenderData.setText(cell.get(j).getText()); |
| | | // } |
| | | // renderData.add(textRenderData); |
| | | // paragraphRenderData.setContents(renderData); |
| | | // paragraphRenderDataList.add(paragraphRenderData); |
| | | // cellRenderData.setParagraphs(paragraphRenderDataList); |
| | | // cells.add(cellRenderData); |
| | | // } |
| | | // rowRenderData.setCells(cells); |
| | | // rows.add(rowRenderData); |
| | | // } |
| | | // tableData.setRows(rows); |
| | | // table3.put("table3", tableData); |
| | | // tables3.add(table3); |
| | | // } |
| | | // } |
| | | // } catch (IOException e) { |
| | | // e.printStackTrace(); |
| | | // } |
| | | // } |
| | | // } |
| | | } |
| | | //辐射的标题 |
| | | String title3 = ""; |
| | | if (radiationReportNum > 0) { |
| | | title3 = "辐射方向图参数"; |
| | | title3 = "辐射性能参数"; |
| | | } |
| | | //环境表格 |
| | | List<Map<String, Object>> tables4 = new ArrayList<>(); |
| | |
| | | private void getWord1(String term, InsOrderState insOrderState, List<Map<String, Object>> tables2) { |
| | | AtomicInteger lable = new AtomicInteger(1); |
| | | AtomicInteger index = new AtomicInteger(); |
| | | String title = term + "电路参数"; |
| | | String title = term + "电性能参数"; |
| | | InsSample insSample = insSampleMapper.selectById(insOrderState.getInsSampleId()); |
| | | //查询项目 |
| | | List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery() |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | if (i % 2 == 0) { |
| | | //最差值 |
| | | String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", ""); |
| | | String text = value.split(",")[(j - 5) + (i - 1) / 2 * (Math.min(ports, 8))]; |
| | | try { |
| | | textRenderData.setText(value.split(",")[(j - 5) + (i - 1) / 2 * (Math.min(ports, 8))]); |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text))); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | } 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)); |
| | | String text = value.split(",")[(j - 6) / 2 + (i - cc - 1) * 4]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 6)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | } else { |
| | | String value = result2s.get(0).getValue().replaceAll("[\\[\\]\"]", ""); |
| | | try { |
| | | textRenderData.setText(value.split(",")[(j - 5) / 2 + (i - cc - 1) * 4] + "∑5" + i + (j - 5)); |
| | | String text = value.split(",")[(j - 5) / 2 + (i - cc - 1) * 4]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 5)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | } 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)); |
| | | String text = value.split(",")[(j - 6) / 2 + (i - (dd == 0 ? cc : dd) - 1) * 4]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 6)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | } 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)); |
| | | String text = value.split(",")[(j - 5) / 2 + (i - (dd == 0 ? cc : dd) - 1) * 4]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 5)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | } 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)); |
| | | String text = value.split(",")[(j - 6) / 2 + (i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) - 1) * 4]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 6)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | } 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)); |
| | | String text = value.split(",")[(j - 5) / 2 + (i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) - 1) * 4]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 5)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | } 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)); |
| | | String text = value.split(",")[(j - 6) / 2 + (i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) - 1) * 4]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 6)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | } 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)); |
| | | String text = value.split(",")[(j - 5) / 2 + (i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff) - 1) * 4]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 5)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | 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)))]); |
| | | String text = 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)))]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text))); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | 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))]); |
| | | String text = split[(j - 5) + ((i + (angles - 1)) / (angles + 1) - 1) * (Math.min(ports, 8))]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text))); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | 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)); |
| | | String text = split[(j - 6) / 2 + ((i - cc) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑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)); |
| | | String text = split[(j - 5) / 2 + ((i - cc) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 5)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | 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)); |
| | | String text = split[(j - 6) / 2 + ((i - (dd == 0 ? cc : dd)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑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)); |
| | | String text = split[(j - 5) / 2 + ((i - (dd == 0 ? cc : dd)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 5)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | 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)); |
| | | String text = split[(j - 6) / 2 + ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑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)); |
| | | String text = split[(j - 5) / 2 + ((i - (ee == 0 ? ((dd == 0 ? cc : dd)) : ee)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 5)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | 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)); |
| | | String text = split[(j - 6) / 2 + ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑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)); |
| | | String text = split[(j - 5) / 2 + ((i - (ff == 0 ? (ee == 0 ? ((dd == 0 ? cc : dd)) : ee) : ff)) / (angles + 2)) * (ports > 8 ? 4 : (ports + 1) / 2)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text)) + "∑5" + i + (j - 5)); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | 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)))]); |
| | | String text = 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)))]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text))); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | //最差值 |
| | | String[] value = result2s.get(0).getValue().split("\\],\\["); |
| | | String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(","); |
| | | textRenderData.setText(split[0] + "∑7" + i); |
| | | String text = split[0]; |
| | | if (ObjectUtils.isEmpty(text)){ |
| | | textRenderData.setText("" + "∑7" + i); |
| | | }else { |
| | | textRenderData.setText(String.format("%.2f", Double.parseDouble(text)) + "∑7" + i); |
| | | } |
| | | } |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | //最差值 |
| | | String[] value = result2s.get(0).getValue().split("\\],\\["); |
| | | String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(","); |
| | | textRenderData.setText(split[0] + "∑7" + i); |
| | | String text = split[0]; |
| | | if (ObjectUtils.isEmpty(text)){ |
| | | textRenderData.setText("" + "∑7" + i); |
| | | }else { |
| | | textRenderData.setText(String.format("%.2f", Double.parseDouble(text)) + "∑7" + i); |
| | | } |
| | | } |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | 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)]); |
| | | String text = 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)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text))); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | 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)]); |
| | | String text = 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)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text))); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | String[] value = result2s.get(0).getValue().split("\\],\\["); |
| | | String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(","); |
| | | try { |
| | | textRenderData.setText(split[(j - 5) + ((i - rr) / (angles + 2)) * Math.min(length, 8)]); |
| | | String text = split[(j - 5) + ((i - rr) / (angles + 2)) * Math.min(length, 8)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text))); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | cells.add(cellRenderData); |
| | | } else if (j == 3) { |
| | | //第四列 |
| | | textRenderData.setText(products.get(0).getAsk() + "∑4" + index); |
| | | textRenderData.setText(ObjectUtils.isNull(result2s.get(0).getAsk())?products.get(0).getAsk():result2s.get(0).getAsk() + "∑4" + index); |
| | | renderData.add(textRenderData); |
| | | paragraphRenderData.setContents(renderData); |
| | | paragraphRenderDataList.add(paragraphRenderData); |
| | |
| | | String[] value = result2s.get(0).getValue().split("\\],\\["); |
| | | String[] split = value[(i + (angles - 1)) % (angles + 1)].replaceAll("[\\[\\]\"]", "").split(","); |
| | | try { |
| | | textRenderData.setText(split[(j - 5) + ((i - ss) / (angles + 2)) * Math.min(length, 8)]); |
| | | String text = split[(j - 5) + ((i - ss) / (angles + 2)) * Math.min(length, 8)]; |
| | | textRenderData.setText(String.format("%.2f",Double.parseDouble(text))); |
| | | } catch (Exception e) { |
| | | textRenderData.setText(""); |
| | | } |
| | |
| | | //电路报告用于总报告的方法(无源器件) |
| | | private void getWord2(String term, InsOrderState insOrderState, List<Map<String, Object>> tables2) { |
| | | AtomicInteger index = new AtomicInteger(); |
| | | String title = term + "电路参数"; |
| | | String title = term + "电性能参数"; |
| | | //查询样品 |
| | | InsSample insSample = insSampleMapper.selectById(insOrderState.getInsSampleId()); |
| | | //查询项目 |
| | |
| | | List<RowRenderData> rows = new ArrayList<>(); |
| | | Set<String> itemSet = new HashSet<>(); |
| | | //表格的行数 |
| | | for (int i = 0; i < result2VOS.size()+1; i++) { |
| | | for (int i = 0; i < result2VOS.size(); i++) { |
| | | RowRenderData rowRenderData = new RowRenderData(); |
| | | RowStyle rowStyle = new RowStyle(); |
| | | rowStyle.setHeight(40); |