$('#overtime-table').DataTable().clear().destroy(); var table_table = $('#overtime-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 }, serverSide: true, ajax: { url: "{{ route('salary_overtime.show',$employee->id) }}", }, columns: [ { data: 'month_year', name : 'month_year' }, { data: 'overtime_title', name: 'overtime_title' }, { data: 'no_of_days', name: 'no_of_days', }, { data: 'overtime_hours', name: 'overtime_hours' }, { data: 'overtime_rate', name: 'overtime_rate', render: function (data) { if ('{{config('variable.currency_format') =='suffix'}}') { return data + ' {{config('variable.currency')}}'; } else { return '{{config('variable.currency')}} ' + data; } } }, { data: 'action', name: 'action', orderable: false } ], "order": [], 'language': { "info": '{{trans("Showing")}} _START_ - _END_ (_TOTAL_)', "search": '{{trans("Search")}}', 'paginate': { 'previous': '{{trans("Previous")}}', 'next': '{{trans("Next")}}' } }, 'columnDefs': [ { "orderable": false, 'targets': [0, 5], }, ], {{-- 'select': {style: 'multi', selector: 'td:first-child'}, --}} 'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]], }); new $.fn.dataTable.FixedHeader(table_table); $('#create_overtime_record').click(function () { $('.modal-title').text('{{__('Add Overtime')}}'); $('#overtime_action_button').val('{{trans('Add')}}'); $('#overtime_action').val('{{trans('Add')}}'); $('#OvertimeformModal').modal('show'); }); $('#overtime_sample_form').on('submit', function (event) { event.preventDefault(); if ($('#overtime_action').val() == '{{trans('Add')}}') { $.ajax({ url: "{{ route('salary_overtime.store',$employee) }}", method: "POST", data: new FormData(this), contentType: false, cache: false, processData: false, dataType: "json", success: function (data) { var html = ''; if (data.errors) { html = '
'; for (var count = 0; count < data.errors.length; count++) { html += '

' + data.errors[count] + '

'; } html += '
'; } if (data.success) { toastr.success(data.success, "Success!"); $('#OvertimeformModal').modal('hide'); $('#overtime-table').DataTable().ajax.reload(); $('#overtime_sample_form')[0].reset(); } $('#overtime_form_result').html(html).slideDown(300).delay(5000).slideUp(300); } }); } if ($('#overtime_action').val() == '{{trans('Edit')}}') { $.ajax({ url: "{{ route('salary_overtime.update') }}", method: "POST", data: new FormData(this), contentType: false, cache: false, processData: false, dataType: "json", success: function (data) { var html = ''; if (data.errors) { html = '
'; for (var count = 0; count < data.errors.length; count++) { html += '

' + data.errors[count] + '

'; } html += '
'; } if (data.error) { html = '
' + data.error + '
'; } if (data.success) { toastr.success(data.success, "Success!"); setTimeout(function () { $('#OvertimeformModal').modal('hide'); $('#overtime-table').DataTable().ajax.reload(); $('#overtime_sample_form')[0].reset(); }, 1000); } $('#overtime_form_result').html(html).slideDown(300).delay(5000).slideUp(300); } }); } }); $(document).ready(function () { $("#overtime_code_id").on("change", function () { const selectedCodeTitle = $(this).find(":selected").data("code-title"); $("#overtime_title").val(selectedCodeTitle || ""); }); $("#overtime_code_id").trigger("change"); }); $(document).on('click', '.overtime_edit', function () { var id = $(this).attr('id'); var target = "{{ route('salary_overtime.index') }}/" + id + '/edit'; $.ajax({ url: target, dataType: "json", success: function (html) { let id = html.data.id; $('.month_year').val(html.data.month_year); $('#overtime_hours').val(html.data.overtime_hours); $('#overtime_title').val(html.data.overtime_title); $('#no_of_days').val(html.data.no_of_days); $('#overtime_rate').val(html.data.overtime_rate); $('#overtime_code_id').val(html.data.code_id).trigger('change'); $('#overtime_hidden_id').val(html.data.id); $('.modal-title').text('{{trans('Edit')}}'); $('#overtime_action_button').val('{{trans('Edit')}}'); $('#overtime_action').val('{{trans('Edit')}}'); $('#OvertimeformModal').modal('show'); } }) }); let overtime_delete_id; $(document).on('click', '.overtime_delete', function () { overtime_delete_id = $(this).attr('id'); $('.confirmModal').modal('show'); $('.modal-title').text('{{__('DELETE Record')}}'); $('.overtime-ok').text('{{trans('OK')}}'); }); $('.overtime-close').click(function () { $('#overtime_sample_form')[0].reset(); $('.confirmModal').modal('hide'); $('#overtime-table').DataTable().ajax.reload(); }); $('.overtime-ok').click(function () { let target = "{{ route('salary_overtime.index') }}/" + overtime_delete_id + '/delete'; $.ajax({ url: target, beforeSend: function () { $('.overtime-ok').text('{{trans('Deleting...')}}'); }, success: function (data) { setTimeout(function () { $('.confirmModal').modal('hide'); $('#overtime-table').DataTable().ajax.reload(); }, 2000); } }) });