zhongrj
2023-06-30 1581ef5a1b4e24ecf21fd95ee6e4b9bd4085b2da
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
package cn.gistack.alerts.sms.service.impl;
 
import cn.com.flaginfo.sdk.cmc.api.result.ComResult;
import cn.com.flaginfo.sdk.cmc.api.sms.dynsend.DynSMSSendDataResult;
import cn.com.flaginfo.sdk.cmc.api.sms.dynsend.DynSMSSendRequest;
import cn.com.flaginfo.sdk.cmc.api.sms.send.SMSSendDataResult;
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.notice.util.FormatUtil;
import cn.gistack.alerts.sms.constant.MinConstant;
import cn.gistack.alerts.sms.entity.SmsRecord;
import cn.gistack.alerts.sms.entity.SmsRequest;
import cn.gistack.alerts.sms.entity.SmsResult;
import cn.gistack.alerts.sms.entity.SmsTemplate;
import cn.gistack.alerts.sms.excel.SendRainSmsExcel;
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.alerts.sms.vo.SmsResponseVO;
import cn.gistack.sm.intelligentCall.entity.CallNotFillRecord;
import cn.gistack.sm.intelligentCall.feign.OutCallClient;
import cn.gistack.sm.sjztmd.feign.IAttResManagePersonClient;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.IdWorker;
import org.jetbrains.annotations.NotNull;
import org.springblade.core.redis.cache.BladeRedis;
import org.springblade.core.tool.api.R;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.util.stream.Collectors;
 
import static cn.gistack.alerts.sms.util.SmsUtils.validator;
 
/**
 * 短信发送服务实现层
 * @author zhongrj
 * @date 2023-05-30
 */
@Service
public class SmsServiceImpl implements SmsService {
 
    @Autowired
    private ISmsRecordService smsRecordService;
 
    @Autowired
    private AlarmRecordDetailService alarmRecordDetailService;
 
    @Autowired
    private ISmsResultService smsResultService;
 
    @Autowired
    private ISmsTemplateService smsTemplateService;
 
    @Autowired
    private BladeRedis bladeRedis;
 
    @Autowired
    private OutCallClient outCallClient;
 
    @Autowired
    private IAttResManagePersonClient attResManagePersonClient;
 
    @Autowired
    private SmsAsyncService asyncService;
 
    /**
     * 发送 xx 变量模板短信
     * @param phoneNumbers 手机号集合
     * @param request 内容对象
     * @return
     */
    @Override
    public Object sendXXMsg(SMSSendRequest request, List<String> phoneNumbers) {
        List<ComResult<SMSSendDataResult>> list = new ArrayList<>();
        if (phoneNumbers.size()>0){
            // 先保存结果记录
            SmsResult smsResult = saveSendResult(null,request, phoneNumbers.size());
            // 遍历发送
            for (String phone : phoneNumbers) {
                request.setUserNumber(phone);
                // 发送
                ComResult<SMSSendDataResult> result = SmsUtils.sendMsg(request);
                if(null != smsResult) {
                    // 保存记录
                    saveSendRecord(request, result.getCode().toString(), result.getMsg(), smsResult.getId());
                }
                list.add(result);
            }
        }
        return list;
    }
 
    /**
     * 发送 具名 变量模板短信(告警定制)
     * @param smsRequestTemplate
     * @return
     */
    @Override
    public Map<String, Object> sendSignMsg(SmsRequestTemplate smsRequestTemplate) {
        // 取出数据
        SMSSendRequest request = new SMSSendRequest();
        SmsTemplate smsTemplate = smsRequestTemplate.getSmsTemplate();
        request.setTemplateId(smsTemplate.getTemplateId());
        List<List<String>> templateContent = smsRequestTemplate.getTemplateContent();
        // 先保存结果记录
        SmsResult smsResult = saveSendResult(null,request, templateContent.size());
        List<SmsRecord> smsRecordList = new ArrayList<>();
        // 遍历处理
        for (List<String> list : templateContent) {
            AlarmRecordDetail alarmRecordDetail = new AlarmRecordDetail();
            alarmRecordDetail.setReservoirNumber(list.get(0));
            alarmRecordDetail.setAlarmRecordId(Long.parseLong(list.get(list.size() - 1)));
            alarmRecordDetail.setAlarmMode("短信");
            // 删除 最后一个 告警记录id
            list.remove(list.size() - 1);
            // 删除 0 水库编码
            list.remove(0);
            // 转换字符串
            String row = String.join(",", list);
            // 组装数据
            String[][] dyns = new String[][]{{smsRequestTemplate.getTitle()}, {row}};
            //请求参数
            ComResult<DynSMSSendDataResult> resultComResult = sendDynSMSSendDataResultComResult(smsTemplate.getTemplateId(), dyns);
 
            SmsRecord smsRecord = new SmsRecord();
            if (null != smsResult){
                alarmRecordDetail.setPhone(list.get(0));
                // 设置手机号
                request.setUserNumber(list.get(0));
                // 内容处理
                String s = smsTemplate.getContent().replaceAll("\\{.+?\\}", "%s");
                // 短信内容拼接(完成发送的结果信息)
                // 需要删除最前面的手机号
                list.remove(0);
                // 格式转换
                String format = String.format(s, list.toArray());
                // 设置内容
                request.setMessageContent(format);
                // 保存记录
                smsRecord = saveSendRecord(request, resultComResult.getCode().toString(), resultComResult.getMsg(), smsResult.getId());
                if (null != smsRecord){
                    alarmRecordDetail.setAlarmContent(format);
                    alarmRecordDetail.setSendRecordId(smsRecord.getId());
                    alarmRecordDetail.setCreateTime(new Date());
                    // 保存告警记录详情信息
                    boolean save = alarmRecordDetailService.save(alarmRecordDetail);
                }
            }
            smsRecordList.add(smsRecord);
        }
        Map<String, Object> map = new HashMap<>(2);
        map.put("smsRecord",smsRecordList.size());
        // 返回
        return map;
    }
 
    /**
     * 保存站内信记录信息
     * @param smsRequestTemplate
     * @return
     */
    @Override
    public Map<String, Object> saveInStationInfo(SmsRequestTemplate smsRequestTemplate) {
        // 取出数据
        SMSSendRequest request = new SMSSendRequest();
        SmsTemplate smsTemplate = smsRequestTemplate.getSmsTemplate();
        request.setTemplateId(smsTemplate.getTemplateId());
        List<List<String>> templateContent = smsRequestTemplate.getTemplateContent();
        // 先保存结果记录
        SmsResult smsResult = saveSendResult(null,request, templateContent.size());
        List<SmsRecord> smsRecordList = new ArrayList<>();
        // 遍历处理
        for (List<String> list : templateContent) {
            AlarmRecordDetail alarmRecordDetail = new AlarmRecordDetail();
            alarmRecordDetail.setReservoirNumber(list.get(0));
            alarmRecordDetail.setAlarmRecordId(Long.parseLong(list.get(list.size() - 1)));
            alarmRecordDetail.setAlarmMode("站内信");
            // 未读
            alarmRecordDetail.setStatus(1);
            // 删除 最后一个 告警记录id
            list.remove(list.size() - 1);
            // 删除 0 水库编码
            list.remove(0);
 
            SmsRecord smsRecord = new SmsRecord();
            if (null != smsResult){
                alarmRecordDetail.setPhone(list.get(0));
                // 设置手机号
                request.setUserNumber(list.get(0));
                // 内容处理
                String s = smsTemplate.getContent().replaceAll("\\{.+?\\}", "%s");
                // 需要删除最前面的手机号
                list.remove(0);
                // 格式转换
                String format = String.format(s, list.toArray());
                // 设置内容
                request.setMessageContent(format);
                // 保存记录
                smsRecord = saveSendRecord(request, "", "", smsResult.getId());
                if (null != smsRecord){
                    alarmRecordDetail.setAlarmContent(format);
                    alarmRecordDetail.setSendRecordId(smsRecord.getId());
                    alarmRecordDetail.setCreateTime(new Date());
                    // 保存告警记录详情信息
                    boolean save = alarmRecordDetailService.save(alarmRecordDetail);
                }
            }
            smsRecordList.add(smsRecord);
        }
        Map<String, Object> map = new HashMap<>(2);
        map.put("smsRecord",smsRecordList);
        map.put("smsResult",smsResult);
        // 返回
        return map;
    }
 
    /**
     * 发送降雨短信--批量一次发送
     * @param params 具名变量头
     * @return
     */
    @Override
    public Object sendSignRainMsg(Map<String, Object> params) {
        String[] titleArr = params.get("title").toString().split(",");
        String data = params.get("data").toString();
        String templateId = params.get("templateId").toString();
        // 查询短信模板
        SmsTemplate smsTemplate = smsTemplateService.getOne(new QueryWrapper<SmsTemplate>().eq("template_id", templateId));
        List<String> phones = (List<String>)params.get("phones");
        List<String> errPhones = new ArrayList<>();
        // 手机号去重
        Set<String> hashSet = new HashSet<>();
        for (String phone : phones) {
            hashSet.add(phone);
        }
        // 批量发送短信
        Map<String, Object> batchSendSmsMap = batchSendSms(hashSet, titleArr, data, smsTemplate,errPhones);
        ComResult<DynSMSSendDataResult> resultComResult = (ComResult<DynSMSSendDataResult>)batchSendSmsMap.get("resultComResult");
        errPhones = (List<String>) batchSendSmsMap.get("errPhones");
        // 计算差值
        Integer diff = phones.size() - hashSet.size();
        if (resultComResult.getCode()==0){
            String successMsg = "发送成功!共提交号码 "+phones.size()+" 个,其中重复号码 "+diff+" 个,错误号码 "
                +errPhones.size()+" 个,发送成功号码 "+ hashSet.size() + " 个。";
            // 返回
            return R.data(200,successMsg,null);
        }
        String errorMsg = "发送失败!共提交号码 "+phones.size()+" 个,其中重复号码 "+diff+" 个,错误号码 "+errPhones.size()+
            " 个,发送异常号码 "+ hashSet.size()+" 个,异常原因" + resultComResult.getMsg() + "。";
        // 返回
        return R.data(400,errorMsg,null);
    }
 
 
    /**
     * 发送记录保存
     * @param smsResponse 响应消息
     * @param request 发送信息
     * @param number 号码个数
     */
    @Override
    public SmsResult saveSendResult(SmsResponseVO smsResponse, SMSSendRequest request, Integer number) {
        // 先保存结果表
        SmsResult smsResult = new SmsResult();
        smsResult.setTemplateId(request.getTemplateId());
        smsResult.setContent(request.getMessageContent());
        smsResult.setNumber(number);
        if (null!= smsResponse) {
            smsResult.setResCode(smsResponse.getCode());
            smsResult.setResMsg(smsResponse.getMsg());
        }
        //插入记录
        boolean save = smsResultService.save(smsResult);
        if (save){
            return smsResult;
        }
        // 返回
        return null;
    }
 
 
    /**
     * 保存发送短信记录信息
     * @param request
     * @param code 响应code
     * @param sendMsg 响应消息
     * @param resultId
     */
    @Override
    public SmsRecord saveSendRecord(SMSSendRequest request, String code, String sendMsg, Long resultId) {
        // 在保存明细
        SmsRecord smsRecord = new SmsRecord();
        smsRecord.setTel(request.getUserNumber());
        smsRecord.setContent(request.getMessageContent());
        smsRecord.setTemplateId(request.getTemplateId());
        smsRecord.setResultId(resultId);
        smsRecord.setResponseStatus(code);
        smsRecord.setResponseMsg(sendMsg);
        //插入记录
        smsRecordService.save(smsRecord);
        // 返回
        return smsRecord;
    }
 
    /**
     * 外呼未接通-发送短信
     * @param taskId
     * @param time
     * @return
     */
    @Override
    public String sendSmsByOutCallNotConnect(String taskId,String time) {
        String templateId = "2431012249882";
        // 查询符合当前时间外呼任务id集合
        String format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
        List<String> taskIdList = smsTemplateService.getTaskIdListByTime(format);
        if (taskIdList.size()>0) {
            // 查询当前任务未接通的人员信息(包含水库编号)
            List<Map<String, Object>> list = smsTemplateService.getNotConnectPatrolPersonList(taskIdList, 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) {
                    // 获取任务id
                    String redisByTaskId = bladeRedis.get(MinConstant.is_send_prefix + map.get("callId").toString());
                    // 如果为null,并且不能匹配,加入发送短信集合
                    if (redisByTaskId == null) {
                        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(map.get("waterName") + ",")
                            .append(MinConstant.fillWaterInfoUrl + "?" + "callId=" + map.get("callId"))
                            .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;
                    }
                    ComResult<DynSMSSendDataResult> resultComResult = sendDynSMSSendDataResultComResult(templateId, dyns);
                    SmsResponseVO smsResponse = new SmsResponseVO();
                    smsResponse.setCode(resultComResult.getCode().toString());
                    smsResponse.setMsg(resultComResult.getMsg());
                    SmsResult smsResult = getSaveSmsResult(smsResponse,templateId, rows, "");
                    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) {
                            // 保存redis
                            // 已发送短信的人员对应呼叫id的过期时间
                            bladeRedis.setEx(MinConstant.is_send_prefix + map.get("callId").toString(),  map.get("taskId").toString(), MinConstant.is_send_time);
                            // 填报过期时间
                            bladeRedis.setEx(MinConstant.fill_info_prefix + map.get("callId").toString(), map.get("taskId").toString(), validTime);
                            // 封装短息记录数据
                            SmsRecord smsRecord = getSmsRecord(time, templateId, smsTemplate, resultComResult, smsResult, map);
                            // 加入集合
                            smsRecordList.add(smsRecord);
                        }
                        // 批量保存记录
                        Integer count = smsRecordService.batchSaveSendRecord(smsRecordList);
                        // 返回
                        return count.toString();
                    }
                }
            }
        }
        return null;
    }
 
    /**
     * 保存短信发送结果
     * @param smsResponse
     * @param templateId
     * @param rows
     * @param content
     * @return
     */
    private SmsResult getSaveSmsResult(SmsResponseVO smsResponse,String templateId, String[] rows, String content) {
        SMSSendRequest request = new SMSSendRequest();
        request.setTemplateId(templateId);
        request.setMessageContent(content);
        request.setUserNumber("");
        // 先保存结果记录
        return saveSendResult(smsResponse,request, rows.length);
    }
 
    /**
     * 动态批量发送短信
     * @param templateId
     * @param dyns
     * @return
     */
    private ComResult<DynSMSSendDataResult> sendDynSMSSendDataResultComResult(String templateId, String[][] dyns) {
        //请求参数
        DynSMSSendRequest sendRequest = new DynSMSSendRequest();
        sendRequest.setTemplateId(templateId);
        sendRequest.setDynData(dyns);
        // 发送
        return SmsUtils.dynSendMethod(sendRequest);
    }
 
    /**
     * 短信记录数据处理
     * @param time
     * @param templateId
     * @param smsTemplate
     * @param resultComResult
     * @param smsResult
     * @param map
     * @return
     */
    @NotNull
    private SmsRecord getSmsRecord(String time, String templateId, SmsTemplate smsTemplate, ComResult<DynSMSSendDataResult> resultComResult, SmsResult smsResult, Map<String, Object> map) {
        SmsRecord smsRecord = new SmsRecord();
        smsRecord.setId(IdWorker.getId());
        smsRecord.setTel(map.get("userPhone").toString());
        // 内容处理
        String s = smsTemplate.getContent().replaceAll("\\{.+?\\}", "%s");
        // 拼接内容
        String arrString = time + "," +
            map.get("waterName").toString() + "," +
            MinConstant.fillWaterInfoUrl + "?" + "callId=" + map.get("callId") ;
        // 格式转换
        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());
        // 返回
        return smsRecord;
    }
 
 
    /**
     * 通过手机号获取外呼未接通已发短信通知的人员水库信息
     * @param callId 呼叫id
     * @return
     */
    @Override
    public Object getCallNotConnectSmsNoticeInfo(String callId) {
        Map<String, Object> map = new HashMap<>(2);
        boolean flag = false;
        List<Map<String, Object>> list = new ArrayList<>();
        // 通过手机号查询外呼任务id
        String taskId = bladeRedis.get(MinConstant.is_send_prefix + callId);
        // 判断
        if (null!=taskId && !taskId.equals("")){
            List<String> taskIdList = new ArrayList<>();
            taskIdList.add(taskId);
            // 通过手机号和外呼任务id 查询水库人员信息
            list = smsTemplateService.getNotConnectPatrolPersonList(taskIdList,callId);
            // 查询是否填报
            CallNotFillRecord callNotFillRecordInfo = outCallClient.getCallNotFillRecordInfo(callId);
            if (callNotFillRecordInfo != null){
                flag = true;
            }
            // 封装数据
            map.put("list",list);
            map.put("isFill",flag);
            // 返回
            return map;
        }
        // 没有,已过期
        return map;
    }
 
    /**
     * 导入表格发送降雨短信
     * @param list 导入的excel 集合数据
     * @param startTime 短信内容填报起始时间
     * @param endTime 短信内容填报截止时间
     * @return
     */
    @Override
    public Object importSendRainSms(List<SendRainSmsExcel> list,String startTime,String endTime) {
        String templateId = "2431012251309";
        // 获取水库个数
        Integer size = list.size();
        List<String> errPhones = new ArrayList<>();
        // 转换
        List<String> stringList = list.stream().map(SendRainSmsExcel::getWaterCode).collect(Collectors.toList());
        // 通过水库代码获取巡查责任人及技术责任人手机号
        Set<String> personList = attResManagePersonClient.getPersonListByWaterCodeList(stringList);
        // 查询短信模板
        SmsTemplate smsTemplate = smsTemplateService.getOne(new QueryWrapper<SmsTemplate>().eq("template_id", templateId));
        String param = startTime + "-" + endTime;
        // 拼接短信标题数组
        String [] titleArr = getSmsTitleArr(smsTemplate);
        // 批量发送短信
        Map<String, Object> batchSendSmsMap = batchSendSms(personList, titleArr, param, smsTemplate,errPhones);
        ComResult<DynSMSSendDataResult> resultComResult = (ComResult<DynSMSSendDataResult>)batchSendSmsMap.get("resultComResult");
        errPhones = (List<String>) batchSendSmsMap.get("errPhones");
        // 计算差值
        Integer diff = size - errPhones.size();
        if (resultComResult.getCode()==0){
            String successMsg = "发送成功!共导入水库个数 "+ size +" 个,其中发送号码 "+ diff + " 个。";
            // 返回
            return R.data(200,successMsg,null);
        }
        String errorMsg = "发送失败!共导入水库个数 "+ size +" 个,发送异常号码 "+ diff + " 个,异常原因" + resultComResult.getMsg() + "。";
        // 返回
        return R.data(400,errorMsg,null);
    }
 
    /**
     * 拼接短信标题数组
     * @param smsTemplate
     * @return
     */
    private String[] getSmsTitleArr(SmsTemplate smsTemplate) {
        String title = FormatUtil.composeMessage(smsTemplate.getContent());
        // 返回
        return title.split(",");
    }
 
    /**
     * 批量发送动态短信
     * @param phoneList
     * @param titleArr 示例: [手机号码,水库名称,水位值]
     * @param param 示例: ***水库,15.12
     * @param smsTemplate
     * @return
     */
    private Map<String, Object> batchSendSms(Set<String> phoneList,String[] titleArr,String param,SmsTemplate smsTemplate,List<String> errPhones){
        Map<String, Object> map = new HashMap<>();
        StringBuilder builder = new StringBuilder();
        // 遍历,拼接短信
        if (phoneList.size()>0){
            for (String phone : phoneList) {
                if (validator(phone)){
                    builder.append(phone+","+ param).append(";");
                }else {
                    // 异常手机号
                    errPhones.add(phone);
                }
            }
        }
        String datas = builder.toString();
        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;
        }
        //请求参数
        ComResult<DynSMSSendDataResult> resultComResult = sendDynSMSSendDataResultComResult(smsTemplate.getTemplateId(), dyns);
        SmsResponseVO smsResponse = new SmsResponseVO();
        smsResponse.setCode(resultComResult.getCode().toString());
        smsResponse.setMsg(resultComResult.getMsg());
        SmsResult smsResult = getSaveSmsResult(smsResponse,smsTemplate.getTemplateId(), rows, "");
        // 异步记录发送记录
        asyncService.batchSaveSendRecord(smsResult,rows,smsTemplate,resultComResult);
        // 返回
        map.put("errPhones",errPhones);
        map.put("resultComResult",resultComResult);
        return map;
    }
 
    /**
     * 发送邮件提醒短信
     * @param list
     */
    @Override
    public void sendEmailMsg(List<String> list, SmsRequest smsRequest) {
        String templateId = "2431012165299";
        // 获取水库个数
        List<String> errPhones = new ArrayList<>();
        // 去重
        Set<String> hashSet = new HashSet<>(list);
        // 查询短信模板
        SmsTemplate smsTemplate = smsTemplateService.getOne(new QueryWrapper<SmsTemplate>().eq("template_id", templateId));
        String param = smsRequest.getContent();
        // 拼接短信标题数组
        String [] titleArr = getSmsTitleArr(smsTemplate);
        // 批量发送短信
        Map<String, Object> batchSendSmsMap = batchSendSms(hashSet, titleArr, param, smsTemplate,errPhones);
    }
}