日期范围查询
<if test="optometryTimeStart != null and optometryTimeStart != ''">
AND a.VISIT_DATE <![CDATA[>=]]> STR_TO_DATE(#{optometryTimeStart},'%Y-%m-%d')
</if>
<if test="optometryTimeEnd != null and optometryTimeEnd != ''">
AND a.VISIT_DATE <![CDATA[<=]]> STR_TO_DATE(#{optometryTimeEnd},'%Y-%m-%d')
</if><if test="optometryTimeStart != null a
