Sha256: ee7c1a972eb7e4934c8af2bdd19e927e85f9eea5bb071cb7b45583466ee06606
Contents?: true
Size: 1.95 KB
Versions: 9
Compression:
Stored size: 1.95 KB
Contents
module MyForum
class Forum < ActiveRecord::Base
belongs_to :category
has_many :topics
has_many :posts
def has_unread_posts?(current_user)
return false unless current_user
latest_post_ids = self.topics.where('latest_post_created_at >= ?', current_user.created_at).pluck(:latest_post_id)
read_log = []
read_log = LogReadMark.where("user_id = ? AND post_id IN (?)", current_user.id, latest_post_ids).pluck(:post_id) unless latest_post_ids.blank?
!(latest_post_ids - read_log).empty?
end
# Forum index page
def topics_with_latest_post_info(page: 0, per_page: 30)
Topic.paginate_by_sql("
SELECT
my_forum_topics.*,
my_forum_topics.latest_post_created_at AS last_post_time,
my_forum_topics.latest_post_login AS last_post_user_login
FROM my_forum_topics
WHERE my_forum_topics.forum_id = #{self.id} AND my_forum_topics.deleted IS FALSE
ORDER BY my_forum_topics.pinned DESC, my_forum_topics.latest_post_created_at DESC
", page: page, per_page: per_page)
end
def self.unread_topics_with_latest_post_info(user_id:, page: 0, per_page: 30)
log_topic_ids = LogReadMark.where(user_id: user_id).pluck(:topic_id)
log_topic_ids = [0] if log_topic_ids.empty?
Topic.paginate_by_sql("
SELECT
my_forum_topics.*,
my_forum_topics.latest_post_created_at AS last_post_time,
my_forum_topics.latest_post_login AS last_post_user_login
FROM my_forum_topics
WHERE my_forum_topics.id NOT IN (#{log_topic_ids.join(',')}) AND my_forum_topics.deleted IS FALSE
ORDER BY my_forum_topics.id DESC
", page: page, per_page: per_page)
end
def unread_topics_with_user
log_topic_ids = LogReadMark.where(user_id: current_user.id).pluck(:topic_id)
Topic.where('id NOT IN (?)', log_topic_ids).order('updated_at DESC').paginate(:page => params[:page], :per_page => 30)
end
end
end
Version data entries
9 entries across 9 versions & 1 rubygems