修改sql语句问题2

jinpengyong

2022-12-14 0c4fa637138a38e1d6fa825122ee369dbc5920e4

 screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java

@@ -2,8 +2,10 @@

import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.moral.api.entity.CityAqi;
import com.moral.api.entity.GovMonitorPoint;
import com.moral.api.entity.HistoryAqi;
import com.moral.api.mapper.CityAqiMapper;
import com.moral.api.mapper.HistoryAqiMapper;
import com.moral.api.service.GovMonitorPointService;
import com.moral.api.service.HistoryAqiService;
@@ -45,6 +47,8 @@

    @Autowired
    private HistoryAqiMapper historyAqiMapper;
    @Autowired
    private CityAqiMapper cityAqiMapper;

    @Autowired
    private RestTemplate restTemplate;
@@ -71,7 +75,8 @@
        //获取所有国控，省控，县控站点
        List<GovMonitorPoint> govMonitorPoints = govMonitorPointService.list(queryWrapper);
        Date time = DateUtils.dataToTimeStampTime(new Date(), DateUtils.yyyy_MM_dd_HH_EN);
        String timeStr = DateUtils.dateToDateString(time, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
//        String timeStr = DateUtils.dateToDateString(time, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
        String timeStr = DateUtils.dateToDateString(DateUtils.addHours(time, -1), DateUtils.yyyy_MM_dd_HH_mm_ss_EN);

//        List<HistoryAqi> historyAqis = new ArrayList<>();

@@ -131,10 +136,17 @@
                    value.put(Constants.SENSOR_CODE_O3, o3);
                }


                //aqi数据存入redis
                redisTemplate.opsForHash().put(RedisConstants.AQI_DATA, guid, value);

                historyAqiMapper.insert(historyAqi);
                CityAqi cityAqi = new CityAqi();
                cityAqi.setCityCode(11111);
                cityAqi.setTime(DateUtils.addHours(time, -1));
                cityAqi.setValue(JSONObject.toJSONString(map));
                cityAqiMapper.insert(cityAqi);

            }else {
                ResponseEntity<String> response;
                try {
@@ -190,6 +202,12 @@
                //aqi数据存入redis
                redisTemplate.opsForHash().put(RedisConstants.AQI_DATA, guid, value);
                historyAqiMapper.insert(historyAqi);

                CityAqi cityAqi = new CityAqi();
                cityAqi.setCityCode(11111);
                cityAqi.setTime(DateUtils.addHours(time, -1));
                cityAqi.setValue(JSONObject.toJSONString(map));
                cityAqiMapper.insert(cityAqi);
            }

        }