searchSmsChannel
===
*查询短信渠道下发量
SELECT @pageTag(){
	a.spnumber as spnumber,b.channelname as channelname,a.smsnum as smsnum,a.successnum as successnum,a.failnum  as failnum,CONCAT(ROUND(a.successnum/a.smsnum*100,2),'%') as cgrate
 @} 
	from td_sms_count_log a,tb_channel_info b 
	where a.spnumber=b.channelcode and 1=1
	  @if(!isEmpty(starttime)){
	  	and DATE_FORMAT(id,'%Y-%m-%d') >= #starttime#
	  @}
	  @if(!isEmpty(endtime)){
	  	and DATE_FORMAT(id,'%Y-%m-%d') <= #endtime# 
	  @} 
	  