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

{% block title %}Spot Trip Report{% endblock %}

{% block heading %}
  Spot Trip Summary Report
{% endblock %}

{% block content %}

<form method="get" class="mb-3">
  <div class="form-row">
    <div class="col-md-2">
      <label class="small mb-1">Date From</label>
      <input type="date"
             name="date_from"
             class="form-control form-control-sm"
             value="{{ date_from_q }}">
    </div>
    <div class="col-md-2">
      <label class="small mb-1">Date To</label>
      <input type="date"
             name="date_to"
             class="form-control form-control-sm"
             value="{{ date_to_q }}">
    </div>
    <div class="col-md-3">
      <label class="small mb-1">Staff / Driver</label>
      <select name="staff_id"
              class="form-control form-control-sm">
        <option value="">— All —</option>
        {% for s in staff_list %}
          <option value="{{ s.t_id }}"
                  {% if staff_id_q|default:'' == s.t_id|stringformat:"s" %}selected{% endif %}>
            {{ s.name }}
          </option>
        {% endfor %}
      </select>
    </div>
    <div class="col-md-2">
      <label class="small mb-1">Status</label>
      <select name="status"
              class="form-control form-control-sm">
        <option value="" {% if not status_q %}selected{% endif %}>All</option>
        <option value="OPEN" {% if status_q == 'OPEN' %}selected{% endif %}>OPEN</option>
        <option value="SETTLED" {% if status_q == 'SETTLED' %}selected{% endif %}>SETTLED</option>
      </select>
    </div>
    <div class="col-md-3 d-flex align-items-end">
      <button type="submit"
              class="btn btn-primary btn-sm mr-2">
        Filter
      </button>
      <a href="{% url 'sales:spottrip_report' %}"
         class="btn btn-light btn-sm">
        Reset
      </a>
      <a href="{% url 'sales:spottrip_list' %}"
         class="btn btn-secondary btn-sm ml-2">
        &laquo; Back to Trips
      </a>
    </div>
  </div>
</form>

<div class="section-card">
  <h6>Summary (per Trip)</h6>
  <div class="table-responsive">
    <table class="table table-sm table-bordered table-striped">
      <thead class="thead-light">
        <tr>
          <th style="width: 40px;">#</th>
          <th style="width: 90px;">Date</th>
          <th style="width: 70px;">Trip #</th>
          <th style="width: 130px;">Staff / Driver</th>
          <th style="width: 130px;">Vehicle</th>
          <th>Route</th>
          <th style="width: 80px;">Status</th>
          <th style="width: 110px;" class="text-right">Trip Amount<br><small>(Net Sale)</small></th>
          <th style="width: 110px;" class="text-right">Expenses</th>
          <th style="width: 130px;" class="text-right">Final Expected</th>
          <th style="width: 130px;" class="text-right">Final Received</th>
          <th style="width: 110px;" class="text-right">Variance</th>
          <th style="width: 70px;"></th>
        </tr>
      </thead>
      <tbody>
        {% if rows %}
          {% for r in rows %}
            <tr>
              <td class="text-center">{{ forloop.counter }}</td>
              <td>{{ r.trip.transaction_date|date:"Y-m-d" }}</td>
              <td class="text-center">{{ r.trip.trip_no }}</td>
              <td>
                {% if r.staff %}
                  {{ r.staff.name }}
                {% else %}
                  &mdash;
                {% endif %}
              </td>
              <td>{{ r.vehicle_desc|default_if_none:"" }}</td>
              <td>{{ r.route_desc|default_if_none:"" }}</td>
              <td class="text-center">{{ r.trip.status }}</td>

              <td class="text-right">{{ r.net_sale|floatformat:2 }}</td>
              <td class="text-right">{{ r.expense_total|floatformat:2 }}</td>
              <td class="text-right">{{ r.final_expected|floatformat:2 }}</td>
              <td class="text-right">{{ r.final_received|floatformat:2 }}</td>
              <td class="text-right">{{ r.variance|floatformat:2 }}</td>

              <td class="text-center">
                <a href="{% url 'sales:spottrip_edit' trip_no=r.trip.trip_no %}"
                   class="btn btn-xs btn-outline-primary">
                  View
                </a>
              </td>
            </tr>
          {% endfor %}
          <tr class="font-weight-bold bg-light">
            <td colspan="7" class="text-right">TOTAL</td>
            <td class="text-right">{{ total_net_sale|floatformat:2 }}</td>
            <td class="text-right">{{ total_expense|floatformat:2 }}</td>
            <td class="text-right">{{ total_final_expected|floatformat:2 }}</td>
            <td class="text-right">{{ total_final_received|floatformat:2 }}</td>
            <td class="text-right">{{ total_variance|floatformat:2 }}</td>
            <td></td>
          </tr>
        {% else %}
          <tr>
            <td colspan="13" class="text-center text-muted">
              No trips found for selected filters.
            </td>
          </tr>
        {% endif %}
      </tbody>
    </table>
  </div>
</div>

{% endblock %}