外呼分页详情查询修改

zhongrj

2023-08-10 2041e74cac01fe1a33421bce829aa478a3ac44b2

外呼分页详情查询修改

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

@@ -92,7 +92,7 @@
        ) ctc
        on ctr."call_id" = ctc."call_id"
        left join "SJZT_MD"."att_res_base" arb on ctc.waterCode = arb."code"
        left join "SJZT_MD"."att_ad_base" aab on aab."guid" = concat(arb."ad_guid",'000000')
        left join "SJZT_MD"."att_ad_base" aab on aab."guid" = arb."interior_ad_guid"
        left join
        (
        SELECT ctra."call_id", replace(WM_CONCAT(ctag."tag_title"),',', ',') as "tag_title" from "SJZT_ODS"."call_tag" ctag
@@ -230,6 +230,7 @@
                        when ctc1."call_result"='200004' then 1
                        when ctc1."call_result"='200007' then 1
                        when ctc1."call_result"='200010' then 1
                        when ctc1."call_result"='200011' then 1
                        when ctc1."call_result"='200100' then 1
                        when ctc1."call_result"='200130' then 1
                        else 0 end),0) as threeNotConnectCount,
@@ -561,6 +562,7 @@
                        when ctc."call_result"='200004' then 1
                        when ctc."call_result"='200007' then 1
                        when ctc."call_result"='200010' then 1
                        when ctc."call_result"='200011' then 1
                        when ctc."call_result"='200100' then 1
                        when ctc."call_result"='200130' then 1
                        else 0 end),0) as threeNotConnectCount,