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.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; /** *

* 城市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; @Autowired @Override public void insertCityAqi() { //获取城市配置 QueryWrapper wrapper = new QueryWrapper<>(); wrapper.select("city_code", "city_id").eq("is_delete", Constants.NOT_DELETE); List list = cityConfigService.list(wrapper); Date time = DateUtils.dataToTimeStampTime(new Date(), DateUtils.yyyy_MM_dd_HH_EN); 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.put("pm2_5", aqi.remove("pm25C")); aqi.remove("pm25"); 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滑动值计算 //获取一天内每个小时o3数据 QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.select("time", "value").eq("city_code", cityCode); List> cityAqis = cityAqiMapper.selectMaps(queryWrapper); List> o3_8H = AmendUtils.getO3_8H(cityAqis); if (!ObjectUtils.isEmpty(o3_8H)) { for (Map o3Map : o3_8H) { String hourTime = o3Map.get("time").toString(); if (DateUtils.dateToDateString(time, DateUtils.yyyy_MM_dd_HH_mm_ss_EN).equals(hourTime)) { o3Map.get("o3"); aqi.put("o3_8h", o3Map.get("o3")); break; } } } //综合指数计算 Map temp = new HashMap<>(aqi); temp.put("o3", temp.get("o3_8h")); Double compositeIndex = ComprehensiveIndexUtils.dailyData(temp); aqi.put("compositeIndex", compositeIndex); //首要污染物计算 Map pollutant = AQIUtils.cityAqiPollutant(aqi); if (!ObjectUtils.isEmpty(pollutant)) { aqi.putAll(pollutant); } 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); } } }