{# 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.">strategy: ephemeral</span>
  {%- elif strategy == "incremental" -%}
    <span class="ui-pill ui-pill-success" title="Switch to materialized: incremental so rebuilds process only the delta.">strategy: 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.">strategy: 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.">strategy: materialized view</span>
  {%- else -%}
    <span class="ui-pill ui-pill-neutral">{{ strategy or "unspecified" }}</span>
  {%- endif -%}
{% endmacro %}

{# Renders the "why this fits" reasoning lines. Each attribute is one
   inline line: ``<label>:`` followed by the value text on the same
   row, wrapping naturally for long content. Lowercase labels per
   user feedback (spec 154 v3.3). Caveats fold in as the last line,
   joined when there's more than one. Renders nothing if the reasoning
   dict is absent, so older Opportunity rows from before this change
   degrade gracefully (still rare; cleared on next scan). #}
{% macro reasoning_block(reasoning, caveats=None) %}
  {% if reasoning %}
  <div class="mt-4 space-y-1.5 text-sm leading-relaxed">
    {% if reasoning.current_state_phrase %}
      <p><span class="font-bold text-slate-700 dark:text-slate-200">Current State:</span> <span class="text-slate-700 dark:text-slate-200">{{ reasoning.current_state_phrase }}</span></p>
    {% endif %}
    {% if reasoning.observation %}
      <p><span class="font-bold text-slate-700 dark:text-slate-200">Observation:</span> <span class="text-slate-700 dark:text-slate-200">{{ reasoning.observation }}</span></p>
    {% endif %}
    {% if reasoning.recommendation %}
      <p><span class="font-bold text-slate-700 dark:text-slate-200">Recommendation:</span> <span class="text-slate-700 dark:text-slate-200">{{ reasoning.recommendation }}</span></p>
    {% endif %}
    {% if reasoning.expected_benefit %}
      <p><span class="font-bold text-slate-700 dark:text-slate-200">Expected Benefit:</span> <span class="text-emerald-700 dark:text-emerald-300">{{ reasoning.expected_benefit }}</span></p>
    {% endif %}
    {% if caveats %}
      <p><span class="font-bold text-amber-700 dark:text-amber-300">Caveats:</span> <span class="text-slate-700 dark:text-slate-200">{{ caveats | join(" ") }}</span></p>
    {% endif %}
  </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 materialization strategy for this table's queries. Strategies: ephemeral (inline as CTE), incremental, table, materialized view. Each card explains the evidence behind the recommendation.",
       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="border border-slate-200 dark:border-slate-800 p-5 bg-white dark:bg-slate-950">
        <div class="flex flex-wrap items-center gap-2">
          {{ strategy_pill(_strategy) }}
          <span class="ui-pill ui-pill-neutral">audit-detected</span>
          <span class="font-mono text-sm text-slate-700 dark:text-slate-200">{{ cand.suggested_mv_name }}</span>
        </div>

        {{ reasoning_block(cand.reasoning, caveats=cand.safety_caveats) }}
      </div>

      {% elif _strategy == "ephemeral" %}
      <div class="border border-slate-200 dark:border-slate-800 p-5 bg-white dark:bg-slate-950">
        <div class="flex flex-wrap items-center gap-2">
          {{ strategy_pill(_strategy) }}
          <span class="ui-pill ui-pill-neutral">audit-detected</span>
          {% if cand.dbt_node_id %}
            <span class="font-mono text-sm text-slate-700 dark:text-slate-200">{{ cand.dbt_node_id }}</span>
          {% endif %}
        </div>

        {{ 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-3 text-sm">
          <span class="font-medium text-slate-600 dark:text-slate-300">downstream consumers:</span>
          <span class="font-mono text-slate-700 dark:text-slate-200">{{ cand.downstream_dbt_node_ids | join(", ") }}</span>
        </div>
        {% endif %}
      </div>

      {% elif _strategy == "table" %}
      <div class="border border-slate-200 dark:border-slate-800 p-5 bg-white dark:bg-slate-950">
        <div class="flex flex-wrap items-center gap-2">
          {{ strategy_pill(_strategy) }}
          <span class="ui-pill ui-pill-neutral">audit-detected</span>
        </div>

        {{ reasoning_block(cand.reasoning, caveats=cand.caveats) }}
      </div>

      {% elif _strategy == "incremental" %}
      <div class="border border-slate-200 dark:border-slate-800 p-5 bg-white dark:bg-slate-950">
        <div class="flex flex-wrap items-center gap-2">
          {{ strategy_pill(_strategy) }}
          <span class="ui-pill ui-pill-neutral">audit-detected</span>
          {% if cand.dbt_node_id %}
            <span class="font-mono text-sm text-slate-700 dark:text-slate-200">{{ cand.dbt_node_id }}</span>
          {% endif %}
        </div>

        {{ reasoning_block(cand.reasoning, caveats=cand.caveats) }}
      </div>

      {% else %}
      {# Unknown strategy - render a minimal fallback so we never
         silently swallow an opportunity. #}
      <div class="border border-slate-200 dark:border-slate-800 p-5 bg-white dark:bg-slate-950">
        <div class="flex flex-wrap items-center gap-2">
          {{ strategy_pill(_strategy) }}
          <span class="ui-pill ui-pill-neutral">audit-detected</span>
        </div>
        <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="border border-slate-200 dark:border-slate-800 p-5 bg-white dark:bg-slate-950">
      <div class="flex flex-wrap items-center gap-2">
        {{ strategy_pill("materialized_view") }}
        <span class="ui-pill ui-pill-neutral">BigQuery Recommender</span>
        {% if rec.bq_recommendation_state %}
          <span class="ui-pill ui-pill-neutral">{{ rec.bq_recommendation_state }}</span>
        {% endif %}
        <span class="font-mono text-sm text-slate-700 dark:text-slate-200 break-all">{{ rec.target_table_full_name or rec.target_resource }}</span>
      </div>

      {% if rec.bq_description %}
      <blockquote class="mt-4 border-l-4 border-slate-300 dark:border-slate-700 pl-4 text-sm text-slate-700 dark:text-slate-300 italic whitespace-pre-line">
        {{ rec.bq_description }}
      </blockquote>
      {% endif %}

      {% if rec.bq_insights %}
      <div class="mt-4 border-t border-slate-200 dark:border-slate-800 pt-4">
        <p class="text-sm font-semibold text-slate-700 dark:text-slate-200">Paired insights</p>
        <ul class="mt-2 space-y-2 text-sm text-slate-700 dark:text-slate-300">
          {% for ins in rec.bq_insights %}
          <li class="flex items-start gap-2">
            <span class="ui-pill ui-pill-neutral mt-0.5 shrink-0">{{ ins.category }}</span>
            <span>{{ ins.description }}</span>
          </li>
          {% endfor %}
        </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 %}