| | |
| | | |
| | | @Override |
| | | public void insertCityAqi() { |
| | | //pubtime=08的数据,是07-08之间的数据,存入数据库时的时间为07点 |
| | | Date now = new Date(); |
| | | Date time = DateUtils.dataToTimeStampTime(now, DateUtils.yyyy_MM_dd_HH_EN); |
| | | |
| | | //存入数据库是time字段实际时间 |
| | | Date dataTime = DateUtils.addHours(time, -1); |
| | | Date start = null; |
| | | if (DateUtils.getHour(time) >= 7) { |
| | | start = DateUtils.addHours(time, -7); |
| | | if (DateUtils.getHour(time) >= 8) { |
| | | start = DateUtils.addHours(time, -8); |
| | | } |
| | | |
| | | //获取城市配置 |
| | |
| | | .ge("time", DateUtils.dateToDateString(start)); |
| | | List<Map<String, Object>> cityAqis = cityAqiMapper.selectMaps(queryWrapper); |
| | | Map<String, Object> params = new HashMap<>(); |
| | | params.put("time", DateUtils.dateToDateString(time, DateUtils.yyyy_MM_dd_HH_mm_ss_S_EN)); |
| | | params.put("time", DateUtils.dateToDateString(dataTime, DateUtils.yyyy_MM_dd_HH_mm_ss_S_EN)); |
| | | params.put("value", JSONObject.toJSONString(aqi)); |
| | | cityAqis.add(params); |
| | | if (cityAqis.size() >= 6) { |
| | |
| | | |
| | | CityAqi cityAqi = new CityAqi(); |
| | | cityAqi.setCityCode(cityCode); |
| | | cityAqi.setTime(time); |
| | | cityAqi.setTime(dataTime); |
| | | cityAqi.setValue(JSONObject.toJSONString(aqi)); |
| | | cityAqiMapper.insert(cityAqi); |
| | | //存入redis |