class Buyer < ActiveRecord::Base
  has_many :wins
  has_many :pledges
  has_many :payments

@buyers = Buyer.joins("LEFT OUTER JOIN pledges on buyers.id = pledges.buyer_id")
                 .where(event_id: @event.id)
                 .select("buyers.*, sum(pledges.amount) as pledges_total")
                 .group('buyers.id')
                 .order('buyers.last_name')

@buyers = Buyer.joins("LEFT OUTER JOIN wins on buyers.id = wins.buyer_id")
                 .joins("LEFT OUTER JOIN pledges on buyers.id = pledges.buyer_id")
                 .joins("LEFT OUTER JOIN payments on buyers.id = payments.buyer_id")
                 .where(event_id: @event.id)
                 .select("buyers.*, sum(wins.price) as wins_total, sum(pledges.amount) as pledges_total, sum(payments.amount) as payments_total")
                 .group('buyers.id')
                 .order('buyers.last_name')