From 10b6c791f1a137ac97cce6844482649fc859309b Mon Sep 17 00:00:00 2001 From: 吴祝攀 <2040239371@qq.com> Date: 星期三, 26 六月 2024 16:25:33 +0800 Subject: [PATCH] 1.LAQ全景图 2.获取地址优化 --- src/main/java/com/ots/common/utils/poi/WordUtil.java | 215 +++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 188 insertions(+), 27 deletions(-) diff --git a/src/main/java/com/ots/common/utils/poi/WordUtil.java b/src/main/java/com/ots/common/utils/poi/WordUtil.java index 7b702b0..e0c6e8c 100644 --- a/src/main/java/com/ots/common/utils/poi/WordUtil.java +++ b/src/main/java/com/ots/common/utils/poi/WordUtil.java @@ -16,9 +16,13 @@ import com.ots.project.tool.ShellTool; import com.ots.project.tool.exam.ExamUtil; import com.ots.project.tool.exam.ImageUtil; +import com.ots.project.tool.exam.JsonUtil; import com.ots.project.tool.exam.ZipUtil; import com.ots.project.tool.libreoffice.LibreOfficeUtil; +import com.ots.project.tool.report.APIFan.chart.APIFanChart; import com.ots.project.tool.report.CIAQ.chart.CIAQChart; +import com.ots.project.tool.report.JAQ.condition.JAQTeam; +import com.ots.project.tool.report.LAQ.chart.LAQAllChart; import com.ots.project.tool.report.LAQ.chart.LAQChart; import com.ots.project.tool.report.MAQTR.chart.MAQTRChart; import com.ots.project.tool.report.PAQ.chart.PAQChart; @@ -41,8 +45,11 @@ import org.slf4j.LoggerFactory; import org.w3c.dom.Node; import org.w3c.dom.NodeList; +import springfox.documentation.spring.web.json.Json; + import java.awt.image.BufferedImage; import java.io.*; +import java.time.LocalDate; import java.util.*; import java.util.regex.Matcher; import java.util.regex.Pattern; @@ -313,6 +320,7 @@ log.info("琛ㄦ牸鏁版嵁锛�" + table.getText()); //澧炲姞琛ㄦ牸鎴栬�呮笡灏戣〃鏍� if (Objects.equals(textMap.get("sendEmailFileName"), ReportTypeEnum.JAQ.getCode())) { + log.info("琛細{}",i); addOrDelTableRow(table,i,textMap); } if (checkText(table.getText())) { @@ -340,12 +348,15 @@ Integer tableNum = Integer.valueOf(textMap.get(tableEnum.getName()).toString()); Integer rows = table.getRows().size(); + log.info("[娴嬭瘯]-tableEnum锛�"+tableEnum.toString()); + //琛�1-琛�3 闇�鍓旈櫎琛ㄥご Integer contentRows = rows - 1; //琛�4 闇�鍓旈櫎琛ㄥご璺熷熬閮ㄩ鐣欒鏁� if(tableEnum == TableEnum.table4){ - contentRows -= 5; - rows -= 5; + //濡傛灉琛�4锛岃澧炲姞鏄剧ず琛岋紝杩欓噷瑕佹敼鍔� + contentRows -= 3; + rows -= 3; //琛�4 琛屼负琛ㄧ幇涓句緥澶勭悊 Integer table4ChildrenNum = Integer.valueOf(textMap.get(TableEnum.table4Children.getName()).toString()); @@ -387,30 +398,34 @@ } } - //闄愬埗琛屾暟涓嶄负绌� 鍜� 闄愬埗琛屾暟璺熸姤鍛婄幇鏈変笉涓�鑷撮渶杩涜澶勭悊 - if(tableNum != null && !tableNum.equals(contentRows)){ - if(tableNum > contentRows){ - //澧炲姞琛屾暟 - Integer addRow = tableNum - contentRows; - log.info("{}澧炲姞{}琛�",tableEnum.getName(),addRow); - for (int i = rows; i < rows+addRow; i++) { - addJAQTable(table,tableEnum,i,textMap); - } + //table5涓嶉渶瑕佽拷鍔狅紝鍗曠嫭澶勭悊 + if(tableEnum != TableEnum.table5) { + //闄愬埗琛屾暟涓嶄负绌� 鍜� 闄愬埗琛屾暟璺熸姤鍛婄幇鏈変笉涓�鑷撮渶杩涜澶勭悊 + if (tableNum != null && !tableNum.equals(contentRows)) { + if (tableNum > contentRows) { + //澧炲姞琛屾暟 + Integer addRow = tableNum - contentRows; + log.info("{}澧炲姞{}琛�", tableEnum.getName(), addRow); + for (int i = rows; i < rows + addRow; i++) { + addJAQTable(table, tableEnum, i, textMap); + } - }else{ - //鍑忓皯琛屾暟 - Integer delRow = rows - tableNum; - for (int i = contentRows; i > rows-delRow; i--) { - delJAQTable(table,i); + } else { + //鍑忓皯琛屾暟 + Integer delRow = rows - tableNum; + for (int i = contentRows; i > rows - delRow; i--) { + delJAQTable(table, i); + } + log.info("{}鍑忓皯{}琛屾暟", TableEnum.codeOf(index).getName(), delRow - 1); } - log.info("{}鍑忓皯{}琛屾暟",TableEnum.codeOf(index).getName(),delRow-1); } } + //濡傛灉琛�4锛岃澧炲姞鏄剧ず琛岋紝杩欓噷瑕佹敼鍔� //琛�4 鑳滀换鍔涢鐣欎綅缃簭鍙峰鐞� if(tableEnum == TableEnum.table4){ - if(tableNum != null && tableNum != 8){ - for (int i = tableNum; i <= tableNum + 4; i++) { + if(tableNum != null && tableNum != 12){ + for (int i = tableNum; i <= tableNum + 2; i++) { if(i+2 > table.getRows().size()){ continue; } @@ -420,9 +435,38 @@ } } } + + + //琛�6锛屾樉绀篔AQ鎶ュ憡鍙備笌浜� + if(tableEnum == TableEnum.table5) + { + log.info("銆愯〃5銆戝紑濮嬪鐞�...{}",tableNum); +// if(tableNum != null && !tableNum.equals(contentRows)) { +// if (tableNum > contentRows) { +// //澧炲姞琛屾暟 +// Integer addRow = tableNum - contentRows; +// log.info("{}澧炲姞{}琛�", tableEnum.getName(), addRow); +// for (int i = rows; i < rows + addRow; i++) { +// addJAQTable(table, tableEnum, i, textMap); +// } +// } +// } + if(tableNum>0) + { + for(int i=rows;i<rows+tableNum;i++) + { + addJAQTable(table, tableEnum, i, textMap); + } + + delJAQTable(table,1); + } + log.info("銆愯〃5銆戝鐞嗗畬鎴�..."); + } + }catch (Exception e){ e.printStackTrace(); log.info("琛▄}澧炲姞琛ㄦ牸鎴栬�呮笡灏戣〃鏍煎紓甯�",index+1); + log.info("寮傚父锛歿}",e.getMessage()); } } @@ -474,6 +518,7 @@ XWPFTableRow row = table.getRows().get(index); List<XWPFTableCell> cells = row.getTableCells(); + switch (tableEnum){ case table1: cells.get(0).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T1rank"+index)+""); @@ -544,6 +589,48 @@ cell.getParagraphs().get(cell.getParagraphs().size()-1).getRuns().get(0).setText(null); } } + break; + case table5: + log.info("[add] table5,澧炲姞琛屻�俰ndex={}",index); + String teamUsers = textMap.get("teamUserList").toString(); + List<JAQTeam> teamUserList = JsonUtil.toJsonListObject(teamUsers,JAQTeam.class); + + int keyIndex = index-2; + if(keyIndex>=0) + { + log.info("褰撳墠keyIndex:{}",keyIndex); + for(int k =0;k<3;k++) + { + XWPFParagraph p =cells.get(k).getParagraphs().get(0); + List<XWPFRun> runs = p.getRuns(); + if(runs.isEmpty()) + { + p.createRun(); + } + for (int i = runs.size()-1;i>0;i--) + { + p.removeRun(i); + } + XWPFRun run = runs.get(0); + + switch (k){ + case 0:run.setText(String.valueOf(keyIndex+1),0); break; + case 1:run.setText(teamUserList.get(keyIndex).getTeamName(),0);break; + case 2:run.setText(teamUserList.get(keyIndex).getTeamDepart(),0);break; + case 3:run.setText(teamUserList.get(keyIndex).getTeamName(),0);break; + default:break; + } + } + } + + + + + +// cells.get(0).getParagraphs().get(0).getRuns().get(0).setText(index.toString()); +// cells.get(1).getParagraphs().get(0).getRuns().get(0).setText(teamUserList.get(index).getTeamName()); +// cells.get(2).getParagraphs().get(0).getRuns().get(0).setText(teamUserList.get(index).getTeamDepart()); +// cells.get(3).getParagraphs().get(0).getRuns().get(0).setText(teamUserList.get(index).getTeamName()); break; } } @@ -1181,9 +1268,9 @@ changColorIfJAQ(textMap, out, reportName, tReportTemplate.getReportType()); //} - //PAQ銆丮AQTR閲囩敤銆丆IAQ鏂扮殑doc杞琾df + //PAQ銆丮AQTR閲囩敤銆丆IAQ銆丄PIFan鏂扮殑doc杞琾df if(ReportTypeEnum.PAQ.getCode().equals(reportType) || ReportTypeEnum.MAQTR.getCode().equals(reportType) - || ReportTypeEnum.CIAQ.getCode().equals(reportType)){ + || ReportTypeEnum.CIAQ.getCode().equals(reportType) ||ReportTypeEnum.API_Fan.getCode().equals(reportType)){ PdfUtil.convertPDF(EssConfig.getProfile() + "/" + reportName); }else if(ReportTypeEnum.LAQ.getCode().equals(reportType)){ PdfUtil.dockerConvertPDF(EssConfig.getProfile(),EssConfig.getDocx2pdfPath(),reportName); @@ -1290,11 +1377,28 @@ XWPFDocument document = new XWPFDocument(POIXMLDocument.openPackage(getTemplateDownLoadPathByUpLoad(fileName))); - //璁剧疆鏂囨湰 - changeText(document, textMap); + if (StringUtils.equals(reportType, ReportTypeEnum.JAQ.getCode())) { + //璁剧疆鏂囨湰妗� + changeTextBox(document, textMap); - //璁剧疆鏂囨湰妗� - changeTextBox(document, textMap); + //璁剧疆鏂囨湰 + changeText(document, textMap); + }else { + //璁剧疆鏂囨湰 + changeText(document, textMap); + + //璁剧疆鏂囨湰妗� + changeTextBox(document, textMap); + } + +// //璁剧疆鏂囨湰妗� +// changeTextBox(document, textMap); +// +// //璁剧疆鏂囨湰 +// changeText(document, textMap); + + //淇敼椤佃剼 + changeFootNotes(document,textMap); //鎻掑叆琛ㄦ牸 addTableValue(document, autoTableMap); @@ -1306,6 +1410,49 @@ changChart(textMap, document, reportType,dataPath); document.write(out); } + + /** + * 淇敼椤佃剼锛堜富瑕佹槸鎶婂勾闄愮粰鎹簡锛� + * @param document + * @param textMap + * @throws DocumentException + */ + private static void changeFootNotes(XWPFDocument document,Map<String,Object> textMap) throws DocumentException{ + + LocalDate currentDate = LocalDate.now(); + int year = currentDate.getYear(); + + // 鑾峰彇鎵�鏈夐〉 + List<XWPFFooter> footers = document.getFooterList(); + + for (XWPFFooter footer : footers) { + // 鑾峰彇姣忎釜椤佃剼鐨勬钀� + List<XWPFParagraph> paragraphs = footer.getParagraphs(); + + // 鎵撳嵃姣忎釜娈佃惤鐨勬枃鏈� + for (XWPFParagraph paragraph : paragraphs) { + System.out.println(paragraph.getText()); + + log.info("銆愰〉鑴氥�戯細{}",paragraph.getText()); + if(paragraph.getText().contains("%year%")) + { + // 鑾峰彇娈佃惤涓殑鎵�鏈塺un + List<XWPFRun> runs = paragraph.getRuns(); + + // 鏇挎崲鏂囨湰 + for (XWPFRun run : runs) { + String text = run.getText(0); + if (text != null && text.contains("%year%")) { + text = text.replace("%year%", String.valueOf(year)); + run.setText(text, 0); + } + } + } + } + } + + } + private static void changeTextBox(XWPFDocument document, Map<String, Object> textMap) throws DocumentException { List<XWPFParagraph> paragraphs = document.getParagraphs(); @@ -1417,8 +1564,22 @@ } else if (StringUtils.equals(reportType, ReportTypeEnum.CIAQ.getCode())) { CIAQChart.changeChart(document, textMap); } else if (StringUtils.equals(reportType, ReportTypeEnum.LAQ.getCode())) { - LAQChart.changeChart(document, textMap); - } else { + if(!textMap.containsKey("allList")) + { + System.out.println("涓汉鐢ㄦ埛鎶ュ憡"); + LAQChart.changeChart(document, textMap); + } + else + { + System.out.println("鍏ㄦ櫙鍥炬姤鍛�"); + //濡傛灉鍖呭惈allList锛屽垯娓叉煋鍏ㄦ櫙鍥惧浘琛� + LAQAllChart.changeChart(document,textMap); + } + } else if(StringUtils.equals(reportType, ReportTypeEnum.API_Fan.getCode())) + { + APIFanChart.changeChart(document,textMap); + } + else { return; } }catch (Exception e){ -- Gitblit v1.9.1