{% extends "base.html" %}{% set active="archive" %}{% block title %}Data Archive{% endblock %}{% block page_title %}Data Archive & Retention{% endblock %}
{% block content %}
{% if msg %}<div class="alert alert-{{ msg[0] }}">{{ msg[1] }}</div>{% endif %}
<div class="stats-grid">
    <div class="stat-card"><div class="stat-label">Total Appointments</div><div class="stat-value">{{ stats.total }}</div><div class="stat-icon">🗓</div></div>
    <div class="stat-card accent"><div class="stat-label">Active</div><div class="stat-value">{{ stats.active }}</div><div class="stat-icon">✅</div></div>
    <div class="stat-card"><div class="stat-label">Archived</div><div class="stat-value">{{ stats.archived }}</div><div class="stat-icon">🗄</div></div>
    <div class="stat-card" style="border-color:var(--warning)"><div class="stat-label">Eligible</div><div class="stat-value" style="color:var(--warning)">{{ stats.eligible }}</div><div class="stat-icon">⏳</div></div>
</div>
<div class="grid-2" style="margin-bottom:1.5rem">
    <div class="card">
        <div class="card-header"><span class="card-title">🗄 Archive Old Records</span></div>
        <p class="text-muted" style="margin-bottom:1.2rem;font-size:.88rem">Move completed/cancelled appointments older than N days to the archive table.</p>
        <form method="POST">
            <input type="hidden" name="action" value="archive">
            <div class="form-group"><label>Archive older than (days)</label><input type="number" name="days" value="90" min="30"></div>
            <button type="submit" class="btn btn-primary" onclick="return confirm('Archive now?')">Run Archive</button>
        </form>
    </div>
    <div class="card" style="border-color:var(--danger)">
        <div class="card-header"><span class="card-title" style="color:var(--danger)">🗑️ Purge Archive</span></div>
        <p class="text-muted" style="margin-bottom:1.2rem;font-size:.88rem"><strong style="color:var(--danger)">Permanent.</strong> Delete archived records older than N days.</p>
        <form method="POST">
            <input type="hidden" name="action" value="purge">
            <div class="form-group"><label>Purge older than (days)</label><input type="number" name="purge_days" value="365" min="180"></div>
            <button type="submit" class="btn btn-danger" onclick="return confirm('PERMANENTLY DELETE? Cannot undo.')">Purge Records</button>
        </form>
    </div>
</div>
<div class="card">
    <div class="card-header"><span class="card-title">Archive Log</span><span class="text-muted" style="font-size:.8rem">{{ stats.archived }} total</span></div>
    {% if archives %}
    <div class="table-wrap"><table>
        <thead><tr><th>ID</th><th>Orig #</th><th>Patient</th><th>Doctor</th><th>Apt Date</th><th>Status</th><th>Archived</th></tr></thead>
        <tbody>{% for a in archives %}<tr>
            <td class="text-muted">#{{ a.archive_id }}</td>
            <td class="text-muted">{{ '#'+a.original_appointment_id|string if a.original_appointment_id else '—' }}</td>
            <td>{{ a.patient_name or '—' }}</td><td>{{ a.doctor_name or '—' }}</td>
            <td>{{ a.appointment_datetime[:10] if a.appointment_datetime else '—' }}</td>
            <td><span class="badge badge-{{ a.status|lower|replace(' ','-') if a.status else '' }}">{{ a.status or '—' }}</span></td>
            <td class="text-muted">{{ a.archived_at[:10] }}</td>
        </tr>{% endfor %}</tbody>
    </table></div>
    {% else %}<div class="empty-state"><div class="empty-icon">🗄</div><p>No archived records yet.</p></div>{% endif %}
</div>
{% endblock %}