table.sort.js 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201
  1. /**
  2. * Created with JetBrains PhpStorm.
  3. * User: Jinqn
  4. * Date: 13-10-12
  5. * Time: 上午10:20
  6. * To change this template use File | Settings | File Templates.
  7. */
  8. UE.UETable.prototype.sortTable = function(sortByCellIndex, compareFn) {
  9. var table = this.table,
  10. rows = table.rows,
  11. trArray = [],
  12. flag = rows[0].cells[0].tagName === "TH",
  13. lastRowIndex = 0;
  14. if (this.selectedTds.length) {
  15. var range = this.cellsRange,
  16. len = range.endRowIndex + 1;
  17. for (var i = range.beginRowIndex; i < len; i++) {
  18. trArray[i] = rows[i];
  19. }
  20. trArray.splice(0, range.beginRowIndex);
  21. lastRowIndex = range.endRowIndex + 1 === this.rowsNum
  22. ? 0
  23. : range.endRowIndex + 1;
  24. } else {
  25. for (var i = 0, len = rows.length; i < len; i++) {
  26. trArray[i] = rows[i];
  27. }
  28. }
  29. var Fn = {
  30. reversecurrent: function(td1, td2) {
  31. return 1;
  32. },
  33. orderbyasc: function(td1, td2) {
  34. var value1 = td1.innerText || td1.textContent,
  35. value2 = td2.innerText || td2.textContent;
  36. return value1.localeCompare(value2);
  37. },
  38. reversebyasc: function(td1, td2) {
  39. var value1 = td1.innerHTML,
  40. value2 = td2.innerHTML;
  41. return value2.localeCompare(value1);
  42. },
  43. orderbynum: function(td1, td2) {
  44. var value1 = td1[browser.ie ? "innerText" : "textContent"].match(/\d+/),
  45. value2 = td2[browser.ie ? "innerText" : "textContent"].match(/\d+/);
  46. if (value1) value1 = +value1[0];
  47. if (value2) value2 = +value2[0];
  48. return (value1 || 0) - (value2 || 0);
  49. },
  50. reversebynum: function(td1, td2) {
  51. var value1 = td1[browser.ie ? "innerText" : "textContent"].match(/\d+/),
  52. value2 = td2[browser.ie ? "innerText" : "textContent"].match(/\d+/);
  53. if (value1) value1 = +value1[0];
  54. if (value2) value2 = +value2[0];
  55. return (value2 || 0) - (value1 || 0);
  56. }
  57. };
  58. //对表格设置排序的标记data-sort-type
  59. table.setAttribute(
  60. "data-sort-type",
  61. compareFn && typeof compareFn === "string" && Fn[compareFn] ? compareFn : ""
  62. );
  63. //th不参与排序
  64. flag && trArray.splice(0, 1);
  65. trArray = utils.sort(trArray, function(tr1, tr2) {
  66. var result;
  67. if (compareFn && typeof compareFn === "function") {
  68. result = compareFn.call(
  69. this,
  70. tr1.cells[sortByCellIndex],
  71. tr2.cells[sortByCellIndex]
  72. );
  73. } else if (compareFn && typeof compareFn === "number") {
  74. result = 1;
  75. } else if (compareFn && typeof compareFn === "string" && Fn[compareFn]) {
  76. result = Fn[compareFn].call(
  77. this,
  78. tr1.cells[sortByCellIndex],
  79. tr2.cells[sortByCellIndex]
  80. );
  81. } else {
  82. result = Fn["orderbyasc"].call(
  83. this,
  84. tr1.cells[sortByCellIndex],
  85. tr2.cells[sortByCellIndex]
  86. );
  87. }
  88. return result;
  89. });
  90. var fragment = table.ownerDocument.createDocumentFragment();
  91. for (var j = 0, len = trArray.length; j < len; j++) {
  92. fragment.appendChild(trArray[j]);
  93. }
  94. var tbody = table.getElementsByTagName("tbody")[0];
  95. if (!lastRowIndex) {
  96. tbody.appendChild(fragment);
  97. } else {
  98. tbody.insertBefore(
  99. fragment,
  100. rows[lastRowIndex - range.endRowIndex + range.beginRowIndex - 1]
  101. );
  102. }
  103. };
  104. UE.plugins["tablesort"] = function() {
  105. var me = this,
  106. UT = UE.UETable,
  107. getUETable = function(tdOrTable) {
  108. return UT.getUETable(tdOrTable);
  109. },
  110. getTableItemsByRange = function(editor) {
  111. return UT.getTableItemsByRange(editor);
  112. };
  113. me.ready(function() {
  114. //添加表格可排序的样式
  115. utils.cssRule(
  116. "tablesort",
  117. "table.sortEnabled tr.firstRow th,table.sortEnabled tr.firstRow td{padding-right:20px;background-repeat: no-repeat;background-position: center right;" +
  118. " background-image:url(" +
  119. me.options.themePath +
  120. me.options.theme +
  121. "/images/sortable.png);}",
  122. me.document
  123. );
  124. //做单元格合并操作时,清除可排序标识
  125. me.addListener("afterexeccommand", function(type, cmd) {
  126. if (cmd == "mergeright" || cmd == "mergedown" || cmd == "mergecells") {
  127. this.execCommand("disablesort");
  128. }
  129. });
  130. });
  131. //表格排序
  132. UE.commands["sorttable"] = {
  133. queryCommandState: function() {
  134. var me = this,
  135. tableItems = getTableItemsByRange(me);
  136. if (!tableItems.cell) return -1;
  137. var table = tableItems.table,
  138. cells = table.getElementsByTagName("td");
  139. for (var i = 0, cell; (cell = cells[i++]); ) {
  140. if (cell.rowSpan != 1 || cell.colSpan != 1) return -1;
  141. }
  142. return 0;
  143. },
  144. execCommand: function(cmd, fn) {
  145. var me = this,
  146. range = me.selection.getRange(),
  147. bk = range.createBookmark(true),
  148. tableItems = getTableItemsByRange(me),
  149. cell = tableItems.cell,
  150. ut = getUETable(tableItems.table),
  151. cellInfo = ut.getCellInfo(cell);
  152. ut.sortTable(cellInfo.cellIndex, fn);
  153. range.moveToBookmark(bk);
  154. try {
  155. range.select();
  156. } catch (e) {}
  157. }
  158. };
  159. //设置表格可排序,清除表格可排序
  160. UE.commands["enablesort"] = UE.commands["disablesort"] = {
  161. queryCommandState: function(cmd) {
  162. var table = getTableItemsByRange(this).table;
  163. if (table && cmd == "enablesort") {
  164. var cells = domUtils.getElementsByTagName(table, "th td");
  165. for (var i = 0; i < cells.length; i++) {
  166. if (
  167. cells[i].getAttribute("colspan") > 1 ||
  168. cells[i].getAttribute("rowspan") > 1
  169. )
  170. return -1;
  171. }
  172. }
  173. return !table
  174. ? -1
  175. : (cmd == "enablesort") ^
  176. (table.getAttribute("data-sort") != "sortEnabled")
  177. ? -1
  178. : 0;
  179. },
  180. execCommand: function(cmd) {
  181. var table = getTableItemsByRange(this).table;
  182. table.setAttribute(
  183. "data-sort",
  184. cmd == "enablesort" ? "sortEnabled" : "sortDisabled"
  185. );
  186. cmd == "enablesort"
  187. ? domUtils.addClass(table, "sortEnabled")
  188. : domUtils.removeClasses(table, "sortEnabled");
  189. }
  190. };
  191. };