import json

from django.contrib.contenttypes.fields import GenericRelation
from django.db import models

class TtAcademicTerm(models.Model):
    code = models.CharField(max_length=150)
    name = models.CharField(max_length=255)
    start_date = models.DateField()
    end_date = models.DateField()
    start_time = models.TimeField()
    end_time = models.TimeField()
    default_availability = models.TextField(null=True)
    default_usage = models.TextField(null=True)
    default_start = models.TextField(null=True)
    extra_data_1 = models.TextField(null=True)
    extra_data_2 = models.TextField(null=True)
    extra_data_3 = models.TextField(null=True)
    extra_data_4 = models.TextField(null=True)
    extra_data_5 = models.TextField(null=True)
    extra_data_6 = models.TextField(null=True)
    extra_data_7 = models.TextField(null=True)
    extra_data_8 = models.TextField(null=True)
    extra_data_9 = models.TextField(null=True)
    extra_data_10 = models.TextField(null=True)
    status = models.SmallIntegerField()
    created_by = models.BigIntegerField(null=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_by = models.BigIntegerField(null=True)
    updated_at = models.DateTimeField(auto_now=True)

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

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

    # table need display for delete confirmation
    DELETE_CONFIRMATION_TABLE = [
        "tt_module",
        "tt_pos",
        "tt_activity",
        "tt_activity_template",
        "tt_student_set",
        "tt_week_pattern",
        "tt_pathway",
    ]

    class Meta:
        db_table = "tt_academic_term"

    def __str__(self):
        return self.name