qimall/addons/CloudStock/backend/views/default/price-log.php

<?php
/**
 * @link:http://www.goodmall.com/
 * @copyright: Copyright (c) 2020
 * Created by PhpStorm
 * Author: ganxiaohao
 * Date: 2020-05-13
 * Time: 14:21
 */
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;
    }

    .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; */
    }
</style>
<div id="app" v-cloak>
    <el-tabs v-model="actionNameDetail" @tab-click="handleClick">
        <el-tab-pane label="佣金明细" name="first">
            <div class="order_stat">
                <div class="el-card is-never-shadow" style="border: 0px; min-width: 800px; margin-bottom: 10px;">
                    <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>
            </div>
            <el-card shadow="never" style="border:0;min-width: 800px;"
                     body-style="background-color: #f3f3f3;padding: 10px 0 0;">
                <div class="table-body">
                    <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-select size="small" v-model="searchData.capital_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>
                    <el-date-picker size="small" placeholder="选择日期" v-model="searchData.date" type="month"
                                    style="float: left" value-format="yyyy-MM" @change="selectDateTime">
                    </el-date-picker>
                    <el-input clearable style="width: 170px;margin-right: 20px;" size="small" type="text" @keyup.enter.native="search" v-model="searchData.contributor" placeholder="来源会员ID/手机号"></el-input>
                    <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" 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="180">
                            <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" label="佣金类型" min-width="150" align="center">
                            <template slot-scope="scope">
                                <div v-if="scope.row.source_text">{{scope.row.source_text}}</div>
                                <div v-else-if="scope.row.source">{{scope.row.source}}</div>
                                <div v-else>--</div>
                            </template>
                        </el-table-column>
                        <el-table-column label="结算金额" min-width="100" align="center">
                            <template slot-scope="scope">
                                <div style="font-size: 18px;color: #68CF3D" v-if="scope.row.change_type == 'add'">
                                    +{{scope.row.change_num}}
                                </div>
                                <div style="font-size: 18px;color: #F6AA5A" v-if="scope.row.change_type == 'sub'">
                                    -{{scope.row.change_num}}
                                </div>
                            </template>
                        </el-table-column>
                        <el-table-column prop="current_num" label="变动前佣金" min-width="100"
                                         align="center"></el-table-column>
                        <el-table-column prop="current_num" label="变动后佣金" min-width="100" align="center">
                            <template slot-scope="scope">
                                <div v-if="scope.row.change_type == 'add'">{{Number((scope.row.current_num +
                                    scope.row.change_num)).toFixed(2)}}
                                </div>
                                <div v-if="scope.row.change_type == 'sub'">{{Number((scope.row.current_num -
                                    scope.row.change_num)).toFixed(2)}}
                                </div>
                            </template>
                        </el-table-column>

                        <el-table-column prop="desc" label="说明" min-width="200" align="center"></el-table-column>
                        <el-table-column prop="order_no" label="订单编号" width="150" align="center"></el-table-column>
                        <el-table-column label="来源会员" width="180">
                            <template slot-scope="scope">
                                <div class="table-info-img-text" v-if="scope.row.from_user">
                                    <el-image class="table-info-img circle" :src="scope.row.from_user.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.from_user.id">ID：{{scope.row.from_user.id}}</div>
                                        <div v-if="scope.row.from_user.nickname">昵称：{{scope.row.from_user.nickname}}
                                        </div>
                                    </div>
                                </div>
                            </template>
                        </el-table-column>
                        <el-table-column prop="scope" min-width="150" label="创建时间" align="center">
                            <template slot-scope="scope">
                                {{scope.row.created_at}}
                            </template>
                        </el-table-column>
                    </el-table>

                    <!--工具条 批量操作和分页-->
                    <el-col :span="24" class="toolbar">
                        <el-pagination
                                background
                                layout="prev, pager, next"
                                @current-change="pageChange"
                                :page-size="pageSize"
                                :total="pagination.totalCount"
                                style="float:right;margin:15px"
                                v-if="pagination">
                        </el-pagination>
                    </el-col>
                </div>
            </el-card>
        </el-tab-pane>
        <el-tab-pane label="货款明细" name="second">
            <div class="order_stat">
                <div class="el-card is-never-shadow" style="border: 0px; min-width: 800px; margin-bottom: 10px;">
                    <div class="stat_details">
                        <div class="order_module" v-for="(item,index) in paymentTotalArr" :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>
            </div>
            <el-card shadow="never" style="border:0;min-width: 800px;"
                     body-style="background-color: #f3f3f3;padding: 10px 0 0;">
                <div class="table-body">
                    <el-date-picker size="small" placeholder="选择日期" v-model="searchData.date" type="month"
                                    style="float: left" value-format="yyyy-MM" @change="selectDateTimePayment">
                    </el-date-picker>
                    <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-select size="small" v-model="searchData.status" class="select">
                        <el-option key="all" label="全部" value="all"></el-option>
                        <el-option key="0" label="未结算" value="0"></el-option>
                        <el-option key="1" label="已结算" value="1"></el-option>
                    </el-select>
                    <el-input clearable style="width: 170px;margin-right: 20px;" size="small" type="text" @keyup.enter.native="search" v-model="searchData.contributor" placeholder="来源会员ID/手机号"></el-input>
                    <div class="input-item">
                        <el-button type="primary" size="small" icon="el-icon-search" @click="searchPayment"
                                   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" 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="会员" align="center" width="180">
                            <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" label="货款类型" min-width="150" align="center">
                            <template slot-scope="scope">
                                <div>云库存-{{scope.row.source_text}}</div>
                            </template>
                        </el-table-column>
                        <el-table-column label="金额" min-width="100" align="center" prop="money"></el-table-column>
                        <el-table-column label="状态" min-width="100" align="center">
                            <template slot-scope="scope">
                                <div v-if="scope.row.status == 0">
                                    未结算
                                </div>
                                <div v-if="scope.row.status == 1">
                                    已结算
                                </div>
                            </template>
                        </el-table-column>
                        <el-table-column prop="desc" label="说明" min-width="200" align="center"></el-table-column>
                        <el-table-column prop="order_no" label="订单编号" width="150" align="center"></el-table-column>
                        <el-table-column label="来源会员" width="180">
                            <template slot-scope="scope">
                                <div class="table-info-img-text" v-if="scope.row.from_user">
                                    <el-image class="table-info-img circle" :src="scope.row.from_user.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.from_user.id">ID：{{scope.row.from_user.id}}</div>
                                        <div v-if="scope.row.from_user.nickname">昵称：{{scope.row.from_user.nickname}}
                                        </div>
                                    </div>
                                </div>
                            </template>
                        </el-table-column>
                        <el-table-column prop="scope" min-width="150" label="创建时间" align="center">
                            <template slot-scope="scope">
                                {{scope.row.created_at}}
                            </template>
                        </el-table-column>
                    </el-table>

                    <!--工具条 批量操作和分页-->
                    <el-col :span="24" class="toolbar">
                        <el-pagination
                                background
                                layout="prev, pager, next"
                                @current-change="pageChangePaymentLog"
                                :page-size="pageSize"
                                :total="pagination.totalCount"
                                style="float:right;margin:15px"
                                v-if="pagination">
                        </el-pagination>
                    </el-col>
                </div>
            </el-card>
        </el-tab-pane>
    </el-tabs>


</div>
<script>
    const app = new Vue({
        el: '#app',
        data() {
            return {
                actionName: 'settlement',
                actionNameDetail: 'first',
                status: 1,
                searchData: {
                    keyword: '',
                    date: '',
                    user_id: '',
                    // order_num: '',
                    capital_type: '',
                    order_no:'',
                    status: '1',
                    contributor: '',
                },
                export_url: 'mall/finance/commission-log',
                exportList:{},
                form: [],
                incomeFromTypeList:[],
                incomeCapitalTypeList:[],
                pagination: null,
                listLoading: false,
                orderTotalArr: [
                    {
                        type: 'commission_total',
                        name: '总发放佣金',
                        value: '0.00',
                        prompt: '累计所有发放给会员的佣金（待结算+已结算）',
                    },{
                        type: 'frozen_capital_total',
                        name: '待结算佣金',
                        value: '0.00',
                        prompt: '所有会员待结算的佣金',
                    },
                ],
                paymentTotalArr: [
                    {
                        type: 'cloud_warehouse',
                        name: '货款总额',
                        value: '0.00',
                        prompt: '',
                    }, {
                        type: 'cloud_warehouse_withdraw_price',
                        name: '货款提现总数',
                        value: '0.00',
                        prompt: '',
                    },
                ],
                pageSize: 20,
            };
        },
        methods: {
            handleClick(tab, event) {
                if (tab.name == 'first') {
                    this.searchData.status = '1';
                    this.getList();
                } else if (tab.name == 'second') {
                    this.searchData.status = 'all';
                    this.getPaymentLog();
                }
                console.log(tab.name, event);
            },
            exportConfirm() {
                this.search.status = this.status
            },
            pageChange(currentPage) {
                this.page = currentPage;
                this.getList();
            },
            pageChangePaymentLog(currentPage) {
                this.page = currentPage;
                this.getPaymentLog();
            },
            search() {
                this.page = 1;
                this.getList();
            },
            searchPayment() {
                this.page = 1;
                this.getPaymentLog();
            },
            selectDateTime(e) {
                this.searchData.date = e;
                this.page = 1;
                this.search();
            },
            selectDateTimePayment(e) {
                this.searchData.date = e;
                this.page = 1;
                this.getPaymentLog();
            },

            getList() {
                let params = {
                    r: 'cloud-stock/default/price-log',
                    page: this.page,
                    user_id: this.searchData.user_id,
                    keyword: this.searchData.keyword,
                    status: this.status,
                    date: this.searchData.date,
                    capital_type: this.searchData.capital_type,
                    order_no:this.searchData.order_no,
                    contributor:this.searchData.contributor,
                };
                request({
                    params,
                }).then(e => {
                    if (e.data.code === 0) {
                        this.pageSize = e.data.data.page_size;
                        this.form = e.data.data.list;
                        this.pagination = e.data.data.pagination;
                        this.incomeCapitalTypeList = e.data.data.incomeCapitalTypeList;
                        this.exportList = e.data.data.export_list;
                        this.export_url = 'cloud-stock/default/price-log';
                        for (const key in e.data.data.statistics_data) {
                            let info = this.orderTotalArr.filter(v => v.type == key); //订单概况
                            if(info.length){
                                let index = this.orderTotalArr.findIndex(v => v.type==info[0].type);
                                this.orderTotalArr[index].value = Number(e.data.data.statistics_data[key]).toFixed(2);
                            }
                        }
                    } else {
                        if(e.data.msg == 'User Id必须是整数。'){
                            e.data.msg = '会员id必须是整数';
                        }
                        this.$message.error(e.data.msg);
                    }
                    this.listLoading = false;
                }).catch(e => {
                    this.listLoading = false;
                });
                this.listLoading = true;
            },
            settlement(id){
                let self = this;
                self.$confirm('是否确认结算?', '提示', {
                    confirmButtonText: '确定',
                    cancelButtonText: '取消',
                    type: 'warning'
                }).then(() => {
                    request({
                        params: {
                            r: 'cloud-stock/default/settlement',
                        },
                        method: 'post',
                        data:{
                            id:id,
                        }
                    }).then(e => {
                        self.loading = false;
                        if (e.data.code == 0) {
                            self.$message.success(e.data.msg);
                            self.getList();
                        } else {
                            self.$message.error(e.data.msg);
                        }
                    }).catch(e => {
                        self.loading = false;
                    });
                }).catch(() => {
                    //self.$message.info('已取消')
                });



            },
            change_tab(tab, event) {
                for(let i in this.searchData) {
                    this.searchData[i] = '';
                }
                if (tab.name == 'settlement') {
                    this.status = 1;
                    this.searchData.status = 1;
                } else {
                    this.status = 0;
                    this.searchData.status = 0;
                }
                this.search();
            },
            exportData(){
                let self = this;
                self.listLoading = true;

                request({
                    params: {
                        r: 'mall/finance/commission-log',
                        date: this.searchData.date,
                        user_id: this.searchData.user_id,
                        keyword: this.searchData.keyword,
                        desc: this.searchData.remark,
                        capital_type: this.searchData.capital_type,
                        status: this.status,
                        order_no:this.searchData.order_no,
                        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;
                });
            },
            getPaymentLog() {
                let params = {
                    r: 'cloud-stock/default/payment-log',
                    page: this.page,
                    user_id: this.searchData.user_id,
                    keyword: this.searchData.keyword,
                    status: this.searchData.status,
                    date: this.searchData.date,
                    capital_type: this.searchData.capital_type,
                    order_no: this.searchData.order_no,
                    contributor: this.searchData.contributor,
                };
                request({
                    params,
                }).then(e => {
                    if (e.data.code === 0) {
                        this.pageSize = e.data.data.page_size;
                        this.form = e.data.data.list;
                        this.pagination = e.data.data.pagination;
                        this.exportList = e.data.data.export_list;
                        this.export_url = e.data.data.export_url;
                        for (const key in e.data.data.statistics_data) {
                            let info = this.paymentTotalArr.filter(v => v.type == key); //订单概况
                            if (info.length) {
                                let index = this.paymentTotalArr.findIndex(v => v.type == info[0].type);
                                this.paymentTotalArr[index].value = Number(e.data.data.statistics_data[key]).toFixed(2);
                            }
                        }
                    } else {
                        if (e.data.msg == 'User Id必须是整数。') {
                            e.data.msg = '会员id必须是整数';
                        }
                        this.$message.error(e.data.msg);
                    }
                    this.listLoading = false;
                }).catch(e => {
                    this.listLoading = false;
                });
                this.listLoading = true;
            },
        },
        mounted: function() {
            this.user_id = getQuery('user_id');
            this.searchData.user_id = getQuery('user_id');
            this.getList();
        }
    });
</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;
    }

    .statistical ul {
        float: left;
    }
    .statistical ul li.ul-li {
        width: 33%;
        float: left;
        list-style-type :none;
        padding-bottom: 10px;
    }


    .stat_details{
        /* padding-bottom: 30px; */
        padding-top: 20px;
        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>