================================================================================
PROCESSING FEE REPORT FIX - DEPLOYMENT GUIDE
================================================================================

ISSUE:
------
The processing fees report shows incorrect fees (e.g., KES 4,243 instead of 
KES 7,668 for LOAN-000086) because it was calculating 2% for all loans instead
of using the actual processing fee stored in the database.

FIX APPLIED:
------------
Updated reports/views.py to use actual loan.processing_fee values and display
correct product names and fee rates.

DEPLOYMENT STEPS:
-----------------

1. BACKUP CURRENT FILE (on production server)
   cp reports/views.py reports/views.py.backup.$(date +%Y%m%d_%H%M%S)

2. UPLOAD UPDATED FILE
   Upload the modified reports/views.py to production server
   Location: /home/username/branch-system/reports/views.py

3. RESTART APPLICATION
   Option A (cPanel):
     - Go to Setup Python App
     - Click "Restart" button
   
   Option B (SSH):
     cd /home/username/branch-system
     touch tmp/restart.txt

4. VERIFY THE FIX
   - Visit: https://branchbusinessadvance.co.ke/reports/processing-fees/
   - Check LOAN-000086:
     * Should show: KES 7,668.00 (not KES 4,243)
     * Product: Boost Plus (not "Standard Loan")
     * Fee Rate: 6.0% (or actual rate, not 2.0%)

5. RUN VERIFICATION SCRIPT (optional)
   python verify_processing_fee_production.py

EXPECTED RESULTS:
-----------------
For LOAN-000086:
  Borrower: JAMES MUGENDI NJIRU
  Product: Boost Plus
  Principal: KES 127,800.00
  Processing Fee: KES 7,668.00 ✓ (was showing KES 4,243.00 ✗)
  Fee Rate: 6.0% ✓ (was showing 2.0% ✗)

ROLLBACK (if needed):
---------------------
If issues occur, restore the backup:
  cp reports/views.py.backup.YYYYMMDD_HHMMSS reports/views.py
  touch tmp/restart.txt

FILES MODIFIED:
---------------
- reports/views.py (enhanced_processing_fees_report function)

NO DATABASE CHANGES REQUIRED
NO MIGRATIONS NEEDED

SUPPORT:
--------
If the issue persists after deployment:
1. Verify the file was uploaded correctly
2. Check that the application restarted
3. Clear browser cache
4. Check error logs: logs/error.log

================================================================================