如何在Django中显示今天、昨天和最后7天的数据

Question

我想显示today、yesterday和最后一个7 days的数据，请告诉我如何做到。

我正在尝试这个。。。。但它只显示最近7天的数据，但我想根据today、yesterday和last 7 days在HTML文件中显示数据这是我的views.py文件。。

def myview(request):
datas= Mymodel.objects.filter(created_on_gte=datetime.now()- 
timedelta(days=7)).count()
context= {'datas':datas}
return render(request, 'test.html', context}

这是我的test.html文件，我在其中显示数据。。。

<p>{{datas}} today</p>
<p>{{datas}} Yesterday</p>
<p>{{datas}} Last 7 Days</p>

Answer 1

此查询将给出聚合结果，并在模板中适当使用它

from django.utils import timezone
from datetime import timedelta
from django.db import models
now = timezone.now()
Mymodel.objects.aggregate(
today=models.Count('id', filter=models.Q(created_on__date=now.date())),
yesterday=models.Count('id', filter=models.Q(created_on__date__gte=(now - timedelta(hours=24)).date())),
last_7_day=models.Count('id', filter=models.Q(created_on__date__gte=(now - timedelta(days=7)).date())),
)

更新

from django.utils import timezone
from datetime import timedelta

def myview(request):
now = timezone.now()
result =Mymodel.objects.aggregate(
total=models.Count('id'),
today=models.Count('id', filter=models.Q(created_on__date=now.date())),
yesterday=models.Count('id', filter=models.Q(created_on__date__gte=(now - timedelta(hours=24)).date())),
last_7_day=models.Count('id', filter=models.Q(created_on__date__gte=(now - timedelta(days=7)).date())),
)
context = {'result': result}
return render(request, 'test.html',context)

然后在你的模板中，

<p>{{ result.today }} today</p>
<p>{{ result.yesterday }} Yesterday</p>
<p>{{ result.last_7_day }} Last 7 Days</p>

Answer 2

试试这样的东西：

from django.shortcuts import render
def days(request):

week = Mymodel.objects.filter(created_on_gte=datetime.now()-timedelta(days=7)).count()
yesterday = Mymodel.objects.filter(created_on_gte=datetime.now()-timedelta(days=1)).count()
today = Mymodel.objects.filter(created_on_gte=datetime.now())
context = {
'week': week,
'yesterday' : yesterday,
'today' : today,
}
return render(request, 'days.html', context)

.html

<p>{{today}} today</p>
<p>{{yesterday}} Yesterday</p>
<p>{{week}} Last 7 Days</p>