From b4b118315f3959c6cd01b2e6e6e3ff02cdc3b4bc Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期三, 18 六月 2025 09:37:36 +0800
Subject: [PATCH] 电网拓扑功率历史导出(多code)
---
ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)
diff --git a/ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java b/ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java
index bea2bfd..ba5e146 100644
--- a/ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java
+++ b/ansteel-biz/src/main/java/com/iailab/module/ansteel/api/controller/admin/PowerController.java
@@ -1137,9 +1137,10 @@
}
@PostMapping("/net-factor/export-history")
- @Operation(summary = "功率因数-电网拓扑功率历史(多code)")
+ @Operation(summary = "功率因数-电网拓扑功率历史导出(多code)")
public void exportPowerHistoryList(HttpServletResponse response, HttpServletRequest
request, @RequestBody PowerNetFactorHisReqDTO dto) throws IOException {
+ log.info("exportPowerHistoryList开始");
List<String> column = new ArrayList<>();
column.add("时间");
List<List<Object>> exportData = new ArrayList<>();
@@ -1209,6 +1210,7 @@
Map<String, Object> dataMap = new HashMap<>();
if (StringUtils.isNotBlank(pointNo)) {
+ log.info("查询功率");
apiPointValueQueryDTO.setPointNo(pointNo);
List<ApiPointValueDTO> chartData = dataPointApi.queryPointHistoryValue(apiPointValueQueryDTO);
for (ApiPointValueDTO pv : chartData) {
@@ -1217,6 +1219,7 @@
dataMap.put(key, val);
}
} else if (StringUtils.isNotBlank(pointNoArr[0]) && StringUtils.isNotBlank(pointNoArr[1])) {
+ log.info("查询累计功率");
apiPointValueQueryDTO.setPointNo(pointNoArr[0]);
List<ApiPointValueDTO> chartDataP = dataPointApi.queryPointHistoryValue(apiPointValueQueryDTO);
Map<String, Double> dataMapP = new HashMap<>();
@@ -1243,11 +1246,14 @@
for (String cate : categories) {
List<Object> row = new ArrayList<>();
+ row.add(cate);
for (String col : column) {
row.add(dataAll.get(col).get(cate));
}
+ exportData.add(row);
}
-
+ log.info("column=" + JSONArray.toJSONString(column));
+ log.info("exportData.size=" + exportData.size());
ExcelUtils.write(response, "历史.xlsx", "历史数据", column, exportData);
}
--
Gitblit v1.9.3