from django.db import models
import uuid
from django.urls.base import reverse

class Record(models.Model):
    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    voice_record = models.FileField(upload_to="records")
    language = models.CharField(max_length=50, null=True, blank=True)

    class Meta:
        verbose_name = "Record"
        verbose_name_plural = "Records"

    def __str__(self):
        return str(self.id)

    def get_absolute_url(self):
        return reverse("record_detail", kwargs={"id": str(self.id)})


class Product(models.Model):
    barcode = models.CharField(max_length=20)
    brand = models.CharField(max_length=100)
    sub_brand = models.CharField(max_length=100, blank=True, null=True)
    manufactured_by = models.CharField(max_length=200)
    product_name = models.CharField(max_length=200)
    weight = models.FloatField()
    variant = models.CharField(max_length=100, blank=True, null=True)
    net_content = models.CharField(max_length=100, blank=True, null=True)
    price = models.DecimalField(max_digits=10, decimal_places=2)
    parent_category = models.CharField(max_length=100)
    child_category = models.CharField(max_length=100)
    sub_child_category = models.CharField(max_length=100, blank=True, null=True)
    images_paths = models.CharField(max_length=3000, blank=True, null=True) # Comma separated paths
    description = models.TextField(max_length=3000, blank=True, null=True)
    quantity = models.IntegerField(null=True, blank=True)
    mrp = models.CharField(max_length=100, blank=True, null=True)

    def __str__(self):
        return self.product_name


class Database(models.Model):
    barcode = models.CharField(max_length=20)
    brand = models.CharField(max_length=100)
    sub_brand = models.CharField(max_length=100, blank=True, null=True)
    manufactured_by = models.CharField(max_length=200)
    product_name = models.CharField(max_length=200)
    weight = models.FloatField()
    variant = models.CharField(max_length=100, blank=True, null=True)
    net_content = models.CharField(max_length=100, blank=True, null=True)
    price = models.DecimalField(max_digits=10, decimal_places=2)
    parent_category = models.CharField(max_length=100)
    child_category = models.CharField(max_length=100)
    sub_child_category = models.CharField(max_length=100, blank=True, null=True)
    images_paths = models.CharField(max_length=3000, blank=True, null=True) # Comma separated paths
    description = models.TextField(max_length=3000, blank=True, null=True)
    quantity = models.IntegerField(null=True, blank=True)
    promotion_on_the_pack = models.CharField(max_length=100, blank=True, null=True)
    type_of_packaging = models.CharField(max_length=100, blank=True, null=True)
    mrp = models.CharField(max_length=100, blank=True, null=True)