大坝安全监测接口添加流域

guoshilong

2023-09-07 94be5e3a4c9f881020db928d452d7e5ae16cc6d5

大坝安全监测接口添加流域

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/damSecurity/mapper/DamSecurityMapper.xml

@@ -439,7 +439,9 @@
        SELECT
               arb."center_long" AS longitude,
               arb."center_lat" AS latitude,
               resCd
               resCd,
               abb."code" AS basCode,
               abb."name" AS basName
        FROM
            (
                SELECT NAG.dam_id resCd,count(*)  FROM YWXT.NKY_ALARM_GET NAG GROUP BY NAG.dam_id
@@ -449,10 +451,18 @@
                LEFT JOIN SJZT_MD."att_ad_base" county ON county."guid" = town."p_ad_code"
                LEFT JOIN SJZT_MD."att_ad_base" city ON city."guid" = county."p_ad_code"
                LEFT JOIN SJZT_MD."att_ad_base" province ON province."guid" = city."p_ad_code"

                LEFT JOIN SJZT_MD."rel_res_bas_loc" rrbl ON rrbl."res_guid" = baseAlarm.resCd
                LEFT JOIN SJZT_MD."att_bas_base" abb ON abb."code" = rrbl."bas_guid"
                LEFT JOIN SJZT_MD."att_bas_base" pabb ON abb."p_code" = pabb."code"

        WHERE 1=1
        <if test="dam.adCode != null and dam.adCode !='' ">
            AND  (province."ad_code" =#{dam.adCode} or city."ad_code" = #{dam.adCode} or county."ad_code" = #{dam.adCode})
        </if>
        <if test="dam.basCode != null and dam.basCode !='' ">
            AND abb."code" = #{dam.basCode} or pabb."code" = #{dam.basCode}
        </if>
    </select>

    <select id="damResInfoCount" resultType="cn.gistack.sm.damSecurity.vo.DamStatisticsRes">

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/damSecurity/vo/DamStationStatistics.java

@@ -91,4 +91,14 @@
    private String startTime;

    private String endTime;

    /**
     * 流域id
     */
    private String basCode;

    /**
     * 流域名称
     */
    private String basName;
}