{{ 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: Campaign Statistics</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_campaign_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">
                            <select class="form-control" name="providerId">
                                <option value="0"
                                        {% if params.providerId == 0 %}selected="selected"{% endif %}
                                        >-- By AdProvider --
                                </option>
                                {% for provider in providers %}
                                    <option value="{{ provider.providerId }}"
                                            {% if params.providerId == provider.providerId %}selected="selected"{% endif %}
                                            >{{ provider.providerName }}</option>
                                {% endfor %}
                            </select>
                        </div>
                        <div class="col-lg-4">
                            <select class="form-control" name="campaignId">
                                <option value="0" selected="selected"
                                        {% if params.campaignId == 0 %}selected="selected"{% endif %}
                                        >-- By Campaign --
                                </option>
                                {% for campaign in campaignList %}
                                    <option value="{{ campaign.campaignId }}"
                                            {% if params.campaignId == campaign.campaignId %}selected="selected"{% endif %}
                                            >{{ campaign.campaignCode }} - {{ campaign.campaignName }}</option>
                                {% endfor %}
                            </select>
                        </div>
                    </div>


                    <div class="form-group">
                        <div class="col-lg-4">
                            <div class="input-group date" id="form_datetime_from" data-date-format="yyyy-mm-dd hh:ii:ss">
                                <input class="form-control" id="fromDate" name="fromDate" size="16" type="text"
                                       value="{{ params.fromDate }}" 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 hh:ii:ss",
                                    autoclose: true,
                                    todayBtn: true,
                                    minuteStep: 5,
                                    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 hh:ii:ss">
                                <input class="form-control" id="toDate" name="toDate" size="16" type="text"
                                       value="{{ params.toDate }}" 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 hh:ii:ss",
                                    autoclose: true,
                                    todayBtn: true,
                                    minuteStep: 5,
                                    pickerPosition: "bottom-left"
                                });
                            </script>
                        </div>

                        <div class="col-lg-2">
                            <div class="checkbox">
                                <label>
                                    <input type="checkbox" name="groupProviders" id="groupProviders" value="1"
                                           {% if params.groupProviders == 1 %}checked{% endif %}
                                            > Group Providers
                                </label>
                            </div>
                        </div>

                        <div class="col-lg-2">
                            <div class="checkbox">
                                <label>
                                    <input type="checkbox" name="showInactive" id="showInactive" value="1"
                                           {% if params.showInactive == 1 %}checked{% endif %}
                                            > Show Inactive
                                </label>
                            </div>
                        </div>


                    </div>


                    <div class="form-group">
                        <div class="col-lg-12">
                            <button type="submit" class="btn btn-default btn-block">Run Report</button>
                        </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_campaign_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_campaign_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_campaign_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_campaign_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>

{% if not total %}
    <p class="text-center text-warning">Please specify some parameters before running the report,
        take into account that the broader the search,
        the longer it'll take to compute.</p>
{% else %}
    <table id="maintable" class="table table-striped">
        <thead>
        <tr>
            <th>Club</th>
            <th>Provider</th>
            <th>Name</th>
            <th>Code</th>
            {#<th>Daily Avg.</th>#}
            <th>Conversions</th>
            <th>Notified</th>
            <th>Suppressed</th>
            <th>Cost USD</th>
        </tr>
        </thead>
        <tbody>

        {# TOTAL ROW #}
        <tr>
            {% if total.sumTotalUsers is null %}
                <td colspan="9" style="text-align:center;"><strong>Could not compute totals.</strong></td>
            {% else %}
                <td colspan="4" style="text-align:center;"><strong>All Campaigns / Total</strong></td>
                {# <td><strong>--</strong></td> #}
                {# BEFORE: <td><strong>{{ total.sumTotalUsers|number_format }}</strong></td> #}
                {# NOW: #}
                <td><strong>{{ (total.sumNotifiedUsers + total.sumSuppressedUsers)|number_format }}</strong></td>
                <td><strong>{{ total.sumNotifiedUsers|number_format }}</strong></td>
                <td><strong>{{ total.sumSuppressedUsers|number_format }}</strong></td>
                <td><strong>${{ total.sumCost|number_format(2, '.', ',') }}</strong></td>
            {% endif %}
        </tr>

        {# BY CAMPAIGN #}
        {% for campaign in campaigns %}

            <tr
                    {% if campaign.sumTotalUsers != (campaign.sumNotifiedUsers + campaign.sumSuppressedUsers) %}
                        class="warning"
                    {% endif %}
                    >
                <td>{{ campaign.clubName }}</td>
                <td>{{ campaign.providerName }}</td>
                {% if params.groupProviders == 1 %}
                    <td>--</td>
                    <td>--</td>
                {% else %}
                    <td>{{ campaign.campaignName }}</td>
                    <td>{{ campaign.campaignCode }}</td>
                {% endif %}
                {#<td>--</td>#}

                {# BEFORE: <td>{{ campaign.sumTotalUsers|number_format }}</td> #}
                {# NOW: #}
                <td>{{ (campaign.sumNotifiedUsers + campaign.sumSuppressedUsers)|number_format }}</td>
                <td>{{ campaign.sumNotifiedUsers|number_format }}</td>
                <td>{{ campaign.sumSuppressedUsers|number_format }}</td>

                <td>${{ campaign.sumCost|number_format(2, '.', ',') }}</td>
            </tr>

        {% endfor %}

        </tbody>
    </table>

    {% if campaigns[0] is not defined %}
        <p>Woah, no campaigns found.</p>
    {% else %}
        <p class="text-center">If a campaign is highlighted in yellow, please notify your system administrator.</p>
    {% endif %}
{% endif %}

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

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

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