From 499b1d27da156ddd25c7adb58a5601805d8149fe Mon Sep 17 00:00:00 2001
From: 吴祝攀 <2040239371@qq.com>
Date: 星期五, 14 六月 2024 15:51:16 +0800
Subject: [PATCH] JAQ报告优化
---
src/main/java/com/ots/project/tool/report/JAQ/condition/JAQTeam.java | 3 +
src/main/java/com/ots/project/tool/report/LAQ/chart/LAQTest.java | 171 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2 files changed, 174 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/ots/project/tool/report/JAQ/condition/JAQTeam.java b/src/main/java/com/ots/project/tool/report/JAQ/condition/JAQTeam.java
index 75e16a5..a58020f 100644
--- a/src/main/java/com/ots/project/tool/report/JAQ/condition/JAQTeam.java
+++ b/src/main/java/com/ots/project/tool/report/JAQ/condition/JAQTeam.java
@@ -2,6 +2,9 @@
import lombok.Data;
+/**
+ * 杩欓噷鏄复鏃跺彉閲忕殑锛屽瓨鍌↗AQ鍙備笌浜哄憳鍚嶅崟琛�
+ */
@Data
public class JAQTeam {
//濮撳悕
diff --git a/src/main/java/com/ots/project/tool/report/LAQ/chart/LAQTest.java b/src/main/java/com/ots/project/tool/report/LAQ/chart/LAQTest.java
new file mode 100644
index 0000000..2ec6ea3
--- /dev/null
+++ b/src/main/java/com/ots/project/tool/report/LAQ/chart/LAQTest.java
@@ -0,0 +1,171 @@
+package com.ots.project.tool.report.LAQ.chart;
+
+import com.alibaba.fastjson.JSON;
+import com.microsoft.schemas.vml.CTTextbox;
+import com.ots.common.utils.poi.ExcelUtil;
+import com.ots.common.utils.poi.WordUtil;
+import com.ots.project.tool.report.LAQ.LAQReport;
+import com.ots.project.tool.report.LAQ.LAQTemplate;
+import com.ots.project.tool.report.MAQ.base.SeriesData;
+import lombok.extern.slf4j.Slf4j;
+import org.apache.poi.xwpf.usermodel.XWPFDocument;
+import org.apache.poi.xwpf.usermodel.XWPFParagraph;
+import org.apache.poi.xwpf.usermodel.XWPFRun;
+
+import java.awt.*;
+import java.io.*;
+import java.math.BigInteger;
+import java.util.*;
+
+
+import java.io.FileOutputStream;
+import java.io.IOException;
+import java.util.List;
+
+@Slf4j
+public class LAQTest {
+ public static void main(String[] args) throws Exception {
+ System.out.println("鍚姩娴嬭瘯..");
+
+
+//
+// try {
+// FileInputStream fis = new FileInputStream("D:\\妗岄潰鏂囦欢\\TaiTest.docx");
+// XWPFDocument document = new XWPFDocument(fis);
+//
+// List<XWPFParagraph> paragraphs = document.getParagraphs();
+// for (XWPFParagraph paragraph : paragraphs) {
+// for (XWPFRun run : paragraph.getRuns()) {
+// for (XWPFPicture picture : run.getEmbeddedPictures()) {
+// if (picture.getCTPicture() != null
+// && picture.getCTPicture().getSpPr() != null
+// && picture.getCTPicture().getSpPr().getXfrm() != null
+// && picture.getCTPicture().getSpPr().getXfrm().getExt() != null) {
+//
+// CTPositiveSize2D ext = picture.getCTPicture().getSpPr().getXfrm().getExt();
+// if (ext != null) {
+// long widthEmus = ext.getCx();
+// long heightEmus = ext.getCy();
+//
+// int width = (int) (widthEmus / 9525); // Convert EMUs to points (assuming 1 inch = 9525 EMUs)
+// int height = (int) (heightEmus / 9525); // Convert EMUs to points (assuming 1 inch = 9525 EMUs)
+//
+// System.out.println("Image Width: " + width + " points");
+// System.out.println("Image Height: " + height + " points");
+// }
+// } else {
+// System.err.println("Error: Unable to retrieve image width and height.");
+// }
+// }
+// }
+// }
+//
+//
+// // 鍒涘缓涓�涓柊鐨勬钀�
+//// XWPFParagraph paragraph = document.createParagraph();
+////
+//// // 璁剧疆娈佃惤鐨勫乏杈硅窛鍜屼笂杈硅窛
+////// paragraph.setIndentationLeft(0); // 0鏈�灏忋��7500
+////// paragraph.setSpacingBefore(0); // 璁剧疆涓婅竟璺濅负0
+//// paragraph.setIndentationLeft(7200);//鏈�澶�8000
+//// paragraph.setSpacingBefore(7000);//鏈�澶�7200
+////
+//// // 娣诲姞鏂囨湰鍒版钀�
+//// XWPFRun run = paragraph.createRun();
+//// run.setText("鍚寸鏀�");
+////
+////
+//// XWPFParagraph paragraph1 = document.createParagraph();
+//// paragraph1.setIndentationLeft(5000);//鏈�澶�8000
+//// paragraph1.setSpacingBefore(5000);//鏈�澶�7200
+//// XWPFRun run1= paragraph1.createRun();
+//// run1.setText("鍚磋鏅�");
+//
+//
+// // 鍒涘缓涓�涓舰鐘朵綔涓烘枃鏈
+// Shape textBox = new Shape(document, ShapeType.TEXT_BOX);
+//
+// // 璁剧疆鏂囨湰妗嗙殑鍐呭
+// textBox.getTextPath().setText("鏂囨湰妗嗕腑鐨勬枃鏈�");
+//
+// // 璁剧疆鏂囨湰妗嗙殑浣嶇疆鍜屽ぇ灏�
+// textBox.setWidth(200); // 璁剧疆瀹藉害
+// textBox.setHeight(100); // 璁剧疆楂樺害
+//
+// // 璁剧疆鏂囨湰妗嗙殑鑳屾櫙閫忔槑
+// textBox.setFilled(false); // 璁剧疆濉厖鑹蹭负閫忔槑
+// textBox.setStrokeColor(Color.WHITE); // 璁剧疆杈规棰滆壊涓洪�忔槑
+//
+// // 灏嗘枃鏈娣诲姞鍒版枃妗ｄ腑
+// doc.getFirstSection().getBody().getFirstParagraph().appendChild(textBox);
+//
+//
+// // 灏嗘枃妗ｅ啓鍏ュ埌鏂囦欢
+// FileOutputStream fos = new FileOutputStream("D:\\妗岄潰鏂囦欢\\TaiTest_out_"+ UUID.randomUUID().toString() +".docx");
+// document.write(fos);
+//
+// // 鍏抽棴鏂囦欢娴�
+// fis.close();
+// fos.close();
+//
+// } catch (IOException e) {
+// e.printStackTrace();
+// }
+//
+
+// FileInputStream fis = new FileInputStream("D:\\妗岄潰鏂囦欢\\TaiTest.docx");
+// Document doc = new Document(fis);
+//
+// // 鍒涘缓鏂囨湰妗�
+// Shape textBox = new Shape(doc, ShapeType.TEXT_BOX);
+// textBox.setWidth(200); // 璁剧疆鏂囨湰妗嗗搴�
+// textBox.setHeight(50); // 璁剧疆鏂囨湰妗嗛珮搴�
+// textBox.setWrapType(WrapType.NONE); // 璁剧疆鏂囨湰妗嗕笉鑷姩鎹㈣
+//
+// // 鍒涘缓鏂囨湰妗嗙殑娈佃惤鍜孯un瀵硅薄锛屽苟娣诲姞鍐呭
+// Paragraph para = new Paragraph(doc);
+// Run run = new Run(doc, "杩欐槸鏂囨湰妗嗕腑鐨勫唴瀹�");
+// para.appendChild(run);
+// textBox.appendChild(para);
+//
+// // 娣诲姞鏂囨湰妗嗗埌Word鏂囨。
+// doc.getFirstSection().getBody().getFirstParagraph().appendChild(textBox);
+//
+// // 淇濆瓨淇敼鍚庣殑Word鏂囨。
+// doc.save("D:\\妗岄潰鏂囦欢\\TaiTest_out_"+ UUID.randomUUID().toString() +".docx");
+//
+
+ // 鍒涘缓涓�涓┖鐨刉ord鏂囨。
+// XWPFDocument document = new XWPFDocument();
+//
+// // 鍒涘缓涓�涓钀�
+// XWPFParagraph paragraph = document.createParagraph();
+//
+// // 鍒涘缓涓�涓枃鏈
+// XWPFRun run = paragraph.createRun();
+// CTTextbox textbox = run.getCTR().addNewTextbox();
+// CTTextboxContent textboxContent = textbox.addNewTextboxContent();
+//
+// // 璁剧疆鏂囨湰妗嗙殑浣嶇疆鍜屽ぇ灏�
+// textbox.setInset(new BigInteger("0"));
+// textboxContent.setWMode(STTextbox.WMode.WINDOW);
+// textboxContent.setNoBorder(true);
+// textboxContent.setAnchor(STTextAnchoringType.MIDDLE);
+// textboxContent.setAnchorCenter(true);
+//
+// // 璁剧疆鏂囨湰妗嗙殑鍐呭
+// textboxContent.setT("This is a text box.");
+//
+// // 淇濆瓨鏂囨。
+// try {
+// FileOutputStream out = new FileOutputStream("example.docx");
+// document.write(out);
+// out.close();
+// System.out.println("Word鏂囨。鍒涘缓鎴愬姛锛�");
+// } catch (Exception e) {
+// e.printStackTrace();
+// }
+
+ }
+
+}
--
Gitblit v1.9.1