{% extends "base.html" %}
{% block content %}
<div class="container-fluid mt-3">

  <div class="d-flex justify-content-between align-items-center mb-3">
    <h4 class="mb-0">
      <i class="bi bi-list-ul me-1"></i>
      All Loans
    </h4>
    <div class="d-flex gap-2">
      <a href="{{ url_for('loan.admin_dashboard') }}" class="btn btn-outline-secondary btn-sm">
        <i class="bi bi-speedometer2"></i> Loan Dashboard
      </a>
    </div>
  </div>

  <!-- Filters -->
  <div class="card shadow-sm mb-3">
    <div class="card-header bg-light fw-semibold">
      Filters
    </div>
    <div class="card-body">
      <form class="row g-2 align-items-end" method="get" action="{{ url_for('loan.admin_loans_list') }}">
        <div class="col-md-3">
          <label class="form-label small mb-1">Employee / Code / Loan #</label>
          <input type="text"
                 name="q"
                 value="{{ request.args.get('q','') }}"
                 class="form-control form-control-sm"
                 placeholder="Search name, code or loan id">
        </div>

        <div class="col-md-3">
          <label class="form-label small mb-1">Department</label>
          <select name="department_id" class="form-select form-select-sm">
            <option value="">All</option>
            {% for dept in departments %}
              <option value="{{ dept.id }}"
                      {% if request.args.get('department_id', type=int) == dept.id %}selected{% endif %}>
                {{ dept.name }}
              </option>
            {% endfor %}
          </select>
        </div>

        <div class="col-md-3">
          <label class="form-label small mb-1">Loan Type</label>
          <select name="loan_type" class="form-select form-select-sm">
            <option value="">All</option>
            {% for lt in loan_types %}
              <option value="{{ lt.name }}"
                      {% if request.args.get('loan_type') == lt.name %}selected{% endif %}>
                {{ lt.label }}
              </option>
            {% endfor %}
          </select>
        </div>

        <div class="col-md-3">
          <label class="form-label small mb-1">Status</label>
          <select name="status" class="form-select form-select-sm">
            <option value="">All</option>
            {% set s = request.args.get('status','') %}
            {% for val,label in [
              ('requested','Requested'),
              ('under_review','Under Review'),
              ('approved','Approved'),
              ('active','Active'),
              ('closed','Closed'),
              ('rejected','Rejected'),
              ('cancelled','Cancelled')
            ] %}
              <option value="{{ val }}" {% if s == val %}selected{% endif %}>{{ label }}</option>
            {% endfor %}
          </select>
        </div>

        <div class="col-12 d-flex justify-content-end gap-2 mt-1">
          <a href="{{ url_for('loan.admin_loans_list') }}" class="btn btn-outline-secondary btn-sm">
            Clear
          </a>
          <button class="btn btn-primary btn-sm" type="submit">
            <i class="bi bi-search me-1"></i> Apply
          </button>
        </div>
      </form>
    </div>
  </div>

  <!-- Loans table -->
  <div class="card shadow-sm">
    <div class="card-header bg-light fw-semibold">
      Loans ({{ rows|length }})
    </div>
    <div class="table-responsive">
      <table class="table table-sm table-hover mb-0 align-middle">
        <thead class="table-light">
          <tr>
            <th style="width: 70px;">Loan #</th>
            <th>Employee</th>
            <th>Department</th>
            <th>Loan Type</th>
            <th class="text-end">Amount (₹)</th>
            <th class="text-end">Monthly EMI (₹)</th>
            <th class="text-center">Tenure</th>
            <th>Requested On</th>
            <th>Status</th>
            <th class="text-end">Outstanding (₹)</th>
            <th style="width: 130px;" class="text-end">Actions</th>
          </tr>
        </thead>
        <tbody>
          {% if rows %}
            {% for row in rows %}
              {% set loan = row.loan %}
              <tr>
                <td>#{{ loan.id }}</td>
                <td>
                  <div class="fw-semibold">{{ loan.employee.full_name if loan.employee else '-' }}</div>
                  <div class="small text-muted">
                    {{ loan.employee.employee_code if loan.employee else '' }}
                  </div>
                </td>
                <td class="small">
                  {{ loan.employee.department.name if loan.employee and loan.employee.department else '-' }}
                </td>
                <td class="small">
                  {{ loan.display_loan_type or loan.loan_type or '-' }}
                </td>
                <td class="text-end">
                  ₹{{ "%.2f"|format(row.loan_amount or 0) }}
                </td>
                <td class="text-end">
                  ₹{{ "%.2f"|format(row.emi_amount or 0) }}
                </td>
                <td class="text-center small">
                  {{ row.tenure_months or '-' }}
                </td>
                <td class="small">
                  {{ loan.requested_on.strftime("%d-%b-%Y") if loan.requested_on else '-' }}
                </td>
                <td class="small">
                  {% set st = (loan.status or '') %}
                  {% set st_lower = st.lower() %}
                  {% if st_lower in ['requested','under_review'] %}
                    <span class="badge bg-warning text-dark">{{ st.replace('_',' ')|title }}</span>
                  {% elif st_lower in ['approved','active'] %}
                    <span class="badge bg-success">Approved / Active</span>
                  {% elif st_lower == 'closed' %}
                    <span class="badge bg-secondary">Closed</span>
                  {% elif st_lower == 'rejected' %}
                    <span class="badge bg-danger">Rejected</span>
                  {% elif st_lower == 'cancelled' %}
                    <span class="badge bg-dark">Cancelled</span>
                  {% else %}
                    <span class="badge bg-light text-dark">{{ st or 'Unknown' }}</span>
                  {% endif %}
                </td>
                <td class="text-end fw-semibold {% if row.outstanding > 0 %}text-danger{% endif %}">
                  ₹{{ "%.2f"|format(row.outstanding or 0) }}
                </td>
                <td class="text-end">
                  <div class="btn-group btn-group-sm">
                    <a href="{{ url_for('loan.admin_detail', loan_id=loan.id) }}"
                       class="btn btn-outline-primary">
                      Review
                    </a>
                    <a href="{{ url_for('loan.loan_detail', loan_id=loan.id) }}"
                       class="btn btn-outline-secondary">
                      View
                    </a>
                  </div>
                </td>
              </tr>
            {% endfor %}
          {% else %}
            <tr>
              <td colspan="11" class="text-center text-muted py-3">
                No loans found for the selected filters.
              </td>
            </tr>
          {% endif %}
        </tbody>
      </table>
    </div>
  </div>

</div>
{% endblock %}