from django.db import models
from django.utils.text import slugify
from status.models import Status  # Import the Status model
from organization.models import BaseTenantModel, BaseOrganizationModel

def get_default_status_pk():
    try:
        return Status.objects.get(slug='active-teacher').pk
    except Status.DoesNotExist:
        return None

class Teacher(BaseOrganizationModel):
    teacher_id = models.AutoField(primary_key=True)
    first_name = models.CharField(max_length=100)
    last_name = models.CharField(max_length=100, blank=True, null=True)
    code = models.CharField(max_length=10, unique=True)
    slug = models.SlugField(unique=True, max_length=200)
    email = models.EmailField(unique=True)
    phone = models.CharField(max_length=20)
    title = models.CharField(max_length=255, blank=True, null=True)
    department = models.ForeignKey(
        'departments.Department',
        on_delete=models.CASCADE,
        null=True,
        blank=True,
        related_name='teachers'
    )
    
    hire_date = models.DateField(null=True, blank=True)
    status = models.ForeignKey(Status, on_delete=models.CASCADE, default=get_default_status_pk, limit_choices_to={'type': 'teacher'})

    def save(self, *args, **kwargs):
        if not self.slug:
            self.slug = slugify(f"{self.first_name}-{self.last_name}-{self.code}")
        super(Teacher, self).save(*args, **kwargs)

    def __str__(self):
        return f"{self.first_name} {self.last_name}"

    class Meta:
        db_table = 'teacher'
        verbose_name = "Teacher"
        verbose_name_plural = "Teachers"