step 1 add_column
首先rails g migration add_category_to_job
在新增的db/migrate/2017xxxx_create_category_to_job.rb文件中添加
def change
add_column :jobs, :category_name, :string, default: "工程師"
end```
然后`rake db:migrate`
###step 2 GEM
在Gemfile中添加
gem 'ransack'
gem 'paginate'
gem 'paginate-bootstrap
然后 `bundle install`;
###step 3 搜索框
在Navbar增加一個搜索框
<%= form_tag search_jobs_path, :method => :get, class: "navbar-form navbar-right" do %>
<div class="input-group">
<input type="text" class="form-control" name="q" placeholder="搜索職位、公司" value="<%= params[:q] %>">
<div class="input-group-btn">
<button class="btn btn-default" type="submit">
<i class="fa fa-search" aria-hidden="true"></i>
</button>
</div>
</div>
<% end %>
###step 4 控制器
在jobs_controller中增加相應(yīng)的函數(shù)
def search
if @query_string.present?
search_result = Job.ransack(@search_criteria).result(distinct: true)
@jobs = search_result.paginate(:page => params[:page], per_page: 10 )
puts @jobs
else
@jobs = Job.publish.recent.paginate(page: params[:page], per_page: 10)
puts @jobs
end
end
在`private`下面添加
def validate_search_key
@query_string = params[:q].gsub(/\|'|/|?/, "") if params[:q].present?
@search_criteria = search_criteria(@query_string)
end
def search_criteria(query_string)
{ :title_or_description_or_contact_email_or_location_or_company_or_category_cont => query_string }
end
#注意: 這里搜索是會報錯,是因為沒有對應(yīng)的view顯示搜索結(jié)果（圖中標注文字可以忽略）
###step 5 VIEW
生成搜索結(jié)果所需要的對應(yīng)頁面 `touch app/views/jobs/search_result.html.erb`
<% if @jobs.length > 0 %>
<table class="table table-hover table-boldered table-striped custab">
<thead>
<tr>
<th>職位名稱</th>
<th>工作類型</th>
<th>薪金</th>
<th>公司名稱</th>
<th>公司地點</th>
<th>發(fā)布時間</th>
</tr>
</thead>
<tbody>
<% @jobs.each do |job| %>
<tr>
<td> <%= link_to(job.title, job_path(job)) %></td>
<td><%= job.category %></td>
<td> <span class="label label-success"><%= job.wage_lower_bound %>K - <%= job.wage_upper_bound %>K</span></td>
<td><%= link_to(job.company, '/jobs/search?utf8=?&q=' + job.company) %></td>
<td><%= job.location %></td>
<td><%= job.created_at %></td>
</tr>
<% end %>
</tbody>
</table>
<% else %>
<h4 class="text-center">沒有相關(guān)職位崔列，嘗試搜索其他的關(guān)鍵字</h4>
<div class="text-center">
<a class="btn btn-lg btn-info" href="/jobs">瀏覽職位</a>
</div>
<% end %>```
重新搜索試試看中狂？??
