From b097841d8c343edd2b6cb650d0693c502754ce26 Mon Sep 17 00:00:00 2001 From: Your Name <123456> Date: 星期四, 23 六月 2022 12:33:45 +0800 Subject: [PATCH] '导入导出' --- src/views/doublePreventAction/riskLevelManage/riskSourceManage/index.vue | 154 +++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 117 insertions(+), 37 deletions(-) diff --git a/src/views/doublePreventAction/riskLevelManage/riskSourceManage/index.vue b/src/views/doublePreventAction/riskLevelManage/riskSourceManage/index.vue index 433594a..dc01e3b 100644 --- a/src/views/doublePreventAction/riskLevelManage/riskSourceManage/index.vue +++ b/src/views/doublePreventAction/riskLevelManage/riskSourceManage/index.vue @@ -10,20 +10,9 @@ <!-- <el-date-picker v-model="listQuery.endTime" value-format="yyyy-MM-dd HH:mm:ss" type="datetime" placeholder="结束时间"></el-date-picker>--> <!-- </div>--> <div class="basic_search"> - <span>风险源名称:</span> + <span>生产装置名称:</span> <el-input v-model="listQuery.name" class="analyseUnit_input"> </el-input> - </div> - <div class="basic_search"> - <span>风险类型:</span> - <el-select v-model="listQuery.type"> - <el-option - v-for="item in typeList" - :key="item.id" - :value="item.id" - :label="item.name" - ></el-option> - </el-select> </div> <div class="basic_search"> <span>风险等级:</span> @@ -64,9 +53,11 @@ </el-input> </div> - <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="showRiskSourceForm('','新增')">新增</el-button> - </div> + <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="showRiskSourceForm('','新增')">新增</el-button> + <el-button class="filter-item" style="margin-left: 10px;margin-top: 10px" type="primary" @click="showImportDialog()">导入</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 v-loading="listLoading" @@ -77,12 +68,7 @@ highlight-current-row style="width: 100%;" > - <el-table-column label="风险源名称" prop="name" align="center"> - </el-table-column> - <el-table-column label="点位类型" prop="type" align="center"> - <template slot-scope="scope"> - {{ scope.row.type | parseType}} - </template> + <el-table-column label="生产装置名称" prop="name" align="center"> </el-table-column> <el-table-column label="风险等级" prop="level" align="center"> <template slot-scope="scope"> @@ -136,19 +122,9 @@ </div> <el-dialog :title="title" :visible.sync="riskSourceVisible" :modal-append-to-body="false" :close-on-click-modal="false" width="600px"> <el-form ref="riskSourceForm" :rules="riskSourceFormRules" :model="riskSourceForm" label-position="right" label-width="165px"> - <el-form-item label="风险源名称" prop="name"> + <el-form-item label="生产装置名称" prop="name"> <el-input v-model="riskSourceForm.name" class="analyseUnit_input"> </el-input> - </el-form-item> - <el-form-item label="风险源类型" prop="type"> - <el-select v-model="riskSourceForm.type" class="analyseUnit_input"> - <el-option - v-for="item in typeList" - :key="item.id" - :value="item.id" - :label="item.name" - ></el-option> - </el-select> </el-form-item> <el-form-item label="风险等级" prop="level"> <el-select v-model="riskSourceForm.level" class="analyseUnit_input"> @@ -182,6 +158,32 @@ <el-button type="primary" @click="submitRiskSourceForm()">确认</el-button> </div> </el-dialog> + <el-dialog + :visible.sync="importDialogFormVisible" + :modal-append-to-body="false" + :close-on-click-modal="false" + title="用户导入" + width="700px" + > + <el-form + ref="importForm" + label-position="right" + label-width="120px" + style="margin-left:50px;width:500px;" + element-loading-text="导入中..." + > + <el-form-item label="导入文件:"> + <input ref="importLabInput" type="file" accept=".xls, .xlsx" > + </el-form-item> + <el-form-item label="excel参考模板:"> + <el-button type="text" @click="viewHandle">下载模板</el-button> + </el-form-item> + </el-form> + <div slot="footer" class="dialog-footer"> + <el-button @click="importDialogFormVisible = false">取消</el-button> + <el-button type="primary" @click="importToTable()">导入</el-button> + </div> + </el-dialog> </div> </template> @@ -190,7 +192,9 @@ import { computePageCount } from '@/utils' import { getRiskSourceList , addRiskSource , updateRiskSource , deleteById } from '@/api/riskSource' import {getAllDepartment, getDepartmentList} from "../../../../api/departmentManage"; -import {deleteRiskSource} from "../../../../api/riskSource"; +import {deleteRiskSource, exportRiskSource, importRiskSource} from "../../../../api/riskSource"; +import {parseError} from "../../../../utils/messageDialog"; +const exampleFile = require('@/assets/example/riskSource.xlsx') export default { name: 'index', filters: { @@ -242,10 +246,10 @@ title:'', company:'', code:'', + importDialogFormVisible:false, riskSourceVisible:false, riskSourceFormRules:{ name: [{ required: true, message: '风险源名称不能为空', trigger: 'blur' }], - type: [{ required: true, message: '风险源类型不能为空', trigger: 'change' }], level: [{ required: true, message: '风险等级不能为空', trigger: 'change' }], accidentDesc: [{ required: true, message: '可能导致事故的主要原因不能为空', trigger: 'blur' }], location: [{ required: true, message: '区域位置不能为空', trigger: 'blur' }], @@ -259,12 +263,10 @@ level: null, location: "", name: "", - type: null }, listQuery:{ startTime:'', endTime:'', - type:'', status:'', level:'', depId:'', @@ -304,6 +306,9 @@ message:res.data.message, type:'warning' }) + if(res.data.code === '50001'){ + this.riskSourceData = [] + } } }, showRiskSourceForm(value,type){ @@ -321,7 +326,6 @@ level: null, location: "", name: "", - type: null } }else{ this.title = '编辑' @@ -397,6 +401,82 @@ }) }, + + viewHandle() { + window.open(exampleFile, '_blank') + }, + + showImportDialog(){ + this.importDialogFormVisible = true + }, + + importToTable(){ + const formData = new FormData() + const files = this.$refs['importLabInput'].files + if (files && files.length > 0) { + formData.append('file', files[0]) + } + importRiskSource(formData).then((response) => { + const res = response.data + if (res.code == 200) { + this.importDialogFormVisible = false + this.$message({ + message: '导入成功', + type: 'success' + }) + this.getRiskSourceData() + } else { + parseError({ error: res.message, vm: this }) + } + }).catch((error) => { + parseError({ error: error, vm: this }) + }) + }, + + exportToExcel() { + exportRiskSource(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 = [ + 'name', + 'level', + 'accidentDesc', + 'location', + 'depName', + ] + 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])) + }, + + refreshHandle(){ this.listQuery.pageIndex = 1 this.getRiskSourceData() -- Gitblit v1.9.2