1 module ActionController
2 # === Action Pack pagination for Active Record collections
4 # The Pagination module aids in the process of paging large collections of
5 # Active Record objects. It offers macro-style automatic fetching of your
6 # model for multiple views, or explicit fetching for single actions. And if
7 # the magic isn't flexible enough for your needs, you can create your own
8 # paginators with a minimal amount of code.
10 # The Pagination module can handle as much or as little as you wish. In the
11 # controller, have it automatically query your model for pagination; or,
12 # if you prefer, create Paginator objects yourself.
14 # Pagination is included automatically for all controllers.
16 # For help rendering pagination links, see
17 # ActionView::Helpers::PaginationHelper.
19 # ==== Automatic pagination for every action in a controller
21 # class PersonController < ApplicationController
24 # paginate :people, :order => 'last_name, first_name',
30 # Each action in this controller now has access to a <tt>@people</tt>
31 # instance variable, which is an ordered collection of model objects for the
32 # current page (at most 20, sorted by last name and first name), and a
33 # <tt>@person_pages</tt> Paginator instance. The current page is determined
34 # by the <tt>params[:page]</tt> variable.
36 # ==== Pagination for a single action
39 # @person_pages, @people =
40 # paginate :people, :order => 'last_name, first_name'
43 # Like the previous example, but explicitly creates <tt>@person_pages</tt>
44 # and <tt>@people</tt> for a single action, and uses the default of 10 items
47 # ==== Custom/"classic" pagination
50 # @person_pages = Paginator.new self, Person.count, 10, params[:page]
51 # @people = Person.find :all, :order => 'last_name, first_name',
52 # :limit => @person_pages.items_per_page,
53 # :offset => @person_pages.current.offset
56 # Explicitly creates the paginator from the previous example and uses
57 # Paginator#to_sql to retrieve <tt>@people</tt> from the model.
60 unless const_defined?(:OPTIONS)
61 # A hash holding options for controllers using macro-style pagination
64 # The default options for pagination
67 :singular_name => nil,
81 DEFAULT_OPTIONS[:group] = nil
84 def self.included(base) #:nodoc:
86 base.extend(ClassMethods)
89 def self.validate_options!(collection_id, options, in_action) #:nodoc:
90 options.merge!(DEFAULT_OPTIONS) {|key, old, new| old}
92 valid_options = DEFAULT_OPTIONS.keys
93 valid_options << :actions unless in_action
95 unknown_option_keys = options.keys - valid_options
96 raise ActionController::ActionControllerError,
97 "Unknown options: #{unknown_option_keys.join(', ')}" unless
98 unknown_option_keys.empty?
100 options[:singular_name] ||= ActiveSupport::Inflector.singularize(collection_id.to_s)
101 options[:class_name] ||= ActiveSupport::Inflector.camelize(options[:singular_name])
104 # Returns a paginator and a collection of Active Record model instances
105 # for the paginator's current page. This is designed to be used in a
106 # single action; to automatically paginate multiple actions, consider
107 # ClassMethods#paginate.
110 # <tt>:singular_name</tt>:: the singular name to use, if it can't be inferred by singularizing the collection name
111 # <tt>:class_name</tt>:: the class name to use, if it can't be inferred by
112 # camelizing the singular name
113 # <tt>:per_page</tt>:: the maximum number of items to include in a
114 # single page. Defaults to 10
115 # <tt>:conditions</tt>:: optional conditions passed to Model.find(:all, *params) and
117 # <tt>:order</tt>:: optional order parameter passed to Model.find(:all, *params)
118 # <tt>:order_by</tt>:: (deprecated, used :order) optional order parameter passed to Model.find(:all, *params)
119 # <tt>:joins</tt>:: optional joins parameter passed to Model.find(:all, *params)
121 # <tt>:join</tt>:: (deprecated, used :joins or :include) optional join parameter passed to Model.find(:all, *params)
123 # <tt>:include</tt>:: optional eager loading parameter passed to Model.find(:all, *params)
125 # <tt>:select</tt>:: :select parameter passed to Model.find(:all, *params)
127 # <tt>:count</tt>:: parameter passed as :select option to Model.count(*params)
129 # <tt>:group</tt>:: :group parameter passed to Model.find(:all, *params). It forces the use of DISTINCT instead of plain COUNT to come up with the total number of records
131 def paginate(collection_id, options={})
132 Pagination.validate_options!(collection_id, options, true)
133 paginator_and_collection_for(collection_id, options)
136 # These methods become class methods on any controller
138 # Creates a +before_filter+ which automatically paginates an Active
139 # Record model for all actions in a controller (or certain actions if
140 # specified with the <tt>:actions</tt> option).
142 # +options+ are the same as PaginationHelper#paginate, with the addition
144 # <tt>:actions</tt>:: an array of actions for which the pagination is
145 # active. Defaults to +nil+ (i.e., every action)
146 def paginate(collection_id, options={})
147 Pagination.validate_options!(collection_id, options, false)
149 before_filter :create_paginators_and_retrieve_collections
150 OPTIONS[self] ||= Hash.new
151 OPTIONS[self][collection_id] = options
156 def create_paginators_and_retrieve_collections #:nodoc:
157 Pagination::OPTIONS[self.class].each do |collection_id, options|
158 next unless options[:actions].include? action_name if
161 paginator, collection =
162 paginator_and_collection_for(collection_id, options)
164 paginator_name = "@#{options[:singular_name]}_pages"
165 self.instance_variable_set(paginator_name, paginator)
167 collection_name = "@#{collection_id.to_s}"
168 self.instance_variable_set(collection_name, collection)
172 # Returns the total number of items in the collection to be paginated for
173 # the +model+ and given +conditions+. Override this method to implement a
175 def count_collection_for_pagination(model, options)
176 model.count(:conditions => options[:conditions],
177 :joins => options[:join] || options[:joins],
178 :select => (options[:group] ? "DISTINCT #{options[:group]}" : options[:count]))
181 # Returns a collection of items for the given +model+ and +options[conditions]+,
182 # ordered by +options[order]+, for the current page in the given +paginator+.
183 # Override this method to implement a custom finder.
184 def find_collection_for_pagination(model, options, paginator)
185 model.find(:all, :conditions => options[:conditions],
186 :order => options[:order_by] || options[:order],
187 :joins => options[:join] || options[:joins], :include => options[:include],
188 :select => options[:select], :limit => options[:per_page],
189 :group => options[:group], :offset => paginator.current.offset)
192 protected :create_paginators_and_retrieve_collections,
193 :count_collection_for_pagination,
194 :find_collection_for_pagination
196 def paginator_and_collection_for(collection_id, options) #:nodoc:
197 klass = options[:class_name].constantize
198 page = params[options[:parameter]]
199 count = count_collection_for_pagination(klass, options)
200 paginator = Paginator.new(self, count, options[:per_page], page)
201 collection = find_collection_for_pagination(klass, options, paginator)
203 return paginator, collection
206 private :paginator_and_collection_for
208 # A class representing a paginator for an Active Record collection.
212 # Creates a new Paginator on the given +controller+ for a set of items
213 # of size +item_count+ and having +items_per_page+ items per page.
214 # Raises ArgumentError if items_per_page is out of bounds (i.e., less
215 # than or equal to zero). The page CGI parameter for links defaults to
216 # "page" and can be overridden with +page_parameter+.
217 def initialize(controller, item_count, items_per_page, current_page=1)
218 raise ArgumentError, 'must have at least one item per page' if
221 @controller = controller
222 @item_count = item_count || 0
223 @items_per_page = items_per_page
226 self.current_page = current_page
228 attr_reader :controller, :item_count, :items_per_page
230 # Sets the current page number of this paginator. If +page+ is a Page
231 # object, its +number+ attribute is used as the value; if the page does
232 # not belong to this Paginator, an ArgumentError is raised.
233 def current_page=(page)
235 raise ArgumentError, 'Page/Paginator mismatch' unless
236 page.paginator == self
239 @current_page_number = has_page_number?(page) ? page : 1
242 # Returns a Page object representing this paginator's current page.
244 @current_page ||= self[@current_page_number]
246 alias current :current_page
248 # Returns a new Page representing the first page in this paginator.
250 @first_page ||= self[1]
252 alias first :first_page
254 # Returns a new Page representing the last page in this paginator.
256 @last_page ||= self[page_count]
258 alias last :last_page
260 # Returns the number of pages in this paginator.
262 @page_count ||= @item_count.zero? ? 1 :
263 (q,r=@item_count.divmod(@items_per_page); r==0? q : q+1)
266 alias length :page_count
268 # Returns true if this paginator contains the page of index +number+.
269 def has_page_number?(number)
270 number >= 1 and number <= page_count
273 # Returns a new Page representing the page with the given index
276 @pages[number] ||= Page.new(self, number)
279 # Successively yields all the paginator's pages to the given block.
281 page_count.times do |n|
286 # A class representing a single page in a paginator.
290 # Creates a new Page for the given +paginator+ with the index
291 # +number+. If +number+ is not in the range of valid page numbers or
292 # is not a number at all, it defaults to 1.
293 def initialize(paginator, number)
294 @paginator = paginator
295 @number = number.to_i
296 @number = 1 unless @paginator.has_page_number? @number
298 attr_reader :paginator, :number
301 # Compares two Page objects and returns true when they represent the
302 # same page (i.e., their paginators are the same and they have the
305 return false if page.nil?
306 @paginator == page.paginator and
307 @number == page.number
310 # Compares two Page objects and returns -1 if the left-hand page comes
311 # before the right-hand page, 0 if the pages are equal, and 1 if the
312 # left-hand page comes after the right-hand page. Raises ArgumentError
313 # if the pages do not belong to the same Paginator object.
315 raise ArgumentError unless @paginator == page.paginator
316 @number <=> page.number
319 # Returns the item offset for the first item in this page.
321 @paginator.items_per_page * (@number - 1)
324 # Returns the number of the first item displayed.
329 # Returns the number of the last item displayed.
331 [@paginator.items_per_page * @number, @paginator.item_count].min
334 # Returns true if this page is the first page in the paginator.
336 self == @paginator.first
339 # Returns true if this page is the last page in the paginator.
341 self == @paginator.last
344 # Returns a new Page object representing the page just before this
345 # page, or nil if this is the first page.
347 if first? then nil else @paginator[@number - 1] end
350 # Returns a new Page object representing the page just after this
351 # page, or nil if this is the last page.
353 if last? then nil else @paginator[@number + 1] end
356 # Returns a new Window object for this page with the specified
358 def window(padding=2)
359 Window.new(self, padding)
362 # Returns the limit/offset array for this page.
364 [@paginator.items_per_page, offset]
367 def to_param #:nodoc:
372 # A class for representing ranges around a given page.
374 # Creates a new Window object for the given +page+ with the specified
376 def initialize(page, padding=2)
377 @paginator = page.paginator
379 self.padding = padding
381 attr_reader :paginator, :page
383 # Sets the window's padding (the number of pages on either side of the
385 def padding=(padding)
386 @padding = padding < 0 ? 0 : padding
387 # Find the beginning and end pages of the window
388 @first = @paginator.has_page_number?(@page.number - @padding) ?
389 @paginator[@page.number - @padding] : @paginator.first
390 @last = @paginator.has_page_number?(@page.number + @padding) ?
391 @paginator[@page.number + @padding] : @paginator.last
393 attr_reader :padding, :first, :last
395 # Returns an array of Page objects in the current window.
397 (@first.number..@last.number).to_a.collect! {|n| @paginator[n]}