import os, sys, django
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'branch_system.settings')
django.setup()

from expenses.models import Expense
from datetime import date

print(f"Total Expenses in DB: {Expense.objects.count()}")
print(f"Approved: {Expense.objects.filter(status='approved').count()}")
print(f"Pending: {Expense.objects.filter(status='pending').count()}")
print(f"\nThis Month: {Expense.objects.filter(expense_date__gte=date(2026, 7, 1), status='approved').count()}")
print(f"\nFirst 10 expenses:")
for e in Expense.objects.all().order_by('-expense_date')[:10]:
    print(f"  {e.expense_date} - {e.title}: KES {e.amount} ({e.status})")