# models.py
from django.db import models
from django.contrib.auth.models import User
from ckeditor_uploader.fields import RichTextUploadingField
from django.utils.text import slugify


class Profile(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE, primary_key=True)
    usergroup = models.ForeignKey('UserGroup', on_delete=models.SET_NULL, null=True, blank=True)
    name = models.CharField(max_length=100, blank=True)
    image = models.ImageField(upload_to='profile_images', blank=True, null=True)

    class Meta:
        db_table = 'dashboard_profile'


class UserGroup(models.Model):
    name = models.CharField(max_length=100)
    status = models.BooleanField(default=True)

    def __str__(self):
        return self.name

    class Meta:
        db_table = "dash_usergroup"


class Module(models.Model):
    name = models.CharField(max_length=100)
    url_name = models.CharField(max_length=255, null=True, blank=True)
    icon_class = models.CharField(max_length=100, blank=True)

    def __str__(self):
        return self.name

    class Meta:
        db_table = "dash_module"


class Child(models.Model):
    module = models.ForeignKey(Module, related_name='children', on_delete=models.CASCADE)
    name = models.CharField(max_length=100)
    url_name = models.CharField(max_length=255, null=True, blank=True)

    def __str__(self):
        return f"{self.name} (Child of {self.module.name})"

    class Meta:
        db_table = "dash_child"


class Permission(models.Model):
    usergroup = models.ForeignKey(UserGroup, on_delete=models.CASCADE, null=True, blank=True)
    module = models.ForeignKey(Module, on_delete=models.CASCADE, null=True, blank=True)
    enabled = models.BooleanField(default=False)

    class Meta:
        db_table = "dash_permission"



class Page(models.Model):

    POSITION_CHOICES = [
        ('header', 'Header'),
        ('footer', 'Footer'),
    ]

    position = models.CharField(
        max_length=50,
        choices=POSITION_CHOICES,
        verbose_name="Position"
    )

    parent = models.ForeignKey(
        'self',
        null=True,
        blank=True,
        on_delete=models.SET_NULL,
        verbose_name="Parent Page"
    )

    page_name = models.CharField(
        max_length=200,
        verbose_name="Page Name",
        null=True,
        blank=True
    )

    title = models.CharField(
        max_length=200,
        verbose_name="Title"
    )

    slug = models.SlugField(
        max_length=255,
        unique=True,
        blank=True,
        verbose_name="URL"
    )

    priority = models.IntegerField(
        default=0,
        verbose_name="Priority"
    )

    description = RichTextUploadingField(
        blank=True,
        verbose_name="Description"
    )

    # SEO Fields

    meta_title = models.CharField(
        max_length=255,
        blank=True,
        null=True,
        verbose_name="Meta Title"
    )

    meta_keywords = models.CharField(
        max_length=255,
        blank=True,
        null=True,
        verbose_name="Meta Keywords"
    )

    meta_description = models.TextField(
        blank=True,
        null=True,
        verbose_name="Meta Description"
    )

    def save(self, *args, **kwargs):

        if not self.slug:

            base_slug = slugify(self.title)
            slug = base_slug
            count = 1

            while Page.objects.filter(slug=slug).exclude(pk=self.pk).exists():
                slug = f"{base_slug}-{count}"
                count += 1

            self.slug = slug

        super().save(*args, **kwargs)

    def __str__(self):
        return self.title

    class Meta:
        db_table = "dash_page"
        ordering = ['priority', 'title']
        verbose_name = "Page"
        verbose_name_plural = "Pages"

class Gallery(models.Model):
    title = models.CharField(max_length=100)
    image = models.ImageField(upload_to='gallery/')

    def __str__(self):
        return self.title

class FileManager(models.Model):

    name = models.CharField(max_length=200)
    image = models.ImageField(
        upload_to='gallery/'
    )
    created_at = models.DateTimeField(
        auto_now_add=True
    )

    def __str__(self):
        return self.name

    @property
    def image_url(self):
        return self.image.url
class BlogCategory(models.Model):
    name = models.CharField(max_length=200)

    url = models.SlugField(
        max_length=255,
        unique=True,
        blank=True
    )

    meta_title = models.CharField(
        max_length=255,
        blank=True,null=True
    )

    meta_keywords = models.CharField(
        max_length=255,
        blank=True,null=True
    )

    meta_description = models.TextField(
        blank=True,null=True
    )

    def save(self, *args, **kwargs):

        if not self.url:
            base_slug = slugify(self.name)
            slug = base_slug
            counter = 1

            while BlogCategory.objects.filter(url=slug).exclude(pk=self.pk).exists():
                slug = f"{base_slug}-{counter}"
                counter += 1

            self.url = slug

        super().save(*args, **kwargs)

    def __str__(self):
        return self.name    
class Blog(models.Model):

    category = models.ForeignKey(
        BlogCategory,
        on_delete=models.CASCADE,
        related_name='blogs'
    )

    blog_name = models.CharField(
        max_length=255
    )

    url = models.SlugField(
        max_length=255,
        unique=True,
        blank=True
    )

    image = models.ImageField(
        upload_to='blog/images/'
    )

    file = models.FileField(
        upload_to='blog/files/',
        blank=True,
        null=True
    )

    short_description = models.TextField()

    description = RichTextUploadingField()

    meta_title = models.CharField(
        max_length=255,
        blank=True
    )

    meta_keywords = models.CharField(
        max_length=500,
        blank=True
    )

    meta_description = models.TextField(
        blank=True
    )

    created_at = models.DateTimeField(
        auto_now_add=True
    )

    updated_at = models.DateTimeField(
        auto_now=True
    )

    status = models.BooleanField(
        default=True
    )

    class Meta:
        ordering = ['-created_at']

    def save(self, *args, **kwargs):

        if not self.url:
            base_slug = slugify(self.blog_name)
            slug = base_slug
            count = 1

            while Blog.objects.filter(url=slug).exclude(pk=self.pk).exists():
                slug = f"{base_slug}-{count}"
                count += 1

            self.url = slug

        super().save(*args, **kwargs)

    def __str__(self):
        return self.blog_name
    


class ContactUs(models.Model):
    first_name = models.CharField(max_length=100)
    last_name = models.CharField(max_length=100)
    email = models.EmailField()
    phone = models.CharField(max_length=20)
    message = models.TextField()
    created_at = models.DateTimeField(auto_now_add=True)

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

    class Meta:
        db_table = "dash_contact"
        ordering = ['-created_at']
        verbose_name = "Contact"
        verbose_name_plural = "Contacts"


class Application(models.Model):

    QUALIFICATION_CHOICES = [
        ('10th', '10th'),
        ('12th', '12th / Plus Two'),
        ('degree', 'Degree'),
        ('pg', 'Post Graduate'),
    ]

    COURSE_CHOICES = [
        ('graphics', 'Creative Graphics'),
        ('marketing', 'Digital Marketing'),
        ('uiux', 'UI/UX Designing & Development'),
        ('fullstack', 'Fullstack Development'),
        ('multimedia', 'Videography & Advanced Editing'),
        ('nodejs', 'Node.js Development'),
        ('python', 'Python Development'),
    ]

    LOCATION_CHOICES = [
        ('wayanad', 'Wayanad'),
        ('kozhikode', 'Kozhikode'),
        ('kannur', 'Kannur'),
        ('malappuram', 'Malappuram'),
        ('other', 'Other'),
    ]

    name = models.CharField(max_length=200)
    email = models.EmailField()
    phone = models.CharField(max_length=20)
    qualification = models.CharField(max_length=50, choices=QUALIFICATION_CHOICES)
    course = models.CharField(max_length=50, choices=COURSE_CHOICES)
    dob = models.DateField()
    location = models.CharField(max_length=50, choices=LOCATION_CHOICES)
    created_at = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return f"{self.name} - {self.course}"

    class Meta:
        db_table = "dash_application"
        ordering = ['-created_at']
        verbose_name = "Application"
        verbose_name_plural = "Applications"