☰

All tables sortable

Make all tables on any page sortable by converting them to dataTables

  1. // ==UserScript==
  2. // @name         All tables sortable
  3. // @namespace	 https://greasyfork.org/ru/users/303426
  4. // @version      1.4
  5. // @description  Make all tables on any page sortable by converting them to dataTables
  6. // @author       Титан
  7. // @match        *://*/*
  8. // @icon         data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNiIgaGVpZ2h0PSIxNiIgZmlsbD0iI2ZmZiIgY2xhc3M9ImJpIGJpLXRhYmxlIiB2aWV3Qm94PSIwIDAgMTYgMTYiPgogIDxwYXRoIGQ9Ik0wIDJhMiAyIDAgMCAxIDItMmgxMmEyIDIgMCAwIDEgMiAydjEyYTIgMiAwIDAgMS0yIDJIMmEyIDIgMCAwIDEtMi0yVjJ6bTE1IDJoLTR2M2g0VjR6bTAgNGgtNHYzaDRWOHptMCA0aC00djNoM2ExIDEgMCAwIDAgMS0xdi0yem0tNSAzdi0zSDZ2M2g0em0tNSAwdi0zSDF2MmExIDEgMCAwIDAgMSAxaDN6bS00LTRoNFY4SDF2M3ptMC00aDRWNEgxdjN6bTUtM3YzaDRWNEg2em00IDRINnYzaDRWOHoiLz4KPC9zdmc+
  9. // @require https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js
  10. // @grant       GM_registerMenuCommand
  11. // @require https://cdn.jsdelivr.net/npm/datatables.net@1.13.6/js/jquery.dataTables.min.js
  12. // @license MIT
  13. // ==/UserScript==
  14.  
  15. (function() {
  16. 	'use strict';
  17. 	let autolaunch = false;
  18.  
  19. 	function ConvertTables() {
  20. 		if (document.querySelector("head > link[href=\"https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css\"]") == null)
  21. 		$('head').append('<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">'); // add dataTAbles css
  22.  
  23.  
  24. 		let tables = $('table')
  25.  
  26. 		for (let i = 0; i < tables.length; i++) {
  27. 			try {
  28. 				ConvertTable_ToDataTable(tables[i]);
  29. 			} catch (e) {
  30. 				console.log(`[All tables sortable] table ${i}/${tables.length} error: ${e}`);
  31. 				console.log(tables[i]);
  32. 			}
  33. 		}
  34. 	}
  35.     
  36.     function ConvertTableFromSelection() {
  37.         const selection = window.getSelection();
  38.         let node;
  39.         if (selection?.anchorNode?.nodeType === 1) {
  40.             node = selection?.anchorNode;
  41.         } else {
  42.             node = selection?.anchorNode?.parentElement;
  43.         }
  44.  
  45.         const table = node?.closest("table");
  46.         if (table) {
  47.             addDatatablesCSS();
  48.             try {
  49.                 ConvertTable_ToDataTable(table);
  50.             } catch (e) {
  51.                 console.error("[All tables sortable] selected table error:", e, table);
  52.             }
  53.         } else {
  54.             alert("No table found near selected text.");
  55.         }
  56.     }
  57.  
  58.  
  59.  
  60. 	function ConvertTable_ToDataTable(table) {
  61. 		if (!table.querySelector("thead")) {
  62. 			ConvertHeadlessTable_ToHeadedTable(table);
  63. 		}
  64.  
  65. 		$(table).DataTable({
  66. 			"paging": false,
  67. 		});
  68. 	}
  69.  
  70. 	function ConvertHeadlessTable_ToHeadedTable(table) {
  71. 		let tbody = table.querySelector("tbody");
  72. 		if (tbody && tbody.rows.length > 0) {
  73. 			let thead = document.createElement("thead");
  74. 			let firstRow = tbody.rows[0]; // first row = header
  75. 			thead.appendChild(firstRow); // move it to <thead>
  76. 			table.insertBefore(thead, tbody); // add <thead> before <tbody>
  77. 		}
  78. 	}
  79.  
  80. 	GM_registerMenuCommand('Convert Tables', () => {
  81. 		ConvertTables();
  82. 	});
  83.     
  84.     GM_registerMenuCommand("Convert table containing selected text", () => {
  85.         ConvertTableFromSelection();
  86. });
  87.  
  88.  
  89. 	$(document).ready(function() {
  90. 		window.alert = (function() {  // suppress DataTables alert
  91. 			let nativeAlert = window.alert;
  92. 			return function(message) {
  93. 				//window.alert = nativeAlert;
  94. 				message.indexOf("DataTables warning") === 0 ?
  95. 					console.warn(message) :
  96. 					nativeAlert(message);
  97. 			}
  98. 		})();
  99.  
  100. 		if (autolaunch) {
  101. 			ConvertTables();
  102. 		}
  103.  
  104. 	});
  105.  
  106. })();