JS交叉表动态排序,10.1.1亲测可用

浏览: 2319

JS交叉表动态排序,10.1.1亲测可用

JS.png

<JS主体>代码

<script>

var SORT_COLUMN_INDEX;

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

//此处i=0可指定从哪一列生效

for (var i=0;i<firstRow.cells.length;i++) {

var cell = firstRow.cells[i];

var txt = ts_getInnerText(cell);

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

//cell.innerHTML = '<span class="sortheader" onclick="ts_resortTable(this);return false;">'+txt+'<span class="sortarrow">&nbsp;&nbsp;&nbsp;</span></span>';

}

}

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.toLowerCase() == 'span') span = lnk.childNodes[ci];

}

var spantext = ts_getInnerText(span);

var td = lnk.parentNode;

var column = td.cellIndex;

var table = getParent(td,'TABLE');



// Work out a type for the column

if (table.rows.length <= 1) return;

var itm = ts_getInnerText(table.rows[1].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++) { newRows[j-1] = table.rows[j]; }

newRows.sort(sortfn);

if (span.getAttribute("sortdir") == 'down') {

ARROW = '&nbsp;&nbsp;&uarr;';

newRows.reverse();

span.setAttribute('sortdir','up');

} else {

ARROW = '&nbsp;&nbsp;&darr;';

span.setAttribute('sortdir','down');

}



// 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(newRows[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(newRows[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_COLUMN_INDEX]);

bb = ts_getInnerText(b.cells[SORT_COLUMN_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_COLUMN_INDEX]).replace(/[^0-9.]/g,'');

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

return parseFloat(aa) - parseFloat(bb);

}

function ts_sort_numeric(a,b) {

aa = parseFloat(ts_getInnerText(a.cells[SORT_COLUMN_INDEX]).replace(/[^0-9.]/g,''));

if (isNaN(aa)) aa = 0;

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

if (isNaN(bb)) bb = 0;

return aa-bb;

}

function ts_sort_caseinsensitive(a,b) {

aa = ts_getInnerText(a.cells[SORT_COLUMN_INDEX]).toLowerCase();

bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]).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_INDEX]);

bb = ts_getInnerText(b.cells[SORT_COLUMN_INDEX]);

if (aa==bb) return 0;

if (aa<bb) return -1;

return 1;

}

</script>

<SPAN>和</SPAN>的代码

<span id="t00">

</SPAN>

<方法调用>的代码

<script>

var targetTable = document.getElementById("t00");

targetTable.firstChild.id = "rsTable";

targetTable.firstChild.name = "rsTable";

var tds = document.getElementById("rsTable").getElementsByTagName("TD");

var s = 0;

//remove nested span tags (this might effect previously applied customs styles)

for (var i=0; i<tds.length; i++) {

/*var x = tds[i].firstChild.innerHTML;

tds[i].removeChild(tds[i].firstChild);

tds[i].innerHTML = x;*/

}

ts_makeSortable(document.getElementById("rsTable"));

</script>
推荐 0
本文由 H_Elsker 创作,采用 知识共享署名-相同方式共享 3.0 中国大陆许可协议 进行许可。
转载、引用前需联系作者,并署名作者且注明文章出处。
本站文章版权归原作者及原出处所有 。内容为作者个人观点, 并不代表本站赞同其观点和对其真实性负责。本站是一个个人学习交流的平台,并不用于任何商业目的,如果有任何问题,请及时联系我们,我们将根据著作权人的要求,立即更正或者删除有关内容。本站拥有对此声明的最终解释权。

0 个评论

要回复文章请先登录注册