在每个列上分离过滤器有很多问题。但是我都没有发现相同的问题,但是当然有了Ajax的触感。
我正在使用近一个月。在搜索一个很酷的东西时,我可以将其添加到我的数据表中,我找到了一个网站,该站点在每列上都有该数据列表。我想拥有那个,但我无法弄清楚如何。
我已经在DataTables中阅读了一些文档,但是我似乎很难理解它。所以有人可以帮助我解决问题吗?
顺便说一句,这是我的ajax代码:
var initAjaxDatatables = function () {
var grid = new Datatable();
grid.init({
src: $("#applicationTracker"),
loadingMessage: 'Loading...',
dataTable: {
"bStateSave": true,
"lengthMenu": [
[10, 20, 50, 100, 150, -1],
[10, 20, 50, 100, 150, "All"]
],
"pageLength": 10,
"ajax": {
"url": root_path + "/public/ajax/report/application/LoadAllDataAsync/",
},
"order": [
[1, "asc"]
],
buttons: [
{ extend: 'print', className: 'btn default' },
{ extend: 'copy', className: 'btn default' },
{ extend: 'pdf', className: 'btn default' },
{ extend: 'excel', className: 'btn default' },
{ extend: 'csv', className: 'btn default' },
{
text: 'Reload',
className: 'btn default',
action: function ( e, dt, node, config ) {
dt.ajax.reload();
}
}
],
}
});
// handle datatable custom tools
$('#datatable_ajax_tools > li > a.tool-action').on('click', function() {
var action = $(this).attr('data-action');
grid.getDataTable().button(action).trigger();
});
我已经在页脚中为每列实现了过滤器,请尝试以下操作:
$(document).ready(function() {
var data = [];
data.push(
[1,"Sasha","Brenna","0800 1111"],
[2,"Sage","Mia","(01012) 405872"],
[3,"Chelsea","Allistair","076 0578 0265"],
[4,"Uta","Savannah","070 1247 5884"],
[5,"Remedios","Berk","0995 181 0007"],
[6,"Ruby","Wayne","0800 1111"],
[7,"Faith","Fredericka","(01709) 099879"],
[8,"Myra","Harrison","070 4241 9576"],
[9,"Drake","Miriam","0800 733635"],
[10,"Reed","Shannon","076 8597 5067"]
);
var count = 0;
$('#data_table').DataTable( {
data: data,
initComplete: function (){
this.api().columns().every( function () {
/*if(count == 2)
{*/
var column = this;
var select = $('<select><option value=""></option></select>')
.appendTo( $(column.footer()).empty() )
.on( 'change', function () {
var val = $.fn.dataTable.util.escapeRegex(
$(this).val()
);
column
.search( val ? '^'+val+'$' : '', true, false )
.draw();
});
column.data().unique().sort().each( function ( d, j ) {
select.append( '<option value="'+d+'">'+d+'</option>' )
});
/*}*/
count++;
});
}
});
});
github demo
工作jsfiddle