summary.vue 2.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  1. <template>
  2. <el-table :data="tableData" border show-summary style="width: 100%">
  3. <el-table-column prop="id" label="ID" width="180" />
  4. <el-table-column prop="name" label="Name" />
  5. <el-table-column prop="amount1" sortable label="Amount 1" />
  6. <el-table-column prop="amount2" sortable label="Amount 2" />
  7. <el-table-column prop="amount3" sortable label="Amount 3" />
  8. </el-table>
  9. <el-table :data="tableData" border height="200" :summary-method="getSummaries" show-summary style="width: 100%; margin-top: 20px">
  10. <el-table-column prop="id" label="ID" width="180" />
  11. <el-table-column prop="name" label="Name" />
  12. <el-table-column prop="amount1" label="Cost 1 ($)" />
  13. <el-table-column prop="amount2" label="Cost 2 ($)" />
  14. <el-table-column prop="amount3" label="Cost 3 ($)" />
  15. </el-table>
  16. </template>
  17. <script lang="ts" setup>
  18. import type { TableColumnCtx } from 'element-plus/es/components/table/src/table-column/defaults'
  19. interface Product {
  20. id: string
  21. name: string
  22. amount1: string
  23. amount2: string
  24. amount3: number
  25. }
  26. interface SummaryMethodProps<T = Product> {
  27. columns: TableColumnCtx<T>[]
  28. data: T[]
  29. }
  30. const getSummaries = (param: SummaryMethodProps) => {
  31. const { columns, data } = param
  32. const sums: string[] = []
  33. columns.forEach((column, index) => {
  34. if (index === 0) {
  35. sums[index] = 'Total Cost'
  36. return
  37. }
  38. const values = data.map(item => Number(item[column.property]))
  39. if (!values.every(value => Number.isNaN(value))) {
  40. sums[index] = `$ ${values.reduce((prev, curr) => {
  41. const value = Number(curr)
  42. if (!Number.isNaN(value)) {
  43. return prev + curr
  44. } else {
  45. return prev
  46. }
  47. }, 0)}`
  48. } else {
  49. sums[index] = 'N/A'
  50. }
  51. })
  52. return sums
  53. }
  54. const tableData: Product[] = [
  55. {
  56. id: '12987122',
  57. name: 'Tom',
  58. amount1: '234',
  59. amount2: '3.2',
  60. amount3: 10,
  61. },
  62. {
  63. id: '12987123',
  64. name: 'Tom',
  65. amount1: '165',
  66. amount2: '4.43',
  67. amount3: 12,
  68. },
  69. {
  70. id: '12987124',
  71. name: 'Tom',
  72. amount1: '324',
  73. amount2: '1.9',
  74. amount3: 9,
  75. },
  76. {
  77. id: '12987125',
  78. name: 'Tom',
  79. amount1: '621',
  80. amount2: '2.2',
  81. amount3: 17,
  82. },
  83. {
  84. id: '12987126',
  85. name: 'Tom',
  86. amount1: '539',
  87. amount2: '4.1',
  88. amount3: 15,
  89. },
  90. ]
  91. </script>