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