Added some admin dashboard stats

3 files changed, 41 insertions, 1 deletions

@@ -35,6 +35,8 @@ class CommentsController < ApplicationController
     if is_blatant
       # I am lying.
       flash.notice = "Comment submitted successfully! It will need to be moderated before it shows up on the blog."
+
+      Global.increment_filtered_comments
     else
       if is_spam
         @comment.status = :pending
@@ -0,0 +1,20 @@
+class Global < ApplicationRecord
+  def self.get_filtered_comments
+    row = find_by_key("filtered_comments")
+    if row
+      row[:int_value]
+    else
+      0
+    end
+  end
+
+  def self.increment_filtered_comments
+    row = find_by_key("filtered_comments")
+    if row
+      row.int_value += 1
+      row.save
+    else
+      create(key: "filtered_comments", int_value: 1)
+    end
+  end
+end
@@ -1 +1,19 @@
-Welcome to the the ubiquitous administration panel!
+%p Welcome to the the ubiquitous administration panel!
+%p Stats:
+%ul
+  %li
+    %strong Blog posts:
+    = Blog.count
+  %li
+    %strong Approved comments:
+    = Comment.where(status: :published).count
+  %li
+    %strong Filtered comments:
+    = Global.get_filtered_comments
+  %li
+    %strong Quotes:
+    = Quote.count
+  %li
+    %strong Votes:
+    = Vote.count
+    (+#{Vote.where(upvote: true).count} / -#{Vote.where(upvote: false).count})