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