{% extends "base.html" %}
{% block title %}Reorder list{% endblock %}
{% block content %}
<div class="page-head"><h1>Reorder list</h1></div>
<p class="text-secondary">Based on average daily sales over the last 30 days. A product appears here when its stock is at or below its
  reorder point: the larger of its own reorder level and {{ lead + safety }} days of sales ({{ lead }} days supplier lead time plus {{ safety }} safety days).
  The suggested quantity covers the next 30 days.</p>
<div class="panel flush">
  <table class="table align-middle">
    <thead><tr><th>SKU</th><th>Product</th><th class="num">On hand</th><th class="num">Sold in 30 days</th>
      <th class="num">Per day</th><th class="num">Days left</th><th class="num">Reorder point</th>
      <th class="num">Order now</th><th class="num">Est. cost ({{ currency }})</th></tr></thead>
    <tbody>
    {% for r in rows %}
      <tr><td>{{ r.sku }}</td><td>{{ r.name }}</td>
        <td class="num"><span class="tag{% if r.on_hand <= 0 %} empty{% endif %}">{{ r.on_hand }}</span></td>
        <td class="num">{{ r.sold_30 }}</td><td class="num">{{ r.daily }}</td>
        <td class="num">{{ r.days_left if r.days_left is not none else 'no sales' }}</td>
        <td class="num">{{ r.reorder_point }}</td>
        <td class="num fw-bold">{{ r.suggested_qty }} {{ r.unit }}</td><td class="num">{{ r.est_cost|money }}</td></tr>
    {% else %}
      <tr><td colspan="9" class="text-secondary">Nothing needs reordering today.</td></tr>
    {% endfor %}
    </tbody>
  </table>
</div>
{% endblock %}