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

{% block content %}
    <div class="block-header">
        <h2>Największe przegrane szanse sprzedaży</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">
                    <div class="row clearfix">
                        <div class="col-sm-4">
                            <div class="form-group">
                                <div class="form-line">
                                    <select id="search-users" name="search-users[]" class="form-control show-tick selectpicker" multiple title="Pracownik" data-live-search="true">
                                        {% for user in users %}
                                            <option value="{{user}}">{{user}}</option>
                                        {% endfor %}
                                    </select>   
                                </div>
                            </div>
                        </div>
                        <div class="col-sm-4">
                            <div class="form-group">
                                <div class="form-line">
                                    <select id="search-products" name="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-4">
                            <div class="form-group">
                                <div class="form-line">
                                    <select id="search-steps" name="search-steps[]" class="form-control show-tick selectpicker" multiple title="Krok" data-live-search="true">
                                        {% for step in steps %}
                                            <option value="{{step}}">{{step}}</option>
                                        {% endfor %}
                                    </select>   
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="body">
                    <div class="table-responsive">
                        <table id="contact-table" class="table table-bordered table-striped table-hover dataTable js-exportable">
                            <thead>
                                <tr>
                                    <th>Szansa sprzedaży</th>
                                    <th>Suma z kwot</th>
                                    <th>Pracownik</th>
                                    <th>Produkt</th>
                                    <th>Krok</th>
                                </tr>
                            </thead>
                            <tfoot>
                                <tr>
                                    <th>Szansa sprzedaży</th>
                                    <th>Suma z kwot</th>
                                    <th>Pracownik</th>
                                    <th>Produkt</th>
                                    <th>Krok</th>
                                </tr>
                            </tfoot>
                            <tbody>
                                {% for sale in sales %}
                                    <tr data-id="{{ sale.id }}" class="{{ sale.deletedAt ? 'deleted-row' : '' }}">
                                        <td>{{ sale.sale.contact }}</td>
                                        <td>{{ sale.price|number_format(2, '.', ',') }}</td>
                                        <td>{{ sale.sale.user }}</td>
                                        <td>{{ sale.product }}</td>
                                        <td>{{ sale.sale.salesStep }}</td>
                                    </tr>
                                {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

{% endblock content %}
{% block javascript %}
    {{ parent() }}
    <script type="text/javascript">
        $(function () {
            //Exportable table
            var dataTable = $('#contact-table').DataTable({
                //scrollX: true,
                dom: 'Bfrtip',
                order : [[ 1, "desc" ]],
                responsive: true,
                pageLength: 500000,
                buttons: [
                    'copyHtml5', 'csv', 'excel', 'pdf', 'print'
                ],
                colReorder: true,
                "language": {
                    "url": "/js/plugins/jquery-datatable/extensions/Polish.lang.js"
                },
                "columns": [
                    {"type": "html"},
                    {"type": "num-fmt"},
                    null,
                    null,
                    null
                ]

            });

            $.fn.dataTable.ext.search.push(
                    function (settings, data, dataIndex) {
                        var users = $('#search-users').val();
                        var user = data[2];
                        if (!(users) ||
                                jQuery.inArray(user, users) != -1
                                )
                        {
                            return true;
                        }
                        return false;
                    }
            );

            $('#search-users').change(function () {
                dataTable.draw();
            });

            $.fn.dataTable.ext.search.push(
                    function (settings, data, dataIndex) {
                        var products = $('#search-products').val();
                        var product = data[3];
                        if (!(products) ||
                                jQuery.inArray(product, products) != -1
                                )
                        {
                            return true;
                        }
                        return false;
                    }
            );

            $('#search-products').change(function () {
                dataTable.draw();
            });

            $.fn.dataTable.ext.search.push(
                    function (settings, data, dataIndex) {
                        var steps = $('#search-steps').val();
                        var step = data[4];
                        if (!(steps) ||
                                jQuery.inArray(step, steps) != -1
                                )
                        {
                            return true;
                        }
                        return false;
                    }
            );

            $('#search-steps').change(function () {
                dataTable.draw();
            });
        });
    </script>
{% endblock %}