I have a model Staff and LeaveReportStaff, I wanted to get leave_balance
between Total_Leave_Days and leave_days. I already used Foreignkey for
staff but I'm not sure if it is right to use Foreignkey again.

Please advise the best way forward.

class Staff(models.Model):
    Total_Leave_Days = models.PositiveIntegerField(default=0)
    course = models.ForeignKey(Course, on_delete=models.DO_NOTHING,
null=True, blank=False)
    admin = models.OneToOneField(CustomUser, on_delete=models.CASCADE)


class LeaveReportStaff(models.Model):
    staff = models.ForeignKey(Staff, on_delete=models.CASCADE)
    start_date = models.DateField()
    end_date = models.DateField()
    leave_type = models.CharField(choices=LEAVE_TYPE, max_length=25,
null=True, blank=False)

@property
def leave_days(self):
    return (self.end_date - self.start_date).days

@property
def leave_balance(self):
    return (self.Total_Leave_Days - self.leave_days)

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CADYG20F2ySFndjkc6o3oPH%3DxjPc450hXuGRM5c7_cnBMOy9ZiQ%40mail.gmail.com.

Reply via email to