diff options
Diffstat (limited to 'app')
| -rw-r--r-- | app/controllers/admin_public_body_controller.rb | 14 | ||||
| -rw-r--r-- | app/views/admin_public_body/missing_scheme.rhtml | 10 |
2 files changed, 23 insertions, 1 deletions
diff --git a/app/controllers/admin_public_body_controller.rb b/app/controllers/admin_public_body_controller.rb index 0e5a8b213..85a654c05 100644 --- a/app/controllers/admin_public_body_controller.rb +++ b/app/controllers/admin_public_body_controller.rb @@ -4,7 +4,7 @@ # Copyright (c) 2007 UK Citizens Online Democracy. All rights reserved. # Email: francis@mysociety.org; WWW: http://www.mysociety.org/ # -# $Id: admin_public_body_controller.rb,v 1.19 2009-01-29 12:10:10 francis Exp $ +# $Id: admin_public_body_controller.rb,v 1.20 2009-03-10 10:33:52 tony Exp $ class AdminPublicBodyController < AdminController def index @@ -21,6 +21,18 @@ class AdminPublicBodyController < AdminController @public_bodies_by_tag = PublicBody.find_by_tag(@query) end + def missing_scheme + # There might be a way to do this in ActiveRecord, but I can't find it + @public_bodies = PublicBody.find_by_sql(" + SELECT a.id, a.name, a.url_name, COUNT(*) AS howmany + FROM public_bodies a JOIN info_requests r ON a.id = r.public_body_id + WHERE a.publication_scheme = '' + GROUP BY a.id, a.name, a.url_name + ORDER BY howmany DESC + LIMIT 20 + ") + end + def show @public_body = PublicBody.find(params[:id]) end diff --git a/app/views/admin_public_body/missing_scheme.rhtml b/app/views/admin_public_body/missing_scheme.rhtml new file mode 100644 index 000000000..3a24fc5cc --- /dev/null +++ b/app/views/admin_public_body/missing_scheme.rhtml @@ -0,0 +1,10 @@ +<% @title = 'Popular authorities without Publication Scheme' %> + +<h1><%=@title%></h1> + +<ol> + <% for public_body in @public_bodies %> + <li><%= public_body_both_links(public_body) %></li> + <% end %> +</ul> + |