| | |
| | | */ |
| | | @TableField(exist = false) |
| | | private BigDecimal voucherCnt; |
| | | |
| | | @TableField(exist = false) |
| | | private BigDecimal voucherCntSurplus; |
| | | /** |
| | | * 凭证现金 |
| | | */ |
| | |
| | | IFNULL(c.voucher_cnt,0) voucherCnt, |
| | | IFNULL(c.voucher_amount,0) voucherAmount, |
| | | IFNULL(c.voucher_fire_cnt,0) voucherFireCnt, |
| | | d.description levelName |
| | | (SELECT |
| | | sum(IFNULL(surplus_cnt, 0)) |
| | | FROM |
| | | mall_score_record |
| | | WHERE |
| | | member_id = m.id) voucherCntSurplus, |
| | | d.description levelName |
| | | FROM mall_member m |
| | | left join mall_member a on m.referrer_id = a.invite_id |
| | | LEFT JOIN mall_member_wallet c on c.member_id = m.id |
| | |
| | | {field: 'star', title: '贡献点', minWidth: 100,align:'left',totalRow: '{{= parseInt(d.star) }}'}, |
| | | {field: 'totalScore', title: '补贴额度', minWidth: 100,align:'left',totalRow: '{{= parseInt(d.totalScore) }}'}, |
| | | {field: 'voucherCnt', title: '绿色凭证', minWidth: 100,align:'left',totalRow: '{{= parseInt(d.voucherCnt) }}'}, |
| | | {field: 'voucherCntSurplus', title: '待释放数量', minWidth: 100,align:'left',totalRow: '{{= parseInt(d.voucherCntSurplus) }}'}, |
| | | {field: 'voucherAmount', title: '凭证现金', minWidth: 100,align:'left',totalRow: '{{= parseInt(d.voucherAmount) }}'}, |
| | | {field: 'voucherFireCnt', title: '能量值', minWidth: 100,align:'left',totalRow: '{{= parseInt(d.voucherFireCnt) }}'}, |
| | | {field: 'referrerName', title: '推荐人', minWidth: 100,align:'left'}, |