Solved

rails 3 group_by for simple active record groupings

Posted on 2010-11-21
3
1,074 Views
Last Modified: 2012-08-14
so i have fixtures that have different seasons, i want to group and display the fixtures by season. On the fixtures index page i want the current season displayed and then link to old seasons. I was thinks some kind of group_by method?
class FixturesController < ApplicationController
 
  def index
    @fixtures = Fixture.all
  end
end

##view
<h1>Listing fixtures</h1>

<% @fixtures.each do |fixture| %>
  <%= fixture.season.title %></td>
  <td><%= fixture.event.title %></td>
  <td><%= fixture.home_team.name %></td>
  <td><%= fixture.away_team.name %></td>
  <td><%= fixture.date %></td>

class Season < ActiveRecord::Base
  has_many :fixtures
end

class Fixture < ActiveRecord::Base
  belongs_to :season
  belongs_to :event
  belongs_to :home_team, :class_name => 'Team'
  belongs_to :away_team, :class_name => 'Team'
end

Open in new window

0
Comment
Question by:depassion
  • 2
3 Comments
 
LVL 2

Expert Comment

by:lusfernandos
ID: 34425381
I don't know how you are getting the @fixtures in your index action ... anyway I believe you just need to order by season
something like:

@fixtures = Fixture.all(:order=>"season_id ASC")
0
 

Accepted Solution

by:
depassion earned 0 total points
ID: 34426260
i"ve solved it by creating a get_season method which works out the current season.
#application_controller
before_filter :get_season

def get_season
    @current_season = Season.where(["start_date < ? AND end_date > ?", Date.today, Date.today]).first
  end


#fixtures_view
<% @current_season.fixtures.each do |fixture| %>
...
<%end%>

Open in new window

0
 

Author Closing Comment

by:depassion
ID: 34447401
took too long for a solution from the community so was forced to pay to get help
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Java - confuse using abstract class and class 13 514
return captures in array 5 259
Converting a bash script to ruby 6 1,361
Method Inheritance / Overriding in Ruby 5 178
I recently rediscovered rails when I needed a holiday project and decided to build a management dashboard for the company where I work.  With it being a project done in my free time, I could focus my time on learning the basics rather than trying to…
In Ruby, Call or invoke a API DLL library is easily via Win32API class, win32-api gem or other gems. For general DLL API call, there are quite a few references, some good tips list below: http://www.rubytips.org/2008/05/13/accessing-windows-api-fro…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question