| | |
| | | * 提现金额 |
| | | */ |
| | | private BigDecimal amount; |
| | | private BigDecimal amountUSDT; |
| | | private BigDecimal fee; |
| | | /** |
| | | * 1:内转 2:外转提现 |
| | |
| | | b.phone phone, |
| | | a.id id, |
| | | (a.amount - a.fee) amount, |
| | | CASE |
| | | WHEN a.type = 1 THEN NULL |
| | | ELSE |
| | | FORMAT( |
| | | (a.amount - a.fee) / ( SELECT VALUE FROM data_dictionary WHERE type = 'USDT_TIME' AND CODE = 'USDT_TIME' ), |
| | | 2 |
| | | ) |
| | | END AS amountUSDT, |
| | | a.type type, |
| | | a.address address, |
| | | a.address_type addressType, |
| | |
| | | {field: 'id', title: '', minWidth: 150,align:'center', totalRowText: '合计:',align:'center'}, |
| | | {field: 'phone', title: '电话号码', minWidth: 150,align:'center'}, |
| | | {field: 'nickName', title: '昵称', minWidth: 150,align:'center'}, |
| | | {field: 'amount', title: '人民币金额', minWidth: 100,align:'center',align:'center',totalRow: '{{= parseInt(d.amount) }}'}, |
| | | {field: 'addressType', title: '公链', minWidth: 150,align:'center'}, |
| | | {field: 'amount', title: '金额', minWidth: 100,align:'center',align:'center',totalRow: '{{= parseInt(d.amount) }}'}, |
| | | {field: 'amountUSDT', title: 'USDT金额', minWidth: 100,align:'center',align:'center',totalRow: '{{= parseInt(d.amountUSDT) }}'}, |
| | | {field: 'type', title: '类型', |
| | | templet: function (d) { |
| | | if (d.type === 1) { |