From 91387893047f9b02cb0e9741f4843161e2e78179 Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Thu, 13 Nov 2014 17:15:12 +0100 Subject: Present sales by date and calculate totals. --- parse_report.rb | 29 +++++++++++++++++++++-------- 1 file changed, 21 insertions(+), 8 deletions(-) diff --git a/parse_report.rb b/parse_report.rb index 840708e..aac426b 100644 --- a/parse_report.rb +++ b/parse_report.rb @@ -12,15 +12,28 @@ sales_by_date = {} rows = CSV.foreach(ARGV[0], csv_opts) rows.each do |row| - 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"]} + 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 -sales_by_date.each do |row| - p row +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" -- cgit v1.2.3