{% extends "inventory/base.html" %}{% load humanize_tags %}
{% block title %}{{ item.sku }}{% endblock %}
{% block content %}
<p class="crumb"><a href="{% url 'items' %}">Items</a> / {{ item.sku }}</p>
<h1>{{ item.name }} <small>{{ item.sku }} &middot; {{ item.category }} &middot; {{ item.supplier|default:"no supplier" }}</small></h1>
<div class="kpis">
  <div class="kpi"><span>On hand ({{ item.uom }})</span><b>{{ replay.qty|qty }}</b><small>{% for w, q in warehouses.items %}{{ w }} {{ q|qty }}{% if not forloop.last %}, {% endif %}{% endfor %}</small></div>
  <div class="kpi"><span>Value ({{ method|upper }})</span><b>{{ replay.value|money2 }}</b><small>avg {{ replay.avg_cost|money2 }}</small></div>
  <div class="kpi"><span>Class</span><b>{{ c.abc }}{{ c.xyz }} / {{ c.fsn }}</b><small>CV {{ c.cv|num:2 }}</small></div>
  <div class="kpi"><span>Turnover</span><b>{{ c.turnover|num:1 }}x</b><small>last issue {{ c.days_since_issue|default_if_none:"never" }} days ago</small></div>
  <div class="kpi"><span>Days of cover</span><b>{{ plan.days_cover|num:0 }}</b><small>lead time {{ inp.lead_time|num:0 }}d</small></div>
</div>
{% if writedown %}<p class="alert warn">NRV {{ item.nrv }} is below cost: lower-of-cost-or-NRV write-down {{ writedown|money2 }}.</p>{% endif %}
{% if suggestion %}<p class="alert {% if suggestion.risk == 'high' %}danger{% else %}warn{% endif %}">Reorder suggested: {{ suggestion.qty|num:0 }} units ({{ suggestion.reason }}), stockout risk {{ suggestion.risk }}.</p>{% endif %}

<section class="card"><h2>Demand and forecast</h2>
{{ chart }}
<p class="legend"><i class="l-hist"></i>actual <i class="l-fc"></i>forecast <i class="l-band"></i>{{ run.interval_level|default:0.9|pct }} prediction interval</p>
{% if result %}<p>Model <b>{{ result.model }}</b> ({{ result.demand_class }}, ADI {{ result.adi|num:2 }}, CV&sup2; {{ result.cv2|num:2 }}) - backtest MASE {{ result.mase|num:2 }}, MAPE {{ result.mape|pct }}. <a href="{% url 'forecast_detail' run.pk %}">Run #{{ run.pk }}</a></p>
{% else %}<p class="muted">No forecast run yet for this item. <a href="{% url 'forecasts' %}">Run forecasts</a>. Policy numbers use trailing 12-month demand.</p>{% endif %}
</section>

<div class="grid2">
<section class="card"><h2>Policy numbers explained</h2>
<table class="data compact"><thead><tr><th>Metric</th><th>Formula</th><th>Substituted</th><th class="r">Result</th></tr></thead>
<tbody>{% for e in explain %}<tr><td>{{ e.name }}</td><td><code>{{ e.formula }}</code></td><td>{{ e.values }}</td><td class="r"><b>{{ e.result }}</b></td></tr>{% endfor %}</tbody></table>
<h3>Price break evaluation (annual cost at each tier's EOQ)</h3>
<table class="data compact"><thead><tr><th>From qty</th><th class="r">Unit cost</th><th class="r">Order qty</th><th class="r">Annual cost</th><th>Feasible</th></tr></thead>
<tbody>{% for t in plan.tiers %}<tr><td>{{ t.min_qty|num:0 }}</td><td class="r">{{ t.unit_cost|num:2 }}</td><td class="r">{{ t.order_qty|num:0 }}</td><td class="r">{{ t.total_cost|num:0 }}</td><td>{% if t.feasible %}yes{% else %}no{% endif %}{% if t.unit_cost == plan.unit_cost and t.feasible %} (chosen if cheapest){% endif %}</td></tr>{% endfor %}</tbody></table>
<p class="muted">MOQ {{ item.moq|qty }}, pack size {{ item.pack_size|qty }}, ordering cost {{ inp.order_cost|num:2 }}.</p>
</section>
<section class="card"><h2>Open cost layers</h2>
<table class="data compact"><thead><tr><th>Received</th><th class="r">Left / in</th><th class="r">Unit cost</th><th class="r">Value</th><th>Expiry</th></tr></thead>
<tbody>{% for l in layers %}<tr><td>{{ l.date }}</td><td class="r">{{ l.qty_left|qty }} / {{ l.qty_in|qty }}</td><td class="r">{{ l.unit_cost|money2 }}</td><td class="r">{{ l.value|money2 }}</td><td>{{ l.expiry|default_if_none:"" }}</td></tr>{% empty %}<tr><td colspan="5" class="muted">No stock.</td></tr>{% endfor %}</tbody></table>
</section>
</div>

<section class="card"><h2>Movement ledger <small>{{ total_movements }} movements{% if truncated %}, latest 60 shown - <a href="?all=1">show all</a>{% endif %}</small></h2>
<table class="data compact"><thead><tr><th>Date</th><th>Type</th><th>Ref</th><th>Warehouse</th><th class="r">Qty</th><th class="r">Unit cost</th><th class="r">Value change</th><th class="r">Qty after</th><th class="r">Value after</th><th>Cost layers consumed</th></tr></thead>
<tbody>{% for r in ledger %}<tr>
<td>{{ r.m.date }}</td><td>{{ r.m.kind }}</td><td>{{ r.m.reference }}</td><td>{{ r.m.warehouse }}{% if r.m.to_warehouse %} &rarr; {{ r.m.to_warehouse }}{% endif %}</td>
<td class="r">{{ r.m.qty|qty }}</td>
{% if r.p %}<td class="r">{{ r.p.unit_cost|money2 }}</td><td class="r">{{ r.p.value_delta|money2 }}</td><td class="r">{{ r.p.qty_after|qty }}</td><td class="r">{{ r.p.value_after|money2 }}</td>
<td class="small">{% for d, q, cost in r.consumed %}{{ d }}: {{ q|qty }} @ {{ cost|money2 }}{% if not forloop.last %}; {% endif %}{% endfor %}{% if r.p.unbacked_qty %} <span class="neg">{{ r.p.unbacked_qty|qty }} unbacked</span>{% endif %}</td>
{% else %}<td colspan="5" class="muted">warehouse transfer, no cost effect</td>{% endif %}
</tr>{% endfor %}</tbody></table></section>
{% endblock %}