{% extends "base.html" %}

{% block title %}Unità Stratigrafiche{% endblock %}

{% block content %}
<div class="container mt-4">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h2>Unità Stratigrafiche</h2>
        <div>
            <a href="{{ url_for('export_us_pdf') }}{% if sito_filter %}?sito={{ sito_filter }}{% endif %}" class="btn btn-danger">
                <i class="fas fa-file-pdf"></i> Esporta PDF
            </a>
            <a href="{{ url_for('create_us') }}" class="btn btn-primary">Nuova US</a>
        </div>
    </div>

    <!-- Filters -->
    <form method="GET" class="mb-4">
        <div class="row">
            <div class="col-md-6">
                <select name="sito" class="form-select">
                    <option value="">Tutti i siti</option>
                    {% for site in sites %}
                    <option value="{{ site.sito }}" {% if sito_filter == site.sito %}selected{% endif %}>{{ site.sito }}</option>
                    {% endfor %}
                </select>
            </div>
            <div class="col-md-6">
                <button type="submit" class="btn btn-primary">Filtra</button>
                <a href="{{ url_for('us_list') }}" class="btn btn-secondary">Reset</a>
            </div>
        </div>
    </form>

    <!-- US Table -->
    {% if us_list %}
    <div class="table-responsive">
        <table class="table table-striped">
            <thead>
                <tr>
                    <th>US</th>
                    <th>Sito</th>
                    <th>Area</th>
                    <th>Descrizione</th>
                    <th>Anno</th>
                </tr>
            </thead>
            <tbody>
                {% for us in us_list %}
                <tr>
                    <td><strong>{{ us.us }}</strong></td>
                    <td>{{ us.sito }}</td>
                    <td>{{ us.area or '-' }}</td>
                    <td>{{ us.d_stratigrafica or '-' }}</td>
                    <td>{{ us.anno_scavo or '-' }}</td>
                </tr>
                {% endfor %}
            </tbody>
        </table>
    </div>
    <p class="text-muted">Totale: {{ total }} US</p>
    {% else %}
    <div class="alert alert-info">Nessuna US trovata.</div>
    {% endif %}
</div>
{% endblock %}