from django.db import models
from django.contrib.auth.models import User

class Profile(models.Model):
    ROLE_CHOICES = [('owner','مالك'),('executive','مدير تنفيذي')]
    user = models.OneToOneField(User, on_delete=models.CASCADE, related_name='profile')
    role = models.CharField(max_length=20, choices=ROLE_CHOICES, default='executive')
    company = models.CharField(max_length=160, blank=True)
    title = models.CharField(max_length=160, blank=True)

    def __str__(self):
        return f'{self.user.get_full_name() or self.user.username} - {self.get_role_display()}'

class Task(models.Model):
    STATUS_CHOICES = [('pending','قيد التنفيذ'),('completed','مكتملة')]
    PRIORITY_CHOICES = [('low','منخفضة'),('normal','عادية'),('high','عالية'),('urgent','عاجلة')]

    title = models.CharField(max_length=220)
    description = models.TextField(blank=True)
    assigned_to = models.ForeignKey(User, on_delete=models.CASCADE, related_name='assigned_tasks')
    created_by = models.ForeignKey(User, on_delete=models.PROTECT, related_name='created_tasks')
    status = models.CharField(max_length=20, choices=STATUS_CHOICES, default='pending')
    priority = models.CharField(max_length=20, choices=PRIORITY_CHOICES, default='normal')
    due_date = models.DateField(null=True, blank=True)
    created_at = models.DateTimeField(auto_now_add=True)
    completed_at = models.DateTimeField(null=True, blank=True)
    completion_note = models.TextField(blank=True)

    class Meta:
        ordering = ['status', '-priority', '-created_at']

    def __str__(self):
        return self.title