Analise do comportamento dos clientes que cancelaram Plano Recorrente em 2019

microgym_cancelled_data.rb

file = File.open('/tmp/cancel.csv', 'w')
file << "Mes de cancelamento, cliente, Modalidade, Unidade, Compras apos cancelar, Ultimo Plano comprado, Mes da ultima compra"

cancelled = Purchase.cancelled.recurrency.distinct(:person_id).joins(:plan).where("cancelled >= ?", Date.current.beginning_of_year)

cancelled.find_each do |purchase|
  person = purchase.person

  if person.purchases.where("created_at > ?", purchase.cancelled).exists?
    new_purchases = person.purchases.where("created_at >= ?", purchase.cancelled)
    qtd           = new_purchases.count
    last_purchase = new_purchases.last.plan.name
    last_buy_at   = new_purchases.last.created_at
  end

  file << "\n #{purchase.cancelled.try(:month)}, #{person.id}, #{purchase.microgym}, #{purchase.location.name}, #{qtd}, #{last_purchase}, #{last_buy_at.try(:month)}"
end

file.close