Table 表格

表格展示,不支持配置初始化接口初始化数据域,所以需要搭配类似像Service这样的,具有配置接口初始化数据域功能的组件,或者手动进行数据域初始化,然后通过source属性,获取数据链中的数据,完成数据展示。

基本用法

```schema: scope=”body” { “type”: “service”, “api”: “/api/mock2/sample?perPage=5”, “body”: [ { “type”: “table”, “title”: “表格1”, “source”: “$rows”, “columns”: [ { “name”: “engine”, “label”: “Engine” },

  1. {
  2. "name": "version",
  3. "label": "Version"
  4. }
  5. ]
  6. }
  7. ]

}

  1. ## 数据需求
  2. 数据是对象数组,比如前面的例子中 `rows` 的值类似:

[ { “engine”: “webkie”, “version”: 1 } ]

  1. ## 空状态展示
  2. ```schema: scope="body"
  3. {
  4. "type": "service",
  5. "api": "/api/mock2/sample?perPage=5",
  6. "body": [
  7. {
  8. "type": "table",
  9. "title": "表格1",
  10. "source": [],
  11. "columns": [
  12. {
  13. "name": "engine",
  14. "label": "Engine"
  15. },
  16. {
  17. "name": "version",
  18. "label": "Version"
  19. }
  20. ],
  21. "placeholder": "您还没有创建任何实例"
  22. }
  23. ]
  24. }

列配置

columns内,除了简单的配置labelname展示数据以外,还支持一些额外的配置项,可以帮助更好的展示数据。

列类型

除了简单展示数据源所返回的数据以外,list的列支持除表单项以外所有组件类型,例如:

  1. {
  2. "type": "table",
  3. "data": {
  4. "items": [
  5. {
  6. "id": "91264",
  7. "text": "衡 阎",
  8. "progress": 22,
  9. "type": 4,
  10. "boolean": true,
  11. "list": [
  12. {
  13. "title": "Forward Functionality Technician",
  14. "description": "nisi ex eum"
  15. },
  16. {
  17. "title": "District Applications Specialist",
  18. "description": "ipsam ratione voluptas"
  19. },
  20. {
  21. "title": "Future Operations Manager",
  22. "description": "ducimus fugit debitis"
  23. },
  24. {
  25. "title": "Dynamic Solutions Associate",
  26. "description": "saepe consequatur aut"
  27. }
  28. ],
  29. "audio": "https://news-bos.cdn.bcebos.com/mvideo/%E7%9A%87%E5%90%8E%E5%A4%A7%E9%81%93%E4%B8%9C.aac",
  30. "carousel": [
  31. {
  32. "image": "https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3893101144,2877209892&fm=23&gp=0.jpg"
  33. },
  34. {
  35. "html": "<div style=\"width: 100%; height: 200px; background: #e3e3e3; text-align: center; line-height: 200px;\">carousel data in crud</div>"
  36. },
  37. {
  38. "image": "https://video-react.js.org/assets/poster.png"
  39. }
  40. ],
  41. "date": 1591270438,
  42. "image": "https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3893101144,2877209892&fm=23&gp=0.jpg",
  43. "json": {
  44. "id": 1,
  45. "text": "text"
  46. }
  47. },
  48. {
  49. "id": "34202",
  50. "text": "吉 卢汉市",
  51. "progress": 85,
  52. "type": 1,
  53. "boolean": true,
  54. "list": [
  55. {
  56. "title": "Dynamic Assurance Orchestrator",
  57. "description": "ea ullam voluptates"
  58. },
  59. {
  60. "title": "Internal Division Assistant",
  61. "description": "illum deleniti qui"
  62. },
  63. {
  64. "title": "International Usability Administrator",
  65. "description": "sit voluptatem quia"
  66. },
  67. {
  68. "title": "Lead Optimization Orchestrator",
  69. "description": "autem et blanditiis"
  70. },
  71. {
  72. "title": "Future Division Assistant",
  73. "description": "dolor cupiditate sint"
  74. },
  75. {
  76. "title": "Forward Program Orchestrator",
  77. "description": "quia distinctio voluptas"
  78. },
  79. {
  80. "title": "Human Implementation Technician",
  81. "description": "consequatur quaerat ullam"
  82. },
  83. {
  84. "title": "National Identity Administrator",
  85. "description": "ipsa et reiciendis"
  86. },
  87. {
  88. "title": "Regional Factors Planner",
  89. "description": "sed deserunt natus"
  90. },
  91. {
  92. "title": "Human Data Administrator",
  93. "description": "rerum consequatur odit"
  94. }
  95. ],
  96. "audio": "https://news-bos.cdn.bcebos.com/mvideo/%E7%9A%87%E5%90%8E%E5%A4%A7%E9%81%93%E4%B8%9C.aac",
  97. "carousel": [
  98. {
  99. "image": "https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3893101144,2877209892&fm=23&gp=0.jpg"
  100. },
  101. {
  102. "html": "<div style=\"width: 100%; height: 200px; background: #e3e3e3; text-align: center; line-height: 200px;\">carousel data in crud</div>"
  103. },
  104. {
  105. "image": "https://video-react.js.org/assets/poster.png"
  106. }
  107. ],
  108. "date": 1591270438,
  109. "image": "https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3893101144,2877209892&fm=23&gp=0.jpg",
  110. "json": {
  111. "id": 1,
  112. "text": "text"
  113. }
  114. },
  115. {
  116. "id": "37701",
  117. "text": "立辉安市",
  118. "progress": 72,
  119. "type": 2,
  120. "boolean": false,
  121. "list": [
  122. {
  123. "title": "Corporate Metrics Liason",
  124. "description": "aspernatur natus qui"
  125. },
  126. {
  127. "title": "Central Paradigm Analyst",
  128. "description": "sequi numquam ad"
  129. },
  130. {
  131. "title": "International Data Administrator",
  132. "description": "sed libero eum"
  133. },
  134. {
  135. "title": "Forward Optimization Assistant",
  136. "description": "officiis accusantium dolorem"
  137. },
  138. {
  139. "title": "Senior Metrics Executive",
  140. "description": "commodi sint quod"
  141. },
  142. {
  143. "title": "Corporate Quality Facilitator",
  144. "description": "aut aperiam est"
  145. },
  146. {
  147. "title": "Forward Operations Producer",
  148. "description": "sed corporis eaque"
  149. },
  150. {
  151. "title": "National Integration Analyst",
  152. "description": "quasi ab cumque"
  153. }
  154. ],
  155. "audio": "https://news-bos.cdn.bcebos.com/mvideo/%E7%9A%87%E5%90%8E%E5%A4%A7%E9%81%93%E4%B8%9C.aac",
  156. "carousel": [
  157. {
  158. "image": "https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3893101144,2877209892&fm=23&gp=0.jpg"
  159. },
  160. {
  161. "html": "<div style=\"width: 100%; height: 200px; background: #e3e3e3; text-align: center; line-height: 200px;\">carousel data in crud</div>"
  162. },
  163. {
  164. "image": "https://video-react.js.org/assets/poster.png"
  165. }
  166. ],
  167. "date": 1591270438,
  168. "image": "https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3893101144,2877209892&fm=23&gp=0.jpg",
  169. "json": {
  170. "id": 1,
  171. "text": "text"
  172. }
  173. }
  174. ]
  175. },
  176. "affixHeader": false,
  177. "syncLocation": false,
  178. "columns": [
  179. {
  180. "name": "id",
  181. "label": "ID",
  182. "type": "text"
  183. },
  184. {
  185. "name": "text",
  186. "label": "文本",
  187. "type": "text"
  188. },
  189. {
  190. "type": "image",
  191. "label": "图片",
  192. "name": "image"
  193. },
  194. {
  195. "name": "date",
  196. "type": "date",
  197. "label": "日期"
  198. },
  199. {
  200. "name": "progress",
  201. "label": "进度",
  202. "type": "progress"
  203. },
  204. {
  205. "name": "boolean",
  206. "label": "状态",
  207. "type": "status"
  208. },
  209. {
  210. "name": "boolean",
  211. "label": "开关",
  212. "type": "switch"
  213. },
  214. {
  215. "name": "type",
  216. "label": "映射",
  217. "type": "mapping",
  218. "map": {
  219. "1": "<span class='label label-info'>漂亮</span>",
  220. "2": "<span class='label label-success'>开心</span>",
  221. "3": "<span class='label label-danger'>惊吓</span>",
  222. "4": "<span class='label label-warning'>紧张</span>",
  223. "*": "其他:${type}"
  224. }
  225. },
  226. {
  227. "name": "list",
  228. "type": "list",
  229. "label": "List",
  230. "placeholder": "-",
  231. "listItem": {
  232. "title": "${title}",
  233. "subTitle": "${description}"
  234. }
  235. }
  236. ]
  237. }

列宽

可以给列配置 width 属性,控制列宽,共有两种方式:

固定像素

可以配置数字,用于设置列宽像素,例如下面例子我们给Rendering engine列宽设置为100px

```schema: scope=”body” { “type”: “crud”, “api”: “/api/mock2/sample?waitSeconds=1”, “columns”: [ { “name”: “id”, “label”: “ID” }, { “name”: “engine”, “label”: “Rendering engine”, “width”: 100 } ] }

  1. #### 百分比
  2. 也可以百分比来指定列宽,例如下面例子我们给`Rendering engine`列宽设置为`50%`
  3. ```schema: scope="body"
  4. {
  5. "type": "crud",
  6. "api": "/api/mock2/sample?waitSeconds=1",
  7. "columns": [
  8. {
  9. "name": "id",
  10. "label": "ID"
  11. },
  12. {
  13. "name": "engine",
  14. "label": "Rendering engine",
  15. "width": "50%"
  16. }
  17. ]
  18. }

列对齐方式

1.4.0 及以上版本

通过 align 可以控制列文本对齐方式,比如

```schema: scope=”body” { “type”: “service”, “api”: “/api/mock2/sample?perPage=5”, “body”: [ { “type”: “table”, “title”: “表格1”, “source”: “$rows”, “columns”: [ { “name”: “engine”, “label”: “Engine” }, { “label”: “Version”, “type”: “tpl”, “tpl”: “${version | number}”, “align”: “right” } ] } ] }

  1. ### 列样式
  2. > 1.4.0 及以上版本
  3. 除了前面的宽度和对齐方式,还有更灵活的控制方法是通过样式表
  4. ```schema: scope="body"
  5. {
  6. "type": "service",
  7. "api": "/api/mock2/sample?perPage=5",
  8. "body": [
  9. {
  10. "type": "table",
  11. "title": "表格1",
  12. "source": "$rows",
  13. "columns": [
  14. {
  15. "name": "engine",
  16. "label": "Engine"
  17. },
  18. {
  19. "name": "version",
  20. "label": "Version",
  21. "className": "text-primary"
  22. }
  23. ]
  24. }
  25. ]
  26. }

如果要单独设置标题的样式,可以使用 labelClassName 属性

```schema: scope=”body” { “type”: “service”, “api”: “/api/mock2/sample?perPage=5”, “body”: [ { “type”: “table”, “title”: “表格1”, “source”: “$rows”, “columns”: [ { “name”: “engine”, “label”: “Engine” }, { “name”: “version”, “label”: “Version”, “className”: “text-primary”, “labelClassName”: “font-bold” } ] } ] }

  1. ### 单元格样式
  2. > 1.4.0 及以上版本
  3. `classNameExpr` 可以根据数据动态添加 CSS 类,支持 [模板]($docs-docs-concepts-template) 语法。
  4. 例如下例,`"<%= data.version > 5 ? "text-danger" : "" %>"` 表示当行数据的 `version` 数据大于 5 的时候添加 `text-danger` CSS 类名,使得文字颜色变红
  5. ```schema: scope="body"
  6. {
  7. "type": "service",
  8. "api": "/api/mock2/sample?perPage=5",
  9. "body": [
  10. {
  11. "type": "table",
  12. "source": "$rows",
  13. "columns": [
  14. {
  15. "name": "engine",
  16. "label": "Engine"
  17. },
  18. {
  19. "name": "version",
  20. "label": "Version",
  21. "classNameExpr": "<%= data.version > 5 ? 'text-danger' : '' %>",
  22. },
  23. {
  24. "name": "grade",
  25. "label": "Grade"
  26. }
  27. ]
  28. }
  29. ]
  30. }

背景色阶

1.8.0 及以上版本

backgroundScale 可以用来根据数据控制自动分配色阶

```schema: scope=”body” { “type”: “service”, “data”: { “rows”: [ { “engine”: “Trident”, “version”: “1”, “grade”: “A” }, { “engine”: “Trident”, “version”: “7”, “grade”: “B” }, { “engine”: “Trident”, “version”: “4”, “grade”: “C” }, { “engine”: “Trident”, “version”: “3”, “grade”: “A” }, { “engine”: “Trident”, “version”: “4”, “grade”: “A” }, { “engine”: “Gecko”, “version”: “6”, “grade”: “A” }, { “engine”: “Gecko”, “version”: “2”, “grade”: “A” }, { “engine”: “Gecko”, “version”: “5”, “grade”: “B” }, { “engine”: “Gecko”, “version”: “10”, “grade”: “D” } ] }, “body”: [ { “type”: “table”, “source”: “$rows”, “columns”: [ { “name”: “engine”, “label”: “Engine” }, { “name”: “version”, “label”: “Version”, backgroundScale: { min: 0, max: 10, colors: [‘#FFEF9C’, ‘#FF7127’] } }, { “name”: “grade”, “label”: “Grade” } ] } ] }

  1. `min` `max` 都支持变量,如果为设置会自动计算当前列的最大和最小值。
  2. 默认会从当前列的 `name` 属性来获取数据,也可以通过 `backgroundScale.source` 使用变量及公式来获取数据。
  3. ### 默认是否显示
  4. 默认 `columnsTogglable` 配置为 `auto`,当列超过 5 列后,就会在工具栏多渲染出来一个列展示与否的开关。你可以设置成 `true` 或者 `false` 来强制开或者关。在列配置中可以通过配置 `toggled` `false` 默认不展示这列,比如下面这个例子中 ID 这一栏。
  5. ```schema: scope="body"
  6. {
  7. "type": "service",
  8. "api": "/api/mock2/sample?perPage=5",
  9. "body": [
  10. {
  11. "type": "table",
  12. "source": "$rows",
  13. "className": "m-b-none",
  14. "columns": [
  15. {
  16. "name": "engine",
  17. "label": "Engine"
  18. },
  19. {
  20. "name": "grade",
  21. "label": "Grade"
  22. },
  23. {
  24. "name": "version",
  25. "label": "Version"
  26. },
  27. {
  28. "name": "browser",
  29. "label": "Browser"
  30. },
  31. {
  32. "name": "id",
  33. "label": "ID",
  34. "toggled": false
  35. },
  36. {
  37. "name": "platform",
  38. "label": "Platform"
  39. }
  40. ]
  41. }
  42. ]
  43. }

固定列

列太多可以让重要的几列固定,可以配置固定在左侧还是右侧,只需要给需要固定的列上配置 fixed 属性,配置 left 或者 right

```schema: scope=”body” { “type”: “service”, “api”: “/api/mock2/sample?perPage=5”, “className”: “w-xxl”, “body”: [ { “type”: “table”, “source”: “$rows”, “className”: “m-b-none”, “columnsTogglable”: false, “columns”: [ { “name”: “engine”, “label”: “Engine”, “fixed”: “left” },

  1. {
  2. "name": "grade",
  3. "label": "Grade"
  4. },
  5. {
  6. "name": "version",
  7. "label": "Version"
  8. },
  9. {
  10. "name": "browser",
  11. "label": "Browser"
  12. },
  13. {
  14. "name": "id",
  15. "label": "ID"
  16. },
  17. {
  18. "name": "platform",
  19. "label": "Platform",
  20. "fixed": "right"
  21. }
  22. ]
  23. }
  24. ]

}

  1. ### 可复制
  2. 可以在列上配置`"copyable": true`,会在该列的内容区里,渲染一个复制内容的图标,点击可复制该显示内容
  3. ```schema: scope="body"
  4. {
  5. "type": "crud",
  6. "api": "/api/mock2/sample?waitSeconds=1",
  7. "columns": [
  8. {
  9. "name": "id",
  10. "label": "ID"
  11. },
  12. {
  13. "name": "engine",
  14. "label": "Rendering engine",
  15. "copyable": true
  16. }
  17. ]
  18. }

你也可以配置对象形式,可以自定义显示内容

```schema: scope=”body” { “type”: “crud”, “api”: “/api/mock2/sample?waitSeconds=1”, “columns”: [ { “name”: “id”, “label”: “ID” }, { “name”: “engine”, “label”: “Rendering engine”, “copyable”: { “content”: “复制的内容是:${engine}” } } ] }

  1. ### 弹出框(popOver)
  2. 可以给列上配置 `popOver` 属性,会在该列的内容区里,渲染一个图标,点击会显示弹出框,用于展示内容
  3. ```schema: scope="body"
  4. {
  5. "type": "crud",
  6. "api": "/api/mock2/sample?waitSeconds=1",
  7. "columns": [
  8. {
  9. "name": "id",
  10. "label": "ID"
  11. },
  12. {
  13. "name": "engine",
  14. "label": "Rendering engine",
  15. "popOver": {
  16. "body": {
  17. "type": "tpl",
  18. "tpl": "${engine}"
  19. }
  20. }
  21. }
  22. ]
  23. }

popOver 的其它配置请参考 popover

表头样式

可以配置"isHead": true,来让当前列以表头的样式展示。应用场景是:

  1. 所有列label配置空字符串,不显示表头
  2. 配置combineNum,合并单元格,实现左侧表头的形式
  3. 列上配置"isHead": true,调整样式

```schema: scope=”body” { “type”: “crud”, “api”: “/api/mock2/sample?waitSeconds=1”, “affixHeader”: false, “combineNum”: 1, “columns”: [ { “name”: “engine”, “label”: “”, “isHead”: true }, { “name”: “browser”, “label”: “” }, { “name”: “platform”, “label”: “” }, { “name”: “version”, “label”: “” }, { “name”: “grade”, “label”: “” } ] }

  1. 还可以配置"offset",实现弹出框位置调整自定义
  2. ```schema: scope="body"
  3. {
  4. "type": "crud",
  5. "api": "/api/mock2/sample?waitSeconds=1",
  6. "columns": [
  7. {
  8. "name": "id",
  9. "label": "ID"
  10. },
  11. {
  12. "name": "engine",
  13. "label": "Rendering engine",
  14. "popOver": {
  15. "body": {
  16. "type": "tpl",
  17. "tpl": "偏了一点的popover"
  18. },
  19. "offset": {
  20. "y": 100
  21. }
  22. }
  23. }
  24. ]
  25. }

嵌套

当行数据中存在 children 属性时,可以自动嵌套显示下去。

```schema: scope=”body” { “type”: “service”, “data”: { “rows”: [ { “engine”: “Trident”, “browser”: “Internet Explorer 4.0”, “platform”: “Win 95+”, “version”: “4”, “grade”: “X”, “id”: 1, “children”: [ { “engine”: “Trident”, “browser”: “Internet Explorer 4.0”, “platform”: “Win 95+”, “version”: “4”, “grade”: “X”, “id”: 1001 }, { “engine”: “Trident”, “browser”: “Internet Explorer 5.0”, “platform”: “Win 95+”, “version”: “5”, “grade”: “C”, “id”: 1002 } ] }, { “engine”: “Trident”, “browser”: “Internet Explorer 5.0”, “platform”: “Win 95+”, “version”: “5”, “grade”: “C”, “id”: 2, “children”: [ { “engine”: “Trident”, “browser”: “Internet Explorer 4.0”, “platform”: “Win 95+”, “version”: “4”, “grade”: “X”, “id”: 2001 }, { “engine”: “Trident”, “browser”: “Internet Explorer 5.0”, “platform”: “Win 95+”, “version”: “5”, “grade”: “C”, “id”: 2002 } ] }, { “engine”: “Trident”, “browser”: “Internet Explorer 5.5”, “platform”: “Win 95+”, “version”: “5.5”, “grade”: “A”, “id”: 3, “children”: [ { “engine”: “Trident”, “browser”: “Internet Explorer 4.0”, “platform”: “Win 95+”, “version”: “4”, “grade”: “X”, “id”: 3001 }, { “engine”: “Trident”, “browser”: “Internet Explorer 5.0”, “platform”: “Win 95+”, “version”: “5”, “grade”: “C”, “id”: 3002 } ] }, { “engine”: “Trident”, “browser”: “Internet Explorer 6”, “platform”: “Win 98+”, “version”: “6”, “grade”: “A”, “id”: 4, “children”: [ { “engine”: “Trident”, “browser”: “Internet Explorer 4.0”, “platform”: “Win 95+”, “version”: “4”, “grade”: “X”, “id”: 4001 }, { “engine”: “Trident”, “browser”: “Internet Explorer 5.0”, “platform”: “Win 95+”, “version”: “5”, “grade”: “C”, “id”: 4002 } ] }, { “engine”: “Trident”, “browser”: “Internet Explorer 7”, “platform”: “Win XP SP2+”, “version”: “7”, “grade”: “A”, “id”: 5, “children”: [ { “engine”: “Trident”, “browser”: “Internet Explorer 4.0”, “platform”: “Win 95+”, “version”: “4”, “grade”: “X”, “id”: 5001 }, { “engine”: “Trident”, “browser”: “Internet Explorer 5.0”, “platform”: “Win 95+”, “version”: “5”, “grade”: “C”, “id”: 5002 } ] } ] }, “body”: [ { “type”: “table”, “source”: “$rows”, “className”: “m-b-none”, “columnsTogglable”: false, “columns”: [ { “name”: “engine”, “label”: “Engine” },

  1. {
  2. "name": "grade",
  3. "label": "Grade"
  4. },
  5. {
  6. "name": "version",
  7. "label": "Version"
  8. },
  9. {
  10. "name": "browser",
  11. "label": "Browser"
  12. },
  13. {
  14. "name": "id",
  15. "label": "ID"
  16. },
  17. {
  18. "name": "platform",
  19. "label": "Platform"
  20. }
  21. ]
  22. }
  23. ]

}

  1. ## 底部展示 (Footable)
  2. 列太多时,内容没办法全部显示完,可以让部分信息在底部显示,可以让用户展开查看详情。配置很简单,只需要开启 `footable` 属性,同时将想在底部展示的列加个 `breakpoint` 属性为 `*` 即可。
  3. ```schema: scope="body"
  4. {
  5. "type": "service",
  6. "api": "/api/mock2/sample?perPage=5",
  7. "body": [
  8. {
  9. "type": "table",
  10. "source": "$rows",
  11. "className": "m-b-none",
  12. "columnsTogglable": false,
  13. "footable": true,
  14. "columns": [
  15. {
  16. "name": "engine",
  17. "label": "Engine"
  18. },
  19. {
  20. "name": "grade",
  21. "label": "Grade"
  22. },
  23. {
  24. "name": "version",
  25. "label": "Version",
  26. "breakpoint": "*"
  27. },
  28. {
  29. "name": "browser",
  30. "label": "Browser",
  31. "breakpoint": "*"
  32. },
  33. {
  34. "name": "id",
  35. "label": "ID",
  36. "breakpoint": "*"
  37. },
  38. {
  39. "name": "platform",
  40. "label": "Platform",
  41. "breakpoint": "*"
  42. }
  43. ]
  44. }
  45. ]
  46. }

默认都不会展开,如果你想默认展开第一个就把 footable 配置成这样。

  1. {
  2. "footable": {
  3. "expand": "first"
  4. }
  5. }

当配置成 all 时表示全部展开。

合并单元格

只需要配置 combineNum 属性即可,他表示从左到右多少列内启动自动合并单元格,只要多行的同一个属性值是一样的,就会自动合并。

如果你不想从第一列开始合并单元格,可以配置 combineFromIndex,如果配置为 1,则会跳过第一列的合并。如果配置为 2,则会跳过第一列和第二列的合并,从第三行开始向右合并 combineNum 列。

```schema: scope=”body” { “type”: “service”, “data”: { “rows”: [ { “engine”: “Trident”, “browser”: “Internet Explorer 4.2”, “platform”: “Win 95+”, “version”: “4”, “grade”: “A” }, { “engine”: “Trident”, “browser”: “Internet Explorer 4.2”, “platform”: “Win 95+”, “version”: “4”, “grade”: “B” }, { “engine”: “Trident”, “browser”: “AOL browser (AOL desktop)”, “platform”: “Win 95+”, “version”: “4”, “grade”: “C” }, { “engine”: “Trident”, “browser”: “AOL browser (AOL desktop)”, “platform”: “Win 98”, “version”: “3”, “grade”: “A” }, { “engine”: “Trident”, “browser”: “AOL browser (AOL desktop)”, “platform”: “Win 98”, “version”: “4”, “grade”: “A” }, { “engine”: “Gecko”, “browser”: “Firefox 1.0”, “platform”: “Win 98+ / OSX.2+”, “version”: “4”, “grade”: “A” }, { “engine”: “Gecko”, “browser”: “Firefox 1.0”, “platform”: “Win 98+ / OSX.2+”, “version”: “5”, “grade”: “A” }, { “engine”: “Gecko”, “browser”: “Firefox 2.0”, “platform”: “Win 98+ / OSX.2+”, “version”: “5”, “grade”: “B” }, { “engine”: “Gecko”, “browser”: “Firefox 2.0”, “platform”: “Win 98+ / OSX.2+”, “version”: “5”, “grade”: “C” }, { “engine”: “Gecko”, “browser”: “Firefox 2.0”, “platform”: “Win 98+ / OSX.2+”, “version”: “5”, “grade”: “D” } ] }, “body”: [ { “type”: “table”, “source”: “$rows”, “className”: “m-b-none”, “combineNum”: 3, “columnsTogglable”: false, “columns”: [ { “name”: “engine”, “label”: “Rendering engine” }, { “name”: “browser”, “label”: “Browser” }, { “name”: “platform”, “label”: “Platform(s)” }, { “name”: “version”, “label”: “Engine version” }, { “name”: “grade”, “label”: “CSS grade” } ] } ] }

  1. > 1.3.0 版本开始 combineNum 支持使用变量,如下所示
  2. ```schema: scope="body"
  3. {
  4. "type": "service",
  5. "data": {
  6. "rows": [
  7. {
  8. "engine": "Trident",
  9. "browser": "Internet Explorer 4.2",
  10. "platform": "Win 95+",
  11. "version": "4",
  12. "grade": "A"
  13. },
  14. {
  15. "engine": "Trident",
  16. "browser": "Internet Explorer 4.2",
  17. "platform": "Win 95+",
  18. "version": "4",
  19. "grade": "B"
  20. },
  21. {
  22. "engine": "Trident",
  23. "browser": "AOL browser (AOL desktop)",
  24. "platform": "Win 95+",
  25. "version": "4",
  26. "grade": "C"
  27. },
  28. {
  29. "engine": "Trident",
  30. "browser": "AOL browser (AOL desktop)",
  31. "platform": "Win 98",
  32. "version": "3",
  33. "grade": "A"
  34. },
  35. {
  36. "engine": "Trident",
  37. "browser": "AOL browser (AOL desktop)",
  38. "platform": "Win 98",
  39. "version": "4",
  40. "grade": "A"
  41. },
  42. {
  43. "engine": "Gecko",
  44. "browser": "Firefox 1.0",
  45. "platform": "Win 98+ / OSX.2+",
  46. "version": "4",
  47. "grade": "A"
  48. },
  49. {
  50. "engine": "Gecko",
  51. "browser": "Firefox 1.0",
  52. "platform": "Win 98+ / OSX.2+",
  53. "version": "5",
  54. "grade": "A"
  55. },
  56. {
  57. "engine": "Gecko",
  58. "browser": "Firefox 2.0",
  59. "platform": "Win 98+ / OSX.2+",
  60. "version": "5",
  61. "grade": "B"
  62. },
  63. {
  64. "engine": "Gecko",
  65. "browser": "Firefox 2.0",
  66. "platform": "Win 98+ / OSX.2+",
  67. "version": "5",
  68. "grade": "C"
  69. },
  70. {
  71. "engine": "Gecko",
  72. "browser": "Firefox 2.0",
  73. "platform": "Win 98+ / OSX.2+",
  74. "version": "5",
  75. "grade": "D"
  76. }
  77. ],
  78. combineNum: 3
  79. },
  80. "body": [
  81. {
  82. "type": "table",
  83. "source": "$rows",
  84. "className": "m-b-none",
  85. "combineNum": "$combineNum",
  86. "columnsTogglable": false,
  87. "columns": [
  88. {
  89. "name": "engine",
  90. "label": "Rendering engine"
  91. },
  92. {
  93. "name": "browser",
  94. "label": "Browser"
  95. },
  96. {
  97. "name": "platform",
  98. "label": "Platform(s)"
  99. },
  100. {
  101. "name": "version",
  102. "label": "Engine version"
  103. },
  104. {
  105. "name": "grade",
  106. "label": "CSS grade"
  107. }
  108. ]
  109. }
  110. ]
  111. }

超级表头

超级表头意思是,表头还可以再一次进行分组。额外添加个 groupName 属性即可。

```schema: scope=”body” { “type”: “service”, “api”: “/api/mock2/sample?perPage=5”, “body”: [ { “type”: “table”, “source”: “$rows”, “className”: “m-b-none”, “columns”: [ { “name”: “engine”, “label”: “Engine”, “groupName”: “分组1” },

  1. {
  2. "name": "grade",
  3. "label": "Grade",
  4. "groupName": "分组1"
  5. },
  6. {
  7. "name": "version",
  8. "label": "Version",
  9. "groupName": "分组2"
  10. },
  11. {
  12. "name": "browser",
  13. "label": "Browser",
  14. "groupName": "分组2"
  15. },
  16. {
  17. "name": "id",
  18. "label": "ID",
  19. "toggled": false,
  20. "groupName": "分组2"
  21. },
  22. {
  23. "name": "platform",
  24. "label": "Platform",
  25. "groupName": "分组2"
  26. }
  27. ]
  28. }
  29. ]

}

  1. ## 高亮行
  2. 可以通过配置`rowClassNameExpr`来为行添加 CSS 类,支持 [模板]($docs-docs-concepts-template) 语法。
  3. 例如下例,`"<%= data.id % 2 ? "bg-success" : "" %>"` 表示当行数据的 `id` 变量为 不能被 `2` 整除时,给当前行添加`bg-success` CSS 类名,即绿色背景色
  4. ```schema: scope="body"
  5. {
  6. "type": "service",
  7. "api": "/api/mock2/sample?perPage=10",
  8. "body": [
  9. {
  10. "type": "table",
  11. "source": "$rows",
  12. "rowClassNameExpr": "<%= data.id % 2 ? 'bg-success' : '' %>",
  13. "columns": [
  14. {
  15. "name": "engine",
  16. "label": "Engine"
  17. },
  18. {
  19. "name": "grade",
  20. "label": "Grade"
  21. },
  22. {
  23. "name": "version",
  24. "label": "Version"
  25. },
  26. {
  27. "name": "browser",
  28. "label": "Browser"
  29. },
  30. {
  31. "name": "id",
  32. "label": "ID"
  33. },
  34. {
  35. "name": "platform",
  36. "label": "Platform"
  37. }
  38. ]
  39. }
  40. ]
  41. }

总结行

可以通过配置 prefixRowaffixRow 来为表格顶部或底部添加总结行,

```schema: scope=”body” { “type”: “service”, “api”: “/api/mock2/sample?perPage=10”, “body”: [ { “type”: “table”, “source”: “$rows”, “columns”: [ { “name”: “browser”, “label”: “Browser” },

  1. {
  2. "name": "version",
  3. "label": "Version"
  4. }
  5. ],
  6. "affixRow":[
  7. {
  8. "type": "text",
  9. "text": "总计"
  10. },
  11. {
  12. "type": "tpl",
  13. "tpl": "${rows|pick:version|sum}"
  14. }
  15. ]
  16. }
  17. ]

}

  1. > 1.8.1 及以上版本
  2. 新增 `affixRowClassNameExpr``affixRowClassName``prefixRowClassNameExpr``prefixRowClassName` 来控制总结行样式,比如下面的例子
  3. ```schema: scope="body"
  4. {
  5. "type": "service",
  6. "api": "/api/mock2/sample?perPage=10",
  7. "body": [
  8. {
  9. "type": "table",
  10. "source": "$rows",
  11. "columns": [
  12. {
  13. "name": "browser",
  14. "label": "Browser"
  15. },
  16. {
  17. "name": "version",
  18. "label": "Version"
  19. }
  20. ],
  21. "affixRowClassNameExpr": "${SUM(ARRAYMAP(rows, item => item.version)) > 30 ? 'text-success' : ''}",
  22. "affixRow":[
  23. {
  24. "type": "text",
  25. "text": "总计"
  26. },
  27. {
  28. "type": "tpl",
  29. "tpl": "${rows|pick:version|sum}"
  30. }
  31. ]
  32. }
  33. ]
  34. }

配置合并单元格

可以配置 colSpan 来设置一列所合并的列数,例如

```schema: scope=”body” { “type”: “service”, “api”: “/api/mock2/sample?perPage=10”, “body”: [ { “type”: “table”, “source”: “$rows”, “columns”: [ { “name”: “id”, “label”: “ID” },

  1. {
  2. "name": "browser",
  3. "label": "Browser"
  4. },
  5. {
  6. "name": "version",
  7. "label": "Version"
  8. }
  9. ],
  10. "affixRow":[
  11. {
  12. "type": "text",
  13. "text": "总计",
  14. "colSpan": 2
  15. },
  16. {
  17. "type": "tpl",
  18. "tpl": "${rows|pick:version|sum}"
  19. }
  20. ]
  21. }
  22. ]

}

  1. 上例中我们给 `总计` 列配置了 `"colSpan": 2`,它会合并两个单元格
  2. ### 配置多行
  3. 可以配置二维数组来配置多行总结行
  4. ```schema: scope="body"
  5. {
  6. "type": "service",
  7. "api": "/api/mock2/sample?perPage=10",
  8. "body": [
  9. {
  10. "type": "table",
  11. "source": "$rows",
  12. "columns": [
  13. {
  14. "name": "browser",
  15. "label": "Browser"
  16. },
  17. {
  18. "name": "version",
  19. "label": "Version"
  20. }
  21. ],
  22. "affixRow":[
  23. [
  24. {
  25. "type": "text",
  26. "text": "总计1"
  27. },
  28. {
  29. "type": "tpl",
  30. "tpl": "${rows|pick:version|sum}"
  31. }
  32. ],
  33. [
  34. {
  35. "type": "text",
  36. "text": "总计2"
  37. },
  38. {
  39. "type": "tpl",
  40. "tpl": "${rows|pick:version|sum}"
  41. }
  42. ]
  43. ]
  44. }
  45. ]
  46. }

行操作按钮

通过 itemActions 可以设置鼠标移动到行上出现操作按钮

```schema: scope=”body” { “type”: “service”, “api”: “/api/mock2/sample?perPage=10”, “body”: [{ “type”: “table”, “source”: “$rows”, “itemActions”: [{ “label”: “编辑”, “type”: “button”, “actionType”: “dialog”, “dialog”: { “title”: “编辑”, “body”: “这是个简单的编辑弹框” } }, { “label”: “删除”, “type”: “button”, “actionType”: “ajax”, “confirmText”: “确认要删除?”, “api”: “/api/mock2/form/saveForm” }], “columns”: [{ “name”: “browser”, “label”: “Browser” },

  1. {
  2. "name": "version",
  3. "label": "Version"
  4. }
  5. ]

}] }

  1. ## 单行点击操作
  2. > 1.4.0 及以上版本
  3. 处理前面的 itemActions,还可以配置 itemAction 来实现点击某一行后进行操作,支持 [action](./action) 里的所有配置,比如弹框、刷新其它组件等。
  4. ```schema: scope="body"
  5. {
  6. "type": "service",
  7. "api": "/api/mock2/sample?perPage=10",
  8. "body": [{
  9. "type": "table",
  10. "source": "$rows",
  11. "itemAction": {
  12. "type": "button",
  13. "actionType": "dialog",
  14. "dialog": {
  15. "title": "详情",
  16. "body": "当前行的数据 browser: ${browser}, version: ${version}"
  17. }
  18. },
  19. "columns": [{
  20. "name": "browser",
  21. "label": "Browser"
  22. },
  23. {
  24. "name": "version",
  25. "label": "Version"
  26. }
  27. ]
  28. }]
  29. }

注意这个属性和 checkOnItemClick 冲突,因为都是定义行的点击行为,开启 itemActioncheckOnItemClick 将会失效。

行角标

1.5.0 及以上版本

通过属性itemBadge,可以为表格行配置角标,可以使用数据映射为每一行添加特定的 Badge 属性。visibleOn属性控制显示的条件,表达式中this可以取到行所在上下文的数据,比如行数据中有badgeText字段才显示角标,可以设置"visibleOn": "this.badgeText"

schema: scope="body" { "type": "service", "body": { "type": "table", "source": "${table}", "syncLocation": false, "itemBadge": { "text": "${badgeText}", "mode": "ribbon", "position": "top-left", "level": "${badgeLevel}", "visibleOn": "this.badgeText" }, "columns": [ { "name": "id", "label": "ID", "searchable": { "type": "input-text", "name": "id", "label": "主键", "placeholder": "输入id", "size": "sm", } }, { "name": "engine", "label": "Rendering engine" }, { "name": "browser", "label": "Browser", "searchable": { "type": "select", "name": "browser", "label": "浏览器", "placeholder": "选择浏览器", "size": "sm", "options": [ { "label": "Internet Explorer ", "value": "ie" }, { "label": "AOL browser", "value": "aol" }, { "label": "Firefox", "value": "firefox" } ] } }, { "name": "platform", "label": "Platform(s)" }, { "name": "version", "label": "Engine version", "searchable": { "type": "input-number", "name": "version", "label": "版本号", "placeholder": "输入版本号", "size": "sm", "mode": "horizontal" } }, { "name": "grade", "label": "CSS grade" } ] }, data: { table: [ { "id": 1, "engine": "Trident", "browser": "Internet Explorer 4.0", "platform": "Win 95+", "version": "4", "grade": "X", "badgeText": "默认", "badgeLevel": "info" }, { "id": 2, "engine": "Trident", "browser": "Internet Explorer 5.0", "platform": "Win 95+", "version": "5", "grade": "C", "badgeText": "危险", "badgeLevel": "danger" }, { "id": 3, "engine": "Trident", "browser": "Internet Explorer 5.5", "platform": "Win 95+", "version": "5.5", "grade": "A" }, { "id": 4, "engine": "Trident", "browser": "Internet Explorer 6", "platform": "Win 98+", "version": "6", "grade": "A" }, { "id": 5, "engine": "Trident", "browser": "Internet Explorer 7", "platform": "Win XP SP2+", "version": "7", "grade": "A" } ] } }

表格内容高度自适应

1.5.0 及以上版本

通过 autoFillHeight 可以让表格内容区自适应高度,具体效果请看这个示例

它的展现效果是整个内容区域高度自适应,表格内容较多时在内容区域内出滚动条,这样顶部筛选和底部翻页的位置都是固定的。

开启这个配置后会自动关闭 affixHeader 功能避免冲突。

属性表

属性名 类型 默认值 说明
type string "type" 指定为 table 渲染器
title string 标题
source string ${items} 数据源, 绑定当前环境变量
affixHeader boolean true 是否固定表头
columnsTogglable auto 或者 boolean auto 展示列显示开关, 自动即:列数量大于或等于 5 个时自动开启
placeholder string 或者 SchemaTpl 暂无数据 当没数据的时候的文字提示
className string panel-default 外层 CSS 类名
tableClassName string table-db table-striped 表格 CSS 类名
headerClassName string Action.md-table-header 顶部外层 CSS 类名
footerClassName string Action.md-table-footer 底部外层 CSS 类名
toolbarClassName string Action.md-table-toolbar 工具栏 CSS 类名
columns Array<Column> 用来设置列信息
combineNum number 自动合并单元格
itemActions Array<Action> 悬浮行操作按钮组
itemCheckableOn 表达式 配置当前行是否可勾选的条件,要用 表达式
itemDraggableOn 表达式 配置当前行是否可拖拽的条件,要用 表达式
checkOnItemClick boolean false 点击数据行是否可以勾选当前行
rowClassName string 给行添加 CSS 类名
rowClassNameExpr 模板 通过模板给行添加 CSS 类名
prefixRow Array 顶部总结行
affixRow Array 底部总结行
itemBadge BadgeSchema 行角标配置
autoFillHeight boolean 内容区域自适应高度
resizable boolean true 列宽度是否支持调整

列配置属性表

属性名 类型 默认值 说明
label 模板 表头文本内容
name string 通过名称关联数据
fixed left \ right \ none 是否固定当前列
popOver 弹出框
quickEdit 快速编辑
copyable boolean{icon: string, content:string} 是否可复制
sortable boolean false 是否可排序
searchable boolean \ Schema false 是否可快速搜索
width number \ string 列宽
remark 提示信息