<template>
|
<div>
|
<!-- <el-container> -->
|
<el-card>
|
<el-form :inline="true" class="demo-form-inline">
|
<el-form-item label="店铺名">
|
<el-input v-model="form.name"></el-input>
|
</el-form-item>
|
|
<el-form-item label="设备编号">
|
<el-input v-model="form.number"></el-input>
|
</el-form-item>
|
|
<el-form-item label="站点名称">
|
<el-input v-model="form.dname"></el-input>
|
</el-form-item>
|
|
<el-form-item label="开始日期">
|
<el-date-picker
|
v-model="form.begin"
|
type="datetime"
|
placeholder="选择开始日期时间"
|
format="YYYY-MM-DD HH:mm:ss"
|
value-format="YYYY-MM-DD HH:mm:ss"
|
:shortcuts="shortcuts"
|
/>
|
</el-form-item>
|
|
<el-form-item label="结束日期">
|
<el-date-picker
|
v-model="form.end"
|
type="datetime"
|
placeholder="选择结束日期时间"
|
format="YYYY-MM-DD HH:mm:ss"
|
value-format="YYYY-MM-DD HH:mm:ss"
|
:shortcuts="shortcuts"
|
/>
|
</el-form-item>
|
|
<!-- <el-form-item> -->
|
<div class="button-and-export">
|
<el-button
|
type="primary"
|
@click="handleSubmit"
|
style="margin-left: 10px"
|
>查询</el-button
|
>
|
<el-button type="success" @click="exportDom">导出数据</el-button>
|
</div>
|
<!-- </el-form-item> -->
|
</el-form>
|
</el-card>
|
|
<!-- <el-main> -->
|
<div class="table">
|
<el-table :data="displayData" border="" id="table" ref="table" table-layout="auto" >
|
<!-- <el-table-column prop="id" label="序号" width="60"></el-table-column> -->
|
<el-table-column
|
type="index"
|
label="序号"
|
:index="indexMethod"
|
v-if="showColumn.num"
|
>
|
</el-table-column>
|
<!--绑定一个方法，将返回值赋给index,即表格每行数据的下标-->
|
|
<el-table-column
|
prop="shopName"
|
label="餐饮店"
|
v-if="showColumn.shopname"
|
fixed
|
>
|
</el-table-column>
|
<el-table-column
|
prop="equipmentNumber"
|
label="设备编号"
|
v-if="showColumn.deviceid"
|
>
|
</el-table-column>
|
<el-table-column
|
prop="equipmentName"
|
label="站点名称"
|
v-if="showColumn.devicename"
|
>
|
</el-table-column>
|
<el-table-column
|
prop="provider"
|
label="供应商"
|
v-if="showColumn.privides"
|
></el-table-column>
|
<!-- <el-table-column prop="smokePushDensity" label="进烟浓度mg/m³" width="130"> </el-table-column> -->
|
<el-table-column
|
prop="smokePopDensity"
|
label="油烟浓度(mg)"
|
v-if="showColumn.smog"
|
>
|
</el-table-column>
|
<el-table-column
|
prop="windTurbine"
|
label="风机电"
|
v-if="showColumn.wind"
|
>
|
</el-table-column>
|
<el-table-column
|
prop="purifier"
|
label="净化器"
|
v-if="showColumn.purifier"
|
>
|
</el-table-column>
|
<el-table-column
|
prop="level"
|
label="级别"
|
v-if="showColumn.lever"
|
>
|
</el-table-column>
|
<el-table-column
|
prop="alarmRequired"
|
label="需报警"
|
v-if="showColumn.alarmrequire"
|
>
|
</el-table-column>
|
<el-table-column
|
prop="alarmTriggered"
|
label="已报警"
|
v-if="showColumn.alarmalready"
|
>
|
</el-table-column>
|
<el-table-column
|
prop="attributionTime"
|
label="归属时间"
|
v-if="showColumn.attributiontime"
|
>
|
</el-table-column>
|
<!-- <el-table-column prop="reportingTime" label="上报时间" width="100"> </el-table-column> -->
|
|
<el-table-column fixed="right" width="100" align="center">
|
<template v-slot:header>
|
<i-ep-setting
|
style="font-size: 22px;
|
cursor: pointer"
|
@click="showColumnOption">
|
</i-ep-setting>
|
</template>
|
<!-- <template v-slot:header>
|
<i
|
class="el-icon-setting"
|
style="font-size: 22px; cursor: pointer"
|
@click="showColumnOption"
|
></i>
|
</template> -->
|
</el-table-column>
|
</el-table>
|
|
<!--size-change 是pageSize 改变时会触发的事件,handleSizeChange是事件处理函数
|
current-change 是currentPage 改变时会触发的事件 -->
|
<el-pagination
|
@size-change="handleSizeChange"
|
@current-change="handleCurrentChange"
|
:page-sizes="[10, 20, 50, 100]"
|
:page-size="pageSize"
|
:total="total"
|
layout="total, sizes, prev, pager, next, jumper"
|
></el-pagination>
|
|
<!-- 配置列面板 -->
|
<transition name="fade">
|
<div class="columnOption" v-show="isShowColumn">
|
<div class="content">
|
<div class="head">选择显示字段</div>
|
<div class="body">
|
<el-checkbox v-model="checkList.num" disabled>编号</el-checkbox>
|
<el-checkbox v-model="checkList.shopname">餐饮店</el-checkbox>
|
<el-checkbox v-model="checkList.deviceid">设备编号</el-checkbox>
|
<el-checkbox v-model="checkList.devicename"
|
>站点名称</el-checkbox
|
>
|
<el-checkbox v-model="checkList.privides">供应商</el-checkbox>
|
<el-checkbox v-model="checkList.smog">油烟浓度</el-checkbox>
|
<el-checkbox v-model="checkList.wind">风机电</el-checkbox>
|
<el-checkbox v-model="checkList.purifier">净化器</el-checkbox>
|
<el-checkbox v-model="checkList.lever">级别</el-checkbox>
|
<el-checkbox v-model="checkList.alarmrequire"
|
>需报警</el-checkbox
|
>
|
<el-checkbox v-model="checkList.alarmalready"
|
>已报警</el-checkbox
|
>
|
<el-checkbox v-model="checkList.attributiontime"
|
>归属时间</el-checkbox
|
>
|
</div>
|
|
<div class="footer">
|
<el-button size="small" type="primary" plain @click="saveColumn"
|
>保存列配置</el-button
|
>
|
</div>
|
</div>
|
</div>
|
</transition>
|
</div>
|
<!-- </el-main> -->
|
<!-- </el-container> -->
|
</div>
|
</template>
|
|
<script>
|
import axios from 'axios';
|
import * as XLSX from 'xlsx/xlsx.mjs';
|
// import { saveAs } from 'file-saver';
|
export default {
|
data() {
|
return {
|
form: {
|
//表单中
|
name: '狼来了',
|
// 设备编号
|
number: 'zhuoquan_31011020175012',
|
// 站点名称
|
dname: '',
|
// 开始时间
|
begin: '2023-05-01 00:00:00',
|
// 结束时间
|
end: '2023-05-15 23:59:59'
|
},
|
// defaultEndTime:new Date(2000, 1, 1, 23, 59, 59),
|
isShowColumn: false,
|
tableData: [], //查询的全部数据
|
displayData: [], //每页展示的数据
|
jsonData: [], // 存放后端返回的json数据
|
currentPage: 1, //当前页
|
pageSize: 10, //每页条数
|
total: 0,
|
//日期快捷键
|
shortcuts : [
|
{
|
text: '今天',
|
value: new Date(),
|
},
|
{
|
text: '昨天',
|
value: () => {
|
const date = new Date()
|
date.setTime(date.getTime() - 3600 * 1000 * 24)
|
return date
|
},
|
},
|
{
|
text: '一周前',
|
value: () => {
|
const date = new Date()
|
date.setTime(date.getTime() - 3600 * 1000 * 24 * 7)
|
return date
|
},
|
},
|
],
|
|
checkList: {},
|
showColumn: {
|
num: true,
|
shopname: true,
|
deviceid: true,
|
devicename: true,
|
privides: true,
|
smog: true,
|
wind: true,
|
purifier: true,
|
lever: true,
|
alarmrequire: true,
|
alarmalready: true,
|
attributiontime: true
|
}
|
};
|
},
|
|
mounted() {
|
//发送一部请求，获取数据
|
// axios.get('http://192.168.0.144:8080/web/findall',{params:{}}).then((result) => {
|
// this.tableData = result.data.data;
|
// //this.tableData=result.data.data.rows 当访问/tiaojian 时
|
// this.total = this.tableData.length;
|
// this.handleCurrentChange(1); // 默认显示第一页
|
// });
|
// 默认加载 ‘狼来了’， 05-01到05-15时间段
|
this.handleSubmit()
|
|
if (localStorage.getItem('columnSet')) {
|
this.checkList = JSON.parse(localStorage.getItem('columnSet'));
|
} else {
|
this.checkList = {
|
num: true,
|
shopname: true,
|
deviceid: true,
|
devicename: true,
|
privides: true,
|
smog: true,
|
wind: true,
|
purifier: true,
|
lever: true,
|
alarmrequire: true,
|
alarmalready: true,
|
attributiontime: true
|
};
|
}
|
},
|
methods: {
|
handleSubmit() {
|
if (
|
this.form.begin >= this.form.end &&
|
(this.form.begin != null || this.form.end != null) &&
|
(this.form.begin != '' || this.form.end != '')
|
) {
|
alert('请输入有效的时间段');
|
return;
|
}
|
|
let params = {};
|
if (this.form.name) {
|
params['name'] = this.form.name;
|
}
|
if (this.form.number) {
|
params['number'] = this.form.number;
|
}
|
if (this.form.dname) {
|
params['dname'] = this.form.dname;
|
}
|
if (this.form.begin) {
|
params['begin'] = this.form.begin;
|
}
|
if (this.form.end) {
|
params['end'] = this.form.end;
|
}
|
|
axios
|
.get('http://localhost:8080/web/form', {
|
params: params
|
})
|
.then((response) => {
|
this.tableData = response.data.data;
|
this.total = this.tableData.length;
|
this.handleCurrentChange(1); // 默认显示第一页
|
});
|
},
|
exportDom() {
|
const fields = [
|
'id',
|
'provider',
|
'shopName',
|
'equipmentNumber',
|
'equipmentName',
|
'smokePushDensity',
|
'smokePopDensity',
|
'windTurbine',
|
'purifier',
|
'level',
|
'alarmRequired',
|
'alarmTriggered',
|
'attributionTime',
|
'reportingTime',
|
'dateTime'
|
];
|
const itemsFormatted = this.tableData.map((item) => {
|
const newItem = {};
|
fields.forEach((field) => {
|
newItem[field] = item[field];
|
});
|
return newItem;
|
});
|
// 创建xlsx对象
|
const xls = XLSX.utils.json_to_sheet(itemsFormatted);
|
|
// 编辑表头行 修改表头
|
xls['A1'].v = '编号';
|
xls['B1'].v = '供应商';
|
xls['C1'].v = '餐饮店';
|
xls['D1'].v = '设备编号';
|
xls['E1'].v = '站点名称';
|
xls['F1'].v = '进烟浓度(mg/m^3)';
|
xls['G1'].v = '排烟浓度(mg/m^3)';
|
xls['H1'].v = '风机电(A)';
|
xls['I1'].v = '净化器(A)';
|
xls['J1'].v = '级别';
|
xls['K1'].v = '需报警';
|
xls['L1'].v = '已报警';
|
xls['M1'].v = '归属时间(每10分钟一段)';
|
xls['N1'].v = '上报时间';
|
xls['O1'].v = '数据时间';
|
|
// 创建workbook，并把sheet添加进去
|
const wb = XLSX.utils.book_new();
|
XLSX.utils.book_append_sheet(wb, xls, 'Sheet1');
|
|
// 将workbook转为二进制xlsx文件并下载
|
XLSX.writeFile(wb, '页面数据.xlsx');
|
|
// this.jsonData=this.tableData
|
// const sheetName = '数据表';
|
// const worksheet = XLSX.utils.json_to_sheet(this.jsonData);
|
|
// // 导出Excel文件
|
// const workbook = XLSX.utils.book_new();
|
// XLSX.utils.book_append_sheet(workbook, worksheet, sheetName);
|
// const excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
|
// const fileName = '页面数据.xlsx';
|
// const file = new Blob([excelBuffer], {type: 'application/octet-stream'});
|
// saveAs(file, fileName);
|
},
|
handleSizeChange(val) {
|
this.pageSize = val;
|
this.handleCurrentChange(1); // 改变每页显示数目时跳到第一页
|
},
|
handleCurrentChange(val) {
|
const startIndex = (val - 1) * this.pageSize;
|
const endIndex = startIndex + this.pageSize;
|
this.displayData = this.tableData.slice(startIndex, endIndex);
|
// this.indexMethod(this.pageSize)
|
},
|
//序号递增
|
indexMethod(index) {
|
// let limitpage = this.pageSize; // 每页条数
|
// let curpage = this.currentPage; // 当前页码
|
return index + 1 + (this.currentPage - 1) * this.pageSize;
|
},
|
|
// 隐藏列部分
|
handleClick(row) {
|
console.log(row);
|
},
|
showColumnOption() {
|
this.isShowColumn = true;
|
},
|
saveColumn() {
|
localStorage.setItem('columnSet', JSON.stringify(this.checkList));
|
this.isShowColumn = false;
|
}
|
},
|
watch: {
|
// 监听复选框配置列所有的变化
|
checkList: {
|
handler: function (newnew) {
|
// console.log(newnew);
|
this.showColumn = newnew;
|
// 这里需要让表格重新绘制一下，否则会产生固定列错位的情况
|
this.$nextTick(() => {
|
this.$refs.table.doLayout();
|
});
|
},
|
deep: true,
|
immediate: true
|
}
|
}
|
};
|
</script>
|
|
<style>
|
/* 表格 */
|
.table {
|
/* margin: 10px,0px,10px,10px; */
|
margin: 10px;
|
}
|
.button-and-export {
|
display: flex;
|
justify-content: flex-end; /* 从行尾位置开始排列 */
|
|
}
|
.columnOption {
|
position: fixed;
|
z-index: 20;
|
top: 0;
|
left: 0;
|
width: 100%;
|
height: 100%;
|
background-color: rgba(0, 0, 0, 0.3);
|
display: flex;
|
flex-direction: row-reverse;
|
.content {
|
width: 100px;
|
height: 100%;
|
background-color: rgb(203, 223, 198);
|
.head {
|
width: 100%;
|
height: 44px;
|
border-bottom: 1px solid #000;
|
display: flex;
|
justify-content: center;
|
align-items: center;
|
font-size: 12px;
|
}
|
.body {
|
width: 100%;
|
height: calc(100% - 88px);
|
box-sizing: border-box;
|
padding-top: 10px;
|
overflow-y: auto;
|
.items {
|
width: 100%;
|
height: 100%;
|
overflow-y: auto;
|
display: flex;
|
flex-direction: column;
|
.el-checkbox {
|
width: 100%;
|
height: 28px;
|
line-height: 28px;
|
margin-bottom: 14px;
|
display: inline-block;
|
font-family: PingFang SC;
|
font-style: normal;
|
font-weight: normal;
|
font-size: 14px;
|
color: #000;
|
overflow: hidden;
|
text-overflow: ellipsis;
|
white-space: nowrap;
|
box-sizing: border-box;
|
padding-left: 14px;
|
}
|
.el-checkbox:hover {
|
background-color: #f5f7fa;
|
}
|
}
|
}
|
.footer {
|
width: 100%;
|
height: 44px;
|
border-top: 1px solid #000;
|
display: flex;
|
justify-content: center;
|
align-items: center;
|
}
|
}
|
}
|
/* // 控制淡入淡出效果 */
|
.fade-enter-active,
|
.fade-leave-active {
|
transition: opacity 0.3s;
|
}
|
.fade-enter,
|
.fade-leave-to {
|
opacity: 0;
|
}
|
/* .el-form {
|
margin: 10px;
|
} */
|
</style>
|
