使用 jQuery DataTables 时禁用第一列的自动排序 [英] Disable automatic sorting on the first column when using jQuery DataTables
本文介绍了使用 jQuery DataTables 时禁用第一列的自动排序的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我正在使用 jQuery DataTables，我想知道是否可以禁用表格第一列的自动排序?
我的代码如下:
/* 默认类修改 */$.extend( $.fn.dataTableExt.oStdClasses, {"sWrapper": "dataTables_wrapper 表单内联"});/* 获取分页信息的 API 方法 */$.fn.dataTableExt.oApi.fnPagingInfo = 函数(oSettings){返回 {"iStart": oSettings._iDisplayStart,"iEnd": oSettings.fnDisplayEnd(),"iLength": oSettings._iDisplayLength,"iTotal": oSettings.fnRecordsTotal(),"iFilteredTotal": oSettings.fnRecordsDisplay(),"iPage": Math.ceil( oSettings._iDisplayStart/oSettings._iDisplayLength ),"iTotalPages": Math.ceil( oSettings.fnRecordsDisplay()/oSettings._iDisplayLength )};}/* Bootstrap 风格的分页控件 */$.extend( $.fn.dataTableExt.oPagination, {引导程序":{fnInit":函数(oSettings，nPaging，fnDraw){var oLang = oSettings.oLanguage.oPaginate;var fnClickHandler = 函数 ( e ) {e.preventDefault();如果(oSettings.oApi._fnPageChange(oSettings，e.data.action)){fnDraw( oSettings );}};$(nPaging).addClass('分页').append(''+'<li class="prev disabled"><a href="#">←'+oLang.sPrevious+'</a></li>'+'<li class="next disabled"><a href="#">'+oLang.sNext+' →</a></li>'+'</ul>');var els = $('a', nPaging);$(els[0]).bind('click.DT', { action: "previous" }, fnClickHandler);$(els[1]).bind('click.DT', { action: "next" }, fnClickHandler);},fnUpdate":函数(oSettings，fnDraw){var iListLength = 5;var oPaging = oSettings.oInstance.fnPagingInfo();var an = oSettings.aanFeatures.p;var i, j, sClass, iStart, iEnd, iHalf=Math.floor(iListLength/2);如果(oPaging.iTotalPages < iListLength){iStart = 1;iEnd = oPaging.iTotalPages;}否则如果(oPaging.iPage <= iHalf){iStart = 1;iEnd = iListLength;} else if ( oPaging.iPage >= (oPaging.iTotalPages-iHalf) ) {iStart = oPaging.iTotalPages - iListLength + 1;iEnd = oPaging.iTotalPages;} 别的 {iStart = oPaging.iPage - iHalf + 1;iEnd = iStart + iListLength - 1;}for ( i=0, iLen=an.length ; i
解决方案
设置aaSorting 空数组的选项.它将禁用初始排序，同时在您单击列时仍允许手动排序.
"a排序": []<块引用>
aaSorting 数组应该包含一个数组，每列都应该是排序 最初 包含列的索引和方向字符串('asc' 或 'desc').
I'm using jQuery DataTables and I would like to know if there's possible to disable automatic sorting on the first column of the table?
My code looks like this:
/* Default class modification */
$.extend( $.fn.dataTableExt.oStdClasses, {
"sWrapper": "dataTables_wrapper form-inline"
} );
/* API method to get paging information */
$.fn.dataTableExt.oApi.fnPagingInfo = function ( oSettings )
{
return {
"iStart": oSettings._iDisplayStart,
"iEnd": oSettings.fnDisplayEnd(),
"iLength": oSettings._iDisplayLength,
"iTotal": oSettings.fnRecordsTotal(),
"iFilteredTotal": oSettings.fnRecordsDisplay(),
"iPage": Math.ceil( oSettings._iDisplayStart / oSettings._iDisplayLength ),
"iTotalPages": Math.ceil( oSettings.fnRecordsDisplay() / oSettings._iDisplayLength )
};
}
/* Bootstrap style pagination control */
$.extend( $.fn.dataTableExt.oPagination, {
"bootstrap": {
"fnInit": function( oSettings, nPaging, fnDraw ) {
var oLang = oSettings.oLanguage.oPaginate;
var fnClickHandler = function ( e ) {
e.preventDefault();
if ( oSettings.oApi._fnPageChange(oSettings, e.data.action) ) {
fnDraw( oSettings );
}
};
$(nPaging).addClass('pagination').append(
'<ul>'+
'<li class="prev disabled"><a href="#">← '+oLang.sPrevious+'</a></li>'+
'<li class="next disabled"><a href="#">'+oLang.sNext+' → </a></li>'+
'</ul>'
);
var els = $('a', nPaging);
$(els[0]).bind( 'click.DT', { action: "previous" }, fnClickHandler );
$(els[1]).bind( 'click.DT', { action: "next" }, fnClickHandler );
},
"fnUpdate": function ( oSettings, fnDraw ) {
var iListLength = 5;
var oPaging = oSettings.oInstance.fnPagingInfo();
var an = oSettings.aanFeatures.p;
var i, j, sClass, iStart, iEnd, iHalf=Math.floor(iListLength/2);
if ( oPaging.iTotalPages < iListLength) {
iStart = 1;
iEnd = oPaging.iTotalPages;
}
else if ( oPaging.iPage <= iHalf ) {
iStart = 1;
iEnd = iListLength;
} else if ( oPaging.iPage >= (oPaging.iTotalPages-iHalf) ) {
iStart = oPaging.iTotalPages - iListLength + 1;
iEnd = oPaging.iTotalPages;
} else {
iStart = oPaging.iPage - iHalf + 1;
iEnd = iStart + iListLength - 1;
}
for ( i=0, iLen=an.length ; i<iLen ; i++ ) {
// Remove the middle elements
$('li:gt(0)', an[i]).filter(':not(:last)').remove();
// Add the new list items and their event handlers
for ( j=iStart ; j<=iEnd ; j++ ) {
sClass = (j==oPaging.iPage+1) ? 'class="active"' : '';
$('<li '+sClass+'><a href="#">'+j+'</a></li>')
.insertBefore( $('li:last', an[i])[0] )
.bind('click', function (e) {
e.preventDefault();
oSettings._iDisplayStart = (parseInt($('a', this).text(),10)-1) * oPaging.iLength;
fnDraw( oSettings );
} );
}
// Add / remove disabled classes from the static elements
if ( oPaging.iPage === 0 ) {
$('li:first', an[i]).addClass('disabled');
} else {
$('li:first', an[i]).removeClass('disabled');
}
if ( oPaging.iPage === oPaging.iTotalPages-1 || oPaging.iTotalPages === 0 ) {
$('li:last', an[i]).addClass('disabled');
} else {
$('li:last', an[i]).removeClass('disabled');
}
}
}
}
});
/* Show/hide table column */
function dtShowHideCol( iCol ) {
var oTable = $('#example-2').dataTable();
var bVis = oTable.fnSettings().aoColumns[iCol].bVisible;
oTable.fnSetColumnVis( iCol, bVis ? false : true );
};
/* Table #example */
$(document).ready(function() {
$('.datatable').dataTable( {
"sDom": "<'row'<'span6'l><'span6'f>r>t<'row'<'span6'i><'span6'p>>",
"sPaginationType": "bootstrap",
"oLanguage": {
"sLengthMenu": "_MENU_ records per page"
},
"aoColumnDefs": [
{
"bSortable": false,
"aTargets": [ -1 ] // <-- gets last column and turns off sorting
}
]
});
$('.datatable-controls').on('click','li input',function(){
dtShowHideCol( $(this).val() );
})
});
解决方案
Set the aaSorting option to an empty array. It will disable initial sorting, whilst still allowing manual sorting when you click on a column.
"aaSorting": []
The aaSorting array should contain an array for each column to be sorted initially containing the column's index and a direction string ('asc' or 'desc').
这篇关于使用 jQuery DataTables 时禁用第一列的自动排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
