Nested resources and pagination

gistfile1.txt

route:
  resources :muscle_groups do
    resources :muscles
  end


controller index method:
  def index
    if params[:muscle_group_id]
      muscle_group_id = params[:muscle_group_id]
      @muscles = Muscle.paginate :page => params[:page], :order => 'created_at DESC', :conditions => ['muscle_group_id = ?', muscle_group_id]
    else
      @muscles = Muscle.paginate :page => params[:page], :order => 'created_at DESC'
    end

    respond_to do |format|
      format.html # index.html.erb
      format.xml  { render :xml => @muscles }
    end
  end

You could add this to your model:

def self.search(search, page)
  if !search.blank?
    search.chomp!
    paginate :page => page, :conditions => ['muscle_group_id like ?', "%#{search}%"], :order => 'created_at'
  end
end

Call in your controller:

@muscles = Muscle.search(params[:search], params[:page])

An else part is needed plus the use of like is overkill for an id column.

def self.search(search, page)
if !search.blank?
paginate :page => page, :conditions => ['muscle_group_id = ?', search], :order => 'name'
else
paginate :page => page, :order => 'name'
end
end