空表发送预警短信

aix

2024-09-13 621908e4299ec5a44af5a5c68014644dc66cc414

空表发送预警短信

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

@@ -77,6 +77,10 @@
     * @return
     */
    int getDimResInfoACount();
    int getAttWmstBaseCount();
    int getAttImagestBaseCount();
    int getAttCdBaseCount();
    int getAttWyCdBaseCount();

    Boolean updateIsShowStatus(@Param("ids") String ids, @Param("isShow") Integer status);


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

@@ -387,6 +387,22 @@
        from sjzt_dw."dim_res_info_a"
    </select>

    <select id="getAttWmstBaseCount" resultType="java.lang.Integer">
        select count(*) from sjzt_md."att_wmst_base"
    </select>

    <select id="getAttImagestBaseCount" resultType="java.lang.Integer">
        select count(*) from sjzt_md."att_imagest_base"
    </select>

    <select id="getAttCdBaseCount" resultType="java.lang.Integer">
        select count(*) from sjzt_md."att_cd_base"
    </select>

    <select id="getAttWyCdBaseCount" resultType="java.lang.Integer">
        select count(*) from sjzt_md."att_wy_cd_base"
    </select>


    <update id="updateIsShowStatus">
        UPDATE SJZT_MD."att_res_base" SET "is_show" = #{isShow}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttResBaseService.java

@@ -54,6 +54,10 @@
    AttResAdVO getWaterRegionInfoByResGuid(String guid);

    int getDimResInfoACount();
    int getAttWmstBaseCount();
    int getAttImagestBaseCount();
    int getAttCdBaseCount();
    int getAttWyCdBaseCount();

    Boolean updateIsShowStatus(String ids, Integer status);


 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java

@@ -325,6 +325,26 @@
    }

    @Override
    public int getAttWmstBaseCount() {
        return baseMapper.getAttWmstBaseCount();
    }

    @Override
    public int getAttImagestBaseCount() {
        return baseMapper.getAttImagestBaseCount();
    }

    @Override
    public int getAttCdBaseCount() {
        return baseMapper.getAttCdBaseCount();
    }

    @Override
    public int getAttWyCdBaseCount() {
        return baseMapper.getAttWyCdBaseCount();
    }

    @Override
    public Boolean updateIsShowStatus(String ids, Integer status) {
        return baseMapper.updateIsShowStatus(ids,status);
    }

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sms/feign/DataAbnormalWarnClient.java

@@ -91,7 +91,15 @@
            count = attResRsbNorspiService.count();
        } else if (tableName.equals("att_res_flse_lim")) {
            count = attResFlseLimService.count();
        }
        } else if (tableName.equals("att_wmst_base"))
            count = resBaseService.getAttWmstBaseCount();
        else if (tableName.equals("att_imagest_base"))
            count = resBaseService.getAttImagestBaseCount();
        else if (tableName.equals("att_cd_base"))
            count = resBaseService.getAttCdBaseCount();
        else if (tableName.equals("att_wy_cd_base"))
            count = resBaseService.getAttWyCdBaseCount();


        log.info("预警数量count:" +  count);