智能外呼统计查询修改

zhongrj

2023-06-19 7c2a4aecdcaccb97f4022b2409a7e48505ee4203

 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,13 +10,13 @@
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * @author zhongrj
 * @date 2023-04-25
 */
@Mapper
@DS("ztznwh")
public interface CallTaskMapper{

   /**
@@ -24,6 +25,7 @@
    * @param callTask
    * @return
    */
   @DS("ztznwh")
   @InterceptorIgnore(tenantLine = "true")
   List<CallTaskStatistic> getCallListPage(@Param("page") IPage<CallTaskStatistic> page, @Param("callTask") CallTaskStatistic callTask);

@@ -31,7 +33,95 @@
    * 查询呼叫详情列表信息
    * @param callTaskResult
    * @param page
    * @param list
    * @param idsList
    * @return
    */
   List<CallTaskResultVO> getCallTaskResultListPage(@Param("page") IPage<CallTaskResultVO> page,@Param("callTaskResult") CallTaskResultVO callTaskResult);
   @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);
}