{# Fragment for echasl23 Weeks/Courses proxy embed (no base layout).
   Sticky panes / layout CSS: /css/shared.css (.sce-wc-*). #}

{% set range_end = page * per_page %}
{% if range_end > total %}{% set range_end = total %}{% endif %}
{% set sort = filters.sort|default('StartDateReport') %}
{% set dir = filters.dir|default('asc') %}

{% macro pager(page, pages, total, per_page, filters) %}
    {% if total > 0 %}
        <div class="sce-wc-pager">
            <span>
                Records Per Page
                <strong>{{ per_page }}</strong>
            </span>
            <span>
                Page
                <strong>{{ page }}</strong>
                of
                <strong>{{ pages }}</strong>
            </span>
            {% if page > 1 %}
                <a href="#" data-sce-wc-ajax="1"
                   data-from="{{ filters.from|default('')|e('html_attr') }}"
                   data-to="{{ filters.to|default('')|e('html_attr') }}"
                   data-q="{{ filters.q|default('')|e('html_attr') }}"
                   data-sort="{{ filters.sort|default('StartDateReport')|e('html_attr') }}"
                   data-dir="{{ filters.dir|default('asc')|e('html_attr') }}"
                   data-per_page="{{ per_page }}"
                   data-page="1">First</a>
                <a href="#" data-sce-wc-ajax="1"
                   data-from="{{ filters.from|default('')|e('html_attr') }}"
                   data-to="{{ filters.to|default('')|e('html_attr') }}"
                   data-q="{{ filters.q|default('')|e('html_attr') }}"
                   data-sort="{{ filters.sort|default('StartDateReport')|e('html_attr') }}"
                   data-dir="{{ filters.dir|default('asc')|e('html_attr') }}"
                   data-per_page="{{ per_page }}"
                   data-page="{{ page - 1 }}">Previous</a>
            {% else %}
                <span>First</span>
                <span>Previous</span>
            {% endif %}
            {% if page < pages %}
                <a href="#" data-sce-wc-ajax="1"
                   data-from="{{ filters.from|default('')|e('html_attr') }}"
                   data-to="{{ filters.to|default('')|e('html_attr') }}"
                   data-q="{{ filters.q|default('')|e('html_attr') }}"
                   data-sort="{{ filters.sort|default('StartDateReport')|e('html_attr') }}"
                   data-dir="{{ filters.dir|default('asc')|e('html_attr') }}"
                   data-per_page="{{ per_page }}"
                   data-page="{{ page + 1 }}">Next</a>
                <a href="#" data-sce-wc-ajax="1"
                   data-from="{{ filters.from|default('')|e('html_attr') }}"
                   data-to="{{ filters.to|default('')|e('html_attr') }}"
                   data-q="{{ filters.q|default('')|e('html_attr') }}"
                   data-sort="{{ filters.sort|default('StartDateReport')|e('html_attr') }}"
                   data-dir="{{ filters.dir|default('asc')|e('html_attr') }}"
                   data-per_page="{{ per_page }}"
                   data-page="{{ pages }}">Last</a>
            {% else %}
                <span>Next</span>
                <span>Last</span>
            {% endif %}
        </div>
    {% endif %}
{% endmacro %}

{% macro sort_th(label, key, sort, dir, filters, per_page, title, sticky) %}
    {% set next_dir = (sort == key and dir == 'asc') ? 'desc' : 'asc' %}
    {% set marker = '' %}
    {% if sort == key %}
        {% set marker = dir == 'asc' ? ' ▲' : ' ▼' %}
    {% endif %}
    <th{% if sticky %} class="sce-wc-sticky-col"{% endif %}{% if title %} title="{{ title|e('html_attr') }}"{% endif %}>
        <a href="#" data-sce-wc-ajax="1"
           data-from="{{ filters.from|default('')|e('html_attr') }}"
           data-to="{{ filters.to|default('')|e('html_attr') }}"
           data-q="{{ filters.q|default('')|e('html_attr') }}"
           data-sort="{{ key|e('html_attr') }}"
           data-dir="{{ next_dir|e('html_attr') }}"
           data-per_page="{{ per_page }}"
           data-page="1"
           {% if title %}title="{{ title|e('html_attr') }}"{% endif %}>{{ label|e }}{{ marker }}</a>
    </th>
{% endmacro %}

{% from _self import pager, sort_th %}

<div class="sce-wc-dash">
    <p class="sce-wc-meta">
        Signed in as {{ username|e }}
        · {{ total }} event(s)
        {% if total > 0 %}
            · showing {{ ((page - 1) * per_page) + 1 }}–{{ range_end }}
            · page {{ page }} of {{ pages }}
        {% endif %}
    </p>

    {% if filters.defaults_applied|default(false) %}
        <p class="sce-wc-defaults-note">Default period: today − 14 days through today + 4 months.</p>
    {% endif %}

    <form class="sce-wc-filters" method="get" action="" data-sce-wc-ajax="1">
        <label for="sce_wc_from">From</label>
        <input id="sce_wc_from" type="date" name="from" value="{{ filters.from|default('')|e }}">
        <label for="sce_wc_to">To</label>
        <input id="sce_wc_to" type="date" name="to" value="{{ filters.to|default('')|e }}">
        <label for="sce_wc_q">Search</label>
        <input id="sce_wc_q" type="text" name="q" value="{{ filters.q|default('')|e }}" placeholder="Event, venue, category…">
        <label for="sce_wc_per_page">Records Per Page</label>
        <select id="sce_wc_per_page" name="per_page">
            {% for opt in per_page_options %}
                <option value="{{ opt }}"{% if opt == per_page %} selected{% endif %}>{{ opt }}</option>
            {% endfor %}
        </select>
        <input type="hidden" name="page" value="1">
        <input type="hidden" name="sort" value="{{ sort|e }}">
        <input type="hidden" name="dir" value="{{ dir|e }}">
        <button type="submit">Filter</button>
        <a href="#" data-sce-wc-ajax="1" data-from="" data-to="" data-q="" data-sort="StartDateReport" data-dir="asc" data-per_page="{{ per_page }}" data-page="1">Clear</a>
        <a class="sce-wc-export"
           href="?export=1&amp;from={{ filters.from|default('')|e('url') }}&amp;to={{ filters.to|default('')|e('url') }}&amp;q={{ filters.q|default('')|e('url') }}&amp;sort={{ sort|e('url') }}&amp;dir={{ dir|e('url') }}">Export to Excel</a>
    </form>

    {{ pager(page, pages, total, per_page, filters) }}

    {% if rows is empty %}
        <div class="sce-wc-empty">No school events match the current filters.</div>
    {% else %}
        <div class="sce-wc-table-wrapper" id="sce-wc-table-wrapper">
            <div class="sce-wc-table-scroll">
                <table class="sce-wc-table">
                    <thead>
                    <tr>
                        {{ sort_th('Event Name', 'EventName', sort, dir, filters, per_page, null, true) }}
                        {{ sort_th('Course Type', 'CourseType', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Start Date', 'StartDateReport', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('End Date', 'EndDateReport', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Del', 'AttendeeCount', sort, dir, filters, per_page, 'Delegates/ Attendees', false) }}
                        {{ sort_th('Provider', 'ProviderName', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Presenter', 'PresenterName', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Category', 'Category', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('X', 'Cancelled', sort, dir, filters, per_page, 'Cancelled', false) }}
                        {{ sort_th('Cost / Person', 'CostPerPerson', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Rate / Day', 'RatePerDay', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Days', 'Days', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Total TP Rate', 'TotalTPRate', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Total Income', 'TotalIncome', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Profit', 'Profit', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Invoice', 'Invoice', sort, dir, filters, per_page, null, false) }}
                        {{ sort_th('Venue', 'Venue', sort, dir, filters, per_page, null, false) }}
                    </tr>
                    </thead>
                    <tbody>
                    {% for row in rows %}
                        <tr{% if row.Cancelled %} class="sce-wc-row-cancelled"{% endif %}>
                            <td class="sce-wc-sticky-col">
                                {% if row.EventID %}
                                    <a href="/echasl23/SchoolEventsedit.php?EventID={{ row.EventID }}" target="_blank" rel="noopener noreferrer">{{ row.EventName|e }}</a>
                                {% else %}
                                    {{ row.EventName|e }}
                                {% endif %}
                            </td>
                            <td>{{ row.CourseType|e }}</td>
                            <td>{{ row.StartDateReport|e }}</td>
                            <td>{{ row.EndDateReport|e }}</td>
                            <td class="sce-wc-num" title="Delegates/ Attendees">{{ row.AttendeeCount|e }}</td>
                            <td>{{ row.ProviderName|e }}</td>
                            <td>{{ row.PresenterName|e }}</td>
                            <td>{{ row.Category|e }}</td>
                            <td class="{% if row.Cancelled %}sce-wc-cancelled-y{% endif %}"{% if row.Cancelled %} title="Cancelled"{% endif %}>
                                {{ row.Cancelled ? 'Y' : 'N' }}
                            </td>
                            <td class="sce-wc-num">{{ row.CostPerPerson|e }}</td>
                            <td class="sce-wc-num">{{ row.RatePerDay|e }}</td>
                            <td class="sce-wc-num">{{ row.Days|e }}</td>
                            <td class="sce-wc-num">{{ row.TotalTPRate|e }}</td>
                            <td class="sce-wc-num">{{ row.TotalIncome|e }}</td>
                            <td class="sce-wc-num{% if row.ProfitIsNegative|default(false) %} sce-wc-profit-neg{% endif %}">{{ row.Profit|e }}</td>
                            <td>{{ row.Invoice|e }}</td>
                            <td>{{ row.Venue|e }}</td>
                        </tr>
                    {% endfor %}
                    </tbody>
                </table>
            </div>
        </div>

        {{ pager(page, pages, total, per_page, filters) }}
    {% endif %}
</div>