blob: 3aea11704b0d53ffd7b0db392cce64e2c5445056 (
plain) (
blame)
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
|
from django.db import models
from ctrack.organisations.models import Organisation, Person
class ApplicableSystemManager(models.Manager):
def with_primary_contact(self):
"""
Add in the name of the primary nis contact to the context.
Using Custom Managers Django docs for an example.
"""
from django.db import connection
with connection.cursor() as cursor:
cursor.execute("""
SELECT a.id, a.name, o.id, c.id, sm.descriptor, p.id, o.name
FROM caf_applicablesystem a, organisations_organisation o, organisations_person p, caf_caf c, organisations_submode sm
WHERE a.organisation_id = o.id AND a.caf_id = c.id AND p.organisation_id = o.id AND o.submode_id = sm.id AND p.primary_nis_contact = False;
""")
result_list = []
for row in cursor.fetchall():
org = Organisation.objects.get(pk=row[2])
ass = self.model(id=row[0], name=row[1], organisation=org)
ass.nis_contact = Person.objects.get(pk=row[5])
result_list.append(ass)
return result_list
|