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/service/impl/SmsServiceImpl.java |  128 ++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 127 insertions(+), 1 deletions(-)

diff --git a/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/service/impl/SmsServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/service/impl/SmsServiceImpl.java
index 9e637dc..8d153bc 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/service/impl/SmsServiceImpl.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/sms/service/impl/SmsServiceImpl.java
@@ -7,16 +7,22 @@
 import cn.com.flaginfo.sdk.cmc.api.sms.send.SMSSendRequest;
 import cn.gistack.alerts.alarmRule.entity.AlarmRecordDetail;
 import cn.gistack.alerts.alarmRule.service.AlarmRecordDetailService;
+import cn.gistack.alerts.sms.constant.MinConstant;
 import cn.gistack.alerts.sms.entity.SmsRecord;
 import cn.gistack.alerts.sms.entity.SmsResult;
 import cn.gistack.alerts.sms.entity.SmsTemplate;
 import cn.gistack.alerts.sms.service.ISmsRecordService;
 import cn.gistack.alerts.sms.service.ISmsResultService;
+import cn.gistack.alerts.sms.service.ISmsTemplateService;
 import cn.gistack.alerts.sms.service.SmsService;
 import cn.gistack.alerts.sms.util.SmsUtils;
 import cn.gistack.alerts.sms.vo.SmsRequestTemplate;
+import cn.gistack.common.cache.CacheNames;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.IdWorker;
+import org.springblade.core.redis.cache.BladeRedis;
 import org.springblade.core.tool.api.R;
+import org.springblade.core.tool.utils.StringUtil;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 
@@ -40,6 +46,12 @@
 
 	@Autowired
 	private ISmsResultService smsResultService;
+
+	@Autowired
+	private ISmsTemplateService smsTemplateService;
+
+	@Autowired
+	private BladeRedis bladeRedis;
 
 	/**
 	 * 发送 xx 变量模板短信
@@ -323,6 +335,101 @@
 	}
 
 	/**
+	 * 外呼未接通-发送短信
+	 * @param taskId
+	 * @param time
+	 * @return
+	 */
+	@Override
+	public String sendSmsByOutCallNotConnect(String taskId,String time) {
+		String templateId = "2431012249882";
+		// 查询当前任务未接通的人员信息(包含水库编号)
+		List<Map<String, Object>> list = smsTemplateService.getNotConnectPatrolPersonList(taskId,null);
+		SmsTemplate smsTemplate = smsTemplateService.getOne(new QueryWrapper<SmsTemplate>().eq("template_id", templateId));
+		if (list.size()>0) {
+			List<Map<String, Object>> newList = new ArrayList<>();
+			// 比对
+			for (Map<String, Object> map : list) {
+				// 获取验证码
+				String redisByTaskId = bladeRedis.get(MinConstant.is_send_prefix + map.get("userPhone").toString() + ":" + map.get("waterCode").toString());
+				// 如果为null,并且不能匹配,加入发送短信集合
+				if (redisByTaskId == null || !StringUtil.equalsIgnoreCase(redisByTaskId, taskId)) {
+					newList.add(map);
+				}
+			}
+			if (newList.size() > 0) {
+				// 组装短信数据
+				StringBuilder builder = new StringBuilder();
+				// 遍历
+				for (Map<String, Object> map : newList) {
+					builder.append(map.get("userPhone") + ",")
+						.append(time + ",")
+						.append(MinConstant.fillWaterInfoUrl + ",")
+						.append(map.get("waterName"))
+						.append(";");
+				}
+				String datas = builder.toString();
+				String title = "手机号码,时间范围,链接地址,水库名称";
+				String[] titleArr = title.split(",");
+				String[] rows = datas.split(";");
+				String[][] dyns = new String[rows.length + 1][titleArr.length];
+				dyns[0] = titleArr;
+				int rowNum = 1;
+				for (String row : rows) {
+					String[] cols = row.split(",");
+					dyns[rowNum++] = cols;
+				}
+				//请求参数
+				DynSMSSendRequest sendRequest = new DynSMSSendRequest();
+				sendRequest.setTemplateId(templateId);
+				sendRequest.setDynData(dyns);
+				// 发送
+				ComResult<DynSMSSendDataResult> resultComResult = SmsUtils.dynSendMethod(sendRequest);
+				SMSSendRequest request = new SMSSendRequest();
+				request.setTemplateId(templateId);
+				request.setMessageContent("");
+				request.setUserNumber("");
+				// 先保存结果记录
+				SmsResult smsResult = saveSendResult(request, rows.length);
+				if (null != smsResult) {
+					List<SmsRecord> smsRecordList = new ArrayList<>();
+					Pattern compile = Pattern.compile("[^0-9]");
+					Integer result = Integer.parseInt(compile.matcher(time).replaceAll("").trim());
+					// 分钟或小时
+					Long validTime = time.contains("分钟") ? 60L * result : 60L * 60 * result;
+					// 遍历保存
+					for (Map<String, Object> map : newList) {
+						SmsRecord smsRecord = new SmsRecord();
+						smsRecord.setId(IdWorker.getId());
+						smsRecord.setTel(map.get("userPhone").toString());
+						// 内容处理
+						String s = smsTemplate.getContent().replaceAll("\\{.+?\\}", "%s");
+						// 拼接内容
+						String arrString = time + "," + MinConstant.fillWaterInfoUrl + "," + map.get("waterName").toString();
+						// 格式转换
+						String format = String.format(s, arrString.split(","));
+						smsRecord.setContent(format);
+						smsRecord.setTemplateId(templateId);
+						smsRecord.setResultId(smsResult.getId());
+						smsRecord.setResponseStatus(resultComResult.getCode().toString());
+						smsRecord.setResponseMsg(resultComResult.getMsg());
+						// 保存redis
+						bladeRedis.setEx(MinConstant.is_send_prefix + map.get("userPhone").toString() + ":" + map.get("waterCode").toString(), taskId, 2 * 60 * 60L);
+						bladeRedis.setEx(MinConstant.fill_info_prefix + map.get("userPhone").toString(), taskId, validTime);
+						// 加入集合
+						smsRecordList.add(smsRecord);
+					}
+					// 批量保存记录
+					Integer count = smsRecordService.batchSaveSendRecord(smsRecordList);
+					// 返回
+					return count.toString();
+				}
+			}
+		}
+		return null;
+	}
+
+	/**
 	 * 校验手机号码
 	 */
 	public static boolean validator(String phone) {
@@ -340,5 +447,24 @@
 		return false;
 	}
 
-
+	/**
+	 * 通过手机号获取外呼未接通已发短信通知的人员水库信息
+	 * @param phone 手机号码
+	 * @return
+	 */
+	@Override
+	public Object getCallNotConnectSmsNoticeInfo(String phone) {
+		List<Map<String, Object>> list = new ArrayList<>();
+		// 通过手机号查询外呼任务id
+		String taskId = bladeRedis.get(MinConstant.fill_info_prefix + phone);
+		// 判断
+		if (null!=taskId && !taskId.equals("")){
+			// 通过手机号和外呼任务id 查询水库人员信息
+			list = smsTemplateService.getNotConnectPatrolPersonList(taskId,phone);
+			// 返回
+			return list;
+		}
+		// 没有,已过期
+		return list;
+	}
 }

--
Gitblit v1.9.3