File size: 1,372 Bytes
b7f55e1 | 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 | from django.db import models
from students.models import Student
from teachers.models import Subject
class Grade(models.Model):
TERM_CHOICES = [('1', 'Term 1'), ('2', 'Term 2'), ('3', 'Term 3'), ('final', 'Final')]
student = models.ForeignKey(Student, on_delete=models.CASCADE, related_name='grades')
subject = models.ForeignKey(Subject, on_delete=models.CASCADE, related_name='grades')
term = models.CharField(max_length=10, choices=TERM_CHOICES, default='1')
score = models.DecimalField(max_digits=5, decimal_places=2)
max_score = models.DecimalField(max_digits=5, decimal_places=2, default=100)
academic_year = models.CharField(max_length=20, default='2024-2025')
remarks = models.TextField(blank=True)
created_at = models.DateTimeField(auto_now_add=True)
@property
def percentage(self):
if self.max_score > 0:
return round((self.score / self.max_score) * 100, 1)
return 0
@property
def letter_grade(self):
p = self.percentage
if p >= 90: return 'A+'
if p >= 80: return 'A'
if p >= 70: return 'B'
if p >= 60: return 'C'
if p >= 50: return 'D'
return 'F'
def __str__(self):
return f"{self.student} - {self.subject} - {self.term}"
class Meta:
ordering = ['-created_at'] |