require "csv"

csv_opts = {
  :col_sep => ";",
  :skip_lines => /^(Notes|The |;)/,
  :headers => true,
  :converters => :all,
}

sales_by_date = {}

rows = CSV.foreach(ARGV[0], csv_opts)

rows.each do |row|
  if row.count > 0
    d = Date.parse(row["Date"])
    if sales_by_date[d]
      sales_by_date[d][:count] += row["quantity"]
      sales_by_date[d][:total] += row["revenue EUR"]
    else
      sales_by_date[d] = {:count => row["quantity"], :total => row["revenue EUR"]}
    end
  end
end

puts "Date:       Streams:  Revenue:"
puts "------------------------------------------"

total_rev = 0
total_streams = 0

sales_by_date.each do |key, row|
  puts "#{key.iso8601}: #{row[:count].to_s.rjust(7)} #{row[:total].round(5).to_s.rjust(10)} EUR"
  total_rev += row[:total]
  total_streams += row[:count]
end

puts "------------------------------------------"
puts "Total:      #{total_streams.to_s.rjust(7)} #{total_rev.round(5).to_s.rjust(10)} EUR"