From 9655ea9ce8cdd671a766f87a0885b0fdff7b89c9 Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Thu, 24 Aug 2023 17:12:28 +0800
Subject: [PATCH] Merge branch 'dev' of http://blit.7drlb.com:8888/r/moral into wb

---
 screen-api/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java           |   10 ++
 screen-manage/src/main/java/com/moral/api/util/AdjustDataUtils.java                  |   68 +++++++++-------
 screen-api/src/main/java/com/moral/api/config/Interceptor/WebAppConfiguration.java   |    5 -
 screen-manage/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java |   13 +-
 screen-api/src/main/java/com/moral/api/config/Interceptor/CorsConfig.java            |   51 ++++++++++++
 screen-api/src/main/java/com/moral/api/dto/MonitoringStationDTO.java                 |    4 +
 screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java     |   58 ++++++++++++--
 screen-manage/src/main/java/com/moral/api/kafka/consumer/DeviceConsumer.java         |   16 +++
 8 files changed, 173 insertions(+), 52 deletions(-)

diff --git a/screen-api/src/main/java/com/moral/api/config/Interceptor/CorsConfig.java b/screen-api/src/main/java/com/moral/api/config/Interceptor/CorsConfig.java
new file mode 100644
index 0000000..7db0bc2
--- /dev/null
+++ b/screen-api/src/main/java/com/moral/api/config/Interceptor/CorsConfig.java
@@ -0,0 +1,51 @@
+package com.moral.api.config.Interceptor;
+
+import org.springframework.boot.SpringBootConfiguration;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.Configuration;
+import org.springframework.web.cors.CorsConfiguration;
+import org.springframework.web.cors.UrlBasedCorsConfigurationSource;
+import org.springframework.web.filter.CorsFilter;
+import org.springframework.web.servlet.config.annotation.CorsRegistry;
+import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
+
+/**
+ * @ClassName CorsConfig
+ * @Description TODO
+ * @Author @lizijie
+ * @Date 2023-08-23 13:27
+ * @Version 1.0
+ */
+@Configuration
+public class CorsConfig {
+
+    @Bean
+    public CorsFilter corsFilter() {
+
+        CorsConfiguration config = new CorsConfiguration();
+        //������������ip���������������������������������������������������������������
+        config.addAllowedOrigin("*");
+        //������������������Cookie������
+        config.setAllowCredentials(true);
+        //������������Http���������������������������
+        config.addAllowedMethod("*");
+        //������HTTP������������������������Header������
+        config.addAllowedHeader("*");
+        //������������������������������������������������������������������������������������
+//        config.addExposedHeader("*");
+
+        config.addExposedHeader("Content-Type");
+        config.addExposedHeader( "X-Requested-With");
+        config.addExposedHeader("accept");
+        config.addExposedHeader("Origin");
+        config.addExposedHeader( "Access-Control-Request-Method");
+        config.addExposedHeader("Access-Control-Request-Headers");
+
+        //������������������������/**������������������������������������������������������������������
+        UrlBasedCorsConfigurationSource configSource = new UrlBasedCorsConfigurationSource();
+        configSource.registerCorsConfiguration("/**", config);
+
+        return new CorsFilter(configSource);
+    }
+
+}
diff --git a/screen-api/src/main/java/com/moral/api/config/Interceptor/WebAppConfiguration.java b/screen-api/src/main/java/com/moral/api/config/Interceptor/WebAppConfiguration.java
index f1cde10..ffb1dfa 100644
--- a/screen-api/src/main/java/com/moral/api/config/Interceptor/WebAppConfiguration.java
+++ b/screen-api/src/main/java/com/moral/api/config/Interceptor/WebAppConfiguration.java
@@ -4,10 +4,7 @@
 import org.springframework.boot.system.ApplicationHome;
 import org.springframework.context.annotation.Bean;
 import org.springframework.context.annotation.Configuration;
-import org.springframework.web.servlet.config.annotation.InterceptorRegistration;
-import org.springframework.web.servlet.config.annotation.InterceptorRegistry;
-import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry;
-import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
+import org.springframework.web.servlet.config.annotation.*;
 
 import java.util.ArrayList;
 
diff --git a/screen-api/src/main/java/com/moral/api/dto/MonitoringStationDTO.java b/screen-api/src/main/java/com/moral/api/dto/MonitoringStationDTO.java
index 54dc8be..2e50d5b 100644
--- a/screen-api/src/main/java/com/moral/api/dto/MonitoringStationDTO.java
+++ b/screen-api/src/main/java/com/moral/api/dto/MonitoringStationDTO.java
@@ -36,10 +36,14 @@
     private int CompositeNum;
 
     private BigDecimal SO2;
+    private int SO2Num;
 
     private BigDecimal NO2;
+    private int NO2Num;
 
     private BigDecimal PM10;
+    private int PM10Num;
 
     private BigDecimal CO;
+    private int CONum;
 }
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java
index 005d4ca..9619dba 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java
@@ -358,8 +358,14 @@
                     Map<String,Object> historyHourlyMap = new HashMap<>();
                     historyHourlyMap.put("mac",mac);
                     JSONObject value = JSONObject.parseObject(historyFiveMinutely.getValue());
-                    Double sensorValue = Double.parseDouble(value.get(sensorCode).toString());
-                    historyHourlyMap.put(sensorCode,sensorValue);
+                    if (value.get(sensorCode)==null){
+                        historyHourlyMap.put(sensorCode,0.0);
+                    }else {
+                        Double sensorValue = Double.parseDouble(value.get(sensorCode).toString());
+                        historyHourlyMap.put(sensorCode,sensorValue);
+                    }
+//                    Double sensorValue = Double.parseDouble(value.get(sensorCode).toString());
+//                    historyHourlyMap.put(sensorCode,sensorValue);
                     Date time = historyFiveMinutely.getTime();
                     String timeStr = DateUtils.dateToDateString(time, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
                     historyHourlyMap.put("time",timeStr);
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java
index 26353e6..b5e058d 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java
@@ -525,7 +525,6 @@
             return list;
         }
         Map<String,Map<String,ArrayList<Double>>> resultMap = new HashMap<>();
-        int zz = 0;
         for(HistoryDaily h : historyDailyByMacAndTimeSlot) {
             JSONObject jsonObject = JSONObject.parseObject(h.getValue());
             Map<String, Object> map = jsonObject.getInnerMap();
@@ -556,8 +555,6 @@
                 maps.put("NO2",numResult);
             }
             if(Objects.nonNull(map.get("a21005"))){
-                System.out.println(">>>"+map.toString());
-                System.out.println(">>>"+map.get("a21005").toString());
                 ArrayList<Double> numResult = Objects.nonNull(maps.get("CO"))?maps.get("CO"):new ArrayList<>();
                 numResult.add(Double.parseDouble(map.get("a21005").toString()));
                 maps.put("CO",numResult);
@@ -568,7 +565,6 @@
                 maps.put("TVOC",numResult);
             }
             resultMap.put(h.getMac(),maps);
-            zz++;
         }
         for(Map.Entry entry : resultMap.entrySet()){
             String mapKey = (String) entry.getKey();
@@ -583,21 +579,21 @@
             }
             if(mapValue.containsKey("PM10")){
                 Double ListAvg = mapValue.get("PM10").stream().collect(Collectors.averagingDouble(Double::doubleValue));
-                double rsAvg = new BigDecimal(ListAvg).setScale(3, BigDecimal.ROUND_HALF_UP).doubleValue();
+                double rsAvg = new BigDecimal(ListAvg).setScale(0, BigDecimal.ROUND_HALF_UP).doubleValue();
                 data.put("PM10",rsAvg);
             }else {
                 data.put("PM10",0);
             }
             if(mapValue.containsKey("SO2")){
                 Double ListAvg = mapValue.get("SO2").stream().collect(Collectors.averagingDouble(Double::doubleValue));
-                double rsAvg = new BigDecimal(ListAvg).setScale(3, BigDecimal.ROUND_HALF_UP).doubleValue();
+                double rsAvg = new BigDecimal(ListAvg).setScale(0, BigDecimal.ROUND_HALF_UP).doubleValue();
                 data.put("SO2",rsAvg);
             }else {
                 data.put("SO2",0);
             }
             if(mapValue.containsKey("NO2")){
                 Double ListAvg = mapValue.get("NO2").stream().collect(Collectors.averagingDouble(Double::doubleValue));
-                double rsAvg = new BigDecimal(ListAvg).setScale(3, BigDecimal.ROUND_HALF_UP).doubleValue();
+                double rsAvg = new BigDecimal(ListAvg).setScale(0, BigDecimal.ROUND_HALF_UP).doubleValue();
                 data.put("NO2",rsAvg);
             }else {
                 data.put("NO2",0);
@@ -629,6 +625,10 @@
             monitoringStationDTO.setO3(BigDecimal.valueOf(Double.parseDouble(data.get("O3").toString())));
             monitoringStationDTO.setTovc(BigDecimal.valueOf(Double.parseDouble(data.get("TVOC").toString())));
             monitoringStationDTO.setComposite(BigDecimal.valueOf(resultNum));
+            monitoringStationDTO.setSO2(BigDecimal.valueOf(Double.parseDouble(data.get("SO2").toString())));
+            monitoringStationDTO.setNO2(BigDecimal.valueOf(Double.parseDouble(data.get("NO2").toString())));
+            monitoringStationDTO.setPM10(BigDecimal.valueOf(Double.parseDouble(data.get("PM10").toString())));
+            monitoringStationDTO.setCO(BigDecimal.valueOf(Double.parseDouble(data.get("CO").toString())));
             monitoringStationDTO.setMac(mapKey);
             list.add(monitoringStationDTO);
         }
@@ -636,12 +636,16 @@
         List<MonitoringStationDTO> pM25List = fun3(list,2);
         List<MonitoringStationDTO> o3List = fun3(list,3);
         List<MonitoringStationDTO> tovcList = fun3(list,4);
+        List<MonitoringStationDTO> SO2List = fun3(list,5);
+        List<MonitoringStationDTO> NO2cList = fun3(list,6);
+        List<MonitoringStationDTO> PM10List = fun3(list,7);
+        List<MonitoringStationDTO> COList = fun3(list,8);
         List<MonitoringStationDTO> resultList = new ArrayList<>();
         LambdaQueryChainWrapper<Device> wrapper = deviceService.lambdaQuery();
         wrapper.eq(Device::getIsDelete,0);
         Map<String,String> deviceMap =  new HashMap<>();
         wrapper.list().forEach(it->deviceMap.put(it.getMac(),it.getName()));
-        int num = 1;
+
         for (MonitoringStationDTO m :compositeList ){
             MonitoringStationDTO monit = new MonitoringStationDTO();
             String mac = m.getMac();
@@ -658,7 +662,19 @@
             monit.setPM25Num(pM25List.get(listPM25.indexOf(mac)).getPM25Num());
             monit.setTovc(tovcList.get(listTovc.indexOf(mac)).getTovc());
             monit.setTOVCNum(tovcList.get(listTovc.indexOf(mac)).getTOVCNum());
-            //num++;
+            List<String> listSO2 = SO2List.stream().map(MonitoringStationDTO::getMac).collect(Collectors.toList());
+            monit.setSO2(SO2List.get(listSO2.indexOf(mac)).getSO2());
+            monit.setSO2Num(SO2List.get(listSO2.indexOf(mac)).getSO2Num());
+            List<String> listNO2 = NO2cList.stream().map(MonitoringStationDTO::getMac).collect(Collectors.toList());
+            monit.setNO2(NO2cList.get(listNO2.indexOf(mac)).getNO2());
+            monit.setNO2Num(NO2cList.get(listNO2.indexOf(mac)).getNO2Num());
+            List<String> listPM10 = PM10List.stream().map(MonitoringStationDTO::getMac).collect(Collectors.toList());
+            monit.setPM10(PM10List.get(listPM10.indexOf(mac)).getPM10());
+            monit.setPM10Num(PM10List.get(listPM10.indexOf(mac)).getPM10Num());
+            List<String> listCO = COList.stream().map(MonitoringStationDTO::getMac).collect(Collectors.toList());
+            monit.setCO(COList.get(listCO.indexOf(mac)).getCO());
+            monit.setCONum(COList.get(listCO.indexOf(mac)).getCONum());
+
             resultList.add(monit);
         }
         return resultList;
@@ -680,6 +696,18 @@
         }else if(type == 4){
             compositeList = monList.stream().sorted(Comparator.comparing(MonitoringStationDTO::getTovc)).collect(Collectors.toList());
             map1 = compositeList.stream().collect(Collectors.groupingBy(MonitoringStationDTO::getTovc,LinkedHashMap::new,Collectors.toList()));
+        }else if(type == 5){
+            compositeList = monList.stream().sorted(Comparator.comparing(MonitoringStationDTO::getSO2)).collect(Collectors.toList());
+            map1 = compositeList.stream().collect(Collectors.groupingBy(MonitoringStationDTO::getSO2,LinkedHashMap::new,Collectors.toList()));
+        }else if(type == 6){
+            compositeList = monList.stream().sorted(Comparator.comparing(MonitoringStationDTO::getNO2)).collect(Collectors.toList());
+            map1 = compositeList.stream().collect(Collectors.groupingBy(MonitoringStationDTO::getNO2,LinkedHashMap::new,Collectors.toList()));
+        }else if(type == 7){
+            compositeList = monList.stream().sorted(Comparator.comparing(MonitoringStationDTO::getPM10)).collect(Collectors.toList());
+            map1 = compositeList.stream().collect(Collectors.groupingBy(MonitoringStationDTO::getPM10,LinkedHashMap::new,Collectors.toList()));
+        }else if(type == 8){
+            compositeList = monList.stream().sorted(Comparator.comparing(MonitoringStationDTO::getCO)).collect(Collectors.toList());
+            map1 = compositeList.stream().collect(Collectors.groupingBy(MonitoringStationDTO::getCO,LinkedHashMap::new,Collectors.toList()));
         }
         int index = 1;
         for (Map.Entry entry : map1.entrySet()) {
@@ -699,6 +727,18 @@
                 }else if(type == 4){
                     stationDTO.setTovc(m.getTovc());
                     stationDTO.setTOVCNum(index);
+                }else if(type == 5){
+                    stationDTO.setSO2(m.getSO2());
+                    stationDTO.setSO2Num(index);
+                }else if(type == 6){
+                    stationDTO.setNO2(m.getNO2());
+                    stationDTO.setNO2Num(index);
+                }else if(type == 7){
+                    stationDTO.setPM10(m.getPM10());
+                    stationDTO.setPM10Num(index);
+                }else if(type == 8){
+                    stationDTO.setCO(m.getCO());
+                    stationDTO.setCONum(index);
                 }
                 resultList.add(stationDTO);
             }
diff --git a/screen-manage/src/main/java/com/moral/api/kafka/consumer/DeviceConsumer.java b/screen-manage/src/main/java/com/moral/api/kafka/consumer/DeviceConsumer.java
index c21f1fb..30041ec 100644
--- a/screen-manage/src/main/java/com/moral/api/kafka/consumer/DeviceConsumer.java
+++ b/screen-manage/src/main/java/com/moral/api/kafka/consumer/DeviceConsumer.java
@@ -10,6 +10,9 @@
 import org.springframework.stereotype.Component;
 import org.springframework.util.ObjectUtils;
 
+import java.text.DecimalFormat;
+import java.text.SimpleDateFormat;
+import java.util.Date;
 import java.util.HashMap;
 import java.util.Iterator;
 import java.util.Map;
@@ -96,8 +99,19 @@
             }
 
             //������������
-//            data.remove("time");
+            data.remove("time");
             data.remove("entryTime");
+            SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+            String format = dateFormat.format(new Date().getTime());
+            //������������
+            String substring = format.substring(0, 4);
+
+            String substring1 = time.toString().substring(0, 4);
+
+            String replace = time.toString().replace(substring1, substring);
+
+            data.put("DataTime",replace);
+
             Iterator<Map.Entry<String, Object>> iterator = data.entrySet().iterator();
             Map<String, Object> newMap = new HashMap<>();
             Map.Entry<String, Object> next;
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java
index 71646df..5bc892c 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java
@@ -51,14 +51,13 @@
         Map<String, Object> versionInfo = (Map<String, Object>) deviceInfo.get("version");
         Integer version = (Integer) versionInfo.get("id");
         //���������������
-        String time1 = data.get("time").toString();
-        long l = Long.parseLong(time1);
-        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:00:00");
-        String format1 = dateFormat.format(l);
-        Date time = DateUtils.getDate(format1, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
+//        String time1 = data.get("time").toString();
+//        long l = Long.parseLong(time1);
+//        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:00:00");
+//        String format1 = dateFormat.format(l);
+//        Date time = DateUtils.getDate(format1, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
 
-
-//        Date time = DateUtils.getDate((String) data.remove("DataTime"), DateUtils.yyyyMMddHHmmss_EN);
+        Date time = DateUtils.getDate((String) data.remove("DataTime"), DateUtils.yyyyMMddHHmmss_EN);
         String yearAndMonth = DateUtils.dateToDateString(DateUtils.addHours(time, -1), DateUtils.yyyyMM_EN);
 
         result.put("mac", mac);
diff --git a/screen-manage/src/main/java/com/moral/api/util/AdjustDataUtils.java b/screen-manage/src/main/java/com/moral/api/util/AdjustDataUtils.java
index eda029a..8d59d01 100644
--- a/screen-manage/src/main/java/com/moral/api/util/AdjustDataUtils.java
+++ b/screen-manage/src/main/java/com/moral/api/util/AdjustDataUtils.java
@@ -126,35 +126,45 @@
               if (ObjectUtils.isEmpty(map)){
                   return deviceData;
               }
-              if (ObjectUtils.isEmpty(aqiMap.get("a21005"))){
-                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
-                  String a21005 = jsonObject.get("a21005").toString();
-                  deviceData.put("a21005",Double.parseDouble(a21005));
-              }
-              if (ObjectUtils.isEmpty(aqiMap.get("a21026"))){
-                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
-                  String a21026 = jsonObject.get("a21026").toString();
-                  deviceData.put("a21026",Double.parseDouble(a21026));
-              }
-              if (ObjectUtils.isEmpty(aqiMap.get("a21004"))){
-                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
-                  String a21004 = jsonObject.get("a21004").toString();
-                  deviceData.put("a21004",Double.parseDouble(a21004));
-              }
-              if (ObjectUtils.isEmpty(aqiMap.get("a34002"))){
-                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
-                  String a34002 = jsonObject.get("a34002").toString();
-                  deviceData.put("a34002",Double.parseDouble(a34002));
-              }
-              if (ObjectUtils.isEmpty(aqiMap.get("a34004"))){
-                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
-                  String a34004 = jsonObject.get("a34004").toString();
-                  deviceData.put("a34004",Double.parseDouble(a34004));
-              }
-              if (ObjectUtils.isEmpty(aqiMap.get("a05024"))){
-                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
-                  String a05024 = jsonObject.get("a05024").toString();
-                  deviceData.put("a05024",Double.parseDouble(a05024));
+              JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
+              if (ObjectUtils.isEmpty(aqiMap)){
+                  deviceData.put("a21005",Double.parseDouble(jsonObject.get("a21005").toString()));
+                  deviceData.put("a21026",Double.parseDouble(jsonObject.get("a21026").toString()));
+                  deviceData.put("a21004",Double.parseDouble(jsonObject.get("a21004").toString()));
+                  deviceData.put("a34002",Double.parseDouble(jsonObject.get("a34002").toString()));
+                  deviceData.put("a34004",Double.parseDouble(jsonObject.get("a34004").toString()));
+                  deviceData.put("a05024",Double.parseDouble(jsonObject.get("a05024").toString()));
+              }else {
+                  if (ObjectUtils.isEmpty(aqiMap.get("a21005"))){
+
+                      String a21005 = jsonObject.get("a21005").toString();
+                      deviceData.put("a21005",Double.parseDouble(a21005));
+                  }
+                  if (ObjectUtils.isEmpty(aqiMap.get("a21026"))){
+//                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
+                      String a21026 = jsonObject.get("a21026").toString();
+                      deviceData.put("a21026",Double.parseDouble(a21026));
+                  }
+                  if (ObjectUtils.isEmpty(aqiMap.get("a21004"))){
+//                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
+                      String a21004 = jsonObject.get("a21004").toString();
+                      deviceData.put("a21004",Double.parseDouble(a21004));
+                  }
+                  if (ObjectUtils.isEmpty(aqiMap.get("a34002"))){
+//                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
+                      String a34002 = jsonObject.get("a34002").toString();
+                      deviceData.put("a34002",Double.parseDouble(a34002));
+                  }
+                  if (ObjectUtils.isEmpty(aqiMap.get("a34004"))){
+//                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
+                      String a34004 = jsonObject.get("a34004").toString();
+                      deviceData.put("a34004",Double.parseDouble(a34004));
+                  }
+                  if (ObjectUtils.isEmpty(aqiMap.get("a05024"))){
+//                  JSONObject jsonObject = JSONObject.parseObject(map.get("value").toString());
+                      String a05024 = jsonObject.get("a05024").toString();
+                      deviceData.put("a05024",Double.parseDouble(a05024));
+                  }
               }
           }
 

--
Gitblit v1.8.0