crowdAI/crowdai

class LeaderboardNotificationJob < ApplicationJob
  queue_as :default

  def perform(submission)
    subscribed_participant_ids(submission).each do |participant_id|
      email_preference = EmailPreference.where(participant_id: participant_id).first
      if email_preference.receive_every_email
        LeaderboardNotificationMailer.new.sendmail(participant_id, submission.id)
      end
    end
  end

  def subscribed_participant_ids(submission)
    ids = admin_ids.concat(challenge_participant_ids(submission))
    ids.uniq
  end


  def admin_ids
    Participant.where(admin: true).pluck(:id)
  end


  def challenge_participant_ids(submission)
    ParticipantChallenge
        .joins("LEFT JOIN email_preferences on participant_challenges.participant_id = email_preferences.participant_id")
        .where(participant_challenges: { challenge_id: submission.challenge_id }, email_preferences: { my_leaderboard: true })
        .pluck(:participant_id)
  end


end