{# Spec 154 v3 - materialization section rendered on the opportunity
   detail page.

   Fires when one or more of this table's opportunities carries a
   materialization payload - either an audit-detected candidate
   (``materialization_candidate``, possibly with any of the four
   strategies below) or Google's MV Recommender pass-through
   (``bq_materialization_recommendation``).

   The audit-detected card branches on ``recommended_strategy``:
     * ``materialized_view`` - full MV card with generated SQL tabs
       and the stat strip (cost / executions / avg bytes).
     * ``ephemeral``         - inline-as-CTE card with the dbt node id
       + the downstream models that would absorb the inline.
     * ``table``             - persist-as-table card with build vs.
       read counts.
     * ``incremental``       - switch-to-incremental card with the
       representative build SQL so the user can see the filter the
       fitter matched.

   Inputs from the route:
     ``audit_mv_candidates``  - list of evidence_snapshot dicts (one
        per audit-detected opportunity on this table); each carries
        a ``recommended_strategy`` field.
     ``bq_mv_recommendations`` - list of dicts (BQ Recommender rows)
        each with: target_resource, target_table_full_name,
        bq_description, bq_recommendation_state, bq_insights[],
        last_refresh_time

   Renders nothing when both lists are empty, so the partial can be
   included unconditionally from detail.html. #}

{% macro strategy_pill(strategy) %}
  {%- if strategy == "ephemeral" -%}
    <span class="ui-pill ui-pill-neutral" title="Inline this SQL as a CTE in your downstream model(s) - no persisted table.">ephemeral</span>
  {%- elif strategy == "incremental" -%}
    <span class="ui-pill ui-pill-success" title="Switch to materialized: incremental so rebuilds process only the delta.">incremental</span>
  {%- elif strategy == "table" -%}
    <span class="ui-pill ui-pill-success" title="Persist the result as a table - currently read often but rebuilt rarely.">table</span>
  {%- elif strategy == "materialized_view" -%}
    <span class="ui-pill ui-pill-success" title="Wrap the query in a CREATE MATERIALIZED VIEW so BigQuery caches and incrementally refreshes the result.">materialized view</span>
  {%- else -%}
    <span class="ui-pill ui-pill-neutral">{{ strategy or "unspecified" }}</span>
  {%- endif -%}
{% endmacro %}

{% macro strategy_heading(strategy) %}
  {%- if strategy == "ephemeral" -%}
    Inline this model
  {%- elif strategy == "incremental" -%}
    Switch to incremental
  {%- elif strategy == "table" -%}
    Keep this persisted as a table
  {%- elif strategy == "materialized_view" -%}
    Create a materialized view
  {%- else -%}
    Review materialization
  {%- endif -%}
{% endmacro %}

{% macro strategy_summary(strategy) %}
  {%- if strategy == "ephemeral" -%}
    Remove the persisted intermediate table and let the downstream model absorb the SQL as a CTE.
  {%- elif strategy == "incremental" -%}
    Avoid rebuilding the full table when the query shape supports processing only new or changed rows.
  {%- elif strategy == "table" -%}
    Keep the table materialized because reads justify the storage and rebuild cost.
  {%- elif strategy == "materialized_view" -%}
    Cache the query result behind BigQuery refresh semantics when the repeated query pattern is stable.
  {%- else -%}
    Review the evidence before changing how this object is persisted.
  {%- endif -%}
{% endmacro %}

{% macro candidate_header(strategy, source_label, object_label=None, state=None) %}
  <div class="flex flex-col gap-3 sm:flex-row sm:items-start sm:justify-between">
    <div class="min-w-0">
      <h3 class="text-base font-semibold text-slate-900 dark:text-slate-100">{{ strategy_heading(strategy) }}</h3>
      <div class="mt-2 flex flex-wrap items-center gap-2">
        {{ strategy_pill(strategy) }}
        <span class="ui-pill ui-pill-neutral">{{ source_label }}</span>
        {% if state %}
          <span class="ui-pill ui-pill-neutral">{{ state }}</span>
        {% endif %}
      </div>
      {% if object_label %}
        <p class="mt-2 max-w-3xl font-mono text-sm text-slate-700 dark:text-slate-200 break-all">{{ object_label }}</p>
      {% endif %}
    </div>
  </div>
{% endmacro %}

{# Concise decision block. The raw evidence payload has four verbose
   fields; the UI only needs the three decision points a reviewer acts
   on: why this surfaced, what to do, and what changes if they do it.
   Caveats stay as one compact "Check" line. #}
{% macro reasoning_block(reasoning, caveats=None) %}
  {% if reasoning %}
  <div class="mt-4 grid gap-4 lg:grid-cols-3">
    {% if reasoning.observation %}
      <div class="min-w-0">
        <p class="ui-card-label">Evidence</p>
        <p class="mt-2 text-sm text-slate-700 dark:text-slate-200 leading-relaxed">{{ reasoning.observation }}</p>
      </div>
    {% endif %}
    {% if reasoning.recommendation %}
      <div class="min-w-0">
        <p class="ui-card-label">Action</p>
        <p class="mt-2 text-sm text-slate-700 dark:text-slate-200 leading-relaxed">{{ reasoning.recommendation }}</p>
      </div>
    {% endif %}
    {% if reasoning.expected_benefit %}
      <div class="min-w-0">
        <p class="ui-card-label">Impact</p>
        <p class="mt-2 text-sm text-emerald-700 dark:text-emerald-300 leading-relaxed">{{ reasoning.expected_benefit }}</p>
      </div>
    {% endif %}
  </div>
  {% endif %}
  {% if caveats %}
  <div class="mt-4 flex flex-col gap-1 border-t border-slate-200 dark:border-slate-800 pt-3 sm:flex-row sm:items-start">
    <p class="ui-card-label text-amber-700 dark:text-amber-300 sm:w-16 sm:shrink-0">Check</p>
    <p class="text-sm text-slate-700 dark:text-slate-200 leading-relaxed">
      {{ caveats[0] }}
      {% if caveats | length > 1 %}
        <span class="text-slate-500 dark:text-slate-400">+{{ caveats | length - 1 }} more</span>
      {% endif %}
    </p>
  </div>
  {% endif %}
{% endmacro %}

{% if audit_mv_candidates or bq_mv_recommendations %}
{% from "components/_section_title.html" import section_title %}
<div class="ui-surface p-6">
  {{ section_title(
       "Materialization",
       description="Recommended way to persist this object, based on rebuild cost, read patterns, and downstream use.",
       aside=((audit_mv_candidates | length + bq_mv_recommendations | length) ~ (' candidate' if (audit_mv_candidates | length + bq_mv_recommendations | length) == 1 else ' candidates'))
  ) }}

  <div class="mt-5 space-y-5">

    {# ─── Audit-detected candidates ────────────────────────────── #}
    {% for cand in audit_mv_candidates %}
      {% set _strategy = cand.recommended_strategy or "materialized_view" %}

      {% if _strategy == "materialized_view" %}
      {# MV card. Spec 154 v3.3: just the reasoning block; no SQL panel
         and no stat-strip cards. The numbers live in the observation
         line; the user looks at this surface to decide whether to
         act, not to copy SQL. #}
      <div class="ui-subcard">
        {{ candidate_header(_strategy, "audit-detected", cand.suggested_mv_name) }}
        {{ reasoning_block(cand.reasoning, caveats=cand.safety_caveats) }}
      </div>

      {% elif _strategy == "ephemeral" %}
      <div class="ui-subcard">
        {{ candidate_header(_strategy, "audit-detected", cand.dbt_node_id) }}
        {{ reasoning_block(cand.reasoning, caveats=cand.caveats) }}

        {# Downstream-consumer list is distinct content (node names),
           not in the observation prose, so it stays. #}
        {% if cand.downstream_dbt_node_ids %}
        <div class="mt-4 flex flex-col gap-2 border-t border-slate-200 dark:border-slate-800 pt-3 sm:flex-row sm:items-center">
          <p class="ui-card-label sm:w-28 sm:shrink-0">Consumers</p>
          <div class="flex flex-wrap gap-2">
            {% for downstream in cand.downstream_dbt_node_ids[:3] %}
              <span class="ui-pill ui-pill-neutral font-mono">{{ downstream }}</span>
            {% endfor %}
            {% if cand.downstream_dbt_node_ids | length > 3 %}
              <span class="ui-pill ui-pill-neutral">+{{ cand.downstream_dbt_node_ids | length - 3 }} more</span>
            {% endif %}
          </div>
        </div>
        {% endif %}
      </div>

      {% elif _strategy == "table" %}
      <div class="ui-subcard">
        {{ candidate_header(_strategy, "audit-detected") }}
        {{ reasoning_block(cand.reasoning, caveats=cand.caveats) }}
      </div>

      {% elif _strategy == "incremental" %}
      <div class="ui-subcard">
        {{ candidate_header(_strategy, "audit-detected", cand.dbt_node_id) }}
        {{ reasoning_block(cand.reasoning, caveats=cand.caveats) }}
      </div>

      {% else %}
      {# Unknown strategy - render a minimal fallback so we never
         silently swallow an opportunity. #}
      <div class="ui-subcard">
        {{ candidate_header(_strategy, "audit-detected") }}
        <pre class="mt-4 text-sm text-slate-600 dark:text-slate-400 font-mono whitespace-pre-wrap break-all">{{ cand | tojson(indent=2) }}</pre>
      </div>
      {% endif %}
    {% endfor %}

    {# ─── BigQuery's MV Recommender pass-through ──────────────── #}
    {% for rec in bq_mv_recommendations %}
    <div class="ui-subcard">
      {{ candidate_header("materialized_view", "BigQuery Recommender", rec.target_table_full_name or rec.target_resource, rec.bq_recommendation_state) }}
      {% if rec.bq_description %}
      <p class="mt-4 max-w-4xl text-sm text-slate-700 dark:text-slate-300 leading-relaxed whitespace-pre-line">
        {{ rec.bq_description }}
      </p>
      {% endif %}

      {% if rec.bq_insights %}
      <div class="mt-4 flex flex-col gap-2 border-t border-slate-200 dark:border-slate-800 pt-3 sm:flex-row sm:items-start">
        <p class="ui-card-label sm:w-20 sm:shrink-0">Insights</p>
        <ul class="space-y-2 text-sm text-slate-700 dark:text-slate-300">
          {% for ins in rec.bq_insights[:2] %}
          <li class="flex flex-wrap items-center gap-2">
            <span class="ui-pill ui-pill-neutral mt-0.5 shrink-0">{{ ins.category }}</span>
            <span>{{ ins.description }}</span>
          </li>
          {% endfor %}
          {% if rec.bq_insights | length > 2 %}
          <li class="text-slate-500 dark:text-slate-400">+{{ rec.bq_insights | length - 2 }} more insights</li>
          {% endif %}
        </ul>
      </div>
      {% endif %}

      {% if rec.last_refresh_time %}
      <p class="mt-3 text-sm text-slate-500 dark:text-slate-400">Last refreshed by Google's Recommender: {{ rec.last_refresh_time }}</p>
      {% endif %}
    </div>
    {% endfor %}

  </div>
</div>
{% endif %}