from django.contrib.auth import get_user_model
from django.db import models

from tickets.models import Ticket

from dbsynce.docs.database.relationship import Relationship as HelpTexts


class Relationship(models.Model):
    """
    Relationship - описание связей 
    (желательных - как имеющиеся договорные отношения, 
    и нежелательных - как пожелание любой из сторон)
    """

    id = models.IntegerField(
        primary_key=True
    )

    # ID METASERVICE
    id_metaservice = models.PositiveIntegerField(
        null=True,
        help_text=HelpTexts.id_metaservice
    )

    # DATA
    neg_type = models.IntegerField(
        help_text=HelpTexts.neg_type
    )
    requirements = models.CharField(
        max_length=150,
        help_text=HelpTexts.requirements
    )
    status = models.CharField(
        max_length=150,
        help_text=HelpTexts.status
    )

    # OTHER
    is_global = models.CharField(
        max_length=1,
        default="f",
        help_text=HelpTexts.is_global
    )
    is_visible = models.CharField(
        max_length=1,
        default="f",
        help_text=HelpTexts.is_visible
    )

    # FK
    user_id_who = models.ForeignKey(
        get_user_model(),
        related_name="user_id_who",
        on_delete=models.DO_NOTHING,
        help_text=HelpTexts.user_id_who
    )
    user_id_whom = models.ForeignKey(
        get_user_model(),
        related_name="user_id_whom",
        on_delete=models.DO_NOTHING,
        help_text=HelpTexts.user_id_whom
    )
    ticket_status = models.ForeignKey(
        Ticket,
        on_delete=models.DO_NOTHING,
        help_text=HelpTexts.ticket_status
    )

    class Meta:
        db_table = "relationship"
        verbose_name = "Связь (Договорное отношение)"
        verbose_name_plural = "Связи (Договорные отношения)"