sorting content of table at client side

[cotton_gear]

Hello,

Fiest of all let me thank this group for so quick in responding to any
postings.
I am using a javascript based utility from a site to sort the columns
of the table. But, for some strange reason it is not working on colmuns
containg checkboxes, text-boxes (or, any user input fileds). For
checkbox column, the values are lost when clicked on the column title
to sort.
I tried a lot to modify but couldnt achive what I wanted.

I have pasted the code of 'SortTable.js' and the HTML file
'SimpleSample.h tml'

Please help me out.

Thanks a ton,
CG

FILES :

1. SortTable.js
//----------------
addEvent(window , "load", sortables_init) ;

var SORT_COLUMN_IND EX;
function sortables_init( ) {
// Find all tables with class sortable and make them sortable
if (!document.getE lementsByTagNam e) return;
tbls = document.getEle mentsByTagName( "table");
for (ti=0;ti<tbls.l ength;ti++) {
thisTbl = tbls[ti];
if (((' '+thisTbl.class Name+' ').indexOf("sor table") != -1) &&
(thisTbl.id)) {
//initTable(thisT bl.id);
ts_makeSortable (thisTbl);
}
}
}

function ts_makeSortable (table) {
if (table.rows && table.rows.leng th > 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);
cell.innerHTML = '<a href="#" class="sorthead er"
onclick="ts_res ortTable(this); return false;">'+txt+' <span
class="sortarro w">&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.chi ldNodes.length; ci++) {
if (lnk.childNodes[ci].tagName &&
lnk.childNodes[ci].tagName.toLowe rCase() == 'span') span =
lnk.childNodes[ci];
}
var spantext = ts_getInnerText (span);
var td = lnk.parentNode;
var column = td.cellIndex;
var table = getParent(td,'T ABLE');

// Work out a type for the column
if (table.rows.len gth <= 1) return;
var itm = ts_getInnerText (table.rows[1].cells[column]);
sortfn = ts_sort_caseins ensitive;
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_currenc y;
if (itm.match(/^[\d\.]+$/)) sortfn = ts_sort_numeric ;
SORT_COLUMN_IND EX = column;
var firstRow = new Array();
var newRows = new Array();
for (i=0;i<table.ro ws[0].length;i++) { firstRow[i] =
table.rows[0][i]; }
for (j=1;j<table.ro ws.length;j++) { newRows[j-1] = table.rows[j]; }

newRows.sort(so rtfn);
//alert(s);
if (span.getAttrib ute("sortdir") == 'down') {
ARROW = '&nbsp;&nbsp;&u arr;';
newRows.reverse ();
span.setAttribu te('sortdir','u p');
} else {
ARROW = '&nbsp;&nbsp;&d arr;';
span.setAttribu te('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.inde xOf('sortbottom ') == -1)))
table.tBodies[0].appendChild(ne wRows[i]);
}
// do sortbottom rows only
for (i=0;i<newRows. length;i++) {

if (newRows[i].className &&
(newRows[i].className.inde xOf('sortbottom ') != -1))
table.tBodies[0].appendChild(ne wRows[i]);

}

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

span.innerHTML = ARROW;
}

function getParent(el, pTagName) {
if (el == null) return null;
else if (el.nodeType == 1 && el.tagName.toLo werCase() ==
pTagName.toLowe rCase()) // Gecko bug, supposed to be uppercase
return el;
else
return getParent(el.pa rentNode, 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_COLUMN_IND EX]);
bb = ts_getInnerText (b.cells[SORT_COLUMN_IND EX]);
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_currenc y(a,b) {
aa =
ts_getInnerText (a.cells[SORT_COLUMN_IND EX]).replace(/[^0-9.]/g,'');
bb =
ts_getInnerText (b.cells[SORT_COLUMN_IND EX]).replace(/[^0-9.]/g,'');
return parseFloat(aa) - parseFloat(bb);
}

function ts_sort_numeric (a,b) {
aa = parseFloat(ts_g etInnerText(a.c ells[SORT_COLUMN_IND EX]));
if (isNaN(aa)) aa = 0;
bb = parseFloat(ts_g etInnerText(b.c ells[SORT_COLUMN_IND EX]));
if (isNaN(bb)) bb = 0;
return aa-bb;
}

function ts_sort_caseins ensitive(a,b) {
aa = ts_getInnerText (a.cells[SORT_COLUMN_IND EX]).toLowerCase() ;
bb = ts_getInnerText (b.cells[SORT_COLUMN_IND EX]).toLowerCase() ;
if (aa==bb) return 0;
if (aa<bb) return -1;
return 1;
}

function ts_sort_default (a,b) {
aa = ts_getInnerText (a.cells[SORT_COLUMN_IND EX]);
bb = ts_getInnerText (b.cells[SORT_COLUMN_IND EX]);
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.addEventLi stener){
elm.addEventLis tener(evType, fn, useCapture);
return true;
} else if (elm.attachEven t){
var r = elm.attachEvent ("on"+evType , fn);
return r;
} else {
alert("Handler could not be removed");
}
}
//-------------------
---------------------------- SimpleSample.ht ml ------------

<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
<IFRAME
STYLE="display: none;position:a bsolute;width:1 49;height:185;z-index=100"

ID="CalFrame" MARGINHEIGHT=0 MARGINWIDTH=0 FRAMEBORDER=0
SCROLLING=NO SRC="Calendar.j sp">
</IFRAME>
<head>
<link rel="StyleSheet " type="text/css"
href="resources/css/Project.css">
<SCRIPT language=JavaSc ript src="SortTable. js"></SCRIPT>
</head>
<body >
<div id="scriptDiv"> </div>


<form name="sPPerProd uctForm" id="newServiceP roductForm" method="POST"
action="/PriceList/goToNewSPPerPro ductAction.do">

<table border=1 class="sortable " id="prodGridTbl ">
<tr class=TABLEROWH EADING>
<th class=TEXTLABEL ><span>Produc t Number</span></th>
<th class=TEXTLABEL ><span>Produc t
Description</span></th>
<th class=TEXTLABEL ><span>Associat e</span></th>
<th class=TEXTLABEL ><span>Name</span></th>
</tr>
<input type="hidden" id="sortTable" value="true">

<input type="hidden"
name="{actionFo rm.serviceProdu ctAssociation[0].productId}"
value="110261"/>
<td><span>C5340 A</span></td>

<td><span>Digit al Camera</span></td>
<td align="center"> <input type="hidden"
name="wlw-checkbox_key:{a ctionForm.servi ceProductAssoci ation[0].isAssociated}O ldValue"
value="false" /><input type="checkbox"
name="wlw-checkbox_key:{a ctionForm.servi ceProductAssoci ation[0].isAssociated}"
checked="true" /></td>
<td><input type=text name="t1" value=""></td>
</tr>
<input type="hidden" id="sortTable" value="true">

<input type="hidden"
name="{actionFo rm.serviceProdu ctAssociation[1].productId}"
value="1229183"/>
<td><span>EC534 AA</span></td>
<td><span>Pavil ion t3131.se</span></td>
<td align="center"> <input type="hidden"
name="wlw-checkbox_key:{a ctionForm.servi ceProductAssoci ation[1].isAssociated}O ldValue"
value="false" /><input type="checkbox"
name="wlw-checkbox_key:{a ctionForm.servi ceProductAssoci ation[1].isAssociated}"
/></td>
<td><input type=text name="t2" value="aaa"></td>

</tr>
<input type="hidden" id="sortTable" value="true">

<input type="hidden"
name="{actionFo rm.serviceProdu ctAssociation[1].productId}"
value="1229183"/>
<td><span>EC534 AA</span></td>

<td><span>Pavil ion t3131.se</span></td>
<td align="center"> <input type="hidden"
name="wlw-checkbox_key:{a ctionForm.servi ceProductAssoci ation[1].isAssociated}O ldValue"
value="false" /><input type="checkbox"
name="wlw-checkbox_key:{a ctionForm.servi ceProductAssoci ation[1].isAssociated}"
checked="true" /></td>
<td><input type=text name="t3" value=""></td>

</tr>

<input type="hidden" id="sortTable" value="true">

<input type="hidden"
name="{actionFo rm.serviceProdu ctAssociation[1].productId}"
value="1229183"/>
<td><span>EC534 AA</span></td>

<td><span>Pavil ion t3131.se</span></td>
<td align="center"> <input type="hidden"
name="wlw-checkbox_key:{a ctionForm.servi ceProductAssoci ation[1].isAssociated}O ldValue"
value="false" /><input type="checkbox"
name="wlw-checkbox_key:{a ctionForm.servi ceProductAssoci ation[1].isAssociated}"
/></td>
<td><input type=text name="t4" value="bbb"></td>

</tr>

</table>

</form>
</body></html>

[Ray Brown]

cotton_gear wrote:

Hello,

Fiest of all let me thank this group for so quick in responding to any
postings.
I am using a javascript based utility from a site to sort the columns
of the table. But, for some strange reason it is not working on colmuns
containg checkboxes, text-boxes (or, any user input fileds). For
checkbox column, the values are lost when clicked on the column title
to sort.
I tried a lot to modify but couldnt achive what I wanted.

I think what you want is at:
http://www.eggheadcafe.com/articles/20021022.asp

The Morris stuff rocks.
Good luck.
Ray