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

xieb

2024-09-26 2508278f2d8ba20ceefa4e54ab7c7e90076ae488

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

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

@@ -18,6 +18,9 @@
        <if test="params.tbYear != null and params.tbYear !=''">
            AND tdis."tb_year" = #{params.tbYear}
        </if>
        <if test="params.tbQuarter != null and params.tbQuarter !=''">
            AND tdis."tb_quarter" = #{params.tbQuarter}
        </if>
        LEFT JOIN YWXT."att_ad_base" aab ON aab."ad_code" = trd."ad_code"
        WHERE
        1=1