{{ 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: SMT Sync 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_smt_sync_analysis') }}"
                      method="post">
                    <div class="form-group">
                        <div class="col-lg-4">
                            <select class="form-control" name="clubId">
                                <option value="0" selected="selected"
                                        {% if params.clubId == 0 %}selected="selected"{% endif %}
                                        >-- By Club --
                                </option>
                                {% for club in clubs %}
                                    <option value="{{ club.clubId }}"
                                            {% if params.clubId == club.clubId %}selected="selected"{% endif %}
                                            >{{ club.clubName }}</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"
                                       value="{{ params.fromDate }}" 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"
                                       value="{{ params.toDate }}" 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-9">
                            <button type="submit" class="btn btn-default btn-block">Filter</button>
                        </div>
                        <div class="col-lg-3">
                            <input class="btn btn-default btn-block" type="reset" value="Reset">
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading">
                <strong>Favorites</strong>
            </div>
            <div class="panel-body">

                <div class="form-group">
                    <form class="form-horizontal" role="form" action="{{ path('admin_report_smt_sync_analysis') }}"
                          method="post">
                        <div class="col-lg-3">
                            <button type="submit" class="btn btn-default btn-block">Today</button>
                            <input type="hidden" name="clubId" value="0"/>
                            <input type="hidden" name="providerId" value="0"/>
                            <input type="hidden" name="campaignId" value="0"/>
                            <input type="hidden" name="groupProviders" value="0"/>
                            <input type="hidden" name="showInactive" value="0"/>
                            <input type="hidden" name="toDate" value="{{ favorites.today.toDate }}"/>
                            <input type="hidden" name="fromDate" value="{{ favorites.today.fromDate }}"/>
                        </div>
                    </form>

                    <form class="form-horizontal" role="form" action="{{ path('admin_report_smt_sync_analysis') }}"
                          method="post">
                        <div class="col-lg-3">
                            <button type="submit" class="btn btn-default btn-block">This day last week</button>
                            <input type="hidden" name="clubId" value="0"/>
                            <input type="hidden" name="providerId" value="0"/>
                            <input type="hidden" name="campaignId" value="0"/>
                            <input type="hidden" name="groupProviders" value="0"/>
                            <input type="hidden" name="showInactive" value="0"/>
                            <input type="hidden" name="toDate" value="{{ favorites.lastWeek.toDate }}"/>
                            <input type="hidden" name="fromDate" value="{{ favorites.lastWeek.fromDate }}"/>
                        </div>
                    </form>

                    <form class="form-horizontal" role="form" action="{{ path('admin_report_smt_sync_analysis') }}"
                          method="post">
                        <div class="col-lg-3">
                            <button type="submit" class="btn btn-default btn-block">This Week</button>
                            <input type="hidden" name="clubId" value="0"/>
                            <input type="hidden" name="providerId" value="0"/>
                            <input type="hidden" name="campaignId" value="0"/>
                            <input type="hidden" name="groupProviders" value="0"/>
                            <input type="hidden" name="showInactive" value="0"/>
                            <input type="hidden" name="toDate" value="{{ favorites.thisWeek.toDate }}"/>
                            <input type="hidden" name="fromDate" value="{{ favorites.thisWeek.fromDate }}"/>
                        </div>
                    </form>

                    <form class="form-horizontal" role="form" action="{{ path('admin_report_smt_sync_analysis') }}"
                          method="post">
                        <div class="col-lg-3">
                            <button type="submit" class="btn btn-default btn-block">This Month</button>
                            <input type="hidden" name="clubId" value="0"/>
                            <input type="hidden" name="providerId" value="0"/>
                            <input type="hidden" name="campaignId" value="0"/>
                            <input type="hidden" name="groupProviders" value="0"/>
                            <input type="hidden" name="showInactive" value="0"/>
                            <input type="hidden" name="toDate" value="{{ favorites.thisMonth.toDate }}"/>
                            <input type="hidden" name="fromDate" value="{{ favorites.thisMonth.fromDate }}"/>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>


<table id="maintable" class="table table-striped table-bordered">
    <thead>
    <tr>
        <th>Date</th>
        <th>Club</th>
        <th>Total Fee</th>
        <th>Total Count</th>
        <th>Type</th>
        <th>Total Messages</th>
        <th>Chargeable?</th>
        <th>Partial Charge?</th>
        <th>Discount?</th>
        <th>Revenue Split</th>
        <th>Aggregator Revenue (MXN)</th>
        <th>Operator Revenue (MXN)</th>
    </tr>
    </thead>
    <tbody>

    {# REST OF THE DAYS #}
    {% for timedLogs in logs %}
    {% for log in timedLogs %}
        <tr>
            <td>{{ log.date }}</td>
            <td>{{ log.club }}</td>
            <td>${{ log.fee|number_format(2) }}</td>
            <td>{{ log.count|number_format }}</td>
            <td>{% if log.type == 1 %}Subscription{% elseif log.type == 2 %}Cancellation{% elseif log.type == 3 %}Renewal{% else %}Unknown{% endif %}</td>
            <td>{#{{{ log.suspendedUsers|number_format }}#}</td>
            <td>{% if log.type == 1 or log.type == 3%}Yes{% elseif log.type == 2 %}No{% else %}Unknown{% endif %}</td>
            <td>{#{{ log.getNetUsers()|number_format }#}</td>
            <td>{#{{ log.activeUsers|number_format }}#}</td>
            <td>{{ log.revenueSplit|number_format(2) }}%</td>
            <td>${{ log.revenueAggregator|number_format(2) }}</td>
            <td>${{ log.revenueOperator|number_format(2) }}</td>
        </tr>
    {% endfor %}
    {% endfor %}

    </tbody>
</table>

{% if logs is empty %}
    <p class="text-danger text-center">Woah, could not compute! This query is CPU intensive, please specify a club and a closed time range.</p>
{% else %}
    <p>Execution time: {{ executionTime }} secs</p>
{% endif %}

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

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

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