{% for employee in employees1 %} {% set TotalgrossSalaryWhenAvsNonZero=0 %} {% set TotalgrossSalaryWhenAvsZero=0 %} {% set TotalAvsPayments=0 %} {% set employeefullName='' %} {% set employer='' %} {% set avsNumber='' %} {% set dateOfBirth='' %} {% set listOfMonths=[] %} {% for monthly_payment_made in monthly_payment_mades %} {% if employee[1]==monthly_payment_made.employee.id %} {% set index=monthly_payment_made.workedmonth|date('d-m-Y') %} {% set month=monthly_payment_made.workedmonth|date('M') %} {% set listOfMonths = listOfMonths|merge({ (month) :index }) %} {% set year=monthly_payment_made.workedmonth|date('Y') %} {% set avsTaxRate = payrollService.taxRatePerMonth(monthly_payment_made.workedmonth |date('Y'),'AVS') %} {% set aanpTaxRate = payrollService.taxRatePerMonth(monthly_payment_made.workedmonth |date('Y'),'AANP') %} {% set impotTaxRate = payrollService.impotTaxRate( year, monthly_payment_made.employee.impotclassification, '1901') %} {% set grossSalary = (monthly_payment_made.amount - payrollService.ExpensesForMonth(monthly_payment_made.employee,monthly_payment_made.paymentemployer,monthly_payment_made.workedmonth) ) *(1+ avsTaxRate + aanpTaxRate +impotTaxRate) %} {% set avsPayment = grossSalary* (avsTaxRate) %} {% set TotalgrossSalaryWhenAvsNonZero = TotalgrossSalaryWhenAvsNonZero + grossSalary %} {% set TotalgrossSalaryWhenAvsZero = TotalgrossSalaryWhenAvsZero + grossSalary %} {% set TotalAvsPayments = TotalAvsPayments + avsPayment %} {% set employeefullName = monthly_payment_made.employee.fullName %} {% set employer = monthly_payment_made.paymentemployer.employer %} {% set avsNumber = monthly_payment_made.employee.avsNumber %} {% set dateOfBirth = monthly_payment_made.employee.dateOfBirth %} {% endif %} {% endfor %} {% endfor %}

Employee	AVS Number	Date of Birth	List of months	Soumis AVS (CHF)	Soumis AC (CHF)	Non Soumis AVS (CHF)
{{ employeefullName }}	{{ avsNumber }}	{{ dateOfBirth|date('d-M-Y') }}	{% set listOfMonths=listOfMonths|sort %} {% for index,getMonth in listOfMonths %} {{ index }} {% endfor %}	{{ TotalgrossSalaryWhenAvsNonZero| number_format(2, '.', ',') }}	{{ TotalAvsPayments |number_format(2, '.', ',') }}	{{ TotalgrossSalaryWhenAvsZero|number_format(2, '.', ',') }}