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.entity.CityWeather; 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.util.DateUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.web.client.RestTemplate; import java.util.Date; 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; @Override public void insertCityAqi() { //获取城市配置 QueryWrapper wrapper = new QueryWrapper<>(); wrapper.select("city_code", "location_id").eq("is_delete", Constants.NOT_DELETE); List list = cityConfigService.list(wrapper); for (CityConfig cityConfig : list) { String cityCode = cityConfig.getCityCode(); Integer locationId = cityConfig.getLocationId(); Map data = restTemplate.getForObject("https://api.qweather.com/v7/air/now?key=da05c6c4852d4f7aa3364a9236ee9e26&gzip=n&location={1}", Map.class, locationId); Map now = (Map) data.get("now"); CityAqi cityAqi = new CityAqi(); cityAqi.setCityCode(cityCode); now.put("pm2_5", now.remove("pm2p5")); cityAqi.setValue(JSONObject.toJSONString(now)); Date time = DateUtils.dataToTimeStampTime(new Date(), DateUtils.yyyy_MM_dd_HH_EN); cityAqi.setTime(time); cityAqiMapper.insert(cityAqi); } } }