$('#basic_table').DataTable().clear().destroy(); var table_table = $('#basic_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('salary_basic.show',$employee->id) }}", }, columns: [ { data: 'month_year', name: 'month_year', }, { data: 'payslip_type', name: 'payslip_type', }, { data: 'basic_salary', name: 'basic_salary', 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': { '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, 3], }, ], {{-- 'select': {style: 'multi', selector: 'td:first-child'}, --}} 'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]], }); new $.fn.dataTable.FixedHeader(table_table); $('#create_basic_salary_record').click(function () { $('.modal-title').text('{{__('Add Basic Salary')}}'); $('#basic_salary_action_button').val('{{trans('file.Add')}}'); $('#basic_salary_action').val('{{trans('file.Add')}}'); $('#basicSalaryformModal').modal('show'); }); $('#basic_salary_sample_form').on('submit', function (event) { event.preventDefault(); if ($('#basic_salary_action').val() == '{{trans('file.Add')}}') { $.ajax({ url: "{{ route('salary_basic.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.check_month_year) { html = '
' + data.check_month_year + '
'; } if (data.success) { html = '
' + data.success + '
'; $('#basic_salary_sample_form')[0].reset(); $('select').selectpicker('refresh'); $('#basic_table').DataTable().ajax.reload(); } $('#basic_salary_form_result').html(html).slideDown(300).delay(5000).slideUp(300); } }); } if ($('#basic_salary_action').val() == '{{trans('file.Edit')}}') { $.ajax({ url: "{{ route('salary_basic.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.check_month_year) { html = '
' + data.check_month_year + '
'; } if (data.success) { html = '
' + data.success + '
'; setTimeout(function () { $('#basicSalaryformModal').modal('hide'); $('select').selectpicker('refresh'); $('#basic_table').DataTable().ajax.reload(); $('#basic_salary_sample_form')[0].reset(); }, 2000); } $('#basic_salary_form_result').html(html).slideDown(300).delay(5000).slideUp(300); } }); } }); $(document).on('click', '.salary_basic_edit', function () { var id = $(this).data("id"); var target = "{{ route('salary_basic.index') }}/" + id + '/edit'; $.ajax({ url: target, dataType: "json", success: function (html) { $('#employee_id').val(html.data.employee_id); $('#month_year').val(html.data.month_year); $('#payslip_type_edit').selectpicker('val', html.data.payslip_type); $('#basic_salary_edit').val(html.data.basic_salary); $('#basic_salary_hidden_id').val(html.data.id); $('.modal-title').text('{{trans('file.Edit')}}'); $('#basic_salary_action_button').val('{{trans('file.Edit')}}'); $('#basic_salary_action').val('{{trans('file.Edit')}}'); $('#basicSalaryformModal').modal('show'); } }) }); {{-- let allowance_delete_id; --}} $(document).on('click', '.salary_basic_delete', function () { salary_basic_delete_id = $(this).data("id"); $('.modal-title').text('{{__('DELETE Record')}}'); $('.basic-ok').text('{{trans('file.OK')}}'); {{-- $('.confirmModal').modal('show'); --}} $('#confirmModal').modal('show'); }); $('.basic_salary-close').click(function () { $('#basic_salary_sample_form')[0].reset(); $('select').selectpicker('refresh'); $('.confirmModal').modal('hide'); $('#basic_table').DataTable().ajax.reload(); }); $('.basic-ok').click(function () { let target = "{{ route('salary_basic.index') }}/" + salary_basic_delete_id + '/delete'; $.ajax({ url: target, beforeSend: function () { $('.basic-ok').text('{{trans('file.Deleting...')}}'); }, success: function (data) { setTimeout(function () { $('#confirmModal').modal('hide'); $('#basic_table').DataTable().ajax.reload(); }, 2000); } }) });