From a30cc74a46477c1820c6114cbda7f4e11b3aaf0d Mon Sep 17 00:00:00 2001
From: jpy <812110275@qq.com>
Date: Sun, 28 May 2023 16:10:24 +0800
Subject: [PATCH] 风场sql
---
screen-api/src/main/java/com/moral/api/controller/MonitorPointController.java | 45 +++++++++++++++++++++++++++++++++------------
1 files changed, 33 insertions(+), 12 deletions(-)
diff --git a/screen-api/src/main/java/com/moral/api/controller/MonitorPointController.java b/screen-api/src/main/java/com/moral/api/controller/MonitorPointController.java
index e8fb716..ca63bcd 100644
--- a/screen-api/src/main/java/com/moral/api/controller/MonitorPointController.java
+++ b/screen-api/src/main/java/com/moral/api/controller/MonitorPointController.java
@@ -17,11 +17,16 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
+import java.util.ArrayList;
+import java.util.Arrays;
import java.util.List;
import java.util.Map;
+import java.util.stream.Collectors;
import javax.servlet.http.HttpServletRequest;
@@ -61,14 +66,14 @@
}
/**
- * @Description: ������������������������������id������name
- * @Param: [organizationId]
- * @return: com.moral.constant.ResultMessage
- * @Author: ���������
- * @Date: 2021/9/26
- */
+ * @Description: ������������������������������id������name
+ * @Param: [organizationId]
+ * @return: com.moral.constant.ResultMessage
+ * @Author: ���������
+ * @Date: 2021/9/26
+ */
@GetMapping("queryAllMonitorPoints")
- public ResultMessage queryAllMonitorPoints(Integer organizationId){
+ public ResultMessage queryAllMonitorPoints(Integer organizationId) {
//������������������
List<MonitorPoint> monitorPoints = monitorPointService.queryAllMonitorPoints(organizationId);
//������������
@@ -98,11 +103,11 @@
}
/**
- *@Description: ������������������������������
- *@Param: [request]
- *@return: com.moral.constant.ResultMessage
- *@Author: lizijie
- *@Date: 2022-10-10 14:00
+ * @Description: ������������������������������
+ * @Param: [request]
+ * @return: com.moral.constant.ResultMessage
+ * @Author: lizijie
+ * @Date: 2022-10-10 14:00
**/
@GetMapping("getHourlyDataByMonitorPoint")
public ResultMessage getHourlyDataByMonitorPoint(HttpServletRequest request) {
@@ -114,4 +119,20 @@
return ResultMessage.ok(resultList);
}
+ /**
+ * ������������������������
+ *
+ * @param params
+ * @return
+ */
+ @PostMapping("getHourlyDataExcel")
+ public ResultMessage getHourlyDataExcel(@RequestBody Map<String, Object> params) {
+ if (!params.containsKey("macs") || !params.containsKey("sensors") || !params.containsKey("startTime") || !params.containsKey("endTime")) {
+ return ResultMessage.fail(ResponseCodeEnum.PARAMETERS_IS_MISSING.getCode(), ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
+ }
+ List<Map<String, Object>> resList = monitorPointService.getHourlyDataDataV3(params);
+ return ResultMessage.ok(resList);
+ }
+
+
}
--
Gitblit v1.8.0