$('#allowance-table').DataTable().clear().destroy(); var table_table = $('#allowance-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_allowance.show',$employee->id) }}", }, columns: [ { data: 'month_year', name: 'month_year', }, { data: 'is_taxable', name: 'is_taxable', render: function (data, type, row) { if (data == 1) { return "{{trans('Taxable')}}"; } else { return "{{trans('Non-Taxable')}}" } } }, { data: 'allowance_title', name: 'allowance_title' }, { data: 'allowance_amount', name: 'allowance_amount', 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, 4], }, ], {{-- 'select': {style: 'multi', selector: 'td:first-child'}, --}} 'lengthMenu': [[10, 25, 50, -1], [10, 25, 50, "All"]], }); new $.fn.dataTable.FixedHeader(table_table); $(document).ready(function () { $("#allowance_code_id").on("change", function () { const selectedCodeTitle = $(this).find(":selected").data("code-title"); $("#allowance_title").val(selectedCodeTitle || ""); }); $("#allowance_code_id").trigger("change"); }); $('#create_allowance_record').click(function () { $(".month_year").val(null).trigger('change'); $('#allowance_sample_form')[0].reset(); $('.modal-title').text('{{__('Add Allowance')}}'); $('#allowance_action_button').val('{{trans('Add')}}'); $('#allowance_action').val('{{trans('Add')}}'); $('#AllowanceformModal').modal('show'); }); $('#allowance_sample_form').on('submit', function (event) { event.preventDefault(); if ($('#allowance_action').val() == '{{trans('Add')}}') { $.ajax({ url: "{{ route('salary_allowance.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!"); $('#AllowanceformModal').modal('hide'); $('#allowance-table').DataTable().ajax.reload(); $('#allowance_sample_form')[0].reset(); } $('#allowance_form_result').html(html).slideDown(300).delay(5000).slideUp(300); } }); } if ($('#allowance_action').val() == '{{trans('Edit')}}') { $.ajax({ url: "{{ route('salary_allowance.update') }}", method: "POST", data: new FormData(this), contentType: false, cache: false, processData: false, dataType: "json", success: function (data) { console.log(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 () { $('#AllowanceformModal').modal('hide'); $('#allowance-table').DataTable().ajax.reload(); $('#allowance_sample_form')[0].reset(); }, 1000); } $('#allowance_form_result').html(html).slideDown(300).delay(5000).slideUp(300); } }); } }); $(document).on('click', '.allowance_edit', function () { var id = $(this).attr('id'); var target = "{{ route('salary_allowance.index') }}/" + id + '/edit'; $.ajax({ url: target, dataType: "json", success: function (html) { console.log("test", html.data) let id = html.data.id; $('#allowance_amount').val(html.data.allowance_amount); $('#allowance_title').val(html.data.allowance_title); $('#month_year_allowance').val(html.data.month_year); $('#allowance_is_taxable').val(html.data.is_taxable).trigger('change'); $('#allowance_code_id').val(html.data.code_id).trigger('change'); $('#AllowanceformModal').modal('show'); $('#allowance_hidden_id').val(html.data.id); $('.modal-title').text('{{trans('Edit Allowance')}}'); $('#allowance_action_button').val('{{trans('Update')}}'); $('#allowance_action').val('{{trans('Edit')}}'); $('#AllowanceformModal').modal('show'); } }) }); let allowance_delete_id; $(document).on('click', '.allowance_delete', function () { allowance_delete_id = $(this).attr('id'); $('.confirmModal').modal('show'); $('.modal-title').text('{{__('DELETE Record')}}'); $('.allowance-ok').text('{{trans('OK')}}'); }); $('.allowance-close').click(function () { $('#allowance_sample_form')[0].reset(); $('select').selectpicker('refresh'); $('.confirmModal').modal('hide'); $('#allowance-table').DataTable().ajax.reload(); }); $('.allowance-ok').click(function () { let target = "{{ route('salary_allowance.index') }}/" + allowance_delete_id + '/delete'; $.ajax({ url: target, beforeSend: function () { $('.allowance-ok').text('{{trans('Deleting...')}}'); }, success: function (data) { setTimeout(function () { $('.confirmModal').modal('hide'); $('#allowance-table').DataTable().ajax.reload(); }, 2000); } }) });