{% extends "layout/base.html" %}

{% block title %}Orphaned Jobs Preview{% endblock %}

{% block content %}
<div class="d-flex justify-content-between align-items-center mb-4">
    <div>
      <h2>Orphaned Jobs Preview</h2>
      <p class="text-muted mb-0">Jobs without a valid customer link</p>
    </div>
    <a href="{{ url_for('main.settings', section='maintenance') }}" class="btn btn-outline-secondary">Back to Settings</a>
  </div>

  {% if orphaned_jobs %}
  <div class="alert alert-warning">
    <strong>⚠️ Warning:</strong> Found {{ orphaned_jobs|length }} orphaned job(s). Review the list below before deleting.
  </div>

  <div class="card mb-4">
    <div class="card-header d-flex justify-content-between align-items-center">
      <span>Orphaned Jobs List</span>
      <form method="post" action="{{ url_for('main.settings_jobs_delete_orphaned') }}" onsubmit="return confirm('Delete all {{ orphaned_jobs|length }} orphaned jobs and their emails? This cannot be undone.');">
        <button type="submit" class="btn btn-sm btn-danger">Delete All ({{ orphaned_jobs|length }} jobs)</button>
      </form>
    </div>
    <div class="card-body p-0">
      <div class="table-responsive">
        <table class="table table-hover mb-0">
          <thead>
            <tr>
              <th>Job Name</th>
              <th>Backup Software</th>
              <th>Backup Type</th>
              <th>Customer ID</th>
              <th class="text-end">Runs</th>
              <th class="text-end">Emails</th>
            </tr>
          </thead>
          <tbody>
            {% for job in orphaned_jobs %}
            <tr>
              <td>{{ job.job_name }}</td>
              <td>{{ job.backup_software }}</td>
              <td>{{ job.backup_type }}</td>
              <td>
                {% if job.customer_id %}
                  <span class="badge bg-danger">{{ job.customer_id }} (deleted)</span>
                {% else %}
                  <span class="badge bg-secondary">NULL</span>
                {% endif %}
              </td>
              <td class="text-end">{{ job.run_count }}</td>
              <td class="text-end">{{ job.mail_count }}</td>
            </tr>
            {% endfor %}
          </tbody>
          <tfoot>
            <tr class="table-light">
              <td colspan="4"><strong>Total</strong></td>
              <td class="text-end"><strong>{{ orphaned_jobs|sum(attribute='run_count') }}</strong></td>
              <td class="text-end"><strong>{{ orphaned_jobs|sum(attribute='mail_count') }}</strong></td>
            </tr>
          </tfoot>
        </table>
      </div>
    </div>
  </div>

  <div class="alert alert-info">
    <strong>ℹ️ What will be deleted:</strong>
    <ul class="mb-0">
      <li>{{ orphaned_jobs|length }} job(s)</li>
      <li>{{ orphaned_jobs|sum(attribute='run_count') }} job run(s)</li>
      <li>{{ orphaned_jobs|sum(attribute='mail_count') }} email(s)</li>
      <li>All related data (backup objects, ticket/remark links, scopes, overrides)</li>
    </ul>
  </div>

  {% else %}
  <div class="alert alert-success">
    <strong>✅ No orphaned jobs found.</strong>
    <p class="mb-0">All jobs are properly linked to existing customers.</p>
  </div>
  {% endif %}
{% endblock %}