77 lines
1.8 KiB
Ruby
77 lines
1.8 KiB
Ruby
class Post < ApplicationRecord
|
|
include Taggable
|
|
include PgSearch::Model
|
|
|
|
pg_search_scope :search_by_query,
|
|
against: [:title, :description, :tags],
|
|
ignoring: :accents,
|
|
using: {
|
|
tsearch: {
|
|
prefix: true,
|
|
tsvector_column: 'tsv'
|
|
}
|
|
}
|
|
|
|
attr_reader :member_id
|
|
|
|
belongs_to :category
|
|
belongs_to :user
|
|
belongs_to :organization, optional: true
|
|
has_many :transfers
|
|
has_many :movements, through: :transfers
|
|
has_many :events, dependent: :destroy
|
|
|
|
delegate :name, to: :category, prefix: true, allow_nil: true
|
|
|
|
default_scope { order("posts.updated_at DESC") }
|
|
scope :by_category, ->(cat) {
|
|
where(category_id: cat) if cat
|
|
}
|
|
scope :by_organization, ->(org) {
|
|
where(organization_id: org) if org
|
|
}
|
|
scope :of_active_members, -> {
|
|
with_member.where("members.active")
|
|
}
|
|
scope :with_member, -> {
|
|
joins("JOIN members USING (user_id, organization_id)").
|
|
select("posts.*, members.member_uid as member_uid")
|
|
}
|
|
scope :active, -> {
|
|
where(active: true)
|
|
}
|
|
scope :from_last_week, -> {
|
|
where(created_at: (1.week.ago.beginning_of_day...DateTime.now.end_of_day))
|
|
}
|
|
|
|
validates :title, presence: true
|
|
|
|
def as_indexed_json(*)
|
|
as_json(only: [:title, :description, :tags, :organization_id])
|
|
end
|
|
|
|
def to_s
|
|
title
|
|
end
|
|
|
|
# will read the member_uid if it has been returned by the query, otherwise
|
|
# don't complain and return nil.
|
|
#
|
|
# To ensure the presence of the attribute, use the `with_member` scope
|
|
def member_uid
|
|
read_attribute(:member_uid) if has_attribute?(:member_uid)
|
|
end
|
|
|
|
def active?
|
|
user && user.member(organization).try(:active) && active
|
|
end
|
|
|
|
def member
|
|
@member ||= Member.find_by(user_id: user_id, organization_id: organization_id)
|
|
end
|
|
|
|
def rendered_description
|
|
RDiscount.new(description || '', :autolink)
|
|
end
|
|
end
|