From a827480e5e74cb6550c5f7b842bccac3023c5bdc Mon Sep 17 00:00:00 2001 From: kaiyu <404897439@qq.com> Date: Thu, 24 Mar 2022 08:48:37 +0800 Subject: [PATCH] screen-api --- screen-job/src/main/java/com/moral/api/service/impl/CityWeatherServiceImpl.java | 35 ++++++++++++++++++++++++----------- 1 files changed, 24 insertions(+), 11 deletions(-) diff --git a/screen-job/src/main/java/com/moral/api/service/impl/CityWeatherServiceImpl.java b/screen-job/src/main/java/com/moral/api/service/impl/CityWeatherServiceImpl.java index a9e9121..1872469 100644 --- a/screen-job/src/main/java/com/moral/api/service/impl/CityWeatherServiceImpl.java +++ b/screen-job/src/main/java/com/moral/api/service/impl/CityWeatherServiceImpl.java @@ -2,10 +2,10 @@ import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; -import com.moral.api.entity.CityConfig; +import com.moral.api.entity.CityConfigWeather; import com.moral.api.entity.CityWeather; import com.moral.api.mapper.CityWeatherMapper; -import com.moral.api.service.CityConfigService; +import com.moral.api.service.CityConfigWeatherService; import com.moral.api.service.CityWeatherService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.moral.constant.Constants; @@ -17,6 +17,7 @@ import org.springframework.stereotype.Service; import org.springframework.web.client.RestTemplate; +import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.Map; @@ -36,7 +37,7 @@ private CityWeatherMapper cityWeatherMapper; @Autowired - private CityConfigService cityConfigService; + private CityConfigWeatherService cityConfigWeatherService; @Autowired private RestTemplate restTemplate; @@ -47,15 +48,18 @@ @Override public void insertCityWeather() { //������������������ - QueryWrapper<CityConfig> wrapper = new QueryWrapper<>(); + QueryWrapper<CityConfigWeather> wrapper = new QueryWrapper<>(); wrapper.select("city_code", "location_id").eq("is_delete", Constants.NOT_DELETE); - List<CityConfig> list = cityConfigService.list(wrapper); - for (CityConfig cityConfig : list) { - Integer cityCode = cityConfig.getCityCode(); - Integer locationId = cityConfig.getLocationId(); + List<CityConfigWeather> list = cityConfigWeatherService.list(wrapper); + + List<CityWeather> cityWeathers = new ArrayList<>(); + + for (CityConfigWeather cityConfigWeather : list) { + CityWeather cityWeather = new CityWeather(); + Integer cityCode = cityConfigWeather.getCityCode(); + Integer locationId = cityConfigWeather.getLocationId(); Map<String, Object> data = restTemplate.getForObject("https://api.qweather.com/v7/weather/now?key=da05c6c4852d4f7aa3364a9236ee9e26&gzip=n&location={1}", Map.class, locationId); Map<String, Object> now = (Map<String, Object>) data.get("now"); - CityWeather cityWeather = new CityWeather(); cityWeather.setCityCode(cityCode); //������km/h->m/s double windSpeed = Double.parseDouble(now.get("windSpeed").toString()); @@ -65,11 +69,12 @@ cityWeather.setValue(JSONObject.toJSONString(now)); Date time = DateUtils.dataToTimeStampTime(new Date(), DateUtils.yyyy_MM_dd_HH_EN); cityWeather.setTime(time); - //��������������� - cityWeatherMapper.insert(cityWeather); + cityWeathers.add(cityWeather); //������redis redisTemplate.opsForHash().put(RedisConstants.CITY_WEATHER, String.valueOf(cityCode), now); } + cityWeatherMapper.insertCityWeather(cityWeathers); + } @Override @@ -83,4 +88,12 @@ } return cityWeather; } + + @Override + public List<CityWeather> getCityWeather() { + String time = DateUtils.getDateStringOfHour(-1, DateUtils.yyyy_MM_dd_HH_EN) + ":00:00"; + QueryWrapper<CityWeather> queryWrapper = new QueryWrapper<>(); + queryWrapper.eq("time", time); + return cityWeatherMapper.selectList(queryWrapper); + } } -- Gitblit v1.8.0