Re: DAILY,MONTHLY AND ANNUAL REPORTS

2023-08-09 Thread ivan harold
is this thread closed? resolved? On Saturday, July 22, 2023 at 8:08:48 AM UTC+8 Ryan Nowakowski wrote: > 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 > wrote: > >> Hello Friends, >> >> Ho

Re: DAILY,MONTHLY AND ANNUAL REPORTS

2023-07-21 Thread 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. On Fri, Jul 21, 2023, 11:12 PM Abdou KARAMBIZI wrote: > Hello Friends, > > How can I get weekly,Monthly and annual reports? from the following model. > I want to get

DAILY,MONTHLY AND ANNUAL REPORTS

2023-07-21 Thread 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(au