Eligable orders

applicable_recipients_for_issue_query.rb

module Quarterly
  class ApplicableRecipientsForIssueQuery
    def initialize(issue, relation=Spree::User)
      @issue    = issue
      @relation = relation
    end

    def call
      @relation
        .joins(:subscriptions)
        .merge(Subscription.active)
        .where("quarterly_subscriptions.plan_id = ?", @issue.plan_id)
        # .where("NOT EXISTS (SELECT so.id FROM spree_orders so
                  # JOIN spree_line_items sli ON so.id = sli.order_id
                  # WHERE sli.variant_id = ? AND so.user_id = spree_users.id)",
                  # @issue.product_variant.id)
    end

    def find_each(&block)
      call.find_each(&block)
    end
  end
end