{# templates/sales/contracts_report.html #}
{% extends "pos/base.html" %}
{% load humanize %}

{% block content %}
<div class="container-fluid">
  <h2>Contracts Summary</h2>

  <!-- Filters -->
  <form method="get" class="form-inline mb-3">

    <div class="form-group mr-2">
      <label for="customer_id" class="mr-1">Customer</label>
      <select name="customer_id" id="customer_id" class="form-control">
        <option value="">All</option>
        {% for cust in customers %}
          <option value="{{ cust.t_id }}"
            {% if filters.customer_id|default:''|add:'' == cust.t_id|stringformat:"s" %}selected{% endif %}>
            {{ cust.name }}
          </option>
        {% endfor %}
      </select>
    </div>

    <div class="form-group mr-2">
      <label for="status" class="mr-1">Status</label>
      <select name="status" id="status" class="form-control">
        <option value="OPEN"   {% if filters.status == "OPEN"   %}selected{% endif %}>Open</option>
        <option value="CLOSED" {% if filters.status == "CLOSED" %}selected{% endif %}>Closed</option>
        <option value="ALL"    {% if filters.status == "ALL"    %}selected{% endif %}>All</option>
      </select>
    </div>

    <div class="form-group mr-2">
      <label for="date_from" class="mr-1">From</label>
      <input type="date" name="date_from" id="date_from"
             value="{{ filters.date_from }}" class="form-control">
    </div>

    <div class="form-group mr-2">
      <label for="date_to" class="mr-1">To</label>
      <input type="date" name="date_to" id="date_to"
             value="{{ filters.date_to }}" class="form-control">
    </div>

    <button type="submit" class="btn btn-primary mr-2">Apply Filter</button>

    <!-- Export buttons -->
    {% if base_query %}
      <a href="?{{ base_query }}&export=excel" class="btn btn-success mr-2">Export Excel</a>
      <a href="?{{ base_query }}&export=pdf"   class="btn btn-secondary">Export PDF</a>
    {% else %}
      <a href="?export=excel" class="btn btn-success mr-2">Export Excel</a>
      <a href="?export=pdf"   class="btn btn-secondary">Export PDF</a>
    {% endif %}
  </form>

  <div class="table-responsive">
    <table class="table table-bordered table-sm">
      <thead class="thead-light">
        <tr>
          <th>#</th>
          <th>Contract No</th>
          <th>Title</th>
          <th>Customer</th>
          <th>Status</th>
          <th class="text-right">Contract Amount</th>
          <th class="text-right">Invoice Count</th>
          <th class="text-right">Invoiced Total</th>
          <th class="text-right">Received Total</th>
          <th class="text-right">Expenses</th>
          <th class="text-right">Gross Profit</th>
          <th class="text-right">Net Profit</th>
          <th class="text-right">% Complete</th>
          <th>Actions</th>
        </tr>
      </thead>
      <tbody>
        {% if rows %}
          {% for row in rows %}
            {% with c=row.contract cust=row.customer %}
            <tr>
              <td>{{ forloop.counter }}</td>
              <td>{{ c.contract_no|default:c.id }}</td>
              <td>{{ c.title|default:"" }}</td>
              <td>{{ cust.name }}</td>
              <td>{{ c.status|upper }}</td>

              <td class="text-right">{{ row.contract_amount|floatformat:2 }}</td>
              <td class="text-right">{{ row.invoice_count }}</td>
              <td class="text-right">{{ row.invoice_total|floatformat:2 }}</td>
              <td class="text-right">{{ row.received_total|floatformat:2 }}</td>
              <td class="text-right">{{ row.expense_total|floatformat:2 }}</td>
              <td class="text-right">{{ row.gross_profit|floatformat:2 }}</td>
              <td class="text-right">{{ row.net_profit|floatformat:2 }}</td>
              <td class="text-right">{{ row.completion_pct|floatformat:2 }}%</td>
              <td>
                <a href="{% url 'sales:contracts_edit' c.id %}" class="btn btn-sm btn-outline-primary">
                  Edit
                </a>

                <a href="{% url 'reports:contract_detail' c.id %}"
                   class="btn btn-sm btn-info">
                  View
                </a>


              </td>
            </tr>
            {% endwith %}
          {% endfor %}
        {% else %}
          <tr>
            <td colspan="14" class="text-center">No contracts found.</td>
          </tr>
        {% endif %}
      </tbody>

      <tfoot>
        <tr class="font-weight-bold">
          <td colspan="4">Grand Totals</td>
          <td></td>
          <td class="text-right">{{ grand.contract_amount|floatformat:2 }}</td>
          <td class="text-right">{{ grand.invoice_count }}</td>
          <td class="text-right">{{ grand.invoice_total|floatformat:2 }}</td>
          <td class="text-right">{{ grand.received_total|floatformat:2 }}</td>
          <td class="text-right">{{ grand.expense_total|floatformat:2 }}</td>
          <td class="text-right">{{ grand.gross_profit|floatformat:2 }}</td>
          <td class="text-right">{{ grand.net_profit|floatformat:2 }}</td>
          <td></td>
          <td></td>
        </tr>
      </tfoot>
    </table>
  </div>
</div>
{% endblock %}