class DiaryEntriesController < ApplicationController
+ include UserMethods
+
layout "site", :except => :rss
before_action :authorize_web
elsif params[:friends]
if current_user
@title = t ".title_friends"
- entries = DiaryEntry.where(:user_id => current_user.friends)
+ entries = DiaryEntry.where(:user => current_user.friends)
else
require_user
return
elsif params[:nearby]
if current_user
@title = t ".title_nearby"
- entries = DiaryEntry.where(:user_id => current_user.nearby)
+ entries = DiaryEntry.where(:user => current_user.nearby)
else
require_user
return
@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
- conditions = { :user_id => @user }
+ comments = DiaryComment.where(:user => @user)
+ comments = comments.visible unless can? :unhidecomment, DiaryEntry
- conditions[:visible] = true unless can? :unhidecomment, DiaryEntry
+ @params = params.permit(:display_name, :before, :after)
- @comment_pages, @comments = paginate(:diary_comments,
- :conditions => conditions,
- :order => "created_at DESC",
- :per_page => 20)
- @page = (params[:page] || 1).to_i
+ @comments, @newer_comments_id, @older_comments_id = get_page_items(comments, [:user])
end
private
@lon = @diary_entry.longitude
@lat = @diary_entry.latitude
@zoom = 12
- elsif current_user.home_lat.nil? || current_user.home_lon.nil?
+ elsif !current_user.home_location?
@lon = params[:lon] || -0.1
@lat = params[:lat] || 51.5
@zoom = params[:zoom] || 4
@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