{% extends "pos/base.html" %}
{% block heading %}Sale History – {{ cust.name }}{% endblock heading %}

{% block content %}
<form method="get" class="form-inline mb-3">
  <label class="mr-2">From:</label>
  <input type="date" name="date_from" class="form-control mr-3" value="{{ date_from }}">
  <label class="mr-2">To:</label>
  <input type="date" name="date_to" class="form-control mr-3" value="{{ date_to }}">
  <button class="btn btn-primary">Search</button>
</form>

<div class="mb-3">
  <a href="{{ export_excel_url }}?{{ query_string }}" class="btn btn-success">Export Excel</a>
  <a href="{{ export_pdf_url }}?{{ query_string }}" class="btn btn-danger">Export PDF</a>
</div>

<table class="table table-bordered">
  <thead>
    <tr>
      <th>Invoice</th><th>Product</th><th>Qty</th><th>Item Price</th>
      <th>Discount</th><th>Total Price</th><th>Date</th><th>Salesman</th>
    </tr>
  </thead>
  <tbody>
    {% for r in rows %}
    <tr>
      <td>{{ r.invoice_no }}</td><td>{{ r.product }}</td><td>{{ r.quantity }}</td>
      <td>{{ r.item_price }}</td><td>{{ r.discount }}</td>
      <td>{{ r.total_price }}</td><td>{{ r.sale_date }}</td><td>{{ r.saleman_name }}</td>
    </tr>
    {% endfor %}
  </tbody>
  <tfoot>
    <tr>
      <th colspan="2" class="text-right">Totals:</th>
      <th>{{ total_qty }}</th><th></th><th></th>
      <th>{{ grand_total }}</th><th></th><th></th>
    </tr>
  </tfoot>
</table>
{% endblock %}