{% extends "base.html" %}
{% from "_macros.html" import report_filters with context %}
{% block title %}{{ t('Stock vs Invoices') }}{% endblock %}
{% block content %}
<div class="page-head"><div><h1>{{ t('Stock vs Invoices') }}</h1>
  <small>{{ t('Month-end check: goods invoiced but not yet delivered or received, and the reverse. Clear these before closing so revenue and its cost of goods sold fall in the same month.') }}</small></div></div>
{{ report_filters(f, False) }}
<div class="report-meta"><span>{{ t('As of') }} {{ f.date_to }}</span></div>
<div class="stat-row">
  {% for key, label, _ in sections %}
  <a class="stat" href="#{{ key }}"><div><div class="l">{{ t(label) }}</div><div class="v num {{ 'neg' if data[key] and key in ('inv_not_delivered', 'credit_not_returned') }}">{{ data[key]|length }} <small class="muted">{{ t('lines') }}</small></div></div></a>
  {% endfor %}
</div>
{% for key, label, help in sections %}
<div class="card flush" id="{{ key }}">
  <div class="card-h" style="padding:14px 16px 0"><div><h2>{{ t(label) }}</h2><small class="muted">{{ t(help) }}</small></div></div>
  <table class="report">
    <thead><tr><th>{{ t('Branch') }}</th><th>{{ t('Document') }}</th><th>{{ t('Date') }}</th><th>{{ t('Partner') }}</th><th>{{ t('Product') }}</th>
      <th class="num">{{ t('Quantity') }}</th><th class="num">{{ t('Value') }}</th><th class="num">{{ t('Estimated cost') }}</th></tr></thead>
    <tbody>
    {% set ns = namespace(value=0, cost=0, curs=[]) %}
    {% for r in data[key] %}
      {% set cur = bmap[r.branch_id].currency %}
      {% set ns.value = ns.value + r.value %}{% set ns.cost = ns.cost + r.cost %}{% if cur not in ns.curs %}{% set ns.curs = ns.curs + [cur] %}{% endif %}
      <tr><td><span class="tag">{{ bmap[r.branch_id].code }}</span></td>
        <td>{% if r.order_id %}<a href="{{ url_for('orders.view', order_id=r.order_id) }}">{{ r.doc }}</a>{% else %}<a href="{{ url_for('invoices.view', inv_id=r.invoice_id) }}">{{ r.doc }}</a>{% endif %}</td>
        <td class="num">{{ r.date }}</td><td>{{ nm({'name_en': r.pname_en, 'name_ar': r.pname_ar}) }}</td>
        <td><b>{{ r.pcode or '' }}</b> {{ nm({'name_en': r.prname_en, 'name_ar': r.prname_ar}) }}</td>
        <td class="num">{{ '%g' % r.qty }} <small>{{ r.uom or '' }}</small></td>
        <td class="num">{{ r.value|money(cur) }}</td><td class="num">{{ r.cost|money(cur) }}</td></tr>
    {% else %}<tr><td class="empty" colspan="8">{{ t('Nothing to clear.') }}</td></tr>{% endfor %}
    </tbody>
    {% if data[key] and ns.curs|length == 1 %}
    <tfoot><tr><td colspan="6">{{ t('Total') }}</td><td class="num">{{ ns.value|money(ns.curs[0]) }}</td><td class="num">{{ ns.cost|money(ns.curs[0]) }}</td></tr></tfoot>
    {% endif %}
  </table>
</div>
{% endfor %}
<p class="muted"><small>{{ t('Value is at the document price, excluding VAT. Estimated cost is at today\'s average cost of the branch.') }}</small></p>
{% endblock %}