{% extends "base.html" %}
{% block title %}Opportunity Queue{% endblock %}
{% block content %}
<header class="page-head"><div><div class="eyebrow">From evidence to accountable action</div><h1>Opportunity Queue</h1><div class="subtitle">Filter and challenge recommendations. Every row exposes the metrics, rule and owner behind the proposed action.</div></div>{% if weeks %}<label><span class="visually-hidden">Trading week</span><select class="week-select" onchange="weekChange(this)">{% for w in weeks %}<option {% if w == selected_week %}selected{% endif %}>{{ w }}</option>{% endfor %}</select></label>{% endif %}</header>
<div class="note" style="margin-bottom:18px"><b>Prototype assumptions:</b> replenishment decisions combine stock cover, sell-through and relative conversion. Thresholds require expert validation before production use.</div>
<section class="section"><div class="section-head"><form class="filters" method="get"><input type="hidden" name="week" value="{{ selected_week or '' }}"><label><span class="visually-hidden">Recommended action</span><select name="action" class="select"><option>All</option>{% for a in actions %}<option {% if a == selected_action %}selected{% endif %}>{{ a }}</option>{% endfor %}</select></label><label><span class="visually-hidden">Evidence confidence</span><select name="confidence" class="select"><option>All</option>{% for c in ['High','Medium','Low'] %}<option {% if c == selected_confidence %}selected{% endif %}>{{ c }}</option>{% endfor %}</select></label><button class="button" type="submit">Apply filters</button></form><div class="sub">{{ rows|length }} visible products</div></div><div class="table-wrap"><table><thead><tr><th>Priority</th><th>Product</th><th>Action and rationale</th><th>Owner</th><th class="num">CVR</th><th class="num">Sell-through</th><th class="num">Cover</th><th class="num">Stock</th><th class="num">Returns</th><th class="num">Indicative exposure</th></tr></thead><tbody>{% for r in rows %}<tr><td><span class="pill {{ r.priority_band }}">{{ r.priority_band }} · {{ r.priority_score }}</span></td><td><div class="product">{{ r.product_name }}</div><div class="sub">{{ r.brand }} · {{ r.category }}</div></td><td><div class="action">{{ r.recommended_action }}</div><div class="reason">{{ r.reason }}</div><div class="sub"><b>{{ r.confidence }}</b> evidence · Rule {{ r.rule_id }}</div></td><td>{{ r.owner }}</td><td class="num">{{ '%.1f'|format(r.effective_cvr) }}%</td><td class="num">{{ '%.1f'|format(r.sell_through_pct) }}%</td><td class="num">{{ '%.1f'|format(r.cover) }} wks</td><td class="num">{{ r.units_remaining|int }}</td><td class="num">{{ '%.1f'|format(r.returns_pct) }}%</td><td class="num">£{{ '{:,.0f}'.format(r.value_proxy) }}</td></tr>{% else %}<tr><td colspan="10" class="empty">{% if selected_week %}No products match the selected filters.{% else %}Upload a workbook to generate the Opportunity Queue.{% endif %}</td></tr>{% endfor %}</tbody></table></div></section>
<div class="grid two"><section class="section"><div class="section-head"><div><h2>Decision-rule assumptions</h2><p>Visible thresholds make the logic auditable.</p></div></div><div class="section-body metric-list"><div><b>Urgent replenishment:</b> ≤ {{ rule_thresholds.urgent_cover_weeks }} weeks cover, ≥ {{ rule_thresholds.strong_sell_through_pct|int }}% sell-through and strong relative CVR</div><div><b>Replenishment review:</b> ≤ {{ rule_thresholds.review_cover_weeks }} weeks cover and ≥ {{ rule_thresholds.review_sell_through_pct|int }}% sell-through</div><div><b>Aged stock:</b> ≥ {{ rule_thresholds.aged_cover_weeks|int }} weeks cover, &lt; {{ rule_thresholds.aged_sell_through_pct|int }}% sell-through and &gt; {{ rule_thresholds.aged_stock_units|int }} units</div><div><b>Returns review:</b> above {{ rule_thresholds.returns_review_pct|int }}%</div><div><b>Priority blend:</b> {{ (priority_weights.weighted_score*100)|int }}% weighted score, {{ (priority_weights.rule_urgency*100)|int }}% urgency, {{ (priority_weights.evidence_strength*100)|int }}% evidence strength</div></div></section><section class="section"><div class="section-head"><div><h2>Customer demand signals</h2><p>Search behaviour supporting assortment decisions.</p></div></div><div class="table-wrap"><table><thead><tr><th>Search term</th><th class="num">Searches</th><th class="num">Zero results</th><th class="num">CVR</th></tr></thead><tbody>{% for r in search_rows %}<tr><td class="product">{{ r.search_term }}</td><td class="num">{{ r.total_searches|int }}</td><td class="num {{ 'bad' if r.zero_result_rate > 20 else '' }}">{{ '%.1f'|format(r.zero_result_rate) }}%</td><td class="num">{{ '%.1f'|format(r.avg_cvr) }}%</td></tr>{% else %}<tr><td colspan="4" class="empty">No search evidence is available.</td></tr>{% endfor %}</tbody></table></div></section></div>
<section class="section"><div class="section-head"><div><h2>Regional context</h2><p>Supporting evidence retained below the main decision workflow.</p></div></div><div class="table-wrap"><table><thead><tr><th>Region</th><th class="num">Revenue</th><th class="num">Sessions</th><th class="num">CVR</th></tr></thead><tbody>{% for r in regional_rows %}<tr><td class="product">{{ r.region }}</td><td class="num">£{{ '{:,.0f}'.format(r.revenue_ga4) }}</td><td class="num">{{ r.sessions|int }}</td><td class="num">{{ '%.1f'|format(r.cvr) }}%</td></tr>{% else %}<tr><td colspan="4" class="empty">No regional evidence is available.</td></tr>{% endfor %}</tbody></table></div></section>
{% endblock %}