{% extends "pos/base.html" %}
{% block content %}

<style>
  .ed-page {
    padding: 28px 0;
  }

  .ed-card {
    border: 0;
    border-radius: 18px;
    box-shadow: 0 10px 30px rgba(15, 23, 42, 0.08);
    overflow: hidden;
  }

  .ed-header {
    background: linear-gradient(135deg, #111827, #374151);
    color: #fff;
    padding: 22px 24px;
  }

  .ed-title {
    font-size: 22px;
    font-weight: 800;
    margin: 0;
  }

  .ed-subtitle {
    margin: 6px 0 0;
    color: rgba(255, 255, 255, 0.75);
    font-size: 14px;
  }

  .ed-toolbar {
    background: #f8fafc;
    border-bottom: 1px solid #e5e7eb;
    padding: 16px 20px;
  }

  .ed-search {
    height: 42px;
    border-radius: 12px;
  }

  .ed-app-card {
    border: 1px solid #e5e7eb;
    border-radius: 16px;
    overflow: hidden;
    margin-bottom: 18px;
    background: #fff;
  }

  .ed-app-header {
    background: #f9fafb;
    border-bottom: 1px solid #e5e7eb;
    padding: 14px 16px;
    display: flex;
    align-items: center;
    justify-content: space-between;
    gap: 12px;
  }

  .ed-app-title {
    font-weight: 800;
    color: #111827;
    margin: 0;
    font-size: 16px;
  }

  .ed-app-meta {
    color: #6b7280;
    font-size: 12px;
    margin-top: 2px;
  }

  .ed-app-badge {
    background: #111827;
    color: #fff;
    padding: 5px 10px;
    border-radius: 999px;
    font-size: 12px;
    font-weight: 700;
  }

  .ed-table-item {
    border: 1px solid #e5e7eb;
    border-radius: 14px;
    padding: 13px 14px;
    height: 100%;
    transition: 0.15s ease;
    background: #fff;
  }

  .ed-table-item:hover {
    border-color: #9ca3af;
    box-shadow: 0 8px 18px rgba(15, 23, 42, 0.07);
    transform: translateY(-1px);
  }

  .ed-model-label {
    font-weight: 750;
    color: #111827;
    cursor: pointer;
  }

  .ed-model-key {
    font-size: 12px;
    color: #6b7280;
    margin-top: 4px;
    word-break: break-all;
  }

  .ed-danger-box {
    border: 1px solid #fecaca;
    background: #fff1f2;
    color: #991b1b;
    border-radius: 14px;
    padding: 12px 14px;
    font-size: 13px;
  }

  .ed-footer {
    background: #f8fafc;
    border-top: 1px solid #e5e7eb;
    padding: 16px 20px;
    display: flex;
    justify-content: space-between;
    gap: 12px;
    flex-wrap: wrap;
  }

  .ed-selected-count {
    font-size: 13px;
    color: #374151;
    font-weight: 700;
  }

  .ed-empty-state {
    display: none;
    text-align: center;
    color: #6b7280;
    padding: 28px;
  }

  .form-check-input {
    cursor: pointer;
  }
</style>

<div class="container ed-page">
  <div class="card ed-card">

    <div class="ed-header">
      <div class="d-flex justify-content-between align-items-start flex-wrap gap-3">
        <div>
          <h3 class="ed-title">Empty Tenant Database</h3>
          <p class="ed-subtitle">
            Select BusinessModel tables app-wise and clear only current tenant data.
          </p>
        </div>

        <div class="text-end">
          <div class="ed-app-badge">
            {{ total_tables }} Tables
          </div>
        </div>
      </div>
    </div>

    <form method="post" id="empty-db-form">
      {% csrf_token %}

      <div class="ed-toolbar">
        {% if messages %}
          <div class="mb-3">
            {% for m in messages %}
              <div class="alert alert-{{ m.tags|default:'info' }} mb-2">
                {{ m }}
              </div>
            {% endfor %}
          </div>
        {% endif %}

        <div class="row g-2 align-items-center">
          <div class="col-12 col-lg-6">
            <input
              type="text"
              id="search-box"
              class="form-control ed-search"
              placeholder="Search table, app, key, or database table..."
            >
          </div>

          <div class="col-12 col-lg-6 text-lg-end">
            <button type="button" id="toggle-all" class="btn btn-dark">
              Select All Visible
            </button>

            <button type="button" id="clear-all" class="btn btn-outline-secondary">
              Clear Selection
            </button>
          </div>
        </div>

        <div class="ed-danger-box mt-3">
          <strong>Warning:</strong>
          This will permanently delete selected tenant data. Related records will also be cleared because this action is designed for complete tenant reset.
        </div>
      </div>

      <div class="card-body p-3 p-lg-4">

        <div id="empty-state" class="ed-empty-state">
          No tables matched your search.
        </div>

        {% for app in grouped_apps %}
          <div
            class="ed-app-card app-group"
            data-app="{{ app.app_name|lower }} {{ app.app_label|lower }}"
          >
            <div class="ed-app-header">
              <div>
                <h5 class="ed-app-title">{{ app.app_name }}</h5>
                <div class="ed-app-meta">
                  App label: {{ app.app_label }} · {{ app.count }} table{{ app.count|pluralize }}
                </div>
              </div>

              <div class="d-flex align-items-center gap-2">
                <span class="ed-app-badge">{{ app.count }}</span>
                <button
                  type="button"
                  class="btn btn-sm btn-outline-dark app-select-btn"
                  data-app-label="{{ app.app_label }}"
                >
                  Select App
                </button>
              </div>
            </div>

            <div class="p-3">
              <div class="row row-cols-1 row-cols-md-2 row-cols-xl-3 g-3">
                {% for model in app.models %}
                  <div
                    class="col model-col"
                    data-search="{{ model.label|lower }} {{ model.key|lower }} {{ model.db_table|lower }} {{ model.app_name|lower }} {{ model.app_label|lower }}"
                    data-app-label="{{ model.app_label }}"
                  >
                    <div class="ed-table-item">
                      <div class="form-check">
                        <input
                          class="form-check-input model-checkbox"
                          type="checkbox"
                          name="models"
                          id="chk_{{ model.html_id }}"
                          value="{{ model.key }}"
                          data-app-label="{{ model.app_label }}"
                        >

                        <label class="form-check-label w-100" for="chk_{{ model.html_id }}">
                          <div class="ed-model-label">
                            {{ model.label }}
                          </div>

                          <div class="ed-model-key">
                            {{ model.key }}
                          </div>

                          <div class="ed-model-key">
                            DB: {{ model.db_table }}
                          </div>
                        </label>
                      </div>
                    </div>
                  </div>
                {% endfor %}
              </div>
            </div>
          </div>
        {% endfor %}

      </div>

      <div class="ed-footer">
        <div class="ed-selected-count">
          Selected: <span id="selected-count">0</span>
        </div>

        <button type="submit" class="btn btn-danger px-4" id="submit-btn">
          Clear Selected Tables
        </button>
      </div>
    </form>
  </div>
</div>

<script>
  (function() {
    const form = document.getElementById('empty-db-form');
    const searchBox = document.getElementById('search-box');
    const toggleBtn = document.getElementById('toggle-all');
    const clearBtn = document.getElementById('clear-all');
    const selectedCountEl = document.getElementById('selected-count');
    const emptyState = document.getElementById('empty-state');

    function getVisibleModelCols() {
      return Array.from(document.querySelectorAll('.model-col'))
        .filter(col => col.style.display !== 'none');
    }

    function getAllCheckboxes() {
      return Array.from(document.querySelectorAll('.model-checkbox'));
    }

    function updateSelectedCount() {
      const count = getAllCheckboxes().filter(chk => chk.checked).length;
      selectedCountEl.textContent = count;
    }

    function updateEmptyState() {
      const visibleCards = Array.from(document.querySelectorAll('.app-group'))
        .filter(group => group.style.display !== 'none');

      emptyState.style.display = visibleCards.length ? 'none' : 'block';
    }

    function refreshAppVisibility() {
      document.querySelectorAll('.app-group').forEach(group => {
        const visibleChildren = Array.from(group.querySelectorAll('.model-col'))
          .filter(col => col.style.display !== 'none');

        group.style.display = visibleChildren.length ? '' : 'none';
      });

      updateEmptyState();
    }

    searchBox.addEventListener('input', function() {
      const term = this.value.trim().toLowerCase();

      document.querySelectorAll('.model-col').forEach(col => {
        const haystack = col.dataset.search || '';
        col.style.display = haystack.includes(term) ? '' : 'none';
      });

      refreshAppVisibility();
    });

    toggleBtn.addEventListener('click', function() {
      const visibleCheckboxes = getVisibleModelCols()
        .map(col => col.querySelector('.model-checkbox'))
        .filter(Boolean);

      const allVisibleSelected = visibleCheckboxes.length > 0 &&
        visibleCheckboxes.every(chk => chk.checked);

      visibleCheckboxes.forEach(chk => {
        chk.checked = !allVisibleSelected;
      });

      updateSelectedCount();
    });

    clearBtn.addEventListener('click', function() {
      getAllCheckboxes().forEach(chk => {
        chk.checked = false;
      });

      updateSelectedCount();
    });

    document.querySelectorAll('.app-select-btn').forEach(btn => {
      btn.addEventListener('click', function() {
        const appLabel = this.dataset.appLabel;

        const appCheckboxes = Array.from(document.querySelectorAll(
          '.model-checkbox[data-app-label="' + appLabel + '"]'
        )).filter(chk => {
          const col = chk.closest('.model-col');
          return col && col.style.display !== 'none';
        });

        const allSelected = appCheckboxes.length > 0 &&
          appCheckboxes.every(chk => chk.checked);

        appCheckboxes.forEach(chk => {
          chk.checked = !allSelected;
        });

        this.textContent = allSelected ? 'Select App' : 'Unselect App';

        updateSelectedCount();
      });
    });

    getAllCheckboxes().forEach(chk => {
      chk.addEventListener('change', updateSelectedCount);
    });

    form.addEventListener('submit', function(e) {
      const selected = getAllCheckboxes().filter(chk => chk.checked).length;

      if (!selected) {
        e.preventDefault();
        alert('Please select at least one table.');
        return;
      }

      const ok = confirm(
        'Are you sure? This will permanently delete selected tenant data. This action cannot be undone.'
      );

      if (!ok) {
        e.preventDefault();
      }
    });

    updateSelectedCount();
    updateEmptyState();
  })();
</script>

{% endblock %}