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

{% block content %}
    <div class="block-header">
        <h2>
            {% if (salesStepType == constant('nordmind\\AdminBundle\\Entity\\SalesStep::STEP_SUCCESS')) %}
                Wygrane
            {% elseif(salesStepType == constant('nordmind\\AdminBundle\\Entity\\SalesStep::STEP_FAILURE')) %}
                Przegrane
            {% else %}
                Sprzedaż
            {% endif %}
        </h2>
    </div>
    <div class="row clearfix">
        <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
            <div class="card">
                <!--<div class="header">
                    <h3 class="card-inside-title">Filtry</h3>
                    <div class="row clearfix">
                        <div class="col-sm-3">
                            <div class="form-group">
                                <div class="form-line">
                                    <input type="text" name="date-from" id="date-from" class="form-control datepicker" placeholder="Data od" autocomplete="off" />
                                </div>
                            </div>
                        </div>
                        <div class="col-sm-3">
                            <div class="form-group">
                                <div class="form-line">
                                    <input type="text" name="date-to" id="date-to" class="form-control datepicker" placeholder="Data do" autocomplete="off" />
                                </div>
                            </div>
                        </div>
                        <div class="col-sm-3">
                            <div class="form-group">
                                <div class="form-line">
                                    <input type="text" name="price-from" id="price-from" class="form-control" placeholder="Kwota od" />
                                </div>
                            </div>
                        </div>
                        <div class="col-sm-3">
                            <div class="form-group">
                                <div class="form-line">
                                    <input type="text" name="price-to" id="price-to" class="form-control" placeholder="Kwota do" />
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="row clearfix">
                        <div class="col-sm-6">
                            <div class="form-group">
                                <div class="form-line">
                                    <select id="search-contacts" class="form-control show-tick selectpicker" multiple title="Klient" data-live-search="true">
                {% for contact in contacts %}
                    <option value="{{contact.getFullName}}">{{contact}}</option>
                {% endfor %}
            </select>   
        </div>
    </div>
</div>
<div class="col-sm-6">
    <div class="form-group">
        <div class="form-line">
            <select id="search-users" class="form-control show-tick selectpicker" multiple title="Pracownik" data-live-search="true">
                {% for user in users %}
                    <option value="{{user.getFullName}}">{{user}}</option>
                {% endfor %}
            </select>   
        </div>
    </div>
</div>
</div>
<div class="row clearfix">
<div class="col-sm-6">
    <div class="form-group">
        <div class="form-line">
            <select id="search-products" class="form-control show-tick selectpicker" multiple title="Produkt" data-live-search="true">
                {% for product in products %}
                    <option value="{{product}}">{{product}}</option>
                {% endfor %}
            </select>   
        </div>
    </div>
</div>
<div class="col-sm-6">
    <div class="form-group">
        <div class="form-line">
            <select id="search-processes" class="form-control show-tick selectpicker" multiple title="Proces" data-live-search="true">
                {% for process in processes %}
                    <option value="{{process}}">{{process}}</option>
                {% endfor %}
            </select>   
        </div>
    </div>
</div>
</div>
<ul class="header-dropdown m-r-0">
<li>
    <a href="{{path('nordmind_sale_add')}}" class="btn btn-primary"  data-toggle="modal" data-target="#mdModal">
        Nowa sprzedaż
    </a>
</li>
</ul>
</div>-->
                <div class="header">
                    <h3 class="card-inside-title">Filtry</h3>
                    {{ include ('nordmindAdminBundle:Default:searchForm.html.twig', {'url' : 'nordmind_sale_index'}) }}
                </div>
                <div class="body">
                    <div class="table-responsive">
                        <table id="sale-table" class="table table-bordered table-striped table-hover dataTable js-exportable">
                            <thead>
                                <tr>
                                    <th>Klient</th>
                                    <th>Produkt</th>
                                    <th>Kwota</th>
                                    <th>Data dodania</th>
                                    <th>Data finalizacji</th>
                                    <th>Współpracownik</th>
                                    <th>Proces</th>
                                    <th>Krok</th>
                                    <th>Typ produktu</th>
                                    <th>Opis klienta</th>
                                    <th>Opis sprzedaży</th>
                                    <th>Producent</th>
                                    <th>Data spotkania</th>
                                    <th>Data wygrania</th>
                                    <th>Opłacone</th>
                                    <th>Akcje</th>
                                </tr>
                            </thead>
                            <tfoot>
                                <tr>
                                    <th>Klient</th>
                                    <th>Produkt</th>
                                    <th>Kwota</th>
                                    <th>Data dodania</th>
                                    <th>Data finalizacji</th>
                                    <th>Współpracownik</th>
                                    <th>Proces</th>
                                    <th>Krok</th>

                                    <th>Typ produktu</th>
                                    <th>Opis klienta</th>
                                    <th>Opis sprzedaży</th>
                                    <th>Producent</th>
                                    <th>Data spotkania</th>
                                    <th>Data wygrania</th>
                                    <th>Opłacone</th>
                                    <th>Akcje</th>
                                </tr>
                            </tfoot>
                            <tbody>
                                {% for sale in sales %}
                                    <tr data-id="{{ sale.id }}"  class="{{ sale.deletedAt ? 'deleted-row' : '' }}">
                                        <td>
                                            <a href="{{ path('nordmind_sale_show', {id: sale.sale.id})}}"  data-toggle="modal" data-target="#mdModal">
                                            {{ sale.sale.contact }}
                                            </a>
                                            </td>
                                        <td>{{ sale.product }}</td>
                                        <td>{{ sale.price|number_format(2, '.', '') }}</td>
                                        <td>{{ sale.sale.createdAt|date('Y-m-d') }}</td>
                                        <td>{{ sale.sale.expectedDate|date('Y-m-d') }}</td>
                                        <td>{{ sale.sale.user }}</td>
                                        <td>{{ sale.sale.salesProcess }}</td>
                                        <td>{{ sale.sale.salesStep }}</td>
                                        <!-- to hide -->
                                        <td>{{ sale.product.productType }}</td>
                                        <td>{{ sale.sale.contact ? sale.sale.contact.description : '' }}</td>
                                        <td>{{ sale.sale.description }}</td>
                                        <td>{{ sale.product.productProducer }}</td>
                                        <td>{{ sale.sale.meetingDate|date('Y-m-d') }}</td>
                                        <td>{{ sale.sale.getWinningDate|date('Y-m-d') }}</td>
                                        <td>{{ sale.sale.isPaid ? 'Tak' : 'Nie' }}</td>
                                        <td>
                                            {% if not sale.deletedAt %}
                                                <a href="{{ path('nordmind_sale_edit', {'id': sale.sale.id}) }}"
                                                   data-toggle="modal" data-target="#mdModal">
                                                    <i class="material-icons">mode_edit</i>
                                                </a>
                                                <a href="{{ path('nordmind_sale_delete', {'id': sale.sale.id, 'callback': 'table'}) }}"
                                                   class="confirm-button" data-type="confirm">
                                                    <i class="material-icons">delete</i>
                                                </a>
                                            {% endif %}
                                        </td>

                                    </tr>
                                {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

{% endblock content %}
{% block javascript %}
    {{ parent() }}
    <script>
        $(function () {
            $.fn.dataTable.ext.search.push(
                    function (settings, data, dataIndex) {
                        var dateFrom = ($('#date-from').val());
                        if (dateFrom)
                        {
                            dateFrom = dateFrom.split('.');
                            dateFrom = dateFrom[2] + '-' + dateFrom[1] + '-' + dateFrom[0];
                        }
                        var dateTo = $('#date-to').val();
                        if (dateTo)
                        {
                            dateTo = dateTo.split('.');
                            dateTo = dateTo[2] + '-' + dateTo[1] + '-' + dateTo[0];
                        }
                        var expectedDate = data[4];
        {#                        expectedDate = expectedDate.split('.');
                                expectedDate = expectedDate[2] + '-' + expectedDate[1] + '-' + expectedDate[0];#}
        {#                        console.log(dateTo);
                                console.log(expectedDate);#}

                                                    if (
                                                            (!dateFrom ||
                                                                    (new Date(dateFrom).getTime() <= new Date(expectedDate).getTime())
                                                                    ) && (!dateTo ||
                                                            (new Date(dateTo).getTime() >= new Date(expectedDate).getTime())
                                                            )
                                                            )
                                                    {
                                                        return true;
                                                    }
                                                    return false;
                                                }
                                        );
                                        $.fn.dataTable.ext.search.push(
                                                function (settings, data, dataIndex) {
                                                    var priceFrom = parseFloat($('#price-from').val());
                                                    var priceTo = parseFloat($('#price-to').val());
                                                    var price = parseFloat(data[2]);
                                                    if (
                                                            (!priceFrom ||
                                                                    (priceFrom <= price)
                                                                    ) && (!priceTo ||
                                                            (priceTo >= price)
                                                            )
                                                            )
                                                    {
                                                        return true;
                                                    }
                                                    return false;
                                                }
                                        );
                                        $.fn.dataTable.ext.search.push(
                                                function (settings, data, dataIndex) {
                                                    var contacts = $('#search-contacts').val();
                                                    var contact = data[0];
                                                    if (!(contacts) ||
                                                            jQuery.inArray(contact, contacts) != -1
                                                            )
                                                    {
                                                        return true;
                                                    }
                                                    return false;
                                                }
                                        );
                                        $.fn.dataTable.ext.search.push(
                                                function (settings, data, dataIndex) {
                                                    var users = $('#search-users').val();
                                                    var user = data[5];
                                                    if (!(users) ||
                                                            jQuery.inArray(user, users) != -1
                                                            )
                                                    {
                                                        return true;
                                                    }
                                                    return false;
                                                }
                                        );
                                        /*Products*/
                                        $.fn.dataTable.ext.search.push(
                                                function (settings, data, dataIndex) {
                                                    var products = $('#search-products').val();
                                                    var product = data[1];
                                                    if (!(products) ||
                                                            jQuery.inArray(product, products) != -1
                                                            )
                                                    {
                                                        return true;
                                                    }
                                                    return false;
                                                }
                                        );
                                        /*Processes*/
                                        $.fn.dataTable.ext.search.push(
                                                function (settings, data, dataIndex) {
                                                    var processes = $('#search-processes').val();
                                                    var process = data[6];
                                                    if (!(processes) ||
                                                            jQuery.inArray(process, processes) != -1
                                                            )
                                                    {
                                                        return true;
                                                    }
                                                    return false;
                                                }
                                        );
                                        $(function () {
                                            //Exportable table
                                            var dataTable = $('#sale-table').DataTable({
                                                scrollX: true,
                                                dom: 'Bfrtip',
                                                responsive: true,
                                                buttons: [
                                                    'copyHtml5', 'pdf', 'print',
                                                    {
                                                        extend: 'csv',
                                                        exportOptions: {
                                                            columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]
                                                        }
                                                    },
                                                    {
                                                        extend: 'excel',
                                                        exportOptions: {
                                                            columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]
                                                        }
                                                    }
                                                ],
                                                colReorder: true,
                                                "language"
                                                        : {
                                                            "url"
                                                                    : "/js/plugins/jquery-datatable/extensions/Polish.lang.js"
                                                        }

                                            });
                                            //hide the first column
                                            //dataTable.column([9,10,11,12,13,14]).visible(false);

                                            dataTable.columns([8, 9, 10, 11, 12, 13]).visible(false, false);
                                            //dataTable.columns.adjust().draw(false);
                                            $("#date-from, #date-to").on("dp.change", function (e) {
                                                dataTable.draw();
                                            });
        {#                $('#date-from, #date-to').change(function () {
                            dataTable.draw();
                        });#}
                                    $('#price-from, #price-to').keyup(function () {
                                        dataTable.draw();
                                    });
                                    $('#search-contacts').change(function () {
                                        dataTable.draw();
                                    });
                                    $('#search-users').change(function () {
                                        dataTable.draw();
                                    });
                                    $('#search-products').change(function () {
                                        dataTable.draw();
                                    });
                                    $('#search-processes').change(function () {
                                        dataTable.draw();
                                    });
                                });
                            });
    </script>
{% endblock %}