from django.conf import settings
from django.db import models
from cloudinary.models import CloudinaryField


class Company(models.Model):
    company_name = models.CharField(max_length=255)
    company_description = models.TextField(blank=True, null=True)
    company_logo = CloudinaryField('image', folder='company/logos', blank=True, null=True)
    date_created = models.DateTimeField(auto_now_add=True)
    last_updated = models.DateTimeField(auto_now=True)

    class Meta:
        ordering = ['company_name']

    def __str__(self):
        return self.company_name


class CompanyUser(models.Model):
    class UserType(models.TextChoices):
        ADMIN = 'Admin', 'Admin'
        EMPLOYEE = 'Employee', 'Employee'
        
    class Status(models.TextChoices):
        ACTIVE = 'Active', 'Active'
        INACTIVE = 'Inactive', 'Inactive'
        BIO_UNPROCESSED = 'Bio_Unprocessed', 'Bio_Unprocessed'
        BIO_REQUESTED = 'Bio_Requested', 'Bio_Requested'

    user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, related_name='company_links')
    company = models.ForeignKey(Company, on_delete=models.CASCADE, related_name='company_users')
    employment_number = models.CharField(unique=True, max_length=35)
    user_type = models.CharField(max_length=20, choices=UserType.choices)
    work_email_address = models.EmailField(max_length=254, blank=True, null=True)
    phone_number = models.CharField(max_length=15, blank=True, null=True)
    profile_pic = CloudinaryField('image', folder='company-users/profile-pics', blank=True, null=True)
    status = models.CharField(max_length=20, choices=Status.choices, default=Status.BIO_UNPROCESSED)
    start_date = models.DateField(blank=True, null=True)
    date_created = models.DateTimeField(auto_now_add=True)
    last_updated = models.DateTimeField(auto_now=True)

    class Meta:
        unique_together = ('user', 'company')
        ordering = ['company', 'user']

    def __str__(self):
        return f'{self.user} @ {self.company} ({self.user_type})'


class UserCompanyContext(models.Model):
    user = models.OneToOneField(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, related_name='company_context')
    current_company = models.ForeignKey(
        Company,
        on_delete=models.SET_NULL,
        blank=True,
        null=True,
        related_name='active_user_contexts',
    )
    last_updated = models.DateTimeField(auto_now=True)

    def __str__(self):
        if self.current_company:
            return f'{self.user} -> {self.current_company}'
        return f'{self.user} -> None'