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 RotationActivityTemplate(MedicalApiBase):
    def validate_request(self,request):
        rules = {
            "academic_term_id": "required|exists:api.TtAcademicTerm,id",
            "module_id": "nullable",# only can filter by module, if no pass in means is get all module activity
        }
        # 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 = []
            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):
        academic_term_id = request.data.get("academic_term_id")
        module_id = request.data.get("module_id")

        activity_templates = (
            TtActivityTemplate.objects
            .filter(academic_term_id=academic_term_id)
            .select_related("activity_type")
            .order_by(self.list_default_order_column)
        )

        if module_id:
            activity_templates = activity_templates.filter(module_id=module_id)

        return_data = []
        for val in activity_templates:
            return_data.append({
                "id": val.id,
                "name": val.name,
                "activity_type": val.activity_type.name if val.activity_type else None,
            })

        return list(return_data)