Again I need some help with grouping&sum
Attributes:
user_id, week_id, project_id, hours 1 61 1 20 1 62 1 5 1 62 2 0 1 61 2 15 1 63
What I need is a table row per user 61 62 63… 35 5
View: <% @hour_users.group_by(&:user_id).each do |user, hours| %> <% hours.each do |h|%> <td"><%= h.hours %> <% end %> <% end %>
This gives me a row with all week_ids and
Again I need some help with grouping&sum
Attributes:
user_id, week_id, project_id, hours 1 61 1 20 1 62 1 5 1 62 2 0 1 61 2 15 1 63
What I need is a table row per user 61 62 63... 35 5
View: <% @hour_users.group_by(&:user_id).each do |user, hours| %> <tr> <% hours.each do |h|%> <td"><%= h.hours %></td> <% end %> </tr> <% end %>
This gives me a row with all week_ids and
You need to tell us the classes and relationships, but if you want a row per user why are you not starting @users.each do |user|
Colin
Sorry the posting was send by mistake… this is the correct question:
Again I need some help with grouping&sum
Attributes:
user_id, week_id, project_id, hours 1 61 1 20 1 62 1 5 1 62 2 0 1 61 2 15 1 63 1 0
What I need is a table row per user like that: 61 62 63…(week_id) 35 5 0… Sum of hours per user of all projects, per week_id
View: <% @hour_users.group_by(&:user_id).each do |user, hours| %> <% hours.each do |h|%> <td"><%= h.hours %> <% end %> <% end %>
This gives me a row with all week_id’s and the hours per user but not summed up by project_id. How do I have to group that ? Thanks…