summary.vue 2.3 KB

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