From 621908e4299ec5a44af5a5c68014644dc66cc414 Mon Sep 17 00:00:00 2001
From: aix <vip_xiaobin810@163.com>
Date: Fri, 13 Sep 2024 23:05:42 +0800
Subject: [PATCH] 空表发送预警短信
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java | 20 ++++++++++++++++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml | 16 ++++++++++++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sms/feign/DataAbnormalWarnClient.java | 10 +++++++++-
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java | 4 ++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttResBaseService.java | 4 ++++
5 files changed, 53 insertions(+), 1 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java
index aacab16..710a89a 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java
+++ b/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);
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml
index 7898f6d..b3b2aa1 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml
+++ b/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}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttResBaseService.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttResBaseService.java
index b2dd909..2a4c0ad 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttResBaseService.java
+++ b/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);
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java
index dfa9c37..a23759a 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java
+++ b/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);
}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sms/feign/DataAbnormalWarnClient.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sms/feign/DataAbnormalWarnClient.java
index 457f483..e780ce8 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sms/feign/DataAbnormalWarnClient.java
+++ b/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);
--
Gitblit v1.9.3