from django.db import models


class KnowledgeArticle(models.Model):
    DRAFT = 'draft'
    PENDING = 'pending_approval'
    PUBLISHED = 'published'
    ARCHIVED = 'archived'

    STATUS_CHOICES = [
        (DRAFT, 'Draft'),
        (PENDING, 'Pending Approval'),
        (PUBLISHED, 'Published'),
        (ARCHIVED, 'Archived'),
    ]

    TYPE_CHOICES = [
        ('faq', 'FAQ'),
        ('sop', 'Standard Operating Procedure'),
        ('troubleshooting', 'Troubleshooting Guide'),
        ('policy', 'Policy Document'),
        ('template', 'Reply Template'),
    ]

    client = models.ForeignKey('clients.Client', on_delete=models.CASCADE, related_name='kb_articles',
                               null=True, blank=True)
    category = models.ForeignKey('clients.TicketCategory', on_delete=models.SET_NULL, null=True, blank=True)
    title = models.CharField(max_length=300)
    slug = models.SlugField(max_length=300, unique=True)
    article_type = models.CharField(max_length=20, choices=TYPE_CHOICES, default='faq')
    content = models.TextField()
    tags = models.CharField(max_length=500, blank=True)
    status = models.CharField(max_length=20, choices=STATUS_CHOICES, default=DRAFT)
    version = models.IntegerField(default=1)
    author = models.ForeignKey('core.User', on_delete=models.SET_NULL, null=True, related_name='kb_articles')
    approved_by = models.ForeignKey('core.User', on_delete=models.SET_NULL, null=True, blank=True,
                                    related_name='approved_kb_articles')
    views = models.IntegerField(default=0)
    helpful_votes = models.IntegerField(default=0)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    def __str__(self):
        return self.title


class ReplyTemplate(models.Model):
    client = models.ForeignKey('clients.Client', on_delete=models.CASCADE, null=True, blank=True)
    name = models.CharField(max_length=100)
    category = models.ForeignKey('clients.TicketCategory', on_delete=models.SET_NULL, null=True, blank=True)
    subject = models.CharField(max_length=200, blank=True)
    body = models.TextField()
    is_active = models.BooleanField(default=True)
    created_by = models.ForeignKey('core.User', on_delete=models.SET_NULL, null=True)
    created_at = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return self.name
