from django.db import models

from django.contrib.auth.models import AbstractUser








class Account(AbstractUser):

    # groupID = models.ManyToOneRel(
    #     'StudyGroups',
    #     to='GroupHelper',
    #     field_name='groups'
    # )

    second_name = models.CharField(
        blank=True,
        null=True,
        max_length=45,
        verbose_name='Отчество'
    )

    avatar = models.ImageField(
        upload_to='avatars/',
        blank=True,
        null=True,
        verbose_name='Аватар'
    )

    phone = models.CharField(
        max_length=11,
        null=True,
        blank=True,
        verbose_name='Номер телефона'
    )

    burstday = models.DateField(
        auto_now=False,
        null=True,
        blank=True,
        verbose_name='День рождения'
    )

    type = models.BooleanField(
        blank=True,
        default=False,
        verbose_name='читатель/ВВ'
    )

    email = models.EmailField(
        blank=False,
        null=False,
        unique=True
    )

    isDeleted = models.BooleanField(
        default=False,
        verbose_name='Помечена как удаленная'
    )

    lastUpdated = models.DateTimeField(
        auto_now=True,
        verbose_name='Обновлена'
    )

    def __str__(self):
        return ' '.join([
            self.first_name,
            self.last_name,
        ])


class StudyGroups(models.Model):


    name = models.CharField(
        max_length=250,
        unique=True,
        verbose_name='Название группы'
    )

    snippet = models.TextField(
        blank=True,
        null=True,
        verbose_name='Описание'
    )

    mhID = models.ManyToManyField(
        'Account',
        blank=True,
        null=True,
    )

    lastUpdated = models.DateTimeField(
        auto_now=True,
        verbose_name='Обновлена'
    )

    created = models.DateTimeField(
        auto_now_add=True,
        verbose_name='Создана'
    )

    isDeleted = models.BooleanField(
        default=False,
        verbose_name='Помечена как удаленная'
    )

    def __str__(self):
        return self.name

    class Meta:
        verbose_name = 'Учебные группы'
        verbose_name_plural = 'Учебные группы'


class GroupHelper(models.Model):

    title = models.CharField(max_length=45, blank=True, null=True)
    person = models.ForeignKey(Account, on_delete=models.CASCADE, null=True, blank=True)
    groups = models.ForeignKey(StudyGroups, on_delete=models.CASCADE, null=True, blank=True, unique=True)

    def __str__(self):
        return self.title