52 lines
1.7 KiB
Python
52 lines
1.7 KiB
Python
from django.db import models
|
|
|
|
|
|
class Project(models.Model):
|
|
name = models.CharField(max_length=100)
|
|
code = models.CharField(max_length=10, blank=True)
|
|
iacuc_number = models.CharField(max_length=25, blank=True)
|
|
description = models.CharField(max_length=255, blank=True)
|
|
sort_order = models.IntegerField(blank=True, null=True)
|
|
|
|
def __str__(self):
|
|
return self.name
|
|
|
|
class Meta:
|
|
unique_together = ('name', 'code')
|
|
ordering = ['sort_order']
|
|
|
|
|
|
class Grant(models.Model):
|
|
title = models.CharField(max_length=200)
|
|
code = models.CharField(max_length=10, blank=True)
|
|
description = models.CharField(max_length=255, blank=True)
|
|
projects = models.ManyToManyField(Project, related_name='grants')
|
|
sort_order = models.IntegerField(blank=True, null=True)
|
|
|
|
def __str__(self):
|
|
return self.title
|
|
|
|
class Meta:
|
|
unique_together = ('title', 'code',)
|
|
ordering = ['sort_order']
|
|
|
|
|
|
class GrantReport(models.Model):
|
|
grant = models.ForeignKey(Grant, related_name='reports',
|
|
on_delete=models.CASCADE)
|
|
title = models.CharField(max_length=200)
|
|
report_type = models.CharField(max_length=50, blank=True)
|
|
description = models.CharField(max_length=255, blank=True)
|
|
due_date = models.DateField(blank=True, null=True)
|
|
submitted_date = models.DateField(blank=True, null=True)
|
|
attachment = models.FileField(
|
|
upload_to='projects/grants/grant_report_attachments/%Y/%m/%d',
|
|
blank=True, null=True)
|
|
sort_order = models.IntegerField(blank=True, null=True)
|
|
|
|
def __str__(self):
|
|
return self.title
|
|
|
|
class Meta:
|
|
unique_together = ('grant', 'title', 'due_date',)
|
|
ordering = ['sort_order']
|