from collections import defaultdict

from django.contrib.postgres.aggregates import ArrayAgg
from django.db.models import Q
from rest_framework import serializers, status

from api.models import TtSuitability, TtTag, TtSetting, AuditTrail, AuditTrailDetails, TtDepartment, TtZone, \
    TtTimeBlock, TtFreeBlock, TtResourceBreak, TtMaximumHour, TtMaximumWorkspan
from api.views.admin.base import AdminApiBase
from api.validator import BaseValidator
from api.utils import decrypt_aes_128_cbc, encrypt_aes_128_cbc, log_critical_error, get_exception_detail, \
    bulk_sync_to_redis, get_ip, get_related_fk_table_ids
from rest_framework.exceptions import ValidationError
from api.translation import __
from backend.kafka import send_request
from backend.redis_client import redis_client


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

        if error:
            raise ValidationError(error)

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

            action = "time_block_delete"
            ids = request.data.get("id")

            time_block = (
                TtTimeBlock.objects.filter(id__in=ids).prefetch_related(
                    "ttresourcebreak_set",
                    "ttfreeblock_set",
                    "ttmaximumhour_set",
                    "ttmaximumworkspan_set"
                )
            )
            time_block_name = ",".join(time_block.values_list("name", flat=True))
            
            # record related table id need to extra update in redis
            resource_break_ids = set()
            free_block_ids = set()
            maximum_hour_ids = set()
            maximum_workspan_ids = set()
            for val in time_block:
                resource_break_ids.update({a.id for a in val.ttresourcebreak_set.all()})
                free_block_ids.update({a.id for a in val.ttfreeblock_set.all()})
                maximum_hour_ids.update({a.id for a in val.ttmaximumhour_set.all()})
                maximum_workspan_ids.update({a.id for a in val.ttmaximumworkspan_set.all()})

            TtTimeBlock.objects.filter(id__in=ids).delete()
            # # remove from redis
            redis_time_block_table = "time_block"
            redis_resource_break_table = "resource_break"
            redis_free_block_table = "free_block"
            redis_maximum_hour_table = "maximum_hour"
            redis_maximum_workspan_table = "maximum_workspan"
            redis_data = {
                "update": {},
                "delete": {}
            }
            get_model_time_block(TtFreeBlock,free_block_ids,redis_free_block_table,redis_data)
            get_model_time_block(TtResourceBreak,resource_break_ids,redis_resource_break_table,redis_data)
            get_model_time_block(TtMaximumHour,maximum_hour_ids,redis_maximum_hour_table,redis_data)
            get_model_time_block(TtMaximumWorkspan,maximum_workspan_ids,redis_maximum_workspan_table,redis_data)

            # delete time_block from redis
            for id in ids:
                redis_data["delete"].setdefault(redis_time_block_table, []).append(id)

            bulk_sync_to_redis(redis_client,redis_data)

            audit_trail = AuditTrail.objects.create(
                user_id=request.user.id,
                type=self.audit_type,
                ip_address=get_ip(request)
            )
            remark_param = {
                "name": time_block_name,
            }

            # 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=remark_param,
            )
            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)


def get_model_time_block(model_class, ids, redis_table, redis_data):
    """
    Helper function to return redis related model time_block_ids
    """
    if not ids:
        return

    results = (
        model_class.objects.filter(id__in=ids)
        .annotate(
            time_block_ids=ArrayAgg(
                "time_block__id",
                filter=Q(time_block__id__isnull=False),
                distinct=True
            )
        )
        .values("id", "time_block_ids")
    )

    for item in results:
        redis_data["update"].setdefault(redis_table, []).append({
            "id": item["id"],
            "time_block_ids": item["time_block_ids"] or [],
        })