from django.db import models

class Customers(models.Model):
    name = models.CharField(max_length=200, null=True)
    phone = models.CharField(max_length= 200, null=True)
    email = models.CharField(max_length=200, null=True)
    date_created = models.DateTimeField(auto_now_add=True, null=True)

    def __str__(self):
        return self.name


class Tags(models.Model):
    name = models.CharField(max_length =200, null=True)

    def __str__(self):
        return self.name


class Product(models.Model):
    CATEGORY = (
        ('Indoor', 'Indoor'),
        ('Out Door', 'Outdoor'),
    )
    name = models.CharField(max_length=200, null=True)
    price = models.FloatField(null=True) 
    category = models.CharField(max_length=200, null=True,choices= CATEGORY)
    description = models.CharField(max_length=200, null=True)
    date_created =  models.DateTimeField(auto_now_add=True, null=True)
    tags = models.ManyToManyField(Tags)

    def __str__(self):
        return self.name

class Order(models.Model):
    STATUS = (
        ('Pending', 'Pending'),
        ('Out for delivery', 'Out for delivery'),
        ('Delivered', 'Delivered'),
    )
    customer = models.ForeignKey(Customers, null=True, on_delete=models.SET_NULL)  
    product = models.ForeignKey(Product, null= True, on_delete= models.SET_NULL)
    status = models.CharField(max_length=200, null=True, choices=STATUS)
    date_created =  models.DateTimeField(auto_now_add=True, null=True)
    
 
# Create your models here.
