| | |
| | | </div> |
| | | </el-form> |
| | | <el-table id="out-table" |
| | | :data="tableData" |
| | | v-loading="loading" |
| | | style="width: 100%"> |
| | | :data="tableData" |
| | | v-loading="loading" |
| | | style="width: 100%"> |
| | | <el-table-column align="center" label="众泰煤焦化-安全隐患台帐"> |
| | | <el-table-column |
| | | prop="y_label" |
| | |
| | | import {danger_summary} from "@/api/sgyhpczl/summaryPotentialSafetyHzards"; |
| | | import FileSaver from "file-saver"; |
| | | import XLSX from "xlsx"; |
| | | |
| | | export default { |
| | | name: "index", |
| | | data() { |
| | |
| | | |
| | | showYHList(row, item) { |
| | | var searchData = {}; |
| | | searchData[this.form.x_axis] = item.x_label; |
| | | searchData[this.form.y_axis] = row.y_label; |
| | | console.log(item) |
| | | if (item.x_label != null && item.x_label != "合计") { |
| | | searchData[this.form.x_axis] = item.x_label; |
| | | } |
| | | if (row.y_label != null && row.y_label != "合计") { |
| | | searchData[this.form.y_axis] = row.y_label; |
| | | } |
| | | let requestData = {}; |
| | | let selectData = [] |
| | | for (const queryElement in this.form) { |
| | |
| | | query: {"searchData": searchData} |
| | | }) |
| | | }, |
| | | exportData(){ |
| | | var xlsxParam = { raw: true }; |
| | | exportData() { |
| | | var xlsxParam = {raw: true}; |
| | | /* 从表生成工作簿对象 */ |
| | | var wb = XLSX.utils.table_to_book( |
| | | document.querySelector("#out-table"), |
| | |
| | | //Blob 表示的不一定是JavaScript原生格式的数据。 |
| | | //File 接口基于Blob,继承了 blob 的功能并将其扩展使其支持用户系统上的文件。 |
| | | //返回一个新创建的 Blob 对象,其内容由参数中给定的数组串联组成。 |
| | | new Blob([wbout], { type: "application/octet-stream" }), |
| | | new Blob([wbout], {type: "application/octet-stream"}), |
| | | //设置导出文件名称 |
| | | "安全隐患汇总.xlsx" |
| | | ); |