blakewest · September 22, 2015 21:02
diff --git a/gistfile1.rb b/gistfile1.rb
 # Used when a practice's patients have been transferred to Stripe from
 # another payment processing platform and we need to associate their Stripe
 # customers with their Hint patients. This is done by matching credit card name
 # to patient name or to email, or to address, or hint hid.

 def get_customers(practice, params = nil)
  response = Stripe::Customer.all(params, practice.stripe_token)
  response.data.each do |customer|
    stripe_customer_id = customer.id
    source_with_name = customer.sources.data.find { |source| source.try(:name) }
    source_with_address = customer.sources.data.find { |source| source.try(:address_line1) }
    customer_name = source_with_name.try(:name)
    customer_email = customer.email
    customer_address = source_with_address.try(:address_line1)
    customer_hint_id = customer.metadata["hint_id"]

    id_match = customer_hint_id && practice.patients.find_by_ident(customer_hint_id)
    name_matches = customer_name && practice.patients.where("LOWER(patients.first_name) = ? AND LOWER(patients.last_name) = ?", customer_name.split(' ').first.downcase, customer_name.split(' ').last.downcase)
    email_matches = customer_email && practice.patients.where(email: customer_email)
    address_matches = customer_address && practice.patients.joins(:address).where('addresses.line1 = ?', customer_address)

    if id_match
      update_stripe_customer_id_on_patient(id_match, stripe_customer_id)
      next
    end

    if email_matches.try(:count) == 1
      update_stripe_customer_id_on_patient(email_matches.first, stripe_customer_id)
      next
    end

    if address_matches.try(:count) == 1
      update_stripe_customer_id_on_patient(address_matches.first, stripe_customer_id)
      next
    end

    if name_matches.try(:count) == 1
      update_stripe_customer_id_on_patient(name_matches.first, stripe_customer_id)
      next
    end
    puts "#{customer_name} - ERROR: (#{stripe_customer_id}) matches #{email_matches.try(:count)} patient emails, #{address_matches.try(:count)} patient addresses, and #{name_matches.try(:count)} patient names."
  end

  last_customer = response.data.last.id
  params = {starting_after: last_customer}
  get_customers(practice, params) if response.has_more
 end

 def update_stripe_customer_id_on_patient(patient, stripe_customer_id)
  if patient.stripe_customer_id.nil?
    patient.update_attribute(:stripe_customer_id, stripe_customer_id)
    puts "SUCCESS: #{stripe_customer_id} matched with #{patient.name} (#{patient.ident})"
  elsif patient.stripe_customer_id == stripe_customer_id
    print "."
  else
    puts "ERROR: #{patient.name} has stripe_customer_id #{patient.stripe_customer_id}, but stripe has someone with the same name or email as having customer id #{stripe_customer_id}"
  end
 end

 # Use this after getting all the customers.
 def import_all_cards_from_existing_stripe_customers(practice)
  practice.patients.where.not(stripe_id: nil).map { |patient| PaymentProcessor::CustomerImporter.new(patient).import }
 end

 # Use this if you know a stripe_customer goes with a certain hint patient, but they won't otherwise 
 # be linked from the above function because, for instance, they match multiple hint patients. 
 def link_patient_with_stripe(practice, patient_ident, stripe_id)
  patient = practice.patients.find_by_ident(patient_ident)
  patient.update_attribute(:stripe_customer_id, stripe_id)
  PaymentProcessor::CustomerImporter.new(patient).import
 end

 # Send this an array of arrays. Like... [['pat-3jlk3', 'cus_38jk3lkj'], ...]
 def link_list_of_patients_with_stripe(list_of_patients_with_stripe)
  list_of_patients_with_stripe.each do |patient_id_stripe_id_pair|
    patient_id = patient_id_stripe_id_pair[0]
    stripe_id = patient_id_stripe_id_pair[1]
    practice = Patient.find_by_ident(patient_id).practice
    link_patient_with_stripe(practice, patient_id, stripe_id)
  end
 end
	# Used when a practice's patients have been transferred to Stripe from
	# another payment processing platform and we need to associate their Stripe
	# customers with their Hint patients. This is done by matching credit card name
	# to patient name or to email, or to address, or hint hid.

	def get_customers(practice, params = nil)
	response = Stripe::Customer.all(params, practice.stripe_token)
	response.data.each do \|customer\|
	stripe_customer_id = customer.id
	source_with_name = customer.sources.data.find { \|source\| source.try(:name) }
	source_with_address = customer.sources.data.find { \|source\| source.try(:address_line1) }
	customer_name = source_with_name.try(:name)
	customer_email = customer.email
	customer_address = source_with_address.try(:address_line1)
	customer_hint_id = customer.metadata["hint_id"]

	id_match = customer_hint_id && practice.patients.find_by_ident(customer_hint_id)
	name_matches = customer_name && practice.patients.where("LOWER(patients.first_name) = ? AND LOWER(patients.last_name) = ?", customer_name.split(' ').first.downcase, customer_name.split(' ').last.downcase)
	email_matches = customer_email && practice.patients.where(email: customer_email)
	address_matches = customer_address && practice.patients.joins(:address).where('addresses.line1 = ?', customer_address)

	if id_match
	update_stripe_customer_id_on_patient(id_match, stripe_customer_id)
	next
	end

	if email_matches.try(:count) == 1
	update_stripe_customer_id_on_patient(email_matches.first, stripe_customer_id)
	next
	end

	if address_matches.try(:count) == 1
	update_stripe_customer_id_on_patient(address_matches.first, stripe_customer_id)
	next
	end

	if name_matches.try(:count) == 1
	update_stripe_customer_id_on_patient(name_matches.first, stripe_customer_id)
	next
	end
	puts "#{customer_name} - ERROR: (#{stripe_customer_id}) matches #{email_matches.try(:count)} patient emails, #{address_matches.try(:count)} patient addresses, and #{name_matches.try(:count)} patient names."
	end

	last_customer = response.data.last.id
	params = {starting_after: last_customer}
	get_customers(practice, params) if response.has_more
	end

	def update_stripe_customer_id_on_patient(patient, stripe_customer_id)
	if patient.stripe_customer_id.nil?
	patient.update_attribute(:stripe_customer_id, stripe_customer_id)
	puts "SUCCESS: #{stripe_customer_id} matched with #{patient.name} (#{patient.ident})"
	elsif patient.stripe_customer_id == stripe_customer_id
	print "."
	else
	puts "ERROR: #{patient.name} has stripe_customer_id #{patient.stripe_customer_id}, but stripe has someone with the same name or email as having customer id #{stripe_customer_id}"
	end
	end

	# Use this after getting all the customers.
	def import_all_cards_from_existing_stripe_customers(practice)
	practice.patients.where.not(stripe_id: nil).map { \|patient\| PaymentProcessor::CustomerImporter.new(patient).import }
	end

	# Use this if you know a stripe_customer goes with a certain hint patient, but they won't otherwise
	# be linked from the above function because, for instance, they match multiple hint patients.
	def link_patient_with_stripe(practice, patient_ident, stripe_id)
	patient = practice.patients.find_by_ident(patient_ident)
	patient.update_attribute(:stripe_customer_id, stripe_id)
	PaymentProcessor::CustomerImporter.new(patient).import
	end

	# Send this an array of arrays. Like... [['pat-3jlk3', 'cus_38jk3lkj'], ...]
	def link_list_of_patients_with_stripe(list_of_patients_with_stripe)
	list_of_patients_with_stripe.each do \|patient_id_stripe_id_pair\|
	patient_id = patient_id_stripe_id_pair[0]
	stripe_id = patient_id_stripe_id_pair[1]
	practice = Patient.find_by_ident(patient_id).practice
	link_patient_with_stripe(practice, patient_id, stripe_id)
	end
	end