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

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

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

<!-- === HEADER === -->
<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-users me-2" style="color: var(--accent);"></i>Worker Batch Report</h1>
        <p class="mb-0" style="color: var(--text-secondary); font-size: 0.85rem;">
            {{ total_workers }} worker{{ total_workers|pluralize }} — lifetime aggregates
        </p>
    </div>
    <div class="d-flex gap-2 mt-3 mt-md-0">
        <a href="{% url 'worker_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 'worker_batch_report_pdf' %}?{{ query_string }}" class="btn btn-accent shadow-sm">
            <i class="fas fa-download me-1"></i>Download PDF
        </a>
        <a href="{% url 'worker_list' %}" class="btn btn-outline-secondary">
            <i class="fas fa-arrow-left me-1"></i>Workers
        </a>
    </div>
</div>

<!-- === FILTER BAR === -->
<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-3">
                <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 workers</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-4">
                <label class="form-label small fw-semibold mb-1">Project <span class="text-muted fw-normal">(optional)</span></label>
                <select name="project" class="form-select">
                    <option value="">All projects</option>
                    {% for p in projects %}
                    <option value="{{ p.id }}" {% if project_id|stringformat:"s" == p.id|stringformat:"s" %}selected{% endif %}>{{ p.name }}</option>
                    {% endfor %}
                </select>
            </div>
            <div class="col-md-3">
                <label class="form-label small fw-semibold mb-1">Team <span class="text-muted fw-normal">(optional)</span></label>
                <select name="team" class="form-select">
                    <option value="">All teams</option>
                    {% for t in teams %}
                    <option value="{{ t.id }}" {% if team_id|stringformat:"s" == t.id|stringformat:"s" %}selected{% endif %}>{{ t.name }}</option>
                    {% endfor %}
                </select>
            </div>
            <div class="col-md-2">
                <button type="submit" class="btn btn-primary w-100"><i class="fas fa-filter me-1"></i>Filter</button>
            </div>
        </form>
    </div>
</div>

<!-- === REPORT TABLE === -->
<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>Name</th>
                        <th>ID</th>
                        <th class="text-end">Salary</th>
                        <th class="text-center">Active</th>
                        <th class="text-end">Days</th>
                        <th>Projects</th>
                        <th>Teams</th>
                        <th>First Payslip</th>
                        <th>Last Payslip</th>
                        <th class="text-end">Total Paid</th>
                        <th class="text-center">Certs</th>
                        <th class="text-center">Warnings</th>
                    </tr>
                </thead>
                <tbody>
                    {% for r in rows %}
                    <tr>
                        <td class="fw-medium">
                            <a href="{% url 'worker_detail' r.worker.id %}" style="color: var(--text-main); text-decoration: none;">{{ r.worker.name }}</a>
                        </td>
                        <td style="color: var(--text-secondary);">{{ r.worker.id_number }}</td>
                        <td class="text-end">R {{ r.worker.monthly_salary|money }}</td>
                        <td class="text-center">
                            {% if r.worker.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 class="text-end">{{ r.days_worked }}</td>
                        <td style="font-size: 0.8rem; max-width: 200px;">{% for p in r.projects %}<span class="badge me-1 mb-1" style="background: var(--accent-subtle); color: var(--accent-text);">{{ p }}</span>{% endfor %}</td>
                        <td style="font-size: 0.8rem; max-width: 160px;">{% 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>{{ r.first_payslip_date|date:"d M Y"|default:'—' }}</td>
                        <td>{{ r.last_payslip_date|date:"d M Y"|default:'—' }}</td>
                        <td class="text-end fw-semibold">R {{ r.total_paid_lifetime|money }}</td>
                        <td class="text-center">
                            <span title="Active / Total">{{ r.certs_active }}/{{ r.certs_total }}</span>
                            {% if r.certs_expiring %}<br><small style="color: #f59e0b;"><i class="fas fa-clock"></i> {{ r.certs_expiring }} expiring</small>{% endif %}
                            {% if r.certs_expired %}<br><small style="color: #ef4444;"><i class="fas fa-exclamation-circle"></i> {{ r.certs_expired }} expired</small>{% endif %}
                        </td>
                        <td class="text-center">
                            {% if r.warnings_count %}<span class="badge" style="background: rgba(245, 158, 11, 0.15); color: #f59e0b;">{{ r.warnings_count }}</span>
                            {% else %}<span class="text-muted">—</span>{% endif %}
                        </td>
                    </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div>
        {% else %}
        <p class="text-center py-5 mb-0" style="color: var(--text-secondary);">
            No workers match the filter. <a href="{% url 'worker_batch_report' %}">Clear filters</a>.
        </p>
        {% endif %}
    </div>
</div>

</div>
{% endblock %}