'导入导出'

Your Name

2022-06-23 b097841d8c343edd2b6cb650d0693c502754ce26

 src/views/doublePreventAction/riskLevelManage/riskSourceManage/index.vue

@@ -1,29 +1,18 @@
<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-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>
                <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">
@@ -131,24 +117,14 @@
                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-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,6 +192,9 @@
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: {
@@ -241,9 +246,14 @@
            title:'',
            company:'',
            code:'',
            importDialogFormVisible:false,
            riskSourceVisible:false,
            riskSourceFormRules:{
                name: [{ required: true, message: '风险名称不能为空', trigger: 'blur' }],
                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: "",
@@ -253,12 +263,10 @@
                level: null,
                location: "",
                name: "",
                type: null
            },
            listQuery:{
                startTime:'',
                endTime:'',
                type:'',
                status:'',
                level:'',
                depId:'',
@@ -298,6 +306,9 @@
                    message:res.data.message,
                    type:'warning'
                })
                if(res.data.code === '50001'){
                    this.riskSourceData = []
                }
            }
        },
        showRiskSourceForm(value,type){
@@ -315,7 +326,6 @@
                    level: null,
                    location: "",
                    name: "",
                    type: null
                }
            }else{
                this.title = '编辑'
@@ -379,7 +389,7 @@
                cancelButtonText:'取消',
                type:'warning',
            }).then(()=> {
                deleteAnalyseUnit({id:val.id}).then( ()=>{
                deleteRiskSource({id:val.id}).then( ()=>{
                    this.getRiskSourceData()
                    this.$notify({
                        title:'成功',
@@ -391,7 +401,84 @@
            })
        },


        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){
@@ -411,6 +498,6 @@
    padding-bottom: 10px;
}
.analyseUnit_input{
    width:200px;
    width:300px;
}
</style>