Added some admin dashboard stats

7 files changed, 79 insertions, 2 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})
@@ -0,0 +1,11 @@
+class CreateGlobals < ActiveRecord::Migration[7.1]
+  def change
+    create_table :globals do |t|
+      t.string :key
+      t.string :string_value
+      t.integer :int_value
+
+      t.timestamps
+    end
+  end
+end
@@ -10,7 +10,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema[7.1].define(version: 2023_10_30_181440) do
+ActiveRecord::Schema[7.1].define(version: 2024_03_20_145033) do
   create_table "active_storage_attachments", force: :cascade do |t|
     t.string "name", null: false
     t.string "record_type", null: false
@@ -118,6 +118,14 @@ ActiveRecord::Schema[7.1].define(version: 2023_10_30_181440) do
     t.date "finished_on"
   end
 
+  create_table "globals", force: :cascade do |t|
+    t.string "key"
+    t.string "string_value"
+    t.integer "int_value"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+  end
+
   create_table "lingo_scores", force: :cascade do |t|
     t.integer "user_id", limit: 8
     t.string "username"
@@ -0,0 +1,11 @@
+# Read about fixtures at https://api.rubyonrails.org/classes/ActiveRecord/FixtureSet.html
+
+one:
+  key: MyString
+  string_value: MyString
+  int_value: 1
+
+two:
+  key: MyString
+  string_value: MyString
+  int_value: 1
@@ -0,0 +1,7 @@
+require "test_helper"
+
+class GlobalTest < ActiveSupport::TestCase
+  # test "the truth" do
+  #   assert true
+  # end
+end