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 | 40 +++++++++++++++++++++++++--------------- 1 files changed, 25 insertions(+), 15 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 dd83ef3..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 @@ -48,7 +48,7 @@ public static void main(String[] args) throws Exception { - String dataPath = "D:\\娴嬭瘎绯荤粺\\闇�姹俓\2023\\5.棰嗗娼滃姏鎶ュ憡\\report\\LAQ琛ㄥご鏁版嵁鏂囦欢.xlsx"; +/* String dataPath = "D:\\娴嬭瘎绯荤粺\\闇�姹俓\2023\\5.棰嗗娼滃姏鎶ュ憡\\report\\LAQ琛ㄥご鏁版嵁鏂囦欢.xlsx"; // 鑾峰彇瀵煎叆鏁版嵁 File file = new File(dataPath); InputStream in = new FileInputStream(file); @@ -71,7 +71,7 @@ // 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:\\娴嬭瘎绯荤粺\\闇�姹俓\2023\\5.棰嗗娼滃姏鎶ュ憡\\report\\LAQ缂栬瘧鎶ュ憡鑻辨枃.docx");XWPFDocument document = new XWPFDocument(POIXMLDocument.openPackage("D:\\娴嬭瘎绯荤粺\\闇�姹俓\2023\\5.棰嗗娼滃姏鎶ュ憡\\report\\LAQ鑻辨枃鐗�.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); @@ -81,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); } /** @@ -89,19 +99,19 @@ * @param textMap * @return */ - public static Map<Integer,List<SeriesData>> initData(Map<String, String> textMap){ + public static Map<Integer,List<SeriesData>> initData(Map<String, Object> textMap){ Map<Integer,List<SeriesData>> seriesDataMap = new HashMap<>(); //鑾峰彇鍛戒腑鏁板�� - Double olas = Double.valueOf(textMap.get("olas")); - Double ca = Double.valueOf(textMap.get("ca")); - Double bla = Double.valueOf(textMap.get("bla")); - Double nr = Double.valueOf(textMap.get("nr")); - Double ar = Double.valueOf(textMap.get("ar")); - Double open = Double.valueOf(textMap.get("open")); - Double cons = Double.valueOf(textMap.get("cons")); - Double extra = Double.valueOf(textMap.get("extra")); - Double agree = Double.valueOf(textMap.get("agree")); - Double emosta = Double.valueOf(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( @@ -266,7 +276,7 @@ * @param seriesDataMap * @param textMap 鏁版嵁婧� */ - public static void changeChart(XWPFDocument document, Map<Integer,List<SeriesData>> seriesDataMap, Map<String, String> textMap) { + public static void changeChart(XWPFDocument document, Map<Integer,List<SeriesData>> seriesDataMap, Map<String, Object> textMap) { if(StringUtils.isEmpty(textMap)){ return; } -- Gitblit v1.9.1