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
|
from django.db import connection, models
import ctrack.caf.models as caf_models # to deal with circular import
import ctrack.organisations.models as org_models
class ApplicableSystemManager(models.Manager):
def with_primary_contact(self):
"""
THIS IS NOT CURRENTLY USED BUT LEAVING IT IN FOR REF
BETTER WAS TO ADD A MODEL METHOD TO FIND THE POC FOR EACH
ORGANISATION AND ADAPT THE TEMPLATE TO USE THAT.
Add in the name of the primary nis contact to the context.
Using Custom Managers Django docs for an example.
"""
with connection.cursor() as cursor:
cursor.execute(
"""
SELECT a.id, a.name, o.id, c.id, sm.id, 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 = True;
"""
)
result_list = []
for row in cursor.fetchall():
org = org_models.Organisation.objects.get(pk=row[3])
caf = ctrack.caf.models.CAF.objects.get(pk=row[3])
ass = self.model(id=row[0], name=row[1], organisation=org, caf=caf)
ass.nis_contact = Person.objects.get(pk=row[5])
result_list.append(ass)
return result_list
|
