fix:升级语句优化

cjl

2023-09-12 ea1373d4e1511b620bb87872e692643e2edb81f8

 screen-api/src/main/java/com/moral/api/service/CityAqiDailyService.java

@@ -2,12 +2,14 @@

import com.moral.api.entity.CityAqiDaily;
import com.baomidou.mybatisplus.extension.service.IService;
import com.moral.api.entity.SysArea;
import com.moral.api.pojo.dto.cityAQI.CityPollutionLevel;
import com.moral.api.pojo.dto.cityAQI.MonthlyPollutionLevel;
import com.moral.api.pojo.form.aqi.AreaPollutionLevelForm;
import com.moral.api.pojo.form.aqi.*;
import com.moral.api.pojo.vo.cityAQI.CityAreaRangeVO;
import com.moral.api.pojo.vo.cityAQI.PieChartOfPollutionLevelVO;
import com.moral.api.pojo.form.aqi.ChartOfPollutionLevelForm;

import java.util.Date;
import java.util.List;
import java.util.Map;

@@ -22,38 +24,94 @@
public interface CityAqiDailyService extends IService<CityAqiDaily> {

    /**
    * @Description: 查询污染等级的饼状图，包括天数，占比
            * @Param: [regionCode]
            * @return: com.moral.api.pojo.dto.dataDisplay.PollutionLevelProportionDTO
            * @Author: 陈凯裕
            * @Date: 2021/11/9
            */
     * @Description: 根据地区码和时间获取数据
     * @Param: [regionCode, startDate, endDate]
     * @return: java.util.List<com.moral.api.entity.CityAqiDaily>
     * @Author: 陈凯裕
     * @Date: 2022/1/17
     */
    List<CityAqiDaily> getCityAqiDailyByRegionCodeAndTime(Integer regionCode, Date startDate, Date endDate);

    /**
     * @Description: 查询污染等级的饼状图，包括天数，占比
     * @Param: [regionCode]
     * @return: com.moral.api.pojo.dto.dataDisplay.PollutionLevelProportionDTO
     * @Author: 陈凯裕
     * @Date: 2021/11/9
     */
    PieChartOfPollutionLevelVO queryPieChartOfPollutionLevels(ChartOfPollutionLevelForm form);

    /**
    * @Description: 查询污染等级的柱状图数据，包括天数和占比
            * @Param: [form]
            * @return: java.util.List<com.moral.api.pojo.dto.cityAQI.MonthlyPollutionLevel>
            * @Author: 陈凯裕
            * @Date: 2021/11/22
            */
     * @Description: 查询污染等级的柱状图数据，包括天数和占比
     * @Param: [form]
     * @return: java.util.List<com.moral.api.pojo.dto.cityAQI.MonthlyPollutionLevel>
     * @Author: 陈凯裕
     * @Date: 2021/11/22
     */
    List<MonthlyPollutionLevel> queryBarChartOfPollutionLevels(ChartOfPollutionLevelForm form);

    /**
     *@Description: 查询一年的数据，并分月份保存
     *@Param: [map]
     *@return: java.util.Map<java.lang.String,java.lang.Object>
     *@Author: lizijie
     *@Date: 2021/11/23 14:42
     * @Description: 查询一年的数据，并分月份保存
     * @Param: [map]
     * @return: java.util.Map<java.lang.String   ,   java.lang.Object>
     * @Author: lizijie
     * @Date: 2021/11/23 14:42
     **/
    Map<String,Map<String,Object>> oneYearsData(Map map);
    Map<String, Map<String, Object>> oneYearsData(Map map);

    /**
    * @Description: 查询一个城市所有县的优良天气占比
            * @Param: [AreaPollutionLevelForm]
            * @return: java.util.List<com.moral.api.pojo.dto.cityAQI.CityPollutionLevel>
            * @Author: 陈凯裕
            * @Date: 2021/12/30
            */
     * @Description: 查询一个城市所有县的优良天气数
     * @Param: [AreaPollutionLevelForm]
     * @return: java.util.List<com.moral.api.pojo.dto.cityAQI.CityPollutionLevel>
     * @Author: 陈凯裕
     * @Date: 2021/12/30
     */
    List<CityPollutionLevel> queryAreaPollutionLevel(AreaPollutionLevelForm form);

    /**
     * @Description: 查询28市优良天气数
     * @Param: [form]
     * @return: java.util.List<com.moral.api.pojo.dto.cityAQI.CityPollutionLevel>
     * @Author: 陈凯裕
     * @Date: 2021/12/31
     */
    List<CityPollutionLevel> querySpecialCitiesPollutionLevel(SpecialCitiesPollutionLevelForm form);

    /**
     * @Description: 查询一个省内所有市的优良天数
     * @Param: [from]
     * @return: java.util.List<com.moral.api.pojo.dto.cityAQI.CityPollutionLevel>
     * @Author: 陈凯裕
     * @Date: 2022/1/7
     */
    List<CityPollutionLevel> queryProvinceCitiesPollutionLevel(ProvinceCitiesPollutionLevelForm form);

    /**
    * @Description: 根据地区和开始结束时间计算优良天气数
            * @Param: [area, startDate, endDate]
            * @return: com.moral.api.pojo.dto.cityAQI.CityPollutionLevel
            * @Author: 陈凯裕
            * @Date: 2022/1/17
            */
    CityPollutionLevel calculateDaysByTimeAndSysArea(SysArea area, Date startDate, Date endDate);

    /**
    * @Description: 查询空气质量简报
            * @Param: [regionCode, time]
            * @return: java.lang.String
            * @Author: 陈凯裕
            * @Date: 2022/3/11
            */
    List<String> airQualityBulletin(String regionCode,Date time);

    /**
     * @Description: 查询对应城市下所有县的综合指数排名(附件7数据)
     * @Param: [regionCode, time]
     * @return: java.util.List<com.moral.api.pojo.vo.cityAQI.CityAreaRangeVO>
     * @Author: 陈凯裕
     * @Date: 2022/3/17
     */
    List<CityAreaRangeVO> cityAreaRange(Integer regionCode, Date time);


}