From f29d0382c54aff9448c9c1cfc77420e06b34022c Mon Sep 17 00:00:00 2001 From: lyfO_o <764716047@qq.com> Date: 星期四, 09 六月 2022 09:26:30 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' into master --- src/views/doublePreventAction/riskLevelManage/analyseUnit/index.vue | 45 ++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 44 insertions(+), 1 deletions(-) diff --git a/src/views/doublePreventAction/riskLevelManage/analyseUnit/index.vue b/src/views/doublePreventAction/riskLevelManage/analyseUnit/index.vue index 57b9f9b..476cf45 100644 --- a/src/views/doublePreventAction/riskLevelManage/analyseUnit/index.vue +++ b/src/views/doublePreventAction/riskLevelManage/analyseUnit/index.vue @@ -31,6 +31,7 @@ <el-button class="filter-item" style="margin-left: 10px;margin-top: 10px" type="primary" icon="el-icon-refresh" @click="refreshHandle">搜索</el-button> <el-button class="filter-item" style="margin-left: 10px;margin-top: 10px" type="primary" icon="el-icon-plus" @click="showAnalyseUnitForm('','新增')">新增</el-button> <el-button class="filter-item" style="margin-left: 10px;margin-top: 10px" type="primary" @click="showDepartmentChart()">图表</el-button> + <el-button class="filter-item" style="margin-left: 10px;margin-top: 10px" type="primary" @click="exportToExcel()">导出</el-button> </div> <div class="table_content"> <el-table @@ -126,7 +127,7 @@ import { addAnalyseUnit, deleteAnalyseUnit, getAnalyseUnitList, updateAnalyseUnit } from '@/api/riskLevelManage' import {getAllDepartment, getDepartmentList} from "../../../../api/departmentManage"; import {safetyInspectionItemName} from "../../../../api/safetySelfInspection"; - import {getDepartmentChart} from "../../../../api/riskLevelManage"; + import {exportAnalyseUnit, getDepartmentChart} from "../../../../api/riskLevelManage"; export default { name: 'index', filters: { @@ -332,6 +333,48 @@ }) }) }, + + exportToExcel() { + exportAnalyseUnit(this.listQuery.filter).then(res=>{ + if (res.data.code === '200') { + if(res.data.result === null ||res.data.result === [] || res.data.result.length === 0){ + this.$message({ + type:'warning', + message:'无数据可导出' + }) + } + else{ + let allData = res.data.result + import('@/vendor/Export2Excel').then((excel) => { + const tHeader = [ + '安全风险分析对象编码', + '安全风险分析单元名称', + '责任部门', + '责任人', + ] + const filterVal = [ + 'hazardCode', + 'riskUnitName', + 'hazardDep', + 'hazardLiablePerson', + ] + const data = this.formatJson(filterVal, allData) + excel.export_json_to_excel({ + header: tHeader, + data, + filename: '安全风险分析单元数据' + }) + }) + + } + } + }) + }, + + formatJson(filterVal, jsonData) { + return jsonData.map(v => filterVal.map(j => v[j])) + }, + personChange(val){ this.analyseUnitForm.hazardLiablePerson = val.realname this.analyseUnitForm.hazardLiablePersonId = val.id -- Gitblit v1.9.2