{% extends "base.html" %} {% block content %}

📊 Reports

System Statistics

{{ stats.total_books }}
Total Books
{{ stats.books_issued }}
Books Issued
{{ stats.overdue_books }}
Overdue Books

📚 All Issues

{% if issues %} {% for issue in issues %} {% endfor %}
Issue ID Student ID Book ID Issue Date Due Date Status
{{ issue.issue_id }} {{ issue.student_id }} {{ issue.book_id }} {{ issue.issue_date.strftime('%Y-%m-%d') }} {{ issue.due_date.strftime('%Y-%m-%d') }} {% if issue.status == 'returned' %} ✓ Returned {% elif issue.is_overdue() %} ⚠ Overdue {% else %} 📖 Active {% endif %}
{% else %}

No issues found

{% endif %}

âš  Overdue Books

{% if overdue %} {% for issue in overdue %} {% endfor %}
Issue ID Student ID Book ID Due Date Days Overdue
{{ issue.issue_id }} {{ issue.student_id }} {{ issue.book_id }} {{ issue.due_date.strftime('%Y-%m-%d') }} {{ issue.days_overdue() }} days
{% else %}

No overdue books

{% endif %}
{% endblock %}