from django.shortcuts import render
from ..models.programs import Program
from ..models.applicants import Applicant
from ..models.registrations import Registration
from conventions.models import Convention
from django.utils import timezone
from datetime import timedelta
from django.contrib.auth.decorators import login_required

@login_required
def dashboard(request):
    total_programs = Program.objects.count()
    active_programs = Program.objects.filter(is_active=True).count()
    total_applicants = Applicant.objects.count()
    pending_registrations = Registration.objects.filter(status='PENDING').count()
    
    recent_registrations = Registration.objects.select_related('applicant', 'program').order_by('-application_date')[:5]

    # Conventions alerts
    today = timezone.now().date()
    expiring_soon = today + timedelta(days=30)
    expiring_conventions = Convention.objects.filter(
        end_date__lte=expiring_soon,
        end_date__gte=today
    ).select_related('partner')

    context = {
        'total_programs': total_programs,
        'active_programs': active_programs,
        'total_applicants': total_applicants,
        'pending_registrations': pending_registrations,
        'recent_registrations': recent_registrations,
        'expiring_conventions': expiring_conventions,
    }
    return render(request, 'management/dashboard.html', context)
