{% extends '@Core/base.html.twig' %}
{% block sectionTitle %}Listado de operaciones ventas{% endblock %}
{% block sectionActions %}
    <a class="double_click_disabled btn bg-color5 btn-rounded heading-btn" href="{{ path('sales_detail') }}"><i class="icon-plus2 position-left"></i>Nueva venta</a>
{% endblock %}

{% block breadcrumbLinks %}
    <li><a class="" href="{{ path('sales_menu') }}">Punto de venta</a></li>
    <li class="active">Listado operaciones de ventas</li>
{% endblock %}

{% block javascript %}
    {{ parent() }}
    <script src="{{ asset('assets/js/orderarticle8.js?') }}?v={{ "now"|date("d-m-Y") }}"></script>
    <script src="{{ asset('assets/js/core.sale.searchcriteria.js') }}?v={{ "now"|date("d-m-Y") }}"></script>
{% endblock %}


{% block content %}

    <div class="panel-body" style="padding-bottom: 0px !important;">

        {% for flash_message in app.session.flashBag.get('danger') %}
            <div class="alert alert-danger alert-styled-left">
                <span class="text-semibold">{{ flash_message | raw }}</span>
            </div>
        {% endfor %}

        {% include '@Core/Sales/sales_searcher_header.html.twig' %}

    </div>

    <div class="row" style="margin-bottom: 20px;padding-right: 10px">
        <!-- BUTTONS -->
        <div class="col-md-12 pull-right text-right">
            <div class="col-xs-2 pull-right">
                <button type="button" class="btn bg-pink-300 btn-block btn-float btn-float-lg"
                        onclick="getExcelSales()">
                    <i class="icon-file-excel position-left button_label_cc_icon_horizontal"></i>
                    <div class="button_label_cc_text">
                        LISTADO EXCEL <BR> VENTAS PICKING
                    </div>
                </button>
            </div>

        </div>
        <!-- BUTTONS -->
    </div>

    <div class="panel-body" style="padding-top: 0px !important;">
        <div class="panel panel-flat">

        <div class="panel-heading">
            <h6 class="panel-title" style="margin-bottom: 0px;">LISTADO DE OPERACIONES</h6>
        </div>

        <div class="panel-body">


            <div id="DataTables_Table_0_wrapper" class="dataTables_wrapper no-footer">
                <div class="table-responsive">

                    <table class="table no-footer" id="DataTables_Table_0" role="grid"
                           aria-describedby="DataTables_Table_0_info">

                        <thead>
                            <tr role="row" style="text-align: center">
                                <th data-orderable="false" class="hidecolum">&nbsp;&nbsp;
                                    <input type="checkbox" onchange="checkAllSsales(this)" name="chk[]" />
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Fecha inicio
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Fecha completado
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Cod.Venta
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Fac. Simplificada
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Fac. Nominativa
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Vendedor
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Tienda
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" id="items_sum">
                                    Und. Vendidas
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    F.Pago cliente
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" id="discount_sum">
                                    Descuento
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" id="total_sale_sum">
                                    Total venta
                                </th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" id="total_income_sum">
                                    Total ingreso
                                </th>
                                <th>Stock en devolución</th>
                                <th class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    Estado
                                </th>
                                <th class="col-sm-1 text-center sorting_disabled" rowspan="1" colspan="1"
                                    aria-label="Actions">Acceder
                                </th>

                            </tr>
                        </thead>

                        <tbody>

                        {% for obj in sales %}

                            {% set canViewTheRow = false %}

                            {% if not roleRight and obj.shopId == shopInSession %}
                                {% set canViewTheRow = true %}
                            {% else %}
                                {% if (roleRight or isRightSaleListInShops) %}
                                    {% set canViewTheRow = true %}
                                {% endif %}
                            {% endif %}

                            {% if canViewTheRow %}
                                <tr role="row" class="odd"  onclick="{{ path('sales_edit', {"id" : obj.id}) }}">
                                    <td><input type="checkbox" name="saleIdRow" id="saleIdRow" value="{{ obj.id }}" style="margin-left: 5px;"></td>
                                    <td align="center"><span class='hide_dataTable_dates'>{{ obj.createdAt | date('Y-m-d') }}</span>{{ obj.createdAt | date('d/m/Y H:i:s') }}</td>
                                    <td align="center">
                                        {% if obj.completionDate is not null %}
                                        {{ obj.completionDate | date('d/m/Y H:i:s') }}
                                        {% else %}
                                        ---
                                        {% endif %}
                                    </td>
                                    <td>{{ obj.alias }}</td>
                                    <td>{{ obj.invoice_number_auto }}</td>
                                    <td>{{ obj.invoice_number }}</td>
                                    <td>
                                        {% if obj.userId %}
                                        {{ obj.userName }}
                                        {% else %}
                                        ---
                                        {% endif %}
                                    </td>
                                    <td align="center">{{ obj.shopName }}</td>
                                    <td align="center">
                                        {{ obj.soldUnits - obj.returnedUnits }}
                                    </td>
                                    <td align="center">
{#                                        {{ render(controller('CoreBundle:SalesPoint:getPaymentMethodsFromSale', { 'sale' : obj.id })) }}#}
                                        {{  obj.salePaymentCustomer|split(',')|sale_payment_synthetic(obj.salePaymentShop|split(',')) }}
                                    </td>
                                    <td class="discount" align="center">{{ obj.totalDiscount | number_format(2, '.', ',') }}</td>

                                    {% if obj.typeStatusSaleId == constant('CoreBundle\\Entity\\TypeStatusSale::ID_STATUS_TO_IN_RESERVED') or obj.typeStatusSaleId == constant('CoreBundle\\Entity\\TypeStatusSale::ID_STATUS_TO_IN_RESERVED_CANCELED') %}
                                        <td class="total" align="center">0.00</td>
                                    {% else %}
                                        <td class="total" align="center">
                                            {{ obj.totalFinal }}
                                        </td>
                                    {% endif %}

                                    <td class="totalIncome" align="center">
                                        {{ obj.totalIncome }}
                                    </td>
                                    <td align="center">
                                        {% if obj.returnedUnits > 0 %}
                                            <span class="label bg-danger" title="Devolución">
                                                <i class="icon-minus-circle2 p-5"></i>
                                            </span>
                                            Devolución
                                        {% endif %}
                                    </td>

                                    <td>
                                        {% if obj.notesInternal != "" %}
                                            <div style="text-align: center; margin:5px;">
                                                <i class="icon-comments" title="{{ obj.notesInternal }}"></i>
                                            </div>
                                        {% endif %}
                                        {% if obj.notes != "" %}
                                            <div style="text-align: center; margin:5px;">
                                                <i class="icon-warning" title="Venta con obsevaciones."></i>
                                            </div>
                                        {% endif %}


                                            {% set color = 'grey' %}
                                            {% if obj.typeStatusSaleId == '1' %}
                                                {% set color = 'green' %}
                                            {% elseif obj.typeStatusSaleId == '4' %}
                                                {% set color = 'yellow' %}
                                            {% elseif obj.typeStatusSaleId == '5' %}
                                                {% set color = 'yellow' %}
                                            {% elseif obj.typeStatusSaleId == '6' %}
                                                {% set color = 'orange' %}
                                            {% elseif obj.typeStatusSaleId == '10' %}
                                                {% set color = 'grey' %}
                                            {% elseif obj.typeStatusSaleId == '11' %}
                                                {% set color = 'grey' %}
                                            {% elseif obj.typeStatusSaleId == '20' %}
                                                {% set color = 'info' %}
                                            {% else %}
                                                {% set color = 'grey' %}
                                            {% endif %}

                                            <span class="label bg-{{ color }}">
                                                {{ obj.typeStatusSaleName }}
                                            </span>

                                        {% if obj.isInvoiced == true %}
                                            <span class="label label-flat label-rounded border-success text-success-600" style="margin-top: 5px;margin-bottom: 5px;">Facturado</span>
                                        {% endif %}
                                    </td>

                                    <td class="text-center">
                                        <a type="button" href="{{ path('sales_edit', {"id" : obj.id}) }}" class="text-color3 btn btn-flat text-color3 border-color3 btn-rounded"><i class="glyphicon glyphicon-arrow-right position-left" style="    margin-right: 0px;"></i></a>
                                    </td>
                                </tr>
                            {% endif %}

                        {% endfor %}

                        </tbody>

                        <tfoot>
                            <tr role="row">
                                <td class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                    <strong>TOTALES</strong>
                                </td>
                                <td class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="7">

                                </td>
                                <td class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" id="item_cell" align="center">

                                </td>
                                <td class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1">
                                </td>
                                <td class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" id="discount_cell" align="center">

                                </td>
                                <td class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" id="total_sale_cell" align="center">

                                </td>
                                <td class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="1" id="total_income_cell" align="center">

                                </td>
                                <td class="sorting" tabindex="0" aria-controls="DataTables_Table_0" rowspan="1" colspan="3">

                                </td>
                            </tr>
                        </tfoot>


                    </table>
                </div>

            </div>
        </div>

    </div>
    </div>

{% endblock %}

{% block script %}

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

        //-DISABLE DOUBLE CLICK ON BUTTONS AND HREF
        $(".double_click_disabled").one("click", function() {
            $(this).click(function () { return false; });
        });

        {% if sales | length > 0 %}
            jQuery.fn.dataTable.Api.register( 'sum()', function () {
                return this.flatten().reduce( function ( a, b ) {
                    return (a*1) + (b*1);
                });
            });
        {% endif %}

        $(document).ready(function(){
            var buttonCommon = {
                exportOptions: {
                    format: {
                        body: function ( data, row, column ) {
                            if(data.includes("hide_dataTable_dates")){
                                data = data.replace(/<[^]*>/g, "");
                            } else {
                                data = data.replace(/<[^>]*>/g, "");
                            }
                            return $.trim(data);
                        }
                    }
                }
            };

            var table = $('#DataTables_Table_0').DataTable({
                dom: 'lBfrtip',
                lengthMenu: [
                    [ 10, 25, 50, 100, -1 ],
                    [ '10', '25', '50', '100', 'Todos' ]
                ],
                buttons: [
                    $.extend( true, {}, buttonCommon, {
                        extend: 'csv',
                        footer: true,
                        exportOptions: {
                            columns: [0,1,2,3,4,5,6,7,8,9,11]
                        },
                    } ),
                    $.extend( true, {}, buttonCommon, {
                        extend: 'excel',
                        footer: true,
                        exportOptions: {
                            columns: [0,1,2,3,4,5,6,7,8,9,11]
                        },
                    } )
                ],
                order: [[1, 'desc']]
            });

            {% if sales | length > 0 %}
                getTotalSale(table);
                getTotalDiscount(table);
                getTotalUnits(table);
                getTotalIncome(table);
            {% endif %}

            orderarticle.getArticleSuggestions();
        });

        $(document).on({
            mouseenter: function () {
                trIndex = $(this).index()+1;
                $("table.dataTable").each(function(index) {
                    $(this).find("tr:eq("+trIndex+")").addClass("hover")
                });
            },
            mouseleave: function () {
                trIndex = $(this).index()+1;
                $("table.dataTable").each(function(index) {
                    $(this).find("tr:eq("+trIndex+")").removeClass("hover")
                });
            }
        }, ".dataTables_wrapper tr");

        //if filter changes calculate total of new rows
        {% if sales | length > 0 %}
            $('#DataTables_Table_0').on( 'search.dt', function () {
                var tab = $('#DataTables_Table_0').DataTable();

                var units = tab.column( 8, {"filter": "applied"} ).data().sum();
                var total = tab.column( 11, {"filter": "applied"} ).data().sum();
                var discounts = tab.column( 10, {"filter": "applied"} ).data().sum();
                var income = tab.column( 12, {"filter": "applied"} ).data().sum();

                $('#item_cell').html('<strong>' + units + '</strong>');
                $('#total_sale_cell').html('<strong>' + parseFloat(total).toFixed(2) + '</strong>');
                $('#discount_cell').html('<strong>' + parseFloat(discounts).toFixed(2) + '</strong>');
                $('#total_income_cell').html('<strong>' + parseFloat(income).toFixed(2) + '</strong>');

                $('#hidden_item_cell').html('<strong>' + units + '</strong>');
                $('#hidden_total_sale_cell').html('<strong>' + parseFloat(total).toFixed(2) + '</strong>');
                $('#hidden_discount_cell').html('<strong>' + parseFloat(discounts).toFixed(2) + '</strong>');
                $('#hidden_total_income_cell').html('<strong>' + parseFloat(income).toFixed(2) + '</strong>');
            });
        {% endif %}

        function getTotalSale(table){
            table.columns('#total_sale_sum').every(function () {
                var sum = this.data().reduce(function (a,b) {
                    return parseFloat(a) + parseFloat(b);
                }, 0);
                $('#total_sale_cell').html('<strong>' + sum.toFixed(2) + '</strong>');
                $('#hidden_total_sale_cell').html('<strong>' + sum.toFixed(2) + '</strong>');
            });
        }

        function getTotalDiscount(table){
            table.columns('#discount_sum').every(function () {
                var sum = this.data().reduce(function (a,b) {
                    return parseFloat(a) + parseFloat(b);
                }, 0);
                $('#discount_cell').html('<strong>' + sum.toFixed(2) + '</strong>');
                $('#hidden_discount_cell').html('<strong>' + sum.toFixed(2) + '</strong>');
            });
        }

        function getTotalUnits(table){
            table.columns('#items_sum').every(function () {
                var sum = this.data().reduce(function (a,b) {
                    return parseFloat(a) + parseFloat(b);
                }, 0);
                $('#item_cell').html('<strong>' + sum.toFixed(0) + '</strong>');
                $('#hidden_item_cell').html('<strong>' + sum.toFixed(0) + '</strong>');
            });
        }

        function getTotalIncome(table){
            table.columns('#total_income_sum').every(function () {
                var sum = this.data().reduce(function (a,b) {
                    return parseFloat(a) + parseFloat(b);
                }, 0);
                $('#total_income_cell').html('<strong>' + sum.toFixed(2) + '</strong>');
                $('#hidden_total_income_cell').html('<strong>' + sum.toFixed(2) + '</strong>');
            });
        }

        // EXCEL SALES
        function getExcelSales() {

            //COLLECTING WEBORDERS
            var data = { 'saleId' : [] };
            $("input[id=saleIdRow]:checked").each(function() {
                data['saleId'].push($(this).val());
            });

            //CHECK WEBORDER IS SELECTED
            if (data['saleId'].length === 0) {
                new PNotify({
                    text: "Debe seleccionar al menos alguna operación para generar el fichero de picking.",
                    type: "warning"
                });
                return ;
            }

            $.ajax({
                type: "POST",
                url: " {{path('generate-excel-for-sales-picking')}}",
                data: {list:data},
                success: function(result) {
                    window.open(
                        result,
                        '_blank' // <- This is what makes it open in a new window.
                    );
                    return true;
                },
                error: function(err) {
                    console.log(err.responseText);
                    new PNotify({
                        text: "Error generando el fichero de picking.",
                        type: "error"
                    });
                }
            });

        }

        //CHECK SALES
        function checkAllSsales(ele) {
            var checkboxes = $('#DataTables_Table_0_wrapper input');
            if (ele.checked) {
                for (var i = 0; i < checkboxes.length; i++) {
                    if (checkboxes[i].type == 'checkbox') {
                        checkboxes[i].checked = true;
                    }
                }
            } else {
                for (var i = 0; i < checkboxes.length; i++) {
                    if (checkboxes[i].type == 'checkbox') {
                        checkboxes[i].checked = false;
                    }
                }
            }
        }

    </script>
{% endblock %}