blah

meh.rb

CSV.open('referral_update.csv', 'wb') do |csv|
  MembershipAgreement.
    joins(:membership_agreement_statuses).
    where(membership_agreement_statuses: { status: 'sent', success: true }).
    where("membership_agreements.created_at < ?", Date.new(2016, 12, 28)).
    uniq.
    find_each do |membership_agreement|

    membership_agreement.all_primary_change_requests.group_by(&:location).each do |location, change_requests_by_location|
      TenantService.switch_tenant_with_location_uuid(location.uuid)

      change_requests_by_location.group_by(&:reservation_started_on).each do |start_date, change_requests_by_date|
        begin
          message_json = MembershipAgreements::ForSalesforceSerializer.new(
            membership_agreement: membership_agreement,
            location: location,
            start_date: start_date,
            change_requests: change_requests_by_date
          ).as_json.to_json

          csv << [membership_agreement.id_company_info.primary_member.email, membership_agreement.account_uuid, message_json]
        rescue Exception => e
          next  
        end
      end
    end
  end
end