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

{% block title %}
    {% trans %}Team report{% endtrans %}
    <small>{{ date|date('Y-m') }}{% if team %}, {% trans %}Team{% endtrans %}: {{ team }}{% endif %}</small>
{% endblock %}

{% block containerclass %}mainnav-sm{% endblock %}

{% block content %}
    {% if markets | length > 0 %}
        <div class="panel">
            <div class="panel-body table-responsive">
                <div class="row">
                    <h4 class="col-sm-2">{% trans %}Markets{% endtrans %}</h4>
                    <div class="col-sm-10">
                        <table class="table table-bordered table-condensed pull-right" style="width: auto">
                            <tr>
                                <td class="text-right">{% trans %}Hours{% endtrans %}/K:</td>
                                <th class="text-center">{{ sumSicknessCash | number_format }}</th>
                                <td class="text-right">{% trans %}Hours{% endtrans %}/U:</td>
                                <th class="text-center">{{ sumHolidayCash | number_format }}</th>
                                <td class="text-right">{% trans %}Hours{% endtrans %}:</td>
                                <th class="text-center">{{ sumWorktime | number_format }}</th>
                                <td class="text-right">{% trans %}Bonus{% endtrans %}:</td>
                                <th class="text-center">{{ sumBonus | number_format }}</th>
                                <td class="text-center">=</td>
                                <th class="text-center">{{ (sumBonus + sumWorktime + sumSicknessCash + sumHolidayCash) | number_format }}</th>
                                <td class="text-right">{% trans %}Total value{% endtrans %}:</td>
                                <th class="text-center">{{ sumTotalValue | number_format }}</th>
                                <td class="text-right">{% trans %}Score{% endtrans %}:</td>
                                <th class="text-center text-{{ result < 0 ? 'danger' : 'success' }}">{{ result | number_format }}</th>
                            </tr>
                        </table>
                    </div>
                </div>
                <table class="table table-condensed mar-top">
                    <thead>
                    <tr>
                        <th class="text-center"{% if date|date('Y') > 2018 %} colspan="2"{% endif %}>{% trans %}Market number{% endtrans %}</th>
                        <th class="text-center">{% trans %}Food CT{% endtrans %}</th>
                        <th class="text-center">{% trans %}Food Pal{% endtrans %}</th>
                        {% if date|date('Y') < 2019 %}
                            <th class="text-center">{% trans %}Food XXL{% endtrans %}</th>
                        {% endif %}
                        <th class="text-center">{% trans %}Non-food CT{% endtrans %}</th>
                        <th class="text-center">{% trans %}Non-food Pal{% endtrans %}</th>
                        <th class="text-center">{% trans %}Frozen CT{% endtrans %}</th>
                        {% if date|date('Y') < 2019 %}
                            <th class="text-center">{% trans %}Frozen Pal{% endtrans %}</th>
                        {% endif %}
                        <th class="text-center">{% trans %}Order.{% endtrans %}</th>
                        <th class="text-center">{% trans %}Sausage Pal{% endtrans %}</th>
                        <th class="text-center">{% trans %}Milk CT{% endtrans %}</th>
                        {% if date|date('Y') < 2019 %}
                            <th class="text-center">{% trans %}Milk Pal{% endtrans %}</th>
                        {% endif %}
                        <th class="text-center">{% trans %}Hours{% endtrans %}</th>
                        {% if date|date('Y') < 2019 %}
                            <th class="text-center">{% trans %}Goods control{% endtrans %}</th>
                        {% else %}
                            <th class="text-center">Kolli</th>
                        {% endif %}
                    </tr>
                    </thead>
                    <tbody>
                    {% for market in markets %}
                        <tr class="text-center">
                            <td class="text-center"{% if date|date('Y') > 2018 %} colspan="2"{% endif %}>{{ market.record.market.number }}</td>
                            <td class="text-center">{{ market.foodContainer | default(0) | number_format }}</td>
                            <td class="text-center">{{ market.foodPalette | default(0) | number_format }}</td>
                            {% if date|date('Y') < 2019 %}
                                <td class="text-center">{{ market.foodPaletteXxl | default(0) | number_format }}</td>
                            {% endif %}
                            <td class="text-center">{{ market.nonFood | default(0) | number_format }}</td>
                            <td class="text-center">{{ market.nonFoodPalette | default(0) | number_format }}</td>
                            <td class="text-center">{{ market.frozenFoodContainer | default(0) | number_format }}</td>
                            {% if date|date('Y') < 2019 %}
                                <td class="text-center">{{ market.frozenFoodPalette | default(0) | number_format }}</td>
                            {% endif %}
                            <td class="text-center">{{ market.ordering | default(0) | number_format }}</td>
                            <td class="text-center">{{ market.sausagePalette | default(0) | number_format }}</td>
                            <td class="text-center">{{ market.milkProductContainer | default(0) | number_format }}</td>
                            {% if date|date('Y') < 2019 %}
                                <td class="text-center">{{ (market.milkProductPalette | default(0) + market.milkProductPaletteXxl | default(0)) | number_format }}</td>
                            {% endif %}
                            <td class="text-center">{{ market.hours | default(0) | number_format }}</td>
                            <td class="text-center">{{ market.goodsReceiptControl | default(0) | number_format }}</td>
                        </tr>
                        <tr class="bg-gray">
                            <th> &gt;&gt;</th>
                            <th>{{ market.workers | default(0) | number_format }} {% trans %}W.{% endtrans %}</th>
                            <th colspan="{{ date|date('Y') < 2019 ? '3' : '1' }}"
                                style="text-align: right">{% trans %}Month{% endtrans %} {% trans %}Worktime{% endtrans %}
                                :
                            </th>
                            <th class="text-center">{{ market.worktime | default(0) | number_format }}</th>
                            <th style="text-align: right">{% trans %}Bonus{% endtrans %}:</th>
                            <th class="text-center">{{ market.bonus | default(0) | number_format }}</th>
                            <th class="text-center">{% trans %}is{% endtrans %}</th>
                            <th class="text-center">{{ (market.worktime | default(0) + market.bonus | default(0)) | number_format }}</th>
                            <th colspan="1" class="text-right">{% trans %}Total value{% endtrans %}:</th>
                            <th class="text-center">{{ market.totalValue | number_format }}</th>
                            <th class="text-right">{% trans %}Score{% endtrans %}:</th>
                            <th class="text-center text-{{ market.result < 0 ? 'danger' : 'success' }}">{{ market.result | number_format }}</th>
                        </tr>
                    {% endfor %}
                    </tbody>
                </table>
            </div>
        </div>
    {% endif %}

    {% if workers | length > 0 %}
        {% set displayNightHours = (team >= 1000 and team <= 1015) or team == 'BL02' %}

        <div class="panel">
            <div class="panel-body table-responsive">
                <h4>{% trans %}Workers{% endtrans %}</h4>
                <table class="table table-condensed table-striped mar-top">
                    <thead>
                    <tr>
                        <th>{% trans %}Worker No.{% endtrans %}</th>
                        <th>{% trans %}Last name{% endtrans %}</th>
                        <th></th>
                        <th class="text-center">{% trans %}Hours{% endtrans %}</th>
                        <th style="width: 2cm">
                            {% if displayNightHours %}Nachtzuschl.{% endif %}
                        </th>
                        <th class="text-center">{% trans %}Bonus{% endtrans %}</th>
                        <th class="text-center" style="width: 3cm">{% trans %}Travel time{% endtrans %}</th>
                        <th class="text-center">{% trans %}h{% endtrans %}/K</th>
                        <th class="text-center">{% trans %}h{% endtrans %}/U</th>
                        <th class="text-center">{% trans %}Reduction{% endtrans %}</th>
                        <th class="text-center">{% trans %}Tick.{% endtrans %}</th>
                        <th class="text-center">{% trans %}Upfront money{% endtrans %}</th>
                        <th style="width: 2cm"></th>
                        <th class="text-center">{% trans %}Exec. limit{% endtrans %}</th>
                        {#<th class="text-center">RILA</th>#}
                    </tr>
                    </thead>
                    <tbody>
                    {% for worker in workers %}
                        <tr>
                            <td>{{ worker.worker.number }}</td>
                            <td>{{ worker.worker.lastName }}</td>
                            <td class="text-center">{{ worker.worker.position }}</td>
                            <td class="text-center bord-rgt">{{ worker.worktime | number_format }}</td>
                            <td class="text-center">
                                {% if displayNightHours %}{{ worker.nightWorktimeSumHours | number_format }}{% endif %}
                            </td>
                            <td class="text-center bord-lft bord-rgt">
                                {% if displayNightHours %}
                                    {{ (worker.bonus - worker.nightWorktimeSum - worker.worktime * worker.workerData.hourlyRate) | number_format }} &euro;
                                {% else %}
                                    {{ worker.bonus | number_format }}
                                {% endif %}
                            </td>
                            <td class="text-center">{{ worker.travelTime | number_format }}</td>
                            <td class="text-center bord-lft">{{ worker.sicknessCash | number_format }}</td>
                            <td class="text-center bord-rgt">{{ worker.holidayCash | number_format }}</td>
                            <td class="text-center bord-rgt">{{ worker.workerData.payment | number_format }} &euro;</td>
                            <td class="bord-rgt"></td>
                            <td class="bord-rgt"></td>
                            <td class="bord-rgt"></td>
                            <td class="text-center bord-rgt">{{ worker.workerData.executionLimit | number_format }}
                                &euro;
                            </td>
                            {#<td class="text-center">{{ worker.rilaCarton | number_format }} &euro;</td>#}
                        </tr>
                    {% endfor %}
                    <tr>
                        <td colspan="15">&nbsp;</td>
                    </tr>
                    <tr class="bg-gray">
                        <th colspan="3" class="text-right">{% trans %}Sum{% endtrans %}</th>
                        <th class="text-center">{{ sumWorkerHours | number_format }}</th>
                        <td></td>
                        <th class="text-center">{{ sumWorkerBonus | number_format }}</th>
                        <th class="text-center">{{ sumWorkerTravelTime | number_format }}</th>
                        <th class="text-center">{{ sumWorkerHoursSick | number_format }}</th>
                        <th class="text-center">{{ sumWorkerHoursHoliday | number_format }}</th>
                        <th colspan="5"></th>
                        {#<th class="text-center">{{ sumWorkerHoursRilaCarton | number_format }}</th>#}
                    </tr>
                    </tbody>
                </table>
            </div>
        </div>
    {% endif %}
{% endblock %}