lukeredpath / process_last_months_finance_reports.rb

Created November 15, 2010


    
    View process_last_months_finance_reports.rb 
  
  
      process_last_months_finance_reports.rb
    
    
        Raw
      
    
    File suppressed. Click to show.
  
  
            1
            2
            3
            4
            5
            6
            7
            8
            9
            10
            11
            12
            13
            14
            15
            16
            17
            18
            19
          
          
            #!/usr/bin/env ruby
SECONDS_IN_DAY = (24*60*60)
REPORT_ROOT = File.expand_path("~/Documents/Business/Accounts/iTunes Finance Reports")
 
# I group US and WW on the same invoice as they are both in USD
INVOICE_GROUPS = [%w{AU}, %w{CA}, %w{GB}, %w{EU}, %w{US WW}, %w{JP}]
 
one_month_ago = Time.now - (30 * SECONDS_IN_DAY)
 
# My "fetch_finance_reports" script puts reports in a sub-dir e.g. 2010-09-Aug
Dir.chdir(File.join(REPORT_ROOT, one_month_ago.strftime("%Y-%m-%b"))) do
  reports = Dir["*.txt"]
  
  INVOICE_GROUPS.each do |invoice|
    puts "* Processing invoices for regions: #{invoice.join(", ")}"
    reports_for_invoice = invoice.map { |region| File.basename(reports.grep(/#{region}\.txt/).first) }
    system "process_finance_report #{reports_for_invoice.join(" ")}"
  end
end