| | |
|---|
| | | @Select("select m.* from sys_user u join com_pb_member m on u.id_card=m.id_card where u.user_id=#{userId}") |
|---|
| | | ComPbMemberDO selectByUserId(Long userId); |
|---|
| | | |
|---|
| | | @Select("SELECT\n" + |
|---|
| | | "m.* \n" + |
|---|
| | | "FROM\n" + |
|---|
| | | "com_pb_member m\n" + |
|---|
| | | "JOIN sys_user u ON m.id_card = u.id_card \n" + |
|---|
| | | "LEFT JOIN com_pb_member_role r on m.id=r.member_id \n" + |
|---|
| | | "WHERE\n" + |
|---|
| | | "m.community_id =#{communityId} and r.id is null ") |
|---|
| | | List<ComPbMemberDO> selectListRegister(Long communityId); |
|---|
| | | @Select("select name from sys_user where user_id=#{createBy}") |
|---|
| | | String selectNameByUserId(Long createBy); |
|---|
| | | @Update("update sys_user u set u.is_partymember=0 where u.id_card=#{idCard}") |
|---|
