{# US3 - deep-analysis dry-run confirm fragment.

   Standalone page (full layout) for v1; a future iteration can move
   this to a datastar-py inline swap. The form POSTs to
   ``/deep/run`` with the ack'd cost as a hidden field so the route
   can detect cost drift between preview and run. #}
{% extends "layout.html" %}

{% block content %}
<section class="ui-shell">
  <div class="ui-page-header">
    <p class="text-sm uppercase tracking-wider text-slate-500 dark:text-slate-400">Deep analysis &mdash; confirm cost</p>
    <h1 class="ui-page-title font-mono text-xl break-all">{{ table_full_name }} &middot; {{ column_name }}</h1>
    <p class="text-sm text-slate-500 dark:text-slate-400 mt-1">
      <a href="/recommendations/layout/{{ table_full_name | urlencode }}" class="underline decoration-dotted">&larr; back to layout detail</a>
    </p>
  </div>

  {% if error %}
    <div class="ui-pane mt-6 border-amber-300 dark:border-amber-700 bg-amber-50 dark:bg-amber-950/30">
      <p class="text-sm font-semibold uppercase tracking-wider text-amber-700 dark:text-amber-300 mb-1.5">Re-confirm required</p>
      <p class="text-sm text-amber-800 dark:text-amber-200">{{ error }}</p>
    </div>
  {% endif %}

  {% if preview %}
    <div class="ui-pane mt-6">
      <p class="text-sm uppercase tracking-wider text-slate-500 dark:text-slate-400">Estimated BigQuery cost</p>
      <p class="text-3xl font-semibold text-slate-900 dark:text-slate-100 mt-2"
         data-dry-run-usd="{{ '%.6f' | format(preview.estimated_cost_usd) }}">
        {{ preview.estimated_cost_usd | format_usd }}
      </p>
      <p class="text-sm text-slate-500 dark:text-slate-400 mt-1">
        Based on a BigQuery dry-run of the two queries below
        (~{{ preview.estimated_bytes_processed | format_bytes }} to scan).
        No chargeable query has run yet.
      </p>

      <div class="mt-6 space-y-3">
        <div>
          <p class="text-sm uppercase tracking-wider text-slate-500 dark:text-slate-400 mb-1.5">Query 1 &mdash; distinct count</p>
          <pre class="text-sm font-mono text-slate-800 dark:text-slate-200 bg-slate-50 dark:bg-slate-900 p-3 overflow-x-auto border border-slate-200 dark:border-slate-800">{{ preview.distinct_count_sql }}</pre>
        </div>
        <div>
          <p class="text-sm uppercase tracking-wider text-slate-500 dark:text-slate-400 mb-1.5">Query 2 &mdash; top 20 values by frequency</p>
          <pre class="text-sm font-mono text-slate-800 dark:text-slate-200 bg-slate-50 dark:bg-slate-900 p-3 overflow-x-auto border border-slate-200 dark:border-slate-800">{{ preview.top_values_sql }}</pre>
        </div>
      </div>

      <form method="post"
            action="/recommendations/layout/{{ table_full_name | urlencode }}/deep/run"
            class="mt-6 flex items-center gap-3">
        <input type="hidden" name="column_name" value="{{ column_name }}" />
        <input type="hidden" name="acknowledged_cost_usd" value="{{ '%.6f' | format(preview.estimated_cost_usd) }}" />
        <button type="submit"
                class="ui-btn-primary inline-flex items-center px-4 py-2 text-sm font-medium">
          Run analysis ({{ preview.estimated_cost_usd | format_usd }})
        </button>
        <a href="/recommendations/layout/{{ table_full_name | urlencode }}"
           class="text-sm text-slate-500 dark:text-slate-400 hover:text-slate-700 dark:hover:text-slate-200">Cancel</a>
      </form>

      <p class="text-sm text-slate-400 mt-4 italic">
        Results are cached per (table, column) within this scan &mdash; running
        once and re-clicking later this scan won't charge again.
      </p>
    </div>
  {% endif %}
</section>
{% endblock %}