{{ 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 Weekly 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_weekly_stats') }}"
                          method="post">
                        <div class="form-group">
                            <div class="col-lg-6">
                                <select class="form-control" name="clubId">
                                    <option value="0" selected="selected"
                                            {% if params.clubId == 0 %}selected="selected"{% endif %}
                                            >-- All Clubs --
                                    </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-6">
                                <button type="submit" class="btn btn-default btn-block">Filter</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <table id="maintable" class="table table-striped">
        <thead>
        <tr>
            <th>Week</th>
            <th>Activations</th>
            {#<th>Resurrected</th>#}
            {#<th>Suspended</th>#}
            <th>Cancellations</th>
            <th>Net Change</th>
            <th>Revenue</th>
            <th>Charged</th>
            {#<th>Costs</th>#}
        </tr>
        </thead>
        <tbody>

        {% for week in weeks %}
            <tr>
                <td>{{ week.weekNumber }}</td>
                <td>{{ week.newUsers|number_format }}</td>
                {#<td>{{ week.resurrectedUsers|number_format }}</td>#}
                {#<td>{{ week.suspendedUsers|number_format }}</td>#}
                <td>{{ week.cancelledUsers|number_format }}</td>
                <td>{{ week.netUsers|number_format }}</td>
                <td>${{ week.revenue|number_format(2, '.', ',') }} MXN</td>
                <td>{{ week.chargedUsers|number_format }}</td>
                {#<td>${{ week.costs|number_format(2, '.', ',') }} USD</td>#}
            </tr>
        {% endfor %}

        </tbody>
    </table>

    {% if weeks[0] is not defined %}
        <p>Woah, no historic records found.</p>
    {% else %}
        <p>Showing only the 52 most recent entries.</p>
    {% endif %}

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

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

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