{% extends "base.html" %}
{% block title %}{{ t('Stock on Hand') }}{% endblock %}
{% block content %}
<div class="page-head">
  <div><h1>{{ t('Stock on Hand') }}</h1><small>{{ t('Forecast = on hand + incoming − outgoing (open receipts and deliveries).') }}</small></div>
  {% if can_write %}<div class="actions"><a class="btn ghost" href="{{ url_for('inventory.adjust') }}">+ {{ t('Inventory Adjustment') }}</a></div>{% endif %}
</div>
<form class="filters" method="get">
  <input type="search" name="q" value="{{ search }}" placeholder="{{ t('Search…') }}">
  <select name="warehouse_id"><option value="">{{ t('All warehouses') }}</option>
    {% for w in warehouses %}<option value="{{ w.id }}" {{ 'selected' if wid == w.id }}>{{ w.code }} — {{ nm(w) }}</option>{% endfor %}</select>
  <label class="chip"><input type="checkbox" name="low" value="1" {{ 'checked' if low }}> {{ t('Below reorder level') }}</label>
  <button class="btn">{{ t('Filter') }}</button>
</form>
<div class="card flush">
  <table>
    <thead><tr><th>{{ t('Product') }}</th><th>{{ t('Warehouse') }}</th><th class="num">{{ t('On Hand') }}</th><th class="num">{{ t('Incoming') }}</th>
      <th class="num">{{ t('Outgoing') }}</th><th class="num">{{ t('Forecast') }}</th><th class="num">{{ t('Reorder Level') }}</th>
      <th class="num">{{ t('Average Cost') }}</th><th class="num">{{ t('Value') }}</th></tr></thead>
    <tbody>
    {% for r in rows %}{% set cur = branches[r.branch_id].currency if r.branch_id in branches else none %}
      <tr data-href="{{ url_for('inventory.moves', product_id=r.id) }}">
        <td><b>{{ r.code or '' }}</b> {{ nm(r) }}{% if r.low %} <span class="badge overdue">{{ t('Reorder') }}</span>{% endif %}</td>
        <td>{{ r.wcode }}</td><td class="num">{{ '%g' % r.qty }} <small>{{ r.uom or '' }}</small></td>
        <td class="num">{{ ('%g' % r.incoming) if r.incoming else '' }}</td><td class="num">{{ ('%g' % r.outgoing) if r.outgoing else '' }}</td>
        <td class="num {{ 'neg' if r.low }}">{{ '%g' % r.forecast }}</td><td class="num">{{ ('%g' % r.min_qty) if r.min_qty else '' }}</td>
        <td class="num">{{ r.avg|money(cur) }}</td><td class="num">{{ r.value|money(cur) }} <small>{{ cur }}</small></td>
      </tr>
    {% else %}<tr><td class="empty" colspan="9">{{ t('Nothing yet.') }}</td></tr>{% endfor %}
    </tbody>
  </table>
</div>
<div class="card flush">
  <div style="padding:14px 16px 6px"><h2 style="margin:0">{{ t('Stock valuation vs general ledger') }}</h2></div>
  <table>
    <thead><tr><th>{{ t('Branch') }}</th><th class="num">{{ t('Stock valuation') }}</th><th class="num">{{ t('Inventory account balance') }}</th><th class="num">{{ t('Difference') }}</th></tr></thead>
    <tbody>
    {% for r in recon %}
      <tr><td><span class="tag">{{ r.branch.code }}</span> {{ nm(r.branch) }}</td><td class="num">{{ r.stock|money(r.branch.currency) }}</td>
        <td class="num">{{ r.gl|money(r.branch.currency) }}</td>
        <td class="num {{ 'neg' if r.stock != r.gl }}">{{ (r.stock - r.gl)|money(r.branch.currency) }}</td></tr>
    {% endfor %}
    </tbody>
  </table>
  <div class="notes">{{ t('A difference means entries were posted to the inventory account manually instead of through stock operations.') }}</div>
</div>
{% endblock %}