xiaoyong931011
2023-05-11 19bb8923067177c1e6b5d21320b61b4e30201230
支付设置
3 files modified
10 ■■■■■ changed files
src/main/java/cc/mrbird/febs/mall/entity/MallMember.java 3 ●●●●● patch | view | raw | blame | history
src/main/resources/mapper/modules/MallMemberMapper.xml 6 ●●●●● patch | view | raw | blame | history
src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html 1 ●●●● patch | view | raw | blame | history
src/main/java/cc/mrbird/febs/mall/entity/MallMember.java
@@ -156,6 +156,9 @@
     */
    @TableField(exist = false)
    private BigDecimal voucherCnt;
    @TableField(exist = false)
    private BigDecimal voucherCntSurplus;
    /**
     * 凭证现金
     */
src/main/resources/mapper/modules/MallMemberMapper.xml
@@ -15,6 +15,12 @@
               IFNULL(c.voucher_cnt,0) voucherCnt,
               IFNULL(c.voucher_amount,0) voucherAmount,
               IFNULL(c.voucher_fire_cnt,0) voucherFireCnt,
                (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
src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html
@@ -303,6 +303,7 @@
                    {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'},