44 lines
1.3 KiB
Ruby
44 lines
1.3 KiB
Ruby
|
class InboxComment < ApplicationRecord
|
||
|
|
validates_presence_of :user_id
|
||
|
|
validates_presence_of :feedback_comment_id
|
||
|
|
|
||
|
|
belongs_to :user
|
||
|
|
belongs_to :feedback_comment, class_name: 'Comment'
|
||
|
|
|
||
|
|
# Filters inbox comments by read and/or replied to and sorts by date
|
||
|
|
scope :find_by_filters, lambda { |filters|
|
||
|
|
read = case filters[:read]
|
||
|
|
when 'true' then true
|
||
|
|
when 'false' then false
|
||
|
|
else [true, false]
|
||
|
|
end
|
||
|
|
replied_to = case filters[:replied_to]
|
||
|
|
when 'true' then true
|
||
|
|
when 'false' then false
|
||
|
|
else [true, false]
|
||
|
|
end
|
||
|
|
direction = (filters[:date]&.upcase == "ASC" ? "created_at ASC" : "created_at DESC")
|
||
|
|
|
||
|
|
includes(feedback_comment: :pseud).
|
||
|
|
order(direction).
|
||
|
|
where(read: read, replied_to: replied_to)
|
||
|
|
}
|
||
|
|
|
||
|
|
scope :for_homepage, -> {
|
||
|
|
where(read: false).
|
||
|
|
order(created_at: :desc).
|
||
|
|
limit(ArchiveConfig.NUMBER_OF_ITEMS_VISIBLE_ON_HOMEPAGE)
|
||
|
|
}
|
||
|
|
|
||
|
|
# Gets the number of unread comments
|
||
|
|
def self.count_unread
|
||
|
|
where(read: false).count
|
||
|
|
end
|
||
|
|
|
||
|
|
# Remove comments that do not exist, were flagged as spam, or hidden by admin
|
||
|
|
def self.with_bad_comments_removed
|
||
|
|
joins("LEFT JOIN comments ON comments.id = inbox_comments.feedback_comment_id")
|
||
|
|
.where("comments.id IS NOT NULL AND comments.is_deleted = 0 AND comments.approved AND NOT comments.hidden_by_admin")
|
||
|
|
end
|
||
|
|
end
|