from django.contrib import admin
from django.db.models import Q
from .models import Department
from status.models import Status
from teacher_management.models import Teacher


@admin.register(Department)
class DepartmentAdmin(admin.ModelAdmin):
    list_display = ('department_id', 'department_name', 'department_code', 'slug', 'status', 'created_at')
    prepopulated_fields = {'slug': ('department_name',)}
    list_filter = ('status', 'created_at')
    search_fields = ('department_name', 'department_code')

    def formfield_for_foreignkey(self, db_field, request, **kwargs):
        if db_field.name == 'head_teacher':
            kwargs['queryset'] = Teacher.objects.filter(
                Q(organization__isnull=False)
            )
        elif db_field.name == 'status':
            kwargs['queryset'] = Status.objects.filter(
                Q(type='department') & (Q(organization__isnull=False))
            )
        return super().formfield_for_foreignkey(db_field, request, **kwargs)
