智能外呼导出查询修改

zhongrj

2023-05-05 cc1efbaded12b76f39699911ba0f032d14e8d24e

智能外呼导出查询修改

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

@@ -28,10 +28,10 @@
            and ct."task_status" = #{callTask.taskStatus}
        </if>
        <if test="callTask.startTime!=null and callTask.startTime!=''">
            and date_format(ct."gmt_create",'%Y-%m-%d') >= #{callTask.startTime}
            and date_format(ct."task_schedule_time",'%Y-%m-%d') >= #{callTask.startTime}
        </if>
        <if test="callTask.endTime!=null and callTask.endTime!=''">
            and date_format(ct."gmt_create",'%Y-%m-%d') &lt;= #{callTask.endTime}
            and date_format(ct."task_schedule_time",'%Y-%m-%d') &lt;= #{callTask.endTime}
        </if>
        order by ct."gmt_create" desc
    </select>
@@ -88,6 +88,7 @@
        GROUP BY ctra."call_id"
        ) cas
        on cas."call_id" = ctr."call_id"
        left join "SJZT_ODS"."call_task" ct on ct."id" = ctr."task_id"
        where 1=1
        <if test="callTaskResult.taskId!=null and callTaskResult.taskId!=''">
            and ctr."task_id" = #{callTaskResult.taskId}
@@ -104,6 +105,12 @@
        <if test="callTaskResult.userName!=null and callTaskResult.userName!=''">
            and ctc.userName like concat('%',#{callTaskResult.userName},'%')
        </if>
        <if test="callTaskResult.taskName!=null and callTaskResult.taskName!=''">
            and ct."task_name" like concat(concat('%',#{callTaskResult.taskName}),'%')
        </if>
        <if test="callTaskResult.taskStatus!=null">
            and ct."task_status" = #{callTaskResult.taskStatus}
        </if>
        <if test="callTaskResult.startTime!=null and callTaskResult.startTime!=''">
            and date_format(ctr."gmt_create",'%Y-%m-%d') >= #{callTaskResult.startTime}
        </if>

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

@@ -93,5 +93,15 @@
     */
    private String isDange;

    /**
     * 任务名称
     */
    private String taskName;

    /**
     * 任务状态 0：未执行  1：执行中  2：已取消 3：已终止  4：已完成
     */
    private Integer taskStatus;


}