| | |
|---|
| | | select user_id,IFNULL(`name`,nick_name) as `name` from sys_user where `type` = 1 AND phone in (select DISTINCT(telephone) from com_act_social_worker where community_id = ${communityId}) and status = 1 |
|---|
| | | </if> |
|---|
| | | <if test="type != null and type == 5"> |
|---|
| | | select user_id,IFNULL(`name`,nick_name) as `name` from sys_user where type` = 1 AND id_card in (select id_card from com_act_four_member where community_id = ${communityId}) and status = 1 |
|---|
| | | select user_id,IFNULL(`name`,nick_name) as `name` from sys_user where `type` = 1 AND id_card in (select id_card from com_act_four_member where community_id = ${communityId}) and status = 1 |
|---|
| | | </if> |
|---|
| | | </select> |
|---|
| | | |
|---|
