From c64c8f43ec1a3d88feb1f915fd488040b6358e7d Mon Sep 17 00:00:00 2001
From: shj <1790240199@qq.com>
Date: 星期二, 09 八月 2022 19:04:12 +0800
Subject: [PATCH] Merge branch 'master' of https://sinanoaq.cn:8888/r/gtqtOut
---
src/views/goalManagement/Goalsummary/index.vue | 24 +++++++++++++++++++-----
1 files changed, 19 insertions(+), 5 deletions(-)
diff --git a/src/views/goalManagement/Goalsummary/index.vue b/src/views/goalManagement/Goalsummary/index.vue
index 2104dfd..a345459 100644
--- a/src/views/goalManagement/Goalsummary/index.vue
+++ b/src/views/goalManagement/Goalsummary/index.vue
@@ -7,9 +7,9 @@
<el-input v-model="ruleForm.searchParams.year" placeholder="年度" />
</el-form-item>
</el-col>
- <el-col :span="4">
- <el-form-item>
- <el-tree-select v-model="form.searchParams.departmentId" :data="data" class="w100" placeholder="请选择" />
+ <el-col :span="4" >
+ <el-form-item size="default">
+ <el-tree-select v-model="ruleForm.searchParams.departmentId" :data="data" class="w100" placeholder="请选择" />
</el-form-item>
</el-col>
<el-col :span="4">
@@ -24,10 +24,10 @@
<div class="btns">
<p>汇总日期:2022-07-04 23:00:07</p>
<div>
- <el-button type="primary" size="default" :icon="Download">导出</el-button>
+ <el-button type="primary" size="default" :icon="Download" @click="exportExcel('tab1', '会员明细.xlsx')">导出</el-button>
</div>
</div>
- <el-table :data="tableData" style="width: 100%">
+ <el-table :data="tableData" style="width: 100%" id="tab1">
<el-table-column label="责任部门" align="center">
<template #default="scope">{{ scope.row.departmentId }}</template>
</el-table-column>
@@ -68,6 +68,9 @@
import { ElMessageBox, ElMessage, ElButton, ElInput, TabsPaneContext, FormInstance } from 'element-plus';
import { Plus, Delete, Upload, Download, Refresh, View } from '@element-plus/icons-vue';
import { goalManagementApi } from '/@/api/goalManagement';
+
+import * as XLSX from 'xlsx';
+
export default defineComponent({
components: { ElButton, ElInput },
setup() {
@@ -162,6 +165,16 @@
],
},
];
+
+ const exportExcel = (id:string,name:string) => {
+ let workbook = XLSX.utils.table_to_book(document.getElementById(id)); //需要在table上定义一个id
+ try {
+ XLSX.writeFile(workbook, name);
+ console.log('导出成功!');
+ } catch (e) {
+ console.log('导出失败!');
+ }
+ }
return {
ruleForm,
tableData,
@@ -179,6 +192,7 @@
Download,
Refresh,
View,
+ exportExcel
};
},
});
--
Gitblit v1.9.2