通话任务查询修改

zhongrj

2023-04-27 f7a913c9fe3a19c0f43575a8dfb369b83e67b3bb

通话任务查询修改

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

@@ -7,11 +7,11 @@
        select
        ct."id",
        ct."task_name" as taskName,
        ct."gmt_create" as createTime,
        date_format(ct."gmt_create",'yyyy-MM-dd HH:mm:ss') as createTime,
        ct."task_status" as taskStatus,
        ctr."calling_number" as callingNumber,
        ctr."callee_number" as calleeNumber,
        ctr."gmt_create" as executeTime,
        date_format(ctr."gmt_create",'yyyy-MM-dd HH:mm:ss') as executeTime,
        ctra."callee_number_count" as calleeNumberCount,
        ctra."connection_count" as connectionCount,
        ctra."failure_count" as failureCount,
@@ -46,7 +46,7 @@
        ctr."call_conversation_round" as callConversationRound,
        ctr."call_hangup_direction" as callHangupDirection,
        ctr."call_id" as callId,
        ctr."gmt_create" as gmtCreate,
        date_format(ctr."gmt_create",'yyyy-MM-dd HH:mm:ss') as gmtCreate,
        ctr."calling_number" as callingNumber,
        ctr."callee_number" as calleeNumber,
        ctr."task_id" as taskId,