{% extends "pos/base.html" %}
{% load static %}

{% block title %}Checkout Report{% endblock %}
{% block heading %}Checkout Report{% endblock %}

{% block stylesheets %}
<style>
  .cor-wrap{
    max-width:1480px;
    margin:0 auto;
  }

  .cor-card{
    background:#fff;
    border:1px solid #e5e7eb;
    border-radius:12px;
    box-shadow:0 3px 12px rgba(15,23,42,.05);
    margin-bottom:12px;
  }

  .cor-head{
    padding:10px 12px;
    border-bottom:1px solid #eef2f7;
    display:flex;
    justify-content:space-between;
    align-items:center;
    gap:10px;
    flex-wrap:wrap;
  }

  .cor-title{
    font-size:15px;
    font-weight:900;
    color:#0f172a;
  }

  .cor-body{
    padding:12px;
  }

  .filter-row{
    display:flex;
    gap:8px;
    flex-wrap:wrap;
    align-items:end;
  }

  .filter-row .form-group{
    margin-bottom:0;
  }

  .filter-row label{
    font-size:12px;
    margin-bottom:3px;
    color:#64748b;
  }

  .mini-kpis{
    display:grid;
    grid-template-columns:repeat(6, minmax(0, 1fr));
    gap:10px;
    margin-bottom:12px;
  }

  .mini-kpi{
    background:#fff;
    border:1px solid #e5e7eb;
    border-radius:12px;
    padding:13px;
  }

  .mini-kpi .label{
    font-size:12px;
    color:#64748b;
    font-weight:700;
  }

  .mini-kpi .value{
    font-size:22px;
    color:#0f172a;
    font-weight:900;
    line-height:1.2;
  }

  .mini-kpi .sub{
    font-size:11px;
    color:#64748b;
  }

  .k-slate{border-top:4px solid #475569;}
  .k-blue{border-top:4px solid #2563eb;}
  .k-purple{border-top:4px solid #7c3aed;}
  .k-green{border-top:4px solid #059669;}
  .k-red{border-top:4px solid #dc2626;}
  .k-orange{border-top:4px solid #d97706;}

  .refund-money{
    color:#d97706;
  }

  .cor-table th,
  .cor-table td{
    vertical-align:middle !important;
    font-size:12px;
  }

  .cor-table thead th{
    background:#f8fafc;
    color:#334155;
    font-weight:900;
  }

  .cor-table tfoot th{
    background:#f8fafc;
    font-weight:900;
  }

  .money{
    text-align:right;
    font-weight:900;
    white-space:nowrap;
  }

  .num{
    text-align:right;
    white-space:nowrap;
  }

  .inv-badge{
    display:inline-block;
    padding:3px 8px;
    border-radius:999px;
    background:#eff6ff;
    color:#1d4ed8;
    font-size:11px;
    font-weight:800;
  }

  .status-badge{
    display:inline-block;
    padding:3px 8px;
    border-radius:999px;
    background:#f1f5f9;
    color:#334155;
    font-size:11px;
    font-weight:800;
  }

  .action-btns{
    display:flex;
    gap:5px;
    flex-wrap:wrap;
  }

  @media(max-width:1100px){
    .mini-kpis{
      grid-template-columns:1fr;
    }
  }
</style>
{% endblock %}

{% block content %}
<div class="cor-wrap">

  <!-- Filter -->
  <div class="cor-card">
    <div class="cor-head">
      <div>
        <div class="cor-title">Checkout Report</div>
        <small class="text-muted">
          {{ start|date:"Y-m-d" }} → {{ end|date:"Y-m-d" }}
        </small>
      </div>

      <div class="d-flex" style="gap:8px;">
       <a
          href="{% url 'hotel:reports:checkout_report_pdf' %}?start={{ start|date:'Y-m-d' }}&end={{ end|date:'Y-m-d' }}"
          target="_blank"
          class="btn btn-sm btn-danger"
        >
          Print PDF
        </a>

        <a href="?{{ export_qs }}" class="btn btn-sm btn-outline-success">
          Export CSV
        </a>
      </div>
    </div>

    <div class="cor-body">
      <form method="get" class="filter-row">
        <div class="form-group">
          <label>Start</label>
          <input
            type="date"
            name="start"
            class="form-control form-control-sm"
            value="{{ start|date:'Y-m-d' }}"
          >
        </div>

        <div class="form-group">
          <label>End</label>
          <input
            type="date"
            name="end"
            class="form-control form-control-sm"
            value="{{ end|date:'Y-m-d' }}"
          >
        </div>

        <div class="form-group">
          <button class="btn btn-sm btn-primary">Apply</button>
        </div>
      </form>
    </div>
  </div>

  <!-- Top Cards -->
  <div class="mini-kpis">

    <div class="mini-kpi k-slate">
      <div class="label">Total Checkouts</div>
      <div class="value">{{ total_checkouts }}</div>
      <div class="sub">Selected date range</div>
    </div>

    <div class="mini-kpi k-blue">
      <div class="label">Grand Total</div>
      <div class="value">Rs {{ total_grand|floatformat:0 }}</div>
      <div class="sub">Final bill amount</div>
    </div>

    <div class="mini-kpi k-purple">
      <div class="label">Advance</div>
      <div class="value">Rs {{ total_advance|floatformat:0 }}</div>
      <div class="sub">P/B + C/I advance</div>
    </div>

    <div class="mini-kpi k-green">
      <div class="label">Received</div>
      <div class="value">Rs {{ total_received|floatformat:0 }}</div>
      <div class="sub">Paid at checkout</div>
    </div>

    <div class="mini-kpi k-red">
      <div class="label">Total Due</div>
      <div class="value">Rs {{ total_due|floatformat:0 }}</div>
      <div class="sub">Amount receivable from guests</div>
    </div>

    <div class="mini-kpi k-orange">
      <div class="label">Total Refund</div>
      <div class="value">Rs {{ total_refund|floatformat:0 }}</div>
      <div class="sub">Amount refundable to guests</div>
    </div>

  </div>

  <!-- Table -->
  <div class="cor-card">
    <div class="cor-head">
      <div class="cor-title">Checkout Detail</div>
      <small class="text-muted">Finalized checkout invoices</small>
    </div>

    <div class="table-responsive">
      <table class="table table-sm table-bordered mb-0 cor-table">
        <thead>
          <tr>
            <th>Invoice</th>
            <th>T#</th>
            <th>Guest</th>
            <th>Rooms</th>
            <th>Check-in</th>
            <th>Checkout</th>
            <th class="num">Nights</th>
            <th class="money">Grand Total</th>
            <th class="money">Advance</th>
            <!-- <th class="money">Received</th>
            <th class="money">Balance</th>
            <th style="width:170px;">Actions</th> -->
            <th class="money">Received</th>
            <th class="money">Due</th>
            <th class="money">Refund</th>
            <th style="width:170px;">Actions</th>
          </tr>
        </thead>

        <tbody>
          {% for r in rows %}
            <tr>
              <td>
                <span class="inv-badge">INV#{{ r.invoice_no }}</span>
              </td>

              <td>
                T#{{ r.booking_tid }}
              </td>

              <td>
                <b>{{ r.guest_name|default:"-" }}</b>
                {% if r.guest_contact %}
                  <br>
                  <small class="text-muted">{{ r.guest_contact }}</small>
                {% endif %}
              </td>

              <td>{{ r.rooms }}</td>

              <td>{{ r.checkin_date|date:"Y-m-d" }}</td>
              <td>{{ r.checkout_date|date:"Y-m-d" }}</td>

              <td class="num">{{ r.nights }}</td>

              <td class="money">Rs {{ r.grand_total|floatformat:0 }}</td>
              <td class="money">Rs {{ r.advance_paid|floatformat:0 }}</td>
              <td class="money text-success">
  Rs {{ r.paid_total|floatformat:0 }}
</td>

<td class="money text-danger">
  Rs {{ r.due_total|floatformat:0 }}
</td>

<td class="money refund-money">
  Rs {{ r.refund_due|floatformat:0 }}
</td>

<td>
                <div class="action-btns">
                  <a
                    href="{% url 'hotel:reports:checkout_report_detail' r.invoice_no %}"
                    class="btn btn-sm btn-info"
                  >
                    View
                  </a>

                  <a
                    href="{% url 'hotel:checkout:checkout_pdf' r.booking_tid %}"
                    target="_blank"
                    class="btn btn-sm btn-danger"
                  >
                    Invoice
                  </a>
                </div>
              </td>
            </tr>
          {% empty %}
            <tr>
              <td colspan="13" class="text-center text-muted py-3">
                No checkout found in selected period.
              </td>
            </tr>
          {% endfor %}
        </tbody>

        <tfoot>
          <tr>
            <th colspan="7">Total</th>

            <th class="money">
              Rs {{ total_grand|floatformat:0 }}
            </th>

            <th class="money">
              Rs {{ total_advance|floatformat:0 }}
            </th>

            <th class="money text-success">
              Rs {{ total_received|floatformat:0 }}
            </th>

            <th class="money text-danger">
              Rs {{ total_due|floatformat:0 }}
            </th>

            <th class="money refund-money">
              Rs {{ total_refund|floatformat:0 }}
            </th>

            <th></th>
          </tr>
        </tfoot>
      </table>
    </div>
  </div>

</div>
{% endblock %}