{% extends '@App/base.html.twig' %}
{% block title %}
    Reporting Advisor Usage
{% 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>OPEN ROS ON DASHBOARD</th>
                                <th>UNREAD MESSAGES</th>
                                <th>TOTAL ROS CLOSED</th>
                                <th>VIDEOS MADE</th>
                                <th>VIDEOS WATCHED</th>
                                <th>QUOTES SENT</th>
                                <th>QUOTES VIEWED</th>
                                <th>QUOTES RESPONDED</th>
                                <th>TOTAL INBOUND TEXT MESSAGES</th>
                                <th>TOTAL OUTBOUND TEXT MESSAGES</th>
                                <th>APPRAISE MY CAR CLICKS</th>
                                <th>FINANCE MY REPAIR CLICKS</th>
                                <th>MYLOAN CLICKS</th>
                            </tr>
                            </thead>
                            <tfoot class="hidden">
                            <tr>
                                <th>ADVISOR</th>
                                <th>OPEN ROS ON DASHBOARD</th>
                                <th>UNREAD MESSAGES</th>
                                <th>TOTAL ROS CLOSED</th>
                                <th>VIDEOS MADE</th>
                                <th>VIDEOS WATCHED</th>
                                <th>QUOTES SENT</th>
                                <th>QUOTES VIEWED</th>
                                <th>QUOTES RESPONDED</th>
                                <th>TOTAL INBOUND TEXT MESSAGES</th>
                                <th>TOTAL OUTBOUND TEXT MESSAGES</th>
                                <th>APPRAISE MY CAR CLICKS</th>
                                <th>FINANCE MY REPAIR CLICKS</th>
                                <th>MYLOAN CLICKS</th>
                            </tr>
                            </tfoot>
                            <tbody id="jobsVideosTable">
                            {% for advisor_id, advisor in results %}
                            {% set closed_ros = advisor.closed_ros|trim %}
                            {% set videos_made = advisor.videos_made|trim %}
                            {% set videos_watched = advisor.videos_watched|trim %}
                            {% set quotes_sent = advisor.quotes_sent|trim %}
                            {% set quotes_viewed = advisor.quotes_viewed|trim %}
                            {% set quotes_responded = advisor.quotes_responded|trim %}
                            {% set open_ros_dashboard = advisor.open_ros_dashboard|trim %}
                            {% set inbound_texts = advisor.inbound_texts|trim %}
                            {% set outbound_texts = advisor.outbound_texts|trim %}
                            {% set appraise_my_car_clicks = advisor.appraise_my_car_clicks|trim %}
                            {% set appraise_my_car_alternative_clicks = advisor.appraise_my_car_alternative_clicks|trim %}
                            {% set myloan_clicks = advisor.myloan_clicks|trim %}

                            {% set video_completion_rate = 0 %}
                            {% set video_watched_rate = 0 %}
                            {% set quotes_sent_rate = 0 %}
                            {% set quotes_viewed_rate = 0 %}
                            {% set quotes_responded_rate = 0 %}
                            {% set inbound_texts_rate = 0 %}
                            {% set outbound_texts_rate = 0 %}
                            {% set appraise_my_car_clicks_rate = 0 %}
                            {% set appraise_my_car_alternative_clicks_rate = 0 %}
                            {% set myloan_clicks_rate = 0 %}

                            {% if videos_made > 0 and closed_ros > 0 %}
                                {% set video_completion_rate = (videos_made/closed_ros)*100 %}
                            {% endif %}

                            {% if videos_made > 0 and videos_watched > 0 %}
                                {% set video_watched_rate = (videos_watched/videos_made)*100 %}
                            {% endif %}

                            {% if quotes_sent > 0 and closed_ros > 0 %}
                                {% set quotes_sent_rate = (quotes_sent/closed_ros)*100 %}
                            {% endif %}

                            {% if quotes_sent > 0 and quotes_viewed > 0 %}
                                {% set quotes_viewed_rate = (quotes_viewed/quotes_sent)*100 %}
                            {% endif %}

                            {% if quotes_responded > 0 and quotes_viewed > 0 %}
                                {% set quotes_responded_rate = (quotes_responded/quotes_viewed)*100 %}
                            {% endif %}

                            {% if inbound_texts > 0 and closed_ros > 0 %}
                                {% set inbound_texts_rate = (inbound_texts/closed_ros)*100 %}
                            {% endif %}

                            {% if outbound_texts > 0 and closed_ros > 0 %}
                                {% set outbound_texts_rate = (outbound_texts/closed_ros)*100 %}
                            {% endif %}

                            {% if appraise_my_car_clicks > 0 and closed_ros > 0 %}
                                {% set appraise_my_car_clicks_rate = (appraise_my_car_clicks/closed_ros)*100 %}
                            {% endif %}

                            {% if appraise_my_car_alternative_clicks > 0 and closed_ros > 0 %}
                                {% set appraise_my_car_alternative_clicks_rate = (appraise_my_car_alternative_clicks/closed_ros)*100 %}
                            {% endif %}

                            {% if myloan_clicks > 0 and closed_ros > 0 %}
                                {% set myloan_clicks_rate = (myloan_clicks/closed_ros)*100 %}
                            {% endif %}

                                <span>
                                    <td>{{ advisor.name }}</td>
                                    <td>{{ advisor.open_ros_dashboard }}</td>
                                    <td>
                                        {% if advisor.unread_messages > 0 %}
                                            <a href="{{ path('iservice_reporting_unread_messages') }}?start_date={{ start_date }}&end_date={{ end_date }}&advisor_id={{ advisor_id }}"
                                               class="btn btn-primary">
                                                {{ advisor.unread_messages }}
                                            </a>
                                        {% else %}
                                            0
                                        {% endif %}
                                    </td>
                                    <td>{{ advisor.closed_ros }}</td>
                                    <td>{{ advisor.videos_made }}
                                        <br />
                                        <span class="btn btn-block btn-primary">{{ video_completion_rate|number_format(2, '.', ',') }}%</span>
                                    </td>
                                    <td>{{ advisor.videos_watched }}
                                        <br />
                                        <span class="btn btn-block btn-primary">{{ video_watched_rate|number_format(2, '.', ',') }}%</span>
                                    </td>
                                    <td>{{ advisor.quotes_sent }}
                                        <br />
                                        <span class="btn btn-block btn-primary">{{ quotes_sent_rate|number_format(2, '.', ',') }}%</span>
                                    </td>
                                    <td>{{ advisor.quotes_viewed }}
                                        <br />
                                        <span class="btn btn-block btn-primary">{{ quotes_viewed_rate|number_format(2, '.', ',') }}%</span>
                                    </td>
                                    <td>{{ advisor.quotes_responded }}
                                        <br />
                                        <span class="btn btn-block btn-primary">{{ quotes_responded_rate|number_format(2, '.', ',') }}%</span>
                                    </td>
                                    <td>{{ advisor.inbound_texts }}
                                        <br />
                                        <span class="btn btn-block btn-primary">{{ inbound_texts_rate|number_format(2, '.', ',') }}%</span>
                                    </td>
                                    <td>{{ advisor.outbound_texts }}
                                        <br />
                                        <span class="btn btn-block btn-primary">{{ outbound_texts_rate|number_format(2, '.', ',') }}%</span>
                                    </td>
                                    <td>{{ advisor.appraise_my_car_clicks }}
                                        <br />
                                        <span class="btn btn-block btn-primary">{{ appraise_my_car_clicks_rate|number_format(2, '.', ',') }}%</span>
                                    </td>
                                    <td>{{ advisor.appraise_my_car_alternative_clicks }}
                                        <br />
                                        <span class="btn btn-block btn-primary">{{ appraise_my_car_alternative_clicks_rate|number_format(2, '.', ',') }}%</span>
                                    </td>
                                    <td>{{ advisor.myloan_clicks }}
                                        <br />
                                        <span class="btn btn-block btn-primary">{{ myloan_clicks_rate|number_format(2, '.', ',') }}%</span>
                                    </td>
                                </tr>
                            {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
{% endblock %}