$('#employee_task-table').DataTable().clear().destroy();
var table_table = $('#employee_task-table').DataTable({
initComplete: function () {
this.api().columns([0]).every(function () {
var column = this;
var 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('');
$('select').selectpicker('refresh');
});
});
},
responsive: true,
fixedHeader: {
header: true,
footer: true
},
processing: true,
serverSide: true,
ajax: {
url: "{{ route('employee_task.index',$employee->id) }}",
},
columns: [
{
data: 'task_name',
name: 'task_name',
},
{
data: 'end_date',
name: 'end_date',
},
{
data: 'task_status',
name: 'task_status',
},
{
data: 'assigned_employee',
name: 'assigned_employee',
render: function (data) {
return data.join("
");
}
},
{
data: 'created_by',
name: 'created_by',
},
{
data: 'task_progress',
name: 'task_progress',
render: function (data) {
if (data !== null) {
return data + '% completed'
} else {
return 0 + '% completed'
}
}
},
{
data: 'action',
name: 'action',
orderable: false
}
],
"order": [],
'language': {
'lengthMenu': '_MENU_ {{__('records per page')}}',
"info": '{{trans("file.Showing")}} _START_ - _END_ (_TOTAL_)',
"search": '{{trans("file.Search")}}',
'paginate': {
'previous': '{{trans("file.Previous")}}',
'next': '{{trans("file.Next")}}'
}
},
'columnDefs': [
{
"orderable": false,
'targets': [0, 6],
},
],
'select': {style: 'multi', selector: 'td:first-child'},
'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]],
});
new $.fn.dataTable.FixedHeader(table_table);