From 9cac94cd48fde9c9cb1b8f37cd652d974ca8d349 Mon Sep 17 00:00:00 2001 From: cjl <909710561@qq.com> Date: Thu, 25 Jan 2024 10:33:47 +0800 Subject: [PATCH] fix:补充提交 --- screen-job/src/main/java/com/moral/api/service/impl/CityWeatherServiceImpl.java | 38 ++++++++++++++++++++++++++------------ 1 files changed, 26 insertions(+), 12 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 313df32..2637f8f 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; @@ -44,18 +45,22 @@ @Autowired private RedisTemplate redisTemplate; + //������������������������������������������������������������������ @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) { - String 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 +70,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, cityCode, now); + redisTemplate.opsForHash().put(RedisConstants.CITY_WEATHER, String.valueOf(cityCode), now); } + cityWeatherMapper.insertCityWeather(cityWeathers); + } @Override @@ -83,4 +89,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