From d3d7dcf919eda40a415b6dc744fb0b347d4293a8 Mon Sep 17 00:00:00 2001
From: zmc <zmc_li@foxmail.com>
Date: 星期三, 30 八月 2023 16:10:29 +0800
Subject: [PATCH] 扬尘Vue代码
---
src/views/line_graph/DataRiskRank.vue | 58 ++++++++++++++++++++++++++++++++++++++++++++++------------
1 files changed, 46 insertions(+), 12 deletions(-)
diff --git a/src/views/line_graph/analysisData.vue b/src/views/line_graph/DataRiskRank.vue
similarity index 81%
rename from src/views/line_graph/analysisData.vue
rename to src/views/line_graph/DataRiskRank.vue
index 1475fd1..56824f2 100644
--- a/src/views/line_graph/analysisData.vue
+++ b/src/views/line_graph/DataRiskRank.vue
@@ -3,7 +3,7 @@
// import InputSearch from '../../sfc/InputSearch.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: {
@@ -22,8 +22,8 @@
tableData: [],
isNoData: false,
loading: false,
- begin: '2023-05-01', //寮�濮嬫椂闂�
- end: '2023-05-15', //缁撴潫鏃堕棿
+ // begin: '2023-05-01', //寮�濮嬫椂闂�
+ // end: '2023-05-15', //缁撴潫鏃堕棿
form: {
// 绔欑偣鍚嶇О
@@ -38,9 +38,9 @@
};
},
setup(){
- // 寮曞叆 鐧惧垎鍙锋瘮杈冨ぇ灏�
- const {cmpp} = useCommonFunction()
- return {cmpp}
+ // 寮曞叆 鐧惧垎鍙锋瘮杈冨ぇ灏� 瀵煎嚭鍔熻兘
+ const {cmpp,exportToExcel} = useCommonFunction()
+ return {cmpp,exportToExcel}
},
// watch:{
@@ -56,6 +56,35 @@
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 }) {
// 骞冲潎鍊间笉婊¤冻鏍囧噯鏃�
@@ -159,6 +188,7 @@
</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>
@@ -199,40 +229,40 @@
<el-table-column
prop="dayAvg"
- label="骞冲潎鍊�"
+ label="鏃ュ钩鍧囧��"
sortable
show-overflow-tooltip
/>
<el-table-column
prop="min"
- label="鏈�灏忓��"
+ label="鏃ユ渶灏忓��"
sortable
show-overflow-tooltip
/>
<el-table-column
prop="max"
- label="鏈�澶у��"
+ label="鏃ユ渶澶у��"
sortable
show-overflow-tooltip
/>
<el-table-column
prop="dayOnline"
- label="鍦ㄧ嚎鐜�"
+ label="鏃ュ湪绾跨巼"
sortable
show-overflow-tooltip
/>
<el-table-column
prop="dayValid"
- label="鏈夋晥鐜�"
+ label="鏃ユ湁鏁堢巼"
sortable
show-overflow-tooltip
/>
<el-table-column
prop="dayExceeding"
- label="瓒呮爣鐜�"
+ label="鏃ヨ秴鏍囩巼"
sortable
show-overflow-tooltip
/>
@@ -259,4 +289,8 @@
:deep().el-table__row .red-color {
background-color: red;
}
+.el-table {
+ color: #000000;
+}
+
</style>
--
Gitblit v1.9.3