Mikel
[转载]jQuery实现表格按列字母或数字排序 – 海之澜 – 博客园.
最近做的一个项目中需要自己写个表格排序的功能，于是就上网收集了一下，主要原理就是JQuery操作表格
JQuery代码如下：
$(function () {$('#tblGrid').each(function () {var $table = $(this); //将table存储为一个jquery对象$('thead td', $table).each(function (column) {var findSortKey;if ($(this).is('.sort-alpha')) { //按字母排序findSortKey = function ($cell) {return $cell.find('sort-key').text().toUpperCase() + '' + $cell.text().toUpperCase();};} else if ($(this).is('.sort-numeric')) { //按数字排序findSortKey = function ($cell) {var key = parseFloat($cell.text().replace(/^[^\d.]*/, ''));return isNaN(key) ? 0 : key;};}if (findSortKey) {$(this).addClass('clickable').hover(function () { $(this).addClass('hover'); }, function () { $(this).removeClass('hover'); }).click(function () {//反向排序状态声明var newDirection = 1;if ($(this).is('.sorted-asc')) {newDirection = -1;}var rows = $table.find('tbody>tr').get(); //将数据行转换为数组$.each(rows, function (index, row) {row.sortKey = findSortKey($(row).children('td').eq(column));});rows.sort(function (a, b) {if (a.sortKey < b.sortKey) return -newDirection; if (a.sortKey > b.sortKey) return newDirection;return 0;});$.each(rows, function (index, row) {$table.children('tbody').append(row);row.sortKey = null;});$table.find('thead td').removeClass('sorted-asc').removeClass('sorted-desc');var $sortHead = $table.find('thead td').filter(':nth-child(' + (column + 1) + ')');//实现反向排序if (newDirection == 1) {$sortHead.addClass('sorted-asc');} else {$sortHead.addClass('sorted-desc');}//移除已排序的列的样式,添加样式到当前列$table.find('td').removeClass('sorted').filter(':nth-child(' + (column + 1) + ')').addClass('sorted');$table.trigger('repaginate');});}});});}); |
Html代码如下：
<table id="tblGrid"><thead><tr><td style="width: 10%;">员工工号</td><td style="width: 10%;">员工姓名</td><td style="width: 15%;">职务名称</td><td class="sort-numeric" style="width: 10%;">得分</td><td class="sort-alpha" style="width: 10%;">绩效考核等级（直接主管）</td><td style="width: 25%;">事例说明</td><td class="sort-alpha" style="width: 10%;">绩效考核等级（上级主管）</td><td style="width: 10%;">绩效考核等级（部门主管）</td></tr></thead><tbody><!--#RowBegin#--><tr><td height="28px"></td><td>张三</td><td>客服支持</td><td></td><td class="director_1">优秀</td><td>李四 直接主管考评信息</td><td>待改进</td><td><select name="Table:model:RANK:0"> <option value="">-请选择-</option></select><select name="Table:model:RANK:0"> <option value="优秀">优秀</option></select><select name="Table:model:RANK:0"> <option value="优良">优良</option></select><select name="Table:model:RANK:0"> <option value="良好">良好</option></select><select name="Table:model:RANK:0"> <option selected="selected" value="待改进">待改进</option></select><select name="Table:model:RANK:0"> <option value="不胜任">不胜任</option></select></td></tr><tr><td height="28px"></td><td>王五</td><td>客服支持</td><td></td><td class="director_2">优良</td><td>事例说明</td><td>优良</td><td><select name="Table:model:RANK:1"> <option value="">-请选择-</option></select><select name="Table:model:RANK:1"> <option value="优秀">优秀</option></select><select name="Table:model:RANK:1"> <option selected="selected" value="优良">优良</option></select><select name="Table:model:RANK:1"> <option value="良好">良好</option></select><select name="Table:model:RANK:1"> <option value="待改进">待改进</option></select><select name="Table:model:RANK:1"> <option value="不胜任">不胜任</option></select></td></tr><tr><td height="28px"></td><td>周氏</td><td>客服支持</td><td></td><td class="director_3">优秀</td><td>直接主管考评信息</td><td>优秀</td><td><select name="Table:model:RANK:2"> <option value="">-请选择-</option></select><select name="Table:model:RANK:2"> <option selected="selected" value="优秀">优秀</option></select><select name="Table:model:RANK:2"> <option value="优良">优良</option></select><select name="Table:model:RANK:2"> <option value="良好">良好</option></select><select name="Table:model:RANK:2"> <option value="待改进">待改进</option></select><select name="Table:model:RANK:2"> <option value="不胜任">不胜任</option></select></td></tr><!--#RowEnd#--></tbody></table> |
css:
利用JQuery的ready事件即可实现排序功能，
页面效果如图：
点击查看源代码SortTable.rar
