Backend: Update stats view

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,