{# Spec 151 - table-level layout recommendations index.

   One row per qualifying table from the latest scan. Replaces the
   spec-148 per-opportunity card surface; the opportunity detail
   page now shows a chip linking to /recommendations/layout/<table>.

   Index columns:
     - Table (clickable → detail page)
     - Current layout (chip: "partitioned" / "unpartitioned")
     - Recommended partition column (or "-")
     - Top cluster picks (chip list, up to 4)
     - Window cost (cost in scan window)
#}
{% extends "layout.html" %}

{% block content %}
<section class="ui-shell">
  <div class="ui-page-header">
    <h1 class="ui-page-title">Partition &amp; Cluster</h1>
  </div>

  {% if not has_latest_scan %}
    <div class="ui-pane mt-8 text-base text-slate-700 dark:text-slate-300">
      <p>No successful scan yet. <a href="/admin/configurations" class="underline decoration-dotted text-brand-600 dark:text-brand-300">Run a scan</a> first - layout recommendations are derived from the workload the scan observes.</p>
    </div>
  {% elif not recommendations %}
    <div class="ui-pane mt-8 text-base text-slate-700 dark:text-slate-300 space-y-3">
      <p>The latest scan didn't surface any tables that meet the layout-recommendation gates. This happens when:</p>
      <ul class="list-disc pl-5 space-y-1">
        <li>No table in the scan window is large enough to justify a partition / cluster change (we use BigQuery's own ≥&nbsp;10&nbsp;GB threshold for clustering and ≥&nbsp;100&nbsp;GB for partitioning).</li>
        <li>Consumer queries don't filter / join / group on enough common columns to give a confident signal.</li>
        <li>Tables that <em>are</em> queried hard are already optimally laid out.</li>
      </ul>
      <p>Run a longer-lookback scan if you suspect there's signal we're missing.</p>
    </div>
  {% else %}
    <div class="ui-pane mt-8">
      <table class="ui-table">
        <thead>
          <tr class="ui-table-head-row">
            <th class="ui-table-th ui-table-th-left">Table</th>
            <th class="ui-table-th ui-table-th-left">Current</th>
            <th class="ui-table-th ui-table-th-left">Recommended partition</th>
            <th class="ui-table-th ui-table-th-left">Recommended cluster</th>
            <th class="ui-table-th ui-table-th-right">Window cost</th>
            <th class="ui-table-th ui-table-th-right">Jobs</th>
          </tr>
        </thead>
        <tbody>
          {% for rec in recommendations %}
            {% set _row_href = '/recommendations/layout/' ~ (rec.table_full_name | urlencode) %}
            <tr class="ui-table-row cursor-pointer"
                tabindex="0"
                role="link"
                aria-label="Open recommendation for {{ rec.table_full_name }}"
                onclick="window.location='{{ _row_href }}'"
                onkeydown="if (event.key === 'Enter' || event.key === ' ') { event.preventDefault(); window.location='{{ _row_href }}'; }">
              <td class="ui-table-td text-left">
                <div class="flex items-center gap-2 flex-wrap">
                  <span class="font-mono text-sm text-brand-600 dark:text-brand-300">{{ rec.table_full_name }}</span>
                  {# "BQ only" pill marks rows that exist solely because
                     Google's recommender flagged the table - the audit
                     itself didn't analyze it (under size gates or sparse
                     query history). Distinguishes them from audit+BQ
                     rows whose cells just happen to be empty for other
                     reasons. #}
                  {% if rec.is_bq_only %}
                    <span class="ui-pill ui-pill-neutral">BQ only</span>
                  {% endif %}
                </div>
                <div class="text-sm text-slate-500 dark:text-slate-400 mt-0.5">{{ rec.table_total_bytes | format_bytes }}</div>
              </td>
              <td class="ui-table-td text-left">
                {% if rec.is_bq_only %}
                  {# Current state is unknown for BQ-only rows - the
                     audit didn't query the table's schema. Avoid
                     rendering a definitive "unpartitioned" chip. #}
                  <span class="inline-flex items-center gap-1.5 text-sm text-slate-400 dark:text-slate-500">
                    <span class="w-1.5 h-1.5 rounded-full bg-slate-300 dark:bg-slate-600"></span>
                    unknown
                  </span>
                {% elif rec.is_currently_partitioned %}
                  <span class="inline-flex items-center gap-1.5 text-sm text-emerald-700 dark:text-emerald-300">
                    <span class="w-1.5 h-1.5 rounded-full bg-emerald-500 dark:bg-emerald-400"></span>
                    partitioned
                  </span>
                {% else %}
                  <span class="inline-flex items-center gap-1.5 text-sm text-slate-500 dark:text-slate-400">
                    <span class="w-1.5 h-1.5 rounded-full bg-slate-400 dark:bg-slate-500"></span>
                    unpartitioned
                  </span>
                {% endif %}
              </td>
              <td class="ui-table-td text-left font-mono text-sm">
                {% if rec.recommended_partition_column %}
                  <span class="text-slate-900 dark:text-slate-100">{{ rec.recommended_partition_column }}</span>
                {% elif rec.is_bq_only and rec.bq_columns %}
                  {# Surface BQ's first column as the partition pick on
                     BQ-only rows. Approximate - Google's recommender
                     doesn't strictly distinguish partition vs cluster
                     in its column list - but better than rendering "-". #}
                  <span class="text-slate-700 dark:text-slate-300">{{ rec.bq_columns[0] }}</span>
                {% else %}
                  <span class="text-slate-400 dark:text-slate-500">-</span>
                {% endif %}
              </td>
              <td class="ui-table-td text-left">
                {% if rec.cluster_picks %}
                  <div class="flex flex-wrap gap-1.5">
                    {% for col in rec.cluster_picks %}
                      <span class="font-mono text-sm px-2 py-0.5 border border-slate-200 dark:border-slate-700 text-slate-700 dark:text-slate-300 bg-slate-50 dark:bg-slate-800/40">{{ col }}</span>
                    {% endfor %}
                  </div>
                {% elif rec.is_bq_only and rec.bq_columns | length > 1 %}
                  <div class="flex flex-wrap gap-1.5">
                    {% for col in rec.bq_columns[1:5] %}
                      <span class="font-mono text-sm px-2 py-0.5 border border-slate-200 dark:border-slate-700 text-slate-700 dark:text-slate-300 bg-slate-50 dark:bg-slate-800/40">{{ col }}</span>
                    {% endfor %}
                  </div>
                {% else %}
                  <span class="text-slate-400 dark:text-slate-500">-</span>
                {% endif %}
              </td>
              <td class="ui-table-td text-right font-mono text-sm">{{ rec.table_total_cost_in_window_usd | format_usd }}</td>
              <td class="ui-table-td text-right text-sm text-slate-500 dark:text-slate-400">{{ rec.contributing_job_count }}</td>
            </tr>
          {% endfor %}
        </tbody>
      </table>
      {# Layout recommendations are one row per table by definition
         (the table-level partition / cluster pick). #}
      {% with pagination_item_noun = "tables" %}
        {% include "components/_pagination.html" %}
      {% endwith %}
    </div>
  {% endif %}
</section>
{% endblock %}