智能外呼查询详情列表查询修改

zhongrj

2023-04-25 b0f0485006b394cecc2e2441d0c10bd87a0be7d6

智能外呼查询详情列表查询修改

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/controller/CallController.java

@@ -1,9 +1,9 @@
package cn.gistack.sm.intelligentCall.controller;

import cn.gistack.sm.intelligentCall.entity.CallTask;
import cn.gistack.sm.intelligentCall.entity.CallTaskResult;
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.intelligentCall.vo.CallTaskVO;
import io.swagger.annotations.Api;
import lombok.AllArgsConstructor;
import lombok.extern.slf4j.Slf4j;
@@ -61,4 +61,17 @@
        return R.data(callService.getCallListPage(Condition.getPage(query),callTask));
    }


    /**
     * 查询呼叫详情列表信息
     * @param callTaskResult
     * @param query
     * @return
     */
    @GetMapping("/getCallTaskResultListPage")
    public R getCallTaskResultListPage(CallTaskResultVO callTaskResult, Query query){
        // 返回
        return R.data(callService.getCallTaskResultListPage(Condition.getPage(query),callTaskResult));
    }

}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/entity/CallTask.java

@@ -11,4 +11,6 @@
 */
@Data
public class CallTask implements Serializable {

    private static final long serialVersionUID = 1L;
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/entity/CallTaskResult.java

New file
@@ -0,0 +1,90 @@
package cn.gistack.sm.intelligentCall.entity;

import lombok.Data;

import java.io.Serializable;

/**
 * 呼叫结果
 * @author zhongrj
 * @date 2023-04-25
 */
@Data
public class CallTaskResult implements Serializable {


    private static final long serialVersionUID = 1L;

    /**
     * 主键id
     */
    private String id;

    /**
     *呼叫结果
     */
    private String callResult;

    /**
     * 通话时长
     */
    private String callDuration;

    /**
     * 对话轮次
     */
    private String callConversationRound;

    /**
     * 挂断方向 A机器B用户
     */
    private String callHangupDirection;

    /**
     * 呼叫id
     */
    private String callId;

    /**
     * 创建时间
     */
    private String gmtCreate;

    /**
     * 主叫号码
     */
    private String callingNumber;

    /**
     * 被叫号码
     */
    private String calleeNumber;
    /**
     * 任务ID
     */
    private String taskId;
    /**
     * 通话开始时间
     */
    private String callStartTime;
    /**
     * 通话结束时间
     */
    private String callEndTime;

    /**
     * 录音文件url
     */
    private String callRecordFile;

    /**
     * 意向客户标记
     */
    private String intentionCustomerFlag;

    /**
     * 删除标记 0 删除 1未删除
     */
    private Integer isDeleted;

}

 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.vo.CallTaskResultVO;
import cn.gistack.sm.intelligentCall.vo.CallTaskStatistic;
import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
@@ -25,4 +26,12 @@
     */
    @InterceptorIgnore(tenantLine = "true")
    List<CallTaskStatistic> getCallListPage(@Param("page") IPage<CallTaskStatistic> page, @Param("callTask") CallTaskStatistic callTask);

    /**
     * 查询呼叫详情列表信息
     * @param callTaskResult
     * @param page
     * @return
     */
    List<CallTaskResultVO> getCallTaskResultListPage(@Param("page") IPage<CallTaskResultVO> page,@Param("callTaskResult") CallTaskResultVO callTaskResult);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/mapper/CallTaskMapper.xml

@@ -2,6 +2,7 @@
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.gistack.sm.intelligentCall.mapper.CallTaskMapper">

    <!--查詢任务列表数据-->
    <select id="getCallListPage" resultType="cn.gistack.sm.intelligentCall.vo.CallTaskStatistic">
        select
        ct."id",
@@ -35,4 +36,27 @@
        </if>
        order by ct."gmt_create" desc
    </select>

    <!--查询呼叫详情列表信息-->
    <select id="getCallTaskResultListPage" resultType="cn.gistack.sm.intelligentCall.vo.CallTaskResultVO">
        select
        ctr."id",
        ctr."call_result" as callResult,
        ctr."call_duration" as callDuration,
        ctr."call_conversation_round" as callConversationRound,
        ctr."call_hangup_direction" as callHangupDirection,
        ctr."call_id" as callId,
        ctr."gmt_create" as gmtCreate,
        ctr."calling_number" as callingNumber,
        ctr."callee_number" as calleeNumber,
        ctr."task_id" as taskId,
        ctr."call_start_time" as callStartTime,
        ctr."call_end_time" as callEndTime,
        ctr."call_record_file" as callRecordFile,
        ctr."intention_customer_flag" as intentionCustomerFlag,
        ctr."is_deleted" as isDeleted
        from "SJZT_ODS"."call_task_result" ctr
        where 1=1
        order by ctr."gmt_create" desc
    </select>
</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/service/CallService.java

@@ -1,9 +1,8 @@
package cn.gistack.sm.intelligentCall.service;


import cn.gistack.sm.intelligentCall.entity.CallTask;
import cn.gistack.sm.intelligentCall.vo.CallTaskResultVO;
import cn.gistack.sm.intelligentCall.vo.CallTaskStatistic;
import cn.gistack.sm.intelligentCall.vo.CallTaskVO;
import com.baomidou.mybatisplus.core.metadata.IPage;

import java.util.List;
@@ -33,4 +32,12 @@
     * @return
     */
    IPage<CallTaskStatistic> getCallListPage(IPage<CallTaskStatistic> page, CallTaskStatistic callTask);

    /**
     * 查询呼叫详情列表信息
     * @param callTaskResult
     * @param page
     * @return
     */
    IPage<CallTaskResultVO> getCallTaskResultListPage(IPage<CallTaskResultVO> page, CallTaskResultVO callTaskResult);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/service/impl/CallServiceImpl.java

@@ -3,8 +3,8 @@
import cn.gistack.sm.intelligentCall.constant.CallConstant;
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.intelligentCall.vo.CallTaskVO;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.dynamic.datasource.annotation.DS;
@@ -199,4 +199,15 @@
    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) {
        return page.setRecords(callTaskMapper.getCallTaskResultListPage(page,callTaskResult));
    }
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/vo/CallTaskResultVO.java

File was renamed from skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/intelligentCall/vo/CallTaskVO.java
@@ -1,6 +1,7 @@
package cn.gistack.sm.intelligentCall.vo;

import cn.gistack.sm.intelligentCall.entity.CallTask;
import cn.gistack.sm.intelligentCall.entity.CallTaskResult;
import lombok.Data;

/**
@@ -9,7 +10,7 @@
 * @date 2023-04-25
 */
@Data
public class CallTaskVO extends CallTask {
public class CallTaskResultVO extends CallTaskResult {

    /**
     * 任务名称