( function ( $, mw ) { var config = { wgMonthNames: ['', 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'], wgMonthNamesShort: ['', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'], wgDefaultDateFormat: 'dmy', wgContentLanguage: 'en' }; QUnit.module( 'jquery.tablesorter', QUnit.newMwEnvironment({ config: config }) ); /** * Create an HTML table from an array of row arrays containing text strings. * First row will be header row. No fancy rowspan/colspan stuff. * * @param {String[]} header * @param {String[][]} data * @return jQuery */ function tableCreate( header, data ) { var i, $table = $( '
' ), $thead = $table.find( 'thead' ), $tbody = $table.find( 'tbody' ), $tr = $( '' ); $.each( header, function ( i, str ) { var $th = $( '' ); $th.text( str ).appendTo( $tr ); }); $tr.appendTo( $thead ); for ( i = 0; i < data.length; i++ ) { $tr = $( '' ); $.each( data[i], function ( j, str ) { var $td = $( '' ); $td.text( str ).appendTo( $tr ); }); $tr.appendTo( $tbody ); } return $table; } /** * Extract text from table. * * @param {jQuery} $table * @return String[][] */ function tableExtract( $table ) { var data = []; $table.find( 'tbody' ).find( 'tr' ).each( function( i, tr ) { var row = []; $( tr ).find( 'td,th' ).each( function( i, td ) { row.push( $( td ).text() ); }); data.push( row ); }); return data; } /** * Run a table test by building a table with the given data, * running some callback on it, then checking the results. * * @param {String} msg text to pass on to qunit for the comparison * @param {String[]} header cols to make the table * @param {String[][]} data rows/cols to make the table * @param {String[][]} expected rows/cols to compare against at end * @param {function($table)} callback something to do with the table before we compare */ function tableTest( msg, header, data, expected, callback ) { QUnit.test( msg, 1, function ( assert ) { var $table = tableCreate( header, data ); // Give caller a chance to set up sorting and manipulate the table. callback( $table ); // Table sorting is done synchronously; if it ever needs to change back // to asynchronous, we'll need a timeout or a callback here. var extracted = tableExtract( $table ); assert.deepEqual( extracted, expected, msg ); }); } function reversed(arr) { // Clone array var arr2 = arr.slice(0); arr2.reverse(); return arr2; } // Sample data set using planets named and their radius var header = [ 'Planet' , 'Radius (km)'], mercury = [ 'Mercury', '2439.7' ], venus = [ 'Venus' , '6051.8' ], earth = [ 'Earth' , '6371.0' ], mars = [ 'Mars' , '3390.0' ], jupiter = [ 'Jupiter', '69911' ], saturn = [ 'Saturn' , '58232' ]; // Initial data set var planets = [mercury, venus, earth, mars, jupiter, saturn]; var ascendingName = [earth, jupiter, mars, mercury, saturn, venus]; var ascendingRadius = [mercury, mars, venus, earth, saturn, jupiter]; tableTest( 'Basic planet table: ascending by name', header, planets, ascendingName, function ( $table ) { $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); tableTest( 'Basic planet table: ascending by name a second time', header, planets, ascendingName, function ( $table ) { $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); tableTest( 'Basic planet table: descending by name', header, planets, reversed(ascendingName), function ( $table ) { $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click().click(); } ); tableTest( 'Basic planet table: ascending radius', header, planets, ascendingRadius, function ( $table ) { $table.tablesorter(); $table.find( '.headerSort:eq(1)' ).click(); } ); tableTest( 'Basic planet table: descending radius', header, planets, reversed(ascendingRadius), function ( $table ) { $table.tablesorter(); $table.find( '.headerSort:eq(1)' ).click().click(); } ); // Regression tests! tableTest( 'Bug 28775: German-style (dmy) short numeric dates', ['Date'], [ // German-style dates are day-month-year ['11.11.2011'], ['01.11.2011'], ['02.10.2011'], ['03.08.2011'], ['09.11.2011'] ], [ // Sorted by ascending date ['03.08.2011'], ['02.10.2011'], ['01.11.2011'], ['09.11.2011'], ['11.11.2011'] ], function ( $table ) { mw.config.set( 'wgDefaultDateFormat', 'dmy' ); mw.config.set( 'wgContentLanguage', 'de' ); $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); tableTest( 'Bug 28775: American-style (mdy) short numeric dates', ['Date'], [ // American-style dates are month-day-year ['11.11.2011'], ['01.11.2011'], ['02.10.2011'], ['03.08.2011'], ['09.11.2011'] ], [ // Sorted by ascending date ['01.11.2011'], ['02.10.2011'], ['03.08.2011'], ['09.11.2011'], ['11.11.2011'] ], function ( $table ) { mw.config.set( 'wgDefaultDateFormat', 'mdy' ); $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); var ipv4 = [ // Some randomly generated fake IPs ['45.238.27.109'], ['44.172.9.22'], ['247.240.82.209'], ['204.204.132.158'], ['170.38.91.162'], ['197.219.164.9'], ['45.68.154.72'], ['182.195.149.80'] ]; var ipv4Sorted = [ // Sort order should go octet by octet ['44.172.9.22'], ['45.68.154.72'], ['45.238.27.109'], ['170.38.91.162'], ['182.195.149.80'], ['197.219.164.9'], ['204.204.132.158'], ['247.240.82.209'] ]; tableTest( 'Bug 17141: IPv4 address sorting', ['IP'], ipv4, ipv4Sorted, function ( $table ) { $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); tableTest( 'Bug 17141: IPv4 address sorting (reverse)', ['IP'], ipv4, reversed(ipv4Sorted), function ( $table ) { $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click().click(); } ); var umlautWords = [ // Some words with Umlauts ['Günther'], ['Peter'], ['Björn'], ['Bjorn'], ['Apfel'], ['Äpfel'], ['Strasse'], ['Sträßschen'] ]; var umlautWordsSorted = [ // Some words with Umlauts ['Äpfel'], ['Apfel'], ['Björn'], ['Bjorn'], ['Günther'], ['Peter'], ['Sträßschen'], ['Strasse'] ]; tableTest( 'Accented Characters with custom collation', ['Name'], umlautWords, umlautWordsSorted, function ( $table ) { mw.config.set( 'tableSorterCollation', { 'ä': 'ae', 'ö': 'oe', 'ß': 'ss', 'ü':'ue' } ); $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); var planetsRowspan = [["Earth","6051.8"], jupiter, ["Mars","6051.8"], mercury, saturn, venus]; var planetsRowspanII = [jupiter, mercury, saturn, venus, ['Venus', '6371.0'], ['Venus', '3390.0']]; tableTest( 'Basic planet table: same value for multiple rows via rowspan', header, planets, planetsRowspan, function ( $table ) { // Modify the table to have a multiuple-row-spanning cell: // - Remove 2nd cell of 4th row, and, 2nd cell or 5th row. $table.find( 'tr:eq(3) td:eq(1), tr:eq(4) td:eq(1)' ).remove(); // - Set rowspan for 2nd cell of 3rd row to 3. // This covers the removed cell in the 4th and 5th row. $table.find( 'tr:eq(2) td:eq(1)' ).prop( 'rowspan', '3' ); $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); tableTest( 'Basic planet table: Same value for multiple rows via rowspan II', header, planets, planetsRowspanII, function ( $table ) { // Modify the table to have a multiuple-row-spanning cell: // - Remove 1st cell of 4th row, and, 1st cell or 5th row. $table.find( 'tr:eq(3) td:eq(0), tr:eq(4) td:eq(0)' ).remove(); // - Set rowspan for 1st cell of 3rd row to 3. // This covers the removed cell in the 4th and 5th row. $table.find( 'tr:eq(2) td:eq(0)' ).prop( 'rowspan', '3' ); $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); var complexMDYDates = [ // Some words with Umlauts ['January, 19 2010'], ['April 21 1991'], ['04 22 1991'], ['5.12.1990'], ['December 12 \'10'] ]; var complexMDYSorted = [ ['5.12.1990'], ['April 21 1991'], ['04 22 1991'], ['January, 19 2010'], ['December 12 \'10'] ]; tableTest( 'Complex date parsing I', ['date'], complexMDYDates, complexMDYSorted, function ( $table ) { mw.config.set( 'wgDefaultDateFormat', 'mdy' ); $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); var currencyUnsorted = [ ['1.02 $'], ['$ 3.00'], ['€ 2,99'], ['$ 1.00'], ['$3.50'], ['$ 1.50'], ['€ 0.99'] ]; var currencySorted = [ ['€ 0.99'], ['$ 1.00'], ['1.02 $'], ['$ 1.50'], ['$ 3.00'], ['$3.50'], // Comma's sort after dots // Not intentional but test to detect changes ['€ 2,99'] ]; tableTest( 'Currency parsing I', ['currency'], currencyUnsorted, currencySorted, function ( $table ) { $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); var ascendingNameLegacy = ascendingName.slice(0); ascendingNameLegacy[4] = ascendingNameLegacy[5]; ascendingNameLegacy.pop(); tableTest( 'Legacy compat with .sortbottom', header, planets, ascendingNameLegacy, function( $table ) { $table.find( 'tr:last' ).addClass( 'sortbottom' ); $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); /** FIXME: the diff output is not very readeable. */ QUnit.test( 'bug 32047 - caption must be before thead', function ( assert ) { var $table; $table = $( '' + '' + '' + '' + '' + '' + '
CAPTION
THEAD
A
B
TFOOT
' ); $table.tablesorter(); assert.equal( $table.children( ).get( 0 ).nodeName, 'CAPTION', 'First element after must be (bug 32047)' ); }); QUnit.test( 'data-sort-value attribute, when available, should override sorting position', function ( assert ) { var $table, data; // Example 1: All cells except one cell without data-sort-value, // which should be sorted at it's text content value. $table = $( '' + '' + '' + '' + '' + '' + '' + '
Data
Cheetah
Bird
Ferret
Elephant
Dolphin
' ); $table.tablesorter().find( '.headerSort:eq(0)' ).click(); data = []; $table.find( 'tbody > tr' ).each( function( i, tr ) { $( tr ).find( 'td' ).each( function( i, td ) { data.push( { data: $( td ).data( 'sortValue' ), text: $( td ).text() } ); }); }); assert.deepEqual( data, [ { data: 'Apple', text: 'Bird' }, { data: 'Bananna', text: 'Ferret' }, { data: undefined, text: 'Cheetah' }, { data: 'Cherry', text: 'Dolphin' }, { data: 'Drupe', text: 'Elephant' } ], 'Order matches expected order (based on data-sort-value attribute values)' ); // Example 2 $table = $( '' + '' + '' + '' + '' + '' + '' + '
Data
D
A
B
G
C
' ); $table.tablesorter().find( '.headerSort:eq(0)' ).click(); data = []; $table.find( 'tbody > tr' ).each( function ( i, tr ) { $( tr ).find( 'td' ).each( function ( i, td ) { data.push( { data: $( td ).data( 'sortValue' ), text: $( td ).text() } ); }); }); assert.deepEqual( data, [ { data: undefined, text: 'B' }, { data: undefined, text: 'D' }, { data: 'E', text: 'A' }, { data: 'F', text: 'C' }, { data: undefined, text: 'G' } ], 'Order matches expected order (based on data-sort-value attribute values)' ); // Example 3: Test that live changes are used from data-sort-value, // even if they change after the tablesorter is constructed (bug 38152). $table = $( '' + '' + '' + '' + '' + '' + '' + '
Data
D
A
B
G
C
' ); // initialize table sorter and sort once $table .tablesorter() .find( '.headerSort:eq(0)' ).click(); // Change the sortValue data properties (bug 38152) // - change data $table.find( 'td:contains(A)' ).data( 'sortValue', 3 ); // - add data $table.find( 'td:contains(B)' ).data( 'sortValue', 1 ); // - remove data, bring back attribute: 2 $table.find( 'td:contains(G)' ).removeData( 'sortValue' ); // Now sort again (twice, so it is back at Ascending) $table.find( '.headerSort:eq(0)' ).click(); $table.find( '.headerSort:eq(0)' ).click(); data = []; $table.find( 'tbody > tr' ).each( function( i, tr ) { $( tr ).find( 'td' ).each( function( i, td ) { data.push( { data: $( td ).data( 'sortValue' ), text: $( td ).text() } ); }); }); assert.deepEqual( data, [ { data: 1, text: "B" }, { data: 2, text: "G" }, { data: 3, text: "A" }, { data: undefined, text: "C" }, { data: undefined, text: "D" } ], 'Order matches expected order, using the current sortValue in $.data()' ); }); var numbers = [ [ '12' ], [ '7' ], [ '13,000'], [ '9' ], [ '14' ], [ '8.0' ] ]; var numbersAsc = [ [ '7' ], [ '8.0' ], [ '9' ], [ '12' ], [ '14' ], [ '13,000'] ]; tableTest( 'bug 8115: sort numbers with commas (ascending)', ['Numbers'], numbers, numbersAsc, function( $table ) { $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); tableTest( 'bug 8115: sort numbers with commas (descending)', ['Numbers'], numbers, reversed(numbersAsc), function( $table ) { $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click().click(); } ); // TODO add numbers sorting tests for bug 8115 with a different language QUnit.test( 'bug 32888 - Tables inside a tableheader cell', 2, function ( assert ) { var $table; $table = $( '' + '' + '' + '' + '
header'+ '' + '
12
A
B
' ); $table.tablesorter(); assert.equal( $table.find('> thead:eq(0) > tr > th.headerSort').length, 1, 'Child tables inside a headercell should not interfere with sortable headers (bug 32888)' ); assert.equal( $( '#mw-bug-32888-2' ).find('th.headerSort').length, 0, 'The headers of child tables inside a headercell should not be sortable themselves (bug 32888)' ); }); var correctDateSorting1 = [ ['01 January 2010'], ['05 February 2010'], ['16 January 2010'] ]; var correctDateSortingSorted1 = [ ['01 January 2010'], ['16 January 2010'], ['05 February 2010'] ]; tableTest( 'Correct date sorting I', ['date'], correctDateSorting1, correctDateSortingSorted1, function ( $table ) { mw.config.set( 'wgDefaultDateFormat', 'mdy' ); $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); var correctDateSorting2 = [ ['January 01 2010'], ['February 05 2010'], ['January 16 2010'] ]; var correctDateSortingSorted2 = [ ['January 01 2010'], ['January 16 2010'], ['February 05 2010'] ]; tableTest( 'Correct date sorting II', ['date'], correctDateSorting2, correctDateSortingSorted2, function ( $table ) { mw.config.set( 'wgDefaultDateFormat', 'dmy' ); $table.tablesorter(); $table.find( '.headerSort:eq(0)' ).click(); } ); }( jQuery, mediaWiki ) );