from django.db.models import Q
from ishtar_common.serializers_utils import generic_get_results, \
    archive_serialization
from archaeological_warehouse import models


WAREHOUSE_MODEL_LIST = [
    models.Warehouse, models.Container,
    models.WarehouseDivisionLink,
    models.ContainerLocalisation
]

# TODO: associated documents


def generate_warehouse_queryset(base_query_key, ids):
    container_ids, warehouse_ids = set(), set()
    warehouse_div_ids, container_loca_ids = set(), set()

    for find_key in ("finds", "finds_ref"):
        base_key = "{}__{}".format(find_key, base_query_key)
        q = Q(**{base_key: ids})
        container_ids.update(
            list(models.Container.objects.filter(
                q).values_list("id", flat=True)))
        q_loca = Q(
            **{"container__{}__{}".format(find_key, base_query_key): ids})
        container_loca_ids.update(
            list(models.ContainerLocalisation.objects.filter(
                q_loca).values_list("id", flat=True)))
        for container_key in ("containers", "owned_containers"):
            q = Q(**
                  {"{}__{}__{}".format(container_key, find_key,
                                       base_query_key): ids})
            q_div = Q(**
                      {"warehouse__{}__{}__{}".format(
                          container_key, find_key, base_query_key): ids})
            warehouse_ids.update(
                list(models.Warehouse.objects.filter(q).values_list(
                    "id", flat=True)))
            warehouse_div_ids.update(
                list(models.WarehouseDivisionLink.objects.filter(
                    q_div).values_list("id", flat=True)))
    result_queryset = {
        models.Warehouse.__name__:
            models.Warehouse.objects.filter(id__in=warehouse_ids),
        models.Container.__name__:
            models.Container.objects.filter(id__in=container_ids),
        models.WarehouseDivisionLink.__name__:
            models.WarehouseDivisionLink.objects.filter(
                id__in=warehouse_div_ids),
        models.ContainerLocalisation.__name__:
            models.ContainerLocalisation.objects.filter(
                id__in=container_loca_ids)
    }
    return result_queryset


def warehouse_serialization(archive=False, return_empty_types=False,
                            archive_name=None, operation_queryset=None,
                            site_queryset=None, cr_queryset=None,
                            find_queryset=None, warehouse_queryset=None,
                            get_queryset=False, no_geo=True,
                            put_locks=False, lock_user=None):
    result_queryset = {}
    if operation_queryset:
        operation_ids = operation_queryset.values_list("id", flat=True)
        base_query_key = "base_finds__context_record__operation_id__in"
        result_queryset = generate_warehouse_queryset(base_query_key,
                                                      operation_ids)
    elif site_queryset:
        site_ids = site_queryset.values_list("id", flat=True)
        base_query_key = "base_finds__context_record__"\
                         "operation__archaeological_sites__id__in"
        result_queryset = generate_warehouse_queryset(base_query_key, site_ids)
    elif cr_queryset:
        cr_ids = cr_queryset.values_list("id", flat=True)
        base_query_key = "base_finds__context_record__id__in"
        result_queryset = generate_warehouse_queryset(base_query_key, cr_ids)
    elif find_queryset:
        find_ids = find_queryset.values_list("id", flat=True)
        base_query_key = "id__in"
        result_queryset = generate_warehouse_queryset(base_query_key, find_ids)
    elif warehouse_queryset:
        warehouse_ids = warehouse_queryset.values_list("id", flat=True)
        result_queryset = {
            models.Warehouse.__name__: warehouse_queryset,
            models.Container.__name__:
                models.Container.objects.filter(
                    Q(location__id__in=warehouse_ids) |
                    Q(responsible__id__in=warehouse_ids)
                ),
            models.WarehouseDivisionLink.__name__:
                models.WarehouseDivisionLink.objects.filter(
                    warehouse_id__in=warehouse_ids),
            models.ContainerLocalisation.__name__:
                models.ContainerLocalisation.objects.filter(
                    division__warehouse_id__in=warehouse_ids)
        }
    if get_queryset:
        return result_queryset
    result = generic_get_results(WAREHOUSE_MODEL_LIST, "warehouse",
                                 result_queryset=result_queryset, no_geo=no_geo)
    if put_locks:
        for model in WAREHOUSE_MODEL_LIST:
            if not hasattr(model, "locked"):
                continue
            q = model.objects
            if result_queryset and model.__name__ in result_queryset:
                q = result_queryset[model.__name__]
            q.update(locked=True, lock_user=lock_user)

    full_archive = archive_serialization(
        result, archive_dir="warehouse", archive=archive,
        return_empty_types=return_empty_types, archive_name=archive_name,
    )
    return full_archive