省内倒数排名增加time字段

jinpengyong

2021-11-02 8f5416a1e507fe24c151648982e391fead13ffdd

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

@@ -187,8 +187,8 @@
        Date endDate = new Date();
        //查询当天数据
        QueryWrapper<CityAqi> wrapper = new QueryWrapper<>();
        wrapper.between("time",startDate,endDate);
        wrapper.eq("city_code",regionCode);
        wrapper.between("time", startDate, endDate);
        wrapper.eq("city_code", regionCode);
        wrapper.select("DISTINCT city_code,time,value");
        List<CityAqi> cityAqis = cityAqiMapper.selectList(wrapper);
        //计算平均数
@@ -197,69 +197,69 @@
        Map<String, Object> result = AQIUtils.hourlyAqi_pollutant(sixParamAvg);
        //结果集添加时间
        CityAqi lastCityAqi = cityAqis.get(cityAqis.size() - 1);
        String time = DateUtils.dateToDateString(lastCityAqi.getTime(),"HH:mm");
        result.put("time",time);
        String time = DateUtils.dateToDateString(lastCityAqi.getTime(), "HH:mm");
        result.put("time", time);
        return result;
    }

    /**
    * @Description: 计算6参平均值
            * @Param: [cityAqiList]
            * @return: java.util.Map<java.lang.String,java.lang.Double>
            * 返回值key为sensorCode,value为值
            * @Author: 陈凯裕
            * @Date: 2021/11/2
            */
    private Map<String,Object> calculate6ParamAvg(List<CityAqi> cityAqiList){
        Double co = calculateSensorAvg(cityAqiList,"co");
        Double pm2_5 = calculateSensorAvg(cityAqiList,"pm2_5");
        Double pm10 = calculateSensorAvg(cityAqiList,"pm10");
        Double so2 = calculateSensorAvg(cityAqiList,"so2");
        Double no2 = calculateSensorAvg(cityAqiList,"no2");
        Double o3 = calculateSensorAvg(cityAqiList,"o3");
        Map<String,Object> result = new HashMap<>();
        result.put(Constants.SENSOR_CODE_CO,co);
        result.put(Constants.SENSOR_CODE_NO2,no2);
        result.put(Constants.SENSOR_CODE_SO2,so2);
        result.put(Constants.SENSOR_CODE_O3,o3);
        result.put(Constants.SENSOR_CODE_PM25,pm2_5);
        result.put(Constants.SENSOR_CODE_PM10,pm10);
     * @Description: 计算6参平均值
     * @Param: [cityAqiList]
     * @return: java.util.Map<java.lang.String, java.lang.Double>
     * 返回值key为sensorCode,value为值
     * @Author: 陈凯裕
     * @Date: 2021/11/2
     */
    private Map<String, Object> calculate6ParamAvg(List<CityAqi> cityAqiList) {
        Double co = calculateSensorAvg(cityAqiList, "co");
        Double pm2_5 = calculateSensorAvg(cityAqiList, "pm2_5");
        Double pm10 = calculateSensorAvg(cityAqiList, "pm10");
        Double so2 = calculateSensorAvg(cityAqiList, "so2");
        Double no2 = calculateSensorAvg(cityAqiList, "no2");
        Double o3 = calculateSensorAvg(cityAqiList, "o3");
        Map<String, Object> result = new HashMap<>();
        result.put(Constants.SENSOR_CODE_CO, co);
        result.put(Constants.SENSOR_CODE_NO2, no2);
        result.put(Constants.SENSOR_CODE_SO2, so2);
        result.put(Constants.SENSOR_CODE_O3, o3);
        result.put(Constants.SENSOR_CODE_PM25, pm2_5);
        result.put(Constants.SENSOR_CODE_PM10, pm10);
        return result;
    }

    /**
    * @Description: 计算因子的平均值
            * @Param: [cityAqiList, sensor]
            * ，sensor是要计算的因子名称
            * @return: java.lang.Double
            * @Author: 陈凯裕
            * @Date: 2021/11/2
            */
    private Double calculateSensorAvg(List<CityAqi> cityAqiList,String sensor){
     * @Description: 计算因子的平均值
     * @Param: [cityAqiList, sensor]
     * ，sensor是要计算的因子名称
     * @return: java.lang.Double
     * @Author: 陈凯裕
     * @Date: 2021/11/2
     */
    private Double calculateSensorAvg(List<CityAqi> cityAqiList, String sensor) {
        Double sum = 0d;
        int num = 0;
        for (CityAqi cityAqi : cityAqiList) {
            String value = cityAqi.getValue();
            if(value==null)
            if (value == null)
                continue;
            Map<String,Object> valueMap = JSON.parseObject(value,Map.class);
            Map<String, Object> valueMap = JSON.parseObject(value, Map.class);
            Object sensorValueObject = valueMap.get(sensor);
            if(sensorValueObject==null)
            if (sensorValueObject == null)
                continue;
            Double sensorValue = Double.valueOf(sensorValueObject.toString());
            sum = MathUtils.add(sum,sensorValue);
            sum = MathUtils.add(sum, sensorValue);
            num++;
        }
        if(num==0)
        if (num == 0)
            return null;
        Double avg = MathUtils.division(sum,num,2);
        Double avg = MathUtils.division(sum, num, 2);
        return avg;
    }

    /**
     * @Description: 从数据库查询数据
     * @Param: [regionCode]
     * @return: java.util.Map<java.lang.String ,java.lang.Object>
     * @return: java.util.Map<java.lang.String, java.lang.Object>
     * @Author: 陈凯裕
     * @Date: 2021/10/28
     */
@@ -372,6 +372,8 @@
        yearMap.put("compositeIndex", yearMap.remove("value"));
        result.put("year", yearMap);

        //时间，昨日
        result.put("time", DateUtils.dateToDateString(yesterday, DateUtils.yyyy_MM_dd_EN));
        return result;
    }