From 23bbee889008c89ca39632ff4c86724d57517906 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 11 二月 2023 15:10:53 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/sys/ReportService.java | 77 ++++++++++++++++++++++++++++++++++++--
1 files changed, 73 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/lf/server/service/sys/ReportService.java b/src/main/java/com/lf/server/service/sys/ReportService.java
index cb77083..84a5a31 100644
--- a/src/main/java/com/lf/server/service/sys/ReportService.java
+++ b/src/main/java/com/lf/server/service/sys/ReportService.java
@@ -14,9 +14,7 @@
import javax.servlet.http.HttpServletResponse;
import java.io.File;
-import java.util.ArrayList;
-import java.util.Date;
-import java.util.List;
+import java.util.*;
/**
* 鎶ュ憡妯℃澘
@@ -153,7 +151,17 @@
break;
}
} else {
- //
+ switch (re.getCode()) {
+ case "countOperates ":
+ createCountOperatesExcel(source, target);
+ break;
+ case "countSizes":
+ createCountSizesExcel(source, target);
+ break;
+ default:
+ createCountServicesExcel(source, target);
+ break;
+ }
}
}
@@ -215,6 +223,67 @@
}
/**
+ * 鍒涘缓 鐢ㄦ埛娴侀噺缁熻 Excel
+ */
+ public void createCountOperatesExcel(String source, String target) {
+ List<CountEntity> list = countOperates();
+ if (null == list || list.isEmpty()) {
+ return;
+ }
+
+ int rows = 1;
+ for (CountEntity ce : list) {
+ ce.setNo(rows++);
+ }
+
+ Map<String, List<CountEntity>> map = new HashMap<>();
+ map.put("data", list);
+
+ ExcelHelper.writeToTemplate(source, target, map);
+ }
+
+ /**
+ * 鍒涘缓 鏈嶅姟璋冪敤閲忕粺璁� Excel
+ */
+ public void createCountServicesExcel(String source, String target) {
+ List<CountEntity> list = countServices();
+ if (null == list || list.isEmpty()) {
+ return;
+ }
+
+ int rows = 1;
+ for (CountEntity ce : list) {
+ ce.setNo(rows++);
+ }
+
+ Map<String, List<CountEntity>> map = new HashMap<>();
+ map.put("data", list);
+
+ ExcelHelper.writeToTemplate(source, target, map);
+ }
+
+ /**
+ * 鍒涘缓 鏁版嵁閲忕粺璁� Excel
+ */
+ public void createCountSizesExcel(String source, String target) {
+ List<CountEntity> list = countSizes();
+ if (null == list || list.isEmpty()) {
+ return;
+ }
+
+ int rows = 1;
+ for (CountEntity ce : list) {
+ ce.setNo(rows++);
+ ce.setM2(FileHelper.getSizes(ce.getSizes()));
+ }
+
+ Map<String, List<CountEntity>> map = new HashMap<>();
+ map.put("data", list);
+
+ ExcelHelper.writeToTemplate(source, target, map);
+ }
+
+ /**
* 鑾峰彇涓嬭浇瀹炰綋绫�
*/
private DownloadEntity getDownloadEntity(UserEntity ue, String file) {
--
Gitblit v1.9.3