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 RotationStudentSet(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")

        student_sets = (
            TtStudentSet.objects
            .filter(academic_term_id=academic_term_id)
            .prefetch_related('activity')
            .order_by(self.list_default_order_column)
        )

        if module_id:
            student_sets = student_sets.filter(module__id=module_id)

        return_data = []
        for val in student_sets:
            return_data.append({
                "id": val.id,
                "name": val.name,
                "activity_ids": [a.id for a in val.activity.all()],
            })

        return list(return_data)