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

{% block title %}Payslip downloads{% endblock %}

{% block body %}

    <h1 class="text-danger">Payslip Downloads </h1>

    <table class="table">
        <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>Month</th>
                <th>Payslip PDF</th>
                <th style="text-align: right" title="Gross salary = (Payment Made - Expenses) (1 + AVS + AANP + Impot)">Gross salary <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 <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</a></th>
                <th style="text-align: right">Actions</th>
            </tr>
        </thead>
        <tbody>
        {% for payslip in payslips %}
            <tr>
                <td>{{payslip.employer}}</td>
                <td><a href="{{ path('payslip_edit', {'id': payslip.id}) }}"> {{payslip.employee.fullName}}</td>
                <td data-sort="{{ payslip.month ? payslip.month|date('Y-m-d') : '' }}">{{ payslip.month|date('M-Y') }}</td>
                <td title="{{payslip.payslipPDF}}"><a href="{{ asset('payslip/'~payslip.payslipPDF) }}">Link</a></td>
                <td style="text-align: right">{{payslip.grossSalary|number_format(2, '.', ',')}}</td>
                <td style="text-align: right">CMW#</td>
                <td style="text-align: right">AGS</td>
                <td style="text-align: right">{{payslip.avsAmount|number_format(2, '.', ',') }}</td>
                <td style="text-align: right">{{payslip.aanpAmount|number_format(2, '.', ',') }}</td>
                <td style="text-align: right">{{payslip.llpAmount|number_format(2, '.', ',') }}</td>
                <td style="text-align: right">{{payslip.impotAmount|number_format(2, '.', ',') }}</td>
                <td style="text-align: right">{{payslip.netSalary|number_format(2, '.', ',') }}</td>
                <td style="text-align: right">{{payslip.expenses|number_format(2, '.', ',') }}</td>
                <td style="text-align: right">{{payslip.perDiem|number_format(2, '.', ',') }}</td>
                <td style="text-align: right">{{payslip.amountPaid|number_format(2, '.', ',') }}</td>

                <td style="text-align: right">{{(payslip.avsRate*100)|number_format(2, '.', ',') }}%</td>
                <td style="text-align: right">{{(payslip.aanpRate*100)|number_format(2, '.', ',') }}%</td>
                <td style="text-align: right">{{(payslip.impotRate*100)|number_format(2, '.', ',') }}%</td>
                <td>
                    <form method="post" action="{{ path('payslip_delete', {'id': payslip.id}) }}" onsubmit="return confirm('Are you sure you want to delete this item?');">
                        <input type="hidden" name="_method" value="DELETE">
                        <input type="hidden" name="_token" value="{{ csrf_token('delete' ~ payslip.id) }}">
                        <button class="btn btn-danger">Delete</button>
                    </form>
                </td>
            </tr>
        {% else %}

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

{% endblock %}

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