{% extends 'dashboard/base.html' %}
{% block title %}Database Backup{% endblock %}
{% block content %}
<div class="sp-topbar">
  <div>
    <h1>Database Backup</h1>
    <p class="sp-muted">Create and download full backups of your website database. Limited to {{ max_per_day }} backups a day to save server resources.</p>
  </div>
</div>

<div class="sp-card" style="max-width:640px;">
  <h2>Run a Backup</h2>
  <p class="sp-muted">
    {% if runs_remaining > 0 %}
      You have <strong>{{ runs_remaining }}</strong> of {{ max_per_day }} backup{{ max_per_day|pluralize }} left today.
    {% else %}
      You've used all {{ max_per_day }} backups for today. The limit resets at midnight.
    {% endif %}
  </p>
  <form method="post" {% if runs_remaining > 0 %}data-sp-confirm="This will create a new database backup now. Continue?" data-sp-confirm-title="Run backup now?"{% endif %}>
    {% csrf_token %}
    <button type="submit" class="sp-btn sp-btn-primary" {% if runs_remaining <= 0 %}disabled{% endif %}>
      <i class="fa-solid fa-database"></i> Run Backup Now
    </button>
  </form>
</div>

<div class="sp-card" style="margin-top:24px;">
  <h2>Backup History</h2>
  <table class="sp-table">
    <thead><tr><th>Date</th><th>Status</th><th>Size</th><th>Triggered By</th><th></th></tr></thead>
    <tbody>
      {% for b in backups %}
      <tr>
        <td>{{ b.created_at|date:"M j, Y g:i A" }}</td>
        <td>
          {% if b.status == 'success' %}<span class="sp-pill sp-pill-blue">Success</span>
          {% elif b.status == 'running' %}<span class="sp-pill sp-pill-gray">Running</span>
          {% else %}<span class="sp-pill sp-pill-gray" title="{{ b.error_message }}">Failed</span>{% endif %}
        </td>
        <td class="sp-muted">
          {% if b.size_bytes %}{{ b.size_bytes|filesizeformat }}{% else %}&mdash;{% endif %}
        </td>
        <td class="sp-muted">{{ b.triggered_by.email|default:"—" }}</td>
        <td>
          {% if b.status == 'success' %}
          <a href="{% url 'dashboard_database_backup_download' b.id %}" class="sp-btn sp-btn-sm">
            <i class="fa-solid fa-download"></i> Download
          </a>
          {% endif %}
          <form method="post" action="{% url 'dashboard_database_backup_delete' b.id %}" style="display:inline;" data-sp-confirm="This cannot be undone." data-sp-confirm-title="Delete this backup?">
            {% csrf_token %}
            <button type="submit" class="sp-btn sp-btn-sm sp-btn-danger"><i class="fa-solid fa-trash"></i></button>
          </form>
        </td>
      </tr>
      {% empty %}
      <tr><td colspan="5" class="sp-empty">No backups yet. Run your first backup above.</td></tr>
      {% endfor %}
    </tbody>
  </table>
</div>
{% endblock %}