from django.db import models
from ctrack.caf.managers import ApplicableSystemManager
from ctrack.organisations.models import Organisation, Person
from django.urls.base import reverse
class Grading(models.Model):
GRADING_TYPE = [("CONFIDENCE", "Confidence"), ("QUALITY", "Quality"), ("MISC", "Misc")]
descriptor = models.CharField(max_length=2, help_text="Q1, C1, etc")
description = models.TextField(max_length=250)
type = models.CharField(max_length=20, choices=GRADING_TYPE, help_text="Type of grading")
def __str__(self):
return self.descriptor
class FileStore(models.Model):
descriptor = models.CharField(max_length=100)
virtual_location = models.CharField(
max_length=100, help_text="USB, Rosa, email, etc"
)
physical_location = models.CharField(
max_length=100, blank=True, help_text="Cupboard, room, building, etc"
) # cupboard, room, building, address
physical_location_organisation = models.ForeignKey(
Organisation, on_delete=models.CASCADE
)
def __str__(self):
return self.descriptor
class DocumentFile(models.Model):
FILETYPE_CHOICES = [(1, "Excel"), (2, "Word"), (3, "PDF"), (4, "Hard Copy")]
name = models.CharField(max_length=255)
type = models.IntegerField(choices=FILETYPE_CHOICES, default=1)
file_store_location = models.ForeignKey(FileStore, on_delete=models.CASCADE)
class ApplicableSystem(models.Model):
def get_sentinel_org():
"""
We need this so that we can ensure models.SET() is applied with a callable
to handle when Users are deleted from the system, preventing the Organisation
objects related to them being deleted also.
"""
return Organisation.objects.get_or_create(name="DELETED ORGANISATION")[0]
name = models.CharField(max_length=256)
description = models.TextField(max_length=1000)
organisation = models.ForeignKey(
Organisation, on_delete=models.SET(get_sentinel_org)
)
caf = models.ForeignKey("CAF", on_delete=models.CASCADE, blank=True, null=True, related_name="applicable_systems")
class Meta:
verbose_name = "Applicable System"
def get_primary_contact(self):
return self.organisation.person_set.filter(primary_nis_contact=True)
def __str__(self):
return f"{self.organisation.name} | {self.name}"
objects = ApplicableSystemManager()
class CAF(models.Model):
quality_grading = models.ForeignKey(Grading, on_delete=models.CASCADE, blank=True, null=True,
related_name="quality_grading")
confidence_grading = models.ForeignKey(Grading, on_delete=models.CASCADE, blank=True, null=True,
related_name="confidence_grading")
file = models.ForeignKey(DocumentFile, on_delete=models.CASCADE, blank=True, null=True)
version = models.CharField(max_length=10, blank=True, null=True)
triage_review_date = models.DateField(blank=True, null=True)
triage_review_inspector = models.ForeignKey(Person, on_delete=models.CASCADE, blank=True, null=True)
comments = models.TextField(max_length=1000)
class Meta:
verbose_name = "CAF"
def get_absolute_url(self):
return reverse("caf:detail", kwargs={"pk": self.pk})
def applicable_systems(self):
"""
Returns a Queryset of objects we can use in our templates.
"""
return ApplicableSystem.objects.filter(caf=self)
def organisation(self):
first_ass = ApplicableSystem.objects.filter(caf=self).first()
return first_ass.organisation
def sub_mode(self):
return self.organisation().submode
def __str__(self):
# Get the organisation and applicable system
ass = ApplicableSystem.objects.filter(caf=self).first()
return f"CAF | {ass.organisation.name}_v{self.version}"