From c66c9f239e2654222e1b5620861850e4aa9df62b Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Fri, 13 Nov 2020 09:50:35 +0800
Subject: [PATCH] 沧州项目服务账号沧州地图不显示设备图标处理

---
 src/main/java/com/moral/controller/ScreenController.java |   72 ++++++++++++++++++++++++++++++++---
 1 files changed, 65 insertions(+), 7 deletions(-)

diff --git a/src/main/java/com/moral/controller/ScreenController.java b/src/main/java/com/moral/controller/ScreenController.java
index 8ecd5e6..84a1798 100644
--- a/src/main/java/com/moral/controller/ScreenController.java
+++ b/src/main/java/com/moral/controller/ScreenController.java
@@ -41,6 +41,7 @@
 
 import com.rabbitmq.client.*;
 import com.rabbitmq.client.Channel;
+
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiImplicitParam;
 import io.swagger.annotations.ApiImplicitParams;
@@ -48,6 +49,7 @@
 import io.swagger.models.auth.In;
 import jdk.nashorn.internal.runtime.regexp.joni.Regex;
 import net.sf.json.JSONString;
+
 import org.apache.commons.collections.CollectionUtils;
 import org.apache.commons.collections.MapUtils;
 import org.apache.commons.net.ftp.FTPClient;
@@ -72,6 +74,7 @@
 import org.springframework.web.bind.annotation.RestController;
 import org.springframework.web.servlet.ModelAndView;
 import org.xml.sax.InputSource;
+
 import static com.moral.common.util.ResourceUtil.getValue;
 import static com.moral.common.util.WebUtils.getParametersStartingWith;
 import static java.util.Calendar.*;
@@ -2037,7 +2040,7 @@
             mon = "" + month;
         }
         String table = "history_minutely_" + year + mon;
-        List list = deviceService.byMonitorIdGetDeviceAndWind(monitorPointId,table);
+        List list = deviceService.byMonitorIdGetDeviceAndWind(monitorPointId, table);
         return list;
     }
 
@@ -2058,7 +2061,7 @@
             mon = "" + month;
         }
         String table = "history_minutely_" + year + mon;
-        List list = deviceService.byMonitorIdGetDeviceAndWindSpecial(monitorPointId,table);
+        List list = deviceService.byMonitorIdGetDeviceAndWindSpecial(monitorPointId, table);
         return list;
     }
 
@@ -2182,7 +2185,7 @@
                     for (Map<String, Object> dataMap : dataList) {
                         JSONObject dataJson = JSONObject.parseObject(dataMap.get("json").toString());
                         if (dataMap.get("time").toString().equals(day + " 00:00:00.0")) {
-                            oneSensorMap.put(dataMap.get("time").toString().substring(0, 10), dataJson.getJSONArray(key).get(2));
+                            oneSensorMap.put(dataMap.get("time").toString().substring(0, 10), dataJson.getJSONArray(key).get(0));
                             break;
                         } else {
                             continue;
@@ -2198,7 +2201,7 @@
                     for (Map sameDayHourlyMap : sameDayHourlyList) {
                         List<Double> arr = new ArrayList<>();
                         JSONObject hourlyJson = JSONObject.parseObject(sameDayHourlyMap.get("json").toString());
-                        arr.add(Double.parseDouble(hourlyJson.getJSONArray(key).get(2).toString()));
+                        arr.add(Double.parseDouble(hourlyJson.getJSONArray(key).get(0).toString()));
                         Double sum = 0.0;
                         for (int i = 0; i < arr.size(); i++) {
                             sum += arr.get(i);
@@ -2234,8 +2237,10 @@
                     for (Map<String, Object> hourlyMap : hourlyList) {
                         JSONObject dataJson = JSONObject.parseObject(hourlyMap.get("json").toString());
                         if (hourlyMap.get("time").toString().equals(hour + ".0")) {
-                            oneSensorMap.put(hourlyMap.get("time").toString().substring(0, 19), dataJson.getJSONArray(key).get(2));
-                            break;
+                            if (dataJson.getJSONArray(key) != null) {
+                                oneSensorMap.put(hourlyMap.get("time").toString().substring(0, 19), dataJson.getJSONArray(key).get(0));
+                                break;
+                            }
                         } else {
                             continue;
                         }
@@ -2596,4 +2601,57 @@
         }
         return 0;
     }
-}
\ No newline at end of file
+
+    @RequestMapping("/biaozhun")
+    @ResponseBody
+    public List<Device> queryDevice(String macOrName){
+        List<Device> deviceList = new ArrayList<>();
+        if (!macOrName.equals("")){
+             deviceList= deviceService.getDevice(macOrName);
+        }
+        return deviceList;
+    }
+
+    @RequestMapping("/getBiaoZhun")
+    @ResponseBody
+    public List<DeviceAdjustValueTiming> getBiaoZhun(String id){
+        List<DeviceAdjustValueTiming> dataByDeviceid = deviceAdjustValueTimingService.getDataByDeviceid(Integer.parseInt(id));
+        for (DeviceAdjustValueTiming deviceAdjustValueTiming : dataByDeviceid) {
+            int seconds = Integer.parseInt(deviceAdjustValueTiming.getSeconds());
+            String hour = String.valueOf(seconds/3600);
+            int millAndSeconds = seconds%3600;
+            String mill = String.valueOf(millAndSeconds/60);
+            String second = String.valueOf(millAndSeconds%60);
+            if (hour.length()<2){
+                hour="0"+hour;
+            }
+            if (mill.length()<2){
+                mill="0"+mill;
+            }
+            if (second.length()<2){
+                second="0"+second;
+            }
+            String time = hour+":"+mill+":"+second;
+            Map<String, String> value = deviceAdjustValueTiming.getValue();
+            Collection<String> values = value.values();
+            deviceAdjustValueTiming.setSeconds(time);
+        }
+        return dataByDeviceid;
+    }
+
+
+    @RequestMapping("/getSensor")
+    @ResponseBody
+    public  List<Map<String, Object>> getSensor(String id){
+        List<Map<String, Object>> allSensors = sensorService.getSensorByDeviceId(id);
+        return allSensors;
+    }
+
+    @RequestMapping("/deleteBiaoZhun")
+    @ResponseBody
+    public int deleteBiaoZhun(String id){
+        int i= deviceAdjustValueTimingService.delete(id);
+        return i;
+    }
+
+}

--
Gitblit v1.8.0