{#
  The columns page's body — crate::pages::admin::table_definition::ui::ColumnsFragment.
  Both writes on this page swap it, so it carries the outcome as well as the
  forms.
#}
{% include "pages/admin/table_definition/feedback.html" %}

{% if page.table_is_writable() %}
  {#
    Append columns. The panel stages columns without writing anything; the
    selection travels in the URL so the posted fields are exactly the ones the
    Add-table builder posts, and both are decoded by the same code.
  #}
  <section class="panel">
    <h2>Add columns to <code>{{ page.selection.table }}</code></h2>
    <p class="hint">Columns are appended. Nothing that already exists is changed, and the new columns can be indexed as they are added.</p>
    <form id="column-form"
          hx-post="/admin/tables/columns{{ page.selection.query() }}"
          hx-target="#table-panel" hx-swap="innerHTML"
          hx-disabled-elt="button[type=submit]">
      <div id="column-panel">
        {% include "pages/admin/table_definition/column_panel.html" %}
      </div>
    </form>
  </section>

  {% if let Some(detail) = page.detail %}
    <section class="panel">
      <h2>Rename a column</h2>
      <p class="hint">Renames what the column is called, not the physical column underneath, so stored data and scripts are untouched. Only possible while the table has no rows.</p>
      <form hx-post="/admin/tables/rename"
            hx-target="#table-panel" hx-swap="innerHTML">
        <input type="hidden" name="profile" value="{{ page.selection.profile }}">
        <input type="hidden" name="table" value="{{ page.selection.table }}">
        <div class="form-grid">
          <label>Column
            <select name="old_column_name">
              <option value="">Choose a column</option>
              {% for column in detail.renameable_columns() %}
                <option value="{{ column.name }}" {% if page.rename.old_column_name == column.name %}selected{% endif %}>{{ column.name }}</option>
              {% endfor %}
            </select>
          </label>
          <label>New name
            <input name="new_column_name" value="{{ page.rename.new_column_name }}" placeholder="invoice_number">
          </label>
        </div>
        <div class="form-actions">
          <button type="submit">Rename column</button>
        </div>
      </form>
    </section>
  {% endif %}
{% endif %}

{% if let Some(detail) = page.detail %}
  <section class="panel">
    <h2>Columns it has now <span class="count">{{ detail.columns.len() }}</span></h2>
    <table class="builder-table">
      <thead><tr><th>Column</th><th>Type</th><th>Notes</th></tr></thead>
      <tbody>
        {% for column in detail.columns %}
          <tr>
            <td><code>{{ column.name }}</code></td>
            <td>{{ column.field_type }}{% if !column.sql_type.is_empty() %} <small class="hint">{{ column.sql_type }}</small>{% endif %}</td>
            <td>
              {%- for flag in column.flags() %}<span class="tag">{{ flag }}</span>{% endfor -%}
            </td>
          </tr>
        {% endfor %}
      </tbody>
    </table>

    {% if !detail.scripts.is_empty() %}
      <h3 class="panel-subhead">Scripts</h3>
      <table class="builder-table">
        <thead><tr><th>Target column</th><th>Type</th><th>Description</th></tr></thead>
        <tbody>
          {% for script in detail.scripts %}
            <tr>
              <td><code>{{ script.target_column }}</code></td>
              <td>{{ script.target_column_type }}</td>
              <td>
                {{ script.description }}
                <details><summary>source</summary><pre class="sql-preview">{{ script.script }}</pre></details>
              </td>
            </tr>
          {% endfor %}
        </tbody>
      </table>
    {% endif %}
  </section>
{% endif %}