{% extends '@Core/base.html.twig' %}
{% block sectionTitle %}Pedidos{% endblock %}
{% block sectionActions %}
    {% if roleRight == true or isShopManager or isOffice %}
        <a class="btn bg-color5 btn-rounded heading-btn" href="{{ path('order_new') }}"><i class="icon-plus2 position-left"></i>Nuevo pedido</a>
    {% endif %}
{% endblock %}
{% block breadcrumbLinks %}
    <li><a class="" href="{{ path('orders_menu') }}">Menú de pedidos</a></li>
    <li class="active">Pedidos</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/Orders/_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 ENCONTRADOS</h6>
                    <span id="dataTable_info"></span>
                </div>

                <div class="panel-body">

                    <div id="DataTables_Table_0_wrapper" class="dataTables_wrapper no-footer">
                    <div class="datatable-scroll table-responsive">
                        <table class="table no-footer" id="DataTables_Table_0" role="grid" aria-describedby="DataTables_Table_0_info">

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

                                </th>

                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    COD-Pedido
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Creación
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Servicio
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Proveedor
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Temporada
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Tipo
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Estado
                                </th>
                                <th class="col-sm-1 text-center" id="received_sum">RECIBIDO</th>
                                <th class="col-sm-1 text-center" id="pending_sum">PENDIENTE</th>
                                <th class="col-sm-1 text-center" id="orders_items_sum">PEDIDO</th>
                                <th class="col-sm-1 text-center" id="articles_sum">ARTÍCULOS</th>

                                {% if roleRight == true or isShopManager or isOffice %}
                                    <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[0].dealer.getWebPath() is not null %}
                                        <td><img class="gallery-item" data-src="{{obj[0].dealer.getWebPath() | imagine_filter('list')}}"/></td>
                                    {% else %}
                                        <td></td>
                                    {% endif %}
                                    {% if roleRight == true or isShopManager or isOffice %}
                                        <td><a href="{{ path('order_edit', {"id" : obj[0].id}) }}">{{ obj[0].alias }}</a></td>
                                    {%  else %}
                                        <td>{{ obj[0].alias }}</td>
                                    {% endif %}
                                    <td data-sort="{{ obj[0].createdAt | date('YmdHis') }}">{{ obj[0].createdAt | date('d-m-Y \\a \\l\\a\\s H:i:s') }}</td>

                                    {% set uniqueDateServiceExpected = obj[0].uniqueDateServiceExpected %}
                                    {% if uniqueDateServiceExpected is defined and uniqueDateServiceExpected %}
                                        <td data-sort="{{ uniqueDateServiceExpected | date('YmdHis') }}" align="center">{{ uniqueDateServiceExpected | date('d-m-Y') }}</td>
                                    {% elseif uniqueDateServiceExpected is null %}
                                        <td align="center"></td>
                                    {% else %}
                                        <td align="center"></td>
                                    {% endif %}

                                    <td>{{ obj[0].dealer.name }}</td>
                                    <td>{{ obj[0].season }}</td>
                                    <td>{% if  obj[0].typeOrder %}
                                            <span class="label bg-status-border">{{ obj[0].typeOrder.description }}</span>
                                        {% endif %}
                                    </td>


                                    <td>
                                        {% if obj['threadOrderGenerateCount'] > 0 %}
                                        <div>
                                            <span class="text-semibold"> <i class="icon-sync spinner mr-2"></i> Actualizando</span>
                                        </div>
                                        {% endif %}
                                        {% include("@Core/Widget/include_order_type_status.html.twig") %}
                                    </td>


                                    {% if obj[0].numStockAvailable > 0 %}
                                        {% if obj[0].numStockAvailable == obj['all_stock'] %}
                                            <td align="center">
                                            {% if isLite == false %}
                                                {% if roleRight == true %}
                                                    <button type="button"
                                                            class="btn bg-green btn-rounded show-stock"
                                                            data-target="#modal_full"
                                                            data-toggle="modal"
                                                            data-order="{{ obj[0].id }}"
                                                            data-status="{{ constant('CoreBundle\\Entity\\TypeStatusStock::ID_STATUS_PENDING_RECEIPT') }}"
                                                            data-compare="higher"
                                                            style="margin: auto; display: block;  min-width: 35px;">{{ obj[0].numStockAvailable }}
                                                    </button>
                                                {% else %}
                                                    <button type="button"
                                                            class="btn bg-green btn-rounded show-stock"
                                                            data-order="{{ obj[0].id }}"
                                                            data-status="{{ constant('CoreBundle\\Entity\\TypeStatusStock::ID_STATUS_PENDING_RECEIPT') }}"
                                                            data-compare="equals"
                                                            style="margin: auto; display: block;  min-width: 35px;">{{ obj[0].numStockAvailable }}
                                                    </button>
                                                {% endif %}
                                            {% else %}
                                                {% if roleRight == true %}
                                                    <button type="button"
                                                            class="btn bg-green btn-rounded show-stock"
                                                            data-target="#modal_full"
                                                            data-toggle="modal"
                                                            data-order="{{ obj[0].id }}"
                                                            data-status="{{ constant('CoreBundle\\Entity\\TypeStatusStock::ID_STATUS_RECEPTION_DONE') }}"
                                                            data-compare="equals"
                                                            style="margin: auto; display: block;  min-width: 35px;">{{ obj[0].numStockAvailable }}
                                                    </button>
                                                {% else %}
                                                    <button type="button"
                                                            class="btn bg-green btn-rounded show-stock"
                                                            data-order="{{ obj[0].id }}"
                                                            data-status="{{ constant('CoreBundle\\Entity\\TypeStatusStock::ID_STATUS_RECEPTION_DONE') }}"
                                                            data-compare="equals"
                                                            style="margin: auto; display: block;  min-width: 35px;">{{ obj[0].numStockAvailable }}
                                                    </button>
                                                {% endif %}
                                            {% endif %}
                                            </td>
                                        {% else %}
                                            <td align="center">
                                            {% if roleRight == true %}
                                                <button type="button" class="btn border-green text-green btn-flat btn-rounded btn-icon btn-xs show-stock"
                                                        data-target="#modal_full"
                                                        data-toggle="modal"
                                                        data-order="{{ obj[0].id }}"
                                                        data-status="{{ constant('CoreBundle\\Entity\\TypeStatusStock::ID_STATUS_PENDING_RECEIPT') }}"
                                                        data-compare="higher"
                                                        style="margin: auto; display: block;  min-width: 35px;">{{ obj[0].numStockAvailable }}
                                                </button>
                                            {% else %}
                                                <button type="button" class="btn border-green text-green btn-flat btn-rounded btn-icon btn-xs show-stock"
                                                        data-order="{{ obj[0].id }}"
                                                        data-status="{{ constant('CoreBundle\\Entity\\TypeStatusStock::ID_STATUS_PENDING_RECEIPT') }}"
                                                        style="margin: auto; display: block;  min-width: 35px;">{{ obj[0].numStockAvailable }}
                                                </button>
                                            {% endif %}
                                            </td>
                                        {% endif %}
                                    {% else %}
                                        <td></td>
                                    {% endif %}
                                    {% if obj[0].numStockPending > 0 %}
                                        <td>
                                            {% if roleRight == true %}
                                            <button type="button" class="btn bg-orange btn-rounded show-stock"
                                                    data-target="#modal_full"
                                                    data-toggle="modal"
                                                    data-order="{{ obj[0].id }}"
                                                    data-status="{{ constant('CoreBundle\\Entity\\TypeStatusStock::ID_STATUS_AVAILABLE') }}"
                                                    data-compare="minor"
                                                    style="margin: auto; display: block;  min-width: 35px;">{{ obj[0].numStockPending }}
                                            </button>
                                            {% else %}
                                            <button type="button" class="btn bg-orange btn-rounded show-stock"
                                                    data-order="{{ obj[0].id }}"
                                                    data-status="{{ constant('CoreBundle\\Entity\\TypeStatusStock::ID_STATUS_AVAILABLE') }}"
                                                    style="margin: auto; display: block;  min-width: 35px;">{{ obj[0].numStockPending }}
                                            </button>
                                            {% endif %}
                                        </td>
                                    {% else %}
                                        <td></td>
                                    {% endif %}
                                    {% if obj['all_stock'] > 0 %}
                                        <td align="center">
                                            {% if roleRight == true %}
                                            <button type="button" class="btn border-grey-800 text-grey-800 btn-flat btn-rounded btn-icon btn-xs show-stock"
                                                    data-target="#modal_full"
                                                    data-toggle="modal"
                                                    data-order="{{ obj[0].id }}"
                                                    data-status="0"
                                                    data-compare="higher"
                                                    style="margin: auto; display: block; min-width: 35px;">{{ obj['all_stock'] }}
                                            </button>
                                            {% else %}
                                            <button type="button" class="btn border-grey-800 text-grey-800 btn-flat btn-rounded btn-icon btn-xs show-stock"
                                                    data-order="{{ obj[0].id }}"
                                                    style="margin: auto; display: block; min-width: 35px;">{{ obj['all_stock'] }}
                                            </button>
                                            {% endif %}
                                        </td>
                                    {% else %}
                                        <td></td>
                                    {% endif %}

                                    {% if obj[0].numArticles > 0 %}
                                        <td style="text-align: center">{{ obj[0].numArticles }}</td>
                                    {% else %}
                                        <td></td>
                                    {% endif %}

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

                                </tr>

                            {% endfor %}

                            </tbody>

                            <tfoot>
                                <tr role="row">
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="7"></th>
                                    <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1">
                                        <strong>TOTALES</strong>
                                    </th>
                                    <th class="col-sm-1" id="received_cell" align="center"></th>
                                    <th class="col-sm-1" id="pending_cell"></th>
                                    <th class="col-sm-1" id="orders_items_cell"></th>
                                    <th class="col-sm-1" id="articles_cell" style="text-align: center"></th>
                                    {% if roleRight == true or isShopManager or isOffice %}
                                        <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 type="text/javascript" src="{{ asset('assets/js/articleStock.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').DataTable({
                retrieve: true,
                dom: 'lBfrtip',
                buttons: [
                    {
                        extend: 'print',
                        text: 'Imprimir',
                        footer: true,
                        exportOptions: {
                            stripHtml : true,
                            columns: ':not(.notexportbtn)'
                        }
                    },
                    {
                        extend: 'csv',
                        exportOptions: {
                            columns: ':not(.notexport)'
                        }
                    },
                    {
                        extend: 'excel',
                        exportOptions: {
                            columns: ':not(.notexport)'
                        }
                    }

                ],
                drawCallback: function(){
                    loadImagesIntoTable();
                }
            }).order([2, 'desc']).draw();

            getTotalReceived(table);
            getTotalPending(table);
            getTotalOrdered(table);
            getTotalArticles(table);
            {% if roleRight == true or isShopManager or isOffice %}
                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 getTotalReceived(table){
            table.columns('#received_sum').every(function () {

                var sum = getSum(this);

                if(sum > 0) {
                    $('#received_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">' + sum.toFixed(0) + '</div>');
                } else {
                    $('#received_cell').html('<div style="border-radius: 50%; width: 35px; height: 35px; text-align: center; vertical-align: middle; line-height: 35px; margin: auto" class="border-green text-green">' + sum.toFixed(0) + '</div>');
                }

            });
        }

        function getTotalPending(table){
            table.columns('#pending_sum').every(function () {

                var sum = getSum(this);

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

            });
        }

        function getTotalOrdered(table) {
            table.columns('#orders_items_sum').every(function () {

                var sum = getSum(this);

                if(sum > 0) {
                    $('#orders_items_cell').html('<div style="border-radius: 50%; width: 35px; height: 35px; text-align: center; vertical-align: middle; line-height: 35px; margin: auto; border-style: solid; border-width: 1px; border-color: #444444" class="border-grey-800 text-grey-800">' + sum.toFixed(0) + '</div>');
                }

            });
        }

        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').on( 'search.dt', function () {
            var tab = $('#DataTables_Table_0').DataTable();

            var received = tab.column(8, {"filter": "applied"}).data().sum();
            var pending = tab.column(9, {"filter": "applied"}).data().sum();
            var ordered = tab.column(10, {"filter": "applied"}).data().sum();
            var articles = tab.column(11, {"filter": "applied"}).data().sum();
            var valoration_total = tab.column(12, {"filter": "applied"}).data().sum();

            if (received > 0) {
                $('#received_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">' + received.toFixed(0) + '</div>');
            } else {
                $('#received_cell').html('');
            }

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

            if (ordered > 0) {
                $('#orders_items_cell').html('<div style="border-radius: 50%; width: 35px; height: 35px; text-align: center; vertical-align: middle; line-height: 35px; margin: auto; border-style: solid; border-width: 1px; border-color: #444444" class="border-grey-800 text-grey-800">' + ordered.toFixed(0) + '</div>');
            } else {
                $('#orders_items_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>');
        });

        $('#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 %}