Merge branch 'wdtk' of git.mysociety.org:/data/git/public/alaveteli into wdtk

1 files changed, 16 insertions, 0 deletions

diff --git a/app/models/request_classification.rb b/app/models/request_classification.rb
new file mode 100644
index 000000000..678b6cd16
--- /dev/null
+++ b/app/models/request_classification.rb
@@ -0,0 +1,16 @@
+class RequestClassification < ActiveRecord::Base
+    belongs_to :user
+
+    # return classification instances representing the top n
+    # users, with a 'cnt' attribute representing the number
+    # of classifications the user has made.
+    def RequestClassification.league_table(size, conditions=[])
+        find(:all, :select => 'user_id, count(*) as cnt',
+                                         :conditions => conditions,
+                                         :group => 'user_id',
+                                         :order => 'cnt desc',
+                                         :limit => size,
+                                         :include => :user)
+    end
+
+end
\ No newline at end of file