{{ 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 Finance Stats & Projections</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_finance_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 is defined and params.clubId == 0 %}selected="selected"{% endif %}
                                        >-- By Club --
                                </option>
                                {% for club in clubs %}
                                    <option value="{{ club.clubId }}"
                                            {% if params.clubId is defined and 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 is defined and 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 is defined and 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-3">
                            <input class="form-control" id="cpa" name="cpa" type="text"
                                    {% if params.cpa is defined and params.cpa %}
                                        value="{{ params.cpa }}"
                                    {% else %}
                                        value=""
                                    {% endif %}
                                   placeholder="CPA"/>
                        </div>
                        <div class="col-lg-3">
                            <input class="form-control" id="dailyActivations" name="dailyActivations" type="text"
                                    {% if params.dailyActivations is defined and params.dailyActivations %}
                                        value="{{ params.dailyActivations }}"
                                    {% else %}
                                        value=""
                                    {% endif %}
                                   placeholder="Daily Activations"/>
                        </div>
                        <div class="col-lg-3">
                            <input class="form-control" id="days" name="days" type="text"
                                    {% if params.days is defined and params.days %}
                                   value="{{ params.days }}"
                                    {% else %}
                                   value=""
                                   {% endif %}placeholder="Days"/>
                        </div>
                        <div class="col-lg-3">
                            <button type="submit" class="btn btn-default btn-block">Run</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

{% if message %}
    <div class="alert alert-{{ message.type }}" role="alert">{{ message.text|raw }}</div>
{% endif %}

{% if results %}
<!-- AVERAGES -->
<div class="row">
    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading">
                Calculated Averages for <strong>{{ club.clubName }}</strong>
            </div>
            <div class="panel-body">
                <table class="table">
                    <tr>
                        <td><strong>Churn</strong></td>
                        <td>{{ (avg.churn * 100)|number_format(4, '.', ',') }}%</td>
                        <td><strong>Effective Charge Avg.</strong></td>
                        <td>${{ avg.chargeAmount|number_format(3, '.', ',') }}</td>
                    </tr>
                    <tr>
                        <td><strong>Chargeability</strong></td>
                        <td>{{ (avg.chargeability * 100)|number_format(4, '.', ',') }}%</td>
                        <td><strong>Partiality</strong></td>
                        <td>{{ (avg.partiality * 100)|number_format(4, '.', ',') }}%</td>
                    </tr>
                </table>
            </div>
        </div>
    </div>
</div>

<table id="maintable" class="table table-striped">
    <thead>
    <tr>
        <th>Date</th>
        <th>Activations</th>
        <th>Cancellations</th>
        <th>Total Users</th>
        <th>Churn</th>
        <th>Charges</th>
        <th>Chargeability</th>
        <th>Full Charges</th>
        <th>Partiality</th>
        <th>Revenue</th>
        <th>Cost</th>
        <th>Utility</th>
        <th>% Utility</th>
    </tr>
    </thead>
    <tbody>
    <!-- HISTORIC RESULTS -->
    <tr>
        <td colspan="13" class="text-center">
            <strong>Historic</strong>
        </td>
    </tr>

    {% for result in results %}
    <tr>
        <td>{{ result.date }}</td>
        <td>{{ result.activations|number_format(0, '.', ',') }}</td>
        <td>{{ result.cancellations|number_format(0, '.', ',') }}</td>
        <td>{{ result.totalUsers|number_format(0, '.', ',') }}</td>
        <td>{{ (result.churn * 100)|number_format(3, '.', ',') }}%</td>
        <td>{{ result.charges|number_format(0, '.', ',') }}</td>
        <td>{{ (result.chargeability * 100)|number_format(2, '.', ',') }}%</td>
        <td>{{ result.fullCharges|number_format(0, '.', ',') }}</td>
        <td>{{ (result.partiality * 100)|number_format(2, '.', ',') }}%</td>
        <td>${{ result.revenue|number_format(2, '.', ',') }}</td>
        <td>${{ result.cost|number_format(2, '.', ',') }}</td>
        <td>${{ result.utility|number_format(2, '.', ',') }}</td>
        <td>{{ (result.utilityPp * 100)|number_format(2, '.', ',') }}%</td>
    </tr>
    {% endfor %}

    <!-- FORECAST -->
    <tr>
        <td colspan="13" class="text-center">
            <strong>Forecast</strong>
        </td>
    </tr>

    {% for index, result in forecast %}
        <tr>
            <td>+{{ index }}</td>
            <td>{{ result.activations|number_format(0, '.', ',') }}</td>
            <td>{{ result.cancellations|number_format(0, '.', ',') }}</td>
            <td>{{ result.totalUsers|number_format(0, '.', ',') }}</td>
            <td>{{ (avg.churn * 100)|number_format(3, '.', ',') }}%</td>
            <td>{{ result.charges|number_format(0, '.', ',') }}</td>
            <td>{{ (avg.chargeability * 100)|number_format(2, '.', ',') }}%</td>
            <td>{{ result.fullCharges|number_format(0, '.', ',') }}</td>
            <td>{{ (avg.partiality * 100)|number_format(2, '.', ',') }}%</td>
            <td>${{ result.revenue|number_format(2, '.', ',') }}</td>
            <td>${{ result.cost|number_format(2, '.', ',') }}</td>
            <td>${{ result.utility|number_format(2, '.', ',') }}</td>
            <td>{{ (result.utilityPp * 100)|number_format(2, '.', ',') }}%</td>
        </tr>
    {% endfor %}

    </tbody>

</table>
{% endif %}

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

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