Sha256: 00a3374d569d0d06be4b5af214d021c23452a4dd11a1c7cce19ee64ff89ee9ae
Contents?: true
Size: 1.69 KB
Versions: 8
Compression:
Stored size: 1.69 KB
Contents
# require "eitil_integrate/application_exporter/auto_sum/sum_data"
module EitilIntegrate::RubyXL
module AutoSum
class << self
# Reduce values and alter data structure.
def sum_data
sum_floats
sum_time_strings
unpack_arrays
end
def sum_floats
@hash.transform_values! { |array| float_array?(array) ? [array.sum] : array }
end
def sum_time_strings
@hash.transform_values! { |array| time_string_array?(array) ? chronic_sum_array(array) : array }
end
def chronic_sum_array(array)
#total minutes, hours and days
tm, th, td = [0]*3
array.each do |time_string|
# add empty 0's, to avoid defining nil values when time values are absent
h, m, s = *time_string.split(':').map(&:to_i), *[0]*3
tm += m; th += h
end
# parsing times into maxes (60 m, 24 h, ∞ days)
th += tm / 60
tm = tm % 60
td += th / 24
th = th % 24
# formatting strings
sd = td.to_s
sh = th.to_s.rjust(2,'0')
sm = tm.to_s.rjust(2,'0')
[[sd, sh, sm].join(':')]
end
def format_time(time)
time.to_s.length == 1 ? "0#{time}" : time.to_s
end
def float_array?(array)
return false if array.empty?
array.all? { |item| item.is_a?(Float) }
end
def time_string_array?(array)
return false if array.empty?
array.all? { |item| item.is_a?(String) && item.scan(/\d{2}:\d{2}:\d{2}/) }
end
def unpack_arrays
@hash.transform_values! { |array| array.empty? ? nil : array.first }
end
end
end
end
Version data entries
8 entries across 8 versions & 1 rubygems