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

{% block title %}Project Batch Report | FoxFitt{% endblock %}

{% block content %}
<div class="container py-4">

<div class="d-flex flex-column flex-md-row justify-content-between align-items-start align-items-md-center mb-4">
    <div>
        <h1 class="page-title"><i class="fas fa-project-diagram me-2" style="color: var(--accent);"></i>Project Batch Report</h1>
        <p class="mb-0" style="color: var(--text-secondary); font-size: 0.85rem;">
            {{ total_projects }} project{{ total_projects|pluralize }} — lifetime aggregates
        </p>
    </div>
    <div class="d-flex gap-2 mt-3 mt-md-0">
        <a href="{% url 'project_batch_report_csv' %}?{{ query_string }}" class="btn btn-primary shadow-sm">
            <i class="fas fa-file-csv me-1"></i>Export CSV
        </a>
        <a href="{% url 'project_list' %}" class="btn btn-outline-secondary">
            <i class="fas fa-arrow-left me-1"></i>Projects
        </a>
    </div>
</div>

<div class="card mb-3">
    <div class="card-body p-3">
        <form method="get" class="row g-2 align-items-end">
            <div class="col-md-4">
                <label class="form-label small fw-semibold mb-1">Status</label>
                <select name="status" class="form-select">
                    <option value="all"      {% if status == 'all' %}selected{% endif %}>All projects</option>
                    <option value="active"   {% if status == 'active' %}selected{% endif %}>Active only</option>
                    <option value="inactive" {% if status == 'inactive' %}selected{% endif %}>Inactive only</option>
                </select>
            </div>
            <div class="col-md-3">
                <button type="submit" class="btn btn-primary w-100"><i class="fas fa-filter me-1"></i>Filter</button>
            </div>
        </form>
    </div>
</div>

<div class="card">
    <div class="card-body p-0">
        {% if rows %}
        <div class="table-responsive">
            <table class="table table-hover mb-0" style="font-size: 0.85rem;">
                <thead>
                    <tr>
                        <th>Project</th>
                        <th class="text-center">Active</th>
                        <th>Supervisors</th>
                        <th>Teams</th>
                        <th class="text-end">Workers</th>
                        <th class="text-end">Worker-Days</th>
                        <th>First Activity</th>
                        <th>Last Activity</th>
                        <th class="text-end">Labour Cost</th>
                    </tr>
                </thead>
                <tbody>
                    {% for r in rows %}
                    <tr>
                        <td class="fw-medium">
                            <a href="{% url 'project_detail' r.project.id %}" style="color: var(--text-main); text-decoration: none;">{{ r.project.name }}</a>
                        </td>
                        <td class="text-center">
                            {% if r.project.active %}<span class="text-success"><i class="fas fa-check-circle"></i></span>
                            {% else %}<span class="text-muted"><i class="far fa-circle"></i></span>{% endif %}
                        </td>
                        <td style="font-size: 0.8rem; color: var(--text-secondary);">{{ r.supervisors|join:", "|default:"—" }}</td>
                        <td style="max-width: 200px;">
                            {% for t in r.teams %}<span class="badge me-1 mb-1" style="background: rgba(59, 130, 246, 0.15); color: #3b82f6;">{{ t }}</span>{% endfor %}
                        </td>
                        <td class="text-end">{{ r.distinct_workers }}</td>
                        <td class="text-end">{{ r.worker_days }}</td>
                        <td>{{ r.first_date|date:"d M Y"|default:'—' }}</td>
                        <td>{{ r.last_date|date:"d M Y"|default:'—' }}</td>
                        <td class="text-end fw-semibold">R {{ r.total_labour_cost|money }}</td>
                    </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div>
        {% else %}
        <p class="text-center py-5 mb-0" style="color: var(--text-secondary);">
            No projects match the filter. <a href="{% url 'project_batch_report' %}">Clear filters</a>.
        </p>
        {% endif %}
    </div>
</div>

</div>
{% endblock %}