From 7c2a4aecdcaccb97f4022b2409a7e48505ee4203 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Mon, 19 Jun 2023 16:37:58 +0800
Subject: [PATCH] 智能外呼统计查询修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/mapper/CallTaskMapper.java | 74 ++++++++++++++++++++++++++++++++++++-
1 files changed, 72 insertions(+), 2 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 7054178..a63cd09 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
@@ -1,5 +1,6 @@
package cn.gistack.sm.intelligentCall.mapper;
+import cn.gistack.sm.intelligentCall.entity.Scene;
import cn.gistack.sm.intelligentCall.vo.CallTaskResultVO;
import cn.gistack.sm.intelligentCall.vo.CallTaskStatistic;
import com.baomidou.dynamic.datasource.annotation.DS;
@@ -9,6 +10,7 @@
import org.apache.ibatis.annotations.Param;
import java.util.List;
+import java.util.Map;
/**
* @author zhongrj
@@ -31,13 +33,16 @@
* 查询呼叫详情列表信息
* @param callTaskResult
* @param page
+ * @param list
+ * @param idsList
* @return
*/
@DS("ztznwh")
@InterceptorIgnore(tenantLine = "true")
List<CallTaskResultVO> getCallTaskResultListPage(@Param("page") IPage<CallTaskResultVO> page,
@Param("callTaskResult") CallTaskResultVO callTaskResult,
- @Param("list") List<String> list);
+ @Param("list") List<String> list,
+ @Param("idsList") List<String> idsList);
/**
* 通过水库编码获取行政区名称
@@ -49,9 +54,74 @@
/**
* 通过行政区编号获取水库名称
+ * @param adCode
+ * @return
+ */
+ @DS("zt")
+ List<String> getWaterNameByAreaCode(@Param("adCode") String adCode);
+
+ /**
+ * 查询所有下级区域
* @param areaCode
* @return
*/
@DS("zt")
- List<String> getWaterNameByAreaCode(@Param("adCode") String areaCode);
+ List<String> getAllChildrenAreaByAreaCode(@Param("areaCode") String areaCode);
+
+ /**
+ * 查询智能外呼统计数据-按日期-行政区统计
+ * @param page
+ * @param callTaskStatistic
+ * @param list
+ * @return
+ */
+ @DS("zt")
+ List<CallTaskStatistic> getOutgoingStatisticList(@Param("page") IPage<CallTaskStatistic> page,
+ @Param("callTaskStatistic") CallTaskStatistic callTaskStatistic,
+ @Param("list") List<String> list);
+
+ /**
+ * 查询智能外呼统计数据-行政区统计
+ * @param callTaskStatistic
+ * @return
+ */
+ @DS("zt")
+ List<CallTaskStatistic> getOutgoingStatisticByArea(@Param("callTaskStatistic") CallTaskStatistic callTaskStatistic);
+
+ /**
+ * 查询外呼多少天内已呼叫过的人员手机号集合信息
+ * @param params
+ * @return
+ */
+ List<String> getCallUserPhoneByParam(@Param("params")Map<String, Object> params);
+
+ /**
+ * 通过任务名称查询taskId
+ * @param taskName
+ * @return
+ */
+ @DS("znwh")
+ String getTaskIdByTaskName(@Param("taskName") String taskName);
+
+ /**
+ * 查询前一天呼叫未接通人员
+ * @return
+ */
+ @DS("znwh")
+ List<Scene> getBeforeOneDayCallNotConnect(@Param("params")Map<String, Object> params);
+
+ /**
+ * 查询前一天已填报的人员
+ * @param map
+ * @return
+ */
+ List<String> getFillRecordList(@Param("params") Map<String, Object> map);
+
+ /**
+ * 查询三天都未接通的人员
+ * @param map
+ * @return
+ */
+ @DS("znwh")
+ List<String> getBeforeThreeDayCallNotConnect(@Param("params") Map<String, Object> map);
}
--
Gitblit v1.9.3