Vxe UI vue vxe-table 实现表格数据分组功能，根据字段数据分组

Vxe UI vue vxe-table 实现表格数据分组功能，根据字段数据分组

实现数据分组功能

基于树结构功能就可以直接实现数据分组功能，代码如下：

<template><div><vxe-button status="primary" @click="listToGroup()">取消分组</vxe-button><vxe-button status="primary" @click="listToGroup('name')">按名称+类型分组</vxe-button><vxe-button status="primary" @click="listToGroup('type')">按类型分组</vxe-button><vxe-button status="primary" @click="listToGroup('date')">按时间分组</vxe-button><vxe-grid v-bind="gridOptions"></vxe-grid></div>
</template><script lang="ts" setup>
import { reactive } from 'vue'
import XEUtils from 'xe-utils'const allList = [{ id: 10000, name: 'Test1', type: 'mp3', size: '1024', date: '2020-08-01' },{ id: 10050, name: 'Test2', type: 'mp4', size: '0', date: '2021-04-01' },{ id: 24300, name: 'Test3', type: 'avi', size: '1024', date: '2020-03-01' },{ id: 20045, name: 'Test4', type: 'html', size: '600', date: '2021-04-01' },{ id: 10053, name: 'Test5', type: 'avi', size: '0', date: '2021-04-01' },{ id: 24330, name: 'Test6', type: 'txt', size: '25', date: '2021-10-01' },{ id: 21011, name: 'Test7', type: 'pdf', size: '512', date: '2020-01-01' },{ id: 22200, name: 'Test8', type: 'js', size: '1024', date: '2021-06-01' },{ id: 23666, name: 'Test9', type: 'xlsx', size: '2048', date: '2020-11-01' },{ id: 23677, name: 'Test9', type: 'js', size: '1024', date: '2021-06-01' },{ id: 23671, name: 'Test3', type: 'js', size: '1024', date: '2021-06-01' },{ id: 23672, name: 'Test6', type: 'js', size: '1024', date: '2021-06-01' },{ id: 23688, name: 'Test8', type: 'js', size: '1024', date: '2021-06-01' },{ id: 23681, name: 'Test2', type: 'js', size: '1024', date: '2021-06-01' },{ id: 23682, name: 'Test8', type: 'js', size: '1024', date: '2021-06-01' },{ id: 24555, name: 'Test1', type: 'avi', size: '224', date: '2020-10-01' },{ id: 24566, name: 'Test2', type: 'js', size: '1024', date: '2021-06-01' },{ id: 24577, name: 'Test1', type: 'js', size: '1024', date: '2021-06-01' }
]const gridOptions = reactive({height: 400,border: 'inner',showOverflow: true,treeConfig: {},columns: [{ field: 'name', title: 'Name', treeNode: true },{ field: 'size', title: 'Size' },{ field: 'type', title: 'Type' },{ field: 'date', title: 'Date' }],data: allList
})let idKey = 1
const handleGroupByField = (list, field) => {const result = []XEUtils.each(XEUtils.groupBy(list, field), (childList, field) => {result.push({id: idKey++,name: field,type: '',size: '',date: '',children: childList})})return result
}const listToGroup = (field?: string) => {gridOptions.data = field ? handleGroupByField(allList, field) : allList
}
</script>

按名称分组

效果如下

按时间分组

效果如下

还可以实现多字段数据分组

效果如下