from django.db import models
from django.conf import settings
from django.utils import timezone
from datetime import timedelta


class Story(models.Model):
    """Vendor story - visible for 24 hours"""
    vendor = models.ForeignKey(
        settings.AUTH_USER_MODEL,
        on_delete=models.CASCADE,
        related_name='stories',
        limit_choices_to={'user_type': 'vendor'},
    )
    image = models.ImageField(upload_to='stories/')
    text = models.CharField(max_length=200, blank=True, null=True)
    price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True)
    views_count = models.PositiveIntegerField(default=0)
    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        db_table = 'stories'
        ordering = ['-created_at']
        verbose_name_plural = 'stories'

    def __str__(self):
        return f"Story by {self.vendor.full_name} at {self.created_at}"

    @property
    def is_active(self):
        return timezone.now() < self.created_at + timedelta(hours=24)

    @property
    def expires_at(self):
        return self.created_at + timedelta(hours=24)


class StoryView(models.Model):
    """Track who viewed a story"""
    story = models.ForeignKey(Story, on_delete=models.CASCADE, related_name='views')
    viewer = models.ForeignKey(
        settings.AUTH_USER_MODEL,
        on_delete=models.CASCADE,
        related_name='viewed_stories',
    )
    viewed_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        db_table = 'story_views'
        unique_together = ('story', 'viewer')

    def __str__(self):
        return f"{self.viewer.full_name} viewed story {self.story.id}"