{{ include( 'NivaControlBundle:Shared:header.html.twig', { 'section': 'admin', 'mode': 'admin' } ) }}

{{ include( 'NivaControlBundle:Shared:sidebar.html.twig', { 'section': 'admin', 'mode': 'admin', 'active': 'report' } ) }}

<!-- main content -->
<div class="col-sm-10">
    <div class="page-header">
        <h1>Report: Provider Traffic Analysis</h1>
    </div>

    <div class="row">
        <div class="col-md-12">
            <div class="panel panel-default">
                <div class="panel-heading">
                    <strong>Filters</strong>
                </div>
                <div class="panel-body">
                    <form class="form-horizontal" role="form" action="{{ path('admin_report_provider_traffic') }}"
                          method="post">
                        <div class="form-group">
                            <div class="col-lg-4">
                                <select class="form-control" name="providerId">
                                    <option value="0" selected="selected"
                                            {% if params.providerId == 0 %}selected="selected"{% endif %}
                                            >-- Select Provider --
                                    </option>
                                    {% for provider in providerList %}
                                        <option value="{{ provider.providerId }}"
                                                {% if params.providerId == provider.providerId %}selected="selected"{% endif %}
                                                >{{ provider.providerName }}</option>
                                    {% endfor %}
                                </select>
                            </div>

                            <div class="col-lg-4">
                                <div class="input-group date" id="form_datetime_from" data-date-format="yyyy-mm-dd">
                                    <input class="form-control" id="fromDate" name="fromDate" size="16" type="text"
                                            {% if params.fromDate %}
                                                value="{{ params.fromDate|date('Y-m-d') }}"
                                            {% else %}
                                                value=""
                                            {% endif %}
                                           placeholder="-- From --" readonly />
                                    <span class="input-group-addon"><span
                                                class="glyphicon glyphicon-remove"></span></span>
                                    <span class="input-group-addon"><span class="glyphicon glyphicon-th"></span></span>
                                </div>
                            </div>

                            <div class="col-lg-4">
                                <div class="input-group date" id="form_datetime_to" data-date-format="yyyy-mm-dd">
                                    <input class="form-control" id="toDate" name="toDate" size="16" type="text"
                                            {% if params.toDate %}
                                                value="{{ params.toDate|date('Y-m-d') }}"
                                            {% else %}
                                                value=""
                                            {% endif %}
                                           placeholder="-- To --" readonly />
                                    <span class="input-group-addon"><span
                                                class="glyphicon glyphicon-remove"></span></span>
                                    <span class="input-group-addon"><span class="glyphicon glyphicon-th"></span></span>
                                </div>
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="col-lg-12">
                                <button type="submit" class="btn btn-default btn-block">Run</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    {% if errorMessage %}
    <p class="text-center text-warning">{{ errorMessage }}</p>
    {% else %}
        <table id="maintable" class="table table-striped">
            <thead>
            <tr>
                <th rowspan="2" class="text-center">Date</th>
                <th colspan="7" class="text-center">Clicks</th>
                <th colspan="5" class="text-center">Activations</th>
                <th colspan="2" class="text-center">Conversion Rate</th>
            </tr>
            <tr>
                <!-- Clicks -->
                <th>Total</th>
                <th>WiFi</th>
                <th>%</th>
                <th>Mobile</th>
                <th>%</th>
                <th>Unique</th>
                <th>%</th>
                <!-- Activations -->
                <th>Total</th>
                <th>Web</th>
                <th>%</th>
                <th>Wap</th>
                <th>%</th>
                <!-- CR -->
                <th>Web</th>
                <th>Wap</th>
            </tr>
            </thead>
            <tbody>
            {# TOTAL ROW #}
            <tr>
                <td style="text-align:center;"><strong>Total</strong></td>
                <!-- Clicks -->
                <td><strong>{{ total.clicks|number_format }}</strong></td>
                <td><strong>{{ total.desktop|number_format }}</strong></td>
                <td><strong><small>{% if total.clicks > 0 %}{{ (total.desktop*100/total.clicks)|number_format(1, '.', ',') }}%{% else %}0%{% endif %}</small></strong></td>
                <td><strong>{{ total.mobile|number_format }}</strong></td>
                <td><strong><small>{% if total.clicks > 0 %}{{ (total.mobile*100/total.clicks)|number_format(1, '.', ',') }}%{% else %}0%{% endif %}</small></strong></td>
                <td><strong>--</strong></td>
                <td><strong><small>--</small></strong></td>
                <!-- Activations -->
                <td><strong>{{ total.activations|number_format }}</strong></td>
                <td><strong>{{ total.web|number_format }}</strong></td>
                <td><strong><small>{% if total.activations > 0 %}{{ (total.web*100/total.activations)|number_format(1, '.', ',') }}%{% else %}0%{% endif %}</small></strong></td>
                <td><strong>{{ total.wap|number_format }}</strong></td>
                <td><strong><small>{% if total.activations > 0 %}{{ (total.wap*100/total.activations)|number_format(1, '.', ',') }}%{% else %}0%{% endif %}</small></strong></td>
                <!-- CR -->
                <td><strong>{{ total.crWeb|number_format(3, '.', ',') }}%</strong></td>
                <td><strong>{{ total.crWap|number_format(3, '.', ',') }}%</strong></td>
            </tr>

            {# BY DAY #}
            {% for result in results %}
                <tr>
                    <td style="white-space:nowrap;">{{ result.datestamp }} {{ result.datestamp|date('D') }}</td>
                    <!-- Clicks -->
                    <td>{{ result.clicks|number_format }}</td>
                    <td>{{ result.desktop|number_format }}</td>
                    <td><small>{% if result.clicks > 0 %}{{ (result.desktop*100/result.clicks)|number_format(1, '.', ',') }}%{% else %}0%{% endif %}</small></td>
                    <td>{{ result.mobile|number_format }}</td>
                    <td><small>{% if result.clicks > 0 %}{{ (result.mobile*100/result.clicks)|number_format(1, '.', ',') }}%{% else %}0%{% endif %}</small></td>
                    <td>{{ result.unique|number_format }}</td>
                    <td><small>{% if result.mobile > 0 %}{{ (result.unique*100/result.mobile)|number_format(1, '.', ',') }}%{% else %}0%{% endif %}</small></td>
                    <!-- Activations -->
                    <td>{{ result.activations|number_format }}</td>
                    <td>{{ result.web|number_format }}</td>
                    <td><small>{% if result.activations > 0 %}{{ (result.web*100/result.activations)|number_format(1, '.', ',') }}%{% else %}0%{% endif %}</small></td>
                    <td>{{ result.wap|number_format }}</td>
                    <td><small>{% if result.activations > 0 %}{{ (result.wap*100/result.activations)|number_format(1, '.', ',') }}%{% else %}0%{% endif %}</small></td>
                    <!-- CR -->
                    <td>{{ result.crWeb|number_format(3, '.', ',') }}%</td>
                    <td>{{ result.crWap|number_format(3, '.', ',') }}%</td>
                </tr>
            {% endfor %}

            </tbody>
        </table>

    <p class="text-center"><a id="exportlink" href="" class='btn btn-default btn-sn' download="report-campaign-conversion-{{ "now"|date("m-d-Y") }}.csv">Export to a spreadsheet</a></p>
    {% endif %}

    <hr>
    <h3>About the report</h3>
    <p>While this report is <i>static</i> in time, it loads data <i>dynamically</i>. In other words, it queries and calculates the moment it's run,
        which means that the numbers shown today might change if the same report is run at a later time because the system is constantly charging clients and
        verifying their conversion status.</p>
    <ul>
        <li><strong>Clicks:</strong> lorem ipsum. The "unique" field only calculates and compares against the clicks in the same day.</li>
        <li><strong>Activations:</strong> lorem ipsum.</li>
        <li><strong>Conversion Rate:</strong> lorem ipsum.</li>
    </ul>

</div>
<!-- /main content -->

{{ include( 'NivaControlBundle:Shared:footer.html.twig' ) }}