rendered paste body def all_pulls # move this off into static level business query_map = Hash.new query_map["pull_group_query"] = "select p.* from pulls p, pull_groups pg where p.pull_group_id = pg.id" query_map["pull_group_title"] = "pg.title" query_map["pull_group_date"] = "pg.date" query = query_map.has_key?(params[:sort]) ? query_map["pull_group_query"] : "select * from pulls" if params[:sort] order = "order by #{query_map.has_key?(params[:sort]) ? query_map[params[:sort]] : params[:sort]} #{params[:order]}" end @pull_pages, @pulls = paginate_collection Pull.find_by_sql("#{query} #{order}"), :page => params[:page] render_action :list_pulls end