Dynamic loop in a hash

I’m trying to create a dynamic loop within the hash @data below and
can’t really seem to figure it out. The array within the hash has to be
dynamic i:e the day number has to be generated by a loop either while or
until and the name of the product and number are dynamic as well. I’ll
try to explain in the loop below

@numdeployed comes from a table in the db

i = 0
until i == 12
i.day.ago.to_date => { :coder=>@numdeployed, :imedidata=>@numdeployed,
:balance=>@numdeployed, :CTMS=>@numdeployed },
i += 1
end

Original Data Hash

@data = {
1.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
2.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
3.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
4.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
5.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
6.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
7.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
8.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
9.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
10.day.ago.to_date => { :coder=>200, :imedidata=>190, :balance=>70,
:CTMS=>90 },
11.day.ago.to_date => { :coder=>190, :imedidata=>200,
:balance=>200, :CTMS=>150 },
12.day.ago.to_date => { :coder=>100, :imedidata=>400,
:balance=>100, :CTMS=>100 }

}

hope someone can help. Thanks

On 3 August 2012 22:03, Sam G. [email protected] wrote:

i.day.ago.to_date => { :coder=>@numdeployed, :imedidata=>@numdeployed,
:balance=>@numdeployed, :CTMS=>@numdeployed },
i += 1
end

Original Data Hash

@data = {
1.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },

How can you have a Date object as the key to a hash? Show us for an
actual date what you want to see here.

This should work:

items = 12.times.map { [i.day.ago.to_date, { :coder=>@numdeployed, :imedidata=>@numdeployed, :balance=>@numdeployed, :CTMS=>@numdeployed } ] }.flatten
result = Hash[*items]

Daniel

Colin L. wrote in post #1071227:

On 3 August 2012 22:03, Sam G. [email protected] wrote:

i.day.ago.to_date => { :coder=>@numdeployed, :imedidata=>@numdeployed,
:balance=>@numdeployed, :CTMS=>@numdeployed },
i += 1
end

Original Data Hash

@data = {
1.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },

How can you have a Date object as the key to a hash? Show us for an
actual date what you want to see here.

the date object has to be there. That helps to build the javascript that
creates the graphical timeline.

Daniel M. wrote in post #1071237:

This should work:

items = 12.times.map { [i.day.ago.to_date, { :coder=>@numdeployed, :imedidata=>@numdeployed, :balance=>@numdeployed, :CTMS=>@numdeployed } ] }.flatten
result = Hash[*items]

Daniel

Thanks Daniel, I will try this.

Sam G. wrote in post #1071240:

Colin L. wrote in post #1071227:

On 3 August 2012 22:03, Sam G. [email protected] wrote:

i.day.ago.to_date => { :coder=>@numdeployed, :imedidata=>@numdeployed,
:balance=>@numdeployed, :CTMS=>@numdeployed },
i += 1
end

Original Data Hash

@data = {
1.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },

How can you have a Date object as the key to a hash? Show us for an
actual date what you want to see here.

the date object has to be there. That helps to build the javascript that
creates the graphical timeline.

Daniel, I tried your suggestion but it did not work. I"m not sure if you
can look at the actual plugin code. Maybe this will give you an idea of
what I’m trying to do. Thanks again.

########################## original controller code. code I’m trying to
replace with what you have written

@data = {
1.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
2.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
3.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
4.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
5.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
6.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
7.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
8.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
9.day.ago.to_date => { :coder=>10, :imedidata=>40, :balance=>10,
:CTMS=>40 },
10.day.ago.to_date => { :coder=>200, :imedidata=>190, :balance=>70,
:CTMS=>90 },
11.day.ago.to_date => { :coder=>190, :imedidata=>200,
:balance=>200, :CTMS=>150 },
12.day.ago.to_date => { :coder=>100, :imedidata=>400,
:balance=>100, :CTMS=>100 }
}

################################ View code

<%= inline_annotated_timeline @data, “900”, “300”, ‘div_id_to_create’ %>

####################### plugin code ######################

Sample generated Javascript

<script type=“text/javascript”

src=“http://www.google.com/jsapi”>

”.html_safe
html << annotated_timeline(daily_counts_by_type, div_id_to_create,
options)
html << “<div id=”#{div_id_to_create}" style=“width: #{width}px;
height: #{height}px;”>".html_safe
end

#you must create a div on your page and pass in the div id
def annotated_timeline(daily_counts_by_type, div_id = ‘graph’, options
= {})
@time_zone = options.delete(:timeZone)
daily_graph = is_daily?(daily_counts_by_type)
google_graph_html = google_graph_data(daily_counts_by_type,
daily_graph, options)

google_options = format_options_for_javascript(options, daily_graph)
data_args = google_options.any? ? "data, {#{google_options.join(", 

“)}}” : “data”

html = "<script type=\"text/javascript\">
google.load(\"visualization\", \"1\", 

{packages:[“annotatedtimeline”]});
google.setOnLoadCallback(drawChart);
function drawChart(){
var data = new google.visualization.DataTable();
#{google_graph_html}
var chart = new
google.visualization.AnnotatedTimeLine(document.getElementById(’#{div_id}’));
chart.draw(#{data_args});
}
".html_safe
end

private
def ruby_time_to_js_date(date)
“new Date(#{date.year}, #{date.month-1}, #{date.day})”
end

def ruby_time_to_js_time(time)
time = time.to_time if !time.is_a?(Time)
if @time_zone && time.respond_to?(:in_time_zone)
time = time.in_time_zone(@time_zone)
end
“new Date(#{time.year}, #{time.month-1}, #{time.day}, #{time.hour},
#{time.min})”
end

def ruby_hash_to_js_hash(hash)
hash.map{|key,val| “#{key}: #{val}”}
end

def format_options_for_javascript(options, daily_graph=true)
valid_options = {}
options.each do |k,v|
valid_options[k] = case v
when String, Array then v.inspect #this turns ‘red’ into
‘“red”’ for strings and %w[red blue] into [“red”, “blue”] for
arrays
when Date,Time then (daily_graph) ?
ruby_time_to_js_date(v) : ruby_time_to_js_time(v)
else v #leave bools and numbers as they are
end
end

# a hash containing annotations is passed into the ruby options 

hash, keyed as :annotations. this hash
# doesn’t get sent to the javascript function - javascript takes the
annotations as data points. the js
# function does, however, require the boolean :displayAnnotations
if (options[:annotations] && options[:annotations].any?)
valid_options[:displayAnnotations] = true
end
valid_options.reject!{|k,v| k == :annotations || v == nil}

ruby_hash_to_js_hash valid_options

end

def is_daily?(daily_counts_by_type={})
return true if (daily_counts_by_type.keys.first.is_a?(Date))
return true if (daily_counts_by_type.length < 2)

sorted_keys = daily_counts_by_type.keys.sort
(sorted_keys[1] - sorted_keys[0]) > 2.hours

end

def google_graph_data(daily_counts_by_type, daily_graph, options)
categories = []
num = 0
html = “”
# Offset used to keep track of nested annotations.
index_offset = 0

#set up columns and assign them each an index
if daily_graph
  html << "data.addColumn('date', 'Date'); \n"
else
  html << "data.addColumn('datetime', 'Date'); \n"
end
types( daily_counts_by_type ).each do |type|
  html<<"data.addColumn('number', '#{type.titleize}');\n"
  categories << type.to_sym

  if options[:annotations] && 

options[:annotations].keys.include?(type.to_sym)
html<<“data.addColumn(‘string’,
‘#{type.titleize}_annotation_title’);\n”
categories << “#{type}_annotation_title”.to_sym

    html<<"data.addColumn('string', 

‘#{type.titleize}_annotation_text’);\n"
categories << “#{type}_annotation_text”.to_sym

    options[:annotations][type.to_sym].each do |date, array|
      if not daily_counts_by_type.key?(date)
        daily_counts_by_type[date] = {}
      end

      # We'll need additional date fields only if we have more than 

one annotation.
index_offset += (array.size-1)

      # Preserve multiple annotations.
      daily_counts_by_type[date]["#{type}_annotation_title".to_sym] 

= array
end
end
end

#The script expects a constant telling it how many rows we're going 

to add
html<<“data.addRows(#{(daily_counts_by_type.size+index_offset)});\n”

html<<add_data_points(daily_counts_by_type, categories, daily_graph)
html

end

Converts this:

{ :Date1=>{:type1=>9, :type2=>9},

:Date2=>{:type1=>9, :type3=>9} }

into

[‘type1’, ‘type2’, ‘type3’]

We can’t just take the keys of the first item because not every date

has every category
def types( daily_counts_by_type )
daily_counts_by_type.values.inject({}){|a,b|a.merge(b)}.stringify_keys.keys.sort
end

def add_data_points(daily_counts_by_type, categories, daily_graph)
html = “”
total_count = 0
# Offset used to keep track of nested annotations.
index_offset = 0

#sort by date
daily_counts_by_type.sort{|a,b| a[0]<=>b[0]}.each_with_index do 

|obj, index|
date, type_and_count = obj
js_date = (daily_graph) ? ruby_time_to_js_date(date) :
ruby_time_to_js_time(date)
html<<“data.setValue(#{(index+index_offset)}, 0, #{js_date});\n”

  #now, on a particular date, go through columns
  categories.each_with_index do |category, idx2|
    value = type_and_count[category]
    if value && category.to_s.include?("_annotation_")
      first_iteration = true
      value.each do |v|
        if (!first_iteration)
          index_offset += 1
          html<<"data.setValue(#{(index+index_offset)}, 0, 

#{js_date});\n"
end
html<<“data.setValue(#{(index+index_offset)}, #{idx2+1},
“#{v[0]}”);\n” if v[0]
# XXX: We assume the _text index is right after the _title
index.
html<<“data.setValue(#{(index+index_offset)}, #{idx2+2},
“#{v[1]}”);\n” if v[1]
first_iteration = false
end
elsif value
total_count = total_count + value.to_i
html<<“data.setValue(#{(index+index_offset)}, #{idx2+1},
#{value});\n” if value
end
end
end
(total_count > 0) ? html : “”
end

end

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs