summaryrefslogtreecommitdiff
path: root/ishtar_common/lookups.py
blob: ef2ff81f1caa0d02101804fff0c022be2a018dbb (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
from ajax_select import register, LookupChannel

from django.conf import settings
from django.db.models import Q
from ishtar_common.models import Person, Organization, IshtarUser, Town


@register('town')
class TownLookup(LookupChannel):
    model = Town

    def get_query(self, q, request):
        if settings.COUNTRY == 'fr':
            query = Q()
            for term in q.strip().split(' '):
                query &= (
                    Q(name__icontains=term) | Q(numero_insee__icontains=term)
                )
        else:
            query = Q(name__icontains=q)
        return self.model.objects.filter(query).order_by('name')[:20]

    def format_item_display(self, item):
        return u"<span class='ajax-label'>%s</span>" % unicode(item)


@register('organization')
class OrganizationLookup(LookupChannel):
    model = Organization

    def get_query(self, q, request):
        return self.model.objects.filter(
            name__icontains=q).order_by('name')[:20]

    def format_item_display(self, item):
        return u"<span class='ajax-label'>%s</span>" % unicode(item)


@register('person')
class PersonLookup(LookupChannel):
    model = Person

    def get_query(self, q, request):
        query = Q()
        for term in q.strip().split(' '):
            query &= (
                Q(name__icontains=term) | Q(surname__icontains=term) |
                Q(email__icontains=term) | Q(attached_to__name__icontains=term)|
                Q(raw_name__icontains=term)
            )
        return self.model.objects.filter(query).order_by('name')[:20]

    def format_item_display(self, item):
        return u"<span class='ajax-label'>%s</span>" % unicode(item)


@register('ishtaruser')
class UserLookup(LookupChannel):
    model = IshtarUser

    def get_query(self, q, request):
        query = Q()
        for term in q.strip().split(' '):
            query &= (
                Q(user_ptr__username__icontains=term) |
                Q(person__name__icontains=term) |
                Q(person__surname__icontains=term) |
                Q(person__email__icontains=term) |
                Q(person__attached_to__name__icontains=term)|
                Q(person__raw_name__icontains=term)
            )
        return self.model.objects.filter(query).order_by('person__name')[:20]

    def format_item_display(self, item):
        return u"<span class='ajax-label'>%s</span>" % unicode(item.person)