5ef0f43636
* Added limited role * Nit fix * Updated tetss * Added spec tests * Attempt at 100% code coverage * Rollback DB migration * Revert timestamp
42 lines
1.3 KiB
Ruby
42 lines
1.3 KiB
Ruby
module Admin
|
|
class ModeratorsQuery
|
|
DEFAULT_OPTIONS = {
|
|
state: :trusted
|
|
}.with_indifferent_access.freeze
|
|
|
|
POTENTIAL_ROLE_NAMES = %i[comment_suspended limited suspended trusted warned].freeze
|
|
|
|
def self.call(relation: User.all, options: {})
|
|
options = DEFAULT_OPTIONS.merge(options)
|
|
state, search = options.values_at(:state, :search)
|
|
role_id = Role.find_by(name: state)&.id
|
|
|
|
relation = if state.to_s == "potential"
|
|
relation.where(
|
|
"id NOT IN (SELECT user_id FROM users_roles WHERE role_id IN (?))",
|
|
potential_role_ids,
|
|
).order("users.comments_count" => :desc)
|
|
elsif role_id.present?
|
|
relation.joins(:roles)
|
|
.where(users_roles: { role_id: role_id })
|
|
else
|
|
User.none
|
|
end
|
|
|
|
relation = search_relation(relation, search) if search.presence
|
|
|
|
relation
|
|
end
|
|
|
|
def self.potential_role_ids
|
|
@potential_role_ids ||= Role.where(name: POTENTIAL_ROLE_NAMES).select(:id)
|
|
end
|
|
|
|
def self.search_relation(relation, search)
|
|
relation.where(
|
|
"users.username ILIKE :search OR users.name ILIKE :search",
|
|
search: "%#{search}%",
|
|
)
|
|
end
|
|
end
|
|
end
|