import uuid
from django.db import models
from django.utils.timezone import now

class Customer(models.Model):
    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    name = models.CharField(max_length=200)
    description = models.TextField(blank=True, null=True)
    contact_email = models.EmailField(blank=True, null=True)
    contact_phone = models.CharField(max_length=20, blank=True, null=True)
    address = models.TextField(blank=True, null=True)
    created_at = models.DateTimeField(default=now)
    updated_at = models.DateTimeField(auto_now=True)
    company = models.ForeignKey('company.Company', on_delete=models.CASCADE, related_name='customers')

    class Meta:
        db_table = 'customers'
        ordering = ['-created_at']
        unique_together = [['company', 'name']]

    def __str__(self):
        return self.name

class Project(models.Model):
    STATUS_CHOICES = [
        ('active', 'Active'),
        ('inactive', 'Inactive'),
        ('completed', 'Completed'),
        ('on_hold', 'On Hold'),
    ]
    
    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    name = models.CharField(max_length=200)
    description = models.TextField(blank=True, null=True)
    code = models.CharField(max_length=100, blank=True, null=True)
    status = models.CharField(max_length=20, choices=STATUS_CHOICES, default='active')
    start_date = models.DateField(blank=True, null=True)
    end_date = models.DateField(blank=True, null=True)
    # New fields for frontend compatibility
    estimated_time = models.CharField(max_length=50, default='0:00', blank=True)
    sum_tasks_estimates = models.BooleanField(default=False)
    due_date = models.DateField(blank=True, null=True)
    client = models.CharField(max_length=200, blank=True, null=True)
    is_public = models.BooleanField(default=False)
    created_at = models.DateTimeField(default=now)
    updated_at = models.DateTimeField(auto_now=True)
    customer = models.ForeignKey('Customer', on_delete=models.CASCADE, related_name='projects', blank=True, null=True)
    parent = models.ForeignKey('self', on_delete=models.CASCADE, related_name='sub_projects', blank=True, null=True)

    def __str__(self):
        return f"{self.name} - {self.code or 'N/A'}"

    class Meta:
        db_table = 'projects'
        ordering = ['-created_at']
        unique_together = [['customer', 'name', 'parent']]