Contents

module Rawbotz
  module Datapolate
    def self.date_minmax sales, stock
      #sales.each{|sale| sale[0] = Date.strptime(sale[0])}
      sales_first, sales_last = sales.minmax_by{|s| s[0]}
      stock_first, stock_last = stock.minmax_by{|s| s.date}
      first_dates = []
      first_dates << sales_first[0]   if !sales_first.nil?
      first_dates << stock_first.date.to_date if !stock_first.nil?

      last_dates = []
      last_dates << sales_last[0]   if !sales_last.nil?
      last_dates << stock_last.date.to_date if !stock_last.nil?

      [first_dates.min, last_dates.max]
    end

    def self.explode_days min_date, max_date
      return [] if min_date.nil? || max_date.nil?
      (min_date.to_date..max_date.to_date).to_a
    end

    def self.create_data sales, stock
      # from [date, sales] and [date, stock] create realistic list
      from_date, to_date = date_minmax sales, stock
      return {} if from_date.nil? || to_date.nil?
      days = explode_days from_date, to_date

      stock_data = Hash.new(nil)
      stock.each{|s| stock_data[s.date.to_date] = s.qty}
      sales_data = Hash.new(nil)
      sales.each{|s| sales_data[s[0].to_date] = s.fetch(1)}

      data = {}
      days.each do |day|
        data[day] = {label: day.to_date,
                     stock: stock_data[day],
                     sales: sales_data[day]
        }
      end
      data
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
rawbotz-0.2.0	lib/rawbotz/datapolate.rb
rawbotz-0.1.5	lib/rawbotz/datapolate.rb