1.为当周,2当月,3自定义
if(state==1){
str="attend_time BETWEEN SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),'%w')-1) AND SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),'%w')-7)";
}else if(state==2){
str="date_format(attend_time,'%Y-%m')=date_format(now(),'%Y-%m') ";
}else if(state==3){
str="attend_time>='"+startTime+"' and attend_time<='"+endTime+"'";
}
if(state==1){
str="attend_time BETWEEN SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),'%w')-1) AND SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),'%w')-7)";
}else if(state==2){
str="date_format(attend_time,'%Y-%m')=date_format(now(),'%Y-%m') ";
}else if(state==3){
str="attend_time>='"+startTime+"' and attend_time<='"+endTime+"'";
}