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 |   63 ++++++++++++++++++++++++++-----
 1 files changed, 52 insertions(+), 11 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 7b5ae9c..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
@@ -3,10 +3,8 @@
 import com.moral.api.entity.MonitorPoint;
 import com.moral.api.pojo.form.device.MonitorPointQueryForm;
 import com.moral.api.pojo.vo.monitorPoint.MonitorPointsVO;
-import com.moral.api.pojo.vo.monitorPoint.StateControllerStationVO;
 import com.moral.api.service.HistoryFiveMinutelyService;
 import com.moral.api.service.MonitorPointService;
-import com.moral.api.service.OrganizationService;
 import com.moral.constant.ResponseCodeEnum;
 import com.moral.constant.ResultMessage;
 import com.moral.util.WebUtils;
@@ -19,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;
 
@@ -62,16 +65,21 @@
         return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(), ResponseCodeEnum.SUCCESS.getMsg(), vo);
     }
 
-    @GetMapping("queryStateControlStation")
-    public ResultMessage queryStateControlStation(Integer regionCode) {
-
-        List<MonitorPoint> monitorPoints = monitorPointService.queryStateControlStationByRegionCode(regionCode);
-
-        //������������������������
-        StateControllerStationVO vo = StateControllerStationVO.convert(monitorPoints);
-
-        return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(), ResponseCodeEnum.SUCCESS.getMsg(), vo);
+    /**
+     * @Description: ������������������������������id������name
+     * @Param: [organizationId]
+     * @return: com.moral.constant.ResultMessage
+     * @Author: ���������
+     * @Date: 2021/9/26
+     */
+    @GetMapping("queryAllMonitorPoints")
+    public ResultMessage queryAllMonitorPoints(Integer organizationId) {
+        //������������������
+        List<MonitorPoint> monitorPoints = monitorPointService.queryAllMonitorPoints(organizationId);
+        //������������
+        return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(), ResponseCodeEnum.SUCCESS.getMsg(), monitorPoints);
     }
+
 
     /**
      * @param request ������������
@@ -94,4 +102,37 @@
         return ResultMessage.ok(response);
     }
 
+    /**
+     * @Description: ������������������������������
+     * @Param: [request]
+     * @return: com.moral.constant.ResultMessage
+     * @Author: lizijie
+     * @Date: 2022-10-10 14:00
+     **/
+    @GetMapping("getHourlyDataByMonitorPoint")
+    public ResultMessage getHourlyDataByMonitorPoint(HttpServletRequest request) {
+        Map<String, Object> params = WebUtils.getParametersStartingWith(request, null);
+        if (!params.containsKey("monitorPointId") || !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>> resultList = monitorPointService.getHourlyDataByMonitorPoint(params);
+        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