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 | 500 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 495 insertions(+), 5 deletions(-)
diff --git a/src/views/doublePreventAction/riskLevelManage/riskSourceManage/index.vue b/src/views/doublePreventAction/riskLevelManage/riskSourceManage/index.vue
index 827727e..dc01e3b 100644
--- a/src/views/doublePreventAction/riskLevelManage/riskSourceManage/index.vue
+++ b/src/views/doublePreventAction/riskLevelManage/riskSourceManage/index.vue
@@ -1,13 +1,503 @@
<template>
-
+ <div class="app-container">
+ <div class="filter-container">
+<!-- <div class="basic_search">-->
+<!-- <span>巡检开始时间:</span>-->
+<!-- <el-date-picker v-model="listQuery.startTime" value-format="yyyy-MM-dd HH:mm:ss" type="datetime" placeholder="开始时间"></el-date-picker>-->
+<!-- </div>-->
+<!-- <div class="basic_search">-->
+<!-- <span>巡检结束时间:</span>-->
+<!-- <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>
+ <el-input v-model="listQuery.name" class="analyseUnit_input">
+ </el-input>
+ </div>
+ <div class="basic_search">
+ <span>风险等级:</span>
+ <el-select v-model="listQuery.level">
+ <el-option
+ v-for="item in levelList"
+ :key="item.id"
+ :value="item.id"
+ :label="item.name"
+ ></el-option>
+ </el-select>
+ </div>
+ <div class="basic_search">
+ <span>状态:</span>
+ <el-select v-model="listQuery.status">
+ <el-option
+ v-for="item in statusList"
+ :key="item.id"
+ :value="item.id"
+ :label="item.name"
+ ></el-option>
+ </el-select>
+ </div>
+ <div class="basic_search">
+ <span>所属部门名称:</span>
+ <el-select v-model="listQuery.depId">
+ <el-option
+ v-for="item in departmentList"
+ :key="item.id"
+ :value="item.department"
+ :label="item.department"
+ ></el-option>
+ </el-select>
+ </div>
+ <div class="basic_search">
+ <span>区域位置:</span>
+ <el-input v-model="listQuery.location" class="analyseUnit_input">
+ </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>
+ <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"
+ :key="tableKey"
+ :data="riskSourceData"
+ border
+ fit
+ highlight-current-row
+ style="width: 100%;"
+ >
+ <el-table-column label="生产装置名称" prop="name" align="center">
+ </el-table-column>
+ <el-table-column label="风险等级" prop="level" align="center">
+ <template slot-scope="scope">
+ {{ scope.row.level | parseLevel}}
+ </template>
+ </el-table-column>
+ <el-table-column label="可能导致的主要事故类型" prop="accidentDesc" align="center">
+ </el-table-column>
+ <el-table-column label="区域位置" prop="location" align="center">
+ </el-table-column>
+ <el-table-column label="所属单位" prop="depName" align="center">
+ </el-table-column>
+ <el-table-column label="创建人" prop="createUname" align="center">
+ </el-table-column>
+ <el-table-column label="创建时间" prop="createTime" align="center">
+ </el-table-column>
+ <el-table-column label="最后修改人" prop="editUname" align="center">
+ </el-table-column>
+ <el-table-column label="最后修改时间" prop="editTime" align="center">
+ </el-table-column>
+ <el-table-column label="状态" prop="status" align="center">
+ <template slot-scope="scope">
+ <div v-for="item in statusList">
+ <div v-show="item.id === scope.row.status">
+ <el-tag :type="scope.row.status === 1 ? 'success' : (scope.row.status === 2 ? 'warning' : 'danger')">{{item.name}}</el-tag>
+ </div>
+ </div>
+ </template>>
+ </el-table-column>
+ <el-table-column label="操作" align="center" width="280" class-name="small-padding fixed-width">
+ <template slot-scope="scope">
+ <el-button type="text" @click="showRiskSourceForm(scope.row,'编辑')">编辑</el-button>
+ <el-button type="text" style="color: red" @click="deleteById(scope.row)">删除</el-button>
+ </template>
+ </el-table-column>
+ </el-table>
+ <br>
+ <el-pagination
+ v-show="recordTotal>0"
+ :current-page="listQuery.pageIndex"
+ :page-sizes="[10, 20, 30, 50]"
+ :page-size="listQuery.pageSize"
+ :total="recordTotal"
+ layout="total, sizes, prev, pager, next, jumper"
+ background
+ style="float:right;"
+ @size-change="handleSizeChange"
+ @current-change="handleCurrentChange"
+ />
+ <br>
+ </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-input v-model="riskSourceForm.name" class="analyseUnit_input">
+ </el-input>
+ </el-form-item>
+ <el-form-item label="风险等级" prop="level">
+ <el-select v-model="riskSourceForm.level" class="analyseUnit_input">
+ <el-option
+ v-for="item in levelList"
+ :key="item.id"
+ :value="item.id"
+ :label="item.name"
+ ></el-option>
+ </el-select>
+ </el-form-item>
+ <el-form-item label="可能导致事故的主要原因" prop="accidentDesc">
+ <el-input v-model="riskSourceForm.accidentDesc" class="analyseUnit_input"></el-input>
+ </el-form-item>
+ <el-form-item label="区域位置" prop="location">
+ <el-input v-model="riskSourceForm.location" class="analyseUnit_input"></el-input>
+ </el-form-item>
+ <el-form-item label="所属部门" prop="depId">
+ <el-select v-model="riskSourceForm.depId" class="analyseUnit_input">
+ <el-option
+ v-for="item in departmentList"
+ :key="item.id"
+ :value="item.id"
+ :label="item.department"
+ ></el-option>
+ </el-select>
+ </el-form-item>
+ </el-form>
+ <div align="right">
+ <el-button @click="riskSourceVisible = false">取消</el-button>
+ <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>
<script>
- export default {
- name: "index"
+import { mapGetters } from 'vuex'
+import { computePageCount } from '@/utils'
+import { getRiskSourceList , addRiskSource , updateRiskSource , deleteById } from '@/api/riskSource'
+import {getAllDepartment, getDepartmentList} from "../../../../api/departmentManage";
+import {deleteRiskSource, exportRiskSource, importRiskSource} from "../../../../api/riskSource";
+import {parseError} from "../../../../utils/messageDialog";
+const exampleFile = require('@/assets/example/riskSource.xlsx')
+export default {
+ name: 'index',
+ filters: {
+ parseType(type){
+ if(type === 1){
+ return "设备、设施"
+ }else{
+ return "作业活动"
+ }
+ },
+ parseLevel(level){
+ switch(level){
+ case 1 : return '低风险';break;
+ case 2 : return '一般风险';break;
+ case 3 : return '较大风险';break;
+ case 4 : return '重大风险';break;
+ default : break;
+
+ }
+ },
+ parseStatus(status){
+ if(status === 1) {
+ return '有效'
+ }else if(status === 2){
+ return '无效'
+ }else{
+ return '删除'
+ }
+ }
+ },
+ computed: {
+ ...mapGetters([
+ 'userType'
+ ])
+ },
+ data() {
+ return {
+ tableKey: 0,
+ riskSourceData: [],
+ departmentList:[],
+ typeList:[{id:1,name:'设备、设施'},{id:2,name:'作业活动'}],
+ levelList:[{id:1,name:'低风险'},{id:2,name:'一般风险'},{id:3,name:'较大风险'},{id:4,name:'重大风险'}],
+ statusList:[{id:1,name:'有效'},{id:2,name:'无效'},{id:3,name:'删除'},],
+ listLoading: false,
+ pageSize: 10,
+ recordTotal: 0,
+ currentPage: 1,
+ pageTotal: 0,
+ title:'',
+ company:'',
+ code:'',
+ importDialogFormVisible:false,
+ riskSourceVisible:false,
+ riskSourceFormRules:{
+ name: [{ required: true, message: '风险源名称不能为空', trigger: 'blur' }],
+ level: [{ required: true, message: '风险等级不能为空', trigger: 'change' }],
+ accidentDesc: [{ required: true, message: '可能导致事故的主要原因不能为空', trigger: 'blur' }],
+ location: [{ required: true, message: '区域位置不能为空', trigger: 'blur' }],
+ depId: [{ required: true, message: '所属部门不能为空', trigger: 'change' }],
+ },
+ riskSourceForm:{
+ accidentDesc: "",
+ depId: null,
+ editUid: null,
+ id: null,
+ level: null,
+ location: "",
+ name: "",
+ },
+ listQuery:{
+ startTime:'',
+ endTime:'',
+ status:'',
+ level:'',
+ depId:'',
+ depName:'',
+ location:'',
+ pageIndex:1,
+ pageSize:10,
+ name:'',
+ },
+ }
+ },
+ created() {
+ this.getRiskSourceData()
+ this.getDepartment()
+ },
+ methods: {
+ async getRiskSourceData(){
+ this.listLoading = true
+ let res = await getRiskSourceList(this.listQuery)
+ if(res.data.code === '200'){
+ this.recordTotal = JSON.parse(res.data.message).totalCount
+ this.riskSourceData = res.data.result
+ }else{
+ this.$message({
+ message:res.data.message,
+ type:'warning'
+ })
+ }
+ this.listLoading = false
+ },
+ async getDepartment(){
+ let res = await getDepartmentList({pageSize:1000,pageIndex:1})
+ if(res.data.code === '200'){
+ this.departmentList = res.data.result.result
+ }else{
+ this.$message({
+ message:res.data.message,
+ type:'warning'
+ })
+ if(res.data.code === '50001'){
+ this.riskSourceData = []
+ }
+ }
+ },
+ showRiskSourceForm(value,type){
+ this.riskSourceVisible = true
+ this.$nextTick(() =>{
+ this.$refs["riskSourceForm"].clearValidate()
+ })
+ if(type === '新增'){
+ this.title = '新增'
+ this.riskSourceForm = {
+ accidentDesc: "",
+ depId: null,
+ editUid: null,
+ id: null,
+ level: null,
+ location: "",
+ name: "",
+ }
+ }else{
+ this.title = '编辑'
+ for( let key in this.riskSourceForm){
+ this.riskSourceForm[key] = JSON.parse(JSON.stringify(value))[key]
+ }
+ }
+ },
+ submitRiskSourceForm(){
+ this.$refs["riskSourceForm"].validate((valid) =>{
+ if(valid){
+ if(this.title === '新增'){
+ addRiskSource(this.riskSourceForm).then((res)=>{
+ if(res.data.code === '200'){
+ this.riskSourceVisible = false
+ this.getRiskSourceData()
+ this.$notify({
+ type:'success',
+ duration:2000,
+ message:'新增成功',
+ title:'成功'
+ })
+ }else{
+ this.$message({
+ type:'warning',
+ message:res.data.message
+ })
+ }
+ })
+ }else{
+ updateRiskSource(this.riskSourceForm).then((res)=>{
+ if(res.data.code === '200'){
+ this.riskSourceVisible = false
+ this.getRiskSourceData()
+ this.$notify({
+ type:'success',
+ duration:2000,
+ title:'成功',
+ message:'编辑成功'
+ })
+ }else{
+ this.$message({
+ type:'warning',
+ message:res.data.message
+ })
+ }
+ })
+ }
+ }else{
+ this.$message({
+ type:'warning',
+ message:'请完善基本信息'
+ })
+ }
+ })
+
+ },
+ deleteById(val){
+ this.$confirm('删除此条信息，是否继续','提示',{
+ confirmButtonText:'确定',
+ cancelButtonText:'取消',
+ type:'warning',
+ }).then(()=> {
+ deleteRiskSource({id:val.id}).then( ()=>{
+ this.getRiskSourceData()
+ this.$notify({
+ title:'成功',
+ message:'删除成功',
+ type:'success',
+ duration:2000,
+ })
+ })
+ })
+ },
+
+
+ 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()
+ },
+ handleSizeChange(val){
+ this.listQuery.pageSize = val
+ this.getRiskSourceData()
+ },
+ handleCurrentChange(val){
+ this.listQuery.pageIndex = val
+ this.getRiskSourceData()
+ },
}
+}
</script>
-
<style scoped>
-
+.basic_search{
+ display:inline-block;
+ padding-bottom: 10px;
+}
+.analyseUnit_input{
+ width:300px;
+}
</style>
--
Gitblit v1.9.2