package cn.gistack.sm.intelligentCall.service.impl;
|
|
import cn.gistack.common.config.MyThreadPoolConfig;
|
import cn.gistack.sm.intelligentCall.constant.CallConstant;
|
import cn.gistack.sm.intelligentCall.constant.ZtConstant;
|
import cn.gistack.sm.intelligentCall.entity.Scene;
|
import cn.gistack.sm.intelligentCall.mapper.CallTaskMapper;
|
import cn.gistack.sm.intelligentCall.service.CallService;
|
import cn.gistack.sm.intelligentCall.vo.CallTaskResultVO;
|
import cn.gistack.sm.intelligentCall.vo.CallTaskStatistic;
|
import cn.gistack.sm.sjztmd.entity.AttAdBase;
|
import cn.gistack.sm.sjztmd.service.IAttAdBaseService;
|
import cn.gistack.sm.sjztmd.vo.AttAdBaseVO;
|
import com.alibaba.fastjson.JSON;
|
import com.alibaba.fastjson.JSONArray;
|
import com.alibaba.fastjson.JSONObject;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.commons.lang3.RandomUtils;
|
import org.apache.commons.lang3.StringUtils;
|
import org.jetbrains.annotations.NotNull;
|
import org.springblade.core.redis.cache.BladeRedis;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.http.*;
|
import org.springframework.stereotype.Service;
|
import org.springframework.util.DigestUtils;
|
import org.springframework.util.MultiValueMap;
|
import org.springframework.web.client.RestTemplate;
|
|
import java.text.DecimalFormat;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.time.LocalDateTime;
|
import java.time.format.DateTimeFormatter;
|
import java.util.*;
|
import java.util.concurrent.CompletableFuture;
|
import java.util.concurrent.ExecutionException;
|
import java.util.concurrent.ThreadPoolExecutor;
|
import java.util.stream.Collectors;
|
|
@Slf4j
|
@Service
|
public class CallServiceImpl implements CallService {
|
|
@Autowired
|
private CallTaskMapper callTaskMapper;
|
|
@Autowired
|
private IAttAdBaseService attAdBaseService;
|
|
@Autowired
|
private RestTemplate restTemplate;
|
|
@Autowired
|
private BladeRedis bladeRedis;
|
|
@Autowired
|
private AsyncCallService asyncCallService;
|
|
// @Value("${dial.task.url}")
|
private String url = CallConstant.HOST;
|
|
// @Value("${dial.task.empId}")
|
private String empId = CallConstant.empId;
|
|
// @Value("${dial.task.appId}")
|
private String appId = CallConstant.AppKey;
|
|
// @Value("${dial.task.appSecret}")
|
private String appSecret = CallConstant.AppSecret;
|
|
// @Value("${dial.task.scenesId}")
|
private String scenesId = CallConstant.scenesId;
|
|
// @Value("${dial.task.callingNumbers}")
|
private String callingNumbers = CallConstant.callingNumbers;
|
|
@Autowired
|
private MyThreadPoolConfig myThreadPoolConfig;
|
|
private static final String CONTENT_TYPE = "application/json; charset=UTF-8";
|
private static final String ACCEPT_TYPE = "application/json";
|
private static final String ACCEPT_ENCODING = "gzip";
|
|
private final static String CREATE_TASK_URL = "/api/task/createTask.json";
|
private final static String CALL_DETAIL_URL = "/api/task/callDetail.json";
|
|
/**
|
* 创建任务
|
* @param map
|
* @return
|
*/
|
@Override
|
public List<String> createTask(Map<String,Object> map) {
|
List<Map<String, String>> params = (List<Map<String, String>>) map.get("list");
|
String requestUrl = url + CREATE_TASK_URL;
|
LocalDateTime now = LocalDateTime.now();
|
String timestamp = now.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss SSS"));
|
String transId = generateTransId(now);
|
String taskName = now.format(DateTimeFormatter.ofPattern("yyyy年MM月dd日HH:mm:ss")) + "智能外呼";;
|
if(null!= map.get("taskName") && !map.get("taskName").equals("")){
|
taskName = map.get("taskName").toString();
|
}
|
String[] numbers = StringUtils.split(callingNumbers,",");
|
String taskScheduleTime = LocalDateTime.now().plusHours(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));
|
if (null!=map.get("taskScheduleTime") && !map.get("taskScheduleTime").equals("")){
|
taskScheduleTime = map.get("taskScheduleTime").toString();
|
}
|
String scenesIds = scenesId;
|
if (null!=map.get("scenesId") && !map.get("scenesId").equals("")){
|
scenesIds = map.get("scenesId").toString();
|
}
|
JSONArray arr = getCalleeInfo(params);
|
HttpHeaders httpHeaders = new HttpHeaders();
|
httpHeaders.add("Content-Type", CONTENT_TYPE);
|
httpHeaders.add("Accept", ACCEPT_TYPE);
|
httpHeaders.add("Accept-Encoding", ACCEPT_ENCODING);
|
JSONObject paramJson = new JSONObject();
|
paramJson.put("taskName", taskName);
|
paramJson.put("scenesId", scenesIds);
|
paramJson.put("callingNumbers", numbers);
|
paramJson.put("taskScheduleTime", taskScheduleTime);
|
paramJson.put("calleeData", arr);
|
paramJson.put("empId", empId);
|
String token = getToken(appId, timestamp, transId, appSecret, paramJson.toJSONString());
|
JSONObject headerJson = new JSONObject();
|
headerJson.put("appId", appId);
|
headerJson.put("timestamp", timestamp);
|
headerJson.put("transId", transId);
|
headerJson.put("token", token);
|
JSONObject bodyJson = new JSONObject();
|
bodyJson.put("head", headerJson);
|
bodyJson.put("body", paramJson);
|
HttpEntity<String> stringHttpEntity = new HttpEntity<>(bodyJson.toJSONString(), httpHeaders);
|
log.info("创建超汛限智能外呼任务请求参数：{}", bodyJson.toJSONString());
|
ResponseEntity<String> response = restTemplate.postForEntity(requestUrl, stringHttpEntity, String.class);
|
log.info("创建外呼任务请求结果：{}", response.getBody());
|
if (response.getStatusCode() != HttpStatus.OK) {
|
log.error("创建智能外呼任务失败：{}", response.getStatusCode());
|
}
|
JSONObject jsonObject = JSON.parseObject(response.getBody());
|
Boolean success = jsonObject.getBoolean("success");
|
String taskId = "";
|
if (success){
|
//通过任务名称查询taskId
|
taskId = callTaskMapper.getTaskIdByTaskName(taskName);
|
}
|
List<String> list = new ArrayList<>();
|
list.add(response.getBody());
|
list.add(taskId);
|
list.add(success.toString());
|
// 返回
|
return list;
|
}
|
|
/**
|
* 获取通话详情
|
* @param taskId
|
* @param calleeNumber
|
* @return
|
*/
|
@Override
|
public Object getCallDetail(String taskId, String calleeNumber) {
|
String requestUrl = url + CALL_DETAIL_URL;
|
LocalDateTime now = LocalDateTime.now();
|
String timestamp = now.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss SSS"));
|
String transId = generateTransId(now);
|
HttpHeaders httpHeaders = new HttpHeaders();
|
httpHeaders.add("Content-Type", CONTENT_TYPE);
|
httpHeaders.add("Accept", ACCEPT_TYPE);
|
httpHeaders.add("Accept-Encoding", ACCEPT_ENCODING);
|
JSONObject paramJson = new JSONObject();
|
paramJson.put("taskId", taskId);
|
paramJson.put("calleeNumber", calleeNumber);
|
JSONObject bodyJson = new JSONObject();
|
bodyJson.put("head", getHeadJson(appId, timestamp, transId, appSecret, paramJson.toJSONString()));
|
bodyJson.put("body", paramJson);
|
HttpEntity<String> stringHttpEntity = new HttpEntity<>(bodyJson.toJSONString(), httpHeaders);
|
ResponseEntity<String> response = restTemplate.postForEntity(requestUrl, stringHttpEntity, String.class);
|
log.info(response.toString());
|
if (response.getStatusCode() == HttpStatus.OK) {
|
JSONObject responseJson = (JSONObject) JSONObject.parse(response.getBody());
|
assert responseJson != null;
|
// return JSONObject.parseObject(responseJson.getString("data"), CallBackDetailVO.class);
|
return response.getBody();
|
}
|
return null;
|
}
|
|
private String getToken(String appId, String timestamp, String transId, String appSecret, String body) {
|
String sb = "appId" + appId + "timestamp" + timestamp + "transId" + transId + body + appSecret;
|
return DigestUtils.md5DigestAsHex(sb.getBytes());
|
}
|
|
private JSONObject getHeadJson(String appId, String timestamp, String transId, String appSecret, String body) {
|
String token = getToken(appId, timestamp, transId, appSecret, body);
|
JSONObject headerJson = new JSONObject();
|
headerJson.put("appId", appId);
|
headerJson.put("timestamp", timestamp);
|
headerJson.put("transId", transId);
|
headerJson.put("token", token);
|
return headerJson;
|
}
|
|
private String generateTransId(LocalDateTime now) {
|
String s = "000000" + RandomUtils.nextLong(0, 999999);
|
String randomStr = StringUtils.substring(s, -6);
|
return now.format(DateTimeFormatter.ofPattern("yyyyMMddHHmmssSSS")) + randomStr;
|
}
|
|
/**
|
* 封装被呼人对象
|
* @param params 被呼人信息
|
* @return 被呼人数组
|
*/
|
private JSONArray getCalleeInfo(List<Map<String, String>> params) {
|
JSONArray arr = new JSONArray();
|
params.forEach(map -> {
|
String phone = map.get("phone");
|
String name = map.get("name");
|
String code = map.get("code");
|
String userName = map.get("userName");
|
String userId = map.get("userId");
|
String over = map.get("over");
|
if (StringUtils.isNotEmpty(phone) && StringUtils.isNotEmpty(name)) {
|
JSONObject json = new JSONObject();
|
json.put("被叫号码", phone);
|
json.put("水库名称", name);
|
json.put("水库编码", code);
|
json.put("用户名", userName);
|
json.put("用户id", userId);
|
json.put("超汛限多少米", over);
|
arr.add(json);
|
}
|
});
|
return arr;
|
}
|
|
/**
|
* 查詢任务列表数据
|
* @param page
|
* @param callTask
|
* @return
|
*/
|
@Override
|
public IPage<CallTaskStatistic> getCallListPage(IPage<CallTaskStatistic> page, CallTaskStatistic callTask) {
|
return page.setRecords(callTaskMapper.getCallListPage(page,callTask));
|
}
|
|
/**
|
* 查询呼叫详情列表信息
|
* @param callTaskResult
|
* @param page
|
* @return
|
*/
|
@Override
|
public IPage<CallTaskResultVO> getCallTaskResultListPage(IPage<CallTaskResultVO> page, CallTaskResultVO callTaskResult) {
|
List<String> list = new ArrayList<>();
|
if (null!= callTaskResult.getAreaName() && !callTaskResult.getAreaName().equals("")){
|
// 查询所有下级区域code
|
list = getAllChildrenAreaByAreaCode(callTaskResult.getAreaName());
|
}
|
List<CallTaskResultVO> resultListPage = callTaskMapper.getCallTaskResultListPage(page, callTaskResult,list,null);
|
return page.setRecords(resultListPage);
|
}
|
|
/**
|
* 导出呼叫详情列表信息
|
* @param callTaskResult
|
* @return
|
*/
|
@Override
|
public Object getCallTaskResultList(CallTaskResultVO callTaskResult) {
|
List<String> list = new ArrayList<>();
|
List<String> idsList = new ArrayList<>();
|
if (null!= callTaskResult.getAreaName() && !callTaskResult.getAreaName().equals("")){
|
// 查询所有下级区域code
|
list = getAllChildrenAreaByAreaCode(callTaskResult.getAreaName());
|
}
|
if (null!= callTaskResult.getIds() && !callTaskResult.getIds().equals("")){
|
// 查询所有下级区域code
|
idsList = Arrays.asList(callTaskResult.getIds().split(","));
|
}
|
List<CallTaskResultVO> resultListPage = callTaskMapper.getCallTaskResultListPage(null, callTaskResult,list,idsList);
|
// 返回
|
return resultListPage;
|
}
|
|
// /**
|
// * 查询智能外呼统计数据-按日期-行政区统计
|
// * @param page
|
// * @param callTaskStatistic
|
// * @return
|
// */
|
// @Override
|
// public Object getOutgoingStatisticList(IPage<CallTaskStatistic> page,CallTaskStatistic callTaskStatistic) {
|
// if (null==callTaskStatistic.getCreateTime() || callTaskStatistic.getCreateTime().equals("")){
|
// long l = System.currentTimeMillis();
|
// // 设置当前时间的前一天
|
// callTaskStatistic.setCreateTime(new SimpleDateFormat("yyyy-MM-dd").format(new Date(l - 60*60*24*1000)));
|
// }
|
// ThreadPoolExecutor executor = myThreadPoolConfig.threadPoolExecutor();
|
// // 异步查询统计数据
|
// CompletableFuture<List<CallTaskStatistic>> callTaskStatisticCompletableFuture = getListCompletableFuture(page, callTaskStatistic, executor);
|
// // 查询 按区域统计连续三天，连续两天未接通，前一天拒接对应的数量
|
// Map<String, Object> threeDay = computationTime(callTaskStatistic.getCreateTime(), 2);
|
// Map<String, Object> twoDay = computationTime(callTaskStatistic.getCreateTime(), 1);
|
// Map<String, Object> oneDay = computationTime(callTaskStatistic.getCreateTime(), 0);
|
// // 查询
|
// CompletableFuture<List<CallTaskStatistic>> threeDayNotCallConnect = getListCompletableFuture(callTaskStatistic, executor, threeDay, "200003", 2);
|
// CompletableFuture<List<CallTaskStatistic>> twoDayNotCallConnect = getListCompletableFuture(callTaskStatistic, executor, twoDay, "200003", 1);
|
// CompletableFuture<List<CallTaskStatistic>> oneDayNotCallConnect = getListCompletableFuture(callTaskStatistic, executor, oneDay, "200005", 0);
|
// //等待所有任务执行完成
|
// try {
|
// CompletableFuture.allOf(callTaskStatisticCompletableFuture,threeDayNotCallConnect,twoDayNotCallConnect,oneDayNotCallConnect).get();
|
// // 数据处理
|
// List<CallTaskStatistic> callTaskStatistics = getCallTaskStatistics(callTaskStatisticCompletableFuture, oneDay, threeDayNotCallConnect, twoDayNotCallConnect, oneDayNotCallConnect);
|
// // 取当前行政区总数据
|
// List<CallTaskStatistic> totalList = getTotalCallTaskStatistics(callTaskStatistics,callTaskStatistic);
|
// // 排序
|
// callTaskStatistics = getCallTaskStatisticsByOrder(callTaskStatistic, callTaskStatistics);
|
// // 合并数据
|
// totalList.addAll(callTaskStatistics);
|
// // 返回数据
|
// if (null!= callTaskStatistic.getIsPage()) {
|
// return totalList;
|
// }else {
|
// return page.setRecords(totalList);
|
// }
|
// } catch (InterruptedException e) {
|
// e.printStackTrace();
|
// } catch (ExecutionException e) {
|
// e.printStackTrace();
|
// }
|
// // 返回
|
// return null;
|
// }
|
|
/**
|
* 查询智能外呼统计数据-按日期-行政区统计
|
* @param page
|
* @param callTaskStatistic
|
* @return
|
*/
|
@Override
|
public Object getOutgoingStatisticList(IPage<CallTaskStatistic> page,CallTaskStatistic callTaskStatistic) {
|
if (null==callTaskStatistic.getCreateTime() || callTaskStatistic.getCreateTime().equals("")){
|
long l = System.currentTimeMillis();
|
// 设置当前时间的前一天
|
callTaskStatistic.setCreateTime(new SimpleDateFormat("yyyy-MM-dd").format(new Date(l - 60*60*24*1000)));
|
}
|
ThreadPoolExecutor executor = myThreadPoolConfig.threadPoolExecutor();
|
// 异步查询当前天日常呼叫（3次）统计数据
|
CompletableFuture<List<CallTaskStatistic>> callTaskStatisticCompletableFuture = getListCompletableFuture(page, callTaskStatistic, executor);
|
// 查询当前天除去日常呼叫外的统计数据
|
CompletableFuture<List<CallTaskStatistic>> notCallConnect = getListCompletableFuture(callTaskStatistic,executor);
|
//等待所有任务执行完成
|
try {
|
CompletableFuture.allOf(callTaskStatisticCompletableFuture,notCallConnect).get();
|
// 数据处理
|
List<CallTaskStatistic> callTaskStatistics = getCallTaskStatistics(callTaskStatisticCompletableFuture,null,null,null, notCallConnect,callTaskStatistic);
|
// 取当前行政区总数据
|
List<CallTaskStatistic> totalList = getTotalCallTaskStatistics(callTaskStatistics,callTaskStatistic);
|
// 排序
|
callTaskStatistics = getCallTaskStatisticsByOrder(callTaskStatistic, callTaskStatistics);
|
// 合并数据
|
totalList.addAll(callTaskStatistics);
|
// 返回数据
|
if (null!= callTaskStatistic.getIsPage()) {
|
return totalList;
|
}else {
|
return page.setRecords(totalList);
|
}
|
} catch (InterruptedException e) {
|
e.printStackTrace();
|
} catch (ExecutionException e) {
|
e.printStackTrace();
|
}
|
// 返回
|
return null;
|
}
|
|
/**
|
* 获取当前行政区总数据
|
* @param callTaskStatistics
|
* @param callTaskStatisticEntity
|
* @return
|
*/
|
private List<CallTaskStatistic> getTotalCallTaskStatistics(List<CallTaskStatistic> callTaskStatistics,CallTaskStatistic callTaskStatisticEntity) {
|
List<CallTaskStatistic> statistics = new ArrayList<>();
|
CallTaskStatistic callTaskStatistic = new CallTaskStatistic();
|
Integer totalCalleeNumberCount = 0;
|
Integer totalConnectionCount = 0;
|
Integer totalThreeNoConnectCount = 0;
|
Integer totalTwoNoConnectCount = 0;
|
Integer totalRefuseConnectCount = 0;
|
// 遍历
|
for (CallTaskStatistic taskStatistic : callTaskStatistics) {
|
totalCalleeNumberCount += Integer.parseInt(taskStatistic.getCalleeNumberCount());
|
totalConnectionCount += Integer.parseInt(taskStatistic.getConnectionCount());
|
totalThreeNoConnectCount += taskStatistic.getThreeNoConnectCount();
|
totalTwoNoConnectCount += taskStatistic.getTwoNoConnectCount();
|
totalRefuseConnectCount += taskStatistic.getRefuseConnectCount();
|
}
|
// 设置数据
|
callTaskStatistic.setCalleeNumberCount(totalCalleeNumberCount.toString());
|
callTaskStatistic.setConnectionCount(totalConnectionCount.toString());
|
callTaskStatistic.setThreeNoConnectCount(totalThreeNoConnectCount);
|
callTaskStatistic.setTwoNoConnectCount(totalTwoNoConnectCount);
|
callTaskStatistic.setRefuseConnectCount(totalRefuseConnectCount);
|
callTaskStatistic.setCreateTime(callTaskStatistics.get(0).getCreateTime());
|
// 查询当前行政区名称
|
AttAdBase attAdBase = new AttAdBase();
|
attAdBase.setGuid(callTaskStatisticEntity.getAdCode());
|
AttAdBaseVO detail = attAdBaseService.getDetail(attAdBase);
|
callTaskStatistic.setAdCode(callTaskStatisticEntity.getAdCode());
|
if (null != detail){
|
callTaskStatistic.setAdName(detail.getAdName());
|
}
|
// 计算比例
|
//格式化小数
|
DecimalFormat df = new DecimalFormat("0.00");
|
callTaskStatistic.setCallCompletingRate(df.format((float)totalConnectionCount/totalCalleeNumberCount*100));
|
statistics.add(callTaskStatistic);
|
// 返回
|
return statistics;
|
}
|
|
/**
|
* 排序
|
* @param callTaskStatistic
|
* @param callTaskStatistics
|
* @return
|
*/
|
private List<CallTaskStatistic> getCallTaskStatisticsByOrder(CallTaskStatistic callTaskStatistic, List<CallTaskStatistic> callTaskStatistics) {
|
// 排序
|
if (null != callTaskStatistic.getSortName() && !callTaskStatistic.getSortName().equals("")) {
|
if (callTaskStatistic.getSortName().equals("refuseConnectCount")) {
|
if (callTaskStatistic.getSortOrder().equals("desc")) {
|
callTaskStatistics = callTaskStatistics.stream().sorted(Comparator.comparing(CallTaskStatistic::getRefuseConnectCount).reversed()).collect(Collectors.toList());
|
}else {
|
callTaskStatistics = callTaskStatistics.stream().sorted(Comparator.comparing(CallTaskStatistic::getRefuseConnectCount)).collect(Collectors.toList());
|
}
|
}
|
if (callTaskStatistic.getSortName().equals("twoNoConnectCount")) {
|
if (callTaskStatistic.getSortOrder().equals("desc")) {
|
callTaskStatistics = callTaskStatistics.stream().sorted(Comparator.comparing(CallTaskStatistic::getTwoNoConnectCount).reversed()).collect(Collectors.toList());
|
}else {
|
callTaskStatistics = callTaskStatistics.stream().sorted(Comparator.comparing(CallTaskStatistic::getTwoNoConnectCount)).collect(Collectors.toList());
|
}
|
}
|
if (callTaskStatistic.getSortName().equals("threeNoConnectCount")) {
|
if (callTaskStatistic.getSortOrder().equals("desc")) {
|
callTaskStatistics = callTaskStatistics.stream().sorted(Comparator.comparing(CallTaskStatistic::getThreeNoConnectCount).reversed()).collect(Collectors.toList());
|
}else {
|
callTaskStatistics = callTaskStatistics.stream().sorted(Comparator.comparing(CallTaskStatistic::getThreeNoConnectCount)).collect(Collectors.toList());
|
}
|
}
|
}
|
return callTaskStatistics;
|
}
|
|
/**
|
* 查询当前天除去日常呼叫外的统计数据
|
* @param callTaskStatistic
|
* @param executor
|
* @return
|
*/
|
@NotNull
|
private CompletableFuture<List<CallTaskStatistic>> getListCompletableFuture(CallTaskStatistic callTaskStatistic, ThreadPoolExecutor executor) {
|
return CompletableFuture.supplyAsync(()->{
|
List<CallTaskStatistic> outgoingStatisticList = callTaskMapper.getNoDayOutgoingStatisticList(callTaskStatistic);
|
return outgoingStatisticList;
|
},executor);
|
}
|
|
/**
|
* 按行政区查询对应的接通率
|
* @param page
|
* @param callTaskStatistic
|
* @param executor
|
* @return
|
*/
|
@NotNull
|
private CompletableFuture<List<CallTaskStatistic>> getListCompletableFuture(IPage<CallTaskStatistic> page, CallTaskStatistic callTaskStatistic, ThreadPoolExecutor executor) {
|
return CompletableFuture.supplyAsync(()->{
|
List<CallTaskStatistic> outgoingStatisticList = new ArrayList<>();
|
// 判断是否分页
|
if (null!= callTaskStatistic.getIsPage()){
|
// 不分页
|
outgoingStatisticList = callTaskMapper.getOutgoingStatisticList(null,callTaskStatistic,null);
|
}else {
|
// 按天查询数据
|
outgoingStatisticList = callTaskMapper.getOutgoingStatisticList(page, callTaskStatistic, null);
|
}
|
return outgoingStatisticList;
|
},executor);
|
}
|
|
/**
|
* 数据处理
|
* @param callTaskStatisticCompletableFuture
|
* @param oneDay
|
* @param threeDayNotCallConnect
|
* @param twoDayNotCallConnect
|
* @param oneDayNotCallConnect
|
* @return
|
* @throws InterruptedException
|
* @throws ExecutionException
|
*/
|
@NotNull
|
private List<CallTaskStatistic> getCallTaskStatistics(CompletableFuture<List<CallTaskStatistic>> callTaskStatisticCompletableFuture,
|
Map<String, Object> oneDay,
|
CompletableFuture<List<CallTaskStatistic>> threeDayNotCallConnect,
|
CompletableFuture<List<CallTaskStatistic>> twoDayNotCallConnect,
|
CompletableFuture<List<CallTaskStatistic>> oneDayNotCallConnect,
|
CallTaskStatistic callTaskStatistic) throws InterruptedException, ExecutionException {
|
// 获取信息
|
List<CallTaskStatistic> callTaskStatistics = callTaskStatisticCompletableFuture.get();
|
// List<CallTaskStatistic> threeNotConnectTaskStatisticsList = threeDayNotCallConnect.get();
|
// List<CallTaskStatistic> twoNotConnectTaskStatisticsList = twoDayNotCallConnect.get();
|
List<CallTaskStatistic> oneNotConnectTaskStatisticsList = oneDayNotCallConnect.get();
|
// 遍历
|
for (CallTaskStatistic taskStatistic : callTaskStatistics) {
|
// taskStatistic.setCreateTime(oneDay.get("endTime").toString());
|
taskStatistic.setCreateTime(callTaskStatistic.getCreateTime());
|
// for (CallTaskStatistic statistic : threeNotConnectTaskStatisticsList) {
|
// if (taskStatistic.getGuid().equals(statistic.getGuid())){
|
// taskStatistic.setThreeNoConnectCount(statistic.getCount());
|
// }
|
// }
|
// for (CallTaskStatistic statistic : twoNotConnectTaskStatisticsList) {
|
// if (taskStatistic.getGuid().equals(statistic.getGuid())){
|
// taskStatistic.setTwoNoConnectCount(statistic.getCount());
|
// }
|
// }
|
for (CallTaskStatistic statistic : oneNotConnectTaskStatisticsList) {
|
if (taskStatistic.getGuid().equals(statistic.getGuid())){
|
Integer count = Integer.parseInt(taskStatistic.getCalleeNumberCount()) + Integer.parseInt(statistic.getCalleeNumberCount());
|
Integer connectCount = Integer.parseInt(taskStatistic.getConnectionCount()) + Integer.parseInt(statistic.getConnectionCount());
|
taskStatistic.setCalleeNumberCount(count.toString());
|
taskStatistic.setConnectionCount(connectCount.toString());
|
taskStatistic.setRefuseConnectCount(taskStatistic.getRefuseConnectCount() + statistic.getRefuseConnectCount());
|
// 计算比例
|
if (connectCount==0){
|
taskStatistic.setCallCompletingRate("0");
|
}else {
|
//格式化小数
|
DecimalFormat df = new DecimalFormat("0.00");
|
taskStatistic.setCallCompletingRate(df.format((float) connectCount / count * 100));
|
}
|
}
|
}
|
}
|
return callTaskStatistics;
|
}
|
|
/**
|
* 按行政区查询未接通/拒接统计数据
|
* @param callTaskStatistic
|
* @param executor
|
* @param threeDay 日期
|
* @param s 状态
|
* @param i 数量
|
* @return
|
*/
|
@NotNull
|
private CompletableFuture<List<CallTaskStatistic>> getListCompletableFuture(CallTaskStatistic callTaskStatistic, ThreadPoolExecutor executor, Map<String, Object> threeDay, String s, int i) {
|
return CompletableFuture.supplyAsync(() -> {
|
// 按天查询数据，区域统计
|
List<CallTaskStatistic> threeDayNotCallConnectStatisticList
|
= callTaskMapper.getNotCallConnectStatisticList(callTaskStatistic, s, i, threeDay);
|
return threeDayNotCallConnectStatisticList;
|
}, executor);
|
}
|
|
/**
|
* 查询智能外呼统计数据-行政区统计
|
* @param callTaskStatistic
|
* @return
|
*/
|
@Override
|
public Object getOutgoingStatisticByArea(CallTaskStatistic callTaskStatistic) {
|
return callTaskMapper.getOutgoingStatisticByArea(callTaskStatistic);
|
}
|
|
/**
|
* 查询所有下级区域
|
* @param areaCode
|
* @return
|
*/
|
private List<String> getAllChildrenAreaByAreaCode(String areaCode) {
|
return callTaskMapper.getAllChildrenAreaByAreaCode(areaCode);
|
}
|
|
/**
|
* 通过水库编码获取行政区名称
|
* @param adCode
|
* @return
|
*/
|
private String getAreaNameByAdCode(String adCode) {
|
// 通过adCode查询区域名称
|
return callTaskMapper.getAreaNameByAdCode(adCode);
|
}
|
|
/**
|
* 通过行政区编号获取水库名称
|
* @param areaCode
|
* @return
|
*/
|
private List<String> getWaterNameByAreaCode(String areaCode) {
|
// 通过行政区编号获取水库名称
|
return callTaskMapper.getWaterNameByAreaCode(areaCode);
|
}
|
|
/**
|
* 根据条件自动创建外呼任务
|
* @param params
|
* @return
|
*/
|
@Override
|
public List<String> createCallTaskByParam(Map<String, Object> params) {
|
// 常规任务，每天上午11点打150人，下午2点打11点未接人员，下午5点打下午2点未接通人员
|
String redisOneKey = bladeRedis.get(CallConstant.call_task_key);
|
if (null==redisOneKey){
|
List<String> stringList = everydayCall(params);
|
// 取出数据进行设置 taskId
|
bladeRedis.setEx(CallConstant.call_task_key,stringList.get(1)+","+1,6*60*60L);
|
// 异步保存日常关联呼叫任务信息
|
asyncCallService.saveDailyCallTask(stringList.get(1),1);
|
// 响应
|
return stringList;
|
}else {
|
return createEverydayAfter(redisOneKey);
|
}
|
}
|
|
/**
|
* 日常外呼任务未接通的继续拨打
|
* @param redisOneKey 取值为上一次外呼的任务id
|
* @return
|
*/
|
private List<String> createEverydayAfter(String redisOneKey) {
|
// redisOneKey = "2216,1";
|
String[] split = redisOneKey.split(",");
|
String taskId = split[0];
|
String type = split[1];
|
List<String> stringList = new ArrayList<>();
|
Map<String, Object> params = new HashMap<>();
|
// 通过 taskId 查询未呼叫人员（mysql）
|
List<Scene> list = callTaskMapper.getCallNotConnectListByTaskId(taskId);
|
if (list.size()>0){
|
Set<Scene> scenes = new HashSet<>(list);
|
// 传入调度时间和随机得到的人员信息进行任务的创建并返回
|
params.put("list",setForListMap(scenes));
|
// 调度时间处理
|
params.put("taskScheduleTime",new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()));
|
// 创建任务
|
stringList = createTask(params);
|
|
// 判断是否发送短信
|
if (type.equals("1")){
|
// 取出数据进行设置 taskId
|
bladeRedis.setEx(CallConstant.call_task_key,stringList.get(1)+","+2,6*60*60L);
|
// 异步保存日常关联呼叫任务信息
|
asyncCallService.saveDailyCallTask(stringList.get(1),2);
|
}
|
// 判断是否发送短信
|
if (type.equals("2")){
|
// 新增一个参数代表需要发短信
|
stringList.add("3");
|
// 异步保存日常关联呼叫任务信息
|
asyncCallService.saveDailyCallTask(stringList.get(1),3);
|
}
|
}
|
// 返回
|
return stringList;
|
}
|
|
/**
|
* 日常外呼任务创建
|
* @param params
|
* @return
|
*/
|
private List<String> everydayCall(Map<String, Object> params) {
|
// 自动创建任务的 4个条件 1：呼叫人数 2：调度时间 3：是否超汛限 4：多少天内呼叫过的不呼叫（天数）
|
//1. 调用中台接口查询出所有需要发任务的水库巡查责任人相关信息（该处需要将是否超汛限条件传入）
|
JSONArray jsonArray = getZtWaterMangerData(params);
|
// 过滤得到手机号集合（排查手机号为null的数据）
|
List<Scene> totalList = filterJsonToList(jsonArray);
|
//2. 查询外呼多少天内已呼叫过的人员手机号集合信息
|
// 计算开始时间，结束时间
|
computationTime(params);
|
// 查询对应数据
|
List<String> list = callTaskMapper.getCallUserPhoneByParam(params);
|
//3. 比对中台得到的数据和外呼已呼叫信息，从中随机取出呼叫人数的信息
|
Set<Scene> taskRandomList = getCreateTaskRandomList(params, totalList, list);
|
//4. 传入调度时间和随机得到的人员信息进行任务的创建并返回
|
params.put("list",setForListMap(taskRandomList));
|
// 调度时间处理
|
params.put("taskScheduleTime",new SimpleDateFormat("yyyy-MM-dd").format(new Date())+ " " +params.get("taskScheduleTime") + ":00");
|
// 创建任务并返回结果
|
return createTask(params);
|
}
|
|
/**
|
* 智能外呼呼叫前一天未接通人员
|
* @param map 包含调度时间
|
* @return
|
*/
|
@Override
|
public List<String> createOutCallTaskByNotConnectJobHandler(Map<String, Object> map) {
|
map.put("day",1);
|
map.put("isOver","");
|
// 自动创建任务的 条件1：昨天外呼未接通人员 条件2：前三天如果同一个人都未接通，则不再呼叫
|
// 计算开始时间，结束时间
|
computationTime(map);
|
// 1. 查询前一天呼叫未接通人员
|
List<Scene> oneDayCallNotConnectList = callTaskMapper.getBeforeOneDayCallNotConnect(map);
|
if (oneDayCallNotConnectList.size()>0) {
|
// 2. 判断是否填报,查询前一天已填报的人员
|
List<String> fillRecordList = callTaskMapper.getFillRecordList(map);
|
// 3. 查询三天都未接通的人员
|
map.put("day", 3);
|
List<String> threeDayCallNotConnectList = callTaskMapper.getBeforeThreeDayCallNotConnect(map);
|
// 4. 组装数据，从前一天呼叫未接通里面去除已填报人员，去除连续三天未接人员
|
Set<Scene> taskRandomList = callNotConnectListDataHandle(oneDayCallNotConnectList, fillRecordList, threeDayCallNotConnectList);
|
// 5. 传入调度时间和随机得到的人员信息进行任务的创建并返回
|
map.put("list", setForListMap(taskRandomList));
|
// 调度时间处理
|
map.put("taskScheduleTime", new SimpleDateFormat("yyyy-MM-dd").format(new Date()) + " " + map.get("taskScheduleTime") + ":00");
|
// 创建任务并返回结果
|
return createTask(map);
|
}
|
return null;
|
}
|
|
/**
|
* 组装数据，从前一天呼叫未接通里面去除已填报人员，去除连续三天未接人员
|
* @param oneDayCallNotConnectList 前一天呼叫未接通人员信息
|
* @param fillRecordList 前一天已填报的人员手机号集合
|
* @param threeDayCallNotConnectList 连续三天都未接通的人员手机号集合
|
* @return
|
*/
|
private Set<Scene> callNotConnectListDataHandle(List<Scene> oneDayCallNotConnectList, List<String> fillRecordList, List<String> threeDayCallNotConnectList) {
|
// 取差集
|
// 去除前一天已填报的人员手机号集合
|
List<Scene> sceneList = oneDayCallNotConnectList.stream().filter(item -> !fillRecordList.contains(item.getPhone())).collect(Collectors.toList());
|
// 再去除连续三天都未接通的人员手机号集合
|
List<Scene> resultList = sceneList.stream().filter(item -> !threeDayCallNotConnectList.contains(item.getPhone())).collect(Collectors.toList());
|
// 转set去重
|
HashSet<Scene> scenes = new HashSet<>(resultList);
|
// 返回
|
return scenes;
|
}
|
|
/**
|
* hashSet 转 List<Map<String,String>>
|
* @param taskRandomList
|
* @return
|
*/
|
private List<Map<String,String>> setForListMap(Set<Scene> taskRandomList) {
|
List<Map<String,String>> list = new ArrayList<>();
|
for (Scene scene : taskRandomList) {
|
Map<String, String> map = new HashMap<>();
|
map.put("phone",scene.getPhone());
|
map.put("name",scene.getWaterName());
|
map.put("code",scene.getWaterCode());
|
map.put("userName",scene.getUsername());
|
map.put("userId",scene.getPhone());
|
map.put("over","");
|
// 加入集合
|
list.add(map);
|
}
|
return list;
|
}
|
|
/**
|
* 获取随机呼叫的相关信息
|
* @param params
|
* @param totalList
|
* @param list
|
*/
|
private Set<Scene> getCreateTaskRandomList(Map<String, Object> params, List<Scene> totalList, List<String> list) {
|
Integer personNumber = ZtConstant.person_number;
|
if (!params.get("personNumber").equals("")){
|
personNumber = Integer.parseInt(params.get("personNumber").toString());
|
}
|
// 先取差集
|
List<Scene> sceneList = totalList.stream().filter(item -> !list.contains(item.getPhone())).collect(Collectors.toList());
|
// 如果差集数量不够 预定的数量（超汛情况），则从未超汛情况数据中补齐预定的数量
|
if (sceneList.size()<personNumber){
|
Map<String, Object> map = new HashMap<>();
|
map.put("isOver",0);
|
// 查询未超汛的数据
|
JSONArray jsonArray = getZtWaterMangerData(map);
|
// 过滤得到手机号集合（排查手机号为null的数据）
|
List<Scene> sceneListNoOver = filterJsonToList(jsonArray);
|
// 取差集
|
List<Scene> differenceSceneListNoOver = sceneListNoOver.stream().filter(item -> !list.contains(item.getPhone())).collect(Collectors.toList());
|
// 再随机抽取对应人员手机号
|
Set<Scene> hashSet = new HashSet<>();
|
// 先将超汛的加入集合
|
for (Scene scene : sceneList) {
|
hashSet.add(scene);
|
}
|
// 未超汛的补充
|
personNumber = personNumber - sceneList.size();
|
Random random = new Random();
|
for (int i = 0; i < differenceSceneListNoOver.size(); i++) {
|
// 获取随机数作为下标索引
|
int num = random.nextInt(differenceSceneListNoOver.size());
|
// 保存到 hashSet ，保证唯一
|
hashSet.add(differenceSceneListNoOver.get(num));
|
// 数量达到预期设定退出循环
|
if (hashSet.size() == personNumber) {
|
break;
|
}
|
}
|
return hashSet;
|
}else {
|
// 再随机抽取对应人员手机号
|
Set<Scene> hashSet = new HashSet<>();
|
Random random = new Random();
|
for (int i = 0; i < sceneList.size(); i++) {
|
// 获取随机数作为下标索引
|
int num = random.nextInt(sceneList.size());
|
// 保存到 hashSet ，保证唯一
|
hashSet.add(sceneList.get(num));
|
// 数量达到预期设定退出循环
|
if (hashSet.size() == personNumber) {
|
break;
|
}
|
}
|
return hashSet;
|
}
|
}
|
|
/**
|
* 将 jsonArray 取出手机号得到新的集合
|
* @param jsonArray
|
* @return
|
*/
|
private List<Scene> filterJsonToList(JSONArray jsonArray) {
|
List<Scene> list = new ArrayList<>();
|
for (int i = 0; i < jsonArray.size(); i++) {
|
if (null != jsonArray.getJSONObject(i).get("user_phone") &&
|
!jsonArray.getJSONObject(i).get("user_phone").equals("")){
|
Scene scene = new Scene();
|
scene.setPhone(jsonArray.getJSONObject(i).get("user_phone").toString());
|
scene.setUsername(jsonArray.getJSONObject(i).get("user_name").toString());
|
scene.setUserId(jsonArray.getJSONObject(i).get("user_phone").toString());
|
scene.setWaterName(jsonArray.getJSONObject(i).get("res_nm").toString());
|
scene.setWaterCode(jsonArray.getJSONObject(i).get("res_cd").toString());
|
// 加入集合
|
list.add(scene);
|
}
|
}
|
return list;
|
}
|
|
/**
|
* 计算时间
|
* @param params
|
*/
|
private void computationTime(Map<String, Object> params) {
|
long l = System.currentTimeMillis();
|
Integer day = ZtConstant.day_number;
|
// 获取天数
|
if (null != params.get("day")){
|
day = Integer.parseInt(params.get("day").toString());
|
}
|
long m = 60*60*24*1000*day;
|
// 相减得到时间
|
Long x = l-m;
|
// 格式化日期
|
String startTime = new SimpleDateFormat("yyyy-MM-dd").format(new Date(x));
|
String endTime = new SimpleDateFormat("yyyy-MM-dd").format(new Date(l));
|
// 加入到参数中
|
params.put("startTime",startTime);
|
params.put("endTime",endTime);
|
}
|
|
/**
|
* 计算时间
|
* @param time 传入的时间
|
* @param day 天数
|
*/
|
private Map<String,Object> computationTime(String time,Integer day) {
|
HashMap<String, Object> map = new HashMap<>(2);
|
long l = 0;
|
try {
|
l = new SimpleDateFormat("yyyy-MM-dd").parse(time).getTime();
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
long m = 60*60*24*1000*day;
|
// 相减得到时间
|
Long x = l-m;
|
// 格式化日期
|
String startTime = new SimpleDateFormat("yyyy-MM-dd").format(new Date(x));
|
String endTime = new SimpleDateFormat("yyyy-MM-dd").format(new Date(l));
|
// 加入到参数中
|
map.put("startTime",startTime);
|
map.put("endTime",endTime);
|
// 返回
|
return map;
|
}
|
|
/**
|
* 调用中台接口查询出所有需要发任务的水库巡查责任人相关信息（该处需要将是否超汛限条件传入）
|
* @param params
|
* @return
|
*/
|
private JSONArray getZtWaterMangerData(Map<String, Object> params) {
|
//设置请求头
|
HttpHeaders headers = new HttpHeaders();
|
headers.add(ZtConstant.header_key, ZtConstant.header_value);
|
//封装请求头
|
HttpEntity<MultiValueMap<String, Object>> formEntity = new HttpEntity<MultiValueMap<String, Object>>(headers);
|
try {
|
//有请求头，有参数请求
|
ResponseEntity<String> responseEntity =
|
restTemplate.exchange(ZtConstant.patr_person_api+"?is_over="+params.get("isOver"),
|
HttpMethod.GET,
|
formEntity,
|
String.class);
|
JSONObject jsonObject = JSON.parseObject(responseEntity.getBody());
|
JSONArray jsonArray = JSONArray.parseArray(jsonObject.get("resultList").toString());
|
// 返回
|
return jsonArray;
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return null;
|
}
|
|
/**
|
* 查询未接通，拒接的呼叫结果详情列表信息
|
* @param page
|
* @param callTaskStatistic
|
* @return
|
*/
|
@Override
|
public Object getCallNotConnectResultList(IPage<CallTaskStatistic> page,CallTaskStatistic callTaskStatistic) {
|
// 计算时间
|
Map<String, Object> map = computationTime(callTaskStatistic.getCreateTime(), callTaskStatistic.getCount());
|
List<String> list = new ArrayList<>();
|
if (null!= callTaskStatistic.getAdCode() && !callTaskStatistic.getAdCode().equals("")){
|
// 查询所有下级区域code
|
list = getAllChildrenAreaByAreaCode(callTaskStatistic.getAdCode());
|
}
|
if (null!=callTaskStatistic.getIsPage()){
|
// 不分页
|
return callTaskMapper.getCallNotConnectResultList(null, list,callTaskStatistic,map);
|
}
|
List<CallTaskStatistic> callNotConnectResultList = callTaskMapper.getCallNotConnectResultList(page,list, callTaskStatistic,map);
|
// 返回
|
return page.setRecords(callNotConnectResultList);
|
}
|
|
/**
|
* 按日期行政区呼叫结果详情列表信息
|
* @param callTaskStatistic
|
* @param page
|
* @return
|
*/
|
@Override
|
public Object getCallResultList(IPage<CallTaskStatistic> page, CallTaskStatistic callTaskStatistic) {
|
List<String> list = new ArrayList<>();
|
if (null!= callTaskStatistic.getAdCode() && !callTaskStatistic.getAdCode().equals("")){
|
// 查询所有下级区域code
|
list = getAllChildrenAreaByAreaCode(callTaskStatistic.getAdCode());
|
}
|
if (null!=callTaskStatistic.getIsPage()){
|
// 不分页
|
return callTaskMapper.getCallResultList(null, list,callTaskStatistic);
|
}
|
List<CallTaskStatistic> callNotConnectResultList = callTaskMapper.getCallResultList(page,list, callTaskStatistic);
|
// 返回
|
return page.setRecords(callNotConnectResultList);
|
}
|
}
|
