From 6cc2a1d726e1019079b6d3fa74599426a359c001 Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Tue, 02 Nov 2021 14:55:24 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev' into dev_

---
 screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java |   80 +++++++++++++++++++++++++++++++++++++++
 1 files changed, 79 insertions(+), 1 deletions(-)

diff --git a/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java
index 9a8bd56..ca1f74d 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java
@@ -15,11 +15,13 @@
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.moral.api.service.OrganizationService;
 import com.moral.api.service.SysAreaService;
+import com.moral.constant.Constants;
 import com.moral.constant.RedisConstants;
 import com.moral.util.AQIUtils;
 import com.moral.util.AmendUtils;
 import com.moral.util.DateUtils;
 
+import com.moral.util.MathUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.data.redis.core.RedisTemplate;
 import org.springframework.stereotype.Service;
@@ -178,10 +180,86 @@
         return result;
     }
 
+    @Override
+    public Map<String, Object> queryTodayAqiAndPollutant(Integer regionCode) {
+        //���������������9���������
+        Date startDate = new Date(DateUtils.getTodayTime());
+        Date endDate = new Date();
+        //������������������
+        QueryWrapper<CityAqi> wrapper = new QueryWrapper<>();
+        wrapper.between("time",startDate,endDate);
+        wrapper.eq("city_code",regionCode);
+        wrapper.select("DISTINCT city_code,time,value");
+        List<CityAqi> cityAqis = cityAqiMapper.selectList(wrapper);
+        //���������������
+        Map<String, Object> sixParamAvg = calculate6ParamAvg(cityAqis);
+        //������������aqi������������������
+        Map<String, Object> result = AQIUtils.hourlyAqi_pollutant(sixParamAvg);
+        //���������������������
+        CityAqi lastCityAqi = cityAqis.get(cityAqis.size() - 1);
+        String time = DateUtils.dateToDateString(lastCityAqi.getTime(),"HH:mm");
+        result.put("time",time);
+        return result;
+    }
+
+    /**
+    * @Description: ������6������������
+            * @Param: [cityAqiList]
+            * @return: java.util.Map<java.lang.String,java.lang.Double>
+            * ���������key���sensorCode,value������
+            * @Author: ���������
+            * @Date: 2021/11/2
+            */
+    private Map<String,Object> calculate6ParamAvg(List<CityAqi> cityAqiList){
+        Double co = calculateSensorAvg(cityAqiList,"co");
+        Double pm2_5 = calculateSensorAvg(cityAqiList,"pm2_5");
+        Double pm10 = calculateSensorAvg(cityAqiList,"pm10");
+        Double so2 = calculateSensorAvg(cityAqiList,"so2");
+        Double no2 = calculateSensorAvg(cityAqiList,"no2");
+        Double o3 = calculateSensorAvg(cityAqiList,"o3");
+        Map<String,Object> result = new HashMap<>();
+        result.put(Constants.SENSOR_CODE_CO,co);
+        result.put(Constants.SENSOR_CODE_NO2,no2);
+        result.put(Constants.SENSOR_CODE_SO2,so2);
+        result.put(Constants.SENSOR_CODE_O3,o3);
+        result.put(Constants.SENSOR_CODE_PM25,pm2_5);
+        result.put(Constants.SENSOR_CODE_PM10,pm10);
+        return result;
+    }
+
+    /**
+    * @Description: ������������������������
+            * @Param: [cityAqiList, sensor]
+            * ���sensor���������������������������
+            * @return: java.lang.Double
+            * @Author: ���������
+            * @Date: 2021/11/2
+            */
+    private Double calculateSensorAvg(List<CityAqi> cityAqiList,String sensor){
+        Double sum = 0d;
+        int num = 0;
+        for (CityAqi cityAqi : cityAqiList) {
+            String value = cityAqi.getValue();
+            if(value==null)
+                continue;
+            Map<String,Object> valueMap = JSON.parseObject(value,Map.class);
+            Object sensorValueObject = valueMap.get(sensor);
+            if(sensorValueObject==null)
+                continue;
+            Double sensorValue = Double.valueOf(sensorValueObject.toString());
+            sum = MathUtils.add(sum,sensorValue);
+            num++;
+        }
+        if(num==0)
+            return null;
+        Double avg = MathUtils.division(sum,num,2);
+        return avg;
+    }
+
     /**
      * @Description: ������������������������
      * @Param: [regionCode]
-     * @return: java.util.Map<java.lang.String       ,       java.lang.Object>
+     * @return: java.util.Map<java.lang.String ,java.lang.Object>
      * @Author: ���������
      * @Date: 2021/10/28
      */

--
Gitblit v1.8.0