{% extends 'base_admin.html.twig' %}

{% block title %}Payroll{% endblock %}

{% block body %}
    <h1 class="text-danger">Payroll</h1>
    {% include ('template_parts/_date_ranges.html.twig') %}
    <table id="table" class="table">
        <thead>
        <tr>
            <th class="to-hide">Id</th>
            <th class="to-hide">Group</th>
            <th>Employer</th>
            <th style="text-align: left" title="* = Gross O=Office staff">Employee <span><i class="fas fa-info-circle"></i></span></th>
            <th style="text-align: left" >Impot  </span></th>
            <th>Month</th>
            <th style="text-align: right" title="Gross salary = (Payment Made - Expenses) * (1 + AVS + AANP )">Gross salary (pre Impot) <span><i class="fas fa-info-circle"></i></span></th>
            <th style="text-align: right">Gross salary (post Impot) <span><i class="fas fa-info-circle"></i></span></th>
            <th style="text-align: right" title="Consecutively Months Worked #">CMW# <span><i class="fas fa-info-circle"></i></span></th>
            <th style="text-align: right" title="Average Gross Salary, in consecutively worked months">AGS (pre impot)<span><i class="fas fa-info-circle"></i></span></th>
            <th style="text-align: right" title="Average Gross Salary, in consecutively worked months">AGS (post impot)<span><i class="fas fa-info-circle"></i></span></th>
            <th style="text-align: right">AVS</th>
            <th style="text-align: right">AANP</th>
            <th style="text-align: right">LLP</th>
            <th style="text-align: right">Impot</th>
            <th style="text-align: right" title="Net salary = (Paid-Into-Account + Expenses - Per Diem)">Net salary<span><i class="fas fa-info-circle"></i></span></th>
            <th style="text-align: right">Expenses</th>
            <th style="text-align: right" title="Per Diem = 16.5% x (Expenses + Paid-Into-Account)">Per Diem <span><i class="fas fa-info-circle"></i></span></th>
            <th style="text-align: right">Amount Paid</th>
            <th style="text-align: right"><a target="_blank" href="{{ path('tax_rates_index') }}">AVS</a></th>
            <th style="text-align: right"><a target="_blank" href="{{ path('tax_rates_index') }}">AANP</a></th>
            <th style="text-align: right"><a target="_blank" href="{{ path('impot_tax_rates_index') }}">Impot rate (1st iteration)</a></th>
            <th style="text-align: right">Impot rate (2nd iteration)</a></th>
            <th style="text-align: right"><a target="_blank" href="{{ path('payslip_index') }}">Payslip</a></th>
        </tr>
        </thead>
        <tbody>
        {% set flag = 2 %}
        {% for monthly_payment_made in monthly_payment_mades %}
            {% 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 expenses = payrollService.ExpensesForMonth(monthly_payment_made.employee,monthly_payment_made.paymentemployer,monthly_payment_made.workedmonth) %}

            {% set PerDiem = 0.165* (
                payrollService.ExpensesForMonth(monthly_payment_made.employee,monthly_payment_made.paymentemployer,monthly_payment_made.workedmonth)
                + monthly_payment_made.amount) %}
            {% set netSalary = monthly_payment_made.amount - PerDiem +
                payrollService.ExpensesForMonth(monthly_payment_made.employee,monthly_payment_made.paymentemployer,monthly_payment_made.workedmonth) %}

            {% set amountPaid =monthly_payment_made.amount %}
            {% set grossSalaryPreImpot = ( (monthly_payment_made.amount -
                payrollService.ExpensesForMonth(monthly_payment_made.employee,monthly_payment_made.paymentemployer,monthly_payment_made.workedmonth) )
                *(1+ avsTaxRate + aanpTaxRate )  ) %}

            {% set avsAmount = (grossSalaryPreImpot * avsTaxRate) %}
            {% set aanpAmount = (grossSalaryPreImpot * aanpTaxRate) %}
s
            {% set netSalary = grossSalaryPreImpot - avsAmount - aanpAmount %}

            {% set expensesR = ((20* expenses)|round) /20 %}
            {% set PerDiemR = ((20* PerDiem)|round) /20 %}
            {% set netSalaryR = ((20* netSalary)|round) /20 %}
            {% set grossSalaryR = ((20* grossSalaryPreImpot)|round) /20 %}
            {% set avsAmountR = ((20* avsAmount)|round) /20 %}
            {% set aanpAmountR = ((20* aanpAmount)|round) /20 %}



            {% if payrollService.findPayslipPDF( monthly_payment_made.paymentemployer.id, monthly_payment_made.employee.id, monthly_payment_made.workedmonth) != 'false' %}
                {% set flag = 1 %}
                {% set path= payrollService.findPayslipPDF( monthly_payment_made.paymentemployer.id, monthly_payment_made.employee.id, monthly_payment_made.workedmonth) %}
            {% endif %}

            {% set date= monthly_payment_made.workedmonth|date('m-Y') %}
            {% set group = payrollService.group(monthly_payment_made.employee.id,monthly_payment_made.paymentemployer.id,date)  %}
            {% set data = payrollService.interval(monthly_payment_made.employee.id,monthly_payment_made.paymentemployer.id,monthly_payment_made.workedmonth|date('Y'), group) %}
            {% set start = data['start'] |date('Y-m-d') %}
            {% set end = data['end']|date('Y-m-d') %}
            {% set AGS = payrollService.AGSPreImpot(monthly_payment_made.employee.id,monthly_payment_made.paymentemployer.id, start, end) %}
            {% set ImpotRateEstimate = payrollService.impotTaxRate( start, monthly_payment_made.employee.impotclassification, AGS) %}
            {% set AGSpostImpot = AGS / (1+  (payrollService.InterpolateImpot(date,monthly_payment_made.employee.impotclassification,AGS)) ) %}
            {% set ImpotAmount = (payrollService.InterpolateImpot(date,monthly_payment_made.employee.impotclassification,AGSpostImpot)* grossSalaryR ) %}
            {% set impotAmountR = ((20* impotAmount)|round) /20 %}
            <tr>
                <!-- IDs -->
               <td class="to-hide">
                  {% set date= monthly_payment_made.workedmonth|date('m-Y') %}
                  {{ payrollService.group(monthly_payment_made.employee.id,monthly_payment_made.paymentemployer.id,date) }}</td>
               <td class="to-hide">{{ monthly_payment_made.employee.id }}</td>

                <!-- Employer, Employee -->
                <td>{{ monthly_payment_made.paymentemployer }}</td>

                <td><a target="_blank"
                       href="{{ path('employee_edit', {'id': monthly_payment_made.employee.id}) }}"> {{ monthly_payment_made.employee.fullName }}
                        {% if monthly_payment_made.employee.grossNetPaymentSetUp  == 'Gross' %} (*) {% endif %}
                        {% if monthly_payment_made.employee.jobDescription  != 'Driver' %} (O) {% endif %}
                    </a>
                </td>

               <td>{{ monthly_payment_made.employee.impotClassification }}</td>



                <!-- Month -->
                <td style="text-align: right"
                    data-sort="{{ monthly_payment_made.workedmonth ? monthly_payment_made.workedmonth|date('Y-m-d') : '' }}">{{ monthly_payment_made.workedmonth ? monthly_payment_made.workedmonth|date('M-Y') : '' }}</td>

                <!-- Gross salary = (Payment Made - Expenses) (1 + AVS + AANP exc Impot) -->
                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['grossSalaryR'] != grossSalaryR %}
                            <span class="bg-warning" title="{{path['grossSalaryR']| number_format(2, '.', ',')}}">{{ grossSalaryR|number_format(2, '.', ',') }} </span>
                        {% else  %}
                            {{ grossSalaryR|number_format(2, '.', ',') }}
                        {% endif %}
                    {% else %}
                        {{ grossSalaryR|number_format(2, '.', ',') }}
                    {% endif %}
                </td>

             <td style="text-align: right">

                 {{ (grossSalaryR+ImpotAmount)|number_format(2, '.', ',') }}
                </td>


                <!-- Period count -->
                <td style="text-align: center">

                    {{ payrollService.group(monthly_payment_made.employee.id,monthly_payment_made.paymentemployer.id,date) +1}}
                </td>

                <!-- Average gross salary in 'period' -->
                <td style="text-align: right">

                    {{ AGS |number_format(2, '.', ',') }}
               </td>

                <td style="text-align: right">
                    {{ AGSpostImpot|number_format(2, '.', ',') }}
                </td>

                <!-- Taxes  -->
                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['avsAmountR'] != avsAmountR %}
                          <span class="bg-warning" title="{{path['avsAmountR']| number_format(2, '.', ',')}}">{{ avsAmountR|number_format(2, '.', ',') }} </span>
                        {% else  %}
                            {{ avsAmountR|number_format(2, '.', ',') }}
                        {% endif %}
                        {% else %}
                        {{ avsAmountR|number_format(2, '.', ',') }}
                    {% endif %}
                </td>


                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['aanpAmountR'] != aanpAmountR %}
                            <span class="bg-warning" title="{{path['aanpAmountR']| number_format(2, '.', ',')}}">{{ aanpAmountR|number_format(2, '.', ',') }} </span>
                        {% else  %}
                            {{ aanpAmountR|number_format(2, '.', ',') }}
                        {% endif %}
                    {% else %}
                        {{ aanpAmountR|number_format(2, '.', ',') }}
                    {% endif %}
                </td>

                <td style="text-align: right">LLP</td>

                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['impotAmountR'] != impotAmountR %}
                            <span class="bg-warning" title="{{path['impotAmountR']| number_format(2, '.', ',')}}">{{ impotAmountR|number_format(2, '.', ',') }} </span>
                        {% else  %}
                            {{ impotAmountR|number_format(2, '.', ',') }}
                        {% endif %}
                    {% else %}
                        {{ impotAmountR|number_format(2, '.', ',') }}
                    {% endif %}
                </td>

                <!-- Net sal style="text-align: right"ry = (Paid-Into-Account + Expenses - Per Diem)-->
                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['netSalaryR'] != netSalaryR %}
                            <span class="bg-warning" title="{{path['netSalaryR']| number_format(2, '.', ',')}}">{{ netSalaryR|number_format(2, '.', ',') }} </span>
                        {% else  %}
                            {{ netSalaryR|number_format(2, '.', ',') }}
                        {% endif %}
                    {% else %}
                        {{ netSalaryR|number_format(2, '.', ',') }}
                    {% endif %}
                </td>


                <!-- Expenses -->
                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['expensesR'] != expensesR %}
                            <span class="bg-warning" title="{{path['expensesR']| number_format(2, '.', ',')}}">{{ expensesR|number_format(2, '.', ',') }} </span>
                        {% else  %}
                            {{ expensesR|number_format(2, '.', ',') }}
                        {% endif %}
                    {% else %}
                        {{ expensesR|number_format(2, '.', ',') }}
                    {% endif %}
                </td>

                <!-- per Diem = 16.5% x (Expenses + Paid-Into-Account)-->
                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['perDiemR'] != PerDiemR %}
                            <span class="bg-warning" title="{{path['perDiemR']| number_format(2, '.', ',')}}">{{ PerDiemR|number_format(2, '.', ',') }} </span>
                        {% else  %}
                            {{ PerDiemR|number_format(2, '.', ',') }}
                        {% endif %}
                    {% else %}
                        {{ PerDiemR|number_format(2, '.', ',') }}
                    {% endif %}
                </td>

                <!-- Payments Made -->
                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['amountPaid'] != amountPaid %}
                            <span class="bg-warning" title="{{path['amountPaid']| number_format(2, '.', ',')}}">{{ amountPaidR|number_format(2, '.', ',') }} </span>
                        {% else  %}
                            {{ amountPaid|number_format(2, '.', ',') }}
                            {% if monthly_payment_made.paymentMades.count  > 1 %}
                                ({{ monthly_payment_made.paymentMades.count }})
                            {% endif %}
                        {% endif %}
                    {% else %}
                        {{ amountPaid|number_format(2, '.', ',') }}
                        {% if monthly_payment_made.paymentMades.count  > 1 %}
                            ({{ monthly_payment_made.paymentMades.count }})
                        {% endif %}
                    {% endif %}
                </td>

                <!-- AVS Rate -->
                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['avsRate'] != avsTaxRate %}
                            <span class="bg-warning" title="{{(path['avsRate'] *100)|number_format(2, '.', ',')}}%">{{ (avsTaxRate * 100)|number_format(2, '.', ',') }}% </span>
                        {% else  %}
                            {{ (avsTaxRate * 100)|number_format(2, '.', ',') }}%
                        {% endif %}
                    {% else %}
                        {{ (avsTaxRate  * 100)|number_format(2, '.', ',') }}%
                    {% endif %}
                </td>

                <!-- AANP Rate -->
                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['aanpRate'] != aanpTaxRate %}
                            <span class="bg-warning" title="{{(path['aanpRate']*100)|number_format(2, '.', ',')}}%">{{ (aanpTaxRate * 100)|number_format(2, '.', ',') }}% </span>
                        {% else  %}
                            {{ (aanpTaxRate * 100)|number_format(2, '.', ',') }}%
                        {% endif %}
                    {% else %}
                        {{ (aanpTaxRate  * 100)|number_format(2, '.', ',') }}%
                    {% endif %}
                </td>

                <!-- Impot Rate -->
                <td style="text-align: right">
                     <a title="{{ monthly_payment_made.employee.impotclassification }}">{{ (payrollService.InterpolateImpot(date,monthly_payment_made.employee.impotclassification,AGS)*100)|number_format(3,'.','.') }}%</a>

                </td>

                <td style="text-align: right">
                    {{ (payrollService.InterpolateImpot(date,monthly_payment_made.employee.impotclassification,AGSpostImpot)*100)|number_format(3,'.','.') }}%
                </td>

                <!-- Payslip -->
                <td style="text-align: center">
                    {% if payrollService.findPayslipPDF( monthly_payment_made.paymentemployer.id, monthly_payment_made.employee.id, monthly_payment_made.workedmonth) == 'false' %}
                        <a class="btn-success" target="_blank"
                           href="{{ path('payment_made_payslip',{'search_payslip_month[employer]' : monthly_payment_made.paymentemployer.employer, 'search_payslip_month[employeeID]': monthly_payment_made.employee.id, 'search_payslip_month[employee]':monthly_payment_made.employee.fullName,'search_payslip_month[month]':monthly_payment_made.workedmonth|date('M'), 'search_payslip_month[year]':monthly_payment_made.workedmonth|date('Y'), 'search_payslip_month[date]':monthly_payment_made.workedmonth|date('M-Y')}) }} "> Add</a>
                    {% else %}
                        {% set pathpay= payrollService.findPayslipPDF( monthly_payment_made.paymentemployer.id, monthly_payment_made.employee.id, monthly_payment_made.workedmonth) %}
                        <a target="_blank" href="{{ asset(pathpay['fileName']) }}" class="text-danger"><i class="fas fa-file-pdf" style="font-size: 20px"></i></a>
                    {% endif %}
                </td>
            </tr>
            {% set flag = 2 %}
        {% endfor %}
        </tbody>
    </table>


{% endblock %}


{% block javascripts %}
    {{ parent() }}
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">
    <script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>
    <script src="https://npmcdn.com/flatpickr/dist/l10n/fr.js"></script>
{#    <script src="{{ asset('admin/js/AGS.js') }}"></script>#}

    <script>

       // $('.to-hide').hide();
        $(document).ready(function () {





            $(".datepicker").flatpickr({
                altInput: true,
                altFormat: "d M Y",
                //defaultDate: "",
                time_24hr: true,
                enableTime: false,
                noCalendar: false,
                dateFormat: "Y-m-d H:i",
                minuteIncrement: 15
                //minDate: "today",
            });
        })
    </script>


    {% include 'template_parts/_js_date_ranges.html.twig' %}
{% endblock javascripts %}

{% block datatable %}
    <script>
        $(document).ready(function () {
            $('#table').DataTable({
                'pageLength': 100,
                 "order": [[2, 'asc'], [3, 'asc'], [4, 'asc']],
                "paging": true,
                "searching": true,
                "bInfo": true
            });
        });
    </script>
{% endblock datatable %}