from datetime import datetime

from django.contrib.auth.base_user import AbstractBaseUser
from django.contrib.auth.models import PermissionsMixin, UserManager
from django.db import models


class CustomUser(AbstractBaseUser, PermissionsMixin):
    """Расширенный пользователь"""
    username = models.CharField('Пользователь', max_length=25, unique=True)
    email = models.EmailField('Email', unique=True)
    date_joined = models.DateTimeField('Дата регистрации', auto_now_add=True)
    is_active = models.BooleanField('is_active', default=True)
    is_staff = models.BooleanField('is_staff', default=False)
    user_photo = models.ImageField(upload_to='media/users_photos/', null=True, blank=True)

    objects = UserManager()

    USERNAME_FIELD = 'username'
    REQUIRED_FIELDS = []

    class Meta:
        db_table = 'user'
        verbose_name = 'Пользователь'
        verbose_name_plural = 'Пользователи'


class Product(models.Model):
    """Продукт"""

    class Colors(models.TextChoices):
        RED = 'RED', 'Красный'
        TOMATO = 'TOMATO', 'Томатный'
        GREEN = 'GREEN', 'Зеленый'
        AQUA = 'AQUA', 'Аква'
        VIOLET = 'VIOLET', 'Фиолетовый'
        WHITE = 'WHITE', 'Белый'
        BLACK = 'BLACK', 'Нигерский'
        DEFAULT = 'DEFAULT', 'По умолчанию'

    name = models.CharField('Название', max_length=150)
    description = models.TextField('Описание', max_length=500)
    preview = models.ImageField(upload_to='media/products/', null=True, blank=True)
    price = models.PositiveSmallIntegerField('Цена', default=0)
    color = models.CharField('Цвета', choices=Colors.choices, default=Colors.DEFAULT)
    characteristics = models.ForeignKey(
        'Characteristic', on_delete=models.SET_NULL, null=True, blank=True, verbose_name='Характеристики'
    )
    url = models.SlugField('Ссылка', max_length=250, unique=True)

    def __str__(self):
        return self.name
    #Добавить метод get_abs_url см в гугле
    class Meta:
        db_table = 'product'
        verbose_name = 'Продукт'
        verbose_name_plural = 'Продукты'


class ProductImages(models.Model):
    """Изображения продукта"""
    image = models.ImageField(upload_to='media/products/') # Тут будут храниться все фото , отфильтруй по папкам
    # Можно добавить name или description для фото
    product = models.ForeignKey(Product, on_delete=models.CASCADE, verbose_name='Продукт')

    class Meta:
        db_table = 'product_images'
        verbose_name = 'Изображение'
        verbose_name_plural = 'Изображения'


class ProductReview(models.Model):
    """Отзывы к продукту"""
    customer = models.ForeignKey(CustomUser, on_delete=models.CASCADE, blank=True, verbose_name='Покупатель')
    product = models.ForeignKey(Product, on_delete=models.CASCADE, verbose_name='Продукт')
    text = models.TextField('Отзыв', max_length=250)
    # Я бы сделал тут не Fk а ContentType, Но не критично
    parent = models.ForeignKey(
        'self', on_delete=models.SET_NULL, null=True, blank=True, verbose_name='Родительский отзыв'
    )

    def __str__(self):
        return f'{self.customer} - {self.text}'

    class Meta:
        db_table = 'product_review'
        verbose_name = 'Отзыв к продукту'
        verbose_name_plural = 'Отзывы к продукту'


class RatingStar(models.Model):
    """Звезда рейтинга"""
    value = models.PositiveSmallIntegerField('Значение', default=0)

    def __str__(self):
        return self.value

    class Meta:
        db_table = 'rating_star'
        verbose_name = 'Звезда рейтинга'
        verbose_name_plural = 'Звёзды рейтинга'


class Rating(models.Model):
    """Рейтинг"""
    customer = models.ForeignKey(
        CustomUser, on_delete=models.SET_NULL, null=True, blank=True, verbose_name='Покупатель'
    )
    star = models.ForeignKey(RatingStar, on_delete=models.CASCADE, verbose_name='Звезда')
    product = models.ForeignKey(Product, on_delete=models.CASCADE, verbose_name='Продукт')

    def __str__(self):
        return f'{self.customer} - {self.star}'

    class Meta:
        db_table = 'rating'
        verbose_name = 'Рейтинг'
        verbose_name_plural = 'Рейтинг'


class Characteristic(models.Model):
    """Характеристики"""

    class CompositionType(models.TextChoices):
        STEEL = 'STEEL', 'Сталь'
        IRON = 'IRON', 'Железо'
        ALUMINIUM = 'ALUMINIUM', 'Алюминий'
        CAST_IRON = 'CAST_IRON', 'Чугун'
        POLYESTER = 'POLYESTER', 'Полиэстер'
        PLA = 'PLA', 'PLA'
        ABS = 'ABS', 'ABS'
        PETG = 'PETG', 'PETG'

    weight = models.PositiveSmallIntegerField('Вес', default=0)
    material = models.CharField('Материал', choices=CompositionType.choices, default=CompositionType.PLA)

    def __str__(self):
        return f'{self.material} - {self.weight}'

    class Meta:
        db_table = 'characteristic'
        verbose_name = 'Характеристика'
        verbose_name_plural = 'Характеристики'


class Customer(models.Model):
    """Покупатель"""
    user = models.ForeignKey(CustomUser, on_delete=models.CASCADE)
    # Где поля адреса фио и тд ???
    # Тут должна быть сылка на adress
    def __str__(self):
        return self.user.username

    class Meta:
        db_table = 'customer'
        verbose_name = 'Покупатель'
        verbose_name_plural = 'Покупатели'


class Order(models.Model):
    """Заказ"""

    class Statuses(models.TextChoices):
        IN_PROCESSING = 'IN_PROCESSING', 'В обработке'
        ACCEPTED = 'ACCEPTED', 'Принята'
        PREPARED_FOR_SHIPMENT = 'PREPARED_FOR_SHIPMENT', 'Подготовлено к отправке'
        SENT = 'SENT', 'Отправлено',
        DELIVERED = 'DELIVERED', 'Доставлено'
        COMPLETED = 'COMPLETED', 'Завершен'

    product = models.ForeignKey(Product, on_delete=models.SET_NULL, null=True, verbose_name='Продукт')
    user = models.ForeignKey(CustomUser, on_delete=models.CASCADE, verbose_name='Заказчик')
    date = models.DateTimeField('Дата заказа', default=datetime.now())
    count = models.SmallIntegerField('Количество', default=1)
    status = models.CharField('Статус', choices=Statuses.choices, default=Statuses.IN_PROCESSING)

    def __str__(self):
        return f'{self.product} - {self.date} - {self.count} - {self.status}'

    class Meta:
        db_table = 'order'
        verbose_name = 'Заказ'
        verbose_name_plural = 'Заказы'


class Address(models.Model):
    """Адрес"""
    user = models.ForeignKey(CustomUser, on_delete=models.CASCADE, verbose_name='Пользователь') # Не верно !!!!! Адрес должен быть у пациента , но не у адрема есть пациент
    recipient = models.CharField('Получатель', max_length=250)
    phone = models.CharField('Номер телефона', max_length=50)
    country = models.CharField('Страна', max_length=150)
    city = models.CharField('Город', max_length=150)
    location = models.CharField('Дом, кв', max_length=250)
    zip = models.CharField('Почтовый индекс', max_length=25)

    def __str__(self):
        return f'{self.country}-{self.city}-{self.location}'

    class Meta:
        db_table = 'address'
        verbose_name = 'Адрес'
        verbose_name_plural = 'Адреса'


class Post(models.Model):
    """Пост"""
    title = models.CharField('Заголовок', max_length=250)
    author = models.ForeignKey(CustomUser, on_delete=models.CASCADE, verbose_name='Автор')
    preview = models.ImageField('Превью', upload_to='media/post_previews/')
    publish_date = models.DateTimeField('Дата публикации', default=datetime.now())
    tags = models.ManyToManyField('Tag', verbose_name='теги')
    text = models.TextField('Текст', max_length=1000)

    def __str__(self):
        return self.title

    class Meta:
        db_table = 'post'
        verbose_name = 'Пост'
        verbose_name_plural = 'Посты'


class Tag(models.Model):
    name = models.CharField('Тег', max_length=25)
    url = models.SlugField('Ссылка', max_length=250, unique=True)

    def __str__(self):
        return self.name

    class Meta:
        db_table = 'tag'
        verbose_name = 'Тег'
        verbose_name_plural = 'Теги'


class PostReview(models.Model):
    user = models.ForeignKey(CustomUser, on_delete=models.SET_NULL, null=True, blank=True, verbose_name='Пользователь')
    name = models.CharField('Имя', max_length=50)
    email = models.EmailField('Email', unique=True)
    text = models.TextField('Текст', max_length=500)
    post = models.ForeignKey(Post, on_delete=models.CASCADE, verbose_name='Пост')

    def __str__(self):
        return f'{self.name} - {self.post}'