Fix sent invoices

find_sent_invoice.rb

def fix_sent_invoices(company_id, reference)
  company = Company.find(company_id)
  invoices = company.invoices.where(company_id: company_id, reference: reference)

  return "Only #{invoices.length} found" if invoices.length < 2
  puts "update #{invoices.length} invoices (#{invoices.map(&:id).join(",")}) for #{company.subdomain}?"
  confirm = gets.chomp

  return unless confirm == "y"

  invoices[1..].each_with_index do |invoice, index|
    new_reference = "#{invoice.reference.strip}-FA#{index+1}"
    invoice.update_column(:reference, new_reference)
    puts "updated invoice #{invoice.id} reference to #{new_reference}"
  end

  invoices.map{|i| i.reload; [i.id, i.reference]}
end