赞
踩
npm install xe-utils vxe-table@legacy
安装 vxe-table
依赖的插件
npm i xe-utils
我这边是全局引入,可以根据自己情况按需引入
main.js
import Vue from 'vue'
import VXETable from 'vxe-table'
import 'vxe-table/lib/style.css'
Vue.use(VXETable)
// 给 vue 实例挂载内部对象,例如:
// Vue.prototype.$XModal = VXETable.modal
// Vue.prototype.$XPrint = VXETable.print
// Vue.prototype.$XSaveFile = VXETable.saveFile
// Vue.prototype.$XReadFile = VXETable.readFile
我这边使用的 demo 用到了 虚拟滚动
,列筛选
,自定义列内容
,可直接全复制
<!-- 页面 --> <template> <vxe-button @click="clearFilter">清除所有的筛选条件</vxe-button> <!-- 表格--> <div class="main-table-div"> <vxe-table ref="xTable1" size="mini" border max-height="800" :row-config="{ isHover: true, height: 60 }" :column-config="{ resizable: true }" :sort-config="{ trigger: 'cell' }" :data="tableData" align="center" show-overflow :scroll-x="{gt: 30}" :scroll-y="{gt: 300}" :filter-config="{remote: true}" @filter-change="filterChangeEvent" > <vxe-column title="机种名称" field="machineTypeName" width="200" :filters="[{ data: '' }]" :filter-method="filterMethod"> <template #filter="{ $panel, column }"> <!-- 官网给的示例是遍历 filters 属性值数组 ,但是一般搜索只有一个输入框,不需要遍历,尽量减少一点性能消耗,我这边使用固定数组第一个元素--> <!-- <input type="type" v-for="(option, index) in column.filters" :key="index" v-model="option.data" @input="$panel.changeOption($event, !!option.data, option)"> --> <input v-model="column.filters[0].data" type="type" @input="$panel.changeOption($event, !!column.filters[0].data, column.filters[0])"> </template> </vxe-column> <vxe-column title="辅料名称" field="auxiliaryMaterialName" width="200" :filters="[{ data: '' }]" :filter-method="filterMethod"> <template #filter="{ $panel, column }"> <input v-model="column.filters[0].data" type="type" @input="$panel.changeOption($event, !!column.filters[0].data, column.filters[0])"> </template> </vxe-column> <vxe-column title="品牌" field="brand" width="120" :filters="[{ data: '' }]" :filter-method="filterMethod"> <template #filter="{ $panel, column }"> <input v-model="column.filters[0].data" type="type" @input="$panel.changeOption($event, !!column.filters[0].data, column.filters[0])"> </template> </vxe-column> <vxe-column title="规格型号" field="specification" width="150" :filters="[{ data: '' }]" :filter-method="filterMethod"> <template #filter="{ $panel, column }"> <input v-model="column.filters[0].data" type="type" @input="$panel.changeOption($event, !!column.filters[0].data, column.filters[0])"> </template> </vxe-column> <vxe-column title="封装用量(ml/g)" field="packageAmount" width="130" :filters="[{ data: '' }]" :filter-method="filterMethod"> <template #filter="{ $panel, column }"> <input v-model="column.filters[0].data" type="type" @input="$panel.changeOption($event, !!column.filters[0].data, column.filters[0])"> </template> </vxe-column> <vxe-column title="料号" field="materialNumber" width="150" :filters="[{ data: '' }]" :filter-method="filterMethod"> <template #filter="{ $panel, column }"> <input v-model="column.filters[0].data" type="type" @input="$panel.changeOption($event, !!column.filters[0].data, column.filters[0])"> </template> </vxe-column> <vxe-column title="用量(ml/g)" field="dosage" width="120" :filters="[{ data: '' }]" :filter-method="filterMethod"> <template #filter="{ $panel, column }"> <input v-model="column.filters[0].data" type="type" @input="$panel.changeOption($event, !!column.filters[0].data, column.filters[0])"> </template> </vxe-column> <vxe-column title="使用位置" field="usePosition" width="120" :filters="[{ data: '' }]" :filter-method="filterMethod"> <template #filter="{ $panel, column }"> <input v-model="column.filters[0].data" type="type" @input="$panel.changeOption($event, !!column.filters[0].data, column.filters[0])"> </template> </vxe-column> <vxe-column title="其他说明" field="doc" width="120" show-header-overflow show-overflow="title" show-footer-overflow /> <vxe-column title="创建时间" field="addTime" width="180" /> <vxe-column title="创建人" field="addUserName" width="180" :filters="[{ data: '' }]" :filter-method="filterMethod"> <template #filter="{ $panel, column }"> <input v-model="column.filters[0].data" type="type" @input="$panel.changeOption($event, !!column.filters[0].data, column.filters[0])"> </template> </vxe-column> <vxe-column title="最后修改时间" field="updateTime" width="180" /> <vxe-column title="最后修改人" field="updateUserName" width="180" :filters="[{ data: '' }]" :filter-method="filterMethod"> <template #filter="{ $panel, column }"> <input v-model="column.filters[0].data" type="type" @input="$panel.changeOption($event, !!column.filters[0].data, column.filters[0])"> </template> </vxe-column> <vxe-column title="操作" width="200" fixed="right"> <template #default="{ row, rowIndex }"> <div> <el-button size="small" type="text" @click="showChange(row)">修改</el-button> <el-button size="small" type="text" @click="deleteById(row, rowIndex)">删除</el-button> </div> </template> </vxe-column> </vxe-table> </div> </template> <script> export default { name: 'Index', components: {}, props: [], data() { return { tableData: [ { "id": 1006, "machineTypeName": "Cheng Fat", "auxiliaryMaterialName": "Cheng Fat", "brand": "aeaVNGZ7An", "specification": "IhABS5QBlX", "packageAmount": "14LBJIvbgZ", "materialNumber": "Ik8mzrfSWg", "dosage": "4FOZcY3KEF", "usePosition": "DWI5RHkBIY", "doc": "nT65qhLkvI", "addTime": "2017-09-10 00:22:20", "addUserName": "Cheng Fat", "updateTime": "2021-04-16 15:04:40", "updateUserName": "2005-09-24" }, { "id": 1005, "machineTypeName": "Yuen Tsz Hin", "auxiliaryMaterialName": "Yuen Tsz Hin", "brand": "e7fPgpqElq", "specification": "l57klAlUd4", "packageAmount": "6Y4e7xcfWg", "materialNumber": "2FOmQSMC8H", "dosage": "TfdbMdn10B", "usePosition": "vFVoDlRbYI", "doc": "6sArmCG4oP", "addTime": "2002-08-12 05:47:08", "addUserName": "Yuen Tsz Hin", "updateTime": "2009-09-21 22:40:57", "updateUserName": "2001-04-10" }], search: { machineTypeName: '', auxiliaryMaterialName: '', brand: '', specification: '', packageAmount: '', materialNumber: '', dosage: '', usePosition: '', addUserName: '', updateUserName: '' } } }, computed: {}, watch: {}, beforeMount() { }, mounted() { }, created() { }, activated() { }, methods: { /** * 当筛选条件发生变化时会触发该事件,api: https://vxetable.cn/v3/#/table/api?filterName=filter-change * @param {*} column 当前筛选的列属性 * @param {*} property 当前筛选的列名称 * @param {*} values 不知道,忽略 * @param {*} datas 当前表格所有列的筛选数据值列表 * @param {*} filterList 当前表格所有列的筛选数据列表,带列属性和值 * @param {*} $event 事件 */ filterChangeEvent({ column, property, values, datas, filterList, $event }) { console.info('列筛选') // console.info('column', column) // console.info('property', property) // console.info('values', values) // console.info('datas', datas) console.info('filterList', filterList) // console.info('$event', $event) // 先清空之前的搜索对象信息 this.search = { machineTypeName: '', auxiliaryMaterialName: '', brand: '', specification: '', packageAmount: '', materialNumber: '', dosage: '', usePosition: '', addUserName: '', updateUserName: '' } // 遍历当前表所有的筛选数据,赋值给搜索对象 filterList.forEach(item => { // 将当前筛选的列条件数据赋值给 查询对象 console.info(item) // item.property 当前筛选条件的列名称 // item.datas[0] 当前筛选条件的列值 因为 每列的 filters 数组数据 只有一个元素,固定0 this.search[item.property] = item.datas[0] }) console.info('查询参数', this.search) // 将参数传递到后台进行查询 }, // 表格单个列筛选,这个筛选的是 当前表数据,不使用这个 filterMethod({ value, row, column }) { }, // 清空表格所有查询条件 clearFilter() { this.$refs.xTable1.clearFilter() // 清空查询对象 this.search = { machineTypeName: '', auxiliaryMaterialName: '', brand: '', specification: '', packageAmount: '', materialNumber: '', dosage: '', usePosition: '', addUserName: '', updateUserName: '' } // 重新请求服务端查询 } // 删除 deleteById(row, index) { console.info(row, index) }, // 打开修改 弹出框 showChange(row) { console.info(row) } } } </script> <style lang="scss" scoped> </style>
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。