Table Sort

I am using sorttable.js to sort a table which works fine which allows a
user to sort the table by clicking on the column header. Is there some
code I could add to the page (onload or something) to auto sort by the
first column without user clicking on it. Here is the sorttable.js
code.


addEvent(window, "load", sortables_init);


var SORT_COLUMN_INDEX;


function sortables_init() {
// Find all tables with class sortable and make them sortable
if (!document.getElementsByTagNam*e) return;
tbls = document.getElementsByTagName(*"table");
for (ti=0;ti<tbls.length;ti++) {
thisTbl = tbls[ti];
if (((' '+thisTbl.className+' ').indexOf("sortable") != -1) &&
(thisTbl.id)) {
//initTable(thisTbl.id);
ts_makeSortable(thisTbl);
}
}



}


function ts_makeSortable(table) {
if (table.rows && table.rows.length > 0) {
var firstRow = table.rows[0];
}
if (!firstRow) return;

// We have a first row: assume it's the header, and make its
contents clickable links
for (var i=0;i<firstRow.cells.length;i+*+) {
var cell = firstRow.cells[i];
var txt = ts_getInnerText(cell);
if (cell.getAttribute('sortsuppre*ss')) {
continue;
}
cell.innerHTML = '<a href="#" class="sortheader"
onclick="ts_resortTable(this);*return false;">'+txt+'<span
class="sortarrow">&nbsp;&nbsp;*&nbsp;</span></a>';
}



}


function ts_getInnerText(el) {
if (typeof el == "string") return el;
if (typeof el == "undefined") { return el };
if (el.innerText) return el.innerText; //Not needed but it is
faster
var str = "";

var cs = el.childNodes;
var l = cs.length;
for (var i = 0; i < l; i++) {
switch (cs[i].nodeType) {
case 1: //ELEMENT_NODE
str += ts_getInnerText(cs[i]);
break;
case 3: //TEXT_NODE
str += cs[i].nodeValue;
break;
}
}
return str;



}


function ts_resortTable(lnk) {
// get the span
var span;
for (var ci=0;ci<lnk.childNodes.length;*ci++) {
if (lnk.childNodes[ci].tagName &&
lnk.childNodes[ci].tagName.toL*owerCase() == 'span') span =
lnk.childNodes[ci];
}
var spantext = ts_getInnerText(span);
var td = lnk.parentNode;
var column = td.cellIndex;
var table = getParent(td,'TABLE');
var row_count = 0;
var test_row = 1;
var i, el;

var sortval =
table.rows[test_row].cells[col*umn].getAttribute('sortval');


// Work out a type for the column
if (table.rows.length <= 1) return;
for (i=1; i<table.rows.length; i++) {
if (table.rows[i].id.indexOf('sec*tion_row') == -1) {
test_row = i;
break;
}
}


if (typeof(sortval) !='undefined' && sortval)
{
sortfn = ts_sort_sortval;
} else {
var itm = ts_getInnerText(table.rows[tes*t_row].cells[column]);
sortfn = ts_sort_caseinsensitive;
if (itm.match(/^\d\d[\/-]\d\d[\/-*]\d\d\d\d$/)) sortfn =
ts_sort_date;
if (itm.match(/^\d\d[\/-]\d\d[\/-*]\d\d$/)) sortfn =
ts_sort_date;
if (itm.match(/^[$]/)) sortfn = ts_sort_currency;
if (itm.match(/^[\d\.]+$/)) sortfn = ts_sort_numeric;
}
SORT_COLUMN_INDEX = column;
var firstRow = new Array();
var newRows = new Array();
for (i=0;i<table.rows[0].length;i+*+) {
firstRow[i] = table.rows[0][i];
}
for (j=1;j<table.rows.length;j++) {
// We don't sort section/folder rows, so we skip them here:
if ((table.rows[j].parentNode.nod*eName == 'TBODY')
&& (table.rows[j].id.indexOf("sec*tion_row") == -1)) {
newRows[row_count] = table.rows[j];
row_count++;
}
}


newRows.sort(sortfn);


if (span.getAttribute("sortdir") == 'down') {
ARROW = '&nbsp;&nbsp;&uarr;';
newRows.reverse();
span.setAttribute('sortdir','u*p');
} else {
ARROW = '&nbsp;&nbsp;&darr;';
span.setAttribute('sortdir','d*own');
}


// We appendChild rows that already exist to the tbody, so it moves

them rather than creating new ones
// don't do sortbottom rows
for (i=0;i<newRows.length;i++) { if (!newRows[i].className ||
(newRows[i].className && (newRows[i].className.indexOf(*'sortbottom')
==
-1))) table.tBodies[0].appendChild(n*ewRows[i]);}
// do sortbottom rows only
for (i=0;i<newRows.length;i++) { if (newRows[i].className &&
(newRows[i].className.indexOf(*'sortbottom') != -1))
table.tBodies[0].appendChild(n*ewRows[i]);}


// Delete any other arrows there may be showing
var allspans = document.getElementsByTagName(*"span");
for (var ci=0;ci<allspans.length;ci++) {
if (allspans[ci].className == 'sortarrow') {
if (getParent(allspans[ci],"table*") ==
getParent(lnk,"table")) { // in the same table as us?
allspans[ci].innerHTML = '&nbsp;&nbsp;&nbsp;';
}
}
}


span.innerHTML = ARROW;



}


function getParent(el, pTagName) {
if (el == null) return null;
else if (el.nodeType == 1 && el.tagName.toLowerCase() ==
pTagName.toLowerCase()) // Gecko bug, supposed to be uppercase
return el;
else
return getParent(el.parentNode, pTagName);

}


function ts_sort_date(a,b) {
// y2k notes: two digit years less than 50 are treated as 20XX,
greater than 50 are treated as 19XX
aa = ts_getInnerText(a.cells[SORT_C*OLUMN_INDEX]);
bb = ts_getInnerText(b.cells[SORT_C*OLUMN_INDEX]);
if (aa.length == 10) {
dt1 = aa.substr(6,4)+aa.substr(3,2)+*aa.substr(0,2);
} else {
yr = aa.substr(6,2);
if (parseInt(yr) < 50) { yr = '20'+yr; } else { yr = '19'+yr; }

dt1 = yr+aa.substr(3,2)+aa.substr(0,*2);
}
if (bb.length == 10) {
dt2 = bb.substr(6,4)+bb.substr(3,2)+*bb.substr(0,2);
} else {
yr = bb.substr(6,2);
if (parseInt(yr) < 50) { yr = '20'+yr; } else { yr = '19'+yr; }

dt2 = yr+bb.substr(3,2)+bb.substr(0,*2);
}
if (dt1==dt2) return 0;
if (dt1<dt2) return -1;
return 1;


}


function ts_sort_currency(a,b) {
aa =
ts_getInnerText(a.cells[SORT_C*OLUMN_INDEX]).replace(/[^0-9.]*/g,'');

bb =
ts_getInnerText(b.cells[SORT_C*OLUMN_INDEX]).replace(/[^0-9.]*/g,'');

return parseFloat(aa) - parseFloat(bb);


}


function ts_sort_numeric(a,b) {
aa = parseFloat(ts_getInnerText(a.c*ells[SORT_COLUMN_INDEX]));
if (isNaN(aa)) aa = 0;
bb = parseFloat(ts_getInnerText(b.c*ells[SORT_COLUMN_INDEX]));
if (isNaN(bb)) bb = 0;
return aa-bb;


}


function ts_sort_caseinsensitive(a,b) {
aa = ts_getInnerText(a.cells[SORT_C*OLUMN_INDEX]).toLowerCase();
bb = ts_getInnerText(b.cells[SORT_C*OLUMN_INDEX]).toLowerCase();
if (aa==bb) return 0;
if (aa == '') return 1;
if (bb == '') return -1;
if (aa<bb) return -1;
return 1;


}


function ts_sort_sortval(a,b) {
aa = a.cells[SORT_COLUMN_INDEX].get*Attribute('sortval');
bb = b.cells[SORT_COLUMN_INDEX].get*Attribute('sortval');
if (aa==bb) return 0;
if (aa<bb) return -1;
return 1;


}


function ts_sort_default(a,b) {
aa = ts_getInnerText(a.cells[SORT_C*OLUMN_INDEX]);
bb = ts_getInnerText(b.cells[SORT_C*OLUMN_INDEX]);
if (aa==bb) return 0;
if (aa<bb) return -1;
return 1;


}


function addEvent(elm, evType, fn, useCapture)
// addEvent and removeEvent
// cross-browser event handling for IE5+, NS6 and Mozilla
// By Scott Andrew
{
if (elm.addEventListener){
elm.addEventListener(evType, fn, useCapture);
return true;
} else if (elm.attachEvent){
var r = elm.attachEvent("on"+evType, fn);
return r;
} else {
alert("Handler could not be removed");
}

jeffsal (AT) charter (DOT) net wrote:

I am using sorttable.js to sort a table which works fine which allows a
user to sort the table by clicking on the column header. Is there some
code I could add to the page (onload or something) to auto sort by the
first column without user clicking on it. Here is the sorttable.js
code.
source code snipped)

If you give each table heading link a unique ID (I did it here by
including the parent table's ID):

cell.innerHTML = '<a href="#" class="sortheader"
id='+table.id+'_a'+i+' onclick="ts_resortTable(this);return
false;">'+txt+'<span class="sortarrow">&nbsp;&nbsp;&nbsp;</span></a>';

You can call the sort function and send it any link you want, at the end
of the init function:

ts_resortTable(document.getElementById('table0_a0' ));

Since you're coding it by hand, you have to make sure the link exists, I
didn't write any error checking).

Modify which table is sorted by changing the table id part of the string:

table0_a0
table1_a0
table2_a0

MOdify which column is sorted by changing the link number:

table0_a0
table0_a1
table0_a2

MIke

addEvent(window, "load", sortables_init);
var SORT_COLUMN_INDEX;


function sortables_init() {
// Find all tables with class sortable and make them sortable
if (!document.getElementsByTagNam*e) return;
tbls = document.getElementsByTagName(*"table");
for (ti=0;ti<tbls.length;ti++) {
thisTbl = tbls[ti];
if (((' '+thisTbl.className+' ').indexOf("sortable") != -1) &&
(thisTbl.id)) {
//initTable(thisTbl.id);
ts_makeSortable(thisTbl);
}
}



}


function ts_makeSortable(table) {
if (table.rows && table.rows.length > 0) {
var firstRow = table.rows[0];
}
if (!firstRow) return;

// We have a first row: assume it's the header, and make its
contents clickable links
for (var i=0;i<firstRow.cells.length;i+*+) {
var cell = firstRow.cells[i];
var txt = ts_getInnerText(cell);
if (cell.getAttribute('sortsuppre*ss')) {
continue;
}
cell.innerHTML = '<a href="#" class="sortheader"
onclick="ts_resortTable(this);*return false;">'+txt+'<span
class="sortarrow">&nbsp;&nbsp;*&nbsp;</span></a>';
}



}


function ts_getInnerText(el) {
if (typeof el == "string") return el;
if (typeof el == "undefined") { return el };
if (el.innerText) return el.innerText; //Not needed but it is
faster
var str = "";

var cs = el.childNodes;
var l = cs.length;
for (var i = 0; i < l; i++) {
switch (cs[i].nodeType) {
case 1: //ELEMENT_NODE
str += ts_getInnerText(cs[i]);
break;
case 3: //TEXT_NODE
str += cs[i].nodeValue;
break;
}
}
return str;



}


function ts_resortTable(lnk) {
// get the span
var span;
for (var ci=0;ci<lnk.childNodes.length;*ci++) {
if (lnk.childNodes[ci].tagName &&
lnk.childNodes[ci].tagName.toL*owerCase() == 'span') span =
lnk.childNodes[ci];
}
var spantext = ts_getInnerText(span);
var td = lnk.parentNode;
var column = td.cellIndex;
var table = getParent(td,'TABLE');
var row_count = 0;
var test_row = 1;
var i, el;

var sortval =
table.rows[test_row].cells[col*umn].getAttribute('sortval');


// Work out a type for the column
if (table.rows.length <= 1) return;
for (i=1; i<table.rows.length; i++) {
if (table.rows[i].id.indexOf('sec*tion_row') == -1) {
test_row = i;
break;
}
}


if (typeof(sortval) !='undefined' && sortval)
{
sortfn = ts_sort_sortval;
} else {
var itm = ts_getInnerText(table.rows[tes*t_row].cells[column]);
sortfn = ts_sort_caseinsensitive;
if (itm.match(/^\d\d[\/-]\d\d[\/-*]\d\d\d\d$/)) sortfn =
ts_sort_date;
if (itm.match(/^\d\d[\/-]\d\d[\/-*]\d\d$/)) sortfn =
ts_sort_date;
if (itm.match(/^[$]/)) sortfn = ts_sort_currency;
if (itm.match(/^[\d\.]+$/)) sortfn = ts_sort_numeric;
}
SORT_COLUMN_INDEX = column;
var firstRow = new Array();
var newRows = new Array();
for (i=0;i<table.rows[0].length;i+*+) {
firstRow[i] = table.rows[0][i];
}
for (j=1;j<table.rows.length;j++) {
// We don't sort section/folder rows, so we skip them here:
if ((table.rows[j].parentNode.nod*eName == 'TBODY')
&& (table.rows[j].id.indexOf("sec*tion_row") == -1)) {
newRows[row_count] = table.rows[j];
row_count++;
}
}


newRows.sort(sortfn);


if (span.getAttribute("sortdir") == 'down') {
ARROW = '&nbsp;&nbsp;&uarr;';
newRows.reverse();
span.setAttribute('sortdir','u*p');
} else {
ARROW = '&nbsp;&nbsp;&darr;';
span.setAttribute('sortdir','d*own');
}


// We appendChild rows that already exist to the tbody, so it moves

them rather than creating new ones
// don't do sortbottom rows
for (i=0;i<newRows.length;i++) { if (!newRows[i].className ||
(newRows[i].className && (newRows[i].className.indexOf(*'sortbottom')
==
-1))) table.tBodies[0].appendChild(n*ewRows[i]);}
// do sortbottom rows only
for (i=0;i<newRows.length;i++) { if (newRows[i].className &&
(newRows[i].className.indexOf(*'sortbottom') != -1))
table.tBodies[0].appendChild(n*ewRows[i]);}


// Delete any other arrows there may be showing
var allspans = document.getElementsByTagName(*"span");
for (var ci=0;ci<allspans.length;ci++) {
if (allspans[ci].className == 'sortarrow') {
if (getParent(allspans[ci],"table*") ==
getParent(lnk,"table")) { // in the same table as us?
allspans[ci].innerHTML = '&nbsp;&nbsp;&nbsp;';
}
}
}


span.innerHTML = ARROW;



}


function getParent(el, pTagName) {
if (el == null) return null;
else if (el.nodeType == 1 && el.tagName.toLowerCase() ==
pTagName.toLowerCase()) // Gecko bug, supposed to be uppercase
return el;
else
return getParent(el.parentNode, pTagName);

}


function ts_sort_date(a,b) {
// y2k notes: two digit years less than 50 are treated as 20XX,
greater than 50 are treated as 19XX
aa = ts_getInnerText(a.cells[SORT_C*OLUMN_INDEX]);
bb = ts_getInnerText(b.cells[SORT_C*OLUMN_INDEX]);
if (aa.length == 10) {
dt1 = aa.substr(6,4)+aa.substr(3,2)+*aa.substr(0,2);
} else {
yr = aa.substr(6,2);
if (parseInt(yr) < 50) { yr = '20'+yr; } else { yr = '19'+yr; }

dt1 = yr+aa.substr(3,2)+aa.substr(0,*2);
}
if (bb.length == 10) {
dt2 = bb.substr(6,4)+bb.substr(3,2)+*bb.substr(0,2);
} else {
yr = bb.substr(6,2);
if (parseInt(yr) < 50) { yr = '20'+yr; } else { yr = '19'+yr; }

dt2 = yr+bb.substr(3,2)+bb.substr(0,*2);
}
if (dt1==dt2) return 0;
if (dt1<dt2) return -1;
return 1;


}


function ts_sort_currency(a,b) {
aa =
ts_getInnerText(a.cells[SORT_C*OLUMN_INDEX]).replace(/[^0-9.]*/g,'');

bb =
ts_getInnerText(b.cells[SORT_C*OLUMN_INDEX]).replace(/[^0-9.]*/g,'');

return parseFloat(aa) - parseFloat(bb);


}


function ts_sort_numeric(a,b) {
aa = parseFloat(ts_getInnerText(a.c*ells[SORT_COLUMN_INDEX]));
if (isNaN(aa)) aa = 0;
bb = parseFloat(ts_getInnerText(b.c*ells[SORT_COLUMN_INDEX]));
if (isNaN(bb)) bb = 0;
return aa-bb;


}


function ts_sort_caseinsensitive(a,b) {
aa = ts_getInnerText(a.cells[SORT_C*OLUMN_INDEX]).toLowerCase();
bb = ts_getInnerText(b.cells[SORT_C*OLUMN_INDEX]).toLowerCase();
if (aa==bb) return 0;
if (aa == '') return 1;
if (bb == '') return -1;
if (aa<bb) return -1;
return 1;


}


function ts_sort_sortval(a,b) {
aa = a.cells[SORT_COLUMN_INDEX].get*Attribute('sortval');
bb = b.cells[SORT_COLUMN_INDEX].get*Attribute('sortval');
if (aa==bb) return 0;
if (aa<bb) return -1;
return 1;


}


function ts_sort_default(a,b) {
aa = ts_getInnerText(a.cells[SORT_C*OLUMN_INDEX]);
bb = ts_getInnerText(b.cells[SORT_C*OLUMN_INDEX]);
if (aa==bb) return 0;
if (aa<bb) return -1;
return 1;


}


function addEvent(elm, evType, fn, useCapture)
// addEvent and removeEvent
// cross-browser event handling for IE5+, NS6 and Mozilla
// By Scott Andrew
{
if (elm.addEventListener){
elm.addEventListener(evType, fn, useCapture);
return true;
} else if (elm.attachEvent){
var r = elm.attachEvent("on"+evType, fn);
return r;
} else {
alert("Handler could not be removed");
}

jeffsal (AT) charter (DOT) net wrote:

I am using sorttable.js to sort a table which works fine which allows a
user to sort the table by clicking on the column header. Is there some
code I could add to the page (onload or something) to auto sort by the
first column without user clicking on it. Here is the sorttable.js
code.
source code snipped)

If you give each table heading link a unique ID (I did it here by
including the parent table's ID):

cell.innerHTML = '<a href="#" class="sortheader"
id='+table.id+'_a'+i+' onclick="ts_resortTable(this);return
false;">'+txt+'<span class="sortarrow">&nbsp;&nbsp;&nbsp;</span></a>';

You can call the sort function and send it any link you want, at the end
of the init function:

ts_resortTable(document.getElementById('table0_a0' ));

Since you're coding it by hand, you have to make sure the link exists, I
didn't write any error checking).

Modify which table is sorted by changing the table id part of the string:

table0_a0
table1_a0
table2_a0

MOdify which column is sorted by changing the link number:

table0_a0
table0_a1
table0_a2

MIke