{% extends "base.html" %}
{% block title %}Reports & Analytics{% endblock %}
{% block page_title %}Reports & Analytics{% endblock %}
{% block content %}
<div class="page-header"><div><h1>Quarterly OVR Analysis</h1><p>Trend and aggregate review for QPS and Environment of Care committee reporting.</p></div><div class="page-actions"><a class="button secondary" href="{{ url_for('main.reports_csv', year=year, quarter=quarter) }}">Export CSV</a></div></div>
<form class="filter-bar" method="get" style="grid-template-columns:1fr 1fr auto"><label>Year<input type="number" name="year" min="2020" max="2100" value="{{ year }}"></label><label>Quarter<select name="quarter"><option value="0" {% if quarter==0 %}selected{% endif %}>Full Year</option>{% for item in [1,2,3,4] %}<option value="{{ item }}" {% if quarter==item %}selected{% endif %}>Q{{ item }}</option>{% endfor %}</select></label><button class="button primary" type="submit">Apply</button></form>
<section class="stats-grid"><div class="stat-card"><span>Total Reports</span><strong>{{ rows|length }}</strong></div><div class="stat-card"><span>High / Extreme</span><strong>{{ by_risk.High + by_risk.Extreme }}</strong></div><div class="stat-card"><span>Closed</span><strong>{{ by_status.get('Closed',0) }}</strong></div><div class="stat-card"><span>Open</span><strong>{{ rows|length - by_status.get('Closed',0) }}</strong></div></section>
<div class="three-column">
  <section class="card"><div class="card-header"><h2>Risk Profile</h2></div><div class="card-body chart-list">{% set maxrisk = by_risk.values()|max if by_risk.values()|list else 1 %}{% for label,count in by_risk.items() %}<div class="chart-row"><span><span class="risk-badge {{ risk_colors.get(label,'gray') }}">{{ label }}</span></span><div class="bar-track"><div class="bar" style="width:{{ (count * 100 / (maxrisk or 1))|round }}%"></div></div><strong>{{ count }}</strong></div>{% endfor %}</div></section>
  <section class="card"><div class="card-header"><h2>Top Classifications</h2></div><div class="card-body chart-list">{% set maxcat = by_category.values()|max if by_category else 1 %}{% for label,count in by_category|dictsort(false,'value')|reverse %}<div class="chart-row"><span>{{ label }}</span><div class="bar-track"><div class="bar" style="width:{{ (count * 100 / (maxcat or 1))|round }}%"></div></div><strong>{{ count }}</strong></div>{% else %}<p class="form-note">No data in this period.</p>{% endfor %}</div></section>
  <section class="card"><div class="card-header"><h2>Branches</h2></div><div class="card-body chart-list">{% set maxbranch = by_branch.values()|max if by_branch else 1 %}{% for label,count in by_branch.items() %}<div class="chart-row"><span>{{ label }}</span><div class="bar-track"><div class="bar" style="width:{{ (count * 100 / (maxbranch or 1))|round }}%"></div></div><strong>{{ count }}</strong></div>{% else %}<p class="form-note">No data in this period.</p>{% endfor %}</div></section>
</div>
<section class="card"><div class="card-header"><div><h2>Included Reports</h2><p>{{ year }} · {{ 'Full year' if quarter == 0 else 'Quarter ' ~ quarter }}</p></div></div>{% if rows %}<div class="table-wrap"><table class="data-table"><thead><tr><th>Reference</th><th>Date</th><th>Branch</th><th>Category</th><th>Risk</th><th>Status</th></tr></thead><tbody>{% for item in rows %}<tr><td class="primary-cell"><a href="{{ url_for('main.incident_detail', incident_id=item.id) }}">{{ item.reference_no }}</a></td><td>{{ item.incident_date }}</td><td>{{ item.branch.name }}</td><td>{{ item.classification_category }}</td><td>{{ item.risk_level or 'Pending' }}</td><td>{{ item.status_label }}</td></tr>{% endfor %}</tbody></table></div>{% else %}<div class="empty-state"><strong>No reports</strong><p>No authorized OVR records match this period.</p></div>{% endif %}</section>
{% endblock %}