蓄水量日报市县查询修改

guoshilong

2023-12-01 91bf27944d48c20c113e08a087d799fd0dede51f

蓄水量日报市县查询修改

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/XsfsQktjMapper.xml

@@ -7,12 +7,13 @@
        select
            xq.*
        from SJZT_ODS."xsfs_qktj" xq
        left join SJZT_MD."att_ad_base" a ON a."ad_code" = xq."ad_code"
        where 1=1
        <if test="xsfsQktj.queryTime!=null and xsfsQktj.queryTime!=''">
            and date_format(xq."statistic_time",'%Y-%m-%d') = #{xsfsQktj.queryTime}
        </if>
        <if test="xsfsQktj.adCode!=null and xsfsQktj.adCode!=''">
            and xq."ad_code" = #{xsfsQktj.adCode}
        <if test="xsfsQktj.adCode!=null and xsfsQktj.adCode!=''  ">
            AND a."p_ad_code" = #{xsfsQktj.adCode}
        </if>
    </select>