| | |
| | | where find_in_set(#{inviteId}, fee_profit_ids) |
| | | </select> |
| | | |
| | | <!-- where find_in_set(#{record.inviteId}, a.fee_profit_ids)--> |
| | | <select id="selectTeamListInPage" resultType="cc.mrbird.febs.dapp.vo.TeamListVo"> |
| | | select |
| | | concat(left(a.address,5), '******', right(a.address,5)) address, |
| | |
| | | (select ifnull(sum(c.balance),0) from dapp_member c where find_in_set(a.invite_id, c.fee_profit_ids) |
| | | ) coinCount |
| | | from dapp_member a |
| | | where find_in_set(#{record.inviteId}, a.fee_profit_ids) |
| | | where a.referer_id=#{record.inviteId} |
| | | </select> |
| | | |
| | | <select id="selectMakerAddress" resultType="cc.mrbird.febs.dapp.entity.DappMemberEntity"> |