There is no exercise better for the heart than reaching down and lifting people up. - John Holmes
Id | Name | Created At | Updated At | |
---|---|---|---|---|
Id | Name | Created At | Updated At |
public function getMultiFilterSelect()
{
return view('datatables.collection.multi-filter-select');
}
public function getMultiFilterSelectData()
{
$users = User::select(['id', 'name', 'email', 'created_at', 'updated_at'])->get();
return Datatables::of($users)->make(true);
}
$('#users-table').DataTable({
processing: true,
serverSide: true,
ajax: 'https://yajratables.tuecus.com/collection/multi-filter-select-data',
columns: [
{data: 'id', name: 'id'},
{data: 'name', name: 'name'},
{data: 'email', name: 'email'},
{data: 'created_at', name: 'created_at'},
{data: 'updated_at', name: 'updated_at'}
],
initComplete: function () {
this.api().columns().every(function () {
var column = this;
var input = document.createElement('input');
$(input).appendTo($(column.footer()).empty())
.on('change', function () {
var val = $.fn.dataTable.util.escapeRegex($(this).val());
column.search(val ? val : '', true, false).draw();
});
});
}
});