{% extends 'payroll/report/base.html' %} {% load i18n %} {% block opts_modify %} var cols = [[ {field:'emp_code', width:120, title: "{% trans 'report_column_empCode' %}", sort:true} ,{field:'first_name', title: "{% trans 'report_column_firstName' %}"} ,{field:'last_name', title: "{% trans 'report_column_lastName' %}"} ,{field:'department', title: "{% trans 'report_column_departmentName' %}"} ,{field:'calc_time', title: "{% trans 'monthlySalary_field_calc_time' %}"} ,{field:'total_deduction', title: "{% trans 'monthlySalary_field_total_deduction' %}"} ,{field:'late_time', title: "{% trans 'monthlySalary_field_late_time' %}"} ,{field:'early_leave', title: "{% trans 'monthlySalary_field_early_leave' %}"} ,{field:'absent_time', title: "{% trans 'monthlySalary_field_absent_time' %}"} ,{field:'deduction', title: "{% trans 'monthlySalary_field_deduction' %}"} ,{field:'extra_deduction', title: "{% trans 'monthlySalary_field_extra_deduction' %}"} ,{field:'advance_deduction', title: "{% trans 'monthlySalary_field_advance_deduction' %}"} ,{field:'loan_deduction', title: "{% trans 'monthlySalary_field_loan_deduction' %}"} ]]; var leaveCols = []; $.ajax({ url: "/payroll/api/leaveformulas/" ,type: "GET" ,dataType: "json" ,async: false ,success:function(response){ var data = response.data; leave_set = new Set() data.forEach(function(col, index){ if(!leave_set.has(col['category_name'])) { leave_set.add(col['category_name']) leaveCols.push({field: col['category_name'], title: col['category_name']}) }; }); } ,error:function(){ } }); var _cols = cols[0].concat(leaveCols); cols[0] = _cols; $.extend(opts, { cols: cols ,url: "/payroll/api/report/deduction_report/" }); {% endblock %}