{% extends "base.html" %}
{% from "_macros.html" import report_filters with context %}
{% block title %}{{ t('Gross Margin') }}{% endblock %}
{% block content %}
{% set cur = currency %}
<div class="page-head"><div><h1>{{ t('Gross Margin') }}</h1><small>{{ t('Sales less the cost of the goods sold, at average cost when the goods left the warehouse') }}</small></div></div>
{% set extra %}<select name="by">{% for g, lbl in [('product', 'By product'), ('customer', 'By customer'), ('category', 'By category'), ('month', 'By month'), ('branch', 'By branch')] %}<option value="{{ g }}" {{ 'selected' if group == g }}>{{ t(lbl) }}</option>{% endfor %}</select>{% endset %}
{{ report_filters(f, False, extra) }}
<div class="report-meta"><span>{{ f.date_from }} → {{ f.date_to }}</span><span>{{ t('Amounts in') }} {{ cur }}</span></div>
<div class="kpis" style="grid-template-columns:repeat(4,minmax(0,1fr))">
  <div class="kpi"><div class="top"><span class="label">{{ t('Revenue') }}</span></div><div class="value num">{{ total.revenue|money(cur) }}</div></div>
  <div class="kpi"><div class="top"><span class="label">{{ t('Cost of Goods Sold') }}</span></div><div class="value num">{{ total.cost|money(cur) }}</div></div>
  <div class="kpi"><div class="top"><span class="label">{{ t('Gross Margin') }}</span></div><div class="value num {{ 'neg' if total.margin < 0 }}">{{ total.margin|money(cur) }}</div></div>
  <div class="kpi"><div class="top"><span class="label">{{ t('Margin %') }}</span></div><div class="value num">{{ '%.1f%%'|format(total.pct) if total.pct is not none else '—' }}</div></div>
</div>
<div class="card flush">
  <table class="report">
    <thead><tr><th>{{ t({'product': 'Product', 'customer': 'Customer', 'branch': 'Branch', 'month': 'Month', 'category': 'Category'}[group]) }}</th>
      {% if group == 'product' %}<th class="num">{{ t('Quantity') }}</th>{% endif %}
      <th class="num">{{ t('Revenue') }}</th><th class="num">{{ t('Cost of Goods Sold') }}</th><th class="num">{{ t('Gross Margin') }}</th><th class="num">{{ t('Margin %') }}</th><th style="width:18%"></th></tr></thead>
    <tbody>
    {% for r in rows %}
      <tr><td>{{ r.label }}</td>{% if group == 'product' %}<td class="num">{{ '%g' % r.qty }}</td>{% endif %}
        <td class="num">{{ r.revenue|money(cur) }}</td><td class="num">{{ r.cost|money(cur) }}</td>
        <td class="num {{ 'neg' if r.margin < 0 }}">{{ r.margin|money(cur) }}</td>
        <td class="num {{ 'neg' if r.pct is not none and r.pct < 0 }}">{{ '%.1f%%'|format(r.pct) if r.pct is not none else '—' }}</td>
        <td><div class="hbar"><i style="width:{{ [[r.pct or 0, 0]|max, 100]|min }}%"></i></div></td></tr>
    {% else %}<tr><td class="empty" colspan="7">{{ t('Nothing yet.') }}</td></tr>{% endfor %}
    </tbody>
    <tfoot><tr><td>{{ t('Total') }}</td>{% if group == 'product' %}<td></td>{% endif %}<td class="num">{{ total.revenue|money(cur) }}</td><td class="num">{{ total.cost|money(cur) }}</td>
      <td class="num">{{ total.margin|money(cur) }}</td><td class="num">{{ '%.1f%%'|format(total.pct) if total.pct is not none else '—' }}</td><td></td></tr></tfoot>
  </table>
</div>
<div class="card flush">
  <div class="card-h"><h2>{{ t('Reconciliation to the Profit & Loss') }}</h2><a class="link" href="{{ url_for('reports.pl', date_from=f.date_from, date_to=f.date_to) }}">{{ t('Profit & Loss') }} →</a></div>
  <table class="report">
    <thead><tr><th></th><th class="num">{{ t('Revenue') }}</th><th class="num">{{ t('Cost of Revenue') }}</th><th class="num">{{ t('Gross Margin') }}</th></tr></thead>
    <tbody>
      <tr><td>{{ t('Margin on goods and services sold (above)') }}</td><td class="num">{{ total.revenue|money(cur) }}</td><td class="num">{{ total.cost|money(cur) }}</td><td class="num">{{ total.margin|money(cur) }}</td></tr>
      <tr><td>{{ t('Revenue in the ledger not on invoice lines or POS') }}</td><td class="num">{{ (gl.revenue - total.revenue)|money(cur) }}</td><td></td><td class="num">{{ (gl.revenue - total.revenue)|money(cur) }}</td></tr>
      <tr><td>{{ t('Cost of revenue in the ledger not from goods movements') }}<br><small class="muted">{{ t('Vendor bills booked straight to cost of sales, price differences, landed costs, stock adjustments and write-offs') }}</small></td>
        <td></td><td class="num">{{ (gl.cost - total.cost)|money(cur) }}</td><td class="num">{{ (total.cost - gl.cost)|money(cur) }}</td></tr>
    </tbody>
    <tfoot><tr><td>{{ t('Gross profit as in the Profit & Loss') }}</td><td class="num">{{ gl.revenue|money(cur) }}</td><td class="num">{{ gl.cost|money(cur) }}</td>
      <td class="num">{{ gl.margin|money(cur) }}{% if gl.pct is not none %} <small>({{ '%.1f'|format(gl.pct) }}%)</small>{% endif %}</td></tr></tfoot>
  </table>
</div>
<p class="muted"><small>{{ t('Revenue: invoice lines on revenue accounts, less credit notes, plus closed POS sessions, without VAT. Cost: goods delivered or sold at POS less goods returned by customers. Services carry no cost of goods. Price differences on vendor bills and landed costs booked later to COGS are not included here; see the Profit & Loss for the full cost of sales.') }}</small></p>
{% endblock %}