gistfile1.txt

require File.expand_path('../../config/environment', __FILE__)
require 'csv'

intermediaries = Person.intermediary.asc(:name).to_a
intermediaries.each do |person|
  company = person.current_company
  latest_activity =
    if company.present?
      company.activities.desc(:created_at).where(:kind.in => Activity::FOLLOWUPABLE_KINDS).first
    else
      nil
    end

  puts CSV.generate_line([
    person.name.strip,
    person.intermediary_type,
    person.intermediary_region,
    company.try(:name),
    person.partner_names.join(', '),
    latest_activity.try(:date).try(:strftime, '%Y-%m-%d'),
    latest_activity.try(:notes),
    latest_activity.try(:follow_up_date).try(:strftime, '%Y-%m-%d')
  ])
end