I have a Store model that has_many Products. I need to allow the users to filter on certain conditions in the products. For example, products at the store that cost more than $50. I am planning on getting the parameter in the controller and modifying the product collection. I have experimented with a few things, but I think there is probably an elegant solution out there. I want to be able to filter and then call the collection using: store.products, since this is in a shared view. I have tried replacing the products with a new collection, but rails automatically modifies the database (store.products = filtered_products). I dont want it to save as this is just going to be a read. Is there an easy way that I can pass conditions in store model to get the products I want in the controller and then call the collection using store.products in the view?
Do you mean there are products of different types ( models ) quite confused ??
There are not different models for products. Product is one model and it has fields for price, etc.. I want to filter out products based on price:
:conditions=>"price>50"
Sandip Ransing wrote:
You're probably looking for named scopes. They can be used to add conditions to an association, like store.products, on the fly.
For instance, if you have these named scopes on your Product model:
named_scope :price_less_than, lambda { |p| { :conditions => ['price <= ?', p] } } named_scope :price_more_than, lambda { |p| { :conditions => ['price
= ?', p] } }
... and a seach form with two fields, :price_max and :price_min, then this code will let you filter your results:
proxy = store.products proxy = proxy.price_less_than(params[:price_max]) unless params [:price_max].blank? proxy = proxy.price_more_than(params[:price_min]) unless params [:price_min].blank?
...then you can use proxy anywhere you would have used store.products (feed it to will_paginate, etc). If you have very specific conditions that would clutter up the model, you can also use .scoped to create an anonymous scope.
The benefit here is that the actual records aren't retrieved until you try to actually access elements of proxy, for instance by iterating over it.
--Matt Jones
