vxe-table 實現表格資料分組，按指定欄位資料分組

可不简单發表於2024-11-27

實現表格資料分組，按指定欄位資料分組，使用樹結構來實現分組功能。

官網：https://vxetable.cn

<template>
  <div>
    <vxe-grid v-bind="gridOptions"></vxe-grid>
  </div>
</template>

<script>
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' }
]
export default {
  data () {
    const gridOptions = {
      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
    }
    return {
      gridOptions,
      idKey: 1
    }
  },
  methods: {
    handleGroupByField (list, field) {
      const result = []
      XEUtils.each(XEUtils.groupBy(list, field), (childList, field) => {
        result.push({
          id: this.idKey++,
          name: field,
          type: '',
          size: '',
          date: '',
          children: childList
        })
      })
      return result
    },
    listToGroup (field) {
      this.gridOptions.data = field ? this.handleGroupByField(allList, field) : allList
    }
  },
  created() {
    this.listToGroup('date')
  }
}
</script>

相關文章