class DiaryEntriesController < ApplicationController
include UserMethods
+ include PaginationMethods
layout "site", :except => :rss
@params = params.permit(:display_name, :friends, :nearby, :language)
- @entries, @newer_entries_id, @older_entries_id = get_page_items(entries, [:user, :language])
+ @entries, @newer_entries_id, @older_entries_id = get_page_items(entries, :includes => [:user, :language])
end
def show
@params = params.permit(:display_name, :before, :after)
- @comments, @newer_comments_id, @older_comments_id = get_page_items(comments, [:user])
+ @comments, @newer_comments_id, @older_comments_id = get_page_items(comments, :includes => [:user])
end
private
@zoom = 12
end
end
-
- def get_page_items(items, includes)
- id_column = "#{items.table_name}.id"
- page_items = if params[:before]
- items.where("#{id_column} < ?", params[:before]).order(:id => :desc)
- elsif params[:after]
- items.where("#{id_column} > ?", params[:after]).order(:id => :asc)
- else
- items.order(:id => :desc)
- end
-
- page_items = page_items.limit(20)
- page_items = page_items.includes(includes)
- page_items = page_items.sort.reverse
-
- newer_items_id = page_items.first.id if page_items.count.positive? && items.exists?(["#{id_column} > ?", page_items.first.id])
- older_items_id = page_items.last.id if page_items.count.positive? && items.exists?(["#{id_column} < ?", page_items.last.id])
-
- [page_items, newer_items_id, older_items_id]
- end
end