Cannot get simple search by date to work with will_paginate

rubyonrails-talk
#1

View:

<% form_tag attendances_path, :method => 'get' do %>
  <p>Search attendances by date:
    <%= date_select :search, params[:search], :use_short_month =>
true, :order => [:month, :day, :year] %>
    <%= submit_tag 'Search', :name => nil %>
  </p>
<% end %>

Model:

def self.search(search, page)
    paginate :per_page => 10, :page => page,
             :conditions => ['date like ?', "%#{search}%"],
             :order => 'date desc'
end

Controller:

def index
    @page_title = 'Attendances'
    @attendances = @school.attendances.search(params[:search],
params[:page])
end

Why is this not working? Thanks for any help!

#2

What isn't working? What's the error? What is the expected behaviour?
How does the actual behaviour differ from the expected?

Is it necessary for you to define a search method in your model,
rather than just call @school.paginate(:all, :conditions => blah)?

Adam

#3

I guess I don't need it a search method so I added this to my
controller:

@attendances = @school.attendances.paginate :per_page => 10, :page =>
params[:page],
                                                :conditions => ['date
like ?', "%#{params[:search]}%"],
                                                :order => 'date desc'

My intended behavior is to simply search attendances by an exact date.
I don't get an error but no records show up even if I search the
correct date. Also, is there a way to have a cleaner url when
searching that this?

domain.com/attendances?search[(2i)]=8&search[(3i
%29%5D=8&search%5B%281i%29%5D=2007

Thanks for the help.

#4

I really like blinksale's invoice filter functionality. Is there a
plugin for something like that?

#5

blinksale's invoice filter looks like it's using a bunch of custom
routes and then parsing the parameters. Read up on rails routes to
figure out how to implement these types of urls.

And your conditions look wrong. If you're searching by date, and the
date column in your database is a date type, then you shouldn't be
using 'like'. You should be using date comparison operators, such as
=, <, >, <=, >=.

Adam

#6

Got it to work! Thanks for your help.