@title = t ".in_language_title", :language => Language.find(params[:language]).english_name
entries = entries.where(:language_code => params[:language])
else
+ candidate_codes = preferred_languages.flat_map(&:candidates).uniq.map(&:to_s)
+ @languages = Language.where(:code => candidate_codes).in_order_of(:code, candidate_codes)
@title = t ".title"
end
end
@params = params.permit(:display_name, :friends, :nearby, :language)
- @entries = if params[:before]
- entries.where("diary_entries.id < ?", params[:before]).order(:id => :desc)
- elsif params[:after]
- entries.where("diary_entries.id > ?", params[:after]).order(:id => :asc)
- else
- entries.order(:id => :desc)
- end
-
- @entries = @entries.limit(20)
- @entries = @entries.includes(:user, :language)
- @entries = @entries.sort.reverse
-
- @newer_entries = @entries.count.positive? && entries.exists?(["diary_entries.id > ?", @entries.first.id])
- @older_entries = @entries.count.positive? && entries.exists?(["diary_entries.id < ?", @entries.last.id])
+ @entries, @newer_entries_id, @older_entries_id = get_page_items(entries, [:user, :language])
end
def show
entries = @user.diary_entries
entries = entries.visible unless can? :unhide, DiaryEntry
- @entry = entries.where(:id => params[:id]).first
+ @entry = entries.find_by(:id => params[:id])
if @entry
@title = t ".title", :user => params[:display_name], :title => @entry.title
@comments = can?(:unhidecomment, DiaryEntry) ? @entry.comments : @entry.visible_comments
def new
@title = t ".title"
- default_lang = current_user.preferences.where(:k => "diary.default_language").first
+ default_lang = current_user.preferences.find_by(:k => "diary.default_language")
lang_code = default_lang ? default_lang.v : current_user.preferred_language
@diary_entry = DiaryEntry.new(entry_params.merge(:language_code => lang_code))
set_map_location
@diary_entry.user = current_user
if @diary_entry.save
- default_lang = current_user.preferences.where(:k => "diary.default_language").first
+ default_lang = current_user.preferences.find_by(:k => "diary.default_language")
if default_lang
default_lang.v = @diary_entry.language_code
default_lang.save!
def comments
@title = t ".title", :user => @user.display_name
- comments = DiaryComment.where(:users => @user)
+ comments = DiaryComment.where(:user => @user)
comments = comments.visible unless can? :unhidecomment, DiaryEntry
- @params = params.permit(:display_name)
-
- @comments = if params[:before]
- comments.where("diary_comments.id < ?", params[:before]).order(:id => :desc)
- elsif params[:after]
- comments.where("diary_comments.id > ?", params[:after]).order(:id => :asc)
- else
- comments.order(:id => :desc)
- end
+ @params = params.permit(:display_name, :before, :after)
- @comments = @comments.limit(20)
- @comments = @comments.includes(:user)
- @comments = @comments.sort.reverse
-
- @newer_comments = @comments.count.positive? && comments.exists?(["diary_comments.id > ?", @comments.first.id])
- @older_comments = @comments.count.positive? && comments.exists?(["diary_comments.id < ?", @comments.last.id])
+ @comments, @newer_comments_id, @older_comments_id = get_page_items(comments, [: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