mirror of
https://gh.wpcy.net/https://github.com/discourse/discourse.git
synced 2026-05-11 03:10:34 +08:00
21 lines
647 B
Ruby
21 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
|
