$('#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);