From 63e621dac099edf0f7e6e21f34c85c4d29b2274d Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Thu, 15 Jun 2023 16:14:04 +0800
Subject: [PATCH] 新增通过手机号查询外呼未接通已短信通过的人员信息接口
---
skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/mapper/SmsTemplateMapper.java | 12 ++++++++++++
1 files changed, 12 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..e67aef2 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,14 @@
* @return
*/
List<SmsTemplateVO> selectSmsTemplatePage(IPage<SmsTemplateVO> page, @Param("smsTemplate") SmsTemplateVO smsTemplate);
+
+ /**
+ * 查询当前任务未接通的人员信息（包含水库编号）--MYSQL
+ * @param taskId
+ * @param phone
+ * @return
+ */
+ @DS("znwh")
+ List<Map<String, Object>> getNotConnectPatrolPersonList(@Param("taskId") String taskId,
+ @Param("phone") String phone);
}
--
Gitblit v1.9.3