导入

Your Name

2022-08-24 bc2747387df0693aa46a55bb556985aaf881d843

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

@@ -3,16 +3,13 @@
        <div class="filter-container">
            <div class="basic_search">
                <span>事件名称：</span>
                <el-input v-model="listQuery.filter.riskEventName" style="width:200px">
                </el-input>
            </div>
            <div class="basic_search">
                <span>单元名称：</span>
                <el-input v-model="listQuery.filter.riskUnitName" style="width:200px">
                <el-input v-model="listQuery.riskEventName" style="width:200px">
                </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="showRiskEvent('','新增')">新增</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
@@ -24,21 +21,13 @@
                highlight-current-row
                style="width: 100%;"
            >
                <el-table-column label="安全风险分析单元名称" prop="riskAnaUnit" align="center">
                    <template slot-scope="scope">
                        <span>{{scope.row.riskAnaUnit.riskUnitName}}</span>
                    </template>
                </el-table-column>
                <el-table-column label="安全风险事件名称" prop="riskEventName" align="center">
                </el-table-column>
                <el-table-column label="创建人" prop="createBy" align="center">
                </el-table-column>
                <el-table-column label="创建时间" prop="createTime" align="center">
                </el-table-column>
                <el-table-column label="最后修改人" prop="updateBy" align="center">
                </el-table-column>
                <el-table-column label="最后修改时间" prop="updateTime" align="center">
                </el-table-column>
                <el-table-column type="index" label="序号" width="60" />
                <el-table-column prop="riskUnitName" label="安全风险分析单元名称" width="180" show-overflow-tooltip></el-table-column>
                <el-table-column prop="riskEventName" label="安全风险事件名称" width="180" show-overflow-tooltip></el-table-column>
                <el-table-column prop="createByUserName" label="创建人" show-overflow-tooltip></el-table-column>
                <el-table-column prop="gmtCreate" label="创建时间" show-overflow-tooltip></el-table-column>
                <el-table-column prop="lastEditUserName" label="最后修改人" show-overflow-tooltip></el-table-column>
                <el-table-column prop="gmtModitify" label="最后修改时间" show-overflow-tooltip></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="showRiskEvent(scope.row,'编辑')">编辑</el-button>
@@ -49,9 +38,9 @@
            <br>
            <el-pagination
                v-show="recordTotal>0"
                :current-page="currentPage"
                :current-page="listQuery.pageIndex"
                :page-sizes="[10, 20, 30, 50]"
                :page-size="pageSize"
                :page-size="listQuery.pageSize"
                :total="recordTotal"
                layout="total, sizes, prev, pager, next, jumper"
                background
@@ -64,22 +53,48 @@
        <el-dialog :title="title" :visible.sync="riskEventVisible" :modal-append-to-body="false" :close-on-click-modal="false" width="600px">
            <el-form ref="riskEventForm" :rules="riskEventFormRules" :model="riskEventForm" label-position="right" label-width="165px">
                <el-form-item label="安全风险分析单元名称" prop="riskUnitId">
                    <el-select v-model="riskEventForm.riskUnitId" class="analyseUnit_input">
                    <el-select v-model="riskEventForm.riskUnitId" placeholder="请输入安全风险分析单元名称" class="analyseUnit_box">
                        <el-option
                            v-for="item in analyseUnitList"
                            :key="item.id"
                            :key="item.riskUnitName"
                            :value="item.id"
                            :label="item.riskUnitName"
                        ></el-option>
                    </el-select>
                </el-form-item>
                <el-form-item label="安全风险事件名称" prop="riskEventName">
                    <el-input v-model="riskEventForm.riskEventName" class="analyseUnit_input"></el-input>
                    <el-input v-model="riskEventForm.riskEventName" placeholder="请输入安全风险事件名称" class="analyseUnit_box"></el-input>
                </el-form-item>
            </el-form>
            <div  align="right">
                <el-button @click="riskEventVisible = false">取消</el-button>
                <el-button type="primary" @click="submitRiskEvent()">确认</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>
@@ -89,7 +104,13 @@
    import { mapGetters } from 'vuex'
    import { computePageCount } from '@/utils'
    import { addRiskEvent, deleteRiskEvent, getRiskEventList, updateRiskEvent } from '@/api/riskLevelManage'
    import {getAnalyseUnitList} from "../../../../api/riskLevelManage";
    const exampleFile = require('@/assets/example/riskEvent.xlsx')
    import {
        exportRiskEvent, getAllSafetyRiskAnalyseUnitList,
        getAnalyseUnitList,
        importRiskEvent
    } from "../../../../api/riskLevelManage";
    import {parseError} from "../../../../utils/messageDialog";
    export default {
        name: 'index',
        filters: {
@@ -119,6 +140,7 @@
                title:'',
                company:'',
                code:'',
                importDialogFormVisible:false,
                riskEventVisible:false,
                riskEventFormRules:{
                    riskUnitId: [{ required: true, message: '安全风险分析单元名称不能为空', trigger: 'change' }],
@@ -126,23 +148,13 @@

                },
                riskEventForm:{
                    id: "",
                    riskUnitId: "",
                    riskEventName: "",
                    validFlag: true,
                    createTime: "",
                    createBy: "",
                    updateTime: "",
                    updateBy: "",
                    riskAnaUnit: {
                    },
                    riskEventName: null,
                    riskUnitId: null
                },
                listQuery:{
                    pageIndex:1,
                    pageSize:10,
                    filter:{
                        riskEventName:'',
                    }
                    pageIndex: 1,
                    pageSize: 10,
                    riskEventName: null
                },
            }
        },
@@ -155,11 +167,27 @@
                this.listLoading = true
                let res = await getRiskEventList(this.listQuery)
                if(res.data.code === '200'){
                    this.recordTotal = res.data.result.total
                    this.pageSize = res.data.result.size
                    this.pageTotal = computePageCount(res.data.result.total, res.data.result.size)
                    this.currentPage = res.data.result.current
                    this.riskEventData = res.data.result.records
                    if(res.data.data.length === 0 && res.data.count > 0){
                        this.listQuery.pageIndex = 1
                        await this.getData()
                    }else{
                        this.recordTotal = res.data.count
                        this.riskEventData = res.data.data
                    }
                }else{
                    this.$message({
                        message:res.data.message,
                        type:'warning'
                    })
                }
                this.listLoading = false
            },
            async getData(){
                this.listLoading = true
                let res = await getRiskEventList(this.listQuery)
                if(res.data.code === '200'){
                    this.recordTotal = res.data.count
                    this.riskEventData = res.data.data
                }else{
                    this.$message({
                        message:res.data.message,
@@ -169,9 +197,9 @@
                this.listLoading = false
            },
            async getAnalyseUnitData(){
                let res = await getAnalyseUnitList({pageSize:1000,pageIndex:1,filter:{ riskUnitName:''}})
                let res = await getAllSafetyRiskAnalyseUnitList()
                if(res.data.code === '200'){
                    this.analyseUnitList = res.data.result.records
                    this.analyseUnitList = JSON.parse(JSON.stringify(res.data.data))
                }else{
                    this.$message({
                        message:res.data.message,
@@ -187,21 +215,15 @@
                if(type === '新增'){
                    this.title = '新增'
                    this.riskEventForm = {
                        id: "",
                        riskUnitId: "",
                        riskEventName: "",
                        validFlag: true,
                        createTime: "",
                        createBy: "",
                        updateTime: "",
                        updateBy: "",
                        riskAnaUnit: {
                            riskUnitName:""
                        },
                    }
                }else{
                    this.title = '修改'
                    this.riskEventForm = value
                    for( let key in this.riskEventForm){
                        this.riskEventForm[key] = JSON.parse(JSON.stringify(value))[key]
                    }
                    this.riskEventForm.id = JSON.parse(JSON.stringify(value)).id
                }
            },
            submitRiskEvent(){
@@ -258,17 +280,93 @@
                    cancelButtonText:'取消',
                    type:'warning',
                }).then(()=> {
                    deleteRiskEvent({id:val.id}).then( ()=>{
                        this.getRiskEventData()
                        this.$notify({
                            title:'成功',
                            message:'删除成功',
                            type:'success',
                            duration:2000,
                        })
                    deleteRiskEvent({id:val.id}).then( (res)=>{
                        if(res.data.code === '200'){
                            this.getRiskEventData()
                            this.$notify({
                                title:'成功',
                                message:'删除成功',
                                type:'success',
                                duration:2000,
                            })
                        }else{
                            this.$message({
                                type:'warning',
                                message:res.data.message
                            })
                        }
                    })
                })
            },

            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])
                }
                importRiskEvent(formData).then((response) => {
                    const res = response.data
                    if (res.code == 200) {
                        this.importDialogFormVisible = false
                        this.$message({
                            message: '导入成功',
                            type: 'success'
                        })
                        this.getRiskEventData()
                    } else {
                        parseError({ error: res.message, vm: this })
                    }
                }).catch((error) => {
                    parseError({ error: error, vm: this })
                })
            },

            exportToExcel() {
                exportRiskEvent(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 = [
                                    'riskUnitName',
                                    'riskEventName',
                                ]
                                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.getRiskEventData()
            },
@@ -289,6 +387,9 @@
        padding-bottom: 10px;
    }
    .analyseUnit_input{
        width:320px;
        width:200px;
    }
    .analyseUnit_box{
        width:90%;
    }
</style>