package com.moral.api.service.impl; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.moral.api.entity.CityAqi; import com.moral.api.entity.CityConfig; import com.moral.api.mapper.CityAqiMapper; import com.moral.api.service.CityAqiService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.moral.api.service.CityConfigService; import com.moral.constant.Constants; import com.moral.constant.RedisConstants; import com.moral.pojo.AQI; import com.moral.util.AQIUtils; import com.moral.util.AmendUtils; import com.moral.util.ComprehensiveIndexUtils; import com.moral.util.DateUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; import org.springframework.util.ObjectUtils; import org.springframework.web.client.RestTemplate; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.OptionalDouble; import java.util.stream.DoubleStream; /** *

* 城市aqi实测小时数据表 服务实现类 *

* * @author moral * @since 2021-10-11 */ @Service public class CityAqiServiceImpl extends ServiceImpl implements CityAqiService { @Autowired private CityAqiMapper cityAqiMapper; @Autowired private CityConfigService cityConfigService; @Autowired private RestTemplate restTemplate; @Autowired private RedisTemplate redisTemplate; @Override public void insertCityAqi() { Date now = new Date(); Date time = DateUtils.dataToTimeStampTime(now, DateUtils.yyyy_MM_dd_HH_EN); Date start = null; if (DateUtils.getHour(time) == 0 || DateUtils.getHour(time) >= 8) { start = DateUtils.addHours(time, -7); } //获取城市配置 QueryWrapper wrapper = new QueryWrapper<>(); wrapper.select("city_code", "city_id").eq("is_delete", Constants.NOT_DELETE); List list = cityConfigService.list(wrapper); for (CityConfig cityConfig : list) { Integer cityCode = cityConfig.getCityCode(); Map data; try { //从第三方接口获取数据 data = restTemplate.getForObject("http://sapi.7drlb.com/api/mj?cityID={1}&apiKey=aqi", Map.class, cityConfig.getCityId()); } catch (Exception e) { continue; } if (ObjectUtils.isEmpty(data)) { continue; } Map map = (Map) data.get("data"); Map aqi = (Map) map.get("aqi"); aqi.remove("pm25"); aqi.remove("pm10"); aqi.remove("so2"); aqi.remove("no2"); aqi.remove("co"); aqi.remove("o3"); aqi.put("PM2_5", aqi.remove("pm25C")); aqi.put("PM10", aqi.remove("pm10C")); aqi.put("SO2", aqi.remove("so2C")); aqi.put("NO2", aqi.remove("no2C")); aqi.put("CO", aqi.remove("coC")); aqi.put("O3", aqi.remove("o3C")); aqi.put("AQI", aqi.remove("value")); //o3滑动值计算 if (start != null) { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.select("time", "value") .eq("city_code", cityCode) .ge("time", DateUtils.dateToDateString(start)); List> cityAqis = cityAqiMapper.selectMaps(queryWrapper); Map params = new HashMap<>(); params.put("time", DateUtils.dateToDateString(time, DateUtils.yyyy_MM_dd_HH_mm_ss_S_EN)); params.put("value", JSONObject.toJSONString(aqi)); cityAqis.add(params); if (cityAqis.size() >= 6) { OptionalDouble average = cityAqis.parallelStream().flatMapToDouble(v -> { Map dataValue = JSONObject.parseObject((String) v.get("value"), Map.class); double o3 = Double.parseDouble(dataValue.get("O3").toString()); return DoubleStream.of(o3); }).average(); if (average.isPresent()) { double O3_8H = AmendUtils.sciCal(average.getAsDouble(), 0); aqi.put("O3_8H", O3_8H); } } } //综合指数计算 Map temp = new HashMap<>(aqi); temp.put("O3", temp.get("O3_8H")); Double compositeIndex = ComprehensiveIndexUtils.dailyData(temp); aqi.put("compositeIndex", compositeIndex); //首要污染物计算 Map sixParamMap = new HashMap<>(); sixParamMap.put(Constants.SENSOR_CODE_PM25, aqi.get("PM2_5")); sixParamMap.put(Constants.SENSOR_CODE_PM10, aqi.get("PM10")); sixParamMap.put(Constants.SENSOR_CODE_SO2, aqi.get("SO2")); sixParamMap.put(Constants.SENSOR_CODE_NO2, aqi.get("NO2")); sixParamMap.put(Constants.SENSOR_CODE_CO, aqi.get("CO")); sixParamMap.put(Constants.SENSOR_CODE_O3, aqi.get("O3")); AQI aqiAndPollutant = AQIUtils.hourlyAQI(sixParamMap); if (!ObjectUtils.isEmpty(aqiAndPollutant.getPrimaryPollutantNames())) { aqi.put("primaryPollutant", aqiAndPollutant.getPrimaryPollutantNames()); } CityAqi cityAqi = new CityAqi(); cityAqi.setCityCode(cityCode); cityAqi.setTime(time); cityAqi.setValue(JSONObject.toJSONString(aqi)); cityAqiMapper.insert(cityAqi); //存入redis redisTemplate.opsForHash().put(RedisConstants.CITY_AQI, cityCode.toString(), aqi); } } }