<if test="param.startTime !=null and param.startTime.trim() != '' and param.endTime!=null and param.endTime.trim() != '' ">
and date_format(wa.date_in,'%Y-%m-%d') BETWEEN #{param.startTime} AND #{param.endTime}
</if>
<if test="param.startTime !=null and param.startTime.trim() != '' and param.endTime!=null and param.endTime.trim() != '' ">
and date_format(wa.date_out,'%Y-%m-%d') BETWEEN #{param.startTime} AND #{param.endTime}
</if>