Class: HighestRankedPagesPortlet

Inherits:
Portlet
  • Object
show all
Defined in:
app/portlets/highest_ranked_pages_portlet.rb

Instance Method Summary collapse

Instance Method Details

#render ⇒ Object 



3
4
5
6
7
8
9
10
11
 
# File 'app/portlets/highest_ranked_pages_portlet.rb', line 3

def render
  @pages =
          Page.find(:all,
            :select => 'pages.*, COUNT(page_rankings.id) AS rankings_count, AVG(page_rankings.rank) as avg_rank',
            :joins  => 'INNER JOIN page_rankings ON page_rankings.page_id = pages.id',
            :group  => 'pages.id',
            :limit => @portlet.number_to_show,
            :order => "avg_rank desc")
end