{% extends 'Common/baseAdminPannel.html.twig' %}

    {% block title %}
        Reporte de productividad
    {% endblock %}


    {% block body %}

        {{ form_start(filterForm, {'attr':{'data-remote':'true', 'data-method':'GET', 'data-url':filterForm.vars.action, 'data-replacecontent':'true' }}) }}
        <div class="col-md-2">
            {{ form_row(filterForm.elaborationRange) }}
        </div>
        <div class="col-md-2">
            {{ form_row(filterForm.creationDateRange) }}
        </div>
        <div class="col-md-2">
            {{ form_row(filterForm.assignationRange) }}
        </div>
        <div class="col-md-2">
            {{ form_row(filterForm.meetingRange) }}
        </div>
        <div class="col-md-2">
            {{ form_row(filterForm.campaign) }}
        </div>
        <div class="col-md-2">
            {{ form_row(filterForm.office) }}
        </div>

        <div class="clearfix"></div>
        <button class="btn-success btn" type="submit">Filtrar</button>
        {{ form_end(filterForm) }}


        {% if app.user.hasOnerole(["ROLE_TLMKT_SUPERVISOR","ROLE_TLMKT_OPC", "ROLE_TLMKT_PROMOTION_MANAGER"])%}
            {% if reportOpc %}
                <h2>Productividad de OPCs</h2>
                <div style="display: inline-block;position: static; box-sizing: content-box;padding: 50px">
                    <div id="opc-productivity-report" style="height: 400px; width: 700px"></div>
                </div>
                <script>
                    window.reports.barChart("opc-productivity-report", {{ reportOpc.graph|json_encode|raw }});
                </script>

                <table class="table table-hover" data-height="500" data-toggle="table" data-search="true" data-show-columns="true">
                    <thead>
                    <tr>
                        <th data-sortable="true">OPC</th>
                        <th data-sortable="true">Total</th>
                        <th data-sortable="true">Dato falso %</th>
                        <th data-sortable="true">No interesa %</th>
                        <th data-sortable="true">NQ Sin cita %</th>
                        <th data-sortable="true">Qs</th>
                        <th data-sortable="true">NQs</th>
                    </tr>
                    </thead>
                    <tbody>
                    {% for rep in reportOpc.table %}
                        {% set user = rep.0 %}
                        <tr>
                            <td>{{user.person.fullName}}</td>
                            <td>{{ rep.countBallots }}</td>
                            <td>{{ (rep.countBallots>0?((rep.FD_count/rep.countBallots)*100):0)|number_format(2) }}</td>
                            <td>{{ (rep.countBallots>0?(((rep.NO_INTERESTED)/rep.countBallots)*100):0)|number_format(2) }}</td>
                            <td>{{ (rep.countBallots>0?(((rep.NQNM)/rep.countBallots)*100):0)|number_format(2) }}</td>
                            <td>{{ rep.QS }}</td>
                            <td>{{ rep.NQS  }}</td>
                        </tr>
                    {% endfor %}
                    </tbody>
                </table>
            {% else %}
            <h3>Aún no hay suficiente información para generar un reporte de productividad de OPCs</h3>
        {% endif %}
        {% endif %}

        {% if app.user.hasOneRole(["ROLE_TLMKT_SUPERVISOR", "ROLE_TLMKT_OPERATOR"]) %}
            {% if reportOperator %}
            <h2>Productividad de Operadores</h2>
            <div style="display: inline-block;position: static; box-sizing: content-box;padding: 50px">
                <div id="operator-productivity-report" style="height: 400px; width: 700px"></div>
            </div>
            <script>

                window.reports.barChart("operator-productivity-report", {{ reportOperator.graph|json_encode|raw }});
            </script>
            <table class="table table-hover" data-height="500" data-toggle="table" data-search="true" data-show-columns="true">
                <thead>
                <tr>
                    <th data-sortable="true">Operador</th>
                    <th data-sortable="true">Oficinas</th>
                    <th data-sortable="true">Total</th>
                    <th data-sortable="true">Dato falso %</th>
                    <th data-sortable="true">No interesa %</th>
                    <th data-sortable="true">Qs</th>
                    <th data-sortable="true">NQs</th>
                    <th data-sortable="true">Citas asistidas</th>
                    <th data-sortable="true">Ventas</th>
                    <th data-sortable="true">Citas</th>
                </tr>
                </thead>
                <tbody>
                {% for rep in reportOperator.table %}
                    {% set user = rep.0 %}
                    <tr>
                        <td>{{user.person.fullName}}</td>
                        <td>{{ app.user.officesArray|join(", ") }}</td>
                        <td>{{ rep.countBallots }}</td>
                        <td>{{ (rep.countBallots>0?((rep.FD_count/rep.countBallots)*100):0)|number_format(2) }}</td>
                        <td>{{ (rep.countBallots>0?(((rep.NO_INTERESTED)/rep.countBallots)*100):0)|number_format(2) }}</td>
                        <td>{{ rep.QS }}</td>
                        <td>{{ rep.NQS  }}</td>
                        <td>{{ rep.ASSISTED  }}</td>
                        <td>{{ rep.SALES  }}</td>
                        <td>{{ rep.MEETINGS  }}</td>
                    </tr>
                {% endfor %}
                </tbody>
            </table>
            {% else %}
            <h3>Aún no hay suficiente información para generar un reporte de productividad de operadores</h3>
        {% endif %}
        {% endif %}

        {% if  app.user.hasOneRole(["ROLE_TLMKT_SUPERVISOR"])%}
            {% if reportCapturists %}
                <h2>Reporte de capturas</h2>

                <div style="display: inline-block;position: static; box-sizing: content-box;padding: 50px">
                    <div id="capturist-productivity-report" style="height: 400px; width: 700px"></div>
                </div>
                <script>
                    window.reports.barChart("capturist-productivity-report", {{ reportCapturists.graph|json_encode|raw }});
                </script>
                <table class="table table-hover" data-height="500" data-toggle="table" data-search="true" data-show-columns="true">
                    <thead>
                    <tr>
                        <th data-sortable="true">Capturista</th>
                        <th data-sortable="true">No de capturas</th>
                    </tr>
                    </thead>
                    <tbody>
                    {% for rep in reportCapturists.table %}
                        {% set user = rep.0 %}
                        <tr>
                            <td>{{user.person.fullName}}</td>
                            <td>{{ rep.countBallots }}</td>
                        </tr>
                    {% endfor %}
                    </tbody>
                </table>
            {% endif %}

            {% if reportLinerSales %}
                <h2>Reporte de ventas de Liners</h2>

                <div style="display: inline-block;position: static; box-sizing: content-box;padding: 50px">
                    <div id="liner-sales-productivity-report" style="height: 400px; width: 700px"></div>
                </div>
                <script>
                    window.reports.barChart("liner-sales-productivity-report", {{ reportLinerSales.graph|json_encode|raw }});
                </script>
                <table class="table table-hover" data-height="500" data-toggle="table" data-search="true" data-show-columns="true">
                    <thead>
                    <tr>
                        <th data-sortable="true">Vendedor</th>
                        <th data-sortable="true">No de citas</th>
                        <th data-sortable="true">Qs</th>
                        <th data-sortable="true">NQs</th>
                        <th data-sortable="true">No de ventas</th>
                        <th data-sortable="true">Iniciales totales</th>
                        <th data-sortable="true">Volumen de vtas</th>
                        <th data-sortable="true">% de cierre</th>
                        <th data-sortable="true">Precio promedio</th>
                        <th data-sortable="true">Ventas pendientes</th>
                        <th data-sortable="true">Ventas procesables</th>
                    </tr>
                    </thead>
                    <tbody>
                    {% for rep in reportLinerSales.table %}
                        {% set user = rep.0 %}
                        <tr>
                            <td>{{user.person.fullName}}</td>
                            <td>{{ rep.countBallots }}</td>
                            <td>{{rep.QS}}</td>
                            <td>{{rep.NQS}}</td>
                            <td>{{ rep.SALES }}</td>
                            <td>${{rep.INITIAL_PAYMENTS|default(0)|number_format(2)}}</td>
                            <td>${{rep.TOTAL_AMMOUNT|default(0)|number_format(2)}}</td>
                            <td>{{ rep.SALES|default(0)>0?((rep.SALES/rep.countBallots)*100)|number_format(2):0 }}%</td>
                            <td>${{ rep.SALES|default(0)>0?(rep.TOTAL_AMMOUNT/rep.SALES)|number_format(2):0 }} </td>
                            <td>{{ rep.SALES|default(0) - rep.FULL_SALES|default(0) }} </td>
                            <td>{{ rep.FULL_SALES|default(0) }}</td>
                        </tr>
                    {% endfor %}
                    </tbody>
                </table>

            {% endif %}

            {% if reportCloserSales %}
                <h2>Reporte de ventas de Closers</h2>

                <div style="display: inline-block;position: static; box-sizing: content-box;padding: 50px">
                    <div id="closer-sales-productivity-report" style="height: 400px; width: 700px"></div>
                </div>
                <script>
                    window.reports.barChart("closer-sales-productivity-report", {{ reportCloserSales.graph|json_encode|raw }});
                </script>
                <table class="table table-hover" data-height="500" data-toggle="table" data-search="true" data-show-columns="true">
                    <thead>
                    <tr>
                        <th data-sortable="true">Vendedor</th>
                        <th data-sortable="true">No de citas</th>
                        <th data-sortable="true">Qs</th>
                        <th data-sortable="true">NQs</th>
                        <th data-sortable="true">No de ventas</th>
                        <th data-sortable="true">Iniciales totales</th>
                        <th data-sortable="true">Volumen de vtas</th>
                        <th data-sortable="true">% de cierre</th>
                        <th data-sortable="true">Precio promedio</th>
                        <th data-sortable="true">Ventas pendientes</th>
                        <th data-sortable="true">Ventas procesables</th>
                    </tr>
                    </thead>
                    <tbody>
                    {% for rep in reportCloserSales.table %}
                        {% set user = rep.0 %}
                        <tr>
                            <td>{{user.person.fullName}}</td>
                            <td>{{ rep.countBallots }}</td>
                            <td>{{rep.QS}}</td>
                            <td>{{rep.NQS}}</td>
                            <td>{{ rep.SALES }}</td>
                            <td>${{rep.INITIAL_PAYMENTS|default(0)|number_format(2)}}</td>
                            <td>${{rep.TOTAL_AMMOUNT|default(0)|number_format(2)}}</td>
                            <td>{{ rep.SALES|default(0)>0?((rep.SALES/rep.countBallots)*100)|number_format(2):0 }}%</td>
                            <td>${{ rep.SALES|default(0)>0?(rep.TOTAL_AMMOUNT/rep.SALES)|number_format(2):0 }} </td>
                            <td>{{ rep.SALES|default(0) - rep.FULL_SALES|default(0) }} </td>
                            <td>{{ rep.FULL_SALES|default(0) }}</td>
                        </tr>
                    {% endfor %}
                    </tbody>
                </table>

            {% endif %}
        {% endif %}

        {% if  app.user.hasOneRole(["ROLE_TLMKT_SUPERVISOR"]) %}
            {% if reportBallots and repBallots[0].Con_cita_no_interesa|default %}
            {% set rep = reportBallots[0] %}

            {% set ctot = rep.Con_cita_no_interesa + rep.Con_cita_no_contesta  + rep.Con_cita_llamar_despues + rep.Con_cita_reprogramada + rep.Con_cita_confirmada + rep.Con_cita_no_asistida + rep.Con_cita_no_calificado_venta  + rep.Con_cita_no_calificado_sin_venta + rep.Con_cita_calificado_venta + rep.Con_cita_calificado_sin_venta + rep.Con_cita_no_tour%}
            <h2>Productividad total</h2>
            <table class="table table-hover" data-height="500" data-toggle="table" data-search="true" data-show-columns="true">
                <thead>
                <tr>
                    <th data-sortable="true">Citas (C)</th>
                    <th data-sortable="true">Citas confirmadas (CC)</th>
                    <th data-sortable="true">Citas con asistencia ( CV, CSV, CNQV, CNQSN, CNT)</th>
                    <th data-sortable="true">Asistencias Q</th>
                    <th data-sortable="true">Asistencias NQ</th>
                    <th data-sortable="true">Citas con venta</th>
                </tr>
                </thead>
                <tbody>
                    <td>{{ ctot }} </td>
                    <td>{{ rep.Con_cita_confirmada }}</td>
                    <td>{{ rep.ASSISTED}}</td>
                    <td>{{ rep.QS }}</td>
                    <td>{{ rep.NQS }}</td>
                    <td>{{ rep.SALES}}</td>
                </tbody>
            </table>
            {% else %}
                <h3>No hay suficiente información para generar un reporte de productividad de operadores</h3>
            {% endif %}
        {% endif %}



    {% endblock %}