一、用户总数统计
1、后端接⼝设计
请求⽅式： GET /statistics/total_count/
请求参数： 通过请求头传递jwt token数据。
返回数据： JSON
{"count": "总⽤户量"}
2、后端代码实现
路由
from django.urls import re_pathfrom rest_framework_jwt.views import obtain_jwt_tokenfrom .views import usersfrom .views import statisticsurlpatterns=[re_path('^mg_admin/login/$',obtain_jwt_token),re_path('^statistics/total_count/$',statistics.UserTotalAPIView.as_view()),
视图
from datetime import datefrom rest_framework.permissions import IsAdminUserfrom rest_framework.response import Responsefrom rest_framework.views import APIViewfrom userapp.models import Usersclass UserTotalCountView(APIView):'''获取用户总数'''#指定管理员权限permission_classes=IsAdminUserdef get(self,request):count=Users.objects.all().count()return Response({'count':count})
二、日增用户数统计
1、后端接⼝设计
请求⽅式： GET /statistics/day_increment/
请求参数： 通过请求头传递jwt token数据。
返回数据： JSON
{"count": "新增⽤户量", }
2、后端代码实现
date_joined 记录创建账户时间
路由
from django.urls import re_pathfrom rest_framework_jwt.views import obtain_jwt_tokenfrom .views import usersfrom .views import statisticsurlpatterns=[re_path('^mg_admin/login/$',obtain_jwt_token),re_path('^statistics/day_increment/$',statistics.UserDayCountView.as_view()),
视图
class UserDayCountView(APIView):'''获取日增用户数'''#指定管理员权限permission_classes=IsAdminUserdef get(self,request):#获取当前日期now_today=date.today()year=now_today.yearmonth=now_today.monthday=now_today.daycount=Users.objects.filter(date_joined__year=year,date_joined__month=month,date_joined__day=day)return Response({'count':count})
三、日活跃用户统计
1、后端接⼝设计
请求⽅式：GET /statistics/day_active/
请求参数： 通过请求头传递jwt token数据。
返回数据： JSON
{"count": "活跃⽤户量"}
2、后端代码实现
路由
from django.urls import re_pathfrom rest_framework_jwt.views import obtain_jwt_tokenfrom .views import usersfrom .views import statisticsurlpatterns=[re_path('^mg_admin/login/$',obtain_jwt_token),re_path('^statistics/day_active/$',statistics.UserActiveCountView.as_view()),]
视图
class UserActiveCountView(APIView):'''获取⽇活跃⽤户数'''#指定管理员权限permission_classes=IsAdminUserdef get(self,request):#获取当前日期now_today=date.today()year=now_today.yearmonth=now_today.monthday=now_today.day# 获取当⽇登录⽤户数量 last_login记录最后登录时间count=User.objects.filter(last_login__year=year,last_login__month=month,last_login__day=day).count()return Response({'count':count})
注意：需要将配置文件中的USE_TZ改为False，才能展示当前时间
上述前端代码实现
data() {return {host:'http://192.168.17.129:8880',token:localStorage.token,username:localStorage.username,userid:localStorage.user_id,stat: [[],]}},computed:{chartLine1() {return this.$echarts.init(Util.getDom('line1'));}},methods: {getOrderCount(){this.$axios.get(this.host +'/statistics/time_order_count/',{headers:{'Authorization': 'JWT ' + this.token}}).then(response=>{this.drawLine1(response.data);}).catch(error=>{console.log(error.response);})},drawLine1(data){let title = "今日和昨日下单量";let option = {title: Object.assign({}, Util.defaultEchartsOpt.title, {text: title}),grid: {top: 60,left: 60,right: 80,bottom: 20,containLabel: true},tooltip: {trigger: 'axis',axisPointer: {lineStyle: {color: '#ddd'}},backgroundColor: 'rgba(255,255,255,1)',padding: [5, 10],textStyle: {color: '#999',},extraCssText: 'box-shadow: 0 0 5px rgba(0,0,0,0.3)'},legend: {top: 15,right: 20,orient: 'vertical',textStyle: {color: "#666"}},xAxis: {type: 'category',data: ['00:00','2:00','4:00','6:00','8:00','10:00','12:00','14:00','16:00','18:00','20:00','22:00'],boundaryGap: false,splitLine: {show: false,interval: 'auto',lineStyle: {color: ['#D4DFF5']}},axisTick: {show: false},axisLine: {lineStyle: {color: '#999'}},axisLabel: {margin: 10,textStyle: {fontSize: 14}}},yAxis: {type: 'value',splitLine: {lineStyle: {color: ['#D4DFF5']}},axisTick: {show: false},axisLine: {lineStyle: {color: '#999'}},axisLabel: {margin: 10,textStyle: {fontSize: 14}}},series: [{name: '今日',type: 'line',smooth: true,showSymbol: false,symbol: 'circle',symbolSize: 4,data: data['t_count_list'],areaStyle: {normal: {color: new this.$echarts.graphic.LinearGradient(0, 0, 0, 1, [{offset: 0,color: 'rgba(199, 237, 250,0.5)'}, {offset: 1,color: 'rgba(199, 237, 250,0.2)'}], false)}},itemStyle: {normal: {color: 'rgba(154, 116, 179, 0.7)'}},lineStyle: {normal: {width: 2}}}, {name: '昨日',type: 'line',smooth: true,showSymbol: false,symbol: 'circle',symbolSize: 4,data: data['y_count_list'],areaStyle: {normal: {color: new this.$echarts.graphic.LinearGradient(0, 0, 0, 1, [{offset: 0,color: 'rgba(216, 244, 247,1)'}, {offset: 1,color: 'rgba(216, 244, 247,1)'}], false)}},itemStyle: {normal: {color: 'rgba(126, 237, 238, 0.7)'}},lineStyle: {normal: {width: 2}}}]};this.chartLine1.setOption(option);return this;},day_active_count(){// 获取日活跃用户总数this.$axios.get(this.host+'/statistics/day_active/',{headers:{'Authorization': 'JWT ' + this.token}}).then(response=>{this.stat[0].splice(2,0,{title: '日活跃用户总数',total: response.data.count,bgColor: '#67c4ed'});}).catch(error=>{console.log(error.response);});},day_increment_count(){// 获取日增用户总数this.$axios.get(this.host+'/statistics/day_increment/',{headers:{'Authorization': 'JWT ' + this.token}}).then(response=>{this.stat[0].splice(1,0,{title: '日增用户总数',total: response.data.count,bgColor: '#3acaa9'});}).catch(error=>{console.log(error.response);});},total_user_count(){// 获取用户总数this.$axios.get(this.host+'/statistics/total_count/',{headers:{'Authorization': 'JWT ' + this.token}}).then(response=>{this.stat[0].splice(0,0,{title: '用户总数',total: response.data.count,bgColor: '#ebcc6f'});}).catch(error=>{console.log(error.response);});},},mounted() {this.total_user_count();this.day_increment_count();this.day_active_count();this.getOrderCount();}}
如果觉得《【django项目后台开发】数据统计——用户总数统计 日增用户数统计 日活跃用户统计（3）》对你有帮助，请点赞、收藏，并留下你的观点哦！
