From 765d9a3de208ba1ea9a10f9b1bd6fba08afd2079 Mon Sep 17 00:00:00 2001
From: 林致杰 <1003392067@qq.com>
Date: 星期四, 26 十月 2023 16:02:44 +0800
Subject: [PATCH] 新增LAQ图表替换

---
 src/main/java/com/ots/project/tool/report/LAQ/chart/LAQChart.java |   45 +++++++++++++++++++++++++++++++--------------
 1 files changed, 31 insertions(+), 14 deletions(-)

diff --git a/src/main/java/com/ots/project/tool/report/LAQ/chart/LAQChart.java b/src/main/java/com/ots/project/tool/report/LAQ/chart/LAQChart.java
index b70254d..962ca37 100644
--- a/src/main/java/com/ots/project/tool/report/LAQ/chart/LAQChart.java
+++ b/src/main/java/com/ots/project/tool/report/LAQ/chart/LAQChart.java
@@ -2,6 +2,8 @@
 
 import com.alibaba.fastjson.JSON;
 import com.ots.common.enums.CapabilityEnum;
+import com.ots.common.enums.LangTypeEnum;
+import com.ots.common.enums.ReportTypeEnum;
 import com.ots.common.utils.DateUtils;
 import com.ots.common.utils.MapDataUtil;
 import com.ots.common.utils.StringUtils;
@@ -10,9 +12,12 @@
 import com.ots.framework.config.EssConfig;
 import com.ots.project.exam.domain.TReportTemplate;
 import com.ots.project.tool.PdfUtil;
+import com.ots.project.tool.report.LAQ.LAQReport;
 import com.ots.project.tool.report.LAQ.LAQTemplate;
 import com.ots.project.tool.report.MAQ.base.RowData;
 import com.ots.project.tool.report.MAQ.base.SeriesData;
+import com.ots.project.tool.report.MAQNEW.MAQReport_V2;
+import com.ots.project.tool.report.ReportResultData;
 import lombok.extern.slf4j.Slf4j;
 import org.apache.poi.ooxml.POIXMLDocument;
 import org.apache.poi.ooxml.POIXMLDocumentPart;
@@ -43,7 +48,7 @@
 
 
     public static void main(String[] args) throws Exception {
-        String dataPath = "D:\\娴嬭瘎绯荤粺\\闇�姹俓\LAQ\\report\\LAQ琛ㄥご鏁版嵁鏂囦欢.xlsx";
+/*        String dataPath = "D:\\娴嬭瘎绯荤粺\\闇�姹俓\2023\\5.棰嗗娼滃姏鎶ュ憡\\report\\LAQ琛ㄥご鏁版嵁鏂囦欢.xlsx";
         // 鑾峰彇瀵煎叆鏁版嵁
         File file = new File(dataPath);
         InputStream in = new FileInputStream(file);
@@ -55,16 +60,18 @@
         for (int i = 0; i < laqTemplateList.size(); i++) {
             LAQTemplate laqTemplate = laqTemplateList.get(i);
             //缁勮鎶ュ憡鎵�鐢ㄦ暟鎹�
-            Map<String, Object> textMap = new HashMap<>();
+            Map<String, String> textMap = new HashMap<>();
             textMap.put("sendEmailFileName",laqTemplate.getName());
             textMap.put("nowDate", DateUtils.getDate());
             MapDataUtil.objectToMap(laqTemplate,textMap);
 
+            LAQReport report = new LAQReport();
+//            ReportResultData resultData = report.getTemplateParameters(textMap, ReportTypeEnum.LAQ, LangTypeEnum.codeOf("English"));
 //            TReportTemplate template = null;
 //            String zipFileName = WordUtil.makeReportFile("D:\\娴嬭瘎绯荤粺\\闇�姹俓\LAQ\\report\\LAQ鑻辨枃鎶ュ憡-20230926.docx", template, textMap, new HashMap<>(), deleteStrList);
 //            fileNameList.add(zipFileName);
             ZipSecureFile.setMinInflateRatio(0.001);
-            try (OutputStream os = new FileOutputStream("D:\\娴嬭瘎绯荤粺\\闇�姹俓\LAQ\\report\\LAQ.docx");XWPFDocument document = new XWPFDocument(POIXMLDocument.openPackage("D:\\娴嬭瘎绯荤粺\\闇�姹俓\LAQ\\report\\LAQ鑻辨枃鎶ュ憡-20230926.docx"))){
+            try (OutputStream os = new FileOutputStream("D:\\娴嬭瘎绯荤粺\\闇�姹俓\2023\\5.棰嗗娼滃姏鎶ュ憡\\report\\LAQ缂栬瘧鎶ュ憡.docx");XWPFDocument document = new XWPFDocument(POIXMLDocument.openPackage("D:\\娴嬭瘎绯荤粺\\闇�姹俓\2023\\5.棰嗗娼滃姏鎶ュ憡\\report\\LAQ涓枃妯℃澘.docx"))){
                 Map<Integer,List<SeriesData>> seriesDatas = initData(textMap);
                 changeChart(document,seriesDatas,textMap);
                 document.write(os);
@@ -74,7 +81,17 @@
 
             log.info("鍒犻櫎鐨勬枃浠跺悕:{}", JSON.toJSONString(deleteStrList));
             WordUtil.deleteFileByStr(deleteStrList);
-        }
+        }*/
+    }
+
+    /**
+     * 鏇挎崲LAQ鍥捐〃鏁版嵁
+     * @param document 鏂囨。瀵硅薄
+     * @param textMap 鏁版嵁婧�
+     */
+    public static void changeChart(XWPFDocument document, Map<String, Object> textMap) {
+        Map<Integer,List<SeriesData>> seriesDatas = initData(textMap);
+        changeChart(document,seriesDatas,textMap);
     }
 
     /**
@@ -85,16 +102,16 @@
     public static Map<Integer,List<SeriesData>> initData(Map<String, Object> textMap){
         Map<Integer,List<SeriesData>> seriesDataMap = new HashMap<>();
         //鑾峰彇鍛戒腑鏁板��
-        BigDecimal olas = (BigDecimal) textMap.get("olas");
-        BigDecimal ca = (BigDecimal) textMap.get("ca");
-        BigDecimal bla = (BigDecimal) textMap.get("bla");
-        BigDecimal nr = (BigDecimal) textMap.get("nr");
-        BigDecimal ar = (BigDecimal) textMap.get("ar");
-        BigDecimal open = (BigDecimal) textMap.get("open");
-        BigDecimal cons = (BigDecimal) textMap.get("cons");
-        BigDecimal extra = (BigDecimal) textMap.get("extra");
-        BigDecimal agree = (BigDecimal) textMap.get("agree");
-        BigDecimal emosta = (BigDecimal) textMap.get("emosta");
+        Double olas = Double.valueOf((String)textMap.get("olas"));
+        Double ca = Double.valueOf((String)textMap.get("ca"));
+        Double bla = Double.valueOf((String)textMap.get("bla"));
+        Double nr = Double.valueOf((String)textMap.get("nr"));
+        Double ar = Double.valueOf((String)textMap.get("ar"));
+        Double open = Double.valueOf((String)textMap.get("open"));
+        Double cons = Double.valueOf((String)textMap.get("cons"));
+        Double extra = Double.valueOf((String)textMap.get("extra"));
+        Double agree = Double.valueOf((String)textMap.get("agree"));
+        Double emosta = Double.valueOf((String)textMap.get("emosta"));
 
         // 鍥捐〃1
         List<SeriesData> seriesDatas = Arrays.asList(

--
Gitblit v1.9.1