Rails HTML output for a table

Question

I'm having a tough time figuring out how to make a helper for my array that outputs an html table, here is what my array looks like.

[
  {"day"=>1.0, "hour"=>14.0, "count"=>818.0},
  {"day"=>1.0, "hour"=>15.0, "count"=>366.0},
  {"day"=>1.0, "hour"=>16.0, "count"=>1246.0},
  {"day"=>1.0, "hour"=>17.0, "count"=>116.0},
  {"day"=>1.0, "hour"=>18.0, "count"=>434.0},
  {"day"=>1.0, "hour"=>19.0, "count"=>123.0},
  {"day"=>1.0, "hour"=>20.0, "count"=>442.0},
]

Additionally this is what my table should look like, how can I for each day output its name in the header, then for each hour of each hour of each day output the count value from my hash? I'm having a hard time picturing how to iterate over these values.

<table>
  <tr>
    <th style="width:8em"></th>
    <th>Monday</th>
    <th>Tuesday</th>
    <th>Wednesday</th>
    <th>Thursday</th>
    <th>Friday</th>
    <th>Saturday</th>
    <th>Sunday</th>
  </tr>

  <tr>
    <th scope="row">00:00–01:00</th>
    <td>468</td>
    <td>2721</td>
    <td>848</td>
    <td>3127</td>
    <td>803</td>
    <td>1970</td>
    <td>2673</td>
  </tr>

  <tr>
    <th scope="row">01:00–02:00</th>
    <td>468</td>
    <td>2721</td>
    <td>848</td>
    <td>3127</td>
    <td>803</td>
    <td>1970</td>
    <td>2673</td>
  </tr>

  <!-- remaining hours of the day for each day continue... -->

</table>

Any help at all would be really really appreciated.

cam · Accepted Answer · 2011-09-20 04:06:24Z

1

Your data doesn't match what you want to do with it, so the first step is to transform your data. This snippet of code is pretty ugly, but it will do the trick:

# arr holds your original array of hashes
by_hour = arr.group_by { |x| x["hour"] }
by_hour.each do |k, v|
  v.sort! { |a,b| a["day"] <=> b["day"] }.map! { |x| x["count"] }
end

by_hour now looks like:

{20.0=>[442.0],
 19.0=>[123.0],
 14.0=>[818.0],
 18.0=>[434.0],
 17.0=>[116.0],
 15.0=>[366.0],
 16.0=>[1246.0]}

where the array holds the counts for each day of the week (from Monday to Sunday, assuming Sunday is 7.0.

From here it should be trivial to build your table. Something like:

<% by_hour.keys.sort.each do |hour| %>
  <tr>
    <% by_hour[hour].each do |count| %>
      <td><%= count %></td>
    <% end %>
  </tr>
<% end %>

answered Sep 20, 2011 at 4:06

cam

14.2k1 gold badge46 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rails HTML output for a table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related