from django.shortcuts import render, redirect, get_object_or_404
from django.core.paginator import Paginator
from django.db.models import ProtectedError, RestrictedError
from django.contrib.auth.decorators import login_required
from ..models.projects import Project
from ..forms import ProjectForm
from ..models.partners import Partner
from django.contrib import messages
from django.db.models import Q

@login_required
def project_list(request):
    query = request.GET.get('q', '')
    projects = Project.objects.all()
    
    if query:
        projects = projects.filter(
            Q(title__icontains=query) | 
            Q(description__icontains=query) |
            Q(sector__icontains=query)
        )
        
    projects = projects.order_by('-created_at')
    
    paginator = Paginator(projects, 10)
    page_number = request.GET.get('page')
    page_obj = paginator.get_page(page_number)

    return render(request, 'management/project_list.html', {
        'projects': page_obj,
        'page_obj': page_obj,
        'is_paginated': page_obj.has_other_pages(),
        'paginator': paginator,
        'query': query
    })

@login_required
def project_detail(request, pk):
    project = get_object_or_404(Project, pk=pk)
    return render(request, 'management/project_detail.html', {
        'project': project,
    })

@login_required
def project_create(request):
    initial = {}
    if request.method == 'GET':
        owner_applicant_id = request.GET.get('owner_applicant')
        if owner_applicant_id:
            initial['owner_applicant'] = owner_applicant_id
        owner_team_id = request.GET.get('owner_team')
        if owner_team_id:
            initial['owner_team'] = owner_team_id

    if request.method == 'POST':
        form = ProjectForm(request.POST)
        if form.is_valid():
            project = form.save()
            messages.success(request, "Projet créé avec succès.")
            return redirect('management:project_detail', pk=project.pk)
    else:
        form = ProjectForm(initial=initial)
    return render(request, 'management/project_form.html', {
        'form': form, 
        'title': 'Nouveau Projet',
        'partners': Partner.objects.all()
    })

@login_required
def project_update(request, pk):
    project = get_object_or_404(Project, pk=pk)
    if request.method == 'POST':
        form = ProjectForm(request.POST, instance=project)
        if form.is_valid():
            form.save()
            messages.success(request, "Projet mis à jour.")
            return redirect('management:project_detail', pk=project.pk)
    else:
        form = ProjectForm(instance=project)
    return render(request, 'management/project_form.html', {
        'form': form, 
        'title': 'Modifier le Projet', 
        'project': project,
        'partners': Partner.objects.all()
    })

@login_required
def project_delete(request, pk):
    project = get_object_or_404(Project, pk=pk)
    if request.method == 'POST':
        try:
            project.delete()
            messages.success(request, "Projet supprimé.")
            return redirect('management:project_list')
        except (ProtectedError, RestrictedError):
            messages.error(request, "Impossible de supprimer ce projet car il est lié à d'autres données (ex. inscriptions ou labels).")
            return redirect('management:project_list')
    return render(request, 'management/project_confirm_delete.html', {'project': project})
from django.http import JsonResponse
from django.views.decorators.http import require_POST



from ..models.projects import Project, ProjectLabel
from ..forms import ProjectForm, ProjectLabelForm, GlobalProjectLabelForm

@login_required
def project_label_create(request, project_id):
    project = get_object_or_404(Project, pk=project_id)
    if request.method == 'POST':
        form = ProjectLabelForm(request.POST)
        if form.is_valid():
            label = form.save(commit=False)
            label.project = project
            try:
                label.save()
                messages.success(request, "Label ajouté avec succès.")
            except Exception:
                messages.error(request, "Ce type de label existe déjà pour ce projet.")
            return redirect('management:project_detail', pk=project.pk)
    else:
        form = ProjectLabelForm()
    
    return render(request, 'management/project_label_form.html', {
        'form': form,
        'project': project,
        'title': 'Ajouter un label'
    })

@login_required
def project_label_update(request, pk):
    label = get_object_or_404(ProjectLabel, pk=pk)
    project = label.project
    if request.method == 'POST':
        form = ProjectLabelForm(request.POST, instance=label)
        if form.is_valid():
            try:
                form.save()
                messages.success(request, "Label mis à jour.")
                return redirect('management:project_detail', pk=project.pk)
            except Exception:
                messages.error(request, "Erreur lors de la mise à jour.")
    else:
        form = ProjectLabelForm(instance=label)
    
    return render(request, 'management/project_label_form.html', {
        'form': form,
        'project': project,
        'title': 'Modifier le label'
    })

@login_required
def project_label_delete(request, pk):
    label = get_object_or_404(ProjectLabel, pk=pk)
    project_id = label.project.id
    if request.method == 'POST':
        try:
            label.delete()
            messages.success(request, "Label supprimé.")
        except (ProtectedError, RestrictedError):
            messages.error(request, "Impossible de supprimer ce label car il est utilisé ailleurs.")
        return redirect('management:project_detail', pk=project_id)
    return render(request, 'management/project_label_confirm_delete.html', {'label': label})


@login_required
def project_label_create_global(request):
    if request.method == 'POST':
        form = GlobalProjectLabelForm(request.POST)
        if form.is_valid():
            try:
                label = form.save()
                messages.success(request, "Label ajouté avec succès.")
                return redirect('management:project_label_list')
            except Exception:
                messages.error(request, "Ce type de label existe déjà pour ce projet.")
    else:
        form = GlobalProjectLabelForm()
    
    return render(request, 'management/project_label_form.html', {
        'form': form,
        'title': 'Ajouter un label'
    })

@login_required
def project_label_list(request):
    query = request.GET.get('q', '')
    group_by = request.GET.get('group_by', 'false')
    
    labels = ProjectLabel.objects.select_related('project', 'project__owner_applicant', 'project__owner_team').all()
    
    if query:
        labels = labels.filter(
            Q(project__title__icontains=query) |
            Q(label_type__icontains=query)
        )
        
    grouped_labels = None
    if group_by == 'true':
        grouped_labels = {}
        for label in labels:
            key = label.get_label_type_display()
            if key not in grouped_labels:
                grouped_labels[key] = []
            grouped_labels[key].append(label)
            
    paginator = Paginator(labels, 10)
    page_number = request.GET.get('page')
    page_obj = paginator.get_page(page_number)
            
    return render(request, 'management/labels/list.html', {
        'labels': page_obj if group_by != 'true' else labels,
        'page_obj': page_obj,
        'is_paginated': page_obj.has_other_pages() and group_by != 'true',
        'paginator': paginator,
        'grouped_labels': grouped_labels,
        'query': query,
        'group_by': group_by,
        'title': 'Gestion des Labels'
    })

@login_required
def project_label_detail(request, pk):
    label = get_object_or_404(ProjectLabel, pk=pk)
    return render(request, 'management/labels/detail.html', {
        'label': label,
        'title': f'Détails du Label - {label.project.title}'
    })

@login_required
def project_search_json(request):
    query = request.GET.get('q', '')
    owner_applicant = request.GET.get('owner_applicant')
    owner_team = request.GET.get('owner_team')
    
    projects = Project.objects.all()
    if owner_applicant:
        projects = projects.filter(owner_applicant_id=owner_applicant)
    if owner_team:
        projects = projects.filter(owner_team_id=owner_team)
        
    if query:
        projects = projects.filter(title__icontains=query)
    
    data = [
        {
            'id': p.id,
            'text': p.title,
            'description': f"{p.description or ''} | Propriétaire: {p.owner_applicant or p.owner_team}"
        } for p in projects.select_related('owner_applicant', 'owner_team')[:20]
    ]
    return JsonResponse({'results': data})

@login_required
@require_POST
def project_create_json(request):
    form = ProjectForm(request.POST)
    if form.is_valid():
        project = form.save()
        return JsonResponse({
            'id': project.id,
            'text': project.title,
            'success': True
        })
    return JsonResponse({'success': False, 'errors': form.errors}, status=400)
