summaryrefslogtreecommitdiff
path: root/ishtar_common/lookups.py
blob: 1d566d1db2a389be5d67a98602ff811146db0559 (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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
from ajax_select import register, LookupChannel as BaseLookupChannel

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


class LookupChannel(BaseLookupChannel):
    def get_objects(self, items):
        # TODO: why IDs are not given here? M2M issue
        ids = []
        for item in items:
            if hasattr(item, 'pk'):
                ids.append(item.pk)
            else:
                ids.append(item)
        return super(LookupChannel, self).get_objects(ids)

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


class TypeLookupChannel(LookupChannel):
    def get_query(self, q, request):
        query = Q(label__icontains=q) | Q(label__icontains=q)
        return self.model.objects.filter(query).order_by('label')[:20]


@register('town')
class TownLookup(LookupChannel):
    model = models.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]


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

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


@register('person')
class PersonLookup(LookupChannel):
    model = models.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]


@register('author')
class AuthorLookup(LookupChannel):
    model = models.Author

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


@register('ishtaruser')
class UserLookup(LookupChannel):
    model = models.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)


@register('area')
class AreaLookup(LookupChannel):
    model = models.Area

    def get_query(self, q, request):
        query = Q(label__icontains=q)
        return self.model.objects.filter(query).order_by('label')[:20]


@register('document')
class DocumentLookup(LookupChannel):
    model = models.Document

    def get_query(self, q, request):
        query = Q(title__icontains=q) | Q(reference__icontains=q) | Q(
            internal_reference__icontains=q
        )
        return self.model.objects.filter(query).order_by('title')[:20]