{% extends 'payroll/report/base.html' %} {% load i18n %} {% block opts_modify %} var cols = [[ {field:'emp_code', width:120, title: "{% trans 'report_column_empCode' %}"} ,{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:'basic_salary', title: "{% trans 'monthlySalary_field_basic_salary' %}"} ,{field:'total_salary', title: "{% trans 'monthlySalary_field_total_salary' %}"} ,{field:'total_increase', title: "{% trans 'monthlySalary_field_total_increase' %}"} ,{field:'total_deduction', title: "{% trans 'monthlySalary_field_total_deduction' %}"} ,{field:'ot1', title: "{% trans 'monthlySalary_field_ot1' %}"} ,{field:'ot2', title: "{% trans 'monthlySalary_field_ot2' %}"} ,{field:'ot3', title: "{% trans 'monthlySalary_field_ot3' %}"} ,{field:'normal_ot', title: "{% trans 'report_column_normalOvertime' %}"} ,{field:'weekend_ot', title: "{% trans 'report_column_weekendOvertime' %}"} ,{field:'holiday_ot', title: "{% trans 'report_column_holidayOvertime' %}"} ,{field:'increase', title: "{% trans 'monthlySalary_field_increase' %}"} ,{field:'extra_increase', title: "{% trans 'monthlySalary_field_extra_increase' %}"} ,{field:'loan_increase', title: "{% trans 'monthlySalary_field_loan_increase' %}"} ,{field:'advance_increase', title: "{% trans 'monthlySalary_field_advance_increase' %}"} ,{field:'reimbursement', title: "{% trans 'monthlySalary_field_reimbursement' %}"} ,{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' %}"} ,{field:'total_loan_amount', title: "{% trans 'monthlySalary_field_total_loan_amount' %}"} ,{field:'refund_loan_amount', title: "{% trans 'monthlySalary_field_refund_loan_amount' %}"} ,{field:'unrefund_loan_amount', title: "{% trans 'monthlySalary_field_unrefund_loan_amount' %}"} ]] 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/monthlysalarydetail_report/" }); {% endblock %}