From e8b2f330647999bad26d2b5e2370f83252ae9c07 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Thu, 15 Jun 2023 10:08:16 +0800
Subject: [PATCH] 新增定时发送外呼未接通人员短信

---
 skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/mapper/SmsTemplateMapper.java |   10 ++++++++++
 1 files changed, 10 insertions(+), 0 deletions(-)

diff --git a/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/mapper/SmsTemplateMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/mapper/SmsTemplateMapper.java
index c6b9587..399d1ee 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/mapper/SmsTemplateMapper.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/mapper/SmsTemplateMapper.java
@@ -2,11 +2,13 @@
 
 import cn.gistack.alerts.sms.entity.SmsTemplate;
 import cn.gistack.alerts.sms.vo.SmsTemplateVO;
+import com.baomidou.dynamic.datasource.annotation.DS;
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import org.apache.ibatis.annotations.Param;
 
 import java.util.List;
+import java.util.Map;
 
 /**
  * 短信发送模板
@@ -21,4 +23,12 @@
 	 * @return
 	 */
     List<SmsTemplateVO> selectSmsTemplatePage(IPage<SmsTemplateVO> page, @Param("smsTemplate") SmsTemplateVO smsTemplate);
+
+	/**
+	 * 查询当前任务未接通的人员信息(包含水库编号)--MYSQL
+	 * @param taskId
+	 * @return
+	 */
+	@DS("znwh")
+    List<Map<String, Object>> getNotConnectPatrolPersonList(@Param("taskId") String taskId);
 }

--
Gitblit v1.9.3