| | |
| | | and m.community_id = ${dto.communityId} |
| | | </if> |
| | | <if test="dto.keyWord != null and dto.keyWord != ''"> |
| | | and (m.name like concat (#{dto.keyWord},'%') or |
| | | m.phone like concat (#{dto.keyWord},'%') or |
| | | cpcu.name like concat (#{dto.keyWord},'%') or o.name like concat (#{dto.keyWord},'%') |
| | | and (m.name like concat ('%',#{dto.keyWord},'%') or |
| | | m.phone like concat ('%',#{dto.keyWord},'%') or |
| | | cpcu.name like concat ('%',#{dto.keyWord},'%') or ca.name like concat ('%',#{dto.keyWord},'%') |
| | | ) |
| | | </if> |
| | | <if test="dto.type != null"> |