from django.db import models
from datetime import time

class EsExamRequirement(models.Model):
    exam_period = models.ForeignKey("api.EsExamPeriod", on_delete=models.CASCADE)
    code = models.CharField(max_length=150, unique=True)
    name = models.CharField(max_length=150)
    description = models.TextField(null=True)
    planned_size = models.IntegerField()
    writing_time = models.TimeField()
    fixed_start_date = models.DateField(null=True)
    reading_time = models.TimeField()
    fixed_start_time = models.TimeField(null=True)
    location_required = models.BooleanField(default=False)
    exclusive_use = models.BooleanField(default=False)
    minimum_split_size = models.IntegerField(null=True)
    earliest_start = models.DateTimeField(null=True)
    latest_end = models.DateTimeField(null=True)
    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)

    invigilator_suitability = models.ManyToManyField(
        "api.EsSuitability",
        through="api.EsExamRequirementInvigilatorSuitability",
        related_name="exam_requirement_invigilator_suitability",
    )
    location_suitability = models.ManyToManyField(
        "api.EsSuitability",
        through="api.EsExamRequirementLocationSuitability",
        related_name="exam_requirement_location_suitability",
    )

    IMPORT_RULES = {
        "code": ["required", "string", "unique"],
        "exam_period_id": ["required", "exist"],
        "name": ["required", "string"],
        "description": ["nullable", "string"],
        "planned_size": ["required", "integer"],
        "writing_time": ["required", "time"],
        "reading_time": ["required", "time"],
        "fixed_start_date": ["nullable", "date"],
        "fixed_start_time": ["nullable", "time"],
        "location_required": ["nullable", "boolean"],
        "exclusive_use": ["nullable", "boolean"],
        "minimum_split_size": ["nullable", "integer"],
        "earliest_start": ["nullable", "datetime"],
        "latest_end": ["nullable", "datetime"],
    }

    EXAM_REQUIREMENT_STUDENT = {
        "IMPORT_RULES": {
            "exam_requirement_id": ["required", "string"],
            "student_id": ["required", "string"],
        }
    }

    EXAM_REQ_INVIGILATOR_S = {
        "IMPORT_RULES": {
            "exam_requirement_id": ["required", "string"],
            "suitability_id": ["required", "string"],
        }
    }

    EXAM_REQ_LOCATION_S = {
        "IMPORT_RULES": {
            "exam_requirement_id": ["required", "string"],
            "suitability_id": ["required", "string"],
        }
    }

    class Meta:
        db_table = "es_exam_requirement"

    def __str__(self):
        return self.name