Its simple... in your fee models' save method check that
self.remaining_fees is zero then make self.completed field to true..
def save(self, *args, **kwargs):
self.remaining_fees = self.school_fees - self.paid_fees
if self.remaining_fees == 0:
self.completed = True
super().save(*args, **kwargs)
On Monday, September 14, 2020 at 7:11:51 AM UTC-4 dex9...@gmail.com wrote:
> Thank you brother @coolguy, I have put to work your latest solution and
> it has worked like a charm.I have been learning a lot from you lately, as
> you know i am still a beginner, i would love to learn one more thing from
> you..i have a boolean field "completed", and i want django to automatically
> check it when balance_fees or remaining_fees is equal to zero,
>
> Here is my model
> [image: image.png]
>
> my template
> [image: image.png]
>
>
>
>
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
>
>
> *From: *coolguy
> *Sent: *Friday, September 11, 2020 8:51 PM
> *To: *Django users
> *Subject: *Re: Help me with the view please
>
>
>
> Technically your Fee model is designed incorrectly. You should have
> separate models for 'fees' and 'fees_paid' where fee would have been the
> foreign key in 'fees_paid. Fee should have a property like annual fee etc
> for each student as fee may be different based on student discounts etc.
> Then when student pays the fees, fees should go in a separate transactional
> table i.e. 'fees paid'. In your scenario, does each row in fee table
> carries the annual/school fee? if so then yes summing them up will
> definitely cause incorrect figure.
>
>
>
> Here is what i would do if i don't change my models structure.
>
>
>
> views.py
>
> =======
>
> def student_detail(request, pk):
>
> student = Student.objects.get(id=pk)
>
>
>
> *# in your case pick the first record from fee_set*
>
> first_record = student.fee_set.first()
>
> school_fees = first_record.school_fees
>
>
>
> paid_fees = student.fee_set.aggregate(total_paid_fees=Sum('paid_fees'))
>
>
>
> balance_fees = school_fees - paid_fees["total_paid_fees"]
>
>
>
> context = {"student": student,
>
> "paid_fees": paid_fees,
>
> "school_fees": school_fees,
>
> "balance_fees": balance_fees, }
>
>
>
> return render(request, "student_details.html", context)
>
>
>
> template
>
> =======
>
> <body>
>
> <h1>Student Detail</h1>
>
> <p>Student name: {{ student.name }}</p>
>
> <p>School fees: {{ school_fees }}</p>
>
> <p>Paid fees: {{ paid_fees.total_paid_fees }}</p>
>
> <p>Remaining fees: {{ balance_fees }}</p>
>
> </body>
>
>
>
> Output:
>
> ================
>
> Student name: student1
>
> School fees: 100000.0
>
> Paid fees: 35000.0
>
> Remaining fees: 65000.0
>
>
>
> On Friday, September 11, 2020 at 5:25:28 AM UTC-4 dex9...@gmail.com wrote:
>
> Sorry for bothering you @coolguy, you’re the only person who seems to be
> nice to a Django beginner developer like me, and I would like to bother you
> one more time
>
> Your solution for using methods in models is perfectly fine
>
> You see I want school_fees to be a fixed amount, example $300
>
> So when a student pays more than once(student.fee_set), lets say this
> month student 1 pays $50
>
> And another month pays $100 dollars, I want payments to added and
> subtracted from fixed schools_fees($300)
>
> Remainingfees to be $300 – (($50)+($100))
>
>
>
> BUT what “
> fees = student.fee_set.aggregate(total_paid_fees=Sum('paid_fees'),
> total_school_fees=Sum('school_fees'))”
> does is that it sums both paid fees school fees every time a student pays,
> I want only paid fees to added every time a student pays but not school fees
>
>
>
>
>
>
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
>
>
> *From: *coolguy
> *Sent: *Friday, September 11, 2020 4:27 AM
> *To: *Django users
> *Subject: *Re: Help me with the view please
>
>
>
> If i choose to go with your way of calculation, i would do this...
>
>
>
> def student_detail(request, pk):
>
> student = Student.objects.get(id=pk)
>
>
> fees = student.fee_set.aggregate(total_paid_fees=Sum('paid_fees'),
> total_school_fees=Sum('school_fees'))
>
>
>
> balance_fees = fees["total_school_fees"] - fees["total_paid_fees"]
>
>
>
> context = {"student": student,
> "fees": fees, "balance_fees": balance_fees, }
>
>
>
> return render(request, "student_details.html", context)
>
>
>
> Template e.g.
>
> <body>
>
> <h1>Student Detail</h1>
>
> <p>Student name: {{ student.name }}</p>
>
> <p>School fees: {{ fees.total_school_fees }}</p>
>
> <p>Paid fees: {{ fees.total_paid_fees }}</p>
>
> <p>Remaining fees: {{ balance_fees }}</p>
>
> </body>
>
>
>
> Result:
>
> Student Detail
>
> Student name: student1
>
> School fees: 100000.0
>
> Paid fees: 25000.0
>
> Remaining fees: 75000.0
>
> I hope this helps!
>
> On Thursday, September 10, 2020 at 2:16:27 PM UTC-4 dex9...@gmail.com
> wrote:
>
> Thanks for helping me @coolguy,but it seems I ran into another problem,
> the school fees and remaining fees somehow sums together, I want students
> to pay school fees in phases, i.e, first quarter, second etc, and I want
> remaining fee to be the difference between the initial school fees which is
> 1000000 and total fee paid.
>
> Thanks in advance
>
>
>
> My views.py for student
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
>
>
> *From: *coolguy
> *Sent: *Tuesday, September 8, 2020 11:58 PM
> *To: *Django users
> *Subject: *Re: Help me with the view please
>
>
>
> I see now what you are asking...
>
>
>
> I never do such calculations in views rather I create methods in models.py
> to do so and call them in the template...
>
>
>
> Like what you could do is..
>
>
>
> class Student(models.Model):
>
> name = models.CharField(max_length=200, null=True, blank=True)
>
> classroom = models.ForeignKey(Classroom,
>
>
> on_delete=models.DO_NOTHING, blank=True,
> null=True)
>
>
>
> def __str__(self):
>
> return *self*.name
>
>
>
> def get_total_fee(self):
>
> return sum(student.school_fees for student in *self*
> .fee_set.all())
>
>
>
> def get_total_paid_fee(self):
>
> return sum(student.paid_fees for student in *self*.fee_set.all())
>
>
>
> def get_remaining_fee(self):
>
> total_fee = *self*.get_total_fee()
>
> total_paid = *self*.get_total_paid_fee()
>
> return float(total_fee - total_paid)
>
>
>
> and in template you can call...
>
> {{ student.get_remaining_fee }}
>
> On Tuesday, September 8, 2020 at 1:35:56 PM UTC-4 dex9...@gmail.com wrote:
>
> Thank you for your help @coolguy..but my real problem lies in writing the
> code for “fee_remaining”, can you help me with that also..thanks
>
>
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
>
>
> *From: *coolguy
> *Sent: *Tuesday, September 8, 2020 7:45 PM
> *To: *Django users
> *Subject: *Re: Help me with the view please
>
>
>
> In your return line of code, you are referring to context variable but I
> don't see you assigned any value to this context variable in your code.
>
> Or if you want to send three variables i.e. "fees", "total_fees" and
> "fee_remaining"... you need to send them separately like
>
>
>
> return render(request, 'website/students.html', {"fees": fees,
> "total_fees": total_fees, "fee_remaining": fee_remaining })
>
>
>
> then use these variables on your students.html template.
>
>
>
> On Tuesday, September 8, 2020 at 12:21:21 PM UTC-4 dex9...@gmail.com
> wrote:
>
> My Models
> class Student(models.Model):
> name = models.CharField(max_length=200, null=True, blank=True)
> classroom = models.ForeignKey(‘Classroom’,
> on_delete=models.DO_NOTHING,blank=True, null=True)
> class Classroom(models.Model):
> name = models.CharField(max_length=40,blank=True, null=True)
>
> class Fee(models.Model):
> student = models.ForeignKey(Student, on_delete=models.CASCADE, null=True,)
> classroom = models.ForeignKey(Classroom, on_delete=models.CASCADE,
> null=True)
> school_fees = models.FloatField(default=1000000)
> paid_fees = models.FloatField(null=False)
> remaining_fees = models.FloatField(blank=True)
> completed = models.BooleanField(null=False, default=False)
>
> views.py
> def student(request, pk):
> student = Student.objects.get(id=pk)
>
> fees = student.fee_set.all().order_by('-publish_date') total_fees =
> student.fee_set.all().filter(student__id=pk)
> .aggregate(sum=Sum('paid_fees', flat=True)['sum']
>
> fees_remaining = ()
>
> return render(request, 'website/students.html', context)
>
> --
> 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...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/e026b778-bac8-4522-ad1f-2ea4b33ad1efn%40googlegroups.com
>
> <https://groups.google.com/d/msgid/django-users/e026b778-bac8-4522-ad1f-2ea4b33ad1efn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
>
>
> --
> 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...@googlegroups.com.
>
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/bc5f52f8-4b46-40c5-8ff1-9d05e3095346n%40googlegroups.com
>
> <https://groups.google.com/d/msgid/django-users/bc5f52f8-4b46-40c5-8ff1-9d05e3095346n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
>
>
> --
> 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...@googlegroups.com.
>
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/aca1c587-c6e9-4bf6-8c07-0d2927795e82n%40googlegroups.com
>
> <https://groups.google.com/d/msgid/django-users/aca1c587-c6e9-4bf6-8c07-0d2927795e82n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
>
>
> --
> 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...@googlegroups.com.
>
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/4f854ccd-3bd0-4b8c-b17c-03e32e8f56dbn%40googlegroups.com
>
> <https://groups.google.com/d/msgid/django-users/4f854ccd-3bd0-4b8c-b17c-03e32e8f56dbn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
>
>
--
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/7f79d2ce-17e7-43f0-9c8f-c5b3afe6b21fn%40googlegroups.com.
