import datetime
from collections import defaultdict

from django.db.models import F
from rest_framework import serializers, status

from api.models import TtSetting, TtActivity, TtActivitySequencing
from api.views.admin.base import AdminApiBase
from api.validator import BaseValidator
from api.utils import log_critical_error, get_exception_detail
from rest_framework.exceptions import ValidationError
from api.translation import __


class ActivitySequencingRules(AdminApiBase):
    def validate_request(self,request):
        rules = {
            "academic_term_id": "required|exists:api.TtAcademicTerm,id",
            "activity_id": "required|exists:api.TtActivity,id",
            "type": "nullable"
        }
        # if need rename field, can put here
        attribute = {
            # "email": __("attr.email"),
        }
        # validate id first, cause need get activity_template by id, if wrong id direct return error
        validator = BaseValidator(request.data,rules,attribute)
        error = validator.validate()
        if error:
            raise ValidationError(error)
        # custom error after basic validation

        if error:
            raise ValidationError(error)

    def post(self, request):
        # Validate input
        try:
            self.api_log_skip_outgoing_data=True
            self.validate_request(request)
            academic_term_id = request.data.get("academic_term_id")
            activity_id = request.data.get("activity_id")
            filter_type = request.data.get("type")

            activity = (
                TtActivity.objects
                .prefetch_related(
                    "sequencing_from",
                    "student_set",
                    "module__ttposmodulegroupmodule_set__pos_module_group__pos"
                    # tags means the relation add in models, __tag means the relation table tag_id get the tag object #2
                )
                .filter(id=activity_id).first()# no need get jta parent activity
            )
            sequencing_activity_id = set()
            info = {
                "activity": [],
                "same_time": [],
                "preceding": [],
                "succeeding": [],
                "min_day": activity.min_day,
                "min_hour": activity.min_hour,
                "min_minute": activity.min_minute,
                "min_slot_required": activity.min_slot_required,
                "max_day": activity.max_day,
                "max_hour": activity.max_hour,
                "max_minute": activity.max_minute,
                "max_slot_required": activity.max_slot_required,
            }
            for sequencing in activity.sequencing_from.all():
                sequencing_activity_id.add(sequencing.sequencing_activity_id)
                if sequencing.type == TtActivitySequencing.TYPE_TO_CODE["same_time"]:
                    info["same_time"].append(sequencing.sequencing_activity_id)
                elif sequencing.type == TtActivitySequencing.TYPE_TO_CODE["preceding"]:
                    info["preceding"].append(sequencing.sequencing_activity_id)
                elif sequencing.type == TtActivitySequencing.TYPE_TO_CODE["succeeding"]:
                    info["succeeding"].append(sequencing.sequencing_activity_id)

            sequencing_activity_id = list(sequencing_activity_id)
            sequencing_activities_list = (
                TtActivity.objects
                .filter(id__in=sequencing_activity_id,jta_parent_id__isnull=True) # dun get jta parent activity
                .select_related("module","activity_template")
                .values(
                    "id",
                    "code",
                    "name",
                    "planned_size",
                    module_code=F("module__code"),
                    module_name=F("module__name"),
                    activity_template_code=F("activity_template__code"),
                    activity_template_name=F("activity_template__name"),
                ).distinct()
            )

            info["activity"] = list(sequencing_activities_list)

            data = {}
            data['delete_confirmation_api'] = False
            data["allow_remove"] = [
                "same_time",
                "preceding",
                "succeeding",
                "min_day",
                "min_hour",
                "min_minute",
                "max_day",
                "max_hour",
                "max_minute",
            ]
            setting_params = {
                "minute_per_slot",
                "slot_per_day",
                "slot_per_week",
            }
            data['based_setting'] = TtSetting.get_multiple_setting(setting_params)

            available_activities = (
                TtActivity.objects
                .filter(academic_term_id=academic_term_id,is_booking=0,jta_parent_id__isnull=True)
                .exclude(id=activity_id)#exclude self
                .select_related("module","activity_template")
            )
            match filter_type:
                case "department":
                    available_activities = available_activities.filter(department_id=activity.department_id)
                case "activity_template":
                    available_activities = available_activities.filter(activity_template_id=activity.activity_template_id)
                case "module":
                    available_activities = available_activities.filter(module_id=activity.module_id)
                case "student_set":
                    available_activities = available_activities.filter(student_set__in=activity.student_set.all())
                case "pos":
                    pos_ids = list({
                        item.pos_module_group.pos_id
                        for item in activity.module.ttposmodulegroupmodule_set.all()
                        if item.pos_module_group.pos is not None
                    })
                    available_activities = available_activities.filter(module__ttposmodulegroupmodule__pos_module_group__pos_id__in=pos_ids)
                case _:
                    pass
            data["activity"] = list(
                available_activities.values(
                    "id",
                    "code",
                    "name",
                    "planned_size",
                    module_code=F("module__code"),
                    module_name=F("module__name"),
                    activity_template_code=F("activity_template__code"),
                    activity_template_name=F("activity_template__name"),
                ).distinct()
            )

            response = {
                "info": info,
                "rules": data,
            }

            return self.api_response(data=response)
        except ValidationError as e:
            first_message = e.detail['error']
            errors = e.detail['errors']
            return self.api_response(error=first_message,errors=errors,code=status.HTTP_400_BAD_REQUEST)
        except Exception as e:
            e_details = get_exception_detail(e)
            log_critical_error(user_id=None,descr=e_details['descr'],url=e_details['url'],trace=e_details['trace'])
            return self.api_response(error=__("message.internal_server_error"),code=status.HTTP_500_INTERNAL_SERVER_ERROR)