qimall/addons/AvoidTax/backend/views/order/index.php

<?php
use common\helpers\ComponentHelper;

ComponentHelper::loadComponentView('com-export-dialog');
?>
<div id="app" v-cloak>
    <el-card shadow="never" style="border:0;" body-style="background-color: #f3f3f3;padding: 10px 0 0;">
        <div slot="header">
            <div>
                <span>交易列表</span>
                <com-export-dialog style="float: right; margin-top: -5px;" :field_list='export_list' :action_url="export_url" :params="searchData"></com-export-dialog>
            </div>
        </div>

        <el-alert title="假设：用户提现10000元;" type="warning" :closable="false" style="margin-bottom: 10px; display: none;" id="alert-box">
            1、首先平台需要收取服务费6%（平台服务费 = 10000 * 6% = 600）；<br>
            2、公司支付宝资金划拨到记账本金额，记账本会打款给用户（10000 - 平台服务费 = 9400[用户所得工资]）；<br>
            3、支付给兼职猫服务费[从公司支付宝账户支付]（9400 * 6% = 576）；<br>
            4、实际总支出（9400 + 576 = 9976）；<br>
            5、平台利润（10000 - 9976 = 24）；
        </el-alert>

        <!-- 统计 -->
        <el-card class="box-card" style="margin-bottom: 10px;">
            <div slot="header" class="clearfix">
                <span>统计</span>
                <el-button style="float: right; padding: 3px 0" type="text" @click="handleRule">发放规则</el-button>
            </div>

            <div class="headBox">
                <div class="headItem" >
                    <div>
                        <i class="el-icon-coin" style="font-size: 50px;margin-right: 10px;"></i>
                    </div>
                    <div>
                        <div>
                            <label slot="label">总佣金
                                <el-tooltip class="item" effect="dark"
                                            content="会员申请提现的总金额"
                                            placement="top-start">
                                    <i class="el-icon-info"></i>
                                </el-tooltip>
                            </label>
                        </div>
                        <div style="font-weight: bold;font-size: 25px;">{{ statistic.withdraw_total }}</div>
                    </div>
                </div>
                <div class="headItem">
                    <div>
                        <i class="el-icon-coin" style="font-size: 50px;margin-right: 10px;"></i>
                    </div>
                    <div>
                        <div>
                            <label slot="label">实际发放佣金
                                <el-tooltip placement="top">
                                    <div slot="content">
                                        实际发放佣金 = 总佣金 - 总佣金 * N%<br/>
                                        N% = 平台设置的手续费比例(“设置”-“资产”-“收益提现设置”：“提现手续费”进行设置)
                                    </div>
                                    <i class="el-icon-info"></i>
                                </el-tooltip>
                            </label>
                        </div>
                        <div style="font-weight: bold;font-size: 25px;">{{ statistic.payment_total }}</div>
                    </div>
                </div>
                <div class="headItem" style="background-color: #F59C6C;">
                    <div>
                        <i class="el-icon-coin" style="font-size: 50px;margin-right: 10px;"></i>
                    </div>
                    <div>
                        <div>
                            <label slot="label">平台利润
                                <el-tooltip class="item" effect="dark"
                                            content="平台利润 = 总佣金 - 实际发放佣金 - 应发税费总额"
                                            placement="top">
                                    <i class="el-icon-info"></i>
                                </el-tooltip>
                            </label>
                        </div>
                        <div style="font-weight: bold;font-size: 25px;">{{ (statistic.withdraw_total - statistic.payment_total - statistic.payment_fee_total).toFixed(2) }}</div>
                    </div>
                </div>
                <div class="headItem" style="background-color: #1ABC9C;">
                    <div>
                        <i class="el-icon-coin" style="font-size: 50px;margin-right: 10px;"></i>
                    </div>
                    <div>
                        <div>
                            <label slot="label">应发税费总额
                                <el-tooltip class="item" effect="dark"
                                            content="应发税费总额 = 实际发放佣金 * 6%（此比例为与第三方签约的比例）"
                                            placement="top">
                                    <i class="el-icon-info"></i>
                                </el-tooltip>
                            </label>
                        </div>
                        <div style="font-weight: bold;font-size: 25px;">{{ statistic.payment_fee_total }}</div>
                    </div>
                </div>
                <div class="headItem" style="background-color: #6C9EF5;">
                    <div>
                        <i class="el-icon-coin" style="font-size: 50px;margin-right: 10px;"></i>
                    </div>
                    <div>
                        <div>
                            <label slot="label">实际发放税费总额
                                <el-tooltip placement="top">
                                    <div slot="content">
                                        实际发放税费总额 = 实际上已经支付给第三方公司的税费<br/>
                                        注意：理论上“实际发放税费总额”应该等于“应发税费总额”，但有可能因为其他原因导致税费支付失败(如：支付宝限额)
                                    </div>
                                    <i class="el-icon-info"></i>
                                </el-tooltip>
                            </label>
                        </div>
                        <div style="font-weight: bold;font-size: 25px;">{{ statistic.fee_total }}</div>
                    </div>
                </div>
            </div>
        </el-card>
        <!-- 统计 -->

        <div class="table-body">
            <el-form :inline="true" :model="searchData" class="demo-form-inline">
                <el-col :span="24">

                    <el-form-item size="small" label="批次号">
                        <el-input v-model="searchData.batch_num" placeholder="批次号"></el-input>
                    </el-form-item>
                    <el-form-item size="small" label="订单号">
                        <el-input v-model="searchData.order_sn" placeholder="订单号"></el-input>
                    </el-form-item>
                    <el-form-item size="small" label="收款人">
                        <el-input v-model="searchData.name" placeholder="收款人"></el-input>
                    </el-form-item>
                    <el-form-item size="small" label="收款账号">
                        <el-input v-model="searchData.mobile" placeholder="收款账号"></el-input>
                    </el-form-item>
                    <br>
                    <el-form-item label="时间筛选">
                        <el-date-picker
                                size="small"
                                v-model="searchData.date"
                                type="datetimerange"
                                range-separator="至"
                                start-placeholder="开始日期"
                                end-placeholder="结束日期"
                                format="yyyy-MM-dd"
                                value-format="yyyy-MM-dd"
                        >
                        </el-date-picker>
                    </el-form-item>

                    <el-form-item size="small" label="状态">
                        <el-select v-model="searchData.status" class="select">
                            <el-option v-for="item in statusArr" :label="item.label" :value="item.value" :key="item.value"></el-option>
                        </el-select>
                    </el-form-item>

                    <el-button type="primary" size="small" @click="onSubmit">查询</el-button>
                    <el-button size="small" @click="resetForm">重置</el-button>
                </el-col>
                <!-- <el-form-item>
                    <el-button type="success" v-loading="addLoading"  size="small"  @click="add()">添加交易</el-button>
                    <el-button type="success" v-loading="addLoading"  size="small"  @click="addBatch()">批量汇款</el-button>
                </el-form-item> -->
            </el-form>

            <!-- 订单信息 -->
            <template>
                <el-table ref="multipleTable" :data="list" @selection-change="handleSelectionChange" v-loading="addLoading">
                    <!-- 空数据 -->
                    <template slot="empty">
                        <el-empty description="暂无交易数据"></el-empty>
                    </template>
                    <el-table-column type="selection"></el-table-column>
                    <el-table-column prop="title" align="center" label="标题"></el-table-column>
                    <el-table-column prop="batch_num" align="center" label="批次号/提现订单号">
                        <template slot-scope="scope">
                            {{ scope.row.batch_num }}
                            <br>
                            {{
                                scope.row.withdraw
                                ? scope.row.withdraw.order_no
                                : '--'
                            }}
                        </template>
                    </el-table-column>
                    <el-table-column prop="account" align="center" label="记账方">
                        <template slot-scope="scope">
                            {{ 
                                scope.row.account
                                ? scope.row.account.alipay_logon_id
                                : '--'
                            }}
                        </template>
                    </el-table-column>
                    <el-table-column prop="name" align="center" label="收款人"></el-table-column>
                    <el-table-column prop="mobile" align="center" label="收款账号"></el-table-column>
                    <el-table-column prop="amount" align="center" label="打款金额"></el-table-column>
                    <el-table-column prop="pay_fee" align="center" label="手续费"></el-table-column>
                    <el-table-column prop="created_at" align="center" label="创建/修改时间">
                        <template slot-scope="scope">
                            {{ scope.row.created_at|dateTimeFormat('Y-m-d H:i:s') }}<br>
                            {{ scope.row.updated_at|dateTimeFormat('Y-m-d H:i:s') }}
                        </template>
                    </el-table-column>
                    <el-table-column prop="status_text" align="center" label="状态"></el-table-column>
                    <el-table-column prop="account_type" align="center" label="资金类型">
                        <template slot-scope="scope">
                            <span v-if="scope.row.account_type == 1">打款</span>
                            <span v-if="scope.row.account_type == 2">出款</span>
                        </template>
                    </el-table-column>
                    <el-table-column prop="type_text" align="center" label="订单类型"></el-table-column>
                    <el-table-column prop="error" align="center" label="错误信息"></el-table-column>
                    <el-table-column prop="right_btn" label="操作" align="center">
                        <template slot-scope="scope">
                            <el-button v-loading="addLoading" size="mini" @click="fee(scope.row.batch_num)">手续费详情</el-button>
                            <!-- <el-button @click="trans(scope.row.id)" :disabled="transLoading" v-loading="transLoading" type="text" size="small" v-if="scope.row.type == 1 && scope.row.status == 0">确认打款</el-button> -->
                            <!-- <el-button @click="trans(scope.row.id)" :disabled="true" v-loading="transLoading" type="text" size="small" v-if="scope.row.type == 2 && scope.row.status == 0">确认打款</el-button> -->
                            <!-- <el-button type="text" size="small" :disabled="true" v-if="scope.row.status == 2">已打款</el-button> -->
                        </template>
                    </el-table-column>
                </el-table>
            </template>

            <el-dialog
                title="详情"
                :visible.sync="dialogVisible"
                width="30%"
            >
            <el-row>
                <el-col :span="22">
                    <el-form ref="feeForm" :model="feeForm" label-width="120px">
                        <el-form-item label="订单号">
                            <el-input v-model="feeForm.order_sn" :disabled="true"></el-input>
                        </el-form-item>
                        <el-form-item label="收款方名称">
                            <el-input v-model="feeForm.name" :disabled="true"></el-input>
                        </el-form-item>
                        <el-form-item label="收款方账号">
                            <el-input v-model="feeForm.mobile" :disabled="true"></el-input>
                        </el-form-item>
                        <el-form-item label="手续费">
                            <el-input v-model="feeForm.amount" :disabled="true"></el-input>
                        </el-form-item>
                        <el-form-item label="状态">
                            <!-- <el-input v-model="feeForm.status" :disabled="true"></el-input> -->
                            <el-select v-model="feeForm.status" :disabled="true">
                                <el-option label="打款失败" :value="-1"></el-option>
                                <el-option label="打款失败" :value="1"></el-option>
                                <el-option label="打款成功" :value="5"></el-option>
                            </el-select>
                        </el-form-item>
                    </el-form>
                </el-col>
            </el-row>
                <span slot="footer" class="dialog-footer">
                    <el-button type="primary" @click="dialogVisible = false">关闭</el-button>
                </span>
            </el-dialog>

            <!-- 分页 -->
            <el-row type="flex" class="page" justify="end">
                <el-pagination @current-change="pagination" background layout="prev, pager, next" :page-count="pageCount" v-if="list"></el-pagination>
            </el-row>
        </div>
    </el-card>
</div>
<script>
    const app = new Vue({
        el: '#app',
        data() {
            return {
                searchData: {
                    status     : '',
                    title      : '',
                    batch_num  : '',
                    order_sn   : '',
                    name       : '',
                    mobile     : '',
                    start_time : '',
                    end_time   : '',
                    date       : '',
                },
                list: [],
                pageCount: 0,
                page: 1,
                currentPage: null,
                listLoading: false,
                btnLoading: false,
                checked: false,
                addLoading: false,
                addVisible: false,
                transaction: {}, // 交易数据
                selectOrder: [],
                transLoading: false,
                statistic: {
                    payment_total: 0,// 出款成功总额
                    payment_fee_total: 0,// 应发服务费总额
                    fee_total: 0,// 实发服务总额
                    withdraw_total: 0,// 总提现金额
                },
                dialogVisible: false,
                feeForm: {},
                export_list: {},
                export_url: 'avoid-tax/order/index',
                alertBox: false,
                statusArr: [
                    {
                        value: -1,
                        label: '打款失败',
                    },
                    {
                        value: 1,
                        label: '待提交审核',
                    },
                    {
                        value: 2,
                        label: '税方审核中',
                    },
                    {
                        value: 3,
                        label: '税方审核成功',
                    },
                    {
                        value: 4,
                        label: '待出款',
                    },
                    {
                        value: 5,
                        label: '出款成功',
                    },
                ]
            };
        },
        methods: {
            resetForm() {
                this.searchData = {
                    status     : '',
                    title      : '',
                    batch_num  : '',
                    order_sn   : '',
                    name       : '',
                    mobile     : '',
                    start_time : '',
                    end_time   : '',
                    date       : '',
                }
            },
            handleSelectionChange(val) {
                let ids = []
                val.forEach((item) => {
                    ids.push(item.id)
                })
                this.selectOrder = ids
            },
            // 全选
            allSelect() {
                if (this.checked) {
                    this.goods_list.forEach(function(item, index) {
                        if (!item.storage) {
                            item.is_select = true
                        }
                    })
                } else {
                    this.goods_list.forEach(function(item, index) {
                        item.is_select = false
                    })
                }
            },
            //搜索
            onSubmit() {
                this.page = 1
                this.getList()
            },
            pagination(currentPage) {
                this.page = currentPage
                this.getList()
            },
            // 获取列表
            getList() {
                this.listLoading = true;
                var param = {
                    r: 'avoid-tax/order/index',
                    page: this.page,
                    limit: 20
                }
                Object.assign(param, param, this.searchData)
                request({
                    params: param,
                }).then(e => {
                    if (e.data.code === 0) {
                        this.statistic = e.data.data.statistic
                        this.export_list = e.data.data.export_list;
                        this.list = e.data.data.list
                        this.pageCount = e.data.data.page_count
                        this.currentPage = e.data.data.pagination.current_page
                    } else {
                        this.$message.error(e.data.msg)
                    }
                    this.listLoading = false
                }).catch(e => {
                    this.listLoading = false
                })
            },
            // 弹出交易界面
            add() {
                navigateTo({
                    r: 'avoid-tax/order/add',
                })
            },
            // trans
            trans (id) {
                this.transLoading = true;
                request({
                    params: {
                        r: 'avoid-tax/order/trans',
                        id: id,
                    }
                }).then(e => {
                    if (e.data.code === 0) {
                        this.$message.success('打款成功')
                        setTimeout(() => {
                            this.getList()
                        }, 1000)
                    } else {
                        this.$message.error(e.data.msg)
                    }
                    this.transLoading = false
                }).catch(e => {
                    this.transLoading = false
                })
            },
            // 批量汇款
            addBatch () {
                if(this.selectOrder.length <= 0){
                    this.$message.error("请选择记录")
                    return
                }
                this.transLoading = true;
                request({
                    method: 'post',
                    params: {
                        r: 'avoid-tax/order/batch-trans',
                    },
                    data: {
                        ids: this.selectOrder,
                    }
                }).then(e => {
                    if (e.data.code === 0) {
                        this.$message.success('添加批量打款成功 后台等待打款中~')
                    } else {
                        this.$message.error(e.data.msg)
                    }
                    this.transLoading = false
                }).catch(e => {
                    this.transLoading = false
                })
            },
            /**
             * 手续费详情
             */
            fee(num) {
                this.dialogVisible = true
                this.feeForm = {}

                request({
                    params: {
                        r: 'avoid-tax/order/fee',
                        num: num
                    },
                }).then(e => {
                    if (e.data.code === 0) {
                        this.feeForm = e.data.data
                    } else {
                        this.$message.error(e.data.msg)
                    }
                    this.listLoading = false
                }).catch(e => {
                    this.listLoading = false
                })
            },
            handleRule() {
                if (this.alertBox == false) {
                    $("#alert-box").show("slow");
                    this.alertBox = true;
                } else {
                    $("#alert-box").hide("slow");
                    this.alertBox = false;
                }
            }
        },
        mounted: function() {
            this.page = getQuery('page') ? getQuery('page') : 1
            this.getList()
        }
    });
</script>
<style>
    .add-body {
        padding: 10px 20px;
    }
    .page {
        padding: 20px 0;
    }

    /*统计样式*/
    .headBox {
        display: flex;
        flex-wrap: wrap;
        /*margin-bottom: 10px;*/
        color: #fff;
    }

    .headItem {
        width: 16%;
        margin:0 0.5%;
        height: 120px;
        border-radius: 10px;
        background-color: #F56C6C;
        /*margin-right: 20px;*/
        margin-bottom: 14px;
        display: flex;
        align-items: center;
        justify-content: center;
    }
</style>