move db query from view to controller and method

avinoth · avinoth · commit 5d9d4332f5e1 · 2015-01-18T14:56:13.000+05:30
diff --git a/app/controllers/admin_controller.rb b/app/controllers/admin_controller.rb
@@ -1,6 +1,7 @@
 class AdminController < BaseAdminController
 
   def index
+    @networks = Network.where('protips_count_cache > 0').order('protips_count_cache desc')
   end
 
   def teams
diff --git a/app/models/network.rb b/app/models/network.rb
@@ -240,4 +240,8 @@ def assign_members
     end
   end
 
+  def recent_protips
+    self.protips.where('created_at > ?', 1.week.ago).count
+  end
+
 end
diff --git a/app/views/admin/index.html.slim b/app/views/admin/index.html.slim
@@ -71,10 +71,10 @@
       h4 Pro tips created in networks in past week
     section
       ul.networks
-        -Network.where('protips_count_cache > 0').order('protips_count_cache desc').each do |network|
+        -@networks.each do |network|
           li.network
             span.name= link_to network.name, network_path(network)
-            span.created_at= network.protips.where('created_at > ?', 1.week.ago).count
+            span.created_at= network.recent_protips
 
   .widget.orange
     header
