<script>
|
import TimeSelectWithShortCuts from '@/sfc/TimeSelectWithShortCuts.vue';
|
import AreaAndmonitorType from '@/sfc/AreaAndmonitorType.vue';
|
import {useCommonFunction} from '../../utils/common.js';
|
import requetsApi from '@/api/exportExcel/requetsApi.js'
|
import dayjs from 'dayjs';
|
export default {
|
components: {
|
TimeSelectWithShortCuts,
|
AreaAndmonitorType
|
},
|
data() {
|
return {
|
// 当前页
|
currentPage: 1,
|
// 每页条数
|
pageSize: 20,
|
total: 0,
|
// 表格数据
|
tableData: [],
|
isNoData: false,
|
loading: false,
|
|
form: {
|
// 开始时间
|
beginTime: '',
|
// 结束时间
|
endTime: ''
|
}
|
};
|
},
|
setup(){
|
// 引入 百分号比较大小 导出功能
|
const {cmpp,exportToExcel} = useCommonFunction()
|
return {cmpp,exportToExcel}
|
},
|
|
|
mounted() {
|
this.form.name = '';
|
},
|
methods: {
|
// 功能：导出为Excel
|
exportData(){
|
let params ={
|
'beginTime':this.form.beginTime,
|
'endTime': this.form.endTime
|
}
|
requetsApi.fetchAllData(params).then(res => {
|
const data = res.data.data
|
console.log('长度：',data.length);
|
|
const tableColumns = [
|
'name',
|
'mnCode',
|
'lst',
|
'dayAvg',
|
'min',
|
'max',
|
'dayOnline',
|
'dayValid',
|
'dayExceeding',
|
]
|
const excelColumns = [['A1','站点名称'],
|
['B1','设备编号'],['C1','监测日期'],['D1','平均值'],
|
['E1','最小值'],['F1','最大值'],['G1','在线率'],
|
['H1','有效率'],['I1','超标率']]
|
this.exportToExcel(data,tableColumns,excelColumns,'分析表.xlsx')
|
})
|
|
},
|
// 功能：改变表格某个单元格的颜色
|
tableCellClassName({ row, column, rowIndex, columnIndex }) {
|
// 平均值不满足标准时
|
if (columnIndex == 4) {
|
if (row.dayAvg >= 0.8) {
|
return 'warning-row';
|
}
|
}
|
|
// 在线率，有效率 不满足标准时 变颜色
|
if (columnIndex == 7) {
|
if (!this.cmpp(row.dayOnline,'90%')) {
|
return 'red-color';
|
}
|
}
|
if (columnIndex == 8) {
|
if (!this.cmpp(row.dayValid,'90%')) {
|
return 'red-color';
|
}
|
}
|
},
|
// 页大小改变时触发
|
handleSizeChange(val) {
|
this.pageSize = val;
|
|
// 改变每页显示数目时跳到当前页
|
this.handleCurrentChange(1);
|
},
|
|
// 页号改变时触发
|
handleCurrentChange(val) {
|
console.log('当前页为：', val);
|
// 将当前页号给currentPage
|
this.currentPage = val;
|
|
// 页面变化时调用 查询数据函数
|
this.fetchData();
|
},
|
//序号递增
|
indexMethod(index) {
|
return index + 1 + (this.currentPage - 1) * this.pageSize;
|
},
|
|
giveTime(val) {
|
//将中国标准时间转为指定格式(该组件返回的标准时间的格式，所以必须的加这个函数)
|
this.form.beginTime = dayjs(val[0]).format('YYYY-MM-DD HH:mm:ss');
|
this.form.endTime = dayjs(val[1]).format('YYYY-MM-DD HH:mm:ss');
|
},
|
|
// 点击统计按钮
|
fetchData() {
|
console.log(this.form.name);
|
let params = {};
|
params['page'] = this.currentPage;
|
params['pageSize'] = this.pageSize;
|
if (this.form.name) {
|
params['siteName'] = this.form.name;
|
}
|
if (this.form.beginTime) {
|
params['beginTime'] = this.form.beginTime;
|
}
|
if (this.form.endTime) {
|
params['endTime'] = this.form.endTime;
|
}
|
this.loading = true;
|
this.$http
|
.get('/dust/analysistime', { params: params })
|
.then((response) => {
|
this.tableData = response.data.data.rows;
|
console.log(this.tableData);
|
this.loading = false;
|
if (response.data.data.total == 0) {
|
this.isNoData = true;
|
return;
|
}
|
// 移除空数据状态
|
this.isNoData = false;
|
this.total = response.data.data.total;
|
this.loading = false;
|
});
|
}
|
}
|
};
|
</script>
|
|
<template>
|
<div class="search-container">
|
<el-container>
|
<el-main>
|
<el-form :inline="true" :model="form" >
|
<el-form-item>
|
<AreaAndmonitorType></AreaAndmonitorType>
|
</el-form-item>
|
|
<el-form-item>
|
<TimeSelectWithShortCuts
|
@submit-time="giveTime"
|
></TimeSelectWithShortCuts>
|
</el-form-item>
|
<el-form-item>
|
<el-button type="primary" @click="fetchData">统计分析</el-button>
|
<el-button type="warning" @click="exportData">导出</el-button>
|
</el-form-item>
|
</el-form>
|
|
<el-card>
|
<el-empty v-show="isNoData" :image-size="200" />
|
|
<el-table
|
:data="tableData"
|
height="600px"
|
style="width: 100%"
|
v-loading="loading"
|
:cell-class-name="tableCellClassName"
|
>
|
<el-table-column
|
type="index"
|
prop="name"
|
label="序号"
|
:index="indexMethod"
|
fixed
|
show-overflow-tooltip
|
/>
|
<el-table-column prop="name" label="站点名称" show-overflow-tooltip />
|
|
<el-table-column
|
prop="mnCode"
|
label="设备编号"
|
show-overflow-tooltip
|
/>
|
|
<el-table-column
|
prop="lst"
|
label="监测日期"
|
sortable
|
show-overflow-tooltip
|
/>
|
|
<el-table-column
|
prop="dayAvg"
|
label="日平均值"
|
sortable
|
show-overflow-tooltip
|
/>
|
<el-table-column
|
prop="min"
|
label="日最小值"
|
sortable
|
show-overflow-tooltip
|
/>
|
<el-table-column
|
prop="max"
|
label="日最大值"
|
sortable
|
show-overflow-tooltip
|
/>
|
|
<el-table-column
|
prop="dayOnline"
|
label="日在线率"
|
sortable
|
show-overflow-tooltip
|
/>
|
|
<el-table-column
|
prop="dayValid"
|
label="日有效率"
|
sortable
|
show-overflow-tooltip
|
/>
|
|
<el-table-column
|
prop="dayExceeding"
|
label="日超标率"
|
sortable
|
show-overflow-tooltip
|
/>
|
</el-table>
|
|
<el-pagination
|
:page-sizes="[10, 20, 50, 100]"
|
:total="total"
|
layout="total,sizes, prev, pager, next, jumper"
|
v-model:current-page="currentPage"
|
v-model:page-size="pageSize"
|
@update:current-page="handleCurrentChange"
|
@update:page-size="handleSizeChange"
|
/>
|
</el-card>
|
|
</el-main>
|
</el-container>
|
</div>
|
</template>
|
|
<style scoped>
|
:deep().el-table__row .warning-row {
|
background-color: #f7ba1e;
|
}
|
:deep().el-table__row .red-color {
|
background-color: red;
|
}
|
.el-table {
|
color: #000000;
|
}
|
|
</style>
|
