qimall/backend/modules/mall/views/finance/balance-log.php

<?php

/**
 * @link:http://www.goodmall.com/
 * @copyright: Copyright (c) 2020
 *
 * Author: james
 * Date: 2020-08-09
 * Time: 09:20
 */

use common\helpers\ComponentHelper;

ComponentHelper::loadComponentView('com-export-dialog', '@backend/views/components/common');
?>
<style>
    .order_stat{
    background: #FFF;
    padding: 10px 10px 0;
    margin-bottom: 10px;
}

.title{
    font-size: 18px;
    font-weight: bold;
    display: flex;
    align-items: center;
    height: 40px;
	display: flex;
	justify-content: space-between;
}

.order_stat > .title > .time{
    font-size: 13px;
    font-weight: 400;
    color: #BFBFBF;
    margin-left: 20px;
    flex: 1;
}

.order_stat .stat_details{
    padding: 30px 0;
    display: flex;
}
    .default-avatar{
        width: 50px;
        height: 50px;
        border-radius: 50%;
        margin-right: 8px;
    }
    .uer-nickname {
        flex: 1;
    }

    .user_img{
        position: relative;
        margin-right: 8px;
        /* height: 50px;
        width: 50px; */
    }
    .search_button{
        margin-right: 20px;
    }
</style>
<div id="app" v-cloak>
    <div class="order_stat">
        <div class="title">
			<span>余额明细</span>
			<com-export-dialog :field_list='exportList' :action_url="export_url" :params="searchData" @selected="exportConfirm"></com-export-dialog>
		</div>

            <div class="stat_details">
                <div class="order_module" v-for="(item,index) in orderTotalArr" :key="item.type">
                    <div class="oirder_modul_title">
                        <div class="text">{{item.name}}</div>
                        <el-tooltip class="item" effect="dark" v-if="item.prompt" :content="item.prompt" placement="bottom">
                            <i class="el-icon-question stat_icon"></i>
                        </el-tooltip>
                    </div>
                    <div class="price">
                        {{item.value}}
                    </div>
                </div>

        </div>
    </div>
        <el-card shadow="never" style="border:0;min-width: 800px;">
            <template>
                <el-tabs v-model="actionName" type="card" @tab-click="change_tab">
                    <el-tab-pane label="已结算" name="settlement">
                    </el-tab-pane>
                    <el-tab-pane label="未结算" name="noSettlement">
                    </el-tab-pane>
                </el-tabs>
            </template>
            <div class="input-item">
                <el-input @keyup.enter.native="search" size="small" placeholder="请输入会员id" v-model="searchData.user_id" clearable>
                </el-input>
            </div>
            <div class="input-item">
                <el-input @keyup.enter.native="search" size="small" placeholder="会员昵称/手机号" v-model="searchData.keyword" clearable>

                </el-input>
            </div>
            <div class="input-item">
                <el-input @keyup.enter.native="search" size="small" placeholder="请输入订单号" v-model="searchData.order_no" clearable>

                </el-input>
            </div>

            <el-date-picker size="small" style="margin-top: 1px; float: left"  @change="selectDateTime" v-model="searchData.date" type="datetimerange" value-format="yyyy-MM-dd HH:mm:ss" range-separator="至" start-placeholder="开始日期" end-placeholder="结束日期" :default-time="['00:00:00', '23:59:59']"></el-date-picker>

            <div class="input-item">
                <el-input @keyup.enter.native="search" size="small" placeholder="备注" v-model="searchData.remark" clearable>
                </el-input>
            </div>
            <el-select size="small" v-model="searchData.balance_from_type" @change='search' class="select">
                <el-option key="all" label="业务类型" value=""></el-option>
                <el-option :key="index" :label="item" :value="index" v-for="(item, index) in incomeCapitalTypeList"></el-option>
            </el-select>
            <div class="input-item">
                <el-button type="primary" size="small" icon="el-icon-search" @click="search" class="search_button">搜索</el-button>
                <com-export-dialog :field_list='exportList' :action_url="export_url" :params="searchData" @selected="exportConfirm"></com-export-dialog>
            </div>

            <el-table :data="form" stripe style="width: 100%" v-loading="listLoading">

                <el-table-column prop="user_id" label="会员ID" min-width="100" align="center"></el-table-column>
                <el-table-column label="会员" width="200">
                    <template slot-scope="scope">
                        <div class="table-info-img-text">
                            <el-image class="table-info-img circle" :src="scope.row.avatar_url">
                                <div slot="error" class="image-slot">
                                    <com-image src="/resources/img/common/default-avatar.png"></com-image>
                                </div>
                            </el-image>
                            <div class="table-info-text">
                                <div v-if="scope.row.nickname">{{scope.row.nickname}}</div>
                                <div>{{scope.row.mobile}}</div>
                            </div>
                        </div>
                    </template>
                </el-table-column>
                <el-table-column prop="source_text" v-model="searchData.balance_from_type" min-width="100" label="业务类型" align="center">
                    <template slot-scope="scope">
                        <div v-if="scope.row.source_text">{{scope.row.source_text}}</div>
                        <div v-else>--</div>
                    </template>
                </el-table-column>
                <el-table-column label="收入/支出" min-width="180" align="center">
                    <template slot-scope="scope">
                        <div style="font-size: 18px;" :style="{color: scope.row.change_type == 'add' ? '#68CF3D' : scope.row.change_type == 'sub' ? '#F6AA5A' : ''}">
                            {{scope.row.change_type == 'add' ? '+' : scope.row.change_type == 'sub' ? '-' : ''}}
                            {{scope.row.change_num}}
                        </div>
                    </template>
                </el-table-column>

                <el-table-column prop="current_num" label="变动前余额" min-width="200" align="center"></el-table-column>
                <el-table-column prop="current_num" label="变动后余额" min-width="150" align="center">
                    <template slot-scope="scope">
                        <div v-if="scope.row.change_type == 'add'">{{(scope.row.current_num + scope.row.change_num).toFixed(2)}}</div>
                        <div v-if="scope.row.change_type == 'sub'">{{(scope.row.current_num - scope.row.change_num).toFixed(2)}}</div>
                    </template>
                </el-table-column>
                <el-table-column prop="desc" label="备注" min-width="300" align="left"></el-table-column>
                <el-table-column prop="created_at" min-width="200" label="创建时间" align="center"></el-table-column>

                <!--                <el-table-column label="备注" align="center" min-width="300">-->
                <!--                    <template slot-scope="scope">-->
                <!--                        <div flex="box:first" v-if="scope.row.info_desc">-->
                <!--                            <div style="padding-right: 10px" v-if="scope.row.info_desc.hasOwnProperty('pic_url')">-->
                <!--                                <com-image mode="aspectFill" :src="scope.row.info_desc.pic_url"></com-image>-->
                <!--                            </div>-->
                <!--                            <div v-if="scope.row.info_desc.hasOwnProperty('remark')">{{scope.row.info_desc.remark}}</div>-->
                <!--                        </div>-->
                <!--                    </template>-->
                <!--                </el-table-column>-->


            </el-table>
            <div style="text-align: right;margin: 20px 0;">
                <el-input  v-model="page" placeholder="" size="small"  @keyup.enter.native="pageSearch" style="width:50px; float: right; text-align: center;margin-top:0px; margin-bottom: 50px; padding: 0;"></el-input>
                <el-pagination @current-change="pagination" background layout="prev, pager, next" :page-count="pageCount"></el-pagination>
            </div>
    </el-card>
</div>
<script>
    const app = new Vue({
        el: '#app',
        data() {
            return {
                searchData: {
                    keyword: '',
                    date: '',
                    user_id: '',
                    order_no: '',
                    remark: '',
                    balance_from_type: '',
                },
                status: 1,
                actionName: 'settlement',
                form: [],
                page:1,
                pageCount: 0,
                listLoading: false,
                exportList: {},
                incomeCapitalTypeList: [],
                export_url: 'mall/finance/balance-log',
                orderTotalArr: [{
                    type: 'income_capital_total',
                    name: '累计余额',
                    value: '0.00',
                    prompt: '累计所有平台产生的余额',
                }, {
                    type: 'expend_capital_total',
                    name: '已使用',
                    value: '0.00',
                    prompt: '使用余额支付或者使用余额抵扣或者用户进行转送行为统计',
                }, {
                    type: 'available_capital_total',
                    name: '会员账户余额',
                    value: '0.00',
                    prompt: '所有会员现有账户的余额',
                }, {
                    type: 'cash_out_total',
                    name: '已提现余额',
                    value: '0.00',
                    prompt: '已提现的累计余额',
                },
                //     {
                //     type: 'service_charges_tatoal',
                //     name: '手续费扣除',
                //     value: '0.00',
                //     prompt: '余额互转和提现产生的手续费',
                // }
                ]
            };
        },
        methods: {
            exportConfirm() {
                this.search.status = this.status
            },
            pagination(currentPage) {
                this.page = currentPage;
                this.getList();
            },
            search() {
                this.page = 1;
                console.log(999);
                this.getList();
            },
            pageSearch(){
                this.page_count = 1;
                this.getList();
            },
            clearsearch(data){
                if(data=='user_id') this.searchData.user_id = '';
                if(data=='keyword') this.searchData.keyword = '';
                if(data=='remark') this.searchData.remark = '';
                if(data=='order_no') this.searchData.order_no = '';
                this.getList();
            },
            getList() {
                this.listLoading = true;
                let self = this;
                request({
                    params: {
                        r: 'mall/finance/balance-log',
                        page: self.page,
                        user_id: self.searchData.user_id,
                        order_no: self.searchData.order_no,
                        keyword: self.searchData.keyword,
                        date: self.searchData.date,
                        remark: self.searchData.remark,
                        balance_from_type: self.searchData.balance_from_type,
                        status: this.status
                    },
                }).then(e => {
                    // console.log(e);return null;
                    if (e.data.code === 0) {
                        self.form = e.data.data.list;
                        self.exportList = e.data.data.export_list;
                        this.searchData.date = e.data.data.date;
                        if(this.page_count !=1)  self.pageCount = e.data.data.page_count;
                        self.pageCount = e.data.data.page_count;
                        this.currentPage =  parseInt(this.page);
                        self.incomeCapitalTypeList = e.data.data.incomeCapitalTypeList;
                        let statistics_data = e.data.data.statistics_data;
                        //self.searchData.date = e.data.data.date;
                        if (statistics_data) {
                            // console.log(23222424);
                            for (const key in statistics_data) {
                                let info = self.orderTotalArr.filter(v => v.type == key); //订单概况
                                console.info(info);
                                if (info.length) {
                                    let index = self.orderTotalArr.findIndex(v => v.type == info[0].type);
                                    self.orderTotalArr[index].value = Number(statistics_data[key]).toFixed(2);
                                }
                            }
                        }
                    } else {
                        if (e.data.msg == 'User Id必须是整数。') {
                            e.data.msg = '会员id必须是整数';
                        }
                        self.$message.error(e.data.msg);
                    }
                    self.listLoading = false;
                }).catch(e => {
                    self.listLoading = false;
                });
            },
            selectDateTime(e) {
                this.searchData.date = e;
                this.page = 1;
                this.search();
            },
            change_tab(tab, event) {
                for(let i in this.searchData) {
                    this.searchData[i] = '';
                }
                if (tab.name == 'settlement') {
                    this.searchData['status'] = 1;
                    this.status = 1;
                } else {
                    this.searchData['status'] = 0;
                    this.status = 0;
                }
                this.searchData.user_id = getQuery('user_id');

                this.search();
            },
            exportData(){
                let self = this;
                self.listLoading = true;
                request({
                    params: {
                        r: 'mall/finance/balance-log',
                        user_id: self.searchData.user_id,
                        order_no: self.searchData.order_no,
                        keyword: self.searchData.keyword,
                        date: self.searchData.date,
                        remark: self.searchData.remark,
                        balance_from_type: self.searchData.balance_from_type,
                        status: this.status,
                        flag: 'EXPORT'
                    },
                }).then(e => {
                    // console.log(e);return null;
                    if (e.data.code == 0) {
                        this.$message.success(e.data.msg);
                    } else {
                        this.$message.error(e.data.msg);
                    }
                    self.listLoading = false;
                }).catch(e => {
                    self.listLoading = false;
                });
            }
        },
        mounted: function() {
            this.user_id = getQuery('user_id');
            this.searchData.user_id = this.user_id;
            this.getList();
            // this.getTotalData();
        }
    });
</script>

<style>
    .table-body {
        padding: 20px;
        background-color: #fff;
    }

    .input-item {
        display: inline-block;
        width: 250px;
        margin: 0 0 20px 20px;
    }



    .input-item .el-input__inner:hover {
        border: 1px solid #dcdfe6;
        border-right: 0;
        outline: 0;
    }

    .input-item .el-input__inner:focus {
        border: 1px solid #dcdfe6;
        border-right: 0;
        outline: 0;
    }

    .input-item .el-input-group__append {
        background-color: #fff;
        border-left: 0;
        width: 10%;
        padding: 0;
    }

    /* .input-item .el-input-group__append .el-button {
        padding: 0;
    }

    .input-item .el-input-group__append .el-button {
        margin: 0;
    }

    .table-body .el-button {
        padding: 0 !important;
        border: 0;
        margin: 0 5px;
    } */

    .el-table th>.cell {
        color: #333;
        font-weight: bold;
        font-size: 14px;
    }

    .el-table__footer-wrapper,
    .el-table__header-wrapper {
        border-bottom: 1.4px solid #D6D6D6;
    }

    .stat_details {
        padding-bottom: 30px;
        display: flex;
    }

    .order_module {
        flex: 1;
        background: #F2F2F2;
        margin: 0 5px;
        padding: 20px 25px;
    }

    .order_module:last-child {
        margin-right: 0;
    }

    .order_module:first-child {
        margin-left: 0;
    }

    .price {
        font-size: 22px;
        font-weight: bold;
    }

    .oirder_modul_title {
        font-size: 12px;
        margin-bottom: 10px;
        display: flex;
        align-items: center;
    }

    .oirder_modul_title .text {
        margin-right: 10px;
    }

    .stat_icon {
        font-size: 19px;
        color: #BFBFBF;
    }
</style>