diff options
Diffstat (limited to 'backend/views.py')
| -rw-r--r-- | backend/views.py | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/backend/views.py b/backend/views.py index 383c487..8d28674 100644 --- a/backend/views.py +++ b/backend/views.py @@ -1061,16 +1061,16 @@ def stats(request): """ View statistics """ uptime = str(datetime.now() - settings.START_TIME) - videos_today = None - videos_total = None - likes_today = None - likes_total = None - users_total = None - users_today = None - users_in_main_room = None - new_users_today = None - rooms_total = None - main_room_peak = None + videos_today = SJContent.objects.filter(content_type='video', datetime__gt=yesterday_datetime()).count() + videos_total = SJContent.objects.filter(content_type='video').count() + likes_today = SJLike.objects.filter(content__content_type='video', datetime__gt=yesterday_datetime()).count() + likes_total = SJLike.objects.filter(content__content_type='video').count() + users_total = auth.models.User.objects.filter(is_active=True).count() + users_today = auth.models.User.objects.filter(is_active=True, last_login__gt=yesterday_datetime()) + users_in_main_room = auth.models.User.objects.filter(sjroom__name='main', sjuserprofile__lastseen_chat__gt=lastseen_datetime()) + new_users_today = auth.models.User.objects.filter(is_active=True, date_joined__gt=yesterday_datetime()).order_by('-date_joined') + rooms_total = SJRoom.objects.all().count() + main_room_peak = auth.models.User.objects.filter(sjroom__name='main').count() return render_to_response('stats.html', {'users_total': users_total, 'users_today': users_today, 'new_users_today': new_users_today, |