{% extends 'base.html' %}
{% block title %}Contract Balance Report{% endblock %}
{% block content %}

<div class="page-header no-print">
  <div class="page-title">Contract Balance Report
    <small>Open contracts – factory wise, month wise</small>
  </div>
  <div class="d-flex gap-2 no-print">
    <a href="{{ url_for('report_export', factory=factory_filter, month=month_filter) }}"
       class="btn btn-outline-secondary btn-sm">
      <i class="bi bi-download me-1"></i> Export CSV
    </a>
    <button onclick="window.print()" class="btn btn-outline-secondary btn-sm">
      <i class="bi bi-printer me-1"></i> Print / PDF
    </button>
  </div>
</div>

<!-- Filters -->
<form class="filters-bar no-print mb-4" method="get">
  <span class="filters-label">Filter</span>
  <select name="factory" onchange="this.form.submit()">
    <option value="">All Factories</option>
    {% for code, name in factories.items() %}
    <option value="{{ code }}" {% if factory_filter==code %}selected{% endif %}>{{ code }} – {{ name }}</option>
    {% endfor %}
  </select>
  <input type="month" name="month" value="{{ month_filter }}" onchange="this.form.submit()">
  {% if factory_filter or month_filter %}
  <a href="{{ url_for('report') }}" class="btn btn-outline-secondary btn-sm">Clear</a>
  {% endif %}
</form>

<!-- Print header removed per user request -->

{% if not factory_groups %}
<div class="card">
  <div class="card-body empty-state py-5">
    <i class="bi bi-file-earmark-x d-block mb-2" style="font-size:36px;color:#e2e8f0"></i>
    <div>No open contracts found for selected filters.</div>
    <a href="{{ url_for('report') }}" class="btn btn-outline-secondary btn-sm mt-3">Clear Filters</a>
  </div>
</div>
{% endif %}

{% for fc, fg in factory_groups.items() %}
<div class="report-section mb-4">
  <!-- Factory header -->
  <div class="d-flex align-items-center gap-2 mb-3 pb-2" style="border-bottom:2px solid #e2e8f0">
    <span class="factory-chip fchip-{{ fc }}" style="font-size:13px;padding:3px 10px">{{ fc }}</span>
    <span style="font-size:18px;font-weight:700">{{ fg.name }}</span>
    {% if fg.is_cf %}
    <span class="badge badge-cf ms-1" style="font-size:11px">CF – Over-delivery normal</span>
    {% endif %}
  </div>

  {% set factory_declared  = namespace(val=0) %}
  {% set factory_delivered = namespace(val=0) %}
  {% set factory_balance   = namespace(val=0) %}
  {% set factory_wet       = namespace(val=0) %}

  {% for month_key, month_rows in fg.months.items() %}
  <div class="card mb-3">
    <div class="card-header" {% if fg.is_cf %}style="background:#ede9fe"{% endif %}>
      <span class="card-title" {% if fg.is_cf %}style="color:#7c3aed"{% endif %}>
        <i class="bi bi-calendar3 me-1"></i>{{ month_key }}
      </span>
      <span class="badge {% if fg.is_cf %}badge-cf{% else %}badge-open{% endif %}">
        {{ month_rows|length }} contract{{ 's' if month_rows|length != 1 }}
      </span>
    </div>
    <div class="table-wrap">
      <table class="report-table" style="table-layout:fixed;width:100%">
        <colgroup>
          {% if fg.is_cf %}
          <col style="width:12%"><!-- Contract No -->
          <col style="width:5%"> <!-- Broker -->
          <col style="width:12%"><!-- Customer -->
          <col style="width:8%"> <!-- S/O -->
          <col style="width:11%"><!-- Materials -->
          <col style="width:6%"> <!-- Price -->
          <col style="width:7%"> <!-- Wet Qty -->
          <col style="width:8%"> <!-- Declared -->
          <col style="width:8%"> <!-- Delivered -->
          <col style="width:8%"> <!-- Balance -->
          <col style="width:15%"><!-- Due Date -->
          {% else %}
          <col style="width:13%"><!-- Contract No -->
          <col style="width:6%"> <!-- Broker -->
          <col style="width:13%"><!-- Customer -->
          <col style="width:9%"> <!-- S/O -->
          <col style="width:13%"><!-- Materials -->
          <col style="width:7%"> <!-- Price -->
          <col style="width:9%"> <!-- Declared -->
          <col style="width:9%"> <!-- Delivered -->
          <col style="width:9%"> <!-- Balance -->
          <col style="width:12%"><!-- Due Date -->
          {% endif %}
        </colgroup>
        <thead>
          <tr>
            <th>Contract No</th>
            <th>Broker</th>
            <th>Customer</th>
            <th>S/O</th>
            <th>Materials</th>
            <th class="text-right">Price</th>
            {% if fg.is_cf %}<th class="text-right">Wet Qty<br><span style="font-weight:400;font-size:9px">(Declared)</span></th>{% endif %}
            <th class="text-right">Declared</th>
            <th class="text-right">Delivered</th>
            <th class="text-right">Balance</th>
            <th>Due Date</th>
          </tr>
        </thead>
        <tbody>
        {% set month_declared  = namespace(val=0) %}
        {% set month_delivered = namespace(val=0) %}
        {% set month_balance   = namespace(val=0) %}
        {% set month_wet       = namespace(val=0) %}
        {% for c in month_rows %}
          {% set pos_balance = [c.balance, 0]|max %}
          {% set month_declared.val  = month_declared.val  + c.qty %}
          {% set month_delivered.val = month_delivered.val + c.delivered %}
          {% set month_balance.val   = month_balance.val   + pos_balance %}
          {% set month_wet.val       = month_wet.val       + (c.wet_qty or 0) %}
          {% set factory_declared.val  = factory_declared.val  + c.qty %}
          {% set factory_delivered.val = factory_delivered.val + c.delivered %}
          {% set factory_balance.val   = factory_balance.val   + pos_balance %}
          {% set factory_wet.val       = factory_wet.val       + (c.wet_qty or 0) %}
          <tr>
            <td style="font-family:'IBM Plex Mono',monospace">
              <a href="{{ url_for('view_contract', cid=c.id) }}"
                 style="color:var(--kvpl-green);text-decoration:none;font-weight:600">{{ c.contract_no }}</a>
            </td>
            <td class="text-muted">{{ c.broker or '–' }}</td>
            <td class="td-wrap">{{ c.customer_name }}</td>
            <td class="text-muted">{{ c.sale_order_no or '–' }}</td>
            <td class="td-wrap">{{ c.material_names }}</td>
            <td class="text-right number">{{ "{:,.2f}".format(c.price) if c.price else '–' }}</td>
            {% if fg.is_cf %}
            <td class="text-right number">{{ "{:,.0f}".format(c.wet_qty) if c.wet_qty else '–' }}</td>
            {% endif %}
            <td class="text-right number">{{ "{:,.0f}".format(c.qty) }}</td>
            <td class="text-right number">{{ "{:,.3f}".format(c.delivered) }}</td>
            <td class="text-right number fw-600">
              {% if c.balance < 0 %}
                <span style="color:#7c3aed">({{ "{:,.3f}".format(c.balance|abs) }} over)</span>
              {% elif c.balance == 0 %}
                <span style="color:#146c3c">Nil</span>
              {% else %}
                {{ "{:,.3f}".format(c.balance) }}
              {% endif %}
            </td>
            <td class="due-date-cell">
              {% if c.delivery_start %}{{ c.delivery_start }} – {% endif %}{{ c.delivery_due }}
            </td>
          </tr>
        {% endfor %}
        </tbody>
        <tfoot>
          <tr class="monthly-total-row" style="background:{% if fg.is_cf %}#ede9fe{% else %}#f0fdf4{% endif %}">
            <td colspan="6" style="font-weight:700;color:{% if fg.is_cf %}#6d28d9{% else %}#15803d{% endif %}">{{ month_key }} Total</td>
            {% if fg.is_cf %}<td class="text-right number" style="font-weight:700">{{ "{:,.0f}".format(month_wet.val) }}</td>{% endif %}
            <td class="text-right number" style="font-weight:700">{{ "{:,.0f}".format(month_declared.val) }}</td>
            <td class="text-right number" style="font-weight:700">{{ "{:,.3f}".format(month_delivered.val) }}</td>
            <td class="text-right number" style="font-weight:700">{{ "{:,.3f}".format(month_balance.val) }}</td>
            <td></td>
          </tr>
        </tfoot>
      </table>
    </div>
  </div>
  {% endfor %}

  <!-- Factory Grand Total -->
  <div class="card mb-2" style="border:2px solid {% if fg.is_cf %}#7c3aed{% else %}#146c3c{% endif %}">
    <div class="table-wrap">
      <table class="report-table" style="table-layout:fixed;width:100%">
        <colgroup>
          {% if fg.is_cf %}
          <col style="width:12%"><col style="width:5%"><col style="width:12%">
          <col style="width:8%"><col style="width:11%">
          <col style="width:6%"><!-- Price -->
          <col style="width:7%"><!-- Wet Qty -->
          <col style="width:8%"><col style="width:8%"><col style="width:8%">
          <col style="width:15%">
          {% else %}
          <col style="width:13%"><col style="width:6%"><col style="width:13%">
          <col style="width:9%"><col style="width:13%">
          <col style="width:7%"><!-- Price -->
          <col style="width:9%"><col style="width:9%"><col style="width:9%">
          <col style="width:12%">
          {% endif %}
        </colgroup>
        <tfoot>
          <tr style="background:{% if fg.is_cf %}#ede9fe{% else %}#dcfce7{% endif %}">
            <td style="padding:10px 14px;font-weight:700;font-size:14px" colspan="6">
              {{ fg.name }} – Grand Total
            </td>
            {% if fg.is_cf %}
            <td class="text-right number fw-600" style="padding:10px 14px">
              {{ "{:,.0f}".format(factory_wet.val) }}
            </td>
            {% endif %}
            <td class="text-right number fw-600" style="padding:10px 14px">
              {{ "{:,.0f}".format(factory_declared.val) }}
            </td>
            <td class="text-right number fw-600" style="padding:10px 14px">
              {{ "{:,.3f}".format(factory_delivered.val) }}
            </td>
            <td class="text-right number fw-600" style="padding:10px 14px;color:{% if fg.is_cf %}#7c3aed{% else %}#146c3c{% endif %}">
              {{ "{:,.3f}".format(factory_balance.val) }}
            </td>
            <td style="padding:10px 14px"></td>
          </tr>
        </tfoot>
      </table>
    </div>
  </div>

</div>
{% endfor %}

{% endblock %}