from rest_framework import status
from rest_framework.exceptions import ValidationError

from api.models import TtUsagePreference, TtTravelTable, TtSetting
from api.translation import __
from api.utils import log_critical_error, get_exception_detail, start_slot_end_slot_to_pattern
from api.validator import BaseValidator
from api.views.admin.base import AdminApiBase

class TravelTableList(AdminApiBase):
    def validate_request(self,request):
        rules = {
            "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": 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):
        setting_params = {
            "slot_per_week",
        }
        settings = TtSetting.get_multiple_setting(setting_params)
        slot_per_week = int(settings["slot_per_week"])
        travel_table = (
            TtTravelTable.objects
            .select_related("department",)
            .prefetch_related(
                'journey__from_zone',
                'journey__to_zone',
                "tag__tag" #tags means the relation add in models, __tag means the relation table tag_id get the tag object
            )
            .order_by(self.list_default_order_column)
        )
        travel_table = self.listing_filter(request, travel_table)
        return_data=[]
        for val in travel_table:
            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['journeys'] = [
                {
                    "id": journey.id,
                    "from_zone": {"id": journey.from_zone.id, "name": journey.from_zone.name, "code": journey.from_zone.code} if journey.from_zone else None,
                    "to_zone": {"id": journey.to_zone.id, "name": journey.to_zone.name, "code": journey.to_zone.code} if journey.to_zone else None,
                    "slot_required": journey.slot_required,
                }
                for journey in val.journey.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 return_data