{{ 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: Club Daily Stats</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_daily_stats') }}"
                      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"
                                        {% 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-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_daily_stats') }}"
                          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_daily_stats') }}"
                          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_daily_stats') }}"
                          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_daily_stats') }}"
                          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">
    <thead>
    <tr>
        <th>Club</th>
        <th>Date</th>
        <th>Day</th>
        <th>New Users</th>
        <th>Resurrected</th>
        <th>Suspended</th>
        <th>Cancelled</th>
        <th>Net Active Change</th>
        <th>Total Registered</th>
        <th>Total Charged</th>
        <th>Revenue (MXN)</th>
        <th>Costs (USD)</th>
        <th>Details</th>
    </tr>
    </thead>
    <tbody>

    {# TOTAL (SUM) #}
    <tr>
        {% if total.sumRevenue is null %}
            <td colspan="11" style="text-align:center;"><strong>Could not compute totals.</strong></td>
        {% else %}
            <td colspan="3" style="text-align:center;"><strong>Total</strong></td>
            <td><strong>{{ total.sumNewUsers|number_format }}</strong></td>
            <td><strong>{{ total.sumResurrectedUsers|number_format }}</strong></td>
            <td><strong>{{ total.sumSuspendedUsers|number_format }}</strong></td>
            <td><strong>{{ total.sumCancelledUsers|number_format }}</strong></td>
            <td><strong>{{ total.sumNetUsers|number_format }}</strong></td>
            <td><strong>{# {{ total.sumActiveUsers|number_format }} #} --</strong></td>
            {#<td><strong>--</strong></td>#}
            <td><strong>--</strong></td>
            <td><strong>${{ total.sumRevenue|number_format(2, '.', ',') }}</strong></td>
            <td><strong>${{ total.sumCosts|number_format(2, '.', ',') }}</strong></td>
            <td>&nbsp;</td>
        {%  endif  %}
    </tr>

    {# REST OF THE DAYS #}
    {% for log in logs %}
        <tr>
            <td>{{ log.getClubId().getClubName() }}</td>
            <td>{{ log.timestamp|date('j M Y') }}</td>
            <td>{{ log.timestamp|date('l') }}</td>
            <td>{{ log.newUsers|number_format }}</td>
            <td>{{ log.resurrectedUsers|number_format }}</td>
            <td>{{ log.suspendedUsers|number_format }}</td>
            <td>{{ log.cancelledUsers|number_format }}</td>
            <td>{{ log.getNetUsers()|number_format }}</td>
            <td>{{ log.activeUsers|number_format }}</td>
            <td>{{ log.chargedUsers|number_format }}</td>
            {#<td>{{ log.totalUsers|number_format }}</td>#}
            <td>${{ log.revenue|number_format(2, '.', ',') }}</td>
            <td>${{ log.costs|number_format(2, '.', ',') }}</td>
            <td>
                <button type="button" class="btn btn-default btn-xs" data-container="body" data-toggle="popover" data-placement="right" data-html="true" data-content="{{ log.generateRevenueByTypeTable()|raw }}">
                    <span class="glyphicon glyphicon-plus"></span> Details
                </button>
            </td>
        </tr>
    {% endfor %}

    </tbody>
</table>

{% if logs[0] is not defined %}
    <p>Woah, no historic records found.</p>
{% else %}
    <p>Showing only the 50 most recent entries, but it calculates the total from all the available entries.</p>
{% endif %}

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

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

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