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 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+unsubscr...@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.

 

--
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/22CCCFA9-83C9-45FF-A2E7-413F1221FE49%40hxcore.ol.

Reply via email to