<template>
  <div>
    <vxe-grid v-bind="gridOptions"></vxe-grid>
  </div>
</template>
<script setup>
import { reactive } from 'vue'
// 表尾合計(jì)行數(shù)據(jù)（手動(dòng)維護(hù)總計(jì)）
const footerSummaryRow = reactive({
  seq: '總計(jì)',
  num: 0
})
const gridOptions = reactive({
  border: true,
  showOverflow: true,       // 超出顯示省略號(hào)
  showFooter: true,         // 開啟表尾
  height: 500,
  loading: false,
  // 分組聚合配置
  aggregateConfig: {
    groupFields: ['role'],   // 按角色字段分組
    // 自定義分組統(tǒng)計(jì)值的計(jì)算方法
    calcValuesMethod({ column, children }) {
      // 只對(duì) num 列進(jìn)行求和
      if (column.field === 'num') {
        let sum = 0
        children.forEach(item => {
          sum += item.num
        })
        return sum
      }
      // 其他列不統(tǒng)計(jì)，返回 0 或空字符串
      return 0
    }
  },
  // 列定義
  columns: [
    { type: 'seq', width: 70, title: '序號(hào)' },
    { field: 'name', title: '姓名', minWidth: 150, rowGroupNode: true },  // 分組顯示節(jié)點(diǎn)
    { field: 'role', title: '角色', width: 120 },
    { field: 'num', title: '數(shù)量', width: 100, aggFunc: true },           // 參與聚合
    { field: 'age', title: '年齡', width: 80 },
    { field: 'address', title: '地址', minWidth: 200 }
  ],
  data: [],               // 動(dòng)態(tài)加載的數(shù)據(jù)
  footerData: [footerSummaryRow]   // 表尾數(shù)據(jù)
})
// 模擬異步加載數(shù)據(jù)，并計(jì)算表尾總計(jì)
const loadData = () => {
  gridOptions.loading = true
  setTimeout(() => {
    const rawData = [
      { id: 10001, name: 'Test1', role: 'Develop', sex: 'Woman', age: 28, num: 63, date: '2025-02-01', address: 'test abc' },
      { id: 10002, name: 'Test2', role: 'Test', sex: 'Man', age: 22, num: 63, date: '2025-01-01', address: 'Guangzhou' },
      { id: 10003, name: 'Test3', role: 'PM', sex: 'Woman', age: 32, num: 10, date: '2025-05-01', address: 'Shanghai' },
      { id: 10004, name: 'Test4', role: 'Designer', sex: 'Man', age: 32, num: 24, date: '2025-01-01', address: 'test abc' },
      { id: 10005, name: 'Test5', role: 'Develop', sex: 'Man', age: 30, num: 98, date: '2025-01-01', address: 'Shanghai' },
      { id: 10006, name: 'Test6', role: 'Designer', sex: 'Man', age: 30, num: 46, date: '2025-03-01', address: 'test abc' },
      { id: 10007, name: 'Test7', role: 'Test', sex: 'Woman', age: 29, num: 35, date: '2025-05-01', address: 'test abc' },
      { id: 10008, name: 'Test8', role: 'PM', sex: 'Woman', age: 35, num: 84, date: '2025-11-01', address: 'test abc' },
      { id: 10009, name: 'Test9', role: 'Test', sex: 'Man', age: 21, num: 25, date: '2025-05-01', address: 'test abc' },
      { id: 10010, name: 'Test10', role: 'PM', sex: 'Woman', age: 28, num: 32, date: '2025-03-01', address: 'test abc' },
      { id: 10011, name: 'Test11', role: 'Test', sex: 'Woman', age: 29, num: 24, date: '2025-03-01', address: 'test abc' },
      { id: 10012, name: 'Test12', role: 'Develop', sex: 'Man', age: 37, num: 28, date: '2025-10-01', address: 'test abc' },
      { id: 10013, name: 'Test13', role: 'Test', sex: 'Woman', age: 24, num: 38, date: '2025-02-01', address: 'test abc' },
      { id: 10014, name: 'Test14', role: 'Develop', sex: 'Man', age: 34, num: 46, date: '2025-08-01', address: 'test abc' },
      { id: 10015, name: 'Test15', role: 'Designer', sex: 'Man', age: 21, num: 48, date: '2025-05-01', address: 'test abc' },
      { id: 10016, name: 'Test16', role: 'Designer', sex: 'Woman', age: 21, num: 59, date: '2025-10-01', address: 'test abc' },
      { id: 10017, name: 'Test17', role: 'Test', sex: 'Man', age: 31, num: 81, date: '2025-12-01', address: 'test abc' },
      { id: 10018, name: 'Test18', role: 'Develop', sex: 'Woman', age: 32, num: 75, date: '2025-10-01', address: 'test abc' },
      { id: 10019, name: 'Test19', role: 'Test', sex: 'Man', age: 37, num: 80, date: '2025-02-01', address: 'test abc' },
      { id: 10020, name: 'Test20', role: 'Develop', sex: 'Man', age: 41, num: 60, date: '2025-03-01', address: 'test abc' }
    ]
    // 計(jì)算總計(jì)（num 總和）
    let totalNum = 0
    rawData.forEach(row => {
      totalNum += row.num
    })
    footerSummaryRow.num = totalNum
    gridOptions.data = rawData
    gridOptions.loading = false
  }, 200)
}
// 調(diào)用加載
loadData()
</script>