from django.db import models
from Models.Usuario import Usuario

class Conversacion(models.Model):
    id = models.AutoField(primary_key=True)
    cliente_phone = models.CharField(max_length=50)
    usuario = models.ForeignKey(Usuario, on_delete=models.SET_NULL, null=True, blank=True, db_column='usuario_id')
    cliente_id = models.CharField(max_length=100, null=True, blank=True)
    fecha_inicio = models.DateTimeField(auto_now_add=True)
    estado = models.CharField(max_length=20, default='abierta')
    ultima_actividad = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = 'conversacion'
        managed = True

class Mensaje(models.Model):
    id = models.AutoField(primary_key=True)
    conversacion = models.ForeignKey(Conversacion, on_delete=models.CASCADE, db_column='conversacion_id', related_name='mensajes')
    sender_type = models.CharField(max_length=20) # 'client', 'operator'
    content = models.TextField(blank=True, null=True)
    media_url = models.CharField(max_length=500, blank=True, null=True)
    message_type = models.CharField(max_length=20, default='text') # text, image, etc.
    timestamp = models.DateTimeField(auto_now_add=True)
    whatsapp_id = models.CharField(max_length=255, unique=True, null=True, blank=True)
    
    class Meta:
        db_table = 'mensaje'
        managed = True