class User(models.Model):
    first_name = models.CharField(max_length=255, null=True, blank=True)
    last_name = models.CharField(max_length=255, null=True, blank=True)
    username = models.CharField(max_length=255, null=True, blank=True)
    email = models.CharField(max_length=255, null=True, blank=True)
    password = models.CharField(max_length=255, null=True, blank=True)
    last_login = models.CharField(max_length=255, null=True, blank=True)
    telephone = models.CharField(max_length=255, null=True, blank=True)

class Profile(models.Model):
    user = models.OneToOneField(User, related_name="profile", on_delete=models.CASCADE)
    image = models.ImageField(upload_to='user/%Y/%m/%d', null=True, blank=True)
    about = models.TextField(null=True, blank=True)
    interests = models.ManyToManyField(Category, blank=True)
    address = models.CharField(max_length=255, null=True, blank=True)
    city = models.CharField(max_length=255, null=True, blank=True)
    telephone = models.CharField(max_length=255, null=True, blank=True)

class MessageList(models.Model):
    user_from = models.ForeignKey(
        User, related_name='message_list_from', blank=True, null=True, on_delete=models.CASCADE)
    store = models.ForeignKey(Store, related_name='message_list_to_store',
                              on_delete=models.CASCADE, blank=True, null=True)
    user_to = models.ForeignKey(User, related_name='message_list_to_user',
                               on_delete=models.CASCADE, blank=True, null=True)
    user_from_read = models.BooleanField(default=False)
    store_read = models.BooleanField(default=False)
    user_to_read = models.BooleanField(default=False)
    created = models.DateTimeField(auto_now_add=True, blank=True, null=True)
    updated = models.DateTimeField(auto_now=True, blank=True, null=True)


class Message(models.Model):
    user_from = models.ForeignKey(
        User, related_name="message_from", blank=True, null=True, on_delete=models.CASCADE)
    user_to = models.ForeignKey(
        User, related_name='message_to', blank=True, null=True, on_delete=models.CASCADE)
    store = models.ForeignKey(
        Store, related_name='store_to', blank=True, null=True, on_delete=models.CASCADE)
    from_store = models.BooleanField(default=False)
    content = models.TextField()
    message_list = models.ForeignKey(
        MessageList, related_name='message_list', on_delete=models.CASCADE)
    user_from_read = models.BooleanField(default=False)
    user_to_read = models.BooleanField(default=False)
    store_read = models.BooleanField(default=False)
    created = models.DateTimeField(auto_now_add=True)

class Store(models.Model):
    owner = models.OneToOneField(User, related_name="store_owned", on_delete=models.CASCADE)
    name = models.CharField(max_length=255)
    image = models.ImageField(upload_to=f'stores/%Y/%m/%d', blank=True)
    description = models.TextField()
    address = models.CharField(max_length=255)
    city = models.CharField(max_length=255)
    created = models.DateTimeField(auto_now_add=True)
    modified = models.DateTimeField(auto_now=True)

class Category(models.Model):
    name = models.CharField(max_length=200, db_index=True)
    slug = models.SlugField(max_length=200, unique=True)


class Product(models.Model):
    category = models.ForeignKey(Category, related_name='product', on_delete=models.CASCADE)
    name = models.CharField(max_length=200, db_index=True)
    slug = models.SlugField(max_length=200, db_index=True)
    store = models.ForeignKey(Store, related_name="store_product", on_delete=models.CASCADE)
    image = models.ImageField(upload_to="products/%Y/%m/%d", blank=True)
    description = models.TextField(blank=True)
    processing_time = models.CharField(max_length=255)
    price = models.DecimalField(max_digits=10, decimal_places=2)
    stock = models.PositiveIntegerField(default=60)
    location = models.PointField(null=True, blank=True)
    available = models.BooleanField(default=True)
    created = models.DateTimeField(auto_now_add=True)
    updated = models.DateTimeField(auto_now=True)

class Order(models.Model):
    product = models.ForeignKey(Product, related_name="order", on_delete=models.CASCADE)
    user = models.ForeignKey(User, related_name="orders_by_user", on_delete=models.CASCADE)
    store = models.ForeignKey(Store, related_name="orders_to_store", on_delete=models.CASCADE)
    status = models.CharField(max_length=255, choices=ORDER_STATUS, default=AWAITING)
    cancellation_reason = models.CharField(max_length=255, null=True, blank=True)
    quantity =models.IntegerField(default=1)
    price = models.DecimalField(max_digits=10, decimal_places=2)
    address = models.CharField(max_length=255)
    city = models.CharField(max_length=255)
    postal_code = models.CharField(max_length=255)
    created = models.DateTimeField(auto_now_add=True)
    updated = models.DateTimeField(auto_now=True)