{# PostGIS health card — only rendered when the extension is installed. #}
{% from "components/feedback.html" import badge %}
<div class="card" style="margin-bottom:18px">
    <div style="padding:12px 16px;border-bottom:1px solid var(--border);display:flex;align-items:center;justify-content:space-between;gap:8px">
        <div style="display:flex;align-items:center;gap:8px;font-weight:600;font-size:13px">
            <i data-lucide="map" style="width:14px;height:14px"></i>Spatial
            <span class="chip chip-neutral">PostGIS {{ postgis }}</span>
            <span class="chip chip-neutral">{{ columns | length }} geometry column{{ '' if columns | length == 1 else 's' }}</span>
        </div>
        {% if findings %}{{ badge(findings | length ~ " finding" ~ ('' if findings | length == 1 else 's'), "warning") }}{% else %}{{ badge("healthy", "success") }}{% endif %}
    </div>
    {% if findings %}
    <div style="padding:10px 16px;border-bottom:1px solid var(--border)">
        {% for f in findings %}
        <div style="display:flex;gap:10px;align-items:flex-start;padding:6px 0">
            <i data-lucide="{{ 'alert-triangle' if f.severity == 'warning' else 'circle-x' }}" style="width:14px;height:14px;flex-shrink:0;margin-top:2px;color:var({{ '--accent-amber' if f.severity == 'warning' else '--red' }})"></i>
            <div style="min-width:0">
                <div style="font-size:13px">{{ f.message }}</div>
                <code class="mono" style="font-size:11.5px;color:var(--fg-3);white-space:pre-wrap">{{ f.fix }}</code>
            </div>
        </div>
        {% endfor %}
    </div>
    {% endif %}
    <table class="dtable w-full">
        <thead><tr><th>Table</th><th>Column</th><th>Type</th><th>SRID</th><th>Rows</th><th>Index</th><th>Invalid</th><th>Extent</th><th></th></tr></thead>
        <tbody>
        {% for c in columns %}
            <tr>
                <td class="mono">{{ c.table }}</td>
                <td class="mono">{{ c.column }}</td>
                <td>{{ c.type }}</td>
                <td>{% if c.srid %}{{ c.srid }}{% else %}{{ badge("0", "warning") }}{% endif %}</td>
                <td class="mono">{{ "{:,}".format(c.approx_rows) }}</td>
                <td>{% if c.has_index %}{{ badge("GIST", "success") }}{% else %}{{ badge("none", "warning" if c.approx_rows >= 1000 else "info") }}{% endif %}</td>
                <td class="mono">{% if c.invalid is none %}—{% elif c.invalid %}<span style="color:var(--red)">{{ c.invalid }}</span>{% else %}0{% endif %}</td>
                <td class="mono" style="font-size:11px;color:var(--fg-3);max-width:260px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap" title="{{ c.extent or '' }}">{{ c.extent or '—' }}</td>
                <td style="text-align:right"><a class="btn btn-sm btn-ghost" title="Open a sample of this table on the map in Studio"
                       href="/studio?connection={{ conn_id }}&map=1&title={{ c.table | urlencode }}&sql={{ ('SELECT * FROM ' ~ c.table ~ ' LIMIT 500') | urlencode }}"><i data-lucide="map"></i></a></td>
            </tr>
        {% endfor %}
        </tbody>
    </table>
</div>