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

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

{% block content %}
{# === PROJECT BATCH REPORT ===
     Admin-only. Per-project 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>Projects Batch Report
        </h1>
        <div class="d-flex gap-2">
            <a href="{% url 'project_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 'project_list' %}" class="btn btn-outline-secondary btn-sm shadow-sm">
                <i class="fas fa-arrow-left me-1"></i> Back to Projects
            </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 'project_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 projects</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>Project</th>
                        <th>Timeline</th>
                        <th class="text-center">Supervisors</th>
                        <th>Teams Involved</th>
                        <th class="text-center">Workers</th>
                        <th class="text-center">Worker-Days</th>
                        <th class="text-end">Labour Cost</th>
                    </tr>
                </thead>
                <tbody>
                    {% for row in project_rows %}
                    <tr>
                        <td>
                            <a href="{% url 'project_detail' row.project.id %}" class="text-decoration-none fw-semibold">
                                {{ row.project.name }}
                            </a>
                            {% if not row.project.active %}
                                <span class="badge bg-secondary ms-1">Inactive</span>
                            {% endif %}
                        </td>
                        <td class="small">
                            {% if row.project.start_date %}{{ row.project.start_date|date:"d M Y" }}{% else %}<span class="text-muted">—</span>{% endif %}
                            &rarr;
                            {% if row.project.end_date %}{{ row.project.end_date|date:"d M Y" }}{% else %}<span class="text-muted">ongoing</span>{% endif %}
                        </td>
                        <td class="text-center">{{ row.supervisor_count }}</td>
                        <td class="small">
                            {% for team_name in row.teams_involved %}
                                <span class="badge bg-light text-dark border me-1">{{ team_name }}</span>
                            {% empty %}
                                <span class="text-muted">—</span>
                            {% endfor %}
                        </td>
                        <td class="text-center">{{ row.worker_count }}</td>
                        <td class="text-center">{{ row.total_worker_days }}</td>
                        <td class="text-end fw-semibold">R {{ row.labour_cost|floatformat:2 }}</td>
                    </tr>
                    {% empty %}
                    <tr>
                        <td colspan="7" class="text-center text-muted py-4">No projects 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>
        Worker-Days = sum of workers across every day of work.
        Labour Cost = sum of daily rates for every worker on every day.
    </p>

</div>
{% endblock %}