from django.db import models


class User(models.Model):
    email      = models.EmailField(unique=True)
    name       = models.CharField(max_length=255, blank=True)
    provider   = models.CharField(max_length=50, default='google')
    created_at = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return self.email


class Category(models.Model):
    user  = models.ForeignKey(User, on_delete=models.CASCADE, related_name='categories')
    name  = models.CharField(max_length=100)
    emoji = models.CharField(max_length=10, default='💰')
    color = models.CharField(max_length=7, default='#BA7517')

    class Meta:
        unique_together = ('user', 'name')
        ordering = ['name']

    def __str__(self):
        return f"{self.emoji} {self.name}"


class Transaction(models.Model):
    user     = models.ForeignKey(User, on_delete=models.CASCADE, related_name='transactions')
    amount   = models.DecimalField(max_digits=10, decimal_places=2)
    category = models.CharField(max_length=100)
    note     = models.CharField(max_length=255, blank=True, default='')
    txn_date = models.DateTimeField()

    class Meta:
        ordering = ['-txn_date']

    def __str__(self):
        return f"{self.category} {self.amount}"


class Budget(models.Model):
    user     = models.ForeignKey(User, on_delete=models.CASCADE, related_name='budgets')
    category = models.CharField(max_length=100)
    amount   = models.DecimalField(max_digits=10, decimal_places=2, default=0)

    class Meta:
        unique_together = ('user', 'category')

    def __str__(self):
        return f"{self.user.email} — {self.category}: {self.amount}"