| | |
| | | "<if test='vaccinesByAdminDTO.phone != null and vaccinesByAdminDTO.phone != ""'>" + |
| | | " and cmver.phone = #{vaccinesByAdminDTO.phone} "+ |
| | | " </if> " + |
| | | "<if test='vaccinesByAdminDTO.startTime != null '>\n" + |
| | | "<if test='vaccinesByAdminDTO.startTime != null and vaccinesByAdminDTO.startTime != "" '>\n" + |
| | | " AND cmver.create_at <![CDATA[>=]]> #{vaccinesByAdminDTO.startTime} \n" + |
| | | "</if>" + |
| | | "<if test='vaccinesByAdminDTO.endTime != null '>\n" + |
| | | "<if test='vaccinesByAdminDTO.endTime != null and vaccinesByAdminDTO.endTime != "" '>\n" + |
| | | " AND cmver.create_at <![CDATA[<=]]> #{vaccinesByAdminDTO.endTime} " + |
| | | " </if> \n" + |
| | | " </where>" + |
| | |
| | | "<if test='vaccinesByAdminDTO.phone != null and vaccinesByAdminDTO.phone != ""'>" + |
| | | " and cmver.phone = #{vaccinesByAdminDTO.phone} "+ |
| | | " </if> " + |
| | | "<if test='vaccinesByAdminDTO.startTime != null '>\n" + |
| | | "<if test='vaccinesByAdminDTO.startTime != null and vaccinesByAdminDTO.startTime != "" '>\n" + |
| | | " AND cmver.create_at <![CDATA[>=]]> #{vaccinesByAdminDTO.startTime} \n" + |
| | | "</if>" + |
| | | "<if test='vaccinesByAdminDTO.endTime != null '>\n" + |
| | | "<if test='vaccinesByAdminDTO.endTime != null and vaccinesByAdminDTO.endTime != "" '>\n" + |
| | | " AND cmver.create_at <![CDATA[<=]]> #{vaccinesByAdminDTO.endTime} " + |
| | | " </if> \n" + |
| | | " </where>" + |