<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="robots" content="noindex, nofollow">
<title>Metrics Dashboard — sfpermits.ai</title>
{% include "fragments/head_obsidian.html" %}
<style nonce="{{ csp_nonce }}">
/* Section badges */
.section-badge {
font-size: 0.7rem; background: var(--bg-elevated); color: var(--text-secondary);
padding: 2px 8px; border-radius: 6px; border: 1px solid rgba(255,255,255,0.08);
font-family: var(--font-mono);
}
/* SLA color coding */
.sla-good { color: var(--signal-green); font-weight: 600; }
.sla-warn { color: var(--signal-amber); font-weight: 600; }
.sla-bad { color: var(--signal-red); font-weight: 600; }
/* Data tables */
.data-table { width: 100%; border-collapse: collapse; font-size: var(--text-sm); }
.data-table th {
text-align: left; padding: 8px 12px; background: transparent;
color: var(--text-secondary); font-weight: 600; font-size: 0.72rem;
text-transform: uppercase; letter-spacing: 0.05em;
border-bottom: 1px solid rgba(255,255,255,0.06);
font-family: var(--font-body);
}
.data-table td {
padding: 8px 12px; border-bottom: 1px solid rgba(255,255,255,0.04);
vertical-align: middle; color: var(--text-primary);
}
.data-table tr:hover td { background: var(--bg-elevated); }
.data-table .num { text-align: right; font-variant-numeric: tabular-nums; font-family: var(--font-mono); }
/* Table wrapper for overflow */
.table-wrap { overflow-x: auto; -webkit-overflow-scrolling: touch; }
/* Empty state */
.empty { text-align: center; padding: 40px 20px; color: var(--text-secondary); }
</style>
</head>
<body class="obsidian">
{% include 'fragments/nav.html' %}
<main style="padding: var(--space-10) 0 var(--space-16);">
<div class="obs-container">
<p style="margin-bottom: var(--space-4);">
<a href="/admin/ops" style="color: var(--signal-cyan); text-decoration: none; font-size: var(--text-sm);">← Back to Operations</a>
</p>
<div class="glass-card" style="margin-bottom: var(--space-6);">
<h1 style="font-family: var(--font-display); font-size: var(--text-2xl); font-weight: 700; color: var(--text-primary); margin-bottom: var(--space-2);">
<span style="font-size:0.65rem;background:var(--bg-elevated);color:var(--text-secondary);padding:3px 8px;border-radius:8px;border:1px solid rgba(255,255,255,0.08);vertical-align:middle;margin-right:8px; font-family: var(--font-body);">⚙ Admin</span>Metrics Dashboard
</h1>
<p style="color: var(--text-secondary); font-size: var(--text-sm);">Permit issuance trends, station SLA compliance, and planning velocity.</p>
<!-- Summary stat blocks -->
<div style="display: grid; grid-template-columns: repeat(auto-fill, minmax(180px, 1fr)); gap: var(--space-4); margin-top: var(--space-6);">
<div style="background: var(--bg-elevated); border: 1px solid rgba(255,255,255,0.06); border-radius: var(--card-radius); padding: var(--space-4);">
<div style="font-size: 0.75rem; color: var(--text-secondary); text-transform: uppercase; letter-spacing: 0.05em; margin-bottom: var(--space-2); font-family: var(--font-body);">Issuance Records</div>
<div style="font-family: var(--font-display); font-size: var(--text-2xl); font-weight: 700; color: var(--signal-cyan);">{{ issuance_rows|length }}</div>
</div>
<div style="background: var(--bg-elevated); border: 1px solid rgba(255,255,255,0.06); border-radius: var(--card-radius); padding: var(--space-4);">
<div style="font-size: 0.75rem; color: var(--text-secondary); text-transform: uppercase; letter-spacing: 0.05em; margin-bottom: var(--space-2); font-family: var(--font-body);">Stations Tracked</div>
<div style="font-family: var(--font-display); font-size: var(--text-2xl); font-weight: 700; color: var(--signal-cyan);">{{ sla_rows|length }}</div>
</div>
<div style="background: var(--bg-elevated); border: 1px solid rgba(255,255,255,0.06); border-radius: var(--card-radius); padding: var(--space-4);">
<div style="font-size: 0.75rem; color: var(--text-secondary); text-transform: uppercase; letter-spacing: 0.05em; margin-bottom: var(--space-2); font-family: var(--font-body);">Planning Stages</div>
<div style="font-family: var(--font-display); font-size: var(--text-2xl); font-weight: 700; color: var(--signal-cyan);">{{ planning_rows|length }}</div>
</div>
</div>
</div>
<!-- Section 1: Permit Issuance Trends -->
<div class="glass-card" style="margin-bottom: var(--space-6);" id="issuance">
<div style="display: flex; align-items: center; gap: var(--space-3); margin-bottom: var(--space-4);">
<h2 style="font-family: var(--font-display); font-size: var(--text-xl); font-weight: 600; color: var(--text-primary);">Permit Issuance Trends</h2>
<span class="section-badge">permit_issuance_metrics</span>
</div>
{% if issuance_rows %}
<div class="table-wrap">
<table class="data-table">
<thead>
<tr>
<th>Year</th>
<th>Month</th>
<th>Permit Type</th>
<th>OTC / In-House</th>
<th class="num">Count</th>
</tr>
</thead>
<tbody>
{% set month_names = {1:'Jan',2:'Feb',3:'Mar',4:'Apr',5:'May',6:'Jun',7:'Jul',8:'Aug',9:'Sep',10:'Oct',11:'Nov',12:'Dec'} %}
{% for row in issuance_rows[:100] %}
<tr>
<td>{{ row.year }}</td>
<td>{{ month_names.get(row.month|int, row.month) }}</td>
<td>{{ row.type or '—' }}</td>
<td>{{ row.otc_ih or '—' }}</td>
<td class="num">{{ '{:,}'.format(row.count) }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
{% if issuance_rows|length > 100 %}
<p style="color:var(--text-secondary);font-size:var(--text-sm);margin-top:8px;">Showing 100 of {{ issuance_rows|length }} rows.</p>
{% endif %}
{% else %}
<div class="empty">No issuance data available. Run the metrics ingest first.</div>
{% endif %}
</div>
<!-- Section 2: Station SLA Compliance -->
<div class="glass-card" style="margin-bottom: var(--space-6);" id="sla">
<div style="display: flex; align-items: center; gap: var(--space-3); margin-bottom: var(--space-4);">
<h2 style="font-family: var(--font-display); font-size: var(--text-xl); font-weight: 600; color: var(--text-primary);">Station SLA Compliance</h2>
<span class="section-badge">permit_review_metrics</span>
</div>
{% if sla_rows %}
<div class="table-wrap">
<table class="data-table">
<thead>
<tr>
<th>Station</th>
<th>Department</th>
<th class="num">Total Reviews</th>
<th class="num">Met SLA</th>
<th class="num">SLA %</th>
<th class="num">Avg Days</th>
</tr>
</thead>
<tbody>
{% for row in sla_rows %}
<tr>
<td>{{ row.station or '—' }}</td>
<td>{{ row.department or '—' }}</td>
<td class="num">{{ '{:,}'.format(row.total) }}</td>
<td class="num">{{ '{:,}'.format(row.met_sla) }}</td>
<td class="num {% if row.sla_pct >= 80 %}sla-good{% elif row.sla_pct >= 60 %}sla-warn{% else %}sla-bad{% endif %}">
{{ row.sla_pct }}%
</td>
<td class="num">{{ row.avg_days }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
{% else %}
<div class="empty">No SLA data available. Run the metrics ingest first.</div>
{% endif %}
</div>
<!-- Section 3: Planning Velocity -->
<div class="glass-card" id="planning">
<div style="display: flex; align-items: center; gap: var(--space-3); margin-bottom: var(--space-4);">
<h2 style="font-family: var(--font-display); font-size: var(--text-xl); font-weight: 600; color: var(--text-primary);">Planning Velocity</h2>
<span class="section-badge">planning_review_metrics</span>
</div>
{% if planning_rows %}
<div class="table-wrap">
<table class="data-table">
<thead>
<tr>
<th>Project Stage</th>
<th>Outcome</th>
<th class="num">Count</th>
<th class="num">Avg Value (days)</th>
</tr>
</thead>
<tbody>
{% for row in planning_rows %}
<tr>
<td>{{ row.stage or '—' }}</td>
<td>{{ row.outcome or '—' }}</td>
<td class="num">{{ '{:,}'.format(row.count) }}</td>
<td class="num">{{ row.avg_value }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</div>
{% else %}
<div class="empty">No planning data available. Run the metrics ingest first.</div>
{% endif %}
</div>
</div>
</main>
</body>
</html>
