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
from api.models.tt_location import TtLocation
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
from rest_framework.exceptions import ValidationError
from api.translation import __
from backend.kafka import send_request
from backend.redis_client import redis_client


class LocationDelete(AdminApiBase):
    def validate_request(self,request):
        rules = {
            "id": "required|array|exists:api.TtLocation,id",
        }
        # if need rename field, can put here
        attribute = {
            # "email": __("attr.email"),
        }
        # validate id first, cause need get location 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 = "location_delete"
            ids = request.data.get("id")

            location = TtLocation.objects.filter(id__in=ids).prefetch_related("suitability","avoid_concurrency")
            # get all suitability ids first, after success delete, will based on this suitability ids get suitability data with latest_location update for update redis
            suitability_ids = set()  # use set to avoid duplicates
            avoid_concurrency_ids = set()

            for val in location:
                suitability_ids.update(val.suitability.values_list("id", flat=True))
                avoid_concurrency_ids.update([ac.id for ac in val.avoid_concurrency.all()])

            # convert back to list
            suitability_ids = list(suitability_ids)
            avoid_concurrency_ids = list(avoid_concurrency_ids)

            location_name = ",".join(location.values_list("name", flat=True))

            TtLocation.objects.filter(id__in=ids).delete()

            # get latest suitability location id
            suitability_with_location = (
                TtSuitability.objects.filter(id__in=suitability_ids)
                .annotate(
                    location_ids=ArrayAgg(
                        "location__id",
                        filter=Q(location__id__isnull=False),  # prevents [None] when no result
                        distinct=True)
                )
                .values("id", "location_ids")
            )
            # remove from redis
            redis_location_table = "location"
            redis_suitability_table = "suitability"
            redis_data = {
                "update": {},
                "delete": {}
            }
            # delete location from redis
            for id in ids:
                redis_data["delete"].setdefault(redis_location_table, []).append(id)
            # update suitability table location_id column in redis
            for val in suitability_with_location:
                redis_data["update"].setdefault(redis_suitability_table, []).append({
                    "id": val['id'],
                    "location_id": val['location_ids'],
                })
            if avoid_concurrency_ids:
                location_avoid_concurrency = TtLocation.objects.filter(id__in=avoid_concurrency_ids).prefetch_related("avoid_concurrency")
                if location_avoid_concurrency:
                    for val in location_avoid_concurrency:
                        current_concurrency_ids = [ac.id for ac in val.avoid_concurrency.all()]
                        redis_location_update_data = {
                            "id": val.id,
                            "avoid_concurrency": current_concurrency_ids
                        }
                        redis_data["update"].setdefault(redis_location_table, []).append(redis_location_update_data)
            bulk_sync_to_redis(redis_client,redis_data)

            #kafka
            method = "location_delete"
            kafka_topic = self.kafka_config['MICROSERVICES_TT_TOPIC']
            if kafka_topic:
                kafka_request_data = {
                    "session_id": request.user.name,
                    "location_ids": ids
                }
                send_request(kafka_topic, kafka_request_data, None, method)


            audit_trail = AuditTrail.objects.create(
                user_id=request.user.id,
                type=self.audit_type,
                ip_address=get_ip(request)
            )
            remark_param = {
                "name": location_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)