qzyReal
/
pco


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356
							<!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="../../static/kj/element-ui/theme-chalk/index.css">
		<link rel="stylesheet" href="../../static/sa.css">
		<script src="../../static/kj/vue.min.js"></script>
		<script src="../../static/kj/element-ui/index.js"></script>
		<script src="../../static/kj/httpVueLoader.js"></script>
		<script src="../../static/kj/jquery.min.js"></script>
		<script src="../../static/kj/layer/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 v-for="(item,index) in feeItemList" :label="item.name" :value="item.id"
								:key="index">
							</el-option>
						</el-select>
					</div>
					<div class="c-item">
						<label class="c-label">日期范围：</label>
						<el-date-picker size="mini" v-model="selectMonth" type="monthrange" unlink-panels="false"
							range-separator="至" start-placeholder="开始月份" end-placeholder="结束月份" format="yyyy 年 MM 月"
							value-format="yyyy-MM">
						</el-date-picker>
					</div>
					<el-button type="primary" icon="el-icon-search" @click="p.pageNo = 1; 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="feeTypeName"></sa-td>
					<sa-td name="月份" prop="month"></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>
			<el-dialog title="提示" :visible.sync="emodel.visible" width="38%">
				<!-- 日期选择器 -->
				<div class="c-item">
					<label class="c-label">月份：</label>
					<el-date-picker type="month" value-format="yyyy-MM" v-model="emodel.form.exportMonth"
						placeholder="选择月份"></el-date-picker>
				</div>
				<span slot="footer" class="dialog-footer">
					<el-button @click="emodel.visible = false">取 消</el-button>
					<el-button type="primary" @click="sureExport">确 定</el-button>
				</span>
			</el-dialog>
		</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=微信支付)
						isMonth: 1,
						pageNo: 1, // 当前页
						pageSize: 10, // 页大小
						sortType: 0 // 排序方式
					},
					dataCount: 0,
					dataList: [], // 数据集合
					selectMonth: [],
					selectMonthRange: {
						beginMonth: '', //查询开始时间
						endMonth: '', //查询结束时间
					},
					emodel: {
						visible: false,
						form: {
							exportMonth: '', //导出月份
						}
					},
					feeItemList: [],
					tableSum: {
						taxMoneySum: 0,
						taxesSum: 0,
						noTaxMoneySum: 0,
					},
				},
				methods: {
					getFeeItemList() {
						sa.ajax('/TbFeeItem/getList', function(res) {
							this.feeItemList = res.data;
						}.bind(this));
					},
					getSumRol(param) {
						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() {
						if (this.selectMonth != null && this.selectMonth.length != 0) {
							this.selectMonthRange.beginMonth = this.selectMonth[0];
							this.selectMonthRange.endMonth = this.selectMonth[1];
						}
						sa.ajax('/TbFeeStatistics/getSum?beginMonth=' + this.selectMonthRange.beginMonth + "&endMonth=" +
							this.selectMonthRange.endMonth,
							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() {
						if (this.selectMonth != null && this.selectMonth.length != 0) {
							this.selectMonthRange.beginMonth = this.selectMonth[0];
							this.selectMonthRange.endMonth = this.selectMonth[1];
						}

						var beginMonth = this.selectMonthRange.beginMonth;
						var endMonth = this.selectMonthRange.endMonth;
						var feeType = this.p.feeType;
						var str = '';
						if (beginMonth === '' && endMonth === '') {
							str += '所有月份';
						} else {
							str += beginMonth + "至" + endMonth
						}
						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('打印月报表', 'monthStatsPrint.html?beginMonth=' + beginMonth +
								"&endMonth=" + endMonth + "&feeType=" + feeType + "&isMonth=1", '1000px',
								'100%');
						}).catch(() => {

						});
					},
					exportStats() {
						if (this.selectMonth != null && this.selectMonth.length != 0) {
							this.selectMonthRange.beginMonth = this.selectMonth[0];
							this.selectMonthRange.endMonth = this.selectMonth[1];
						}

						var beginMonth = this.selectMonthRange.beginMonth;
						var endMonth = this.selectMonthRange.endMonth;
						var feeType = this.p.feeType;
						var str = '';
						if (beginMonth === '' && endMonth === '') {
							str += '所有月份';
						} else {
							str += beginMonth + "至" + endMonth
						}
						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?beginMonth=' + beginMonth + '&endMonth=' +
								endMonth, sa.removeNull(this.p),
								function(resp) {
									window.open(resp.data);
								}.bind(this));
						}).catch(() => {

						});
					},
					exportFn() {
						Object.assign(this.emodel, {
							visible: true,
						})
					},
					sureExport() {
						if (this.emodel.form.exportMonth == '') {
							sa.msg("请选择月份");
							return;
						}
						sa.ajax('/TbFeeStatistics/export/monthStatistics', this.emodel.form, function(resp) {
							window.open(resp.data);
							this.emodel.visible = false;
						}.bind(this));
					},
					// 刷新
					f5: function() {
						if (this.selectMonth != null && this.selectMonth.length != 0) {
							this.selectMonthRange.beginMonth = this.selectMonth[0];
							this.selectMonthRange.endMonth = this.selectMonth[1];
						}
						sa.ajax('/TbFeeStatistics/getMonth?beginMonth=' + this.selectMonthRange.beginMonth +
							"&endMonth=" + this.selectMonthRange.endMonth,
							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('数据详情', 'month-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.getFeeItemList();
					this.f5();
					sa.onInputEnter();
				}
			})
		</script>
	</body>
</html>