我在报表头部添加了一个根据时间查找的按钮。

但是现在sql无法进行查找。

select pro_project.name as proName,

pro_user.name as userName,

pro_project.stage_status as stageStatus,

FROM_UNIXTIME(pro_project_appraisal.time,"%Y-%m-%d") as appraisalDate,

pro_project_appraisal.* 

from pro_project_appraisal

join pro_project on pro_project_appraisal.pid=pro_project.id

join pro_user on pro_project_appraisal.uid=pro_user.id

where pro_project.status=1 

${if(len(timeDQ)==0,""," and pro_project_appraisal.time between '"+UNIX_TIMESTAMP(timeDQ)+"' and '"+(UNIX_TIMESTAMP(timeDQ)+86399)+"'")}

and pro_project_appraisal.status!=0

${if(len(userID)==0,"", " and pro_user.id='"+userID+"'")}

一直提示我

${if(len(timeDQ)==0,""," and pro_project_appraisal.time between '"+UNIX_TIMESTAMP(timeDQ)+"' and '"+(UNIX_TIMESTAMP(timeDQ)+86399)+"'")}

这一行语法错误。

麻烦哪位大佬给点意见或者建议