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