zhongrj
2023-06-19 7c2a4aecdcaccb97f4022b2409a7e48505ee4203
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
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;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
 
import java.util.List;
import java.util.Map;
 
/**
 * @author zhongrj
 * @date 2023-04-25
 */
@Mapper
public interface CallTaskMapper{
 
    /**
     * 查詢任务列表数据
     * @param page
     * @param callTask
     * @return
     */
    @DS("ztznwh")
    @InterceptorIgnore(tenantLine = "true")
    List<CallTaskStatistic> getCallListPage(@Param("page") IPage<CallTaskStatistic> page, @Param("callTask") CallTaskStatistic callTask);
 
    /**
     * 查询呼叫详情列表信息
     * @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("idsList") List<String> idsList);
 
    /**
     * 通过水库编码获取行政区名称
     * @param adCode
     * @return
     */
    @DS("zt")
    String getAreaNameByAdCode(@Param("adCode") String adCode);
 
    /**
     * 通过行政区编号获取水库名称
     * @param adCode
     * @return
     */
    @DS("zt")
    List<String> getWaterNameByAreaCode(@Param("adCode") String adCode);
 
    /**
     * 查询所有下级区域
     * @param areaCode
     * @return
     */
    @DS("zt")
    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);
}