from rest_framework import status
from rest_framework.exceptions import ValidationError

from api.models import EsStudent
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

class StudentList(AdminApiBase):
    list_default_order_column = "id"

    def validate_request(self, request):
        rules = {
            "filter": "nullable",
            "page": "nullable",
            "per_page": "nullable",
            "sort_by": "nullable",
            "order_by": "nullable",
        }
        validator = BaseValidator(request.data, rules, {})
        error = validator.validate()
        if error:
            raise ValidationError(error)

    def custom_listing_filter(self, request, model):
        filters = request.data.get("filter")
        if filters:
            for key, val in filters.items():
                if val == "" or val is None:
                    continue
                match key:
                    case "desc" | "email" | "phone":
                        filter_kwargs = {f"{key}__icontains": val}
                        model = model.filter(**filter_kwargs)
                    case "student_group_id" | "enrolled_programme_id" | "status" | "need_extra_provision":
                        if key == "student_group_id":
                            if isinstance(val, (list, tuple)):
                                model = model.filter(student_group_links__student_group_id__in=val).distinct()
                            else:
                                model = model.filter(student_group_links__student_group_id=val).distinct()
                        elif isinstance(val, (list, tuple)):
                            filter_kwargs = {f"{key}__in": val}
                            model = model.filter(**filter_kwargs)
                        else:
                            filter_kwargs = {key: val}
                            model = model.filter(**filter_kwargs)
        return model

    def post(self, request):
        try:
            self.api_log_skip_outgoing_data = True
            self.validate_request(request)
            
            data_details = self.get_data(request)
            
            response = {
                "page": data_details["page"],
                "per_page": data_details["per_page"],
                "total": data_details["total"],
                "data": data_details["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)

    def get_data(self, request):
        students = (
            EsStudent.objects
            .select_related("department", "student_group", "enrolled_programme")
            .prefetch_related("student_group_links__student_group")
            .all()
        )

        students = self.listing_filter(request, students)
        students = self.custom_listing_filter(request, students)
        paginated_details = self.listing_pagination(request, students)
        total = paginated_details["total"]
        paginated_data = paginated_details["paginated_data"]
        page = paginated_details["page"]
        per_page = paginated_details["per_page"]

        return_data = []

        for val in paginated_data:
            data = {}
            data["id"] = val.id
            data["code"] = val.code
            data["name"] = val.name
            data["email"] = val.email
            data["phone"] = val.phone
            data["desc"] = val.desc
            data["status"] = val.status
            data["status_text"] = __("attr.student_status."+str(val.status))
            data["department_id"] = val.department_id
            data["department"] = val.department.name if val.department else None
            
            data["student_group_id"] = val.student_group_id
            data["student_group"] = val.student_group.name if val.student_group else None
            student_groups = [
                {
                    "id": link.student_group_id,
                    "code": link.student_group.code,
                    "name": link.student_group.name,
                }
                for link in val.student_group_links.all()
            ]
            data["student_group_ids"] = [group["id"] for group in student_groups]
            data["student_groups"] = student_groups
            
            data["enrolled_programme_id"] = val.enrolled_programme_id
            data["enrolled_programme"] = val.enrolled_programme.name if val.enrolled_programme else None

            data["need_extra_provision"] = val.need_extra_provision
            data["reading_type"] = val.reading_type
            data["reading_time"] = val.reading_time
            data["writing_type"] = val.writing_type
            data["writing_time"] = val.writing_time

            for i in range(1, 11):
                extra_data_field = f"extra_data_{i}"
                data[extra_data_field] = getattr(val, extra_data_field, None)

            return_data.append(data)

        return {
            "page": page,
            "per_page": per_page,
            "total": total,
            "data": return_data
        }