{% extends '@Core/base.html.twig' %}
{% block sectionTitle %}Pedidos EAN{% endblock %}
{% block sectionActions %}
    {% if roleRight == true or isShopManager %}
        <a class="btn bg-color5 btn-rounded heading-btn" href="{{ path('orders_ean_new') }}"><i class="icon-plus2 position-left"></i>Nuevo Pedido EAN</a>
    {% endif %}
{% endblock %}
{% block breadcrumbLinks %}
    <li><a class="" href="{{ path('orders_menu') }}">Menú de pedidos</a></li>
    <li class="active">Pedidos EAN</li>
{% endblock %}


{% block content %}
    <div class="panel-flat">

        <div class="panel-body">

            {% for label, flashes in app.session.flashbag.all %}
                {% for flash in flashes %}
                    <div class="alert alert-{{ label }}">
                        {{ flash }}
                    </div>
                {% endfor %}
            {% endfor %}

            {% include '@Core/OrdersEAN/_search.html.twig' %}

            <div class="panel panel-flat">
                <div class="panel-heading" id="orders_founded">
                    <h6 class="panel-title" style="margin-bottom: 0px;">{{ elements | length }} PEDIDOS EAN ENCONTRADOS</h6>
                    <span id="dataTable_info"></span>
                </div>

                <div class="panel-body">

                    <div id="DataTables_Table_0_draft_wrapper" class="dataTables_wrapper no-footer">
                        <div class="datatable-scroll table-responsive">
                            <table class="table no-footer" id="DataTables_Table_0_draft" role="grid"
                                   aria-describedby="DataTables_Table_0_draft_info">

                                <thead>
                                <tr role="row">
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1" colspan="1">

                                    </th>

                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1" colspan="1">
                                        COD-Pedido
                                    </th>
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1" colspan="1">
                                        Creación
                                    </th>
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1" colspan="1">
                                        Últ.Modificación
                                    </th>
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1" colspan="1">
                                        Proveedor
                                    </th>
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1" colspan="1">
                                        Marca
                                    </th>
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1" colspan="1">
                                        Pricat
                                    </th>
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1" colspan="1">
                                        Temporada
                                    </th>
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1" colspan="1">
                                        Tienda
                                    </th>

                                    <th class="col-sm-1 text-center" id="units_sum">UNIDADES</th>
                                    <th class="col-sm-1 text-center" id="articles_sum">ARTÍCULOS</th>

                                    {% if roleRight == true or isShopManager %}
                                        <th class="col-sm-1 text-center" id="valoration_sum">Valoración</th>
                                    {% endif %}

                                </tr>
                                </thead>

                                <tbody>

                                {% for obj in elements %}

                                    <tr role="row" class="odd">
                                        {% if obj.dealer.getWebPath() is not null %}
                                            <td><img class="gallery-item" data-src="{{obj.dealer.getWebPath() | imagine_filter('list')}}"/></td>
                                        {% else %}
                                            <td></td>
                                        {% endif %}
                                        {% if roleRight == true or isShopManager %}
                                            <td><a href="{{ path('orders_ean_edit', {"id" : obj.id}) }}">{{ obj.alias }}</a></td>
                                        {%  else %}
                                            <td>{{ obj.alias }}</td>
                                        {% endif %}
                                        <td><span style="display: none">{{ obj.createdAt | date('Ymd') }}</span>{{ obj.createdAt | date('d-m-Y - H:i:s') }}</td>
                                        <td>
                                                {% if obj.dateOrderClosing is not null %}
                                                    <span style="display: none">{{ obj.dateOrderClosing | date('Ymd') }}</span>{{ obj.dateOrderClosing | date('d-m-Y - H:i:s') }}<br> <span class="label bg-success-600">Completado</span>
                                                {% else %}
                                                    <span style="display: none">{{ obj.modifiedAt | date('Ymd') }}</span>{{ obj.modifiedAt | date('d-m-Y - H:i:s') }}
                                                {% endif %}

                                        </td>
                                        <td>{{ obj.dealer.name }}</td>
                                        <td>{{ obj.brand }}</td>
                                        <td>{{ obj.pricat }}</td>
                                        <td>{{ obj.season }}</td>
                                        <td>{{ obj.shop }}</td>

                                        <td style="text-align: center">
                                            {{ obj.numStock + obj.numStockExisting }}
                                        </td>

                                        <td style="text-align: center">{{ obj.numArticles + obj.numArticlesExisting }}</td>

                                        {% if roleRight == true or isShopManager %}
                                            <td style="text-align: center">{{ (obj.totalValoration + obj.totalValorationExisting) | number_format(2, '.', ',') }} €</td>
                                        {% endif %}

                                    </tr>

                                {% endfor %}

                                </tbody>

                                <tfoot>
                                <tr role="row">
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1" colspan="8"></th>
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0_draft" rowspan="1">
                                        <strong>TOTALES</strong>
                                    </th>
                                    <th class="col-sm-1" id="units_cell"  style="text-align: center"></th>
                                    <th class="col-sm-1" id="articles_cell" style="text-align: center"></th>
                                    {% if roleRight == true or isShopManager %}
                                        <th class="col-sm-1" id="valoration_cell" style="text-align: center"></th>
                                    {% endif %}

                                </tr>
                                </tfoot>

                            </table>
                        </div>

                    </div>
                </div>

            </div>

        </div>
    </div>

    <div id="order_label_modal_container">

    </div>

    {% include "@Core/Article/_stock_modal_menu.html.twig" %}

{% endblock %}

{% block script %}
    <script type="text/javascript" src="{{asset('assets/js/entity.js')}}?v={{ "now"|date("d-m-Y") }}"></script>
    <script>

        jQuery.fn.dataTable.Api.register( 'sum()', function () {
            return getSumUsingFilter(this);
        });

        $(document).ready(function(){
            entity.init({
                urlRemoveEntity: "{{ url('ajax_typeprovince_delete') }}"
            });

            var table = $('#DataTables_Table_0_draft').DataTable({
                retrieve: true,
                drawCallback: function(){
                    loadImagesIntoTable();
                }
            }).order([2, 'desc']).draw();

            getTotalUnits(table);
            getTotalArticles(table);
            {% if roleRight == true or isShopManager %}
                getTotalValoration(table);
            {% endif %}
        });

        $('[id^=print_label_order]').click(function () {
            var orderId = $(this).data('order');

            var path = Routing.generate('_ajax_print_labels_order', {'orderId' : orderId});

            $.get(path, function (result) {
                $('#order_label_modal_container').empty();
                $('#order_label_modal_container').append(result);
                $('#order-print-label').modal('show');
            }).fail(function (err) {
                console.log(err.responseText);
            });
        });

        function getTotalUnits(table){
            table.columns('#units_sum').every(function () {

                var sum = getSum(this);

                if(sum > 0) {
                    $('#units_cell').html(sum.toFixed(0));
                } else {
                    $('#units_cell').html(sum.toFixed(0));
                }

            });
        }

        function getTotalArticles(table) {
            table.columns('#articles_sum').every(function () {

                var sum = getSum(this);

                if(sum > 0) {
                    $('#articles_cell').html(sum.toFixed(0));
                }

            });
        }

        function getTotalValoration(table) {
            table.columns('#valoration_sum').every(function () {

                var sum = getSum(this);

                if(sum > 0) {
                    $('#valoration_cell').html(Number(sum.toFixed(2)).toLocaleString(undefined, {minimumFractionDigits: 2})+" €");
                }

            });
        }

        function getSum(table){
            var sum = 0;

            for(var i = 0; i < table.data().length; i++)
            {
                var text = table.data()[i].replace(/<.*>/, '');
                text = text.replace(/<.*>/, '');
                text = text.replace('€', '');
                text = text.replace(',', '');

                if(text.length > 0) {
                    sum += Number(text.trim());
                }
            }

            return sum;
        }

        function getSumUsingFilter(object) {
            var sum = 0;

            for(var i = 0; i < object.length; i++)
            {
                if(object[i]){
                    var text = object[i].replace(/<.*>/, '');
                    text = text.replace(/<.*>/, '');
                    text = text.replace('€', '');
                    text = text.replace(',', '');
                    if(text.length > 0) {
                        sum += Number(text.trim());
                    }
                }
            }

            return sum;
        }

        //if filter changes calculate total of new rows
        $('#DataTables_Table_0_draft').on( 'search.dt', function () {
            var tab = $('#DataTables_Table_0_draft').DataTable();

            var units = tab.column(8, {"filter": "applied"}).data().sum();
            var articles = tab.column(9, {"filter": "applied"}).data().sum();
            var valoration_total = tab.column(10, {"filter": "applied"}).data().sum();

            if (units > 0) {
                $('#units_cell').html('<div style="border-radius: 50%; width: 35px; height: 35px; text-align: center; vertical-align: middle; line-height: 35px; margin: auto" class="bg-green">' + units.toFixed(0) + '</div>');
            } else {
                $('#units_cell').html('');
            }

            if (articles > 0) {
                $('#articles_cell').html(articles.toFixed(0));
            } else {
                $('#articles_cell').html('');
            }

            if (valoration_total > 0) {
                $('#valoration_cell').html(Number(valoration_total.toFixed(2)).toLocaleString(undefined, {minimumFractionDigits: 2})+" €");
            } else {
                $('#valoration_cell').html('');
            }

            var info = tab.page.info();

            $('#orders_founded').html('<h6 class="panel-title" style="margin-bottom: 0px;">'+ info.recordsDisplay +' PEDIDOS ENCONTRADOS</h6><span id="dataTable_info"></span>');
        });



        //SEARCHING BY ALIAS
        $('#searchOrderForm_article').typeahead({
            highlight: true,
            minLength: 1
        },{
            name: 'alias',
            display: function(value) {
                return value.alias + ' - ' +value.brand + ' - ' + value.model + ' - ' + value.color
            },
            source: function (query,sync, async) {

                $.get(Routing.generate('ajax_alias_suggestions', {'text': query}), function (data) {
                    async(data);
                })
            }
        }).bind("typeahead:select",function(e,data){

            $("#searchSaleForm_article").typeahead('val',data.alias);

        }).bind("typeahead:autocomplete",function(e,data){
            if(e.keyCode === 9) return false;
        });

    </script>
{% endblock %}