vxe-table 实现服务端筛选、分页筛选
查看官网：https://vxetable.cn
gitbub：https://github.com/x-extends/vxe-table
gitee：https://gitee.com/x-extends/vxe-table
配置 filter-config.remote 和 filter-change 与 clear-all-filter 事件，实现服务端筛选
<template><div><vxe-grid v-bind="gridOptions" v-on="gridEvents"></vxe-grid></div>
</template><script setup>
import { ref, reactive } from 'vue'const queryFilterConfs = ref([])const pageVO = reactive({currentPage: 1,pageSize: 10,total: 0
})const gridOptions = reactive({border: true,loading: false,height: 400,columnConfig: {resizable: true},filterConfig: {remote: true},pagerConfig: pageVO,columns: [{ type: 'seq', width: 70 },{ field: 'name', title: 'Name', minWidth: 300 },{field: 'role',title: 'Role',width: 240,filters: [{ label: 'Develop', value: 'Develop' },{ label: 'Test', value: 'Test' },{ label: 'PM', value: 'PM' },{ label: 'Designer', value: 'Designer' }]},{field: 'sex',title: 'Sex',width: 200,filters: [{ label: 'Man', value: 'Man' },{ label: 'Women', value: 'Women' }]},{ field: 'age', title: 'Age', width: 200 },{ field: 'address', title: 'Address', width: 300 }],data: []
})
// 模拟后端接口
const loadList = () => {const mockList = [{ id: 10001, name: 'Test1', role: 'Develop', sex: 'Man', age: 28, num: '3.8', num2: '3.8', address: 'test abc' },{ id: 10002, name: 'Test2', role: 'Test', sex: 'Women', age: 22, num: '511', num2: '511', address: 'Guangzhou' },{ id: 10003, name: 'Test3', role: 'PM', sex: 'Man', age: 32, num: '12.8', num2: '12.8', address: 'Shanghai' },{ id: 10004, name: 'Test4', role: 'Designer', sex: 'Women', age: 23, num: '103', num2: '103', address: 'test abc' },{ id: 10005, name: 'Test5', role: 'Develop', sex: 'Women', age: 30, num: '56', num2: '56', address: 'Shanghai' },{ id: 10006, name: 'Test6', role: 'Designer', sex: 'Women', age: 21, num: '49', num2: '49', address: 'test abc' },{ id: 10007, name: 'Test7', role: 'Test', sex: 'Man', age: 29, num: '400.9', num2: '400.9', address: 'test abc' },{ id: 10008, name: 'Test8', role: 'Develop', sex: 'Man', age: 48, num: '5000', num2: '5000', address: 'test abc' },{ id: 10009, name: 'Test9', role: 'Develop', sex: 'Man', age: 35, num: '5000', num2: '5000', address: 'test abc' },{ id: 10010, name: 'Test10', role: 'Develop', sex: 'Women', age: 29, num: '5000', num2: '5000', address: 'test abc' },{ id: 10011, name: 'Test11', role: 'Develop', sex: 'Man', age: 35, num: '5000', num2: '5000', address: 'test abc' },{ id: 10012, name: 'Test12', role: 'Test', sex: 'Man', age: 35, num: '5000', num2: '5000', address: 'test abc' },{ id: 10013, name: 'Test13', role: 'Develop', sex: 'Man', age: 23, num: '5000', num2: '5000', address: 'test abc' },{ id: 10014, name: 'Test14', role: 'Develop', sex: 'Women', age: 21, num: '5000', num2: '5000', address: 'test abc' },{ id: 10015, name: 'Test15', role: 'Develop', sex: 'Women', age: 35, num: '5000', num2: '5000', address: 'test abc' },{ id: 10016, name: 'Test16', role: 'Test', sex: 'Man', age: 35, num: '5000', num2: '5000', address: 'test abc' },{ id: 10017, name: 'Test17', role: 'Develop', sex: 'Man', age: 28, num: '5000', num2: '5000', address: 'test abc' },{ id: 10018, name: 'Test18', role: 'PM', sex: 'Women', age: 35, num: '5000', num2: '5000', address: 'test abc' },{ id: 10019, name: 'Test19', role: 'Designer', sex: 'Man', age: 35, num: '5000', num2: '5000', address: 'test abc' },{ id: 10020, name: 'Test20', role: 'Develop', sex: 'Man', age: 35, num: '5000', num2: '5000', address: 'test abc' },{ id: 10021, name: 'Test21', role: 'Designer', sex: 'Man', age: 51, num: '5000', num2: '5000', address: 'test abc' },{ id: 10022, name: 'Test22', role: 'PM', sex: 'Women', age: 64, num: '5000', num2: '5000', address: 'test abc' },{ id: 10023, name: 'Test23', role: 'PM', sex: 'Man', age: 67, num: '5000', num2: '5000', address: 'test abc' },{ id: 10024, name: 'Test24', role: 'Develop', sex: 'Women', age: 45, num: '5000', num2: '5000', address: 'test abc' },{ id: 10023, name: 'Test25', role: 'PM', sex: 'Man', age: 35, num: '5000', num2: '5000', address: 'test abc' },{ id: 10025, name: 'Test23', role: 'Develop', sex: 'Man', age: 59, num: '5000', num2: '5000', address: 'test abc' },{ id: 10026, name: 'Test26', role: 'Designer', sex: 'Women', age: 53, num: '5000', num2: '5000', address: 'test abc' },{ id: 10027, name: 'Test27', role: 'Develop', sex: 'Man', age: 35, num: '5000', num2: '5000', address: 'test abc' },{ id: 10028, name: 'Test28', role: 'Designer', sex: 'Man', age: 30, num: '5000', num2: '5000', address: 'test abc' },{ id: 10029, name: 'Test29', role: 'Test', sex: 'Man', age: 25, num: '5000', num2: '5000', address: 'test abc' }]gridOptions.loading = trueconst searchConfs = queryFilterConfs.valuesetTimeout(() => {const { pageSize, currentPage } = pageVOconst result = searchConfs.length? mockList.filter(item => {return searchConfs.every(fItem => {const callValue = item[fItem.field]return fItem.vals.some(val => `${callValue}`.indexOf(val) > -1)})}): mockListpageVO.total = result.lengthgridOptions.data = result.slice((currentPage - 1) * pageSize, currentPage * pageSize)gridOptions.loading = false}, 300)
}
const gridEvents = {pageChange ({ currentPage, pageSize }) {pageVO.currentPage = currentPagepageVO.pageSize = pageSizeloadList()},filterChange ({ filterList }) {const searchConfs = filterList.map(item => {return {field: item.field,vals: item.values}})queryFilterConfs.value = searchConfspageVO.currentPage = 1loadList()},clearAllFilter () {queryFilterConfs.value = []pageVO.currentPage = 1loadList()}
}
loadList()
</script>
https://gitee.com/x-extends/vxe-table