From 95eb8a2a75cbeebcb3393d404c1952bd59b8989a Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期五, 01 八月 2025 13:50:16 +0800
Subject: [PATCH] feat: 新增第三方接口访问
---
src/main/java/com/ots/project/tool/report/LAQ/chart/LAQChart.java | 52 +++++++++++++++++++++++++++++++++++-----------------
1 files changed, 35 insertions(+), 17 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 4ff2859..fe67dd3 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,17 +48,17 @@
public static void main(String[] args) throws Exception {
- /*String dataPath = "D:\\娴嬭瘎绯荤粺\\闇�姹俓\LAQ\\report\\LAQ琛ㄥご鏁版嵁鏂囦欢.xlsx";
- // 鑾峰彇瀵煎叆鏁版嵁
- File file = new File(dataPath);
- InputStream in = new FileInputStream(file);
- ExcelUtil<LAQTemplate> util = new ExcelUtil<>(LAQTemplate.class);
- List<LAQTemplate> laqTemplateList = util.importExcel(in);
+// String dataPath = "D:\\娴嬭瘎绯荤粺\\闇�姹俓\LAQ\\report\\LAQ琛ㄥご鏁版嵁鏂囦欢.xlsx";
+// // 鑾峰彇瀵煎叆鏁版嵁
+// File file = new File(dataPath);
+// InputStream in = new FileInputStream(file);
+// ExcelUtil<LAQTemplate> util = new ExcelUtil<>(LAQTemplate.class);
+// List<LAQTemplate> laqTemplateList = util.importExcel(in);
// 鐢熸垚鏂囦欢闆嗗悎
List<String> fileNameList = new ArrayList<>();
List<String> deleteStrList = new ArrayList<>();
- for (int i = 0; i < laqTemplateList.size(); i++) {
- LAQTemplate laqTemplate = laqTemplateList.get(i);
+ for (int i = 0; i < 1; i++) {
+// LAQTemplate laqTemplate = laqTemplateList.get(i);
//缁勮鎶ュ憡鎵�鐢ㄦ暟鎹�
Map<String, Object> textMap = new HashMap<>();
// textMap.put("sendEmailFileName",laqTemplate.getName());
@@ -74,7 +74,7 @@
textMap.put("extra","48");
textMap.put("agree","90");
textMap.put("emosta","23");
- textMap.put("perfomance","80");
+// textMap.put("perfomance","0");
LAQReport report = new LAQReport();
@@ -83,7 +83,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:\\娴嬭瘎绯荤粺\\闇�姹俓\LAQ\\report\\LAQ鑻辨枃妯℃澘-wzp-淇敼鐗�-1.docx");XWPFDocument document = new XWPFDocument(POIXMLDocument.openPackage("D:\\娴嬭瘎绯荤粺\\闇�姹俓\LAQ\\report\\LAQ鑻辨枃妯℃澘-wzp-淇敼鐗�.docx"))){
+ try (OutputStream os = new FileOutputStream("D:\\TaiOS\\LAQ-1.docx");XWPFDocument document = new XWPFDocument(POIXMLDocument.openPackage("D:\\TaiOS\\LAQ.docx"))){
Map<Integer,List<SeriesData>> seriesDatas = initData(textMap);
changeChart(document,seriesDatas,textMap);
document.write(os);
@@ -93,7 +93,7 @@
log.info("鍒犻櫎鐨勬枃浠跺悕:{}", JSON.toJSONString(deleteStrList));
WordUtil.deleteFileByStr(deleteStrList);
- }*/
+ }
}
/**
@@ -124,7 +124,13 @@
Double extra = Double.valueOf((String)textMap.get("extra"));
Double agree = Double.valueOf((String)textMap.get("agree"));
Double emosta = Double.valueOf((String)textMap.get("emosta"));
- Double perfomance = Double.valueOf((String)textMap.get("perfomance"));
+ Double perfomance;
+ if(textMap.get("perfomance") != null){
+ perfomance = Double.valueOf((String)textMap.get("perfomance"));
+ }else{
+ perfomance = -1D;
+ }
+
// 鍥捐〃1
List<SeriesData> seriesDatas = Arrays.asList(
@@ -283,7 +289,7 @@
// 鍥捐〃11
seriesDatas = Arrays.asList(
new SeriesData("X 鍊�", Arrays.asList(
- new RowData("X 鍊�", olas.doubleValue())
+ new RowData("X 鍊�", perfomance.doubleValue() == -1 ? perfomance.doubleValue() : olas.doubleValue())
)),
new SeriesData("Y 鍊�", Arrays.asList(
new RowData("Y 鍊�", perfomance.doubleValue())
@@ -366,7 +372,7 @@
} catch (Exception e) {
e.printStackTrace();
- log.error("MAQTR鏇挎崲word鍥捐〃 鏁ｇ偣鍥惧浘褰㈠け璐ワ細{}",e);
+ log.error("LAQ.鏇挎崲word鍥捐〃 鏁ｇ偣鍥惧浘褰㈠け璐ワ細{}",e);
}
}
@@ -446,7 +452,11 @@
if(StringUtils.isNotEmpty(cellValu.valueStr)){
cell.setCellValue(cellValu.valueStr);
}else{
- cell.setCellValue(cellValu.value);
+ if(cellValu.value != -1){
+ cell.setCellValue(cellValu.value);
+ }else{
+ cell.setCellValue((String) null);
+ }
}
}
@@ -491,7 +501,11 @@
CTNumVal val = xNumCnt > i ? xDataSource.getNumRef().getNumCache().getPtArray(i)
: xDataSource.getNumRef().getNumCache().addNewPt();
val.setIdx(i);
- val.setV(String.format("%.0f", cellValu.value));
+ if(cellValu.value == -1){
+ val.setV(null);
+ }else {
+ val.setV(String.format("%.0f", cellValu.value));
+ }
}
//鏇存柊Y鍧愭爣缂撳瓨
@@ -500,7 +514,11 @@
CTNumVal val = yNumCnt > i ? yDataSource.getNumRef().getNumCache().getPtArray(i)
: yDataSource.getNumRef().getNumCache().addNewPt();
val.setIdx(i);
- val.setV(String.format("%.0f", cellValu.value));
+ if(cellValu.value == -1){
+ val.setV(null);
+ }else {
+ val.setV(String.format("%.0f", cellValu.value));
+ }
}
// 鏇存柊瀵瑰簲excel鐨勮寖鍥�
--
Gitblit v1.9.1