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