qzyReal
/
pco


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284
							<!DOCTYPE html>
<html>
<head>
    <title>月统计表-列表</title>
    <meta charset="utf-8">
    <meta name="viewport"
          content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no"/>
    <!-- 所有的 css & js 资源 -->
    <link rel="stylesheet" href="https://unpkg.com/element-ui@2.13.0/lib/theme-chalk/index.css">
    <link rel="stylesheet" href="../../static/sa.css">
    <script src="https://unpkg.com/vue@2.6.10/dist/vue.js"></script>
    <script src="https://unpkg.com/element-ui@2.13.0/lib/index.js"></script>
    <script src="https://unpkg.com/http-vue-loader@1.4.2/src/httpVueLoader.js"></script>
    <script src="https://unpkg.com/jquery@3.4.1/dist/jquery.js"></script>
    <script src="https://www.layuicdn.com/layer-v3.1.1/layer.js"></script>
    <script src="../../static/sa.js"></script>
</head>
<body>
<div class="vue-box" style="display: none;" :style="'display: block;'">
    <div class="c-panel">
        <!-- ------------- 检索参数 ------------- -->
        <div class="c-title">检索参数</div>
        <el-form ref="form" :model='p' @submit.native.prevent>
            <div class="c-item">
                <label class="c-label">收费类型：</label>
                <el-select v-model="p.feeType" placeholder="请选择" filterable>
                    <el-option label="-全部-" value=""></el-option>
                    <el-option label="核酸检测" value="1"></el-option>
                    <el-option label="消杀作业" value="2"></el-option>
                    <el-option label="装卸作业" value="3"></el-option>
                    <el-option label="停车业务" value="4"></el-option>
                    <el-option label="过磅费" value="5"></el-option>
                    <el-option label="入场管理费" value="6"></el-option>
                    <el-option label="充电打冷作业" value="7"></el-option>
                </el-select>
            </div>
            <div class="c-item">
                <label class="c-label">日期：</label>
                <el-date-picker type="year" value-format="yyyy" v-model="p.year"></el-date-picker>
            </div>
            <el-button type="primary" icon="el-icon-search" @click="p.pageNo = 1; f5()">查询</el-button>
			<el-button size="mini" type="info" @click="sa.f5()">刷新</el-button>
			<el-button class="c-btn" type="warning" icon="el-icon" @click="exportStats()">导出</el-button>
			<el-button class="c-btn" type="success" icon="el-icon" @click="print()">打印</el-button>
            <br/>
        </el-form>
        <!-- ------------- 快捷按钮 ------------- -->
        <!-- ------------- 数据列表 ------------- -->
        <el-table class="data-table" ref="data-table" :data="dataList" show-summary :summary-method="getSumRol">
            <sa-td name="收费项目" prop="feeType" type="enum"
                   :jv="{1: '核酸检测',2: '消杀作业', 3: '装卸作业', 4: '停车业务', 5: '过磅费', 6: '入场管理费', 7: '充电打冷作业'}"></sa-td>
            <sa-td name="年份" prop="year"></sa-td>
            <sa-td name="数量" prop="num"></sa-td>
            <!--					<sa-td name="含税收入（元）" prop="statisticsMoney"></sa-td>-->
            <el-table-column label="含税收入（元）">
                <template slot-scope="s">
                    <span>{{Number(s.row.taxMoney).toFixed(2)}}</span>
                </template>
            </el-table-column>
            <el-table-column label="税率(%)">
                <template slot-scope="s">
                    <span>{{s.row.taxRate * 100}}</span>
                </template>
            </el-table-column>
            <!--					<sa-td name="税款（元）" prop="taxes" ></sa-td>-->
            <el-table-column label="税款（元）">
                <template slot-scope="s">
                    <span>{{Number(s.row.taxes).toFixed(2)}}</span>
                </template>
            </el-table-column>
            <!--					<sa-td name="不含税收入（元）" prop="noTaxMoney" ></sa-td>-->
            <el-table-column label="不含税收入（元）">
                <template slot-scope="s">
                    <span>{{Number(s.row.noTaxMoney).toFixed(2)}}</span>
                </template>
            </el-table-column>
        </el-table>
        <!-- ------------- 分页 ------------- -->
        <sa-item type="page" :curr.sync="p.pageNo" :size.sync="p.pageSize" :total="dataCount" @change="f5()"></sa-item>
    </div>
</div>
<script>
    var app = new Vue({
        components: {
            "sa-item": httpVueLoader('../../sa-frame/com/sa-item.vue'),
            "sa-td": httpVueLoader('../../sa-frame/com/sa-td.vue'),
        },
        el: '.vue-box',
        data: {
            p: { // 查询参数
                id: '',		// 主键
                feeType: '',		// 收费类型(1=核酸检测,2=消杀作业,3=装卸作业,4=停车费,5=过磅费,6=入场管理费)
                itemTypeId: '',		// 业务类型id
                itemTypeName: '',		// 业务类型
                year: '',		// 年份
                month: '',		// 月份
                day: '',		// 天
                dayTime: '',		// 日期
                num: '',		// 数量
                taxMoney: '',		// 税款
                taxRate: '',		// 税率
                noTaxMoney: '',		// 不含税款
                payType: '',		// 支付方式(1=微信支付)
                isYear: 1,
                pageNo: 1,		// 当前页
                pageSize: 10,	// 页大小
                sortType: 0		// 排序方式
            },
            dataCount: 0,
            dataList: [], // 数据集合
            tableSum: {
                taxMoneySum: 0,
                taxesSum: 0,
                noTaxMoneySum: 0,
            },
        },
        methods: {
            getSumRol(param) {
                console.log("执行了getSumRol")
                const columns = param.columns;
                const sums = [];
                columns.forEach((column, index) => {
                    if (index === 0) {
                        sums[index] = "合计";
                        return;
                    }
                    //根据当前列绑定的字段名进行判断，根据字段名决定展示什么内容
                    switch (column.label) {
                        //金额;
                        case "含税收入（元）":
                            //在这里你就可以根据需要对数据进行一些处理（保留小数位数，加上单位等）
                            sums[index] = this.tableSum.taxMoneySum;
                            break;
                        //人数
                        case "税款（元）":
                            sums[index] = this.tableSum.taxesSum;
                            break;
                        //件数;
                        case "不含税收入（元）":
                            sums[index] = this.tableSum.noTaxMoneySum;
                            break;
                        //不需要计算合计的列就展示‘--’
                        default:
                            sums[index] = "";
                            break;
                    }
                });
                return sums;
            },
            calcuSum() {
                var taxMoneySum = 0;
                var taxesSum = 0;
                var noTaxMoneySum = 0;
                var len = this.dataList.length;
                for (var i = 0; i < len; i++) {
                    taxMoneySum = (taxMoneySum * 100 + this.dataList[i].taxMoney * 100) / 100;
                    taxesSum = (taxesSum * 100 + this.dataList[i].taxes * 100) / 100;
                    noTaxMoneySum = (noTaxMoneySum * 100 + this.dataList[i].noTaxMoney * 100) / 100;
                }
                this.tableSum.taxMoneySum = Number(taxMoneySum).toFixed(2);
                this.tableSum.taxesSum = Number(taxesSum).toFixed(2);
                this.tableSum.noTaxMoneySum = Number(noTaxMoneySum).toFixed(2);

            },
            getTotalMoney() {
                sa.ajax('/TbFeeStatistics/getSum', sa.removeNull(this.p), function (res) {
                    this.tableSum.taxMoneySum = res.data.taxMoneySum;
                    this.tableSum.taxesSum = res.data.taxesSum;
                    this.tableSum.noTaxMoneySum = res.data.noTaxMoneySum;
                }.bind(this));
            },
            print: function () {
                var year = this.p.year;
                var feeType = this.p.feeType;
                var str = '';
                if (year === '') {
                    str += '所有年份';
                } else {
                    str += year + '年'
                }
                if (feeType === '') {
                    str += "、所有收费项目";
                } else {
                    var feeTypeName = '';
                    if (feeType == 1) {
                        feeTypeName = "核酸检测";
                    } else if (feeType == 2) {
                        feeTypeName = "消杀作业";
                    } else if (feeType == 3) {
                        feeTypeName = "装卸作业";
                    } else if (feeType == 4) {
                        feeTypeName = "停车费";
                    } else if (feeType == 5) {
                        feeTypeName = "过磅费";
                    } else if (feeType == 6) {
                        feeTypeName = "入场管理费";
                    } else if (feeType == 7) {
                        feeTypeName = "充电打冷作业";
                    }
                    str += "、收费项目为" + feeTypeName;
                }

                this.$confirm('确定打印' + str + '的数据?', '提示', {
                    confirmButtonText: '确定',
                    cancelButtonText: '取消',
                    type: 'warning'
                }).then(() => {
                    sa.showIframe('打印年报表', 'yearStatsPrint.html?year=' + year + "&feeType=" + feeType + "&isYear=1", '100%', '100%');
                }).catch(() => {

                });
            },
            exportStats() {
                var year = this.p.year;
                var feeType = this.p.feeType;
                var str = '';
                if (year === '') {
                    str += '所有年份';
                } else {
                    str += year + '年'
                }
                if (feeType === '') {
                    str += "、所有收费项目";
                } else {
                    var feeTypeName = '';
                    if (feeType == 1) {
                        feeTypeName = "核酸检测";
                    } else if (feeType == 2) {
                        feeTypeName = "消杀作业";
                    } else if (feeType == 3) {
                        feeTypeName = "装卸作业";
                    } else if (feeType == 4) {
                        feeTypeName = "停车费";
                    } else if (feeType == 5) {
                        feeTypeName = "过磅费";
                    } else if (feeType == 6) {
                        feeTypeName = "入场管理费";
                    } else if (feeType == 7) {
                        feeTypeName = "充电打冷作业";
                    }
                    str += "、收费项目为" + feeTypeName;
                }
                this.$confirm('确定导出' + str + '的数据?', '提示', {
                    confirmButtonText: '确定',
                    cancelButtonText: '取消',
                    type: 'warning'
                }).then(() => {
                    sa.ajax('/TbFeeStatistics/export/stats', sa.removeNull(this.p), function (resp) {
                        window.open(resp.data);
                    }.bind(this));
                }).catch(() => {

                });
            },
            // 刷新
            f5: function () {
                sa.ajax('/TbFeeStatistics/getYear', sa.removeNull(this.p), function (res) {
                    this.dataList = res.data; // 数据
                    this.dataCount = res.dataCount; // 数据总数
                    sa.f5TableHeight();		// 刷新表格高度
                }.bind(this));
                this.getTotalMoney();
            },
            // 查看
            get: function (data) {
                sa.showIframe('数据详情', 'year-statistcs-info.html?id=' + data.id, '1050px', '90%');
            },
            // 查看 - 根据选中的
            getBySelect: function (data) {
                var selection = this.$refs['data-table'].selection;
                if (selection.length == 0) {
                    return sa.msg('请选择一条数据')
                }
                this.get(selection[0]);
            },
        },
        created: function () {
            this.f5();
            sa.onInputEnter();
        }
    })
</script>
</body>
</html>