Pastable version of Advanced search form & Named scopes

<pre class='prettyprint' language='ruby'>class Asset &lt; ActiveRecord::Base
	belongs_to :account
	belongs_to :asset_type
	belongs_to :deal_type
	belongs_to :neighborhood
	belongs_to :settlement
	belongs_to :user
	named_scope :showeb, :conditions =&gt; {:showeb =&gt; 2}
	named_scope :ordered,  :order =&gt; 'created_at DESC'
	named_scope :demo, :conditions =&gt; {:demo =&gt; 1}
	named_scope :image144, :conditions =&gt; [&quot;image_list != ?&quot;, &quot;null&quot;]
	named_scope :slideshow, :conditions =&gt; [&quot;slideshow != ?&quot;, &quot;null&quot;]
	named_scope :status, :conditions =&gt; {:status =&gt; 2}
	named_scope :price_from, lambda {|*args| {:conditions =&gt; [&quot;price_shekel &gt;=?&quot;, (args.first || 0)]} }
	named_scope :price_to, lambda {|*args| {:conditions =&gt; [&quot;price_shekel &lt;=?&quot;, (args.first || 9999999999)]} }
	named_scope :rooms_from, lambda {|*args| {:conditions =&gt; [&quot;rooms &gt;=?&quot;, (args.first || 0)]} }
	named_scope :rooms_to, lambda {|*args| {:conditions =&gt; [&quot;rooms &lt;=?&quot;, (args.first || 9999)]} }
	named_scope :settlement_filter, lambda { |settlement_ids| {:conditions =&gt; {:settlement_id =&gt; settlement_ids.to_i} } }  
	named_scope :neighborhood_filter, lambda { |neighborhood_ids| {:conditions =&gt; [&quot;neighborhood_id = ?&quot;, neighborhood_ids]} }  
	named_scope :assettype_filter, lambda { |assettype_ids| {:conditions =&gt; [&quot;assettype_id = ?&quot;, assettype_ids]} }
	named_scope :dealtype_filter, lambda { |dealtype_ids| {:conditions =&gt; [&quot;dealtype_id = ?&quot;, dealtype_ids]} } 
			
	def self.search(asset_params, page, records)
		main = showeb.ordered.demo.image144.slideshow.status
		if asset_params
			#asset_params = User input from advanced search form
			settlement_conditions = settlement_filter(asset_params[:settlement_id]) if asset_params[:settlement_id]
			neighborhood_conditions = neighborhood_filter(asset_params[:neighborhood_id]) if asset_params[:neighborhood_id]
			assettype_conditions = assettype_filter(asset_params[:assettype_id]) if asset_params[:assettype_id]
			dealtype_conditions = dealtype_filter(asset_params[:dealtype_id]) if asset_params[:dealtype_id]
			price_from_conditions = price_from(asset_params[:pr_from]) if asset_params[:pr_from]
			price_to_conditions = price_to(asset_params[:pr_to]) if asset_params[:pr_to]
			rooms_from_conditions = rooms_from(asset_params[:rm_from]) if asset_params[:rm_from]
			rooms_to_conditions = rooms_to(asset_params[:rm_to]) if asset_params[:rm_to]
			
			&lt;[Join all relevant named scopes according to User input ]&gt;
			
			main.&lt; insert relevant named scopes &gt;.paginate(:all, :page =&gt; page, :per_page =&gt; records)
		else 
			main.paginate(:all, :page =&gt; page, :per_page =&gt; records)
		end
	end
end</pre>
<a href="http://www.refactormycode.com/codes/788-advanced-search-form-named-scopes" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of Advanced search form & Named scopes