接通率查询修改调整

zhongrj

2023-05-15 5111f792a2094400dadd67292117c28d3e410276

接通率查询修改调整

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

@@ -210,7 +210,12 @@
                </if>
                group by DATE_FORMAT(ctr."gmt_create",'%Y-%m-%d'),aab."ad_name",aab."guid",aab."ad_grad",aab."p_ad_code"
            ) a
            on aab."guid" = a."p_ad_code" where aab."p_ad_code" = #{callTaskStatistic.adCode}
            <if test="callTaskStatistic.grad==1">
                on aab."guid" = a."p_ad_code" where aab."p_ad_code" = #{callTaskStatistic.adCode}
            </if>
            <if test="callTaskStatistic.grad==2">
                on aab."guid" = a."guid" where aab."p_ad_code" = #{callTaskStatistic.adCode}
            </if>
            group by aab."ad_name",aab."guid"
            order by aab."guid"
        ) b

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

@@ -115,4 +115,10 @@
    private String adCode;


    /**
     * 区域级别 1:省级 2：市级
     */
    private Integer grad;


}