#111 Advanced Search Form (revised)

Nov 17, 2011 | 6 minutes | Views, Forms, Search

It is often best to use a GET request when submitting a search form, however if it is an advanced search form with a lot of fields then this may not be ideal. Here I show how to create a search resource to handle this.

Click to Play Video ▶

Download:
source codeProject Files in Zip (94.9 KB)
mp4Full Size H.264 Video (17 MB)
m4vSmaller H.264 Video (6.99 MB)
webmFull Size VP8 Video (10.8 MB)
ogvFull Size Theora Video (13.5 MB)

Browse Source Code

Resources

          bash
        
rails g model search keywords:string category_id:integer min_price:decimal max_price:decimal
rake db:migrate
rails g controller searches

          config/routes.rb
        
resources :searches

          searches_controller.rb
        
def new
  @search = Search.new
end

def create
  @search = Search.create!(params[:search])
  redirect_to @search
end

def show
  @search = Search.find(params[:id])
end

          models/search.rb
        
def products
  @products ||= find_products
end

private

def find_products
  products = Product.order(:name)
  products = products.where("name like ?", "%#{keywords}%") if keywords.present?
  products = products.where(category_id: category_id) if category_id.present?
  products = products.where("price >= ?", min_price) if min_price.present?
  products = products.where("price <= ?", max_price) if max_price.present?
  products
end

          products/index.html.erb
        
<p><%= link_to "Advanced Search", new_search_path %></p>

          searches/new.html.erb
        
<h1>Advanced Search</h1>

<%= form_for @search do |f| %>
  <div class="field">
    <%= f.label :keywords %><br />
    <%= f.text_field :keywords %>
  </div>
  <div class="field">
    <%= f.label :category_id %><br />
    <%= f.collection_select :category_id, Category.order(:name), :id, :name, include_blank: true %>
  </div>
  <div class="field">
    <%= f.label :min_price, "Price Range" %><br />
    <%= f.text_field :min_price, size: 10 %> -
    <%= f.text_field :max_price, size: 10 %>
  </div>
  <div class="actions"><%= f.submit "Search" %></div>
<% end %>

          searches/show.html.erb
        
<h1>Search Results</h1>

<%= render @search.products %>