{% extends 'base_admin.html.twig' %}
{% block title %}AVS Declaration (Dynamic){% endblock %}
{% block body %}

    <h1 class="text-danger">AVS Declaration (Dynamic)</h1>
    {% include ('template_parts/_date_ranges_avs_impot_declaration.html.twig') %}
    <a class="btn btn-outline-primary" href="{{ path('avsdeclarationPDF') }}?search_annual_declaration[year]={{ selected_year }}&search_annual_declaration[employer]={{ selected_employer }}">Print AVS declaration PDF</a>
    <table id="maintable" class="table mt-2 table1">
        <thead>
        <tr>
            <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>AVS Number</th>
            <th style="text-align: left">Date of Birth</th>
            <th style="text-align: left">List of months</th>
            <th style="text-align: right" title="Total Gross Salary when AVS <> 0">Soumis AVS (CHF)</th>
            <th style="text-align: right" title="Total AVS Amount"> Soumis AC (CHF)</th>
            <th style="text-align: right" title="Total Gross Salary when AVS == 0">Non Soumis AVS (CHF)</th>
            <th style="text-align: right" title="Downloaded PDF">Download</th>
        </tr>
        </thead>
        <tbody>

        {% for employee in employees1 %}
            {% set TotalgrossSalaryWhenAvsNonZero=0 %}
            {% set TotalgrossSalaryWhenAvsZero=0 %}
            {% set TotalAvsPayments=0 %}
            {% set employeefullName='' %}
            {% set employer='' %}
            {% set avsNumber='' %}
            {% set dateOfBirth='' %}
            {% set listOfMonths=[] %}
            {% set flag = 0 %}
            {% set path = '' %}
            {% 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 TotalgrossSalaryWhenAvsNonZero = ((20* TotalgrossSalaryWhenAvsNonZero)|round) /20 %}
                    {% set TotalgrossSalaryWhenAvsZero = ((20* TotalgrossSalaryWhenAvsZero)|round) /20 %}
                    {% set TotalAvsPayments = ((20* TotalAvsPayments)|round) /20 %}

                    {% set employeefullName = monthly_payment_made.employee.fullName %}
                    {% set employeeid = monthly_payment_made.employee.id %}
                    {% set employer = monthly_payment_made.paymentemployer.employer %}
                    {% set avsNumber = monthly_payment_made.employee.avsNumber %}
                    {% set dateOfBirth = monthly_payment_made.employee.dateOfBirth %}


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

                {% endif %}
            {% endfor %}

            <tr>
                <td>{{ employer }}</td>
                <td><a target="_blank"
                       href="{{ path('employee_edit', {'id': employee[1]}) }}">{{ employeefullName }}</a></td>


                <td>
                    {% if path is defined and flag==1 %}
                        {% if path['avsNumber'] != avsNumber %}
                            <span class="bg-warning" title="{{ path['avsNumber'] }}">{{ avsNumber }} </span>
                        {% else %}
                            <span title="{{ path['avsNumber'] }}">{{ avsNumber }} </span>
                        {% endif %}
                    {% else %}
                        <span title="No history">{{ avsNumber }} </span>
                    {% endif %}
                </td>


                <td data-sort="{{ dateOfBirth|date('Y-m-d') }}">
                    {% if path is defined and flag==1 %}
                        {% if path['dateOfBirth'] != dateOfBirth|date('d-M-Y') %}
                            <span class="bg-warning"
                                  title="{{ path['dateOfBirth'] }}">{{ dateOfBirth|date('d-M-Y') }} </span>
                        {% else %}
                            <span title="{{ path['dateOfBirth'] }}">  {{ dateOfBirth|date('d-M-Y') }} </span>
                        {% endif %}
                    {% else %}
                        <span title="No history">  {{ dateOfBirth|date('d-M-Y') }} </span>
                    {% endif %}
                </td>

                <td style="text-align: left">
                    {% set listOfMonths=listOfMonths|sort %}
                    {% for index,getMonth in listOfMonths %}
                        {{ index }}
                    {% endfor %}
                </td>

                <!-- Total Gross Salary when AVS <> 0  (Soumis AVS (CHF) -->
                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['avsSoumis'] != TotalgrossSalaryWhenAvsNonZero %}
                            <span class="bg-warning"
                                  title="{{ path['avsSoumis']| number_format(2, '.', ',') }}">{{ TotalgrossSalaryWhenAvsNonZero| number_format(2, '.', ',') }} </span>
                        {% else %}
                            <span title="{{ path['avsSoumis']| number_format(2, '.', ',') }}">{{ TotalgrossSalaryWhenAvsNonZero| number_format(2, '.', ',') }} </span>
                        {% endif %}
                    {% else %}
                        <span title="No history">{{ TotalgrossSalaryWhenAvsNonZero| number_format(2, '.', ',') }} </span>
                    {% endif %}
                </td>


                <!--Total AVS Amount (Soumis AC (CHF) -->

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

                <!-- Total Gross Salary when AVS == 0  (Soumis AVS (CHF) -->
                <td style="text-align: right">
                    {% if path is defined and flag==1 %}
                        {% if path['avsNonSoumis'] != TotalgrossSalaryWhenAvsZero %}
                            <span class="bg-warning"
                                  title="{{ path['avsNonSoumis'] }}">{{ TotalgrossSalaryWhenAvsZero| number_format(2, '.', ',') }} </span>
                        {% else %}
                            <span title="{{ path['avsNonSoumis']| number_format(2, '.', ',') }}">{{ TotalgrossSalaryWhenAvsZero| number_format(2, '.', ',') }} </span>
                        {% endif %}
                    {% else %}
                        <span title="No history">{{ TotalgrossSalaryWhenAvsZero| number_format(2, '.', ',') }} </span>
                    {% endif %}
                </td>


                <!-- Downloaded PDF? -->
                <td style="text-align: right">{{ flag }}</td>
            </tr>

        {% endfor %}
        </tbody>
    </table>

    <br>

    <h1 class="text-danger">AVS Declarations Saved</h1>
    <a href="{{ path('avs_declaration_index') }}">>>AVS download</a>
    <table class="table w-25 " style="margin:0px 0px!important;">
        <thead>
        <tr>
            <th>Year</th>
            {% for employer in employers %}
                <th style="text-align:center">{{ employer }}</th>
            {% endfor %}
        </tr>
        </thead>
        <tbody>
        {% for year in years %}
            <tr>
                <td>{{ year.year }}</td>
                {% for employer in employers %}
                    <td style="text-align:center">
                        {% set path = 'avsdeclaration/AVS Declaration-'~employer~'-'~year.year~'.pdf' %}
                        {% set filename = 'AVS Declaration-'~employer~'-'~year.year~'.pdf' %}
                        {% for file in files %}
                            {% if file == filename %}
                                <a href="{{ asset(path) }}" class="text-danger"><i class="fas fa-file-pdf"  style="font-size: 20px"></i></a>
                            {% endif %}
                        {% endfor %}


                    </td>
                {% endfor %}
            </tr>
        {% endfor %}
        </tbody>
    </table>

    <hr><br><br>
{% 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>
        $(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_range_annual_declaration.html.twig' %}
{% endblock javascripts %}

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