| | |
|---|
| | | image_url, |
|---|
| | | `type`, |
|---|
| | | job, |
|---|
| | | is_volunteer, |
|---|
| | | is_partymember, |
|---|
| | | status, |
|---|
| | | create_at, |
|---|
| | | last_login_time, |
|---|
| | | tags, |
|---|
| | | family_id, |
|---|
| | | face_url, |
|---|
| | | face_state, |
|---|
| | | reject_reson, |
|---|
| | | area_id, |
|---|
| | | card_photo_front, |
|---|
| | | card_photo_back, |
|---|
| | | family_book, |
|---|
| | | continuous_landing_days, |
|---|
| | | is_tips, |
|---|
| | | work_status, |
|---|
| | | work_start_time, |
|---|
| | | work_end_time, |
|---|
| | | big_age_tips, |
|---|
| | | street_id, |
|---|
| | | relation_name, |
|---|
| | | app_id, |
|---|
| | | is_accept, |
|---|
| | | binding_check_unit_id, |
|---|
| | | love_integral |
|---|
| | | status |
|---|
| | | from sys_user |
|---|
| | | <where> |
|---|
| | | community_id=#{communityId} |
|---|
| | | community_id=#{communityId} and status=1 |
|---|
| | | <if test="nameAndPhone !=null and nameAndPhone!='' "> |
|---|
| | | and `name` LIKE CONCAT('%', #{nameAndPhone}, '%') |
|---|
| | | or nick_name LIKE CONCAT('%', #{nameAndPhone}, '%') |
|---|
