bootstrap-table-group-by.js 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228
  1. /**
  2. * @author: Dennis Hernández
  3. * @webSite: http://djhvscf.github.io/Blog
  4. * @version: v1.0.0
  5. */
  6. !function ($) {
  7. 'use strict';
  8. var originalRowAttr,
  9. dataTTId = 'data-tt-id',
  10. dataTTParentId = 'data-tt-parent-id',
  11. obj = {},
  12. parentId = undefined;
  13. var getFieldIndex = function (columns, field) {
  14. var index = -1;
  15. $.each(columns, function (i, column) {
  16. if (column.field === field) {
  17. index = i;
  18. return false;
  19. }
  20. return true;
  21. });
  22. return index;
  23. };
  24. var getParentRowId = function (that, id) {
  25. var parentRows = that.$body.find('tr').not('[' + 'data-tt-parent-id]');
  26. for (var i = 0; i < parentRows.length; i++) {
  27. if (i === id) {
  28. return $(parentRows[i]).attr('data-tt-id');
  29. }
  30. }
  31. return undefined;
  32. };
  33. var sumData = function (that, data) {
  34. var sumRow = {};
  35. $.each(data, function (i, row) {
  36. for(var prop in row) {
  37. if (!row.IsParent) {
  38. if (!isNaN(parseFloat(row[prop]))) {
  39. if (that.columns[getFieldIndex(that.columns, prop)].groupBySumGroup) {
  40. if (sumRow[prop] === undefined) {
  41. sumRow[prop] = 0;
  42. }
  43. sumRow[prop] += +row[prop];
  44. }
  45. }
  46. }
  47. }
  48. });
  49. return sumRow;
  50. };
  51. var rowAttr = function (row, index) {
  52. //Call the User Defined Function
  53. originalRowAttr.apply([row, index]);
  54. obj[dataTTId.toString()] = index;
  55. if (!row.IsParent) {
  56. obj[dataTTParentId.toString()] = parentId === undefined ? index : parentId;
  57. } else {
  58. parentId = index;
  59. delete obj[dataTTParentId.toString()];
  60. }
  61. return obj;
  62. };
  63. var setObjectKeys = function () {
  64. // From https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Object/keys
  65. Object.keys = function (o) {
  66. if (o !== Object(o)) {
  67. throw new TypeError('Object.keys called on a non-object');
  68. }
  69. var k = [],
  70. p;
  71. for (p in o) {
  72. if (Object.prototype.hasOwnProperty.call(o, p)) {
  73. k.push(p);
  74. }
  75. }
  76. return k;
  77. }
  78. };
  79. var groupBy = function (array , f) {
  80. var groups = {};
  81. $.each(array, function(i, o) {
  82. var group = JSON.stringify(f(o));
  83. groups[group] = groups[group] || [];
  84. groups[group].push(o);
  85. });
  86. return Object.keys(groups).map(function (group) {
  87. return groups[group];
  88. });
  89. };
  90. var makeGrouped = function (that, data) {
  91. var newRow = {},
  92. newData = [],
  93. sumRow = {};
  94. var result = groupBy(data, function (item) {
  95. return [item[that.options.groupByField]];
  96. });
  97. for (var i = 0; i < result.length; i++) {
  98. newRow[that.options.groupByField.toString()] = result[i][0][that.options.groupByField];
  99. newRow.IsParent = true;
  100. result[i].unshift(newRow);
  101. if (that.options.groupBySumGroup) {
  102. sumRow = sumData(that, result[i])
  103. if (!$.isEmptyObject(sumRow)) {
  104. result[i].push(sumRow);
  105. }
  106. }
  107. newRow = {};
  108. }
  109. newData = newData.concat.apply(newData, result);
  110. if (!that.options.loaded && newData.length > 0) {
  111. that.options.loaded = true;
  112. that.options.originalData = that.options.data;
  113. that.options.data = newData;
  114. }
  115. return newData;
  116. };
  117. $.extend($.fn.bootstrapTable.defaults, {
  118. groupBy: false,
  119. groupByField: '',
  120. groupBySumGroup: false,
  121. groupByInitExpanded: undefined, //node, 'all'
  122. //internal variables
  123. loaded: false,
  124. originalData: undefined
  125. });
  126. $.fn.bootstrapTable.methods.push('collapseAll', 'expandAll');
  127. $.extend($.fn.bootstrapTable.COLUMN_DEFAULTS, {
  128. groupBySumGroup: false
  129. });
  130. var BootstrapTable = $.fn.bootstrapTable.Constructor,
  131. _init = BootstrapTable.prototype.init,
  132. _initData = BootstrapTable.prototype.initData;
  133. BootstrapTable.prototype.init = function () {
  134. //Temporal validation
  135. if (!this.options.sortName) {
  136. if ((this.options.groupBy) && (this.options.groupByField !== '')) {
  137. var that = this;
  138. // Compatibility: IE < 9 and old browsers
  139. if (!Object.keys) {
  140. setObjectKeys();
  141. }
  142. //Make sure that the internal variables are set correctly
  143. this.options.loaded = false;
  144. this.options.originalData = undefined;
  145. originalRowAttr = this.options.rowAttributes;
  146. this.options.rowAttributes = rowAttr;
  147. this.$el.on('post-body.bs.table', function () {
  148. that.$el.treetable({
  149. expandable: true,
  150. onNodeExpand: function () {
  151. if (that.options.height) {
  152. that.resetHeader();
  153. }
  154. },
  155. onNodeCollapse: function () {
  156. if (that.options.height) {
  157. that.resetHeader();
  158. }
  159. }
  160. }, true);
  161. if (that.options.groupByInitExpanded !== undefined) {
  162. if (typeof that.options.groupByInitExpanded === 'number') {
  163. that.expandNode(that.options.groupByInitExpanded);
  164. } else if (that.options.groupByInitExpanded.toLowerCase() === 'all') {
  165. that.expandAll();
  166. }
  167. }
  168. });
  169. }
  170. }
  171. _init.apply(this, Array.prototype.slice.apply(arguments));
  172. };
  173. BootstrapTable.prototype.initData = function (data, type) {
  174. //Temporal validation
  175. if (!this.options.sortName) {
  176. if ((this.options.groupBy) && (this.options.groupByField !== '')) {
  177. data = makeGrouped(this, data ? data : this.options.data);
  178. }
  179. }
  180. _initData.apply(this, [data, type]);
  181. };
  182. BootstrapTable.prototype.expandAll = function () {
  183. this.$el.treetable('expandAll');
  184. };
  185. BootstrapTable.prototype.collapseAll = function () {
  186. this.$el.treetable('collapseAll');
  187. };
  188. BootstrapTable.prototype.expandNode = function (id) {
  189. id = getParentRowId(this, id);
  190. if (id !== undefined) {
  191. this.$el.treetable('expandNode', id);
  192. }
  193. }
  194. }(jQuery);