数据统计
用户总数统计
导包 from datetime import date
date=date.today()
from rest_framework.permissions import IsAdminUser
# 指定管理员权限
permission_classes = [IsAdminUser]
日增用户统计
- 获取当日注册用户数量
- date_joined 记录创建账户时间
count = User.objects.filter(date__joined__get = date).count
日活跃用户统计
- 获取当日登录用户数量
- last_login记录最后登录时间
count=User.objects.filter(last_login__gte=now_date).count()
日下单用户量统计
- 获取当日下单用户数量
- orders__create_time 订单创建时间
count=User.objects.filter(orders__create_time__gte=now_date).count()
月增用户统计
date = date.today()
count_list = []
for i in range(30):
date_begin = today - timedelta(days=29 - i)
date_end = date_begin + timedelta(days=1)
count = User.objects.filter(is_staff=False, date_joined__gte=date_begin, date_joined__lt=date_end).count()
日分类商品访问量
class VisitSerializer(serializers.Serializer):
category=serializers.StringRelatedField(read_only=True)
count = serializers.IntegerField()
class GoodsView(ListAPIView):
queryset = GoodsVisitCount.objects.filter(date=date.today())
serializer_class = statistical.VisitSerializer