You've already posted the same question:
https://groups.google.com/g/django-users/c/f7ZH2pcZp0s
On Wednesday, 20 April 2022 at 16:44:19 UTC+2 techg...@gmail.com wrote:
> 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/498d046c-84e9-4ee6-914c-14a373c50625n%40googlegroups.com.
