From a81f8f5009f2ec48890f722c533b8cf1cee14c52 Mon Sep 17 00:00:00 2001
From: zhijie <1003392067@qq.com>
Date: 星期三, 16 三月 2022 02:28:36 +0800
Subject: [PATCH] JAQ自定义公式支持完善
---
src/main/java/com/ots/common/utils/poi/WordUtil.java | 462 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 447 insertions(+), 15 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 2f7182f..3039402 100644
--- a/src/main/java/com/ots/common/utils/poi/WordUtil.java
+++ b/src/main/java/com/ots/common/utils/poi/WordUtil.java
@@ -1,7 +1,10 @@
package com.ots.common.utils.poi;
import cn.hutool.core.collection.CollUtil;
+import com.alibaba.fastjson.JSON;
+import com.alibaba.fastjson.JSONObject;
import com.ots.common.enums.ReportTypeEnum;
import com.ots.common.enums.ReportTypeNameEnum;
+import com.ots.common.enums.TableEnum;
import com.ots.common.enums.TemplateTypeEnum;
import com.ots.common.utils.StringUtils;
import com.ots.framework.config.EssConfig;
@@ -14,12 +17,7 @@
import com.ots.project.tool.exam.ExamUtil;
import com.ots.project.tool.exam.ImageUtil;
import com.ots.project.tool.exam.ZipUtil;
-import com.ots.project.tool.report.JAQ.condition.Table1;
-import com.ots.project.tool.report.JAQ.condition.Table2;
-import com.ots.project.tool.report.JAQ.condition.Table3;
-import com.ots.project.tool.report.JAQ.condition.Table4;
import com.ots.project.tool.report.PAQ.chart.PAQChart;
-import com.ots.project.tool.report.SAQ.chart.SAQChart;
import org.apache.commons.collections.map.HashedMap;
import org.apache.poi.ooxml.POIXMLDocument;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
@@ -33,9 +31,7 @@
import org.openxmlformats.schemas.drawingml.x2006.chart.*;
import org.openxmlformats.schemas.drawingml.x2006.main.CTGraphicalObject;
import org.openxmlformats.schemas.drawingml.x2006.wordprocessingDrawing.CTAnchor;
-import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTDrawing;
-import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTPPr;
-import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTR;
+import org.openxmlformats.schemas.wordprocessingml.x2006.main.*;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.w3c.dom.Node;
@@ -294,6 +290,13 @@
List<XWPFTable> tables = document.getTables();
setTableValue(document, textMap, tables);
}
+
+ /**
+ * 璁剧疆琛ㄦ牸鍊�
+ * @param document
+ * @param textMap
+ * @param tables
+ */
private static void setTableValue(XWPFDocument document, Map<String, Object> textMap, List<XWPFTable> tables) {
for (int i = 0; i < tables.size(); i++) {
@@ -301,8 +304,10 @@
try {
XWPFTable table = tables.get(i);
if (table.getRows().size() > 0) {
-
+ log.info("琛ㄨ鏁�:{}",table.getRows().size());
log.info("琛ㄦ牸鏁版嵁锛�" + table.getText());
+ //澧炲姞琛ㄦ牸鎴栬�呮笡灏戣〃鏍�
+ addOrDelTableRow(table,i,textMap);
if (checkText(table.getText())) {
List<XWPFTableRow> rows = table.getRows();
@@ -314,7 +319,412 @@
}
}
}
-
+
+ /**
+ * 澧炲姞琛ㄦ牸鎴栬�呮笡灏戣〃鏍�
+ * @param table 琛ㄦ牸
+ * @param index 琛ㄧ储寮�
+ * @param textMap 璧嬪�煎璞�
+ */
+ private static void addOrDelTableRow(XWPFTable table, int index, Map<String, Object> textMap) {
+
+ try {
+ TableEnum tableEnum = TableEnum.codeOf(index);
+ Integer tableNum = Integer.valueOf(textMap.get(tableEnum.getName()).toString());
+ Integer rows = table.getRows().size();
+
+ //琛�1-琛�3 闇�鍓旈櫎琛ㄥご
+ Integer contentRows = rows - 1;
+ //琛�4 闇�鍓旈櫎琛ㄥご璺熷熬閮ㄩ鐣欒鏁�
+ if(tableEnum == TableEnum.table4){
+ contentRows -= 5;
+ rows -= 5;
+
+
+ //琛�4 琛屼负琛ㄧ幇涓句緥澶勭悊
+ Integer table4ChildrenNum = Integer.valueOf(textMap.get(TableEnum.table4Children.getName()).toString());
+ if(table4ChildrenNum != null && table4ChildrenNum != 3){
+ if(table4ChildrenNum > 3){
+ //杩藉姞
+ for (int i = 1; i < rows; i++) {
+ XWPFTableRow row = table.getRows().get(i);
+ List<XWPFTableCell> cells = row.getTableCells();
+ XWPFTableCell cell = cells.get(1);
+ XWPFParagraph paragraph = cell.getParagraphs().get(0);
+ for (int j = 3; j < cell.getParagraphs().size(); j++) {
+ //log.info(cell.getParagraphs().get(j).getText()+"");
+ //璁剧疆鏍峰紡
+ cell.getParagraphs().get(j).getCTP().setPPr(cell.getParagraphs().get(0).getCTP().getPPr());
+ if (paragraph.getRuns() != null
+ && paragraph.getRuns().size() > 0) {
+ XWPFRun cellR = cell.getParagraphs().get(j).createRun();
+ cellR.setBold(paragraph.getRuns().get(0).isBold());
+ cellR.getCTR().setRPr(paragraph.getRuns().get(0).getCTR().getRPr());
+ }
+ //鏇挎崲鏂囧瓧
+ changeText(cell.getParagraphs().get(j),"%T4com"+i+"item"+(j+1)+"%");
+ }
+ }
+ }else{
+ //鍑忓皯
+ for (int i = 1; i < rows; i++) {
+ XWPFTableRow row = table.getRows().get(i);
+ List<XWPFTableCell> cells = row.getTableCells();
+ XWPFTableCell cell = cells.get(1);
+ //XWPFParagraph paragraph = cell.getParagraphs().get(0);
+ for (int j = 3; j > table4ChildrenNum; j--) {
+ //cell.removeParagraph(j-1);
+ changeText(cell.getParagraphs().get(j),"");
+ }
+ }
+ }
+ }
+ //琛�4 鑳滀换鍔涢鐣欎綅缃簭鍙峰鐞�
+ for (int i = tableNum; i < tableNum+4; i++) {
+ XWPFTableRow row = table.getRows().get(i);
+ List<XWPFTableCell> cells = row.getTableCells();
+ changeText(cells.get(0).getParagraphs().get(0),"#"+(i+1)+".");
+ }
+ }
+
+ //闄愬埗琛屾暟涓嶄负绌� 鍜� 闄愬埗琛屾暟璺熸姤鍛婄幇鏈変笉涓�鑷撮渶杩涜澶勭悊
+ 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);
+ }
+ log.info("{}鍑忓皯{}琛屾暟",TableEnum.codeOf(index).getName(),delRow-1);
+ }
+ }
+
+ }catch (Exception e){
+ e.printStackTrace();
+ log.info("琛▄}澧炲姞琛ㄦ牸鎴栬�呮笡灏戣〃鏍煎紓甯�",index+1);
+ }
+ }
+
+ /**
+ * 鏇挎崲娈佃惤閲岄潰鐨勫彉閲�
+ * @param para
+ * @param text
+ */
+ private static void replaceInPara(XWPFParagraph para, String text) {
+ List<XWPFRun> runs;
+ runs = para.getRuns();
+ XWPFRun run = runs.get(0);
+ // 鐩存帴璋冪敤XWPFRun鐨剆etText()鏂规硶璁剧疆鏂囨湰鏃讹紝鍦ㄥ簳灞備細閲嶆柊鍒涘缓涓�涓猉WPFRun锛屾妸鏂囨湰闄勫姞鍦ㄥ綋鍓嶆枃鏈悗闈紝
+ // 鎵�浠ユ垜浠笉鑳界洿鎺ヨ鍊硷紝闇�瑕佸厛鍒犻櫎褰撳墠run,鐒跺悗鍐嶈嚜宸辨墜鍔ㄦ彃鍏ヤ竴涓柊鐨剅un銆�
+ para.removeRun(0);
+ para.insertNewRun(0).setText(text);
+ }
+
+ public static void changeText(XWPFParagraph p, String newText) {
+ 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);
+ run.setText(newText, 0);
+ }
+
+ /**
+ * 鍒犻櫎JAQ琛ㄦ牸
+ * @param table
+ * @param index
+ */
+ private static void delJAQTable(XWPFTable table,Integer index){
+ table.removeRow(index);
+ }
+
+ /**
+ * 娣诲姞JAQ琛ㄦ牸
+ * @param tableEnum
+ * @param index
+ */
+ private static void addJAQTable(XWPFTable table,TableEnum tableEnum,Integer index,Map<String, Object> textMap){
+
+ // 鍦ㄨ〃鏍间腑鎸囧畾鐨勪綅缃柊澧炰竴琛�
+ insertRow(table,1,index);
+
+ 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)+"");
+ cells.get(1).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T1com"+index)+"");
+ cells.get(2).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T1com"+index+"IF_M")+"");
+ cells.get(3).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T1com"+index+"IF_L")+"-"+textMap.get("T1com"+index+"IF_H"));
+ break;
+ case table2:
+ cells.get(0).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T2rank"+index)+"");
+ cells.get(1).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T2com"+index)+"");
+ cells.get(2).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T2Com"+index+"I_M")+"");
+ cells.get(3).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T2com"+index+"I_L")+"-"+textMap.get("T2com"+index+"I_H"));
+ break;
+ case table3:
+ cells.get(0).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T3rank"+index)+"");
+ cells.get(1).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T3item"+index)+"");
+ cells.get(2).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T3item"+index+"IF_M")+"");
+ cells.get(3).getParagraphs().get(0).getRuns().get(0).setText(textMap.get("T3com"+index)+"");
+ break;
+ case table4:
+ cells.get(0).getParagraphs().get(0).getRuns().get(0).setText("#"+textMap.get("T4rank"+index)+". "+textMap.get("T4com"+index));
+
+ //瀛愰泦鍚堥暱搴�
+ Integer table4ChildrenNum = Integer.valueOf(textMap.get(TableEnum.table4Children.getName()).toString());
+ List<String> items = new ArrayList<>();
+ for (int j = 1; j <= table4ChildrenNum; j++) {
+ items.add(textMap.get("T4com"+index+"item"+j)+"");
+ }
+
+ //璁剧疆鍊�
+ XWPFTableCell cell = cells.get(1);
+ XWPFParagraph paragraph = cell.getParagraphs().get(0);
+ for (int i = 0; i < items.size(); i++) {
+ String item = items.get(i);
+ if(i == 0){
+ paragraph.getRuns().get(0).setText(item);
+ }else{
+ //鏂板娈佃惤
+ cell.addParagraph();
+ cell.getParagraphs().get(i).getCTP().setPPr(paragraph.getCTP().getPPr());
+ if (paragraph.getRuns() != null
+ && paragraph.getRuns().size() > 0) {
+ XWPFRun cellR = cell.getParagraphs().get(i).createRun();
+ cellR.setBold(paragraph.getRuns().get(0).isBold());
+ /*cellR.setFontSize(paragraph.getRuns().get(0).getFontSize());
+ cellR.setFontFamily(paragraph.getRuns().get(0).getFontFamily());*/
+ cellR.getCTR().setRPr(paragraph.getRuns().get(0).getCTR().getRPr());
+ }
+ cell.getParagraphs().get(i).getRuns().get(0).setText(item);
+ }
+ }
+
+ //灏忎簬6涓儨浠诲姏 琛ラ綈
+ Integer repair = 6 - table4ChildrenNum;
+ if(repair > 0){
+ for (int i = 0; i < repair; i++) {
+ //鏂板娈佃惤
+ cell.addParagraph();
+ cell.getParagraphs().get(cell.getParagraphs().size()-1).getCTP().setPPr(paragraph.getCTP().getPPr());
+ if (paragraph.getRuns() != null
+ && paragraph.getRuns().size() > 0) {
+ XWPFRun cellR = cell.getParagraphs().get(cell.getParagraphs().size()-1).createRun();
+ cellR.setBold(paragraph.getRuns().get(0).isBold());
+ /*cellR.setFontSize(paragraph.getRuns().get(0).getFontSize());
+ cellR.setFontFamily(paragraph.getRuns().get(0).getFontFamily());*/
+ cellR.getCTR().setRPr(paragraph.getRuns().get(0).getCTR().getRPr());
+ }
+ cell.getParagraphs().get(cell.getParagraphs().size()-1).getRuns().get(0).setText(null);
+ }
+ }
+ break;
+ }
+ }
+
+ /**
+ * insertRow 鍦╳ord琛ㄦ牸涓寚瀹氫綅缃彃鍏ヤ竴琛岋紝骞跺皢鏌愪竴琛岀殑鏍峰紡澶嶅埗鍒版柊澧炶
+ * @param copyrowIndex 闇�瑕佸鍒剁殑琛屼綅缃�
+ * @param newrowIndex 闇�瑕佹柊澧炰竴琛岀殑浣嶇疆
+ * */
+ public static void insertRow(XWPFTable table, int copyrowIndex, int newrowIndex) {
+ // 鍦ㄨ〃鏍间腑鎸囧畾鐨勪綅缃柊澧炰竴琛�
+ XWPFTableRow targetRow = table.insertNewTableRow(newrowIndex);
+ // 鑾峰彇闇�瑕佸鍒惰瀵硅薄
+ XWPFTableRow copyRow = table.getRow(copyrowIndex);
+ //澶嶅埗琛屽璞�
+ targetRow.getCtRow().setTrPr(copyRow.getCtRow().getTrPr());
+ //鎴栬闇�瑕佸鍒剁殑琛岀殑鍒�
+ List<XWPFTableCell> copyCells = copyRow.getTableCells();
+ //澶嶅埗鍒楀璞�
+ XWPFTableCell targetCell = null;
+ for (int i = 0; i < copyCells.size(); i++) {
+ XWPFTableCell copyCell = copyCells.get(i);
+ targetCell = targetRow.addNewTableCell();
+ targetCell.getCTTc().setTcPr(copyCell.getCTTc().getTcPr());
+ if (copyCell.getParagraphs() != null && copyCell.getParagraphs().size() > 0) {
+ targetCell.getParagraphs().get(0).getCTP().setPPr(copyCell.getParagraphs().get(0).getCTP().getPPr());
+ if (copyCell.getParagraphs().get(0).getRuns() != null
+ && copyCell.getParagraphs().get(0).getRuns().size() > 0) {
+ XWPFRun cellR = targetCell.getParagraphs().get(0).createRun();
+ cellR.setBold(copyCell.getParagraphs().get(0).getRuns().get(0).isBold());
+ cellR.getCTR().setRPr(copyCell.getParagraphs().get(0).getRuns().get(0).getCTR().getRPr());
+ }
+ }
+ }
+ }
+
+ /**
+ * 澶嶅埗妯℃澘琛岀殑灞炴��
+ * @param tmpCell
+ * @param cell
+ * @param text
+ * @throws Exception
+ */
+ private static void setCellText(XWPFTableCell tmpCell, XWPFTableCell cell,String text){
+ try {
+ CTTc cttc2 = tmpCell.getCTTc();
+ CTTcPr ctPr2 = cttc2.getTcPr();
+ CTTc cttc = cell.getCTTc();
+ CTTcPr ctPr = cttc.addNewTcPr();
+ if (ctPr2.getTcW() != null) {
+ ctPr.addNewTcW().setW(ctPr2.getTcW().getW());
+ }
+ if (ctPr2.getVAlign() != null) {
+ ctPr.addNewVAlign().setVal(ctPr2.getVAlign().getVal());
+ }
+ if (cttc2.getPList().size() > 0) {
+ CTP ctp = cttc2.getPList().get(0);
+ if (ctp.getPPr() != null) {
+ if (ctp.getPPr().getJc() != null) {
+ cttc.getPList().get(0).addNewPPr().addNewJc()
+ .setVal(ctp.getPPr().getJc().getVal());
+ }
+ }
+ }
+ if (ctPr2.getTcBorders() != null) {
+ ctPr.setTcBorders(ctPr2.getTcBorders());
+ }
+ XWPFParagraph tmpP = tmpCell.getParagraphs().get(0);
+ XWPFParagraph cellP = cell.getParagraphs().get(0);
+ XWPFRun tmpR = null;
+ if (tmpP.getRuns() != null && tmpP.getRuns().size() > 0) {
+ tmpR = tmpP.getRuns().get(0);
+ }
+ XWPFRun cellR = cellP.createRun();
+ cellR.setText(text);
+ // 澶嶅埗瀛椾綋淇℃伅
+ if (tmpR != null) {
+ if(!cellR.isBold()){
+ cellR.setBold(tmpR.isBold());
+ }
+ cellR.setItalic(tmpR.isItalic());
+ cellR.setUnderline(tmpR.getUnderline());
+ cellR.setColor(tmpR.getColor());
+ cellR.setTextPosition(tmpR.getTextPosition());
+ if (tmpR.getFontSize() != -1) {
+ cellR.setFontSize(tmpR.getFontSize());
+ }
+ if (tmpR.getFontFamily() != null) {
+ cellR.setFontFamily(tmpR.getFontFamily());
+ }
+ if (tmpR.getCTR() != null) {
+ if (tmpR.getCTR().isSetRPr()) {
+ CTRPr tmpRPr = tmpR.getCTR().getRPr();
+ if (tmpRPr.isSetRFonts()) {
+ CTFonts tmpFonts = tmpRPr.getRFonts();
+ CTRPr cellRPr = cellR.getCTR().isSetRPr() ? cellR
+ .getCTR().getRPr() : cellR.getCTR().addNewRPr();
+ CTFonts cellFonts = cellRPr.isSetRFonts() ? cellRPr
+ .getRFonts() : cellRPr.addNewRFonts();
+ cellFonts.setAscii(tmpFonts.getAscii());
+ cellFonts.setAsciiTheme(tmpFonts.getAsciiTheme());
+ cellFonts.setCs(tmpFonts.getCs());
+ cellFonts.setCstheme(tmpFonts.getCstheme());
+ cellFonts.setEastAsia(tmpFonts.getEastAsia());
+ cellFonts.setEastAsiaTheme(tmpFonts.getEastAsiaTheme());
+ cellFonts.setHAnsi(tmpFonts.getHAnsi());
+ cellFonts.setHAnsiTheme(tmpFonts.getHAnsiTheme());
+ }
+ }
+ }
+ }
+ // 澶嶅埗娈佃惤淇℃伅
+ cellP.setAlignment(tmpP.getAlignment());
+ cellP.setVerticalAlignment(tmpP.getVerticalAlignment());
+ cellP.setBorderBetween(tmpP.getBorderBetween());
+ cellP.setBorderBottom(tmpP.getBorderBottom());
+ cellP.setBorderLeft(tmpP.getBorderLeft());
+ cellP.setBorderRight(tmpP.getBorderRight());
+ cellP.setBorderTop(tmpP.getBorderTop());
+ cellP.setPageBreak(tmpP.isPageBreak());
+ if (tmpP.getCTP() != null) {
+ if (tmpP.getCTP().getPPr() != null) {
+ CTPPr tmpPPr = tmpP.getCTP().getPPr();
+ CTPPr cellPPr = cellP.getCTP().getPPr() != null ? cellP
+ .getCTP().getPPr() : cellP.getCTP().addNewPPr();
+ // 澶嶅埗娈佃惤闂磋窛淇℃伅
+ CTSpacing tmpSpacing = tmpPPr.getSpacing();
+ if (tmpSpacing != null) {
+ CTSpacing cellSpacing = cellPPr.getSpacing() != null ? cellPPr
+ .getSpacing() : cellPPr.addNewSpacing();
+ if (tmpSpacing.getAfter() != null) {
+ cellSpacing.setAfter(tmpSpacing.getAfter());
+ }
+ if (tmpSpacing.getAfterAutospacing() != null) {
+ cellSpacing.setAfterAutospacing(tmpSpacing
+ .getAfterAutospacing());
+ }
+ if (tmpSpacing.getAfterLines() != null) {
+ cellSpacing.setAfterLines(tmpSpacing.getAfterLines());
+ }
+ if (tmpSpacing.getBefore() != null) {
+ cellSpacing.setBefore(tmpSpacing.getBefore());
+ }
+ if (tmpSpacing.getBeforeAutospacing() != null) {
+ cellSpacing.setBeforeAutospacing(tmpSpacing
+ .getBeforeAutospacing());
+ }
+ if (tmpSpacing.getBeforeLines() != null) {
+ cellSpacing.setBeforeLines(tmpSpacing.getBeforeLines());
+ }
+ if (tmpSpacing.getLine() != null) {
+ cellSpacing.setLine(tmpSpacing.getLine());
+ }
+ if (tmpSpacing.getLineRule() != null) {
+ cellSpacing.setLineRule(tmpSpacing.getLineRule());
+ }
+ }
+ // 澶嶅埗娈佃惤缂╄繘淇℃伅
+ CTInd tmpInd = tmpPPr.getInd();
+ if (tmpInd != null) {
+ CTInd cellInd = cellPPr.getInd() != null ? cellPPr.getInd()
+ : cellPPr.addNewInd();
+ if (tmpInd.getFirstLine() != null) {
+ cellInd.setFirstLine(tmpInd.getFirstLine());
+ }
+ if (tmpInd.getFirstLineChars() != null) {
+ cellInd.setFirstLineChars(tmpInd.getFirstLineChars());
+ }
+ if (tmpInd.getHanging() != null) {
+ cellInd.setHanging(tmpInd.getHanging());
+ }
+ if (tmpInd.getHangingChars() != null) {
+ cellInd.setHangingChars(tmpInd.getHangingChars());
+ }
+ if (tmpInd.getLeft() != null) {
+ cellInd.setLeft(tmpInd.getLeft());
+ }
+ if (tmpInd.getLeftChars() != null) {
+ cellInd.setLeftChars(tmpInd.getLeftChars());
+ }
+ if (tmpInd.getRight() != null) {
+ cellInd.setRight(tmpInd.getRight());
+ }
+ if (tmpInd.getRightChars() != null) {
+ cellInd.setRightChars(tmpInd.getRightChars());
+ }
+ }
+ }
+ }
+ }catch (Exception e){
+ e.printStackTrace();
+ }
+ }
+
private static void addTableValue(XWPFDocument document, Map<Integer, Map<Integer, List<String[]>>> autoTableMap) {
if (Objects.isNull(autoTableMap)) {
return;
@@ -338,7 +748,7 @@
}
}
}
- private static void setTableMap(Map<String, Object> tableMap, Map<Integer, List<String[]>> mapRowsMap) {
+ /* private static void setTableMap(Map<String, Object> tableMap, Map<Integer, List<String[]>> mapRowsMap) {
if (Objects.isNull(tableMap) || tableMap.isEmpty()) {
return;
}
@@ -370,7 +780,7 @@
table4List.add(t.toRow());
}
mapRowsMap.put(3, table4List);
- }
+ }*/
public static void eachTable(List<XWPFTableRow> rows, Map<String, Object> textMap, XWPFDocument document) throws IOException, org.apache.poi.openxml4j.exceptions.InvalidFormatException {
for (XWPFTableRow row : rows) {
@@ -859,7 +1269,7 @@
changeTable(document, textMap);
//璁剧疆鍥捐〃鎺т欢
- //changChar(textMap, document, reportType, templateType);
+ changChar(textMap, document, reportType, templateType);
document.write(out);
}
private static void changeTextBox(XWPFDocument document, Map<String, Object> textMap) throws DocumentException {
@@ -961,7 +1371,7 @@
}
if (StringUtils.equals(reportType, ReportTypeEnum.MAQ.getCode())) {
setMAQCompleteChars(textMap, charts);
- } else if (StringUtils.equals(reportType, ReportTypeEnum.MAQV2.getCode())) {
+ } else if (StringUtils.equals(reportType, ReportTypeEnum.MAQV2.getCode()) || StringUtils.equals(reportType, ReportTypeEnum.MAQIAR.getCode())) {
setMAQ_V2CompleteChars(textMap, charts);
} else if (StringUtils.equals(reportType, ReportTypeEnum.RuiLin.getCode())) {
setRuiLinChar(textMap, charts);
@@ -1293,8 +1703,30 @@
public static void main(String[] args) {
- if (!checkText("浜烘墠閫夋嫈鐨勭洰鐨勫氨鏄壘鍒拌兘澶熻儨浠诲伐浣溿�佹効鎰忔壙鎷呭伐浣滐紝涓斾笌缁勭粐鐨勯渶姹傘�佹枃鍖栥�佷环鍊艰鐩稿尮閰嶇殑浜恒�侾AQ鎶ュ憡鏄牴鎹�欓�変汉瀵筆AQ闂嵎涓鐩殑浣滅瓟淇℃伅鑰岀敓鎴愮殑锛屾祴閲忕殑鏄�欓�変汉鍦ㄥ伐浣滀腑鍋忓ソ鐨勮涓洪鏍笺�侾AQ涔熷寘鎷簡瀵逛綔绛旂湡瀹炴�х殑娴嬮噺锛屽悓鏃朵篃瑁呭叆浜員AI涓撴湁鐨勪綔鍋囬槻鑼冪▼搴忥紝鍙互鏈夋晥闄嶄綆鍊欓�変汉鐨勪吉瑁呭ソ鍊惧悜锛堝叏鐞�30%鐨勮嚜璇勯棶鍗蜂腑閮藉嚭鐜颁簡浼濂界幇璞★級銆�")) {
+/* if (!checkText("浜烘墠閫夋嫈鐨勭洰鐨勫氨鏄壘鍒拌兘澶熻儨浠诲伐浣溿�佹効鎰忔壙鎷呭伐浣滐紝涓斾笌缁勭粐鐨勯渶姹傘�佹枃鍖栥�佷环鍊艰鐩稿尮閰嶇殑浜恒�侾AQ鎶ュ憡鏄牴鎹�欓�変汉瀵筆AQ闂嵎涓鐩殑浣滅瓟淇℃伅鑰岀敓鎴愮殑锛屾祴閲忕殑鏄�欓�変汉鍦ㄥ伐浣滀腑鍋忓ソ鐨勮涓洪鏍笺�侾AQ涔熷寘鎷簡瀵逛綔绛旂湡瀹炴�х殑娴嬮噺锛屽悓鏃朵篃瑁呭叆浜員AI涓撴湁鐨勪綔鍋囬槻鑼冪▼搴忥紝鍙互鏈夋晥闄嶄綆鍊欓�変汉鐨勪吉瑁呭ソ鍊惧悜锛堝叏鐞�30%鐨勮嚜璇勯棶鍗蜂腑閮藉嚭鐜颁簡浼濂界幇璞★級銆�")) {
System.out.println("11");
+ }*/
+
+ try {
+ InputStream is = new FileInputStream("C:\\Users\\datou\\Desktop\\JAQ涓枃鐗�.docx");
+ XWPFDocument document = new XWPFDocument(is);
+
+ String result = "{\"T4com8item1\":\"JAQ0127\",\"T1com8IF_H\":\"12.92\",\"T1com8IF_L\":\"12.16\",\"T1com8IF_M\":\"12.54\",\"T3item2\":\"JAQ0092\",\"T2com1I_L\":\"3.80\",\"T3item3\":\"JAQ0019\",\"T3item4\":\"JAQ0027\",\"T3item5\":\"JAQ0021\",\"T3item6\":\"JAQ0044\",\"T3item7\":\"JAQ0045\",\"T2Com13I_M\":\"3.40\",\"T3item8\":\"JAQ0105\",\"T3item9\":\"JAQ0002\",\"T2com1I_H\":\"4.20\",\"T3item3IF_M\":\"18.00\",\"T3Line10C\":\"0\",\"T1com15IF_H\":\"15.20\",\"T1com15IF_L\":\"7.28\",\"T3Line9C\":\"0\",\"T1com1IF_M\":\"15.62\",\"T1com15IF_M\":\"11.24\",\"T1com1IF_L\":\"14.44\",\"T2com6I_L\":\"3.60\",\"T1com1IF_H\":\"16.80\",\"T1com4IF_M\":\"14.78\",\"T1com4IF_L\":\"14.44\",\"T3Line11C\":\"0\",\"T2com6I_H\":\"4.00\",\"T1com4IF_H\":\"15.12\",\"T3item16IF_M\":\"16.00\",\"T3com18\":\"23. 婵�鍔变粬浜篭",\"T4com6item1\":\"JAQ0049\",\"T3com17\":\"11. 瀹㈡埛瀵煎悜锛堝唴閮ㄥ拰澶栭儴锛塡",\"T3com19\":\"14. 鍒ゆ柇鍜屽喅绛朶",\"T3Line8C\":\"0\",\"T3com10\":\"20. 鎺堟潈\",\"T3item13IF_M\":\"16.00\",\"T3com12\":\"19. 浜哄憳閰嶇疆涓庝汉鎵嶅煿鍏籠",\"T3com11\":\"1. 閫傚簲鎬у拰鍙橀潻绠＄悊\",\"T3com14\":\"15. 璁″垝鍜岀粍缁嘰",\"T3com13\":\"20. 鎺堟潈\",\"T3com16\":\"23. 婵�鍔变粬浜篭",\"T3com15\":\"18. 绠＄悊浠栦汉\",\"T1com11IF_L\":\"10.88\",\"T1com11IF_M\":\"11.90\",\"T1com11IF_H\":\"12.92\",\"T2com14I_H\":\"3.40\",\"T2com1\":\"1. 閫傚簲鎬у拰鍙橀潻绠＄悊\",\"T2com2\":\"20. 鎺堟潈\",\"T3Line6C\":\"0\",\"T2com9\":\"6. 鍘嬪姏蹇嶅彈-鎯呯华闊ф�",\"T2com7\":\"15. 璁″垝鍜岀粍缁嘰",\"T2com8\":\"19. 浜哄憳閰嶇疆涓庝汉鎵嶅煿鍏籠",\"T2com5\":\"5. 缂滃瘑鎬",\"T3item7IF_M\":\"18.00\",\"T3Line7C\":\"0\",\"T2com6\":\"9. 鍚岀悊蹇僜",\"T2Com14I_M\":\"3.40\",\"T2com3\":\"23. 婵�鍔变粬浜篭",\"T2Com5I_M\":\"3.80\",\"T2com4\":\"11. 瀹㈡埛瀵煎悜锛堝唴閮ㄥ拰澶栭儴锛塡",\"T2com14I_L\":\"3.40\",\"T3Line12C\":\"0\",\"T2com15I_H\":\"3.80\",\"T2com15I_L\":\"2.60\",\"T1com4\":\"1. 閫傚簲鎬у拰鍙橀潻绠＄悊\",\"T1com5\":\"9. 鍚岀悊蹇僜",\"T1com6\":\"5. 缂滃瘑鎬",\"T1com7\":\"8. 鍥㈤槦鍗忎綔\",\"T4com2item1\":\"JAQ0105\",\"T1com8\":\"19. 浜哄憳閰嶇疆涓庝汉鎵嶅煿鍏籠",\"T1com9\":\"6. 鍘嬪姏蹇嶅彈-鎯呯华闊ф�",\"T2Com6I_M\":\"3.80\",\"T1com1\":\"23. 婵�鍔变粬浜篭",\"T1com2\":\"20. 鎺堟潈\",\"T1com3\":\"11. 瀹㈡埛瀵煎悜锛堝唴閮ㄥ拰澶栭儴锛塡",\"T2Line9C\":\"0\",\"T1com7IF_H\":\"17.60\",\"T2com5I_H\":\"4.00\",\"T1com7IF_M\":\"12.70\",\"T3Line13C\":\"0\",\"T1com7IF_L\":\"7.80\",\"T2com5I_L\":\"3.60\",\"T1com2IF_M\":\"15.56\",\"T1com2IF_L\":\"14.40\",\"T1com2IF_H\":\"16.72\",\"琛�4瀛愰泦鍚圽":\"1\",\"T2rank1\":\"1\",\"T3item4IF_M\":\"18.00\",\"T2rank3\":\"3\",\"T2rank2\":\"2\",\"T3com20\":\"5. 缂滃瘑鎬",\"T2rank5\":\"5\",\"T2rank4\":\"4\",\"T2rank7\":\"7\",\"T2rank6\":\"6\",\"T2rank9\":\"9\",\"T3Line14C\":\"0\",\"T2rank8\":\"8\",\"T1rank9\":\"9\",\"T3item20\":\"JAQ0049\",\"T1rank6\":\"6\",\"T1com3IF_M\":\"14.88\",\"T1rank5\":\"5\",\"T1com3IF_L\":\"12.96\",\"T1rank8\":\"8\",\"T1rank7\":\"7\",\"T1rank2\":\"2\",\"T1rank1\":\"1\",\"T2Com15I_M\":\"3.20\",\"T1rank4\":\"4\",\"T1rank3\":\"3\",\"琛�1\":\"15\",\"琛�2\":\"15\",\"琛�3\":\"20\",\"琛�4\":\"10\",\"T1com3IF_H\":\"16.80\",\"T3Line15C\":\"1\",\"T3item8IF_M\":\"18.00\",\"T3item17IF_M\":\"16.00\",\"T3item19\":\"JAQ0033\",\"T3item18\":\"JAQ0023\",\"T4com7item1\":\"JAQ0001\",\"T3item12IF_M\":\"16.00\",\"T3item17\":\"JAQ0020\",\"T3item16\":\"JAQ0133\",\"T3item15\":\"JAQ0012\",\"T1com12IF_M\":\"11.58\",\"T3item14\":\"JAQ0131\",\"T3item13\":\"JAQ0129\",\"T3item12\":\"JAQ0127\",\"T3item11\":\"JAQ0006\",\"T3item10\":\"JAQ0089\",\"T4com10\":\"24. 缁勭粐鏁忛攼搴",\"T3item1\":\"JAQ0128\",\"T1com12IF_H\":\"12.96\",\"T1com12IF_L\":\"10.20\",\"T2Com10I_M\":\"3.50\",\"T2com10I_H\":\"4.40\",\"T3Line16C\":\"0\",\"T2Com1I_M\":\"4.00\",\"T2com4I_H\":\"4.20\",\"T2com10I_L\":\"2.60\",\"T2com4I_L\":\"3.60\",\"T4com1item1\":\"JAQ0019\",\"T1com13IF_H\":\"12.92\",\"T2Line4C\":\"0\",\"T3item5IF_M\":\"18.00\",\"T2com11I_H\":\"3.60\",\"T3Line1C\":\"0\",\"T4rank10\":\"10\",\"T1com13IF_L\":\"10.20\",\"T1com13IF_M\":\"11.56\",\"T3Line17C\":\"0\",\"T2Com2I_M\":\"4.00\",\"T2com11I_L\":\"3.40\",\"T2com9I_L\":\"3.00\",\"T4com9item1\":\"JAQ0064\",\"T2com9I_H\":\"4.00\",\"T2Line5C\":\"0\",\"T2Com7I_M\":\"3.60\",\"T2Line6C\":\"0\",\"T3Line18C\":\"0\",\"T2com12\":\"24. 缁勭粐鏁忛攼搴",\"T2com13\":\"16. 鍒涢�犳�",\"T2com14\":\"25. 鍟嗕笟涓庢垬鐣ユ晱閿愬害\",\"T2Line11C\":\"0\",\"T2com15\":\"3. 涓诲姩鎬",\"T2com10\":\"8. 鍥㈤槦鍗忎綔\",\"T2com11\":\"14. 鍒ゆ柇鍜屽喅绛朶",\"T4com5item1\":\"JAQ0044\",\"T4com3\":\"11. 瀹㈡埛瀵煎悜锛堝唴閮ㄥ拰澶栭儴锛塡",\"T4com4\":\"1. 閫傚簲鎬у拰鍙橀潻绠＄悊\",\"T4com1\":\"23. 婵�鍔变粬浜篭",\"T3item9IF_M\":\"18.00\",\"T4com2\":\"20. 鎺堟潈\",\"T4com7\":\"8. 鍥㈤槦鍗忎綔\",\"T3item2IF_M\":\"18.00\",\"T4com8\":\"19. 浜哄憳閰嶇疆涓庝汉鎵嶅煿鍏籠",\"T4com5\":\"9. 鍚岀悊蹇僜",\"T2Com8I_M\":\"3.60\",\"T2Com11I_M\":\"3.50\",\"T4com6\":\"5. 缂滃瘑鎬",\"T2com3I_H\":\"4.20\",\"T3rank20\":\"20\",\"T4com9\":\"6. 鍘嬪姏蹇嶅彈-鎯呯华闊ф�",\"T2Line7C\":\"0\",\"T3Line19C\":\"0\",\"T2com3I_L\":\"3.80\",\"T2Line10C\":\"0\",\"T1com6IF_M\":\"13.00\",\"T1com6IF_L\":\"10.80\",\"T3item18IF_M\":\"16.00\",\"T1com6IF_H\":\"15.20\",\"T3item11IF_M\":\"16.00\",\"T2Line8C\":\"0\",\"T2com8I_L\":\"3.40\",\"T1com9IF_M\":\"12.10\",\"T3rank1\":\"1\",\"T2com8I_H\":\"3.80\",\"T3rank2\":\"2\",\"T3item10IF_M\":\"18.00\",\"T1com14IF_M\":\"11.40\",\"T1com14IF_L\":\"8.40\",\"T3rank9\":\"9\",\"T3Line5C\":\"0\",\"T3rank7\":\"7\",\"T3rank8\":\"8\",\"T3rank5\":\"5\",\"T3rank6\":\"6\",\"T3rank3\":\"3\",\"T3rank4\":\"4\",\"T4rank7\":\"7\",\"T4rank6\":\"6\",\"T4rank5\":\"5\",\"T4rank4\":\"4\",\"T4rank9\":\"9\",\"T4com3item1\":\"JAQ0045\",\"T4rank8\":\"8\",\"T3item6IF_M\":\"18.00\",\"T1com14IF_H\":\"14.40\",\"T4rank3\":\"3\",\"T2Line13C\":\"0\",\"T4rank2\":\"2\",\"T4rank1\":\"1\",\"T3rank19\":\"19\",\"T2Line1C\":\"0\",\"T3rank18\":\"18\",\"T2Line12C\":\"0\",\"T3rank17\":\"17\",\"T3rank16\":\"16\",\"T2com12I_H\":\"4.00\",\"T3Line4C\":\"0\",\"T3item20IF_M\":\"16.00\",\"T2Com12I_M\":\"3.50\",\"T2Com3I_M\":\"4.00\",\"T3item14IF_M\":\"16.00\",\"T3rank11\":\"11\",\"T3rank10\":\"10\",\"T2com2I_H\":\"4.40\",\"T1com9IF_H\":\"15.20\",\"T2com12I_L\":\"3.00\",\"T3rank15\":\"15\",\"T3rank14\":\"14\",\"T2com2I_L\":\"3.60\",\"T3rank13\":\"13\",\"T1com9IF_L\":\"9.00\",\"T3rank12\":\"12\",\"T2rank14\":\"14\",\"T2rank13\":\"13\",\"T2rank15\":\"15\",\"T2rank10\":\"10\",\"T2com13I_H\":\"4.00\",\"T3item15IF_M\":\"16.00\",\"T2Line2C\":\"0\",\"T2rank12\":\"12\",\"T2rank11\":\"11\",\"T3Line3C\":\"0\",\"T1com10IF_M\":\"12.10\",\"T1com10IF_L\":\"9.00\",\"T2Com4I_M\":\"3.90\",\"T1com10IF_H\":\"15.20\",\"T4com10item1\":\"JAQ0027\",\"T2com13I_L\":\"2.80\",\"T3item1IF_M\":\"18.00\",\"T2com7I_L\":\"3.40\",\"T2Line15C\":\"1\",\"T3com6\":\"9. 鍚岀悊蹇僜",\"T3com7\":\"11. 瀹㈡埛瀵煎悜锛堝唴閮ㄥ拰澶栭儴锛塡",\"T3Line20C\":\"0\",\"T2com7I_H\":\"3.80\",\"T3com8\":\"20. 鎺堟潈\",\"T3com9\":\"15. 璁″垝鍜岀粍缁嘰",\"T3com2\":\"16. 鍒涢�犳�",\"T3com3\":\"23. 婵�鍔变粬浜篭",\"T3com4\":\"24. 缁勭粐鏁忛攼搴",\"T2Line3C\":\"0\",\"T3com5\":\"1. 閫傚簲鎬у拰鍙橀潻绠＄悊\",\"T1rank15\":\"15\",\"T1rank14\":\"14\",\"T1rank13\":\"13\",\"T1rank12\":\"12\",\"T1rank11\":\"11\",\"T1rank10\":\"10\",\"T3Line2C\":\"0\",\"T1com5IF_H\":\"15.20\",\"T1com10\":\"24. 缁勭粐鏁忛攼搴",\"T1com11\":\"25. 鍟嗕笟涓庢垬鐣ユ晱閿愬害\",\"T2Com9I_M\":\"3.50\",\"T1com12\":\"14. 鍒ゆ柇鍜屽喅绛朶",\"T1com13\":\"15. 璁″垝鍜岀粍缁嘰",\"T1com14\":\"16. 鍒涢�犳�",\"T1com15\":\"26. 姝ｇ洿銆佷俊浠诲拰鍏俊鍔沑",\"T3item19IF_M\":\"16.00\",\"T1com5IF_M\":\"13.72\",\"T3com1\":\"1. 閫傚簲鎬у拰鍙橀潻绠＄悊\",\"T4com4item1\":\"JAQ0128\",\"T1com5IF_L\":\"12.24\",\"T2Line14C\":\"0\"}";
+
+ JSONObject jsonObject = JSONObject.parseObject(result);
+ //json瀵硅薄杞琈ap
+ Map<String,Object> textMap = jsonObject;
+
+ //鏇存敼琛ㄦ牸鐨勫��
+ changeTable(document, textMap);
+
+ //寤虹珛鏂囦欢瀵硅薄
+ File file = new File("C:\\Users\\datou\\Desktop\\JAQ涓枃鐗�1.docx");
+ FileOutputStream out = new FileOutputStream(file);
+ document.write(out);
+ out.flush();
+ }catch (Exception e){
+ e.printStackTrace();
}
}
}
--
Gitblit v1.9.1