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

{% block title %}Impot Declaration (Dynamic){% endblock %}

{% block body %}
    <h1 class="text-danger">Impot Declaration (Dynamic)</h1>
    {% include ('template_parts/_date_ranges_avs_impot_declaration.html.twig') %}
    <a class="btn btn-outline-primary" href="{{ path('impotdeclarationPDF') }}?search_annual_declaration[year]={{ selected_year }}&search_annual_declaration[employer]={{ selected_employer }}">Print Impot declaration PDF</a>

    <table id="table" class="table mt-2">
        <thead>
        <tr>
            <th>Employer</th>
            <th>N° Sourcier ou date naissance</th>
            <th style="text-align: left">Employee</th>
            <th style="text-align: center">Etat Civil</th>
            <th>Domicile</th>
            <th style="text-align: right">Duree d'occupation du</th>
            <th style="text-align: right">Duree d'occupation au</th>
            <th style="text-align: right" title="Gross salary in period / # months in period">Salaire mensuel determinant le taux (CHF)</th>
            <th style="text-align: right" title="Gross salary in period">Salaire brut (CHF)</th>
            <th style="text-align: right">Colonne tarifaire</th>
            <th style="text-align: right">Taux I.O.</th>
            <th style="text-align: right">Impot retenu</th>
            <th style="text-align: right">PDF</th>
        </tr>
        </thead>
        <tbody>

        {% for getEmployee in employeeList  %}
            <tr>
                <td>{{ getEmployee[4] }}</td>
                <td>{{ getEmployee[0].dateOfBirth|date('d-M-Y') }}</td>
                <td>{{ getEmployee[0].fullName }}</td>
                <td style="text-align: center">{{ getEmployee[0].etatCivil }}</td>
                <td>Domicile</td>
                <td style="text-align: right">
                    {% set data=payrollService.interval(getEmployee[0].id,getEmployee[3],getEmployee[2],getEmployee[1]) %}
                    {% set start = data['start']|date('Y-m-d') %}
                    {% set end =  data['end']|date('Y-m-d') %}
                    {% set monthcount =  1+ data['end']|date('m') - data['start']|date('m') %}
                    {{ data['start']|date('d-M-Y') }}
                </td>
                <td style="text-align: right">{{ data['end']|date_modify("+1 month -1 days")|date('d-M-Y') }}</td>
                <td style="text-align: right">{{ (payrollService.grossSalaryForPeriod( getEmployee[0].id, getEmployee[3],start,end)/monthcount)|number_format(2, '.', ',') }}</td>
                <td style="text-align: right">{{ payrollService.grossSalaryForPeriod( getEmployee[0].id, getEmployee[3],start,end)|number_format(2, '.', ',') }}</td>
                <td style="text-align: right">{{ getEmployee[0].impotClassification }}</td>
                <td style="text-align: right">2%</td>
                <td style="text-align: right">{{ ( 0.02 * payrollService.grossSalaryForPeriod( getEmployee[0].id, getEmployee[3],start,end))|number_format(2, '.', ',') }}</td>
                <td style="text-align: right">PDF</td>
            </tr>
        {% else %}

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

    <h1 class="text-danger">Impot Declarations Saved</h1>
    <a href="{{ path('impot_declaration_index') }}">>>Impot 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 = 'impotdeclaration/Impot Declaration-'~employer~'-'~year.year~'.pdf' %}
                        {% set filename = 'Impot 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 %}