<reponame>centrologic/django-codenerix-geodata
# -*- coding: utf-8 -*-
#
# django-codenerix-geodata
#
# Copyright 2017 Centrologic Computational Logistic Center S.L.
#
# Project URL : http://www.codenerix.com
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

import ast
import operator
from functools import reduce

from django.db.models import Q
from django.conf import settings

from django.utils.translation import ugettext as _

from codenerix.multiforms import MultiForm
from codenerix.views import GenList, GenCreate, GenCreateModal, GenUpdate, GenUpdateModal, GenDelete, GenForeignKey

from .models import Continent, Country, Region, Province, TimeZone, City, MODELS
from .forms import ContinentForm, CountryForm, RegionForm, ProvinceForm, TimeZoneForm, CityForm


# forms for multiforms
formsfull = {}

for info in MODELS:
    field = info[0]
    model = info[1]
    formsfull[model] = [(None, None, None)]
    for lang_code in settings.LANGUAGES_DATABASES:
        query = 'from .models import {}GeoName{}\n'.format(model, lang_code)
        query += 'from .forms import {}TextForm{}'.format(model, lang_code)
        exec(query)

        formsfull[model].append((eval('{}TextForm{}'.format(model, lang_code.upper())), field, None))


class TranslatedMixin(object):

    @property
    def lang(self):
        if hasattr(self, 'request'):
            for x in settings.LANGUAGES:
                if x[0] == self.request.LANGUAGE_CODE:
                    return self.request.LANGUAGE_CODE.lower()
        return settings.LANGUAGES[0][0].lower()


# ###########################################
# Continent
class GenContinentUrl(object):
    ws_entry_point = '{}/continents'.format(settings.CDNX_GEODATA_URL)


class ContinentList(TranslatedMixin, GenContinentUrl, GenList):
    model = Continent
    linkadd = False
    show_details = False
    public = True

    def __fields__(self, info):
        fields = self.model().__fields__(info)
        fields.append(
            ('{}__name'.format(self.lang), _('Name')),
        )
        return fields

    def __searchQ__(self, info, text):
        filters = self.model().__searchQ__(info, text)
        filters['name'] = Q(**{"{}__name__icontains".format(self.lang): text})
        return filters

    def __searchF__(self, info):
        def f(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        filters = self.model().__searchF__(info)
        filters['{}__name'.format(self.lang)] = (_('Name'), f, 'input')
        return filters

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['{}__name'.format(self.lang)]
        return super(ContinentList, self).dispatch(request, *args, **kwargs)


class ContinentCreate(GenContinentUrl, MultiForm, GenCreate):
    model = Continent
    form_class = ContinentForm
    forms = formsfull['Continent']


class ContinentCreateModal(GenCreateModal, ContinentCreate):
    pass


class ContinentUpdate(GenContinentUrl, MultiForm, GenUpdate):
    model = Continent
    form_class = ContinentForm
    forms = formsfull['Continent']


class ContinentUpdateModal(GenUpdateModal, ContinentUpdate):
    pass


class ContinentDelete(GenContinentUrl, GenDelete):
    model = Continent


# ###########################################
# Country
class GenCountryUrl(object):
    ws_entry_point = '{}/countries'.format(settings.CDNX_GEODATA_URL)


class CountryList(TranslatedMixin, GenCountryUrl, GenList):
    model = Country
    linkadd = False
    show_details = False
    public = True

    def __limitQ__(self, info):
        result = {}
        try:
            params = ast.literal_eval(info.request.GET.get('json'))
        except ValueError:
            params = {}

        continent = int(params.get('continent', 0))

        if continent:
            result['continent_limit'] = Q(continent__pk=continent)
        return result

    def __fields__(self, info):
        return [
            ('code', _('Code')),
            ('{}__name'.format(self.lang), _('Name')),
            ('continent__code', _('Code continent')),
            ('continent__{}__name'.format(self.lang), _('Name continent')),
        ]

    def __searchQ__(self, info, text):
        filters = self.model().__searchQ__(info, text)
        filters['name'] = Q(**{"{}__name__icontains".format(self.lang): text})
        filters['continent_code'] = Q(**{"continent__code": text})
        filters['continent_name'] = Q(**{"continent__{}__name__icontains".format(self.lang): text})
        return filters

    def __searchF__(self, info):
        def f(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fc(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"continent__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        filters = self.model().__searchF__(info)
        filters['{}__name'.format(self.lang)] = (_('Name'), f, 'input')
        filters['continent__code'] = (_('Code continent'), lambda x: Q(continent__code__icontains=x), 'input')
        filters['continent__{}__name'.format(self.lang)] = (_('Continent name'), fc, 'input')
        return filters

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['{}__name'.format(self.lang)]
        return super(CountryList, self).dispatch(request, *args, **kwargs)


class CountryCreate(GenCountryUrl, MultiForm, GenCreate):
    model = Country
    form_class = CountryForm
    forms = formsfull['Country']


class CountryCreateModal(GenCreateModal, CountryCreate):
    pass


class CountryUpdate(GenCountryUrl, MultiForm, GenUpdate):
    model = Country
    form_class = CountryForm
    forms = formsfull['Country']


class CountryUpdateModal(GenUpdateModal, CountryUpdate):
    pass


class CountryDelete(GenCountryUrl, GenDelete):
    model = Country


class CountryForeign(TranslatedMixin, GenCountryUrl, GenForeignKey):
    model = Country
    label = "{<LANGUAGE_CODE>__name}"
    public = True

    def get_foreign(self, queryset, search, filters):
        # Filter with search string
        qsobject = Q(code__istartswith=search)

        for lang in settings.LANGUAGES_DATABASES:
            qsobject |= Q(**{"{}__name__istartswith".format(lang.lower()): search})
        qs = queryset.filter(qsobject).order_by("{}__name".format(self.lang))
        return qs[:settings.LIMIT_FOREIGNKEY]


# ###########################################
# Regions
class GenRegionUrl(object):
    ws_entry_point = '{}/regions'.format(settings.CDNX_GEODATA_URL)


class RegionList(TranslatedMixin, GenRegionUrl, GenList):
    model = Region
    linkadd = False
    show_details = False
    public = True

    def __limitQ__(self, info):
        result = {}
        try:
            params = ast.literal_eval(info.request.GET.get('json'))
        except ValueError:
            params = {}

        continent = int(params.get('continent', 0))
        country = int(params.get('country', 0))

        if continent:
            result['continent_limit'] = Q(country__continent__pk=continent)
        if country:
            result['country_limit'] = Q(country__pk=country)
        return result

    def __fields__(self, info):
        return [
            ('code', _('Code')),
            ('{}__name'.format(self.lang), _('Name')),
            ('country__code', _('Code country')),
            ('country__{}__name'.format(self.lang), _('Name country')),
            ('country__continent__code', _('Code continent')),
            ('country__continent__{}__name'.format(self.lang), _('Name continent')),
        ]

    def __searchQ__(self, info, text):
        filters = self.model().__searchQ__(info, text)
        filters['name'] = Q(**{"{}__name__icontains".format(self.lang): text})
        filters['country_code'] = Q(**{'country__code': text})
        filters['country_name'] = Q(**{'country__{}__name__icontains'.format(self.lang): text})
        filters['continent_code'] = Q(**{"country__continent__code": text})
        filters['continent_name'] = Q(**{"country__continent__{}__name__icontains".format(self.lang): text})
        return filters

    def __searchF__(self, info):
        def f(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fco(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"country__continent__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fcu(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"country__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        filters = self.model().__searchF__(info)
        filters['{}__name'.format(self.lang)] = (_('Name'), f, 'input')

        filters['country__code'] = (_('Code self'), lambda x: Q(country__code__icontains=x), 'input')
        filters['country__{}__name'.format(self.lang)] = (_('Name country'), fcu, 'input')

        filters['country__continent__code'] = (_('Code continent'), lambda x: Q(country__continent__code__icontains=x), 'input')
        filters['country__continent__{}__name'.format(self.lang)] = (_('Name continent'), fco, 'input')
        return filters

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['{}__name'.format(self.lang)]
        return super(RegionList, self).dispatch(request, *args, **kwargs)


class RegionCreate(GenRegionUrl, MultiForm, GenCreate):
    model = Region
    form_class = RegionForm
    forms = formsfull['Region']


class RegionCreateModal(GenCreateModal, RegionCreate):
    pass


class RegionUpdate(GenRegionUrl, MultiForm, GenUpdate):
    model = Region
    form_class = RegionForm
    forms = formsfull['Region']


class RegionUpdateModal(GenUpdateModal, RegionUpdate):
    pass


class RegionDelete(GenRegionUrl, GenDelete):
    model = Region


class RegionForeign(TranslatedMixin, GenRegionUrl, GenForeignKey):
    model = Region
    label = "{<LANGUAGE_CODE>__name}"
    public = True

    def get_foreign(self, queryset, search, filters):
        # Filter with search string
        qsobject = Q(code__istartswith=search)

        for lang in settings.LANGUAGES_DATABASES:
            qsobject |= Q(**{"{}__name__istartswith".format(lang.lower()): search})
        qs = queryset.filter(qsobject)

        country = filters.get('country', None)
        if country:
            qs = qs.filter(country__pk=country)
        qs = qs.order_by("{}__name".format(self.lang))
        return qs[:settings.LIMIT_FOREIGNKEY]


# ###########################################
# Provinces
class GenProvinceUrl(object):
    ws_entry_point = '{}/provinces'.format(settings.CDNX_GEODATA_URL)


class ProvinceList(TranslatedMixin, GenProvinceUrl, GenList):
    model = Province
    linkadd = False
    show_details = False
    public = True

    def __limitQ__(self, info):
        result = {}
        try:
            params = ast.literal_eval(info.request.GET.get('json'))
        except ValueError:
            params = {}

        continent = int(params.get('continent', 0))
        country = int(params.get('country', 0))
        region = int(params.get('region', 0))

        if continent:
            result['continent_limit'] = Q(region__country__continent__pk=continent)
        if country:
            result['country_limit'] = Q(region__country__pk=country)
        if region:
            result['region_limit'] = Q(region__pk=region)
        return result

    def __fields__(self, info):
        return [
            ('code', _('Code')),
            ('{}__name'.format(self.lang), _('Name')),
            ('region__code', _('Code region')),
            ('region__{}__name'.format(self.lang), _('Name region')),
            ('region__country__code', _('Code country')),
            ('region__country__{}__name'.format(self.lang), _('Name country')),
            ('region__country__continent__code', _('Code continent')),
            ('region__country__continent__{}__name'.format(self.lang), _('Name continent')),
        ]

    def __searchQ__(self, info, text):
        filters = self.model().__searchQ__(info, text)
        filters['name'] = Q(**{"{}__name__icontains".format(self.lang): text})
        filters['region_code'] = Q(**{'region__code': text})
        filters['region_name'] = Q(**{'region__{}__name__icontains'.format(self.lang): text})
        filters['country_code'] = Q(**{'region__country__code': text})
        filters['country_name'] = Q(**{'region__country__{}__name__icontains'.format(self.lang): text})
        filters['continent_code'] = Q(**{"region__country__continent__code": text})
        filters['continent_name'] = Q(**{"region__country__continent__{}__name__icontains".format(self.lang): text})
        return filters

    def __searchF__(self, info):
        def f(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fr(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"region__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fco(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"region__country__continent__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fcu(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"region__country__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        filters = self.model().__searchF__(info)
        filters['{}__name'.format(self.lang)] = (_('Name'), f, 'input')

        filters['region__code'] = (_('Code self'), lambda x: Q(region__code__icontains=x), 'input')
        filters['region__{}__name'.format(self.lang)] = (_('Name region'), fr, 'input')

        filters['region__country__code'] = (_('Code self'), lambda x: Q(region__country__code__icontains=x), 'input')
        filters['region__country__{}__name'.format(self.lang)] = (_('Name country'), fcu, 'input')

        filters['region__country__continent__code'] = (_('Code continent'), lambda x: Q(region__country__continent__code__icontains=x), 'input')
        filters['region__country__continent__{}__name'.format(self.lang)] = (_('Name continent'), fco, 'input')
        return filters

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['{}__name'.format(self.lang)]
        return super(ProvinceList, self).dispatch(request, *args, **kwargs)


class ProvinceCreate(GenProvinceUrl, MultiForm, GenCreate):
    model = Province
    form_class = ProvinceForm
    forms = formsfull['Province']


class ProvinceCreateModal(GenCreateModal, ProvinceCreate):
    pass


class ProvinceUpdate(GenProvinceUrl, MultiForm, GenUpdate):
    model = Province
    form_class = ProvinceForm
    forms = formsfull['Province']


class ProvinceUpdateModal(GenUpdateModal, ProvinceUpdate):
    pass


class ProvinceDelete(GenProvinceUrl, GenDelete):
    model = Province


class ProvinceForeign(TranslatedMixin, GenProvinceUrl, GenForeignKey):
    model = Province
    label = "{<LANGUAGE_CODE>__name}"
    public = True

    def get_foreign(self, queryset, search, filters):
        # Filter with search string
        qsobject = Q(code__istartswith=search)

        for lang in settings.LANGUAGES_DATABASES:
            qsobject |= Q(**{"{}__name__istartswith".format(lang.lower()): search})
        qs = queryset.filter(qsobject)

        region = filters.get('region', None)
        if region:
            qs = qs.filter(region__pk=region)
        qs = qs.order_by("{}__name".format(self.lang))
        return qs[:settings.LIMIT_FOREIGNKEY]


# ###########################################
# TimeZone
class GenTimeZoneUrl(object):
    ws_entry_point = '{}/timezones'.format(settings.CDNX_GEODATA_URL)


class TimeZoneList(GenTimeZoneUrl, GenList):
    model = TimeZone
    linkadd = False
    show_details = False
    public = True

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['name']
        return super(TimeZoneList, self).dispatch(request, *args, **kwargs)


class TimeZoneCreate(GenTimeZoneUrl, GenCreate):
    model = TimeZone
    form_class = TimeZoneForm


class TimeZoneCreateModal(GenCreateModal, TimeZoneCreate):
    pass


class TimeZoneUpdate(GenTimeZoneUrl, GenUpdate):
    model = TimeZone
    form_class = TimeZoneForm


class TimeZoneUpdateModal(GenUpdateModal, TimeZoneUpdate):
    pass


class TimeZoneDelete(GenTimeZoneUrl, GenDelete):
    model = TimeZone


# ###########################################
# City
class GenCityUrl(object):
    ws_entry_point = '{}/cities'.format(settings.CDNX_GEODATA_URL)


class CityList(TranslatedMixin, GenCityUrl, GenList):
    model = City
    linkadd = False
    show_details = False
    public = True

    def __limitQ__(self, info):
        result = {}
        try:
            params = ast.literal_eval(info.request.GET.get('json'))
        except ValueError:
            params = {}

        continent = int(params.get('continent', 0))
        country = int(params.get('country', 0))
        region = int(params.get('region', 0))
        province = int(params.get('province', 0))
        time_zone = int(params.get('time_zone', 0))

        if continent:
            result['continent_limit'] = Q(region__country__continent__pk=continent)
        if country:
            result['country_limit'] = Q(country__pk=country)
        if region:
            result['region_limit'] = Q(region__pk=region)
        if province:
            result['province_limit'] = Q(province__pk=province)
        if time_zone:
            result['time_zone_limit'] = Q(time_zone__pk=time_zone)

        # result['country'] = Q(**{"country__{}__name__icontains".format(self.lang): u'españa'})
        # result['country'] = Q(**{"country__es__name__icontains".format(self.lang): u'españa'})
        return result

    def __fields__(self, info):
        return [
            ('{}__name'.format(self.lang), _('Name')),
            ('time_zone', _('Time Zone')),
            ('province__code'.format(self.lang), _('Code province')),
            ('province__{}__name'.format(self.lang), _('Province')),
            ('country__code'.format(self.lang), _('Code country')),
            ('country__{}__name'.format(self.lang), _('Country')),
            ('country__continent__code', _('Code continent')),
            ('country__continent__{}__name'.format(self.lang), _('Name continent')),
        ]

    def __searchQ__(self, info, text):
        filters = self.model().__searchQ__(info, text)
        filters['name'] = Q(**{"{}__name__icontains".format(self.lang): text})
        filters['province_code'] = Q(**{'province__code': text})
        filters['province_name'] = Q(**{'province__{}__name__icontains'.format(self.lang): text})
        filters['country_code'] = Q(**{'country__code': text})
        filters['country_name'] = Q(**{'country__{}__name__icontains'.format(self.lang): text})
        filters['continent_code'] = Q(**{"country__continent__code": text})
        filters['continent_name'] = Q(**{"country__continent__{}__name__icontains".format(self.lang): text})
        return filters

    def __searchF__(self, info):
        def f(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fp(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"province__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fco(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"country__continent__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fcu(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"country__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        filters = self.model().__searchF__(info)
        filters['{}__name'.format(self.lang)] = (_('Name'), f, 'input')

        filters['province__code'] = (_('Code self'), lambda x: Q(province__code__icontains=x), 'input')
        filters['province__{}__name'.format(self.lang)] = (_('Name region'), fp, 'input')

        filters['country__code'] = (_('Code self'), lambda x: Q(country__code__icontains=x), 'input')
        filters['country__{}__name'.format(self.lang)] = (_('Name country'), fcu, 'input')

        filters['country__continent__code'] = (_('Code continent'), lambda x: Q(country__continent__code__icontains=x), 'input')
        filters['country__continent__{}__name'.format(self.lang)] = (_('Name continent'), fco, 'input')
        return filters

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['{}__name'.format(self.lang)]
        return super(CityList, self).dispatch(request, *args, **kwargs)


class CityCreate(GenCityUrl, MultiForm, GenCreate):
    model = City
    form_class = CityForm
    forms = formsfull['City']


class CityCreateModal(GenCreateModal, CityCreate):
    pass


class CityUpdate(GenCityUrl, MultiForm, GenUpdate):
    model = City
    form_class = CityForm
    forms = formsfull['City']


class CityUpdateModal(GenUpdateModal, CityUpdate):
    pass


class CityDelete(GenCityUrl, GenDelete):
    model = City


class CityForeign(TranslatedMixin, GenCityUrl, GenForeignKey):
    model = City
    label = "{<LANGUAGE_CODE>__name}"
    public = True
    
    def get_foreign(self, queryset, search, filters):
        # Filter with search string
        qsobject = []
        for lang in settings.LANGUAGES_DATABASES:
            qsobject.append(Q(**{"{}__name__istartswith".format(lang.lower()): search}))
        qs = queryset.filter(
            reduce(operator.or_, qsobject)
        )
        # qs = queryset.filter(qsobject)

        country = filters.get('country', None)
        if country:
            qs = qs.filter(country__pk=country)

        province = filters.get('province', None)
        if province:
            qs = qs.filter(province__pk=province)

        region = filters.get('region', None)
        if region:
            qs = qs.filter(region__pk=region)
        qs = qs.order_by("{}__name".format(self.lang))
        return qs[:settings.LIMIT_FOREIGNKEY]

# -*- coding: utf-8 -*-
#
# django-codenerix-geodata
#
# Copyright 2017 Centrologic Computational Logistic Center S.L.
#
# Project URL : http://www.codenerix.com
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

import ast
import operator
from functools import reduce

from django.db.models import Q
from django.conf import settings

from django.utils.translation import ugettext as _

from codenerix.multiforms import MultiForm
from codenerix.views import GenList, GenCreate, GenCreateModal, GenUpdate, GenUpdateModal, GenDelete, GenForeignKey

from .models import Continent, Country, Region, Province, TimeZone, City, MODELS
from .forms import ContinentForm, CountryForm, RegionForm, ProvinceForm, TimeZoneForm, CityForm


# forms for multiforms
formsfull = {}

for info in MODELS:
    field = info[0]
    model = info[1]
    formsfull[model] = [(None, None, None)]
    for lang_code in settings.LANGUAGES_DATABASES:
        query = 'from .models import {}GeoName{}\n'.format(model, lang_code)
        query += 'from .forms import {}TextForm{}'.format(model, lang_code)
        exec(query)

        formsfull[model].append((eval('{}TextForm{}'.format(model, lang_code.upper())), field, None))


class TranslatedMixin(object):

    @property
    def lang(self):
        if hasattr(self, 'request'):
            for x in settings.LANGUAGES:
                if x[0] == self.request.LANGUAGE_CODE:
                    return self.request.LANGUAGE_CODE.lower()
        return settings.LANGUAGES[0][0].lower()


# ###########################################
# Continent
class GenContinentUrl(object):
    ws_entry_point = '{}/continents'.format(settings.CDNX_GEODATA_URL)


class ContinentList(TranslatedMixin, GenContinentUrl, GenList):
    model = Continent
    linkadd = False
    show_details = False
    public = True

    def __fields__(self, info):
        fields = self.model().__fields__(info)
        fields.append(
            ('{}__name'.format(self.lang), _('Name')),
        )
        return fields

    def __searchQ__(self, info, text):
        filters = self.model().__searchQ__(info, text)
        filters['name'] = Q(**{"{}__name__icontains".format(self.lang): text})
        return filters

    def __searchF__(self, info):
        def f(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        filters = self.model().__searchF__(info)
        filters['{}__name'.format(self.lang)] = (_('Name'), f, 'input')
        return filters

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['{}__name'.format(self.lang)]
        return super(ContinentList, self).dispatch(request, *args, **kwargs)


class ContinentCreate(GenContinentUrl, MultiForm, GenCreate):
    model = Continent
    form_class = ContinentForm
    forms = formsfull['Continent']


class ContinentCreateModal(GenCreateModal, ContinentCreate):
    pass


class ContinentUpdate(GenContinentUrl, MultiForm, GenUpdate):
    model = Continent
    form_class = ContinentForm
    forms = formsfull['Continent']


class ContinentUpdateModal(GenUpdateModal, ContinentUpdate):
    pass


class ContinentDelete(GenContinentUrl, GenDelete):
    model = Continent


# ###########################################
# Country
class GenCountryUrl(object):
    ws_entry_point = '{}/countries'.format(settings.CDNX_GEODATA_URL)


class CountryList(TranslatedMixin, GenCountryUrl, GenList):
    model = Country
    linkadd = False
    show_details = False
    public = True

    def __limitQ__(self, info):
        result = {}
        try:
            params = ast.literal_eval(info.request.GET.get('json'))
        except ValueError:
            params = {}

        continent = int(params.get('continent', 0))

        if continent:
            result['continent_limit'] = Q(continent__pk=continent)
        return result

    def __fields__(self, info):
        return [
            ('code', _('Code')),
            ('{}__name'.format(self.lang), _('Name')),
            ('continent__code', _('Code continent')),
            ('continent__{}__name'.format(self.lang), _('Name continent')),
        ]

    def __searchQ__(self, info, text):
        filters = self.model().__searchQ__(info, text)
        filters['name'] = Q(**{"{}__name__icontains".format(self.lang): text})
        filters['continent_code'] = Q(**{"continent__code": text})
        filters['continent_name'] = Q(**{"continent__{}__name__icontains".format(self.lang): text})
        return filters

    def __searchF__(self, info):
        def f(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fc(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"continent__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        filters = self.model().__searchF__(info)
        filters['{}__name'.format(self.lang)] = (_('Name'), f, 'input')
        filters['continent__code'] = (_('Code continent'), lambda x: Q(continent__code__icontains=x), 'input')
        filters['continent__{}__name'.format(self.lang)] = (_('Continent name'), fc, 'input')
        return filters

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['{}__name'.format(self.lang)]
        return super(CountryList, self).dispatch(request, *args, **kwargs)


class CountryCreate(GenCountryUrl, MultiForm, GenCreate):
    model = Country
    form_class = CountryForm
    forms = formsfull['Country']


class CountryCreateModal(GenCreateModal, CountryCreate):
    pass


class CountryUpdate(GenCountryUrl, MultiForm, GenUpdate):
    model = Country
    form_class = CountryForm
    forms = formsfull['Country']


class CountryUpdateModal(GenUpdateModal, CountryUpdate):
    pass


class CountryDelete(GenCountryUrl, GenDelete):
    model = Country


class CountryForeign(TranslatedMixin, GenCountryUrl, GenForeignKey):
    model = Country
    label = "{<LANGUAGE_CODE>__name}"
    public = True

    def get_foreign(self, queryset, search, filters):
        # Filter with search string
        qsobject = Q(code__istartswith=search)

        for lang in settings.LANGUAGES_DATABASES:
            qsobject |= Q(**{"{}__name__istartswith".format(lang.lower()): search})
        qs = queryset.filter(qsobject).order_by("{}__name".format(self.lang))
        return qs[:settings.LIMIT_FOREIGNKEY]


# ###########################################
# Regions
class GenRegionUrl(object):
    ws_entry_point = '{}/regions'.format(settings.CDNX_GEODATA_URL)


class RegionList(TranslatedMixin, GenRegionUrl, GenList):
    model = Region
    linkadd = False
    show_details = False
    public = True

    def __limitQ__(self, info):
        result = {}
        try:
            params = ast.literal_eval(info.request.GET.get('json'))
        except ValueError:
            params = {}

        continent = int(params.get('continent', 0))
        country = int(params.get('country', 0))

        if continent:
            result['continent_limit'] = Q(country__continent__pk=continent)
        if country:
            result['country_limit'] = Q(country__pk=country)
        return result

    def __fields__(self, info):
        return [
            ('code', _('Code')),
            ('{}__name'.format(self.lang), _('Name')),
            ('country__code', _('Code country')),
            ('country__{}__name'.format(self.lang), _('Name country')),
            ('country__continent__code', _('Code continent')),
            ('country__continent__{}__name'.format(self.lang), _('Name continent')),
        ]

    def __searchQ__(self, info, text):
        filters = self.model().__searchQ__(info, text)
        filters['name'] = Q(**{"{}__name__icontains".format(self.lang): text})
        filters['country_code'] = Q(**{'country__code': text})
        filters['country_name'] = Q(**{'country__{}__name__icontains'.format(self.lang): text})
        filters['continent_code'] = Q(**{"country__continent__code": text})
        filters['continent_name'] = Q(**{"country__continent__{}__name__icontains".format(self.lang): text})
        return filters

    def __searchF__(self, info):
        def f(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fco(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"country__continent__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fcu(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"country__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        filters = self.model().__searchF__(info)
        filters['{}__name'.format(self.lang)] = (_('Name'), f, 'input')

        filters['country__code'] = (_('Code self'), lambda x: Q(country__code__icontains=x), 'input')
        filters['country__{}__name'.format(self.lang)] = (_('Name country'), fcu, 'input')

        filters['country__continent__code'] = (_('Code continent'), lambda x: Q(country__continent__code__icontains=x), 'input')
        filters['country__continent__{}__name'.format(self.lang)] = (_('Name continent'), fco, 'input')
        return filters

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['{}__name'.format(self.lang)]
        return super(RegionList, self).dispatch(request, *args, **kwargs)


class RegionCreate(GenRegionUrl, MultiForm, GenCreate):
    model = Region
    form_class = RegionForm
    forms = formsfull['Region']


class RegionCreateModal(GenCreateModal, RegionCreate):
    pass


class RegionUpdate(GenRegionUrl, MultiForm, GenUpdate):
    model = Region
    form_class = RegionForm
    forms = formsfull['Region']


class RegionUpdateModal(GenUpdateModal, RegionUpdate):
    pass


class RegionDelete(GenRegionUrl, GenDelete):
    model = Region


class RegionForeign(TranslatedMixin, GenRegionUrl, GenForeignKey):
    model = Region
    label = "{<LANGUAGE_CODE>__name}"
    public = True

    def get_foreign(self, queryset, search, filters):
        # Filter with search string
        qsobject = Q(code__istartswith=search)

        for lang in settings.LANGUAGES_DATABASES:
            qsobject |= Q(**{"{}__name__istartswith".format(lang.lower()): search})
        qs = queryset.filter(qsobject)

        country = filters.get('country', None)
        if country:
            qs = qs.filter(country__pk=country)
        qs = qs.order_by("{}__name".format(self.lang))
        return qs[:settings.LIMIT_FOREIGNKEY]


# ###########################################
# Provinces
class GenProvinceUrl(object):
    ws_entry_point = '{}/provinces'.format(settings.CDNX_GEODATA_URL)


class ProvinceList(TranslatedMixin, GenProvinceUrl, GenList):
    model = Province
    linkadd = False
    show_details = False
    public = True

    def __limitQ__(self, info):
        result = {}
        try:
            params = ast.literal_eval(info.request.GET.get('json'))
        except ValueError:
            params = {}

        continent = int(params.get('continent', 0))
        country = int(params.get('country', 0))
        region = int(params.get('region', 0))

        if continent:
            result['continent_limit'] = Q(region__country__continent__pk=continent)
        if country:
            result['country_limit'] = Q(region__country__pk=country)
        if region:
            result['region_limit'] = Q(region__pk=region)
        return result

    def __fields__(self, info):
        return [
            ('code', _('Code')),
            ('{}__name'.format(self.lang), _('Name')),
            ('region__code', _('Code region')),
            ('region__{}__name'.format(self.lang), _('Name region')),
            ('region__country__code', _('Code country')),
            ('region__country__{}__name'.format(self.lang), _('Name country')),
            ('region__country__continent__code', _('Code continent')),
            ('region__country__continent__{}__name'.format(self.lang), _('Name continent')),
        ]

    def __searchQ__(self, info, text):
        filters = self.model().__searchQ__(info, text)
        filters['name'] = Q(**{"{}__name__icontains".format(self.lang): text})
        filters['region_code'] = Q(**{'region__code': text})
        filters['region_name'] = Q(**{'region__{}__name__icontains'.format(self.lang): text})
        filters['country_code'] = Q(**{'region__country__code': text})
        filters['country_name'] = Q(**{'region__country__{}__name__icontains'.format(self.lang): text})
        filters['continent_code'] = Q(**{"region__country__continent__code": text})
        filters['continent_name'] = Q(**{"region__country__continent__{}__name__icontains".format(self.lang): text})
        return filters

    def __searchF__(self, info):
        def f(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fr(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"region__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fco(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"region__country__continent__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fcu(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"region__country__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        filters = self.model().__searchF__(info)
        filters['{}__name'.format(self.lang)] = (_('Name'), f, 'input')

        filters['region__code'] = (_('Code self'), lambda x: Q(region__code__icontains=x), 'input')
        filters['region__{}__name'.format(self.lang)] = (_('Name region'), fr, 'input')

        filters['region__country__code'] = (_('Code self'), lambda x: Q(region__country__code__icontains=x), 'input')
        filters['region__country__{}__name'.format(self.lang)] = (_('Name country'), fcu, 'input')

        filters['region__country__continent__code'] = (_('Code continent'), lambda x: Q(region__country__continent__code__icontains=x), 'input')
        filters['region__country__continent__{}__name'.format(self.lang)] = (_('Name continent'), fco, 'input')
        return filters

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['{}__name'.format(self.lang)]
        return super(ProvinceList, self).dispatch(request, *args, **kwargs)


class ProvinceCreate(GenProvinceUrl, MultiForm, GenCreate):
    model = Province
    form_class = ProvinceForm
    forms = formsfull['Province']


class ProvinceCreateModal(GenCreateModal, ProvinceCreate):
    pass


class ProvinceUpdate(GenProvinceUrl, MultiForm, GenUpdate):
    model = Province
    form_class = ProvinceForm
    forms = formsfull['Province']


class ProvinceUpdateModal(GenUpdateModal, ProvinceUpdate):
    pass


class ProvinceDelete(GenProvinceUrl, GenDelete):
    model = Province


class ProvinceForeign(TranslatedMixin, GenProvinceUrl, GenForeignKey):
    model = Province
    label = "{<LANGUAGE_CODE>__name}"
    public = True

    def get_foreign(self, queryset, search, filters):
        # Filter with search string
        qsobject = Q(code__istartswith=search)

        for lang in settings.LANGUAGES_DATABASES:
            qsobject |= Q(**{"{}__name__istartswith".format(lang.lower()): search})
        qs = queryset.filter(qsobject)

        region = filters.get('region', None)
        if region:
            qs = qs.filter(region__pk=region)
        qs = qs.order_by("{}__name".format(self.lang))
        return qs[:settings.LIMIT_FOREIGNKEY]


# ###########################################
# TimeZone
class GenTimeZoneUrl(object):
    ws_entry_point = '{}/timezones'.format(settings.CDNX_GEODATA_URL)


class TimeZoneList(GenTimeZoneUrl, GenList):
    model = TimeZone
    linkadd = False
    show_details = False
    public = True

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['name']
        return super(TimeZoneList, self).dispatch(request, *args, **kwargs)


class TimeZoneCreate(GenTimeZoneUrl, GenCreate):
    model = TimeZone
    form_class = TimeZoneForm


class TimeZoneCreateModal(GenCreateModal, TimeZoneCreate):
    pass


class TimeZoneUpdate(GenTimeZoneUrl, GenUpdate):
    model = TimeZone
    form_class = TimeZoneForm


class TimeZoneUpdateModal(GenUpdateModal, TimeZoneUpdate):
    pass


class TimeZoneDelete(GenTimeZoneUrl, GenDelete):
    model = TimeZone


# ###########################################
# City
class GenCityUrl(object):
    ws_entry_point = '{}/cities'.format(settings.CDNX_GEODATA_URL)


class CityList(TranslatedMixin, GenCityUrl, GenList):
    model = City
    linkadd = False
    show_details = False
    public = True

    def __limitQ__(self, info):
        result = {}
        try:
            params = ast.literal_eval(info.request.GET.get('json'))
        except ValueError:
            params = {}

        continent = int(params.get('continent', 0))
        country = int(params.get('country', 0))
        region = int(params.get('region', 0))
        province = int(params.get('province', 0))
        time_zone = int(params.get('time_zone', 0))

        if continent:
            result['continent_limit'] = Q(region__country__continent__pk=continent)
        if country:
            result['country_limit'] = Q(country__pk=country)
        if region:
            result['region_limit'] = Q(region__pk=region)
        if province:
            result['province_limit'] = Q(province__pk=province)
        if time_zone:
            result['time_zone_limit'] = Q(time_zone__pk=time_zone)

        # result['country'] = Q(**{"country__{}__name__icontains".format(self.lang): u'españa'})
        # result['country'] = Q(**{"country__es__name__icontains".format(self.lang): u'españa'})
        return result

    def __fields__(self, info):
        return [
            ('{}__name'.format(self.lang), _('Name')),
            ('time_zone', _('Time Zone')),
            ('province__code'.format(self.lang), _('Code province')),
            ('province__{}__name'.format(self.lang), _('Province')),
            ('country__code'.format(self.lang), _('Code country')),
            ('country__{}__name'.format(self.lang), _('Country')),
            ('country__continent__code', _('Code continent')),
            ('country__continent__{}__name'.format(self.lang), _('Name continent')),
        ]

    def __searchQ__(self, info, text):
        filters = self.model().__searchQ__(info, text)
        filters['name'] = Q(**{"{}__name__icontains".format(self.lang): text})
        filters['province_code'] = Q(**{'province__code': text})
        filters['province_name'] = Q(**{'province__{}__name__icontains'.format(self.lang): text})
        filters['country_code'] = Q(**{'country__code': text})
        filters['country_name'] = Q(**{'country__{}__name__icontains'.format(self.lang): text})
        filters['continent_code'] = Q(**{"country__continent__code": text})
        filters['continent_name'] = Q(**{"country__continent__{}__name__icontains".format(self.lang): text})
        return filters

    def __searchF__(self, info):
        def f(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fp(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"province__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fco(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"country__continent__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        def fcu(x):
            qsobject = []
            for lang in settings.LANGUAGES_DATABASES:
                qsobject.append(Q(**{"country__{}__name__icontains".format(lang.lower()): x}))
            return reduce(operator.or_, qsobject)

        filters = self.model().__searchF__(info)
        filters['{}__name'.format(self.lang)] = (_('Name'), f, 'input')

        filters['province__code'] = (_('Code self'), lambda x: Q(province__code__icontains=x), 'input')
        filters['province__{}__name'.format(self.lang)] = (_('Name region'), fp, 'input')

        filters['country__code'] = (_('Code self'), lambda x: Q(country__code__icontains=x), 'input')
        filters['country__{}__name'.format(self.lang)] = (_('Name country'), fcu, 'input')

        filters['country__continent__code'] = (_('Code continent'), lambda x: Q(country__continent__code__icontains=x), 'input')
        filters['country__continent__{}__name'.format(self.lang)] = (_('Name continent'), fco, 'input')
        return filters

    def dispatch(self, request, *args, **kwargs):
        self.order_by = ['{}__name'.format(self.lang)]
        return super(CityList, self).dispatch(request, *args, **kwargs)


class CityCreate(GenCityUrl, MultiForm, GenCreate):
    model = City
    form_class = CityForm
    forms = formsfull['City']


class CityCreateModal(GenCreateModal, CityCreate):
    pass


class CityUpdate(GenCityUrl, MultiForm, GenUpdate):
    model = City
    form_class = CityForm
    forms = formsfull['City']


class CityUpdateModal(GenUpdateModal, CityUpdate):
    pass


class CityDelete(GenCityUrl, GenDelete):
    model = City


class CityForeign(TranslatedMixin, GenCityUrl, GenForeignKey):
    model = City
    label = "{<LANGUAGE_CODE>__name}"
    public = True
    
    def get_foreign(self, queryset, search, filters):
        # Filter with search string
        qsobject = []
        for lang in settings.LANGUAGES_DATABASES:
            qsobject.append(Q(**{"{}__name__istartswith".format(lang.lower()): search}))
        qs = queryset.filter(
            reduce(operator.or_, qsobject)
        )
        # qs = queryset.filter(qsobject)

        country = filters.get('country', None)
        if country:
            qs = qs.filter(country__pk=country)

        province = filters.get('province', None)
        if province:
            qs = qs.filter(province__pk=province)

        region = filters.get('region', None)
        if region:
            qs = qs.filter(region__pk=region)
        qs = qs.order_by("{}__name".format(self.lang))
        return qs[:settings.LIMIT_FOREIGNKEY]
# -*- coding: utf-8 -*- # # django-codenerix-geodata # # Copyright 2017 Centrologic Computational Logistic Center S.L. # # Project URL : http://www.codenerix.com # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. # forms for multiforms # ########################################### # Continent # ########################################### # Country # Filter with search string # ########################################### # Regions # Filter with search string # ########################################### # Provinces # Filter with search string # ########################################### # TimeZone # ########################################### # City # result['country'] = Q(**{"country__{}__name__icontains".format(self.lang): u'españa'}) # result['country'] = Q(**{"country__es__name__icontains".format(self.lang): u'españa'}) # Filter with search string # qs = queryset.filter(qsobject)