from django.shortcuts import render, redirect, get_object_or_404
from django.core.paginator import Paginator
from django.contrib import messages
from django.db.models import ProtectedError, RestrictedError
from django.contrib.auth.decorators import login_required
from ..models.programs import Program
from ..models.registrations import Registration
from ..models.applicants import Applicant
from ..models.teams import Team
from ..forms import ProgramForm

from django.db.models import Q

@login_required
def program_list(request):
    query = request.GET.get('q', '')
    programs = Program.objects.all()
    
    if query:
        programs = programs.filter(
            Q(title__icontains=query) | 
            Q(description__icontains=query)
        )
        
    programs = programs.order_by('-start_date')
    
    paginator = Paginator(programs, 10)
    page_number = request.GET.get('page')
    page_obj = paginator.get_page(page_number)

    return render(request, 'management/program_list.html', {
        'programs': page_obj,
        'page_obj': page_obj,
        'is_paginated': page_obj.has_other_pages(),
        'paginator': paginator,
        'query': query
    })


@login_required
def program_create(request):
    if request.method == 'POST':
        form = ProgramForm(request.POST, request.FILES)
        if form.is_valid():
            form.save()
            return redirect('management:program_list')
    else:
        form = ProgramForm()
    return render(request, 'management/program_form.html', {'form': form, 'title': 'Créer un programme'})

@login_required
def program_update(request, pk):
    program = get_object_or_404(Program, pk=pk)
    if request.method == 'POST':
        form = ProgramForm(request.POST, request.FILES, instance=program)
        if form.is_valid():
            form.save()
            return redirect('management:program_list')
    else:
        form = ProgramForm(instance=program)
    return render(request, 'management/program_form.html', {'form': form, 'title': 'Modifier le programme', 'program': program})

@login_required
def program_delete(request, pk):
    program = get_object_or_404(Program, pk=pk)
    if request.method == 'POST':
        try:
            program.delete()
            messages.success(request, "Programme supprimé.")
            return redirect('management:program_list')
        except (ProtectedError, RestrictedError):
            messages.error(request, "Impossible de supprimer ce programme car il contient des inscriptions ou des équipes.")
            return redirect('management:program_list')
    return render(request, 'management/program_confirm_delete.html', {'program': program})

from ..models.projects import Project

@login_required
def program_detail(request, pk):
    program = get_object_or_404(Program, pk=pk)
    registrations = Registration.objects.filter(program=program).select_related('applicant', 'team')
    
    # Projects for this program
    # We collect all project IDs that should be displayed
    project_ids = set()
    
    # 1. Projects directly mentioned in registrations for this program
    reg_project_ids = Registration.objects.filter(program=program)\
        .exclude(project__isnull=True)\
        .values_list('project_id', flat=True)
    project_ids.update(reg_project_ids)
    
    # 2. Projects owned by applicants who have a registration in this program
    applicant_reg_project_ids = Applicant.objects.filter(registrations__program=program)\
        .exclude(project__isnull=True)\
        .values_list('project__id', flat=True)
    project_ids.update(applicant_reg_project_ids)
    
    # 3. Projects owned by teams who have a registration in this program
    team_reg_project_ids = Team.objects.filter(registrations__program=program)\
        .exclude(project__isnull=True)\
        .values_list('project__id', flat=True)
    project_ids.update(team_reg_project_ids)
    
    # 4. Projects owned by teams directly assigned to this program
    team_direct_project_ids = Team.objects.filter(program=program)\
        .exclude(project__isnull=True)\
        .values_list('project__id', flat=True)
    project_ids.update(team_direct_project_ids)
    
    projects = Project.objects.filter(id__in=project_ids).distinct()

    # Simple stats
    teams_count = registrations.values('team').distinct().exclude(team__isnull=True).count()
    applicants_count = registrations.count()
    
    context = {
        'program': program,
        'registrations': registrations,
        'projects': projects,
        'teams_count': teams_count,
        'applicants_count': applicants_count,
    }
    return render(request, 'management/program_detail.html', context)
