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

{% block page_title %}Estadísticas de ajuste de tarifas{% endblock %}

{% block page_content %}
    <div class="row">
        <div class="col-md-12">
            <div class="box box-solid">
                <div class="box-body ">
                    <div class="col-sm-12 text-right">
                        <p>
                            <a class="btn btn-primary" href="{{ path('excel_rate_adjustment_report', { 'carrierInvoiceDiffReportId' : carrierInvoiceDiffReportId}) }}">Excel</a>
                        </p>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
    <div class="col-md-12">
        <div class="nav-tabs-custom">
            <ul class="nav nav-tabs">
                <li class="active">
                    <a href="#tab-auto-correct" data-toggle="tab"
                       aria-expanded="true">AUTO CORRECT</a>
                </li>
                <li>
                    <a href="#tab-revise" data-toggle="tab"
                       aria-expanded="true">REVISE</a>
                </li>
                <li>
                    <a href="#tab-not-significant" data-toggle="tab"
                       aria-expanded="true">NOT SIGNIFICANT</a>
                </li>
                <li>
                    <a href="#tab-corrected" data-toggle="tab"
                       aria-expanded="true">CORRECTED</a>
                </li>
            </ul>
            <div class="tab-content">
                {% include 'carrier_rate_report/_partial.html.twig' with { 'pane_name' : 'auto-correct', data: filtered_shipping_range.data, 'active' : true } %}

                {% include 'carrier_rate_report/_partial.html.twig' with { 'pane_name' : 'revise', data: filtered_shipping_range.error, 'active' : false} %}

                {% include 'carrier_rate_report/_partial.html.twig' with { 'pane_name' : 'not-significant', data: filtered_shipping_range.notSignificant, 'active' : false } %}

                <div id="tab-corrected" class="tab-pane">
                    <table class="table" id="rate-adjustment-corrected">
                        <thead>
                            <tr>
                                <th>pk</th>
                                <th>dest country id</th>
                                <th>dest zip</th>
                                <th>dest zip to</th>
                                <th>condition from value</th>
                                <th>condition to value</th>
                                <th>original price</th>
                                <th>original cost</th>
                                <th>rate price total</th>
                                <th>rate price diff</th>
                                <th>rate price %</th>
                                <th>shipping lines count</th>
                                <th>GANAR 5%</th>
                                <th>GANAR 10%</th>
                            </tr>
                        </thead>
                        <tbody>
                        {% for row in filtered_shipping_range.data %}


                            {% set corrected_rate_price_5_percent = '-' %}
                            {% set corrected_rate_price_10_percent = '-' %}

                            {% set percentage_price = row.sumDiffPrice/row.totalPrice %}

                            {% if percentage_price < -0.6 or percentage_price > -0.4 %}
                                {% set corrected_rate_price_5_percent = (row.price * ( 1.05 + percentage_price)) | round(2) %}
                                {% set corrected_rate_price_10_percent = (row.price * ( 1.10 + percentage_price)) |round(2) %}
                            {% endif %}

                            <tr>
                                <td>{{ row.pk }} </td>
                                <td>{{ row.destCountryBigBuyId }} </td>
                                <td>{{ row.destZip }} </td>
                                <td>{{ row.destZipTo }} </td>
                                <td>{{ row.conditionFromValue }} </td>
                                <td>{{ row.conditionToValue }} </td>
                                <td>{{ row.price }} </td>
                                <td>{{ row.cost }} </td>
                                <td>{{ row.totalPrice }} </td>
                                <td>{{ row.sumDiffPrice }} </td>
                                <td>{{ percentage_price |round(2)}}</td>
                                <td>{{ row.processedElements }} </td>
                                <td>{{ corrected_rate_price_5_percent }}</td>
                                <td>{{ corrected_rate_price_10_percent }}</td>
                            </tr>
                        {% endfor %}
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
{% endblock %}
{% block javascripts %}
        {{ parent() }}
        <script>
            $(document).ready(function(e) {
                let options = {
                  "pageLength": 20
                };

                $('#rate-adjustment-corrected').dataTable(options);
                $('#rate-adjustment-auto-correct').dataTable(options);
                $('#rate-adjustment-revise').dataTable(options);
                $('#rate-adjustment-not-significant').dataTable(options);
            });
        </script>
{% endblock %}