{% extends 'base.html' %}
{% block title %}Lodge Reports{% endblock %}
{% block page_title %}Lodge Reports{% endblock %}

{% block content %}
<div class="text-muted small mb-3">Report as of {{ today|date:"l, d F Y" }}</div>

<!-- Summary Stats -->
<div class="row g-3 mb-4">
  <div class="col-6 col-md-3">
    <div class="stat-card">
      <div class="icon bg-primary bg-opacity-10 text-primary"><i class="bi bi-building"></i></div>
      <div><div class="label">Hotels</div><div class="value">{{ total_hotels }}</div></div>
    </div>
  </div>
  <div class="col-6 col-md-3">
    <div class="stat-card">
      <div class="icon bg-success bg-opacity-10 text-success"><i class="bi bi-door-open"></i></div>
      <div><div class="label">Available Rooms</div><div class="value">{{ available_rooms }} / {{ total_rooms }}</div></div>
    </div>
  </div>
  <div class="col-6 col-md-3">
    <div class="stat-card">
      <div class="icon bg-danger bg-opacity-10 text-danger"><i class="bi bi-person-fill"></i></div>
      <div><div class="label">Occupied</div><div class="value">{{ occupied_rooms }}</div></div>
    </div>
  </div>
  <div class="col-6 col-md-3">
    <div class="stat-card">
      <div class="icon bg-warning bg-opacity-10 text-warning"><i class="bi bi-people"></i></div>
      <div><div class="label">Guests</div><div class="value">{{ total_guests }}</div></div>
    </div>
  </div>
  <div class="col-6 col-md-3">
    <div class="stat-card">
      <div class="icon bg-success bg-opacity-10 text-success"><i class="bi bi-cash-stack"></i></div>
      <div><div class="label">Total Revenue</div><div class="value" style="font-size:1rem;">TSh {{ total_revenue|floatformat:0 }}</div></div>
    </div>
  </div>
  <div class="col-6 col-md-3">
    <div class="stat-card">
      <div class="icon bg-info bg-opacity-10 text-info"><i class="bi bi-cash"></i></div>
      <div><div class="label">Today's Revenue</div><div class="value" style="font-size:1rem;">TSh {{ today_revenue|floatformat:0 }}</div></div>
    </div>
  </div>
  <div class="col-6 col-md-3">
    <div class="stat-card">
      <div class="icon bg-primary bg-opacity-10 text-primary"><i class="bi bi-calendar2-week"></i></div>
      <div><div class="label">Active Bookings</div><div class="value">{{ active_bookings }}</div></div>
    </div>
  </div>
  <div class="col-6 col-md-3">
    <div class="stat-card">
      <div class="icon bg-secondary bg-opacity-10 text-secondary"><i class="bi bi-archive"></i></div>
      <div><div class="label">All Bookings</div><div class="value">{{ total_bookings }}</div></div>
    </div>
  </div>
</div>

<div class="row g-3 mb-4">
  <!-- Today's Check-Ins -->
  <div class="col-md-6">
    <div class="card h-100">
      <div class="card-header"><i class="bi bi-box-arrow-in-right me-2 text-success"></i>Today's Check-Ins ({{ today_checkins|length }})</div>
      <div class="table-responsive">
        <table class="table table-sm mb-0">
          <thead><tr><th>Guest</th><th>Hotel / Room</th><th>Nights</th><th>Status</th></tr></thead>
          <tbody>
            {% for bk in today_checkins %}
            <tr>
              <td><a href="{% url 'booking_detail' bk.pk %}" class="text-decoration-none">{{ bk.guest.full_name }}</a></td>
              <td>{{ bk.room.hotel.name }} / {{ bk.room.room_number }}</td>
              <td>{{ bk.number_of_nights }}</td>
              <td>
                {% if bk.booking_status == 'reserved' %}<span class="badge bg-info text-dark">Reserved</span>
                {% else %}<span class="badge bg-success">In</span>{% endif %}
              </td>
            </tr>
            {% empty %}
            <tr><td colspan="4" class="text-center text-muted py-2">No check-ins today.</td></tr>
            {% endfor %}
          </tbody>
        </table>
      </div>
    </div>
  </div>

  <!-- Today's Check-Outs -->
  <div class="col-md-6">
    <div class="card h-100">
      <div class="card-header"><i class="bi bi-box-arrow-right me-2 text-warning"></i>Due Checkout Today ({{ today_checkouts|length }})</div>
      <div class="table-responsive">
        <table class="table table-sm mb-0">
          <thead><tr><th>Guest</th><th>Hotel / Room</th><th>Balance</th><th></th></tr></thead>
          <tbody>
            {% for bk in today_checkouts %}
            <tr>
              <td><a href="{% url 'booking_detail' bk.pk %}" class="text-decoration-none">{{ bk.guest.full_name }}</a></td>
              <td>{{ bk.room.hotel.name }} / {{ bk.room.room_number }}</td>
              <td class="{% if bk.get_balance > 0 %}text-danger{% else %}text-success{% endif %}">
                TSh {{ bk.get_balance|floatformat:0 }}
              </td>
              <td>
                <form method="post" action="{% url 'booking_checkout' bk.pk %}">
                  {% csrf_token %}
                  <button type="submit" class="btn btn-xs btn-warning btn-sm text-dark py-0 px-2">Checkout</button>
                </form>
              </td>
            </tr>
            {% empty %}
            <tr><td colspan="4" class="text-center text-muted py-2">No checkouts due today.</td></tr>
            {% endfor %}
          </tbody>
        </table>
      </div>
    </div>
  </div>
</div>

<!-- Recent Bookings -->
<div class="card">
  <div class="card-header d-flex justify-content-between align-items-center">
    <span><i class="bi bi-clock-history me-2"></i>Recent Bookings</span>
    <a href="{% url 'booking_list' %}" class="btn btn-sm btn-outline-primary">View All</a>
  </div>
  <div class="table-responsive">
    <table class="table table-hover table-sm mb-0 align-middle">
      <thead>
        <tr>
          <th>Booking</th>
          <th>Guest</th>
          <th>Hotel / Room</th>
          <th>Check-In</th>
          <th>Check-Out</th>
          <th>Amount</th>
          <th>Status</th>
        </tr>
      </thead>
      <tbody>
        {% for bk in recent_bookings %}
        <tr>
          <td><a href="{% url 'booking_detail' bk.pk %}" class="text-decoration-none"><code>BK{{ bk.pk|stringformat:"04d" }}</code></a></td>
          <td>{{ bk.guest.full_name }}</td>
          <td>{{ bk.room.hotel.name }} / {{ bk.room.room_number }}</td>
          <td>{{ bk.check_in_date|date:"d M Y" }}</td>
          <td>{{ bk.check_out_date|date:"d M Y" }}</td>
          <td>TSh {{ bk.total_amount|floatformat:0 }}</td>
          <td>
            {% if bk.booking_status == 'reserved' %}<span class="badge bg-info text-dark">Reserved</span>
            {% elif bk.booking_status == 'checked_in' %}<span class="badge bg-success">Checked In</span>
            {% elif bk.booking_status == 'checked_out' %}<span class="badge bg-secondary">Checked Out</span>
            {% else %}<span class="badge bg-danger">Cancelled</span>{% endif %}
          </td>
        </tr>
        {% empty %}
        <tr><td colspan="7" class="text-center text-muted py-3">No bookings yet.</td></tr>
        {% endfor %}
      </tbody>
    </table>
  </div>
</div>
{% endblock %}