普查统计提防列表数据接口支持季节查询

xieb

2024-09-28 bf9ed61f17a056aab6f247829329177e54956eac

普查统计提防列表数据接口支持季节查询

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

@@ -420,6 +420,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>
        and (trgis."check_state" > 1)
        )investigationResNum,
        (
@@ -434,6 +437,9 @@
        and (town."ad_code" = aab."guid" or county."ad_code" = aab."guid" or city."ad_code" = aab."guid" or province."ad_code" = aab."guid")
        <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>
        and trgis."check_state" = 3
        )checkResNum,
@@ -459,6 +465,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>
            and trgis."check_state" = 3 and trgis.dangerNum is not null
        )resMayiNum,
        (
@@ -482,6 +491,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>
        and (tdis."check_state" = 1 or tdis."check_state" = 2 or tdis."check_state" = 3)
        )investigationDykeNum,
        (
@@ -496,6 +508,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>
        and (tdis."check_state" = 2 or tdis."check_state" = 3)
        )checkDykeNum,
        IFNULL(
@@ -506,6 +521,9 @@
                <where>
                    <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>
                    and tdis."check_state" >= 2
                </where>
@@ -556,6 +574,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>
        group by tdi."tb_state_id",tdi."dyke_guid",tdi."unit"
        )TEMP1
        ) tdi on tdi."tb_state_id" = tdis."guid"