| | |
| | | |
| | | |
| | | <where> |
| | | service_medicalevaluation.del_flag != 1 |
| | | <if test="name != null and name != ''"> and `service_donatebaseinfo`.Name like concat('%', #{name}, '%')</if> |
| | | <if test="donorno != null and donorno != ''"> and `service_donatebaseinfo`.`DonorNo` = #{donorno}</if> |
| | | <if test="idcardno != null and idcardno != ''"> and `service_donatebaseinfo`.`IDCardNo` = #{idcardno}</if> |
| | |
| | | <if test="endtime != null "> and `service_medicalevaluation`.CoreTeamAssessTime <= #{endtime}</if> |
| | | <if test="reporterno != null and reporterno != ''"> and `service_donatebaseinfo`.ReporterNo = #{reporterno}</if> |
| | | <if test="city != null and city != ''"> and `base_organization`.`City` = #{city}</if> |
| | | service_medicalevaluation.del_flag != 1 |
| | | </where> |
| | | |
| | | order by `service_medicalevaluation`.`create_time` desc, |