普查统计提防柱状图数据接口支持季节查询

xieb

2024-09-26 0f15f409eef03c3f95948ea4384fbd252919e851

普查统计提防柱状图数据接口支持季节查询

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

@@ -266,6 +266,9 @@
        <if test="params.tbYear!=null and params.tbYear!=''">
            AND    tdi."tb_year" = #{params.tbYear}
        </if>
        <if test="params.tbQuarter != null and params.tbQuarter !=''">
            AND tdi."tb_quarter" = #{params.tbQuarter}
        </if>
--         and tdi."investigation_variety" = '白蚁'
        group by tdi."tb_state_id",tdi."dyke_guid",tdi."unit"
        )TEMP1