{{ 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 Monthly 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_monthly_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 %}
                                            >-- Select Club --
                                    </option>
                                    {% for club in clubList %}
                                        <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" data-date-format="yyyy-mm">
                                    <input class="form-control" id="datestamp" name="datestamp" size="16" type="text"
                                           {% if params.datestamp %}
                                           value="{{ params.datestamp|date('Y-m') }}"
                                           {% 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">
                                <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>Day</th>
                <th>Date</th>
                <th>Activations</th>
                <th>Registered Users</th>
                <th colspan="2" class="text-center">Costs USD</th>
                <th colspan="2" class="text-center">Revenue MXN</th>
                <th>Growth</th>
            </tr>
        </thead>
        <tbody>
        {# BY DAY #}
        {% for day in days %}
            {% if day.datestamp|date('D') == 'Sun' %}
            <tr class="success">
            {% else %}
            <tr>
            {% endif %}
                <td>{{ day.datestamp|date('D') }}</td>
                <td>{{ day.datestamp|date('Y-m-d') }}</td>
                <td>{{ day.conv|number_format }}</td>
                <td>{{ day.registered|number_format }}</td>
                <td>${{ day.costs|number_format(2, '.', ',') }}</td>
                <td>${{ day.cumCosts|number_format(2, '.', ',') }}</td>
                <td>${{ day.revenue|number_format(2, '.', ',') }}</td>
                <td>${{ day.cumRevenue|number_format(2, '.', ',') }}</td>
                {% if day.growth == "infin" %}
                <td>&infin;</td>
                {% elseif day.growth == "undef" %}
                <td>Undef.</td>
                {% else %}
                <td>{{ day.growth|number_format(2, '.', ',') }}%</td>
                {% endif %}
            </tr>

        {% endfor %}

        </tbody>
    </table>

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

    <hr>
    <h3>About the report</h3>
    <p><strong>Registered users:</strong> Indicates the registered user base in the system, that is, the sum of both
        active and suspended clients.</p>
    <p><strong>Costs & Revenue:</strong> The column in the left indicates the cost or revenue for that day, while the
    column in the right is the cumulative sum since the first day of the month.</p>
    <p><strong>Growth:</strong> Calculates the percentage of growth in revenue between the day and the same day of last week.</p>
</div>
<!-- /main content -->

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