import json
import math

from django.db.models import Count, Q
from rest_framework import status
from rest_framework.exceptions import ValidationError
from django.db import connection
from api.models import TtModule, TtActivityTemplate, TtActivity, TtPos, TtSetting
from api.models.tt_location import TtLocation
from api.models.tt_staff import TtStaff
from api.models.tt_student_set import TtStudentSet
from api.translation import __
from api.utils import log_critical_error, get_exception_detail
from api.validator import BaseValidator
from api.views.admin.base import AdminApiBase
from api.views.medical.base import MedicalApiBase


class RotationActivity(MedicalApiBase):
    def validate_request(self,request):
        rules = {
            "activity_template_ids": "required|array|exists:api.TtActivityTemplate,id",
        }
        # if need rename field, can put here
        attribute = {
            # "email": __("attr.email"),
        }
        # validate id first, cause need get pos by id, if wrong id direct return error
        validator = BaseValidator(request.data,rules,attribute)
        error = validator.validate()
        if error:
            raise ValidationError(error)

    def post(self, request):
        try:
            self.api_log_skip_outgoing_data=True
            self.validate_request(request)

            data = self.get_data(request)

            response = {
                "data": data
            }
            # log_critical_error(user_id=None,descr=len(connection.queries),url="testing")

            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)

    def get_data(self, request):
        activity_template_ids = request.data.get("activity_template_ids")

        activities = (
            TtActivity.objects
            .filter(activity_template_id__in=activity_template_ids)
            .select_related("activity_template")
            .order_by(self.list_default_order_column)
        )

        return_data = {}
        for val in activities:
            activity_template = val.activity_template
            if activity_template.id not in return_data:
                return_data[activity_template.id] = {
                    "id": activity_template.id,
                    "name": activity_template.name,
                    "activities": list()
                }
            return_data[activity_template.id]["activities"].append({
                "id": val.id,
                "name": val.name,
                "slot_required": val.slot_required,
            })

        return list(return_data.values())