from django.db import models


class TtActivity(models.Model):
    id = models.BigAutoField(primary_key=True)
    code = models.CharField(max_length=150)
    name = models.CharField(max_length=255)
    desc = models.TextField(null=True)
    activity_template_id = models.BigIntegerField(null=True)
    activity_type_id = models.BigIntegerField(null=True)
    department_id = models.BigIntegerField(null=True)
    zone_id = models.BigIntegerField(null=True)
    module_id = models.BigIntegerField(null=True)
    academic_term_id = models.BigIntegerField(null=True)
    duration = models.IntegerField(null=True, db_comment="in minute")
    slot_required = models.IntegerField(null=True)
    planned_size = models.IntegerField(null=True)
    real_size = models.IntegerField(null=True)
    scheduled_start_time = models.TimeField(null=True)
    scheduled_day = models.SmallIntegerField(null=True, db_comment="0 - Monday, 6 - Sunday")
    scheduled_start_slot = models.IntegerField(null=True)
    scheduled = models.IntegerField(null=True, default=0)
    week_pattern_id = models.BigIntegerField(null=True)
    is_jta = models.IntegerField(null=True, default=0)
    jta_parent_id = models.BigIntegerField(null=True)
    is_variant = models.IntegerField(null=True, default=0)
    variant_parent_id = models.BigIntegerField(null=True)
    status = models.SmallIntegerField()

    week = models.ManyToManyField("api.TtWeek", through="api.TtActivityWeek")

    STATUS_TO_CODE = {
        "active": 1,
        "inactive": 2,
    }

    class Meta:
        db_table = "tt_activity"

    def __str__(self) -> str:
        return self.name