普查统计水库饼图统计数据接口支持季节查询

xieb

2024-09-26 b92680e97535c76099d936e7a17d6e5c4a3e2710

普查统计水库饼图统计数据接口支持季节查询

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResGeneralInvestigationMapper.xml

@@ -102,6 +102,9 @@
                    <if test="params.tbYear != null and params.tbYear !=''">
                        AND trgis."tb_year" = #{params.tbYear}
                    </if>
                    <if test="params.tbQuarter != null and params.tbQuarter !=''">
                        AND trgis."tb_quarter" = #{params.tbQuarter}
                    </if>
                WHERE 1=1
                <if test="params.adCode != null and params.adCode !=''">
                    AND CONCAT(arb.provinceCode,arb.cityCode,arb.countyCode,arb.townCode) LIKE CONCAT('%',#{params.adCode},'%')

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/statisticsVO/StatisticsParams.java

@@ -17,6 +17,8 @@
    //填报年份
    private Integer tbYear;

    private String tbQuarter;//季度

    private String isCounty;

    private String tbMonth;