import math

from django.db.models import Count, Q
from rest_framework import status
from rest_framework.exceptions import ValidationError

from api.models import TtModule, TtActivityTemplate
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 ActivityTemplateList(AdminApiBase):
    def validate_request(self,request):
        rules = {
            "academic_term_id": "required|exists:api.TtAcademicTerm,id",
            "filter": "nullable",
            "page": "nullable",
            "per_page": "nullable",
            "sort_by": "nullable",
            "order_by": "nullable",
        }
        # 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

            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):

        existing_activity_exclude_condition = (
            Q(ttactivity__is_jta=1, ttactivity__jta_parent_id__isnull=True) |
            Q(ttactivity__is_variant=1, ttactivity__variant_parent_id__isnull=False)
        )
        activity_templates = (
            TtActivityTemplate.objects
            .filter(academic_term_id=request.data.get('academic_term_id'))
            .select_related("department", "academic_term", "module", "week_pattern","activity_type", "zone", "availability", "start_preference", "usage_preference")
            .prefetch_related(
                "staff",
                "staff_suitability",
                "location",
                "location_suitability",
                "week",
                "week_pattern__week",
                "tag__tag"
                # tags means the relation add in models, __tag means the relation table tag_id get the tag object #2
            )
            .annotate(activity_count=Count("ttactivity",filter=~existing_activity_exclude_condition))
        )
        activity_templates = self.listing_filter(request,activity_templates)

        paginated_details = self.listing_pagination(request,activity_templates)
        total = paginated_details["total"]
        paginated_data = paginated_details["paginated_data"]
        page = paginated_details["page"]
        return_data=[]

        for val in paginated_data:
            data={}
            data["id"] = val.id
            data["code"] = val.code
            data["name"] = val.name
            data['desc'] = val.desc
            data['department'] = val.department.name if val.department else None
            data['department_id'] = val.department_id
            data['sequence_number'] = val.sequence_number
            data['academic_term'] = val.academic_term.name if val.academic_term else None
            data['academic_term_id'] = val.academic_term_id
            data['activity_type'] = val.activity_type.name if val.activity_type else None
            data['activity_type_color'] = val.activity_type.color if val.activity_type else None
            data['activity_type_id'] = val.activity_type_id
            data['zone'] = val.zone.name if val.zone else None
            data['zone_id'] = val.zone_id
            data['module_name'] = val.module.name if val.module else None
            data['module_code'] = val.module.code if val.module else None
            data['module_id'] = val.module_id
            data['duration'] = val.duration

            data['staff_requirement_type'] = __("attr.staff_requirement_type_name."+str(val.staff_requirement_type))
            data['staff_requirement'] = val.staff_requirement
            data['location_requirement_type'] = __("attr.location_requirement_type_name."+str(val.location_requirement_type))
            data['location_requirement'] = val.location_requirement
            data['planned_size'] = val.planned_size

            # module size, extising activity, required activity, need to generate
            data['module_size'] = val.module.planned_size if val.module else 0
            data['required_activity'] = math.ceil(data['module_size'] / data['planned_size']) if data['module_size'] > 0 and data['planned_size'] > 0 else 0
            data['existing_activity'] = val.activity_count

            data['need_to_generate'] = max(data['required_activity'] - data['existing_activity'],0)

            data["week_pattern_id"] = val.week_pattern.id if val.week_pattern else None
            data["week_pattern_name"] = val.week_pattern.name if val.week_pattern else "-"
            if val.week_pattern:
                data["week_pattern"] = [
                    {"id": week.id, "week": week.week, "start_date": week.start_date}
                    for week in val.week_pattern.week.all()
                ]
            else:
                data["week_pattern"] = [
                    {"id": week.id, "week": week.week, "start_date": week.start_date}
                    for week in val.week.all()
                ]
            data["availability_id"] = val.availability.id if val.availability else None
            data["availability_name"] = val.availability.name if val.availability else "-"
            data["availability_pattern"] = val.availability.pattern if val.availability else val.availability_pattern
            data["start_preference_id"] = val.start_preference.id if val.start_preference else None
            data["start_preference_name"] = val.start_preference.name if val.start_preference else "-"
            data["start_preference_pattern"] = val.start_preference.pattern if val.start_preference else val.start_preference_pattern
            data["usage_preference_id"] = val.usage_preference.id if val.usage_preference else None
            data["usage_preference_name"] = val.usage_preference.name if val.usage_preference else "-"
            data["usage_preference_pattern"] = val.usage_preference.pattern if val.usage_preference else val.usage_preference_pattern

            data['staff_suitability'] = [
                {"id": suit.id, "name": suit.name}
                for suit in val.staff_suitability.all()
            ]
            data['staff'] = [
                {"id": staff.id, "name": staff.name}
                for staff in val.staff.all()
            ]
            data['location_suitability'] = [
                {"id": location.id, "name": location.name}
                for location in val.location_suitability.all()
            ]
            data['location'] = [
                {"id": location.id, "name": location.name}
                for location in val.location.all()
            ]
            data["tag"] = [
                {"id": tag.tag.id, "name": tag.tag.name}
                for tag in val.tag.all()
            ]

            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 {
            "total": total,
            "page": page,
            "data": return_data,
        }