import os
import django

os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'nashaajobs.settings')
django.setup()

from study_abroad.models import StudyAbroadPayment, StudyAbroadProfile
from subscriptions.models import SubscriptionPlan

print("Debug Study Abroad Payments")
print("-" * 30)

payments_count = StudyAbroadPayment.objects.count()
print(f"Total StudyAbroadPayment count: {payments_count}")

if payments_count > 0:
    print("\nListing first 5 payments:")
    for payment in StudyAbroadPayment.objects.all()[:5]:
        print(f"ID: {payment.id}")
        print(f"Student: {payment.student}")
        print(f"Plan: {payment.plan} (Type: {type(payment.plan)})")
        print(f"Status: {payment.status}")
        if payment.student:
            print(f"  User: {payment.student.user.username}")
        print("-" * 10)
else:
    print("No payments found in database.")

print("\nDebug Study Abroad Profiles with Payments")
profiles_with_payments = StudyAbroadProfile.objects.filter(payments__isnull=False).distinct()
print(f"Profiles with payments: {profiles_with_payments.count()}")
for profile in profiles_with_payments:
    print(f"Profile: {profile.user.username}, Payments: {profile.payments.count()}")