queryListInfos
===
select 
@pageTag(){
*,CONCAT(ROUND(IFNULL(((b.level1ratio+b.level2ratio+b.level3ratio)/3),0),1),'%') as pjzhl
 @}
 from (select
a.datestr,a.productid,a.productname,a.funneltypename,a.orderpv,a.orderuv,a.cappv,a.capuv,a.ordertimes,a.ordercnt,
CONCAT(ROUND(IFNULL(a.ordercnt/a.ordertimes,'0')*100,1),'%') as cgl,
CONCAT(IFNULL(ROUND(a.capuv/a.orderuv*100,1),0),'%') as level1ratio, 
CONCAT(IFNULL(ROUND(a.ordertimes/a.capuv*100,1),0),'%') as level2ratio, CONCAT(IFNULL(ROUND(a.ordercnt/a.ordertimes*100,1),0),'%') as level3ratio
 from (
select productid,productname,funneltypename,IFNULL(SUM(Orderpv),0) as orderpv,IFNULL(SUM(Orderuv),0) as orderuv,IFNULL(SUM(cappv),0) as cappv,
IFNULL(SUM(capuv),0) as capuv,IFNULL(SUM(ordertimes),0) as ordertimes,IFNULL(SUM(ordercnt),0) as ordercnt
@if(!isEmpty(countDate) && countDate == '1'){
	, datestr
@}
@if(isEmpty(countDate) || countDate == '0'){
	,CONCAT(#startdate#,'-',#enddate# ) as datestr
@}

 from tr_funnel_data where 1=1 and DATE_FORMAT(DATESTR,'%Y-%m-%d') BETWEEN #startdate# and #enddate# 
@if(!isEmpty(productname)){
	  and productname = #productname#
@}
@if(!isEmpty(funneltypename)){
	  and funneltypename = #funneltypename#
@}
 GROUP BY productname,funneltypename 
@if(!isEmpty(countDate) && countDate == '1'){
	, DATESTR
@}
) as a  ORDER BY a.DATESTR DESC,a.orderpv desc) as b



findAllFunnelProduct
===
select productname from tr_funnel_data GROUP BY productname


findAllFunnelTypename
===
select funneltypename from tr_funnel_data GROUP BY funneltypename