from rest_framework import status

from api.models import EsInvigilator

from api.models.audit_trail import AuditTrail
from api.models.audit_trail_details import AuditTrailDetails
from api.views.admin.base import AdminApiBase
from api.validator import BaseValidator
from api.utils import log_critical_error, get_exception_detail, get_ip, get_multiple_old_new_data
from rest_framework.exceptions import ValidationError
from api.translation import __

class InvigilatorUpdate(AdminApiBase):
    def validate_request(self,request):
        rules = {
            "id": "required|array|exists:api.EsInvigilator,id",
        }
        # if need rename field, can put here
        attribute = {
            # "email": __("attr.email"),
        }
        # validate id first, cause need get Invigilator by id, if wrong id direct return error
        validator = BaseValidator(request.data,rules,attribute)
        error = validator.validate()
        if error:
            raise ValidationError(error)

        edit_invigilator = (
            EsInvigilator.objects
            .select_related("department")
            .prefetch_related(
                "suitability",
                "tag__tag" # tags means the relation add in models, __tag means the relation table tag_id get the tag object #2
            )
            .filter(id__in=request.data.get("id"))
        )

        status_code_string = ",".join(str(v) for v in EsInvigilator.STATUS_TO_CODE.values())
        rules = {
            "name": "nullable",
            "desc": "nullable",
            "email": "nullable",
            "phone": "nullable",
            "engagement_date": "nullable|date",
            "termination_date": "nullable|date",
            "department_id": "nullable|exists:api.EsDepartment,id",
            "role": "nullable|array|exists:api.EsInvigilatorRole,id",
            "tag": "nullable|array|exists:api.EsTag,id",
            "suitability": "nullable|array|exists:api.EsSuitability,id",
            "status": "nullable|in:"+status_code_string,
        }

        if request.data.get("code") and edit_invigilator.count() == 1:
            invigilator = edit_invigilator.first()
            if request.data.get("code") != invigilator.code:
                rules['code'] = "nullable|not_exists:api.EsInvigilator,code"

        # if need rename field, can put here
        attribute = {
            # "email": __("attr.email"),
        }

        validator = BaseValidator(request.data,rules,attribute)
        error = validator.validate()

        # custom error after basic validation

        if error:
            raise ValidationError(error)

        return edit_invigilator


    def post(self, request):
        # Validate input
        try:
            edit_invigilator = self.validate_request(request)

            action="invigilator_update" # this is for audit log only

            updated = False
            update_fields = {}
            ignore_fields = ['id','role','tag','suitability','timestamp','signature']
            # if more than 1 Invigilator edit, ignore code
            if edit_invigilator.count() > 1 or not request.data.get("code"):
                ignore_fields.append('code')
            valid_fields = {f.column for f in EsInvigilator._meta.fields}
            for key, val in request.data.items():
                if key not in ignore_fields and key in valid_fields:
                    updated = True
                    match key:
                        case _:
                            # default the key will same as db column name
                            update_fields[key] = val

            # be4 save need get the old new data already, because bulk update is no matter got change or no changes also will update
            old_new_data = get_multiple_old_new_data(edit_invigilator,request.data.items(),ignore_fields,valid_fields)
            if updated and update_fields:
                update_fields['updated_by'] = request.user.id
                edit_invigilator.update(**update_fields)

            if "role" in request.data:
                new_ids = request.data.get("role", [])
                old_new_data = self.update_m2m_field_bulk(edit_invigilator,'role',new_ids,old_new_data,False,False)

            if "tag" in request.data:
                new_ids = request.data.get("tag", [])
                old_new_data = self.update_m2m_field_bulk(edit_invigilator,'tag',new_ids,old_new_data,False,True)

            if "suitability" in request.data:
                new_ids = request.data.get("suitability", [])
                old_new_data = self.update_m2m_field_bulk(edit_invigilator,'suitability',new_ids,old_new_data)

            if old_new_data['old_data'] or old_new_data['new_data']:
                # insert audit trail and details
                # can insert the parent first, then only insert details
                audit_trail = AuditTrail.objects.create(
                    user_id=request.user.id,
                    type=self.audit_type,
                    ip_address=get_ip(request)
                )

                invigilator_code = ",".join(edit_invigilator.values_list("code", flat=True))

                # call to a function for insert details, so in future if want change to used worker, can modify in function only
                AuditTrailDetails.custom_insert(
                    audit_trail=audit_trail,
                    action=action,
                    remark_param={
                        "code": invigilator_code
                    },
                    new_data=old_new_data['new_data'],
                    old_data=old_new_data['old_data'],
                )

            response = {

            }

            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)