DAILY,MONTHLY AND ANNUAL REPORTS

[Abdou KARAMBIZI]

Hello Friends,

How can I get weekly,Monthly and annual reports? from the following model.

I want to get the total amount paid in the week,month and year 

class Payments(models.Model):
    id = models.AutoField(primary_key = True)
    amount = models.IntegerField()
    paidon = models.DateField(auto_now=True)

    def __str__ (self):
        return self.id

[Prashanth Patelc]

Write a condition based on paidon date filed like filter date ,

If date is today get last 7days report and get last month report.

--
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/CABnE44wPtzkAL5YJ4uh3eRpupXUpH%3DkTJL71obTpTthorCdrTw%40mail.gmail.com.

[Ryan Nowakowski]

Check out the Sum() aggregate:

https://docs.djangoproject.com/en/4.2/topics/db/aggregation/

[ivan harold]

is this thread closed? resolved?