Hey all, I keep getting the following error: You have a nil object when you didn''t expect it! You might have expected an instance of Array. The error occurred while evaluating nil.size Based on the current user, when they navigate to a page, I want to limit them to what they can see based on their site. Problem is there is no association between site and user table directly. A contact has_one user (user information is stored in current_user variable). A site has_many contacts. And a site has_many students, where students table has a foreign key of site_id. So there is a link between students and site, so when the current user navigates to students page, they can only see students from same site as them. I can do this by hard coding a number in a named_scope to only display students for the site of the current_user. But different users will belong to different sites so when logged in, the site their associated with will change. That''s the problem - to dynamically set that value in a named_scope. This is what I have: StudentsController def index_scoper if current_user.role_id == 8 super.site_staff_limit while current_user[:site_id] #The problem is the user table has no site_id. There is no direct link between the users table and sites table. However, there is a link between users and contacts and then site and contacts and then site and students, where students table has site_id. else super.with_state.with_site end end Student Model named_scope :site_staff_limit, lambda {|site_id| {:conditions => {:site_id => site_id}}} Thanks for any suggestions. -- View this message in context: http://old.nabble.com/dynamically-set-named_scope-based-on-current_user-tp27331346p27331346.html Sent from the RubyOnRails Users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Given those relationships, you should be able to use current_user.contact.site_id. On Jan 26, 5:01 pm, JohnMerlino <stoici...-YDxpq3io04c@public.gmane.org> wrote:> Hey all, > I keep getting the following error: > > You have a nil object when you didn''t expect it! > You might have expected an instance of Array. > The error occurred while evaluating nil.size > > Based on the current user, when they navigate to a page, I want to limit > them to what they can see based on their site. Problem is there is no > association between site and user table directly. A contact has_one user > (user information is stored in current_user variable). A site has_many > contacts. And a site has_many students, where students table has a foreign > key of site_id. So there is a link between students and site, so when the > current user navigates to students page, they can only see students from > same site as them. I can do this by hard coding a number in a named_scope to > only display students for the site of the current_user. But different users > will belong to different sites so when logged in, the site their associated > with will change. That''s the problem - to dynamically set that value in a > named_scope. This is what I have: > > StudentsController > > def index_scoper > if current_user.role_id == 8 > super.site_staff_limit while current_user[:site_id] #The problem is the > user table has no site_id. There is no direct link between the users table > and sites table. However, there is a link between users and contacts and > then site and contacts and then site and students, where students table has > site_id. > else > super.with_state.with_site > end > end > > Student Model > named_scope :site_staff_limit, lambda {|site_id| {:conditions => > {:site_id => site_id}}} > > Thanks for any suggestions. > > -- > View this message in context:http://old.nabble.com/dynamically-set-named_scope-based-on-current_us... > Sent from the RubyOnRails Users mailing list archive at Nabble.com.-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
site has many contacts through a polymorphic relationship: relationship between tables: users: contact_id contact: primary key, contactable_id, contactable_type site: primary key student: site_id User model belongs_to :contact Contact model has_one :user belongs_to :contactable, :polymorphic => true, :dependent => :destroy Site model has_many :contacts, :as => :contactable has_many :students Students model belongs_to :site This successfully limits the students by site: StudentsController def index_scoper if current_user.role_id == 8 super.site_staff_limit else super.with_state.with_site end end Students model named_scope :site_staff_limit, :conditions => {:site_id => 1} The problem is different users will belong to different sites, so they can only access student records of the site they belong to. I am having difficulty making that named_scope above dynamic enough to accomplish this. -- View this message in context: http://old.nabble.com/dynamically-set-named_scope-based-on-current_user-tp27331346p27339013.html Sent from the RubyOnRails Users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.