{% extends "pos/base.html" %}
{% block title %}Advance Payments{% endblock %}
{% block heading %}Advance Payments (Hotel){% endblock %}

{% block content %}
<div class="container-fluid">

  <!-- Filter Card -->
  <div class="card shadow-sm mb-3">
    <div class="card-body">
      <form method="get" class="form-row align-items-end">
        <div class="form-group col-md-3">
          <label for="id_start">From date</label>
          <input type="date" id="id_start" name="start" class="form-control"
                 value="{{ start|date:'Y-m-d' }}">
        </div>
        <div class="form-group col-md-3">
          <label for="id_end">To date</label>
          <input type="date" id="id_end" name="end" class="form-control"
                 value="{{ end|date:'Y-m-d' }}">
        </div>
        <div class="form-group col-md-3">
          <label for="id_type">Advance type</label>
          <select id="id_type" name="type" class="form-control">
            <option value="" {% if not current_type %}selected{% endif %}>
              All (P/B + C/I)
            </option>
            <option value="pb" {% if current_type == 'pb' %}selected{% endif %}>
              Pre-booking advance only
            </option>
            <option value="ci" {% if current_type == 'ci' %}selected{% endif %}>
              Check-in advance only
            </option>
          </select>
        </div>
        <div class="form-group col-md-3 text-right">
          <button type="submit" class="btn btn-primary mt-4">
            <i class="fas fa-filter"></i> Filter
          </button>
          <a href="{% url 'hotel:reports:report_advances' %}" class="btn btn-light mt-4">
            Reset
          </a>
        </div>
      </form>
    </div>
  </div>

  <!-- Results Card -->
  <div class="card shadow-sm">
    <div class="card-header d-flex justify-content-between align-items-center">
      <div>
        <div class="small text-muted">
          Period: {{ start|date:"Y-m-d" }} → {{ end|date:"Y-m-d" }}
        </div>
        <div class="small">
          {{ type_label }}
        </div>
        <div class="mt-2">
          <span class="badge badge-pill badge-light border mr-2">
            P/B: {{ total_pb|floatformat:2 }}
          </span>
          <span class="badge badge-pill badge-light border mr-2">
            C/I: {{ total_ci|floatformat:2 }}
          </span>
          <span class="badge badge-pill badge-dark">
            Total: {{ total|floatformat:2 }}
          </span>
        </div>
      </div>
      <div>
        <div class="btn-group btn-group-sm">
          <a href="?{{ export_pdf_qs }}" class="btn btn-outline-secondary" target="_blank">
            <i class="fas fa-file-pdf"></i> PDF
          </a>
          <a href="?{{ export_excel_qs }}" class="btn btn-outline-secondary">
            <i class="fas fa-file-excel"></i> Excel
          </a>
        </div>
      </div>
    </div>

    <div class="table-responsive">
      <table class="table table-sm table-striped table-hover mb-0">
        <thead class="thead-light">
          <tr>
            <th>Date</th>
            <th>Type</th>
            <th>Booking</th>
            <th>Guest</th>
            <th>Stay</th>
            <th>Bank</th>
            <th class="text-right">Amount</th>
          </tr>
        </thead>
        <tbody>
          {% if rows %}
            {% for r in rows %}
              <tr>
                <td>{{ r.pay_date|date:"Y-m-d" }}</td>
                <td>
                  <span class="badge badge-info">
                    {{ r.adv_label }}
                  </span>
                </td>
                <td>
                  {% if r.booking_code %}
                    <div>
                      B-{{ r.booking_code }}
                    </div>
                    <div class="small text-muted">
                      {{ r.booking_source|default:"-" }} / {{ r.booking_status|default:"-" }}
                    </div>
                  {% else %}
                    <span class="text-muted">-</span>
                  {% endif %}
                </td>
                <td>
                  <div>{{ r.guest_name|default:"-" }}</div>
                  <div class="small text-muted">{{ r.guest_contact }}</div>
                </td>
                <td class="text-nowrap">
                  {% if r.checkin_date %}
                    {{ r.checkin_date|date:"Y-m-d" }} → {{ r.checkout_date|date:"Y-m-d" }}
                  {% else %}
                    <span class="text-muted">-</span>
                  {% endif %}
                </td>
                <td>
                  {% if r.bank %}
                    {{ r.bank.name }}
                  {% else %}
                    {% if r.payment.bank_id %}
                      Bank #{{ r.payment.bank_id }}
                    {% else %}
                      Cash
                    {% endif %}
                  {% endif %}
                </td>
                <td class="text-right font-weight-bold">
                  {{ r.amount|floatformat:2 }}
                </td>
              </tr>
            {% endfor %}
          {% else %}
            <tr>
              <td colspan="7" class="text-center text-muted py-4">
                No advance payments found for this period.
              </td>
            </tr>
          {% endif %}
        </tbody>
      </table>
    </div>

    <div class="card-footer text-right small text-muted">
      {{ rows|length }} record{{ rows|length|pluralize }} shown.
    </div>
  </div>

</div>
{% endblock %}