discourse-topic-voting/lib/discourse_topic_voting/topic_query_extension.rb

22 lines
647 B
Ruby

# frozen_string_literal: true
module DiscourseTopicVoting
module TopicQueryExtension
def list_voted_by(user)
create_list(:user_topics) do |topics|
topics.joins(
"INNER JOIN topic_voting_votes ON topic_voting_votes.topic_id = topics.id",
).where("topic_voting_votes.user_id = ?", user.id)
end
end
def list_votes
create_list(:votes, unordered: true) do |topics|
topics.joins(
"LEFT JOIN topic_voting_topic_vote_count dvtvc ON dvtvc.topic_id = topics.id",
).order("COALESCE(dvtvc.votes_count,'0')::integer DESC, topics.bumped_at DESC")
end
end
end
end