From db56a260709d59c872b15d8eb6734fcb99f6cf2b Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Thu, 28 Oct 2021 10:46:02 +0800 Subject: [PATCH] 城市aqi日数据统计定时任务 --- screen-job/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java | 34 +++++----------------------------- 1 files changed, 5 insertions(+), 29 deletions(-) diff --git a/screen-job/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java b/screen-job/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java index e1f7902..1250a50 100644 --- a/screen-job/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java +++ b/screen-job/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java @@ -22,7 +22,6 @@ import java.util.Date; import java.util.List; import java.util.Map; -import java.util.stream.Collectors; /** * <p> @@ -47,6 +46,9 @@ @Autowired private RedisTemplate redisTemplate; + @Autowired + + @Override public void insertCityAqi() { //������������������ @@ -55,7 +57,7 @@ List<CityConfig> list = cityConfigService.list(wrapper); Date time = DateUtils.dataToTimeStampTime(new Date(), DateUtils.yyyy_MM_dd_HH_EN); for (CityConfig cityConfig : list) { - String cityCode = cityConfig.getCityCode(); + Integer cityCode = cityConfig.getCityCode(); Map<String, Object> data; try { //������������������������������ @@ -83,33 +85,7 @@ cityAqi.setValue(JSONObject.toJSONString(aqi)); cityAqiMapper.insert(cityAqi); //������redis - redisTemplate.opsForHash().put(RedisConstants.CITY_AQI, cityCode, aqi); + redisTemplate.opsForHash().put(RedisConstants.CITY_AQI, cityCode.toString(), aqi); } - } - - @Override - public void insertCityAqiDaily() { - String format = DateUtils.yyyy_MM_dd_EN; - Date now = new Date(); - //��������������������� - Date start = DateUtils.dataToTimeStampTime(DateUtils.getDateOfDay(now, -1), format); - //��������������������� - Date end = DateUtils.dataToTimeStampTime(now, format); - //������������������aqi������������ - QueryWrapper<CityAqi> wrapper = new QueryWrapper<>(); - wrapper.select("city_code", "value") - .ge("time", DateUtils.dateToDateString(start)) - .lt("time", DateUtils.dateToDateString(end)); - List<Map<String, Object>> dailyData = cityAqiMapper.selectMaps(wrapper); - - if (dailyData.size() == 0) { - return; - } - //���city_code������ - Map<String, List<Map<String, Object>>> data = dailyData.parallelStream().collect(Collectors.groupingBy(o -> (String) o.get("city_code"))); - data.forEach((cityCode, value) -> { - - }); - } } -- Gitblit v1.8.0