$('#employee_ticket-table').DataTable().clear().destroy(); var date = $('.date'); date.datepicker({ format: '{{ env('Date_Format_JS')}}', autoclose: true, todayHighlight: true }); let table_table = $('#employee_ticket-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_ticket.index',$employee->id) }}", }, columns: [ { data: 'ticket_details', name: 'ticket_details', render: function (data, type, row) { return data + "
" + row.ticket_status + "
"; } }, { data: 'subject', name: 'subject', }, { data: 'ticket_priority', name: 'ticket_priority', }, { data: 'created_at', name: 'created_at', }, { 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, 4], }, ], 'select': {style: 'multi', selector: 'td:first-child'}, 'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]], }); new $.fn.dataTable.FixedHeader(table_table);