from django.db import models


class Workflow(models.Model):
    client = models.ForeignKey('clients.Client', on_delete=models.CASCADE, related_name='workflows')
    name = models.CharField(max_length=100)
    description = models.TextField(blank=True)
    trigger_category = models.ForeignKey('clients.TicketCategory', on_delete=models.SET_NULL, null=True, blank=True)
    trigger_priority = models.CharField(max_length=10, blank=True)
    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 f"{self.client.name} - {self.name}"


class WorkflowStep(models.Model):
    ACTION_ASSIGN = 'assign'
    ACTION_NOTIFY = 'notify'
    ACTION_APPROVE = 'require_approval'
    ACTION_ESCALATE = 'escalate'
    ACTION_CHANGE_STATUS = 'change_status'
    ACTION_ROUTE = 'route_department'

    ACTION_CHOICES = [
        (ACTION_ASSIGN, 'Assign to User/Team'),
        (ACTION_NOTIFY, 'Send Notification'),
        (ACTION_APPROVE, 'Require Approval'),
        (ACTION_ESCALATE, 'Escalate'),
        (ACTION_CHANGE_STATUS, 'Change Status'),
        (ACTION_ROUTE, 'Route to Department'),
    ]

    workflow = models.ForeignKey(Workflow, on_delete=models.CASCADE, related_name='steps')
    order = models.IntegerField()
    name = models.CharField(max_length=100)
    action = models.CharField(max_length=30, choices=ACTION_CHOICES)
    action_config = models.JSONField(default=dict)
    condition = models.JSONField(default=dict, blank=True)
    is_active = models.BooleanField(default=True)

    class Meta:
        ordering = ['order']

    def __str__(self):
        return f"{self.workflow.name} - Step {self.order}: {self.name}"


class TicketWorkflowState(models.Model):
    ticket = models.ForeignKey('tickets.Ticket', on_delete=models.CASCADE, related_name='workflow_states')
    workflow = models.ForeignKey(Workflow, on_delete=models.SET_NULL, null=True)
    current_step = models.ForeignKey(WorkflowStep, on_delete=models.SET_NULL, null=True, blank=True)
    started_at = models.DateTimeField(auto_now_add=True)
    completed_at = models.DateTimeField(null=True, blank=True)

    class Meta:
        ordering = ['-started_at']


class WorkflowHistory(models.Model):
    ticket = models.ForeignKey('tickets.Ticket', on_delete=models.CASCADE, related_name='workflow_history')
    step = models.ForeignKey(WorkflowStep, on_delete=models.SET_NULL, null=True)
    action_taken = models.CharField(max_length=100)
    performed_by = models.ForeignKey('core.User', on_delete=models.SET_NULL, null=True)
    notes = models.TextField(blank=True)
    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        ordering = ['created_at']
