index.vue 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163
  1. <template>
  2. <div>
  3. <el-alert
  4. effect="dark"
  5. :closable="false"
  6. title="基于 Element 的 Table 组件进行二次封装,实现数据驱动,支持所有 Table 参数 -- 表尾合计行"
  7. type="info"
  8. style="margin-bottom: 20px;"
  9. />
  10. <com-table
  11. v-loading="loading"
  12. :columns="columns"
  13. :data="tableData"
  14. border
  15. show-summary
  16. />
  17. <com-table
  18. v-loading="loading"
  19. :columns="columns1"
  20. :data="tableData"
  21. border
  22. height="200"
  23. :summary-method="getSummaries"
  24. show-summary
  25. style="margin-top: 20px;"
  26. />
  27. </div>
  28. </template>
  29. <script lang="ts">
  30. import { defineComponent, ref } from 'vue'
  31. const columns = [
  32. {
  33. field: 'id',
  34. label: 'ID'
  35. },
  36. {
  37. field: 'name',
  38. label: '姓名'
  39. },
  40. {
  41. field: 'amount1',
  42. label: '数值1',
  43. sortable: true
  44. },
  45. {
  46. field: 'amount2',
  47. label: '数值2',
  48. sortable: true
  49. },
  50. {
  51. field: 'amount3',
  52. label: '数值4',
  53. sortable: true
  54. }
  55. ]
  56. const columns1 = [
  57. {
  58. field: 'id',
  59. label: 'ID'
  60. },
  61. {
  62. field: 'name',
  63. label: '姓名'
  64. },
  65. {
  66. field: 'amount1',
  67. label: '数值1(元)'
  68. },
  69. {
  70. field: 'amount2',
  71. label: '数值2(元)'
  72. },
  73. {
  74. field: 'amount3',
  75. label: '数值4(元)'
  76. }
  77. ]
  78. const tableData = [
  79. {
  80. id: '12987122',
  81. name: '王小虎',
  82. amount1: '234',
  83. amount2: '3.2',
  84. amount3: 10
  85. }, {
  86. id: '12987123',
  87. name: '王小虎',
  88. amount1: '165',
  89. amount2: '4.43',
  90. amount3: 12
  91. }, {
  92. id: '12987124',
  93. name: '王小虎',
  94. amount1: '324',
  95. amount2: '1.9',
  96. amount3: 9
  97. }, {
  98. id: '12987125',
  99. name: '王小虎',
  100. amount1: '621',
  101. amount2: '2.2',
  102. amount3: 17
  103. }, {
  104. id: '12987126',
  105. name: '王小虎',
  106. amount1: '539',
  107. amount2: '4.1',
  108. amount3: 15
  109. }
  110. ]
  111. export default defineComponent({
  112. // name: 'TotalTable',
  113. setup() {
  114. const loading = ref<boolean>(true)
  115. setTimeout(() => {
  116. loading.value = false
  117. }, 1000)
  118. function getSummaries(param: any) {
  119. const { columns, data } = param
  120. const sums: any[] = []
  121. columns.forEach((column: any, index: number) => {
  122. if (index === 0) {
  123. sums[index] = '总价'
  124. return
  125. }
  126. const values = data.map((item: any) => Number(item[column.property]))
  127. if (!values.every((value: number) => isNaN(value))) {
  128. sums[index] = values.reduce((prev: number, curr: number) => {
  129. const value = Number(curr)
  130. if (!isNaN(value)) {
  131. return prev + curr
  132. } else {
  133. return prev
  134. }
  135. }, 0)
  136. sums[index] += ' 元'
  137. } else {
  138. sums[index] = 'N/A'
  139. }
  140. })
  141. return sums
  142. }
  143. return {
  144. columns, columns1,
  145. tableData,
  146. loading,
  147. getSummaries
  148. }
  149. }
  150. })
  151. </script>
  152. <style>
  153. </style>