#!/usr/bin/env python3 """ Comprehensive script to enhance all report pages with modern styling """ import os import re def create_enhanced_interest_income_report(): """Create enhanced interest income report template""" template = '''{% extends 'base.html' %} {% load humanize %} {% load static %} {% block title %}Interest Income Report{% endblock %} {% block extra_css %} {% endblock %} {% block content %}

Interest Income Report

Analysis of interest income from active loans

Generated on {{ "now"|date:"F d, Y" }} at {{ "now"|date:"g:i A" }}
Back to Dashboard Export PDF Export CSV

Advanced Filters

Total Interest Income

KES {{ report_data.summary.total_interest_income|default:0|floatformat:2|intcomma }}

Revenue from interest

Interest Bearing Loans

{{ report_data.summary.total_loans|default:0 }}

Active loan count

Average Interest Rate

{{ report_data.summary.average_interest_rate|default:0|floatformat:1 }}%

Mean rate across loans

Monthly Growth

{{ report_data.summary.monthly_growth|default:0|floatformat:1 }}%

Growth rate

Interest Income Details

{% if report_data.income_details %}

{{ report_data.income_details|length }} interest income record{{ report_data.income_details|length|pluralize }} found

{% endif %}
Detailed View
{% if report_data.income_details %}
{% for income in report_data.income_details %} {% endfor %}
Loan # Borrower Principal Interest Rate Interest Earned Status
{{ income.loan_number }}
{{ income.borrower_name }}
 KES {{ income.principal_amount|floatformat:2|intcomma }} {{ income.interest_rate|floatformat:1 }}% KES {{ income.interest_earned|floatformat:2|intcomma }} {% if income.status == 'active' %} {{ income.status|title }} {% elif income.status == 'paid' %} {{ income.status|title }} {% else %} {{ income.status|title }} {% endif %}
Showing {{ report_data.income_details|length }} of {{ report_data.income_details|length }} records
Total Interest: KES {{ report_data.summary.total_interest_income|default:0|floatformat:2|intcomma }}
{% else %}

No Interest Income Found

No interest income matches the selected criteria. Try adjusting your filters or check back when loans start generating interest.

Create New Loan Back to Reports
{% endif %}
{% endblock %}''' return template def create_enhanced_registration_fees_report(): """Create enhanced registration fees report template""" template = '''{% extends 'base.html' %} {% load humanize %} {% load static %} {% block title %}Registration Fees Report{% endblock %} {% block extra_css %} {% endblock %} {% block content %}

Registration Fees Report

{% if report_data.period.period_display == 'All Time' %} All client registration fees collected since system launch {% else %} Registration fees for {{ report_data.period.period_display }} {% endif %}

Generated on {{ "now"|date:"F d, Y" }} at {{ "now"|date:"g:i A" }}
Back to Dashboard Add Client Export PDF

Advanced Filters {% if report_data.period.period_display == 'All Time' %} Showing All Time Data {% endif %}

Leave empty for all-time data

Leave empty for all-time data

{% if filters.start_date or filters.end_date %}
Filtered results are shown.
Clear filters (show all-time)
{% endif %}

Total Registration Income

KES {{ report_data.summary.total_registration_income|default:0|floatformat:2|intcomma }}

Total revenue

Total Registrations

{{ report_data.summary.total_registrations|default:0 }}

Client registrations

Average Fee

KES {{ report_data.summary.average_registration_fee|default:0|floatformat:2|intcomma }}

Mean fee amount

Payment Rate

{{ additional_analytics.payment_rate|default:0|floatformat:1 }}%

Completion rate

Registration Fees Details

{% if report_data.fees %}

{{ report_data.fees|length }} fee payment{{ report_data.fees|length|pluralize }} found

{% endif %}
Detailed View
{% if report_data.fees %}
{% for fee in report_data.fees %} {% endfor %}
Client Name Registration Fee Amount Payment Method Date Paid Status
{{ fee.customer_name }}
{% if fee.source == 'Client Registration' %}
Client Registration
{% endif %}
{{ fee.fee_name }}
{% if fee.product_type != 'client_registration' %} {{ fee.product_type|title }} {% endif %} 		KES {{ fee.amount|floatformat:2|intcomma }} {{ fee.payment_method|title }}
{{ fee.payment_date|date:"M d, Y" }}
{{ fee.payment_date|date:"H:i" }}
 {{ fee.payment_status }}
{% if report_data.breakdown_by_source %}

Data Sources Breakdown

Client Registration Fees: KES {{ report_data.breakdown_by_source.user_registration_fees|floatformat:2|intcomma }}
Separate Fee Payments: KES {{ report_data.breakdown_by_source.registration_fee_payments|floatformat:2|intcomma }}
{% endif %} {% else %}

No Registration Fees Found

{% if filters.start_date or filters.end_date %} No registration fees match the selected date range. {% else %} No registration fees have been recorded yet. {% endif %}

Record Fee Payment Add New Client
{% endif %}
{% endblock %}''' return template def main(): """Main function to enhance all reports""" print("šŸŽØ Enhancing All Report Templates...") # Create enhanced interest income report interest_template = create_enhanced_interest_income_report() with open('templates/reports/interest_income_report.html', 'w', encoding='utf-8') as f: f.write(interest_template) print("āœ… Enhanced interest income report created") # Create enhanced registration fees report registration_template = create_enhanced_registration_fees_report() with open('templates/reports/registration_fees_report.html', 'w', encoding='utf-8') as f: f.write(registration_template) print("āœ… Enhanced registration fees report created") print("\nšŸš€ All report templates enhanced!") print("šŸ“‹ Enhanced Features:") print(" šŸŽØ Modern gradient hero sections") print(" šŸ“Š Enhanced metric cards with animations") print(" šŸ” Improved filter sections") print(" šŸ“‹ Professional data tables") print(" šŸ“± Responsive design") print(" šŸŽÆ Better empty states") print(" āœØ Smooth animations and transitions") if __name__ == '__main__': main()