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 django-users+unsubscr...@googlegroups.com.
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