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

{% block title %}Advance Salary Report{% endblock %}

{% block content %}
<div class="container py-4">
  <h2 class="d-flex justify-content-between align-items-center">
    Advance Salary Report
    <button class="btn btn-outline-secondary btn-sm" data-bs-toggle="modal" data-bs-target="#helpModal">
      ?
    </button>
  </h2>

  <form method="get" class="row g-2 align-items-end mb-4">
    <div class="col-auto">
      <label for="start_date" class="form-label">From</label>
      <input type="date" id="start_date" name="start_date" class="form-control"
             value="{{ start_date|date:'Y-m-d' }}">
    </div>
    <div class="col-auto">
      <label for="end_date" class="form-label">To</label>
      <input type="date" id="end_date" name="end_date" class="form-control"
             value="{{ end_date|date:'Y-m-d' }}">
    </div>
    <div class="col-auto">
      <button type="submit" class="btn btn-primary">Filter</button>
      <a href="{% url 'payroll:advance_salary_excel' %}?start_date={{ start_date }}&end_date={{ end_date }}"
         class="btn btn-sm btn-outline-success">Excel</a>
      <a href="{% url 'payroll:advance_salary_pdf' %}?start_date={{ start_date }}&end_date={{ end_date }}"
         class="btn btn-sm btn-outline-secondary" target="_blank">PDF</a>
    </div>
  </form>

  <div class="table-responsive">
    <table class="table table-striped table-bordered">
      <thead class="table-light">
        <tr>
          <th>Staff</th>
          <th class="text-end">Advance Taken</th>
        </tr>
      </thead>
      <tbody>
        {% for r in data %}
          <tr>
            <td>{{ r.staff_name }}</td>
            <td class="text-end">{{ r.advance|floatformat:2 }}</td>
          </tr>
        {% empty %}
          <tr><td colspan="2" class="text-center">No advances recorded.</td></tr>
        {% endfor %}
      </tbody>
      <tfoot class="table-secondary">
        <tr>
          <th class="text-end">Total:</th>
          <th class="text-end">{{ totals.advance|floatformat:2 }}</th>
        </tr>
      </tfoot>
    </table>
  </div>
</div>

<!-- Help Modal -->
<div class="modal fade" id="helpModal" tabindex="-1">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title">Advance Salary Help</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
      </div>
      <div class="modal-body">
        <p>This report lists all salary advances taken by staff in the selected date range.</p>
      </div>
    </div>
  </div>
</div>
{% endblock %}