from django.db import models
from django.contrib.contenttypes.models import ContentType
from django.contrib.contenttypes.fields import GenericForeignKey
from management.models.utente import Utente

class AuditLog(models.Model):
    id = models.AutoField(primary_key=True)
    user = models.ForeignKey(Utente, on_delete=models.CASCADE, related_name='audit_user')
    username = models.CharField(max_length=255, default='0')
    activity_type = models.CharField(max_length=255, default='0')
    entity_name = models.CharField(max_length=255, default='0')
    content_type = models.ForeignKey(ContentType, on_delete=models.CASCADE, null=True, blank=True)
    entity_id = models.IntegerField(default=0)
    content_object = GenericForeignKey('content_type', 'entity_id')
    old_values = models.JSONField(blank=True, null=True)
    new_values = models.JSONField(blank=True, null=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = 'Audit_log'  
        verbose_name = 'Audit Log'
        verbose_name_plural = 'Audit Logs'
        ordering = ['-created_at']

    def __str__(self):
        return f"{self.username} - {self.activity_type} ({self.created_at})"