| | |
| | | </select> |
| | | |
| | | <select id="selectInPage" resultType="cc.mrbird.febs.dapp.entity.DappMemberEntity"> |
| | | select * from dapp_member |
| | | select * from dapp_member a |
| | | <where> |
| | | <if test="record.currentUser != null"> |
| | | and referer_id = (select invite_id from dapp_user_member_relate where user_id=#{record.currentUser}) |
| | | <!-- <if test="record.currentUser != null">--> |
| | | <!-- and referer_id = (select invite_id from dapp_user_member_relate where user_id=#{record.currentUser})--> |
| | | <!-- </if>--> |
| | | |
| | | <if test="record.description!=null and record.description!=''"> |
| | | and a.id in (select id from dapp_member where FIND_IN_SET(#{record.description}, referer_ids)) |
| | | </if> |
| | | <if test="record.accountStatus != null"> |
| | | and account_status = #{record.accountStatus} |
| | | and a.account_status = #{record.accountStatus} |
| | | </if> |
| | | <if test="record.changeAble != null"> |
| | | and change_able = #{record.changeAble} |
| | | and a.change_able = #{record.changeAble} |
| | | </if> |
| | | <if test="record.withdrawAble != null"> |
| | | and withdraw_able = #{record.withdrawAble} |
| | | and a.withdraw_able = #{record.withdrawAble} |
| | | </if> |
| | | <if test="record.inviteId != null and record.inviteId != ''"> |
| | | and invite_id = #{record.inviteId} |
| | | and a.invite_id = #{record.inviteId} |
| | | </if> |
| | | </where> |
| | | order by create_time desc |