{% extends "base.html" %}
{% block title %}Movement ledger{% endblock %}
{% block content %}
<div class="page-head">
  <h1>Movement ledger</h1>
  <a class="btn btn-outline-secondary" href="{{ url_for('movements', format='csv', **request.args.to_dict()) }}">Download as CSV</a>
</div>
<form method="get" class="panel mb-3">
  <div class="row g-2 align-items-end">
    <div class="col-md-4"><label class="form-label" for="product_id">Product</label>
      <select class="form-select" id="product_id" name="product_id"><option value="">All products</option>
        {% for p in products %}<option value="{{ p.id }}" {% if request.args.get('product_id') == p.id|string %}selected{% endif %}>{{ p.sku }} | {{ p.name }}</option>{% endfor %}</select></div>
    <div class="col-md-3"><label class="form-label" for="warehouse_id">Warehouse</label>
      <select class="form-select" id="warehouse_id" name="warehouse_id"><option value="">All warehouses</option>
        {% for w in warehouses %}<option value="{{ w.id }}" {% if request.args.get('warehouse_id') == w.id|string %}selected{% endif %}>{{ w.name }}</option>{% endfor %}</select></div>
    <div class="col-md-3"><label class="form-label" for="move_type">Type</label>
      <select class="form-select" id="move_type" name="move_type"><option value="">All types</option>
        {% for t in types %}<option value="{{ t }}" {% if request.args.get('move_type') == t %}selected{% endif %}>{{ t.replace('_', ' ') }}</option>{% endfor %}</select></div>
    <div class="col-md-2"><button class="btn btn-primary w-100">Filter</button></div>
  </div>
</form>
<div class="panel flush">
  <table class="table">
    <thead><tr><th>When</th><th>SKU</th><th>Product</th><th>Warehouse</th><th>Type</th><th>Reference</th><th>By</th><th class="num">Qty</th></tr></thead>
    <tbody>
    {% for m in rows %}
      <tr><td>{{ m.created_at[:16] }}</td><td>{{ m.sku }}</td><td>{{ m.product }}</td><td>{{ m.warehouse }}</td>
        <td>{{ m.move_type.replace('_', ' ') }}</td><td>{{ m.ref or '' }}</td><td>{{ m.username or '' }}</td>
        <td class="num {{ 'qty-in' if m.qty > 0 else 'qty-out' }}">{{ '%+d'|format(m.qty) }}</td></tr>
    {% else %}
      <tr><td colspan="8" class="text-secondary">No movements match these filters.</td></tr>
    {% endfor %}
    </tbody>
  </table>
</div>
<p class="small text-secondary mt-2">Showing the latest 300 rows. The CSV download contains every matching row.</p>
{% endblock %}