| | |
| | | private String address; |
| | | |
| | | @TableField(exist = false) |
| | | private Integer teamAddressCnt; |
| | | |
| | | @TableField(exist = false) |
| | | private String addressCnt; |
| | | } |
| | |
| | | a.address, |
| | | a.invite_id, |
| | | (select count(1) from dapp_member x where a.invite_id=x.referer_id) addressCnt, |
| | | count(1) teamAddressCnt, |
| | | IFNULL(sum(c.coin_amount),0) coinAmount, |
| | | IFNULL(sum(c.usdt_amount),0) usdtAmount |
| | | from dapp_member a |
| | |
| | | cols: [[ |
| | | {field: 'address', title: '地址', minWidth: 200}, |
| | | {field: 'addressCnt', title: '直属地址数', minWidth: 50}, |
| | | {field: 'teamAddressCnt', title: '团队地址数', minWidth: 50}, |
| | | {field: 'usdtAmount', title: '团队USDT业绩', minWidth: 50}, |
| | | {field: 'coinAmount', title: '团队SDC', minWidth: 50} |
| | | ]] |