$('#employee_travel-table').DataTable().clear().destroy();
var date = $('.date');
date.datepicker({
format: '{{ env('Date_Format_JS')}}',
autoclose: true,
todayHighlight: true
});
let table_table = $('#employee_travel-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_travel.index',$employee->id) }}",
},
columns: [
{
data: null,
render: function (data) {
let expectedBudget = new Intl.NumberFormat('id-ID', {
minimumFractionDigits: 0,
maximumFractionDigits: 0
}).format(data.expected_budget);
let actualBudget = new Intl.NumberFormat('id-ID', {
minimumFractionDigits: 0,
maximumFractionDigits: 0
}).format(data.actual_budget);
return data.purpose_of_visit + "