Javascript 对Table的客户端排序

点击Table中每列的标题,对table相应列排序

点击一次是升序排列,点第二次是降序,如此循环。兼容IE和Firefox

在HTML中引用<script type="text/javascript" src="SortTable.js"></script>,在需要排序的Table上加class="sortable",在Body的onload中调用排序初始化函数sortables_init(); ,排序就OK了。非常方便。

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
    <head>
        <title>
         </title>
        <script type="text/javascript" src="SortTable.js"></script>

        <script type="text/javascript">
             sortables_init();
        </script>
    </head>

<table id="tabRestoreBackup" class="sortable">
       <tr>
          <th class="tdBackupName" id="tdBackupName">Backup Name</th>
          <th class="tdBackupdate">Backup Date</th>
          <th class="tdTime">File Size (bytes)</th>
          <th class="tdComment" id="restoreImage">Restore Image</th>
         </tr>
</table>


 

 

将以下Script保存为SortTable.js

//addEvent(window, "load", sortables_init);
var SORT_COLUMN_INDEX;
function sortables_init()
{
    // Find all tables with class sortable and make them sortable
    if (!document.getElementsByTagName)
        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);
        cell.innerHTML = '<a href="#" class="sortheader" '+'onclick="ts_resortTable(this, '+i+');return false;">' +txt+'<span class="sortarrow">   </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,clid)
{
    // 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 = clid || 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 = ' -';
        newRows.reverse();
        span.setAttribute('sortdir','up');
    }
    else {
        ARROW = ' +';
        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 = '   ';
            }
        }
    }
      
    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]));
    if (isNaN(aa)) aa = 0;
    bb = parseFloat(ts_getInnerText(b.cells[SORT_COLUMN_INDEX]));
    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;
}


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");
    }
}




[本日志由 岸上的鱼 于 2008-12-16 01:02 PM 编辑]
文章来自: alocne
引用通告: 查看所有引用 | 我要引用此文章
Tags: javascript
评论: 0 | 引用: 0 | 查看次数: 2563
发表评论
昵 称:
密 码: 游客发言不需要密码.
邮 箱: 邮件地址支持Gravatar头像,邮箱地址不会公开.
网 址: 输入网址便于回访.
内 容:
验证码:
选 项:
虽然发表评论不用注册,但是为了保护您的发言权,建议您注册帐号.
字数限制 1000 字 | UBB代码 开启 | [img]标签 关闭