{% extends '@App/base.html.twig' %}
{% block title %}
    Advisors
{% endblock %}
{% block body %}
    <div class="row">
        <div class="col-xs-12">
            <div class="widget">
                <div class="row">
                    <div class="col-xs-12">
                        {% include 'AppBundle:iService//Reporting:dateForm.html.twig' %}
                        <table id="table_reporting" class="table table-hover table-striped table-bordered text-center">
                            <thead>
                                <tr>
                                    <th>ADVISOR</th>
                                    <th># OF JOBS</th>
                                    <th>ORIGINAL RO AMOUNTS</th>
                                    <th>FINAL RO AMOUNTS</th>
                                    <th>UPSELL AMOUNTS</th>
                                    <th>UPSELL PERCENTAGE</th>
                                    <th>TOTAL VIDEOS</th>
                                    <th>GROSS/JOB w/VIDEO</th>
                                    <th>GROSS/JOB w/o VIDEO</th>
                                </tr>
                            </thead>
                            <tfoot class="hidden">
                                <tr>
                                    <th>ADVISOR</th>
                                    <th># OF JOBS</th>
                                    <th>ORIGINAL RO AMOUNTS</th>
                                    <th>FINAL RO AMOUNTS</th>
                                    <th>UPSELL AMOUNTS</th>
                                    <th>UPSELL PERCENTAGE</th>
                                    <th>TOTAL VIDEOS</th>
                                    <th>GROSS/JOB w/VIDEO</th>
                                    <th>GROSS/JOB w/o VIDEO</th>
                                </tr>
                            </tfoot>
                            <tbody id="jobsVideosTable">
                                {% for advisor in advisors %}
                                    <tr>
                                        <td>{{ advisor['name'] }}</td>
                                        <td>{{ advisor['total_repair_orders'] }}</td>
                                        <td>${{ advisor['original_value'] }}</td>
                                        <td>${{ advisor['final_value'] }}</td>
                                        <td>${{ advisor['upsell_value'] }}</td>
                                        <td>{{ advisor['upsell_percentage']|round(2, 'ceil') }}%</td>
                                        <td>{{ advisor['total_videos'] }}</td>
                                        <td>{{ advisor['gross_per_job_w_video'] | round(2, 'ceil') }}</td>
                                        <td>{{ advisor['gross_per_job_wo_video'] | round(2, 'ceil') }}</td>
                                    </tr>
                                {% endfor %}
                            </tbody>
                        </table>
                        <br/><br/>
                        <div class="row text-center">
                            <div class="col-md-2">
                                <p><b>Total Number Jobs:</b></p>
                                <h3>{{ cumulative_repair_orders }}</h3>
                            </div>
                            <div class="col-md-2">
                                <p><b>Total Initial RO Value:</b></p>
                                <h3>${{ cumulative_original_value }}</h3>
                            </div>
                            <div class="col-md-2">
                                <p><b>Total Final RO Value:</b></p>
                                <h3>${{ cumulative_final_value }}</h3>
                            </div>
                            <div class="col-md-2">
                                <p><b>Total Upsell Amount:</b></p>
                                <h3>${{ cumulative_upsell_value }}</h3>
                            </div>
                            <div class="col-md-2">
                                <p><b>Total Upsell Percentage:</b></p>
                                <h3>{{ cumulative_upsell_percentage|round(2, 'ceil') }}%</h3>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
{% endblock %}