SELECT * FROM dbo.VIEW_EMPLOYEE_INFO where 1=1
${if((dismiss == true) && len(dismiss)>0,
"AND (dismissal_time < convert(varchar(10),getdate(),120) or staff_status ='7')",
if((dismiss == false)&& len(dismiss)>0,"AND (dismissal_time >= convert(varchar(10),getdate(),120) or staff_status = '11')",if(len(dismiss)=0,"")))}