{% extends 'generic/object.html' %}
{% load helpers %}
{% load plugins %}
{% load i18n %}

{% block content %}
<div class="row mb-3">
  <div class="col col-md-6">
    <div class="card">
      <h5 class="card-header">{% trans "Health Summary" %}</h5>
      <div class="card-body">
        <div class="mb-3">
          <a class="btn btn-sm btn-outline-primary" href="{% url 'plugins:forward_netbox:forwardsync_source_health' pk=object.pk %}">
            {% trans "Export Live Source Check" %}
          </a>
          <a class="btn btn-sm btn-outline-primary ms-2" href="{% url 'plugins:forward_netbox:forwardsync_pushdown_trends' pk=object.pk %}?limit=180">
            {% trans "Export Pushdown Trends" %}
          </a>
          <span class="text-muted ms-2">
            {% trans "Export source reachability diagnostics and long-window pushdown trend history." %}
          </span>
        </div>
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Source" %}</th>
            <td><a href="{{ object.source.get_absolute_url }}">{{ health.source.name }}</a></td>
          </tr>
          <tr>
            <th scope="row">{% trans "Source status" %}</th>
            <td>{{ health.source.status }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Source URL" %}</th>
            <td>{{ health.source.url }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Execution backend" %}</th>
            <td>{{ health.runtime.execution_backend }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Branching available" %}</th>
            <td>{{ health.runtime.branching_available|yesno:"Yes,No" }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Max changes per branch" %}</th>
            <td>{{ health.runtime.max_changes_per_branch }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Forward API timeout" %}</th>
            <td>{{ health.runtime.source_timeout_seconds|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Worker timeout" %}</th>
            <td>{{ health.runtime.rq_default_timeout_seconds|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Pushdown alert thresholds" %}</th>
            <td>
              {% with thresholds=health.runtime.pushdown_alert_thresholds %}
                fallback={{ thresholds.fallback_warn_rate|placeholder }},
                runtime={{ thresholds.runtime_fallback_warn_share|placeholder }},
                diff={{ thresholds.diff_warn_ratio|placeholder }}
              {% endwith %}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "Snapshot selection" %}</th>
            <td>{{ health.runtime.snapshot_selector|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Next run" %}</th>
            <td>
              <div>{{ health.next_run.message }}</div>
              {% if health.next_run.blockers %}
                <ul class="mb-0 ps-3">
                  {% for blocker in health.next_run.blockers %}
                    <li>{{ blocker.message }}</li>
                  {% endfor %}
                </ul>
              {% endif %}
            </td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Forward API Usage" %}</h5>
      <div class="card-body">
        {% if health.api_usage.available %}
          {% with budget=health.api_usage.budget counters=health.api_usage.counters metrics=health.api_usage.budget.metrics %}
            <table class="table table-hover attr-table">
              <tr>
                <th scope="row">{% trans "Budget status" %}</th>
                <td>
                  {% if budget.status == "passed" %}
                    <span class="badge text-bg-success">{% trans "Pass" %}</span>
                  {% elif budget.status == "failed" %}
                    <span class="badge text-bg-danger">{% trans "Fail" %}</span>
                  {% elif budget.status == "warning" %}
                    <span class="badge text-bg-warning">{% trans "Warn" %}</span>
                  {% else %}
                    <span class="badge text-bg-secondary">{{ budget.status|placeholder }}</span>
                  {% endif %}
                </td>
              </tr>
              <tr>
                <th scope="row">{% trans "Configured rate" %}</th>
                <td>{{ metrics.configured_requests_per_minute|placeholder }} / {{ metrics.hard_block_requests_per_minute|placeholder }} rpm</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Observed rate" %}</th>
                <td>
                  {{ metrics.observed_http_attempts_per_minute|placeholder }} rpm
                  {% if metrics.observed_rate_sample_complete %}
                    <span class="text-muted">({% trans "sampled" %})</span>
                  {% endif %}
                </td>
              </tr>
              <tr>
                <th scope="row">{% trans "HTTP attempts" %}</th>
                <td>{{ counters.http_attempts|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "HTTP 429 failures" %}</th>
                <td>{{ counters.http_429_failures|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "NQE calls" %}</th>
                <td>
                  query={{ counters.nqe_query_calls|placeholder }},
                  diff={{ counters.nqe_diff_calls|placeholder }},
                  pages={{ counters.nqe_pages|placeholder }}
                </td>
              </tr>
              <tr>
                <th scope="row">{% trans "Throttle sleep" %}</th>
                <td>{{ metrics.throttle_sleep_seconds|placeholder }} s</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Query parameters" %}</th>
                <td>
                  {% with param_summary=health.api_usage.step_query_parameters %}
                    {% if param_summary.available %}
                      {{ param_summary.step_count }} {% trans "step(s) with explicit parameters" %}
                      <ul class="mb-0 ps-3">
                        {% for item in param_summary.top_steps %}
                          <li>
                            {{ item.model }} / {{ item.query_name }}:
                            {{ item.query_parameters }}
                          </li>
                        {% endfor %}
                      </ul>
                    {% else %}
                      <span class="text-muted">{% trans "No explicit step query parameters recorded." %}</span>
                    {% endif %}
                  {% endwith %}
                </td>
              </tr>
              {% if budget.warnings %}
                <tr>
                  <th scope="row">{% trans "Warnings" %}</th>
                  <td>{{ budget.warnings }}</td>
                </tr>
              {% endif %}
              {% if budget.failure_reasons %}
                <tr>
                  <th scope="row">{% trans "Failure reasons" %}</th>
                  <td>{{ budget.failure_reasons }}</td>
                </tr>
              {% endif %}
            </table>
          {% endwith %}
        {% else %}
          <p class="text-muted mb-0">
            {% trans "No stored Forward API usage evidence is available for the latest execution run." %}
          </p>
        {% endif %}
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Dependency Lookup Cache" %}</h5>
      <div class="card-body">
        {% if health.dependency_lookup_cache.available %}
          <table class="table table-hover attr-table">
            <tr>
              <th scope="row">{% trans "Models primed" %}</th>
              <td>{{ health.dependency_lookup_cache.model_count|placeholder }}</td>
            </tr>
            <tr>
              <th scope="row">{% trans "Rows processed" %}</th>
              <td>{{ health.dependency_lookup_cache.row_count|placeholder }}</td>
            </tr>
            <tr>
              <th scope="row">{% trans "Primed targets" %}</th>
              <td>{{ health.dependency_lookup_cache.primed_target_count|placeholder }}</td>
            </tr>
          </table>
          {% if health.dependency_lookup_cache.models %}
            <div class="small text-muted mb-2">{% trans "Top primed models" %}</div>
            <ul class="mb-0 ps-3">
              {% for item in health.dependency_lookup_cache.models %}
                <li>
                  {{ item.model }}:
                  {{ item.row_count }} {% trans "rows" %},
                  {{ item.primed_target_count }} {% trans "primed targets" %}
                  {% if item.fhrp_group_count %}
                    ,
                    {{ item.fhrp_group_count }} {% trans "FHRP groups" %}
                  {% endif %}
                </li>
              {% endfor %}
            </ul>
          {% endif %}
        {% else %}
          <p class="text-muted mb-0">
            {% trans "No dependency lookup cache evidence is available for the latest execution run." %}
          </p>
        {% endif %}
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Optional Plugin Capabilities" %}</h5>
      <div class="card-body">
        {% for integration_key, integration in health.optional_plugin_capabilities_ui.items %}
          <div class="mb-4">
            <div class="small text-muted mb-2">
              {{ integration.display_name|default:integration_key }}
            </div>
            <table class="table table-hover attr-table">
              <tr>
                <th scope="row">{% trans "Integration" %}</th>
                <td>{{ integration.app_label|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Installed" %}</th>
                <td>{{ integration.installed|yesno:"Yes,No" }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Installed version" %}</th>
                <td>{{ integration.version|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Minimum version" %}</th>
                <td>{{ integration.minimum_version|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Package names" %}</th>
                <td>{{ integration.package_names|join:", " }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Detected package" %}</th>
                <td>{{ integration.installed_package_name|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Available" %}</th>
                <td>{{ integration.available|yesno:"Yes,No" }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Availability status" %}</th>
                <td>{{ integration.availability_status|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Availability reason" %}</th>
                <td>{{ integration.availability_reason|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Unsupported version" %}</th>
                <td>{{ integration.unsupported_version|yesno:"Yes,No" }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Required models missing" %}</th>
                <td>{{ integration.missing_required|length }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Optional models missing" %}</th>
                <td>{{ integration.missing_optional|length }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Command inventory entries" %}</th>
                <td>{{ integration.command_inventory_count }}</td>
              </tr>
            </table>
            {% if integration.missing_required %}
              <div class="small text-muted mb-2">{% trans "Missing required models" %}</div>
              <ul class="mb-0 ps-3">
                {% for model in integration.missing_required %}
                  <li>{{ model }}</li>
                {% endfor %}
              </ul>
            {% endif %}
            {% if integration.missing_optional %}
              <div class="small text-muted mt-3 mb-2">{% trans "Missing optional models" %}</div>
              <ul class="mb-0 ps-3">
                {% for model in integration.missing_optional %}
                  <li>{{ model }}</li>
                {% endfor %}
              </ul>
            {% endif %}
            {% if integration.command_inventory %}
              <div class="small text-muted mt-3 mb-2">{% trans "Command inventory" %}</div>
              <ul class="mb-0 ps-3">
                {% for command in integration.command_inventory %}
                  <li>
                    {{ command.command_type }}
                    <span class="text-muted">
                      - {{ command.status|default:"unknown" }}
                      {% if command.source %}
                        - {{ command.source }}
                      {% endif %}
                    </span>
                  </li>
                {% endfor %}
              </ul>
            {% endif %}
          </div>
        {% empty %}
          <p class="text-muted mb-0">{% trans "No optional plugin capability evidence is available." %}</p>
        {% endfor %}
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Checks" %}</h5>
      <div class="table-responsive">
        <table class="table table-hover">
          <thead>
            <tr>
              <th>{% trans "Check" %}</th>
              <th>{% trans "Status" %}</th>
              <th>{% trans "Message" %}</th>
            </tr>
          </thead>
          <tbody>
            {% for check in health.checks %}
              <tr>
                <td>{{ check.name }}</td>
                <td>
                  {% if check.status == "pass" %}
                    <span class="badge text-bg-success">{% trans "Pass" %}</span>
                  {% elif check.status == "fail" %}
                    <span class="badge text-bg-danger">{% trans "Fail" %}</span>
                  {% elif check.status == "warn" %}
                    <span class="badge text-bg-warning">{% trans "Warn" %}</span>
                  {% else %}
                    <span class="badge text-bg-secondary">{% trans "Info" %}</span>
                  {% endif %}
                </td>
                <td>{{ check.message }}</td>
              </tr>
            {% empty %}
              <tr>
                <td colspan="3" class="text-muted">{% trans "No checks available" %}</td>
              </tr>
            {% endfor %}
          </tbody>
        </table>
      </div>
    </div>
    {% plugin_left_page object %}
  </div>
  <div class="col col-md-6">
    <div class="card">
      <h5 class="card-header">{% trans "Query Binding" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Raw query maps" %}</th>
            <td>{{ health.query_modes.query }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Direct query ID maps" %}</th>
            <td>{{ health.query_modes.query_id }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Repository path maps" %}</th>
            <td>{{ health.query_modes.query_path }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Diff-capable maps" %}</th>
            <td>{{ health.query_modes.diff_capable }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Data-file-dependent maps" %}</th>
            <td>
              {{ health.query_modes.data_file_maps|length }}
              {% if health.query_modes.data_file_maps %}
                <a class="btn btn-sm btn-outline-primary ms-2" href="{% url 'plugins:forward_netbox:forwardsync_data_file_health' pk=object.pk %}">
                  {% trans "Export Live Data File Check" %}
                </a>
              {% endif %}
            </td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Query Path Resolution" %}</h5>
      <div class="card-body">
        {% with resolution=health.query_path_resolution %}
          {% if resolution.available %}
            <table class="table table-hover attr-table">
              <tr>
                <th scope="row">{% trans "Query path specs" %}</th>
                <td>{{ resolution.total_query_path_specs|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Artifact hits" %}</th>
                <td>{{ resolution.artifact_hit_count|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Repository index reads" %}</th>
                <td>{{ resolution.repository_index_count|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Forward lookups" %}</th>
                <td>{{ resolution.client_resolve_count|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Cache hit rate" %}</th>
                <td>{{ resolution.cache_hit_rate|placeholder }}</td>
              </tr>
            </table>
          {% else %}
            <p class="text-muted mb-0">
              {% trans "No query-path resolution telemetry is available for the latest execution run." %}
            </p>
          {% endif %}
        {% endwith %}
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Query Drift Summary" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Maps assessed" %}</th>
            <td>{{ health.query_drift_summary.total_maps|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Warn / info / pass" %}</th>
            <td>
              {{ health.query_drift_summary.warn_count }}/{{ health.query_drift_summary.info_count }}/{{ health.query_drift_summary.pass_count }}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "Remediation actions" %}</th>
            <td>
              {% if health.query_drift_summary.remediation_actions %}
                <ul class="mb-0 ps-3">
                  {% for item in health.query_drift_summary.remediation_actions %}
                    <li>{{ item.count }} - {{ item.message }}</li>
                  {% endfor %}
                </ul>
              {% else %}
                <span class="text-muted">{% trans "No remediation actions emitted." %}</span>
              {% endif %}
            </td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Live Query Drift" %}</h5>
      <div class="card-body">
        {% with live_query_drift=live_diagnostics.query_drift %}
          {% if live_diagnostics.available and live_query_drift.available %}
            <table class="table table-hover attr-table">
              <tr>
                <th scope="row">{% trans "Maps checked" %}</th>
                <td>{{ live_query_drift.live_summary.total_maps|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Live checked" %}</th>
                <td>{{ live_query_drift.live_summary.checked_maps|placeholder }}</td>
              </tr>
              <tr>
                <th scope="row">{% trans "Warn / info / pass" %}</th>
                <td>
                  {{ live_query_drift.live_summary.warn_count }}/{{ live_query_drift.live_summary.info_count }}/{{ live_query_drift.live_summary.pass_count }}
                </td>
              </tr>
              <tr>
                <th scope="row">{% trans "Direct query ID warnings" %}</th>
                <td>
                  {{ live_query_drift.live_summary.query_id_warn_count|placeholder }}
                  {% if live_query_drift.live_summary.query_id_not_found_count or live_query_drift.live_summary.query_id_ambiguous_count or live_query_drift.live_summary.query_id_modified_count %}
                    <span class="text-muted">
                      (
                      {% trans "not found" %}: {{ live_query_drift.live_summary.query_id_not_found_count|placeholder }},
                      {% trans "ambiguous" %}: {{ live_query_drift.live_summary.query_id_ambiguous_count|placeholder }},
                      {% trans "modified" %}: {{ live_query_drift.live_summary.query_id_modified_count|placeholder }}
                      )
                    </span>
                  {% endif %}
                </td>
              </tr>
              <tr>
                <th scope="row">{% trans "Lookup errors" %}</th>
                <td>{{ live_query_drift.live_summary.lookup_error_count|placeholder }}</td>
              </tr>
            </table>
            {% if live_query_drift.live_summary.error %}
              <p class="text-warning mb-0">
                {% trans "Live query drift summary error" %}: {{ live_query_drift.live_summary.error }}
              </p>
            {% endif %}
          {% else %}
            <p class="text-muted mb-0">
              {% if live_diagnostics.message %}
                {{ live_diagnostics.message }}
              {% else %}
                {% trans "Live Forward query-drift diagnostics are unavailable." %}
              {% endif %}
            </p>
          {% endif %}
        {% endwith %}
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Local Query Drift" %}</h5>
      <div class="card-body border-bottom">
        <a class="btn btn-sm btn-outline-primary" href="{% url 'plugins:forward_netbox:forwardsync_query_drift' pk=object.pk %}">
          {% trans "Export Live Query Drift Check" %}
        </a>
        <form method="post" action="{% url 'plugins:forward_netbox:forwardsync_refresh_query_ids' pk=object.pk %}" class="d-inline ms-2">
          {% csrf_token %}
          <button type="submit" class="btn btn-sm btn-outline-secondary">
            {% trans "Refresh Query IDs" %}
          </button>
        </form>
        <span class="text-muted ms-2">
          {% trans "Export diagnostics, or refresh enabled maps to the canonical validation-folder query IDs." %}
        </span>
      </div>
      <div class="table-responsive">
        <table class="table table-hover">
          <thead>
            <tr>
              <th>{% trans "Map" %}</th>
              <th>{% trans "Mode" %}</th>
              <th>{% trans "Commit" %}</th>
              <th>{% trans "Status" %}</th>
              <th>{% trans "Message" %}</th>
              <th>{% trans "Remediation" %}</th>
            </tr>
          </thead>
          <tbody>
            {% for item in health.query_modes.local_drift %}
              <tr>
                <td>{{ item.name }}</td>
                <td>{{ item.mode }}</td>
                <td>{{ item.commit_message }}</td>
                <td>
                  {% if item.severity == "pass" %}
                    <span class="badge text-bg-success">{{ item.status }}</span>
                  {% elif item.severity == "warn" %}
                    <span class="badge text-bg-warning">{{ item.status }}</span>
                  {% else %}
                    <span class="badge text-bg-secondary">{{ item.status }}</span>
                  {% endif %}
                </td>
                <td>{{ item.message }}</td>
                <td>{{ item.remediation|default:"" }}</td>
              </tr>
            {% empty %}
              <tr>
                <td colspan="6" class="text-muted">{% trans "No local query drift diagnostics available" %}</td>
              </tr>
            {% endfor %}
          </tbody>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Apply Engines" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Selected engines" %}</th>
            <td>{{ health.apply_engines.selected }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Fallback reasons" %}</th>
            <td>{{ health.apply_engines.fallback_reasons }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Bulk ORM expansion" %}</th>
            <td>{{ health.apply_engines.bulk_orm_expansion.status }} - {{ health.apply_engines.bulk_orm_expansion.message }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Blocked models" %}</th>
            <td>{{ health.apply_engines.bulk_orm_expansion.blocked_model_count }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Parity gates" %}</th>
            <td>{{ health.apply_engines.bulk_orm_expansion.parity_gates|length }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Next parity target" %}</th>
            <td>
              {% with candidate=health.apply_engines.bulk_orm_expansion.parity_plan.candidates.0 %}
                {% if candidate %}
                  {{ candidate.model }} - {{ candidate.promotion_lane }} ({{ candidate.lane_gate }})
                {% else %}
                  {% trans "No blocked candidates" %}
                {% endif %}
              {% endwith %}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "Parity plan" %}</th>
            <td>{{ health.apply_engines.bulk_orm_expansion.parity_plan.status }} - {{ health.apply_engines.bulk_orm_expansion.parity_plan.next_action }}</td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Fetch Contracts" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Fetch modes" %}</th>
            <td>{{ health.fetch_contracts.modes }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Shard-safe models" %}</th>
            <td>{{ health.fetch_contracts.shard_safe_count }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Model-fetch fallbacks" %}</th>
            <td>{{ health.fetch_contracts.model_fallback_count }}</td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Query Runtime & Pushdown" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Summary" %}</th>
            <td>{{ health.query_pushdown.message }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Stage steps profiled" %}</th>
            <td>{{ health.query_pushdown.total_stage_steps|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Fetch modes observed" %}</th>
            <td>{{ health.query_pushdown.fetch_mode_counts }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Fallback steps" %}</th>
            <td>{{ health.query_pushdown.fallback_step_count|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Fallback reasons" %}</th>
            <td>{{ health.query_pushdown.fallback_reasons|default:"[]" }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Pushdown rate" %}</th>
            <td>{{ health.query_pushdown.efficiency.pushdown_rate|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Fallback rate" %}</th>
            <td>{{ health.query_pushdown.efficiency.fallback_rate|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Efficiency advisory" %}</th>
            <td>{{ health.query_pushdown.efficiency.message|default:"" }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Fallback runtime share" %}</th>
            <td>{{ health.query_pushdown.runtime_share.fallback_runtime_share|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Full-fallback runtime share" %}</th>
            <td>{{ health.query_pushdown.runtime_share.full_fallback_runtime_share|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Diff actual ratio" %}</th>
            <td>{{ health.query_pushdown.diff_utilization.diff_actual_ratio|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Baseline to diff" %}</th>
            <td>{{ health.query_pushdown.diff_baseline_transition.message|default:"" }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Tuning guidance" %}</th>
            <td>
              {% if health.query_pushdown.tuning_guidance %}
                <ul class="mb-0 ps-3">
                  {% for item in health.query_pushdown.tuning_guidance %}
                    <li>{{ item.message }}</li>
                  {% endfor %}
                </ul>
              {% else %}
                <span class="text-muted">{% trans "No tuning guidance emitted for this run." %}</span>
              {% endif %}
            </td>
          </tr>
        </table>
      </div>
      <div class="table-responsive">
        <table class="table table-hover">
          <thead>
            <tr>
              <th>{% trans "Model" %}</th>
              <th>{% trans "Query runtime (ms)" %}</th>
              <th>{% trans "Fetched rows" %}</th>
              <th>{% trans "Steps" %}</th>
              <th>{% trans "Fallback steps" %}</th>
              <th>{% trans "Fetch modes" %}</th>
            </tr>
          </thead>
          <tbody>
            {% for item in health.query_pushdown.slow_models %}
              <tr>
                <td>{{ item.model }}</td>
                <td>{{ item.query_runtime_ms|placeholder }}</td>
                <td>{{ item.fetched_row_count|placeholder }}</td>
                <td>{{ item.steps|placeholder }}</td>
                <td>{{ item.fallback_steps|placeholder }}</td>
                <td>{{ item.fetch_modes }}</td>
              </tr>
            {% empty %}
              <tr>
                <td colspan="6" class="text-muted">{% trans "No stage query runtime samples are available yet" %}</td>
              </tr>
            {% endfor %}
          </tbody>
        </table>
      </div>
      <div class="table-responsive">
        <table class="table table-hover">
          <thead>
            <tr>
              <th>{% trans "Run" %}</th>
              <th>{% trans "Status" %}</th>
              <th>{% trans "Fallback rate" %}</th>
              <th>{% trans "Full-fallback runtime share" %}</th>
              <th>{% trans "Diff actual ratio" %}</th>
              <th>{% trans "Diff baseline correlation" %}</th>
            </tr>
          </thead>
          <tbody>
            {% for item in health.query_pushdown.trend_snapshots %}
              <tr>
                <td>{{ item.run_id }}</td>
                <td>{{ item.status }}</td>
                <td>{{ item.fallback_rate|placeholder }}</td>
                <td>{{ item.full_fallback_runtime_share|placeholder }}</td>
                <td>{{ item.diff_actual_ratio|placeholder }}</td>
                <td>{{ item.baseline_reason_summary|default:"" }}</td>
              </tr>
            {% empty %}
              <tr>
                <td colspan="6" class="text-muted">{% trans "No pushdown trend snapshots are available yet" %}</td>
              </tr>
            {% endfor %}
          </tbody>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Compatibility Cache" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Summary" %}</th>
            <td>{{ health.compatibility_cache.message }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Ledger history exists" %}</th>
            <td>{{ health.compatibility_cache.ledger_history|yesno:"Yes,No" }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Active execution run" %}</th>
            <td>{{ health.compatibility_cache.active_execution_run|yesno:"Yes,No" }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Compatibility payload present" %}</th>
            <td>{{ health.compatibility_cache.compatibility_state_present|yesno:"Yes,No" }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Compatibility payload keys" %}</th>
            <td>{{ health.compatibility_cache.compatibility_state_size|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Prune recommended" %}</th>
            <td>{{ health.compatibility_cache.prune_recommended|yesno:"Yes,No" }}</td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Collection Gap" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Backfilled devices" %}</th>
            <td>
              {% if health.collection_gap.status == "danger" %}
                <span class="badge text-bg-danger">{{ health.collection_gap.backfilled_count }}</span>
              {% elif health.collection_gap.status == "warn" %}
                <span class="badge text-bg-warning">{{ health.collection_gap.backfilled_count }}</span>
              {% else %}
                <span class="badge text-bg-success">{{ health.collection_gap.backfilled_count }}</span>
              {% endif %}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "Status" %}</th>
            <td>{{ health.collection_gap.message }}</td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Density Learning" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Tracked models" %}</th>
            <td>{{ health.density_learning.model_count|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "High confidence models" %}</th>
            <td>{{ health.density_learning.high_confidence_count|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Medium confidence models" %}</th>
            <td>{{ health.density_learning.medium_confidence_count|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Low confidence models" %}</th>
            <td>{{ health.density_learning.low_confidence_count|placeholder }}</td>
          </tr>
        </table>
      </div>
      <div class="table-responsive">
        <table class="table table-hover">
          <thead>
            <tr>
              <th>{% trans "Model" %}</th>
              <th>{% trans "Learned density" %}</th>
              <th>{% trans "Default density" %}</th>
              <th>{% trans "Samples" %}</th>
              <th>{% trans "Confidence" %}</th>
            </tr>
          </thead>
          <tbody>
            {% for item in health.density_learning.models %}
              <tr>
                <td>{{ item.model }}</td>
                <td>{{ item.learned_density|placeholder }}</td>
                <td>{{ item.default_density|placeholder }}</td>
                <td>{{ item.sample_count|placeholder }}</td>
                <td>{{ item.confidence|placeholder }}</td>
              </tr>
            {% empty %}
              <tr>
                <td colspan="5" class="text-muted">{% trans "No density learning samples are available yet" %}</td>
              </tr>
            {% endfor %}
          </tbody>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Latest State" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Latest validation" %}</th>
            <td>
              {% if health.latest_validation %}
                {{ health.latest_validation.status }}{% if health.latest_validation.allowed %} ({% trans "allowed" %}){% endif %}
              {% else %}
                {{ ""|placeholder }}
              {% endif %}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "Latest ingestion" %}</th>
            <td>
              {% if health.latest_ingestion %}
                {{ health.latest_ingestion.name }}{% if health.latest_ingestion.baseline_ready %} ({% trans "baseline ready" %}{% if health.latest_ingestion.sync_mode %}, {% trans "sync mode" %}: {{ health.latest_ingestion.sync_mode }}{% endif %}){% elif health.latest_ingestion.sync_mode %} ({% trans "sync mode" %}: {{ health.latest_ingestion.sync_mode }}){% endif %}
              {% else %}
                {{ ""|placeholder }}
              {% endif %}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "Latest execution run" %}</th>
            <td>
              {% if health.latest_execution_run %}
                {{ health.latest_execution_run.status }} - {{ health.latest_execution_run.phase|placeholder }}
              {% else %}
                {{ ""|placeholder }}
              {% endif %}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "Recovery recommendation" %}</th>
            <td>
              {% if health.latest_execution_run %}
                {{ health.latest_execution_run.recovery_recommendation.message }}
              {% else %}
                {{ ""|placeholder }}
              {% endif %}
            </td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Large Run Tuning" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Status" %}</th>
            <td>{{ health.large_run_tuning.status|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Summary" %}</th>
            <td>{{ health.large_run_tuning.message }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Query fetch concurrency" %}</th>
            <td>{{ health.large_run_tuning.query_fetch_concurrency|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Worker timeout seconds" %}</th>
            <td>{{ health.large_run_tuning.worker_timeout_seconds|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Backend advice" %}</th>
            <td>{{ health.large_run_tuning.execution_backend_advice.message|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Adaptive capacity" %}</th>
            <td>{{ health.large_run_tuning.adaptive_capacity.message|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Scheduler overlap readiness" %}</th>
            <td>
              {{ health.large_run_tuning.scheduler_overlap_readiness.message|placeholder }}
              {% with readiness=health.large_run_tuning.scheduler_overlap_readiness %}
                {% if readiness.hotspot_models %}
                  <ul class="mb-0 ps-3">
                    {% for item in readiness.hotspot_models|slice:":3" %}
                      <li>
                        {{ item.model }}:
                        {{ item.wait_seconds }}s wait,
                        {{ item.wait_share }} share
                      </li>
                    {% endfor %}
                  </ul>
                {% endif %}
              {% endwith %}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "Next tuning batch" %}</th>
            <td>
              {% with batch=health.large_run_tuning.adaptive_capacity.next_tuning_batch %}
                {% if batch %}
                  <ul class="mb-0 ps-3">
                    <li>{% trans "Workers" %}: {{ batch.worker_count.current|placeholder }} -> {{ batch.worker_count.recommended|placeholder }}</li>
                    <li>{% trans "Query fetch concurrency" %}: {{ batch.query_fetch_concurrency.current|placeholder }} -> {{ batch.query_fetch_concurrency.recommended|placeholder }}</li>
                    <li>{% trans "NQE page size" %}: {{ batch.nqe_page_size.current|placeholder }} -> {{ batch.nqe_page_size.recommended|placeholder }}</li>
                    <li>{{ batch.restart_scope }}; {% trans "hold minutes" %}: {{ batch.hold_minutes }}</li>
                  </ul>
                {% else %}
                  <span class="text-muted">{% trans "No adaptive capacity batch is available yet." %}</span>
                {% endif %}
              {% endwith %}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "First actions" %}</th>
            <td>
              {% if health.large_run_tuning.first_order_actions %}
                <ul class="mb-0 ps-3">
                  {% for item in health.large_run_tuning.first_order_actions %}
                    <li>{{ item.message }}</li>
                  {% endfor %}
                </ul>
              {% else %}
                <span class="text-muted">{% trans "No large-run tuning actions are available yet." %}</span>
              {% endif %}
            </td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Delete Wave" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Phase" %}</th>
            <td>{{ health.delete_wave.phase|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Summary" %}</th>
            <td>{{ health.delete_wave.message }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Planned delete rows" %}</th>
            <td>{{ health.delete_wave.plan.delete_rows|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Delete share" %}</th>
            <td>{{ health.delete_wave.plan.delete_share|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Delete shards" %}</th>
            <td>{{ health.delete_wave.plan.delete_shards|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Warning codes" %}</th>
            <td>{{ health.delete_wave.warning_codes|join:", "|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Delete execution order" %}</th>
            <td>{{ health.delete_wave.plan.execution_order|join:", "|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "High-risk models" %}</th>
            <td>
              {% if health.delete_wave.high_risk_models %}
                <ul class="mb-0 ps-3">
                  {% for item in health.delete_wave.high_risk_models %}
                    <li>
                      {{ item.model }}:
                      {{ item.reference_blocker_risk }},
                      {{ item.delete_rows }} {% trans "rows" %}
                    </li>
                  {% endfor %}
                </ul>
              {% else %}
                <span class="text-muted">{% trans "No elevated delete-risk models are recorded." %}</span>
              {% endif %}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "Dependency skip issues" %}</th>
            <td>{{ health.delete_wave.latest_ingestion.dependency_skip_issues.count|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Delete step status" %}</th>
            <td>
              {{ health.delete_wave.steps.completed_delete_step_count|placeholder }}/{{ health.delete_wave.steps.delete_step_count|placeholder }}
              {% trans "terminal" %}
            </td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      <h5 class="card-header">{% trans "Run Throughput & Capacity" %}</h5>
      <div class="card-body">
        <table class="table table-hover attr-table">
          <tr>
            <th scope="row">{% trans "Throughput summary" %}</th>
            <td>{{ health.throughput.message }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Queue / merge smoothing" %}</th>
            <td>{{ health.throughput.throughput_smoothing.message|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Dominant wait component" %}</th>
            <td>{{ health.throughput.scheduler_overlap_dominant_wait_component|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Current shard" %}</th>
            <td>{{ health.throughput.current_shard_index|placeholder }}/{{ health.throughput.total_shards|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Shards per hour" %}</th>
            <td>
              1h={{ health.throughput.shards_per_hour_1h|placeholder }},
              6h={{ health.throughput.shards_per_hour_6h|placeholder }}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "ETA range" %}</th>
            <td>{{ health.throughput.eta_seconds_low|placeholder }} - {{ health.throughput.eta_seconds_high|placeholder }} seconds</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Active step age" %}</th>
            <td>{{ health.throughput.active_step_age_seconds|placeholder }} seconds</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Issue rate" %}</th>
            <td>{{ health.throughput.issue_rate_per_hour|placeholder }} / hour</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Bottleneck phase" %}</th>
            <td>{{ health.throughput.bottleneck_phase|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Runtime knobs" %}</th>
            <td>
              query_fetch_concurrency={{ health.throughput.query_fetch_concurrency|placeholder }},
              nqe_page_size={{ health.throughput.nqe_page_size|placeholder }},
              worker_timeout={{ health.throughput.worker_timeout_seconds|placeholder }}
            </td>
          </tr>
          <tr>
            <th scope="row">{% trans "Completed steps" %}</th>
            <td>{{ health.capacity.completed_steps|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Remaining steps" %}</th>
            <td>{{ health.capacity.remaining_steps|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Average shard seconds" %}</th>
            <td>{{ health.capacity.average_completed_step_seconds|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Max shard seconds" %}</th>
            <td>{{ health.capacity.max_completed_step_seconds|placeholder }}</td>
          </tr>
          <tr>
            <th scope="row">{% trans "Projection" %}</th>
            <td>{{ health.capacity.message }}</td>
          </tr>
        </table>
      </div>
    </div>
    <div class="card">
      {% include 'extras/inc/configcontext_data.html' with title="Health Details" data=health format="json" copyid="forward-sync-health-details" %}
    </div>
    {% plugin_right_page object %}
  </div>
</div>
{% endblock content %}