{% extends 'base.html' %}
{% load static %}

{% block title %}Teams Report | Fox Fitt{% endblock %}

{% block content %}
{# === TEAM BATCH REPORT ===
     Admin-only. Per-team lifetime aggregates. Filter by active/inactive/all.
     CSV download preserves the same filter. #}

<div class="container py-4">

    {# === PAGE HEADER === #}
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1 class="h3 mb-0" style="font-family: 'Poppins', sans-serif;">
            <i class="fas fa-file-alt me-2"></i>Teams Batch Report
        </h1>
        <div class="d-flex gap-2">
            <a href="{% url 'team_batch_report_csv' %}?active={{ active_filter }}"
               class="btn btn-outline-success btn-sm shadow-sm">
                <i class="fas fa-file-csv me-1"></i> Download CSV
            </a>
            <a href="{% url 'team_list' %}" class="btn btn-outline-secondary btn-sm shadow-sm">
                <i class="fas fa-arrow-left me-1"></i> Back to Teams
            </a>
        </div>
    </div>

    {# === FILTER BAR === #}
    <div class="card shadow-sm border-0 mb-4">
        <div class="card-body py-3">
            <form method="GET" action="{% url 'team_batch_report' %}" class="row g-2 align-items-end">
                <div class="col-md-4">
                    <label class="form-label small text-muted mb-1">Include</label>
                    <select name="active" class="form-select form-select-sm" onchange="this.form.submit()">
                        <option value="active" {% if active_filter == 'active' %}selected{% endif %}>Active only</option>
                        <option value="inactive" {% if active_filter == 'inactive' %}selected{% endif %}>Inactive only</option>
                        <option value="all" {% if active_filter == 'all' %}selected{% endif %}>All teams</option>
                    </select>
                </div>
            </form>
        </div>
    </div>

    {# === REPORT TABLE === #}
    <div class="card shadow-sm border-0">
        <div class="table-responsive">
            <table class="table table-hover align-middle mb-0">
                <thead class="table-light">
                    <tr>
                        <th>Team</th>
                        <th>Supervisor</th>
                        <th class="text-center">Workers</th>
                        <th>Pay Schedule</th>
                        <th class="text-center">Work Days</th>
                        <th class="text-center">Worker-Days</th>
                        <th class="text-end">Labour Cost</th>
                        <th>Projects</th>
                    </tr>
                </thead>
                <tbody>
                    {% for row in team_rows %}
                    <tr>
                        <td>
                            <a href="{% url 'team_detail' row.team.id %}" class="text-decoration-none fw-semibold">
                                {{ row.team.name }}
                            </a>
                            {% if not row.team.active %}
                                <span class="badge bg-secondary ms-1">Inactive</span>
                            {% endif %}
                        </td>
                        <td>
                            {% if row.team.supervisor %}
                                {{ row.team.supervisor.username }}
                            {% else %}
                                <span class="text-muted small">—</span>
                            {% endif %}
                        </td>
                        <td class="text-center">{{ row.worker_count }}</td>
                        <td>
                            {% if row.team.pay_frequency %}
                                <span class="small">{{ row.team.get_pay_frequency_display }}</span>
                            {% else %}
                                <span class="text-muted small">Not set</span>
                            {% endif %}
                        </td>
                        <td class="text-center">{{ row.total_work_days }}</td>
                        <td class="text-center">{{ row.total_worker_days }}</td>
                        <td class="text-end fw-semibold">R {{ row.labour_cost|floatformat:2 }}</td>
                        <td class="small">
                            {% for project_name in row.projects_touched %}
                                <span class="badge bg-light text-dark border me-1">{{ project_name }}</span>
                            {% empty %}
                                <span class="text-muted">—</span>
                            {% endfor %}
                        </td>
                    </tr>
                    {% empty %}
                    <tr>
                        <td colspan="8" class="text-center text-muted py-4">No teams match this filter.</td>
                    </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div>
    </div>

    <p class="text-muted small mt-3">
        <i class="fas fa-info-circle me-1"></i>
        Work Days = total attendance records. Worker-Days = sum of workers across all records.
        Labour Cost = sum of daily rates for every worker on every day.
    </p>

</div>
{% endblock %}