<template> <div class="app-container"> <!--筛选条件--> <div class="search-div"> <el-form ref="selectForm" :inline="true" :model="listQuery" class="form-container"> <el-row> <el-form-item class="selectForm-container-item" prop="keywords"> <el-input v-model.trim="listQuery.projectName" placeholder="所属项目关键字" clearable @change="fetchData"/> </el-form-item> <el-form-item class="selectForm-container-item" prop="keywords"> <el-select v-model="listQuery.devTypeId" filterable placeholder="设备类型" clearable value="" value-key="id" @change="changeModel"> <el-option v-for="item in deviceTypeList" :key="item.id" :label="item.productName" :value="item.id"/> </el-select> </el-form-item> <el-form-item class="selectForm-container-item" prop="keywords"> <el-select v-model="listQuery.productModel" filterable placeholder="设备型号" clearable value=""> <el-option v-for="item in modelList" :key="item.id" :label="item.productModel" :value="item.id"/> </el-select> </el-form-item> <el-form-item class="selectForm-container-item" prop="keywords"> <el-select v-model="listQuery.isSend" filterable placeholder="设备状态" clearable value=""> <el-option key="0" label="生产中" value="0"/> <el-option key="1" label="已发货" value="1"/> <el-option key="2" label="待交付" value="2"/> </el-select> </el-form-item> <el-form-item class="selectForm-container-item" prop="keywords"> <el-input v-model.trim="listQuery.devcode" placeholder="设备编号关键字" clearable @change="fetchData"/> </el-form-item> <el-form-item class="selectForm-container-item" prop="keywords"> <el-input v-model.trim="listQuery.contractorNumber" placeholder="合同编号关键字" clearable @change="fetchData"/> </el-form-item> <el-button class="filter-item" type="primary" icon="el-icon-search" @click="search">查询</el-button> <el-upload :limit="1" :show-file-list="false" :http-request="uploadFile" :file-list="fileList" class="upload-btn" action="string" accept=".xls,.xlsx"> <el-button class="filter-item" style="margin-left: 10px;" type="primary" icon="el-icon-edit">批量导入</el-button> </el-upload> <el-button class="filter-item" style="margin-left: 10px;" type="primary" @click="batchExport">导出设备列表</el-button> </el-row> </el-form> </div> <!--查询结果Table显示--> <div> <el-row class="table-title"> <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col> <download-template :filename="factoryfilename" btnname="导入信息模板"/> </el-row> <el-table v-loading="listLoading" :data="list" class="table" border @selection-change="handleSelectionChange"> <el-table-column :index="indexMethod" align="center" type="index" label="序号" width="55"/> <el-table-column v-for="column in columns" :key="column.value" :label="column.text" :width="column.width" :align="column.align" show-overflow-tooltip> <template slot-scope="scope"> <span :class="column.class">{{ scope.row[column.value] }}</span> </template> </el-table-column> <el-table-column label="操作" align="center" width="80"> <template slot-scope="scope"> <el-button type="text" @click="check(scope.row)">查看</el-button> </template> </el-table-column> </el-table> </div> <!--分页--> <div class="pagination-container"> <el-pagination :current-page="listQuery.offset" :page-sizes="[10,20,30]" :page-size="listQuery.limit" :total="total" align="center" layout="total, sizes, prev, pager, next" @size-change="handleSizeChange" @current-change="handleCurrentChange"/> </div> </div> </template> <script> import { getDeviceListPage, batchImportDevice, batchExportDevice, getModelList } from '@/api/batch' import DownloadTemplate from '@/components/DownloadTemplate/index' import { getDeviceList } from '@/api/factory' export default { name: 'ListDevice', components: { DownloadTemplate }, data() { return { fileList: [], // 批量导入 stateList: [{ value: 0, label: '生产中' }, { value: 1, label: '待发货' }, { value: 2, label: '已发货' }], deviceTypeList: null, // 设备类型列表 modelList: null, // 设备类型列表 factoryfilename: 'deviceImp.xlsx', listQuery: { projectName: '', devTypeId: '', devcode: '', productModel: '', isSend: '', contractorNumber: '', pm: '', offset: 1, limit: 10 }, // 筛选条件 columns: [ { text: '设备编号', value: 'devcode', align: 'center' }, { text: '设备类型', value: 'devTypeName', align: 'center' }, { text: '项目简称', value: 'projectSimpleName', align: 'center' }, { text: '运营商', value: 'operator', align: 'center' }, { text: '卡类型', value: 'cardType', align: 'center' }, { text: 'IMEI号', value: 'imei', align: 'center' }, { text: 'ICCID号', value: 'iccid', align: 'center' }, { text: '设备状况', value: 'isSend', align: 'center' }, { text: '合同编号', value: 'contractorNumber', align: 'center' }, { text: '备注', value: 'descn', align: 'center' } ], // 显示列 list: [], // 列表数据 total: 0, // 数据总数 listLoading: true, // 加载动画 fullscreenLoading: false, // 全屏加载动画 editShow: false, // 是否显示编辑框 dialogFormVisible: false, // 是否显示编辑框 dialogFormVisible1: false // 是否显示编辑框 } }, computed: { }, beforeRouteEnter(to, from, next) { // if (from.name === 'QualityList' && from.path !== '/qualitylist/:id') { // to.meta.keepAlive = true // } else { // to.meta.keepAlive = false // } // console.log(from.name) // console.log(to.meta.keepAlive) next(vm => { // 通过 `vm` 访问组件实例 if (!(from.name === 'QualityList' && from.path !== '/qualitylist/:id')) { // 一定是从A进到B页面才刷新 vm.listQuery = { projectName: '', devTypeId: '', devcode: '', productModel: '', isSend: '', contractorNumber: '', pm: '', offset: 1, limit: 10 } vm.list = [] vm.fetchData()// 是本来写在created里面的各种 } }) }, // beforeRouteLeave(to, from, next) { // if (to.name === 'QualityList') { // from.meta.keepAlive = true // } else { // from.meta.keepAlive = false // } // console.log(from.meta.keepAlive) // next() // }, created() { if (this.$route.params.id !== null) { this.listQuery.projectName = this.$route.params.id } this.fetchDeviceList() this.fetchData()// 获取数据 var lett = this document.onkeydown = function(e) { var key = window.event.keyCode if (key === 13) { lett.fetchData() } } }, activated() { this.fetchData()// 获取数据 }, methods: { changeModel(val) { let obj = {} obj = this.deviceTypeList.find((item) => { return item.id === val }) getModelList(obj.productName).then(response => { this.modelList = response.data this.listQuery.productModel = '' }) }, fetchDeviceList() { getDeviceList().then(response => { this.deviceTypeList = response.data }) }, // 批量导入 uploadFile(param) { // 判断文件大小是否符合要求 const _file = param.file const isLt5M = _file.size / 1024 / 1024 < 5 if (!isLt5M) { this.$message.error('请上传5M以下的excel文件') return false } // 全屏加载动画 const loading = this.$loading({ lock: true, text: '导入中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) // 批量导入上传请求 batchImportDevice(_file).then(res => { loading.close() // 关闭加载动画 if (res.code === 200) { this.$message.success('导入成功') this.fileList = [] this.fetchData() } else { this.$message.error(res.message) } }).catch(err => { loading.close() this.$message.error(err.message) }) this.fileList = [] }, // 批量导出 batchExport() { // 全屏加载动画 const loading = this.$loading({ lock: true, text: '下载中,请稍后...', spinner: 'el-icon-loading', background: 'rgba(0, 0, 0, 0.7)' }) batchExportDevice(this.listQuery).then(res => { loading.close() // 关闭加载动画 const blob = new Blob([res.data]) const downloadElement = document.createElement('a') const href = window.URL.createObjectURL(blob) // 创建下载的链接 downloadElement.href = href downloadElement.download = `批产设备列表.xlsx` // 下载后文件名 document.body.appendChild(downloadElement) downloadElement.click() // 点击下载 document.body.removeChild(downloadElement) // 下载完成移除元素 window.URL.revokeObjectURL(href) // 释放blob对象 }).catch((res) => { loading.close() this.$message.error(res.message) }) }, // 编辑字典信息 edit(row) { this.dialogFormVisible = true this.editShow = true this.$refs.edittask.initDialog('update', this.dialogFormVisible, row) }, check(row) { this.$router.push({ path: '/qualitylist/' + row.devcode }) }, // 查询数据 search() { this.fetchData(false) }, // 获取字典数据 fetchData(isNowPage = true) { this.listLoading = true if (!isNowPage) { // 是否显示当前页,否则跳转第一页 this.listQuery.offset = 1 } getDeviceListPage(this.listQuery).then(response => { this.list = response.data.rows this.total = parseInt(response.data.total) this.listLoading = false }) }, indexMethod(index) { return this.listQuery.limit * (this.listQuery.offset - 1) + index + 1 }, // 改变页容量 handleSizeChange(val) { this.listQuery.limit = val this.fetchData() }, // 改变当前页 handleCurrentChange(val) { this.listQuery.offset = val this.fetchData() }, // 多选触发方法 handleSelectionChange(val) { this.multipleSelection = val } } } </script> <style rel="stylesheet/scss" lang="scss" scoped> $tableTitleHeight:46px; .table{ margin-bottom: 20px; } .pagination-container{ margin-bottom: 50px; } .table-title{ background-color:rgba(243, 243, 243, 1); height: $tableTitleHeight; .title-header{ line-height:$tableTitleHeight; color: #606266; font-size: 15px; i{ margin-left: 5px; margin-right: 5px; } } } .edit_btns{ .edit_btn{ float:right; margin:7px 3px;//为了需要居中显示margin-top和bottom要用$tableTitleHeight减去按钮原高度除以2 } } .upload-btn{ display: inline; } </style>