datatables增加跳转指定页功能-datatable自定义分页

3次阅读

共计 5109 个字符,预计需要花费 13 分钟才能阅读完成。

DataTable 使用方便,快捷。但有时候用户需求对分页有需求,例如输入页数进行分页跳转。
这样就需要扩展功能了,datatable 也支持自定义扩展,下面以使用 DataTable bootstrap 分页为例

1. 初始化 DataTable

var $table = $('#listTable');



var listTable = $table.DataTable({language: { url: path + '/resources/js/bootstrap/dtChinese.json'},

            searching: false, // 搜索栏

            ordering: true, // 排序

            scrollX: true,

            scrollY: scrollY,   // 表格滚动区高度

            columns: columns,

            serverSide: true, // 打开后台分页 

            processing: true, // 打开数据加载时的等待效果

            lengthChange: false, // 禁用每页显示的记录数

            sPaginationType: "bootstrap", //bootstrap / full_numbers

            // lengthMenu: [//     [20, 50, 100, -1],

            //     [20, 50, 100, "All"]

            // ],

            pageLength: 20,

            ajax: path + '/searchBase?name=' + sqlStr + '&type=getSqlValues&dataBase=' + opt.dataBase

        });

2. 扩展功能

DataTable 自定义分页(bootstrap 分页)扩展代码如下

/* Set the defaults for DataTables initialisation */

$.extend( true, $.fn.dataTable.defaults, {

    // "sDom": "<'row-fluid'<'span6'l><'span6'f>r>t<'row-fluid'<'span6'i><'span6'p>>",

    "sPaginationType": "bootstrap",

    "oLanguage": {

        "sSearch": "快速搜索:",

        "bAutoWidth": true,

        "sLengthMenu": "每页显示 _MENU_ 条记录",

        "sZeroRecords": "Nothing found - 没有记录",

        "sInfo": "_START_ 到 _END_ 条, 共 _TOTAL_ 条",

        "sInfoEmpty": "显示 0 条记录",

        "sInfoFiltered": "(从 _MAX_ 条中过滤)",

        // "sProcessing":"<div style=''><img src='../static/img/loader.gif'><span> 加载中...</span></div>","oPaginate": {"sPrevious":"",

            "sNext":     "","sLast":">>","sFirst":"<<"

        }

    }

} );

 

 

/* 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="first disabled"><a href="#">'+oLang.sFirst+'</a></li>'+

                '<li class="prev disabled"><a href="#">'+oLang.sPrevious+'</a></li>'+

                '<li class="next disabled"><a href="#">'+oLang.sNext+'</a></li>'+

                '<li class="last disabled"><a href="#">'+oLang.sLast+'</a></li>'+

                '<input type="text"id="redirect"class="redirect">'+

                '</ul>'

                );

 

            //datatables 分页跳转

            $(nPaging).find(".redirect").keyup(function(e){var ipage = parseInt($(this).val());

                var oPaging = oSettings.oInstance.fnPagingInfo();

                var timer = null;

                if(isNaN(ipage) || ipage<1){ipage = 1;}else if(ipage>oPaging.iTotalPages){ipage=oPaging.iTotalPages;}

                $(this).val(ipage);

                ipage--;

                oSettings._iDisplayStart = ipage * oPaging.iLength;

                

                clearTimeout(timer);

                timer = setTimeout(function(){fnDraw( oSettings);

                },600);

            });

 

            var els = $('a', nPaging);

            $(els[0]).bind( 'click.DT', {action: "first"}, fnClickHandler );

            $(els[1]).bind( 'click.DT', {action: "previous"}, fnClickHandler );

            $(els[2]).bind( 'click.DT', {action: "next"}, fnClickHandler );

            $(els[3]).bind( 'click.DT', {action: "last"}, fnClickHandler );

        },

 

        "fnUpdate": function (oSettings, fnDraw) {

            var iListLength = 5;

            var oPaging = oSettings.oInstance.fnPagingInfo();

            var an = oSettings.aanFeatures.p;

            var i, ien, 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, ien=an.length ; i<ien ; i++) {

                // Remove the middle elements

                ($('li:gt(1)', an[i]).filter(':not(:last)')).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($('.next', 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:lt(2)', an[i]).addClass('disabled');

                } else {$('li:lt(2)', an[i]).removeClass('disabled');

                }

 

                if (oPaging.iPage === oPaging.iTotalPages-1 || oPaging.iTotalPages === 0) {$('.next', an[i]).addClass('disabled');

                    $('li:last', an[i]).addClass('disabled');

                } else {$('.next', an[i]).removeClass('disabled');

                    $('li:last', an[i]).removeClass('disabled');

                }

            }

        }

    }

} );

 

 

/*

 * TableTools Bootstrap compatibility

 * Required TableTools 2.1+

 */

if ($.fn.DataTable.TableTools) {

    // Set the classes that TableTools uses to something suitable for Bootstrap

    $.extend( true, $.fn.DataTable.TableTools.classes, {

        "container": "DTTT btn-group",

        "buttons": {

            "normal": "btn",

            "disabled": "disabled"

        },

        "collection": {

            "container": "DTTT_dropdown dropdown-menu",

            "buttons": {"normal": "","disabled":"disabled"}

        },

        "print": {"info": "DTTT_print_info modal"},

        "select": {"row": "active"}

    } );

 

    // Have the collection use a bootstrap compatible dropdown

    $.extend( true, $.fn.DataTable.TableTools.DEFAULTS.oTags, {

        "collection": {

            "container": "ul",

            "button": "li",

            "liner": "a"

        }

    } );

}

分页代码 附件下载: dataTables.plugin.bootstrap

正文完
 0