| | |
| | | com_sw_rota csr |
| | | where csr.community_id = #{comSwRotaPageDTO.communityId} |
| | | <if test='comSwRotaPageDTO.rotaPerson != null and comSwRotaPageDTO.rotaPerson != ""'> |
| | | AND (csr.rota_person LIKE concat('%',#{comSwRotaPageDTO.rotaPerson},'%') |
| | | or csr.rota_leader LIKE concat('%',#{comSwRotaPageDTO.rotaPerson},'%') |
| | | AND (csr.leader_name LIKE concat('%',#{comSwRotaPageDTO.rotaPerson},'%') |
| | | or csr.person_name LIKE concat('%',#{comSwRotaPageDTO.rotaPerson},'%') |
| | | ) |
| | | </if> |
| | | <if test='comSwRotaPageDTO.phone != null and comSwRotaPageDTO.phone != ""'> |