From a9002cc8e749df6f5961acab8e3e61fd21987fc1 Mon Sep 17 00:00:00 2001 From: David Cabo Date: Wed, 7 Sep 2011 22:14:36 +0200 Subject: Hide Internal Admin from user, but using SQL conditions instead, fixes #173 --- app/controllers/public_body_controller.rb | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'app/controllers/public_body_controller.rb') diff --git a/app/controllers/public_body_controller.rb b/app/controllers/public_body_controller.rb index bcd7b334c..79ca58d13 100644 --- a/app/controllers/public_body_controller.rb +++ b/app/controllers/public_body_controller.rb @@ -91,7 +91,10 @@ class PublicBodyController < ApplicationController @tag = params[:tag] @locale = self.locale_from_params() - locale_condition = "(upper(public_body_translations.name) LIKE upper(?) OR upper(public_body_translations.notes) LIKE upper (?)) AND public_body_translations.locale = ?" + locale_condition = "(upper(public_body_translations.name) LIKE upper(?) + OR upper(public_body_translations.notes) LIKE upper (?)) + AND public_body_translations.locale = ? + AND public_bodies.id <> #{PublicBody.internal_admin_body.id}" if @tag.nil? or @tag == "all" @tag = "all" conditions = [locale_condition, @query, @query, @locale] @@ -129,7 +132,6 @@ class PublicBodyController < ApplicationController :conditions => conditions, :joins => :translations ) - @public_bodies.delete(PublicBody.internal_admin_body) # Don't show the Internal Admin body to the user render :template => "public_body/list" end end -- cgit v1.2.3