{{ 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 Chargeability Matrix</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_club_chargeability') }}"
                          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_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>
                                <script type="text/javascript">
                                    $("#form_datetime_from").datetimepicker({
                                        format: "yyyy-mm-dd",
                                        autoclose: true,
                                        minView: 2,
                                        pickerPosition: "bottom-left"
                                    });
                                </script>
                            </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>
                                <script type="text/javascript">
                                    $("#form_datetime_to").datetimepicker({
                                        format: "yyyy-mm-dd",
                                        autoclose: true,
                                        minView: 2,
                                        pickerPosition: "bottom-left"
                                    });
                                </script>
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="col-lg-12">
                                <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 table-bordered table-condensed" style="white-space: nowrap !important;">
            <thead>
            <tr>
                <th>Client</th>
                {% for date, arr in dates %}
                <th>{{ date }}</th>
                {% endfor %}
            </tr>
            </thead>
            <tbody>
            {% for id, row in matrix %}
                <tr>
                    <td><a href="{{ path('admin_client_view', {'id': id}) }}" target="_blank">+{{ row['client']['country'] }} {{ row['client']['phone'] }}</a></td>

                    {% for date, logs in row['dates'] %}
                    <td>
                        {% for log in logs %}
                            <span style="display:block;">
                                {% if log['action'] == 'SUBS' %}<i class="fa fa-user-plus fa-fw text-success"></i>{{ (log['fee']/100.0)|number_format(2) }}{% endif %}
                                {% if log['action'] == 'CANC' %}<i class="fa fa-user-times fa-fw text-danger"></i>{% endif %}
                                {% if log['action'] == 'RENEW' %}<i class="fa fa-calendar-check-o fa-fw text-primary"></i>{{ (log['fee']/100.0)|number_format(2) }}{% endif %}
                                {% if log['action'] == 'RFAIL' %}<i class="fa fa-calendar-times-o fa-fw text-muted"></i>{% endif %}
                            </span>
                        {% endfor %}
                    </td>
                    {% endfor %}
                </tr>
            {% endfor %}
            </tbody>
        </table>

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

    <hr>
    <h3>About the report</h3>
    <p>This report analyzes the Sync Logs that were received during the specified dates</p>
    <p>All dates are in UTC</p>

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

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