From 17a609b7a39d7c0398eaa67b790abfe3fab5f01f Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Fri, 04 Aug 2023 11:37:41 +0800
Subject: [PATCH] 智能外呼统计修改（解决省直管时数据查询不到问题），外呼列表列表县市查询异常解决
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/mapper/CallTaskMapper.java | 74 +++++++++++++++++++++++++++++++++++++
1 files changed, 74 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/mapper/CallTaskMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/mapper/CallTaskMapper.java
index a63cd09..c95ca77 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/mapper/CallTaskMapper.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/mapper/CallTaskMapper.java
@@ -124,4 +124,78 @@
*/
@DS("znwh")
List<String> getBeforeThreeDayCallNotConnect(@Param("params") Map<String, Object> map);
+
+ /**
+ * 查询 按区域统计连续三天，连续两天未接通，前一天拒接对应的数量
+ * @param callTaskStatistic
+ * @param resultStatus
+ * @param number
+ * @param day
+ * @return
+ */
+ @DS("zt")
+ @InterceptorIgnore(tenantLine = "true")
+ List<CallTaskStatistic> getNotCallConnectStatisticList(@Param("callTaskStatistic") CallTaskStatistic callTaskStatistic,
+ @Param("resultStatus") String resultStatus,
+ @Param("number") Integer number,
+ @Param("day") Map<String, Object> day);
+
+ /**
+ * 查询未接通，拒接的呼叫结果详情列表信息
+ * @param page
+ * @param list
+ * @param callTaskStatistic
+ * @param day
+ * @return
+ */
+ List<CallTaskStatistic> getCallNotConnectResultList(@Param("page") IPage<CallTaskStatistic> page,
+ @Param("list") List<String> list,
+ @Param("callTaskStatistic") CallTaskStatistic callTaskStatistic,
+ @Param("day") Map<String, Object> day);
+
+ /**
+ * 通过 taskId 查询未呼叫人员（mysql）
+ * @param taskId
+ * @return
+ */
+ @DS("znwh")
+ List<Scene> getCallNotConnectListByTaskId(@Param("taskId") String taskId);
+
+ /**
+ * 查询当前天除去日常呼叫外的统计数据
+ * @param callTaskStatistic
+ * @return
+ */
+ List<CallTaskStatistic> getNoDayOutgoingStatisticList(@Param("callTaskStatistic") CallTaskStatistic callTaskStatistic);
+
+ /**
+ * 按日期行政区呼叫结果详情列表信息
+ * @param callTaskStatistic (count 1:查所有被叫号码 2：查接通号码 3：查未接通号码 4：查拒接号码)
+ * @param page
+ * @return
+ */
+ @InterceptorIgnore(tenantLine = "true")
+ List<CallTaskStatistic> getCallResultList(@Param("page") IPage<CallTaskStatistic> page,
+ @Param("list") List<String> list,
+ @Param("callTaskStatistic") CallTaskStatistic callTaskStatistic);
+
+ /**
+ * 详情导出临时接口
+ * @param callTaskResult
+ * @param page
+ * @return
+ */
+ @DS("ztznwh")
+ @InterceptorIgnore(tenantLine = "true")
+ List<CallTaskResultVO> getCallResultListTemp(@Param("page") IPage<CallTaskResultVO> page,
+ @Param("callTaskResult") CallTaskResultVO callTaskResult,
+ @Param("list") List<String> list);
+
+ /**
+ * 查询从未接通和从未呼叫的水库
+ * @return
+ */
+ @DS("ztznwh")
+ @InterceptorIgnore(tenantLine = "true")
+ List<Scene> getNotCallOrCallNotConnect();
}
--
Gitblit v1.9.3