Re: DAILY,MONTHLY AND ANNUAL REPORTS

Check out the Sum() aggregate:

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

On July 21, 2023 12:41:48 PM CDT, Abdou KARAMBIZI <abdoukarambizi@gmail.com> wrote:

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