{% extends "inventory/base.html" %}{% load humanize_tags %}
{% block title %}Items{% endblock %}
{% block content %}
<h1>Items <small>{{ rows|length }} shown</small></h1>
<form class="filters" method="get">
  <input name="q" value="{{ q }}" placeholder="Search SKU or name">
  <select name="category"><option value="">All categories</option>{% for c in categories %}<option {% if f.category == c %}selected{% endif %}>{{ c }}</option>{% endfor %}</select>
  <select name="abc"><option value="">ABC</option>{% for v in "ABC" %}<option {% if f.abc == v %}selected{% endif %}>{{ v }}</option>{% endfor %}</select>
  <select name="xyz"><option value="">XYZ</option>{% for v in "XYZ" %}<option {% if f.xyz == v %}selected{% endif %}>{{ v }}</option>{% endfor %}</select>
  <select name="fsn"><option value="">FSN</option>{% for v in "FSN" %}<option {% if f.fsn == v %}selected{% endif %}>{{ v }}</option>{% endfor %}</select>
  <button>Filter</button>
</form>
<table class="data">
<thead><tr><th>SKU</th><th>Name</th><th>Category</th><th>ABC</th><th>XYZ</th><th>FSN</th><th class="r">On hand</th><th class="r">Value</th><th class="r">Turnover</th><th class="r">Monthly demand</th></tr></thead>
<tbody>{% for r in rows %}<tr>
<td><a href="{% url 'item' r.item.sku %}">{{ r.item.sku }}</a></td><td>{{ r.item.name }}</td><td>{{ r.item.category }}</td>
<td><span class="tag t{{ r.c.abc }}">{{ r.c.abc }}</span></td><td>{{ r.c.xyz }}</td><td>{{ r.c.fsn }}</td>
<td class="r">{{ r.qty|qty }}</td><td class="r">{{ r.value|money }}</td><td class="r">{{ r.c.turnover|num:1 }}</td><td class="r">{{ r.c.monthly_mean|num:1 }}</td></tr>{% endfor %}</tbody>
</table>
{% endblock %}