From cd79b3bfdbc33ffa79fefcf5d6fde287a1c05c2f Mon Sep 17 00:00:00 2001
From: panzy <225@qq.com>
Date: Sat, 21 May 2022 11:58:19 +0800
Subject: [PATCH] 表格添加loding转圈 隐患汇总添加导出
---
src/views/summaryPotentialSafetyHzards/index.vue | 88 +++++++++++++++++++++++++++++++------------
1 files changed, 63 insertions(+), 25 deletions(-)
diff --git a/src/views/summaryPotentialSafetyHzards/index.vue b/src/views/summaryPotentialSafetyHzards/index.vue
index 4f953f9..19e71cf 100644
--- a/src/views/summaryPotentialSafetyHzards/index.vue
+++ b/src/views/summaryPotentialSafetyHzards/index.vue
@@ -67,26 +67,30 @@
</el-select>
</el-form-item>
</div>
- <el-form-item label="统计类别">
- <el-radio-group v-model="form.x_axis" style="padding: 0px 0;">
- <el-radio label="ht_branch">按隐患部门</el-radio>
- <el-radio label="ht_typesub">按专业</el-radio>
- <el-radio label="ht_level">按级别</el-radio>
- <el-radio label="checktype">按检查类别</el-radio>
- <el-radio label="ht_community">按检查单位（上级单位）</el-radio>
- <el-radio label="check_branch">按检查单位（本部单位）</el-radio>
- </el-radio-group>
- </el-form-item>
- <el-form-item label="汇总类别">
- <el-radio-group v-model="form.y_axis">
- <el-radio label="ht_branch">按隐患部门</el-radio>
- <el-radio label="ht_typesub">按专业</el-radio>
- <el-radio label="ht_level">按级别</el-radio>
- <el-radio label="checktype">按检查类别</el-radio>
- <el-radio label="ht_community">按检查单位（上级单位）</el-radio>
- <el-radio label="check_branch">按检查单位（本部单位）</el-radio>
- </el-radio-group>
- </el-form-item>
+ <el-row>
+ <el-form-item label="统计类别">
+ <el-radio-group v-model="form.x_axis" style="padding: 0px 0;">
+ <el-radio label="ht_branch">按隐患部门</el-radio>
+ <el-radio label="ht_typesub">按专业</el-radio>
+ <el-radio label="ht_level">按级别</el-radio>
+ <el-radio label="checktype">按检查类别</el-radio>
+ <el-radio label="ht_community">按检查单位（上级单位）</el-radio>
+ <el-radio label="check_branch">按检查单位（本部单位）</el-radio>
+ </el-radio-group>
+ </el-form-item>
+ </el-row>
+ <el-row>
+ <el-form-item label="汇总类别">
+ <el-radio-group v-model="form.y_axis">
+ <el-radio label="ht_branch">按隐患部门</el-radio>
+ <el-radio label="ht_typesub">按专业</el-radio>
+ <el-radio label="ht_level">按级别</el-radio>
+ <el-radio label="checktype">按检查类别</el-radio>
+ <el-radio label="ht_community">按检查单位（上级单位）</el-radio>
+ <el-radio label="check_branch">按检查单位（本部单位）</el-radio>
+ </el-radio-group>
+ </el-form-item>
+ </el-row>
</div>
<div class="center" style="text-align: center;padding-top: 10px;">
<el-form-item label="检查时间：">
@@ -102,14 +106,15 @@
<el-button class="btn" size="small" type="primary" @click="queryData"
>汇总
</el-button>
- <el-button class="btn" size="small" type="primary" @click="close()"
+ <el-button class="btn" size="small" type="primary" @click="exportData()"
>导出Excel
</el-button>
</el-form-item>
</div>
</el-form>
- <el-table
+ <el-table id="out-table"
:data="tableData"
+ v-loading="loading"
style="width: 100%">
<el-table-column align="center" label="众泰煤焦化-安全隐患台帐">
<el-table-column
@@ -152,7 +157,8 @@
} from "@/api/sgyhpczl/initSelect";
import {danger_summary} from "@/api/sgyhpczl/summaryPotentialSafetyHzards";
-
+import FileSaver from "file-saver";
+import XLSX from "xlsx";
export default {
name: "index",
data() {
@@ -199,6 +205,7 @@
YHBMList: [],
YHJBList: [],
YHZTList: [],
+ loading: false,
startDate: "",
endDate: "",
}
@@ -325,7 +332,9 @@
}
selectData.push(timeSearchCloumn)
requestData.query_condition = selectData;
+ this.loading = true;
danger_summary(requestData).then(res => {
+ this.loading = false;
if (res.data.ok == 1) {
this.tableData = res.data.data
} else {
@@ -369,7 +378,7 @@
return data.value
},
- showYHList(row,item){
+ showYHList(row, item) {
var searchData = {};
searchData[this.form.x_axis] = item.x_label;
searchData[this.form.y_axis] = row.y_label;
@@ -394,6 +403,34 @@
path: "/summaryList",
query: {"searchData": searchData}
})
+ },
+ exportData(){
+ var xlsxParam = { raw: true };
+ /* 从表生成工作簿对象 */
+ var wb = XLSX.utils.table_to_book(
+ document.querySelector("#out-table"),
+ xlsxParam
+ );
+ /* 获取二进制字符串作为输出 */
+ var wbout = XLSX.write(wb, {
+ bookType: "xlsx",
+ bookSST: true,
+ type: "array",
+ });
+ try {
+ FileSaver.saveAs(
+ //Blob 对象表示一个不可变、原始数据的类文件对象。
+ //Blob 表示的不一定是JavaScript原生格式的数据。
+ //File 接口基于Blob，继承了 blob 的功能并将其扩展使其支持用户系统上的文件。
+ //返回一个新创建的 Blob 对象，其内容由参数中给定的数组串联组成。
+ new Blob([wbout], { type: "application/octet-stream" }),
+ //设置导出文件名称
+ "安全隐患汇总.xlsx"
+ );
+ } catch (e) {
+ if (typeof console !== "undefined") console.log(e, wbout);
+ }
+ return wbout;
}
}
@@ -460,7 +497,8 @@
/deep/ .el-date-editor .el-range-separator {
width: auto;
}
-.clickSpan:hover{
+
+.clickSpan:hover {
cursor: pointer;
}
--
Gitblit v1.9.2