{% extends 'admin_pages/base_admin.html' %}
{% block title %}Comprehensive Report{% endblock %}

{% block content %}
<h2 class="mb-4">Comprehensive Report</h2>
<nav aria-label="breadcrumb" class="mb-3">
  <ol class="breadcrumb">
    <li class="breadcrumb-item"><a href="{% url 'inventory:admin_page' %}">Dashboard</a></li>
    <li class="breadcrumb-item active" aria-current="page">Comprehensive Report</li>
  </ol>
</nav>
{% if start_date and end_date %}
<p class="text-muted">Report from {{ start_date }} to {{ end_date }}</p>
{% endif %}
<p class="text-muted">Printed by {{ current_user_name }} on {{ current_date }}</p>
<div class="card">
  <div class="card-body">
    <div class="table-responsive">
      <table class="table table-bordered table-striped mb-0">
        <tbody>
          <tr class="table-light">
            <th colspan="2">Cash Summary</th>
          </tr>
          {% for item in cash_summary %}
          <tr>
            <td>{{ item.account_type }}</td>
            <td>{{ item.total_balance|floatformat:2 }}</td>
          </tr>
          {% empty %}
          <tr><td colspan="2" class="text-center">No data</td></tr>
          {% endfor %}

        </tbody>
      </table>
    </div>
    <div class="row row-cols-1 row-cols-sm-2 row-cols-lg-3 g-3 mt-4">
      <div class="col">
        <div class="card shadow-sm text-center h-100">
          <div class="card-body">
            <h6 class="card-title">Total Collection from Consumers</h6>
            <p class="fs-5 mb-0">{{ consumer_collection_total|floatformat:2 }}</p>
          </div>
        </div>
      </div>
      <div class="col">
        <div class="card shadow-sm text-center h-100">
          <div class="card-body">
            <h6 class="card-title">Outstanding with Consumers</h6>
            <p class="fs-5 mb-0">{{ consumer_outstanding_total|floatformat:2 }}</p>
          </div>
        </div>
      </div>
      <div class="col">
        <div class="card shadow-sm text-center h-100">
          <div class="card-body">
            <h6 class="card-title">Total Expenses</h6>
            <p class="fs-5 mb-0">{{ expense_total|floatformat:2 }}</p>
          </div>
        </div>
      </div>
      <div class="col">
        <div class="card shadow-sm text-center h-100">
          <div class="card-body">
            <h6 class="card-title">Total Payment to Doctors</h6>
            <p class="fs-5 mb-0">{{ doctor_payment_total|floatformat:2 }}</p>
          </div>
        </div>
      </div>
      <div class="col">
        <div class="card shadow-sm text-center h-100">
          <div class="card-body">
            <h6 class="card-title">Outstanding to Doctors</h6>
            <p class="fs-5 mb-0">{{ doctor_outstanding_total|floatformat:2 }}</p>
          </div>
        </div>
      </div>
    </div>
    <a href="{% url 'finance:comprehensive_report' %}" class="btn btn-secondary mt-3">Back</a>
  </div>
</div>
{% endblock %}