${
IF(DAY(endtime)>7,
"

select 
 createtime
from table  a 
where  
and a.createtime between '"+开始时间+"' and '"+结束时间+"'
"+if(len(type)=0,'','and a.type = '+type+'')+" 
"+if(len(name)=0,'','and a.name like "%'+name+'%"')+" 
"+if(len(dqname)=0,'','and a.dqname in ("'+dqname+'")')+" 
"+if(len(customername)=0,'','and a.customername like "%'+customername+'%"')+" 

",
"

select 
 createtime
from table  a 
where  
and a.createtime between '"+开始时间+"' and '"+结束时间+"'
"+if(len(type)=0,'','and a.type = '+type+'')+" 
"+if(len(name)=0,'','and a.name like "%'+name+'%"')+" 
"+if(len(dqname)=0,'','and a.dqname in ("'+dqname+'")')+" 
"+if(len(customername)=0,'','and a.customername like "%'+customername+'%"')+" 

")}

select  * from aaa where 1=1

${if(len(aa) == 0,"","and sto.up_store_code in ('" + aa + "')")}

${if(aa == 1,"and substr(a.pay_time ,1,10)>=('" + start_time + "') and

substr(a.pay_time ,1,10)<=('" + end_time + "')","and substr(a.pay_time ,1,7)>=('" + start_time + "') and

substr(a.pay_time ,1,7)<=('" + end_time + "')")}