##// END OF EJS Templates
Eager loading and no extra count query....
Jean-Philippe Lang -
r9961:d99dbe9f0c55
parent child
Show More
@@ -1,105 +1,105
1 1 # Redmine - project management software
2 2 # Copyright (C) 2006-2012 Jean-Philippe Lang
3 3 #
4 4 # This program is free software; you can redistribute it and/or
5 5 # modify it under the terms of the GNU General Public License
6 6 # as published by the Free Software Foundation; either version 2
7 7 # of the License, or (at your option) any later version.
8 8 #
9 9 # This program is distributed in the hope that it will be useful,
10 10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
11 11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 12 # GNU General Public License for more details.
13 13 #
14 14 # You should have received a copy of the GNU General Public License
15 15 # along with this program; if not, write to the Free Software
16 16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17 17
18 18 class BoardsController < ApplicationController
19 19 default_search_scope :messages
20 20 before_filter :find_project_by_project_id, :find_board_if_available, :authorize
21 21 accept_rss_auth :index, :show
22 22
23 23 helper :sort
24 24 include SortHelper
25 25 helper :watchers
26 26
27 27 def index
28 @boards = @project.boards
28 @boards = @project.boards.includes(:last_message => :author).all
29 29 # show the board if there is only one
30 30 if @boards.size == 1
31 31 @board = @boards.first
32 32 show
33 33 end
34 34 end
35 35
36 36 def show
37 37 respond_to do |format|
38 38 format.html {
39 39 sort_init 'updated_on', 'desc'
40 40 sort_update 'created_on' => "#{Message.table_name}.created_on",
41 41 'replies' => "#{Message.table_name}.replies_count",
42 42 'updated_on' => "#{Message.table_name}.updated_on"
43 43
44 44 @topic_count = @board.topics.count
45 45 @topic_pages = Paginator.new self, @topic_count, per_page_option, params['page']
46 46 @topics = @board.topics.reorder("#{Message.table_name}.sticky DESC").order(sort_clause).all(
47 47 :include => [:author, {:last_reply => :author}],
48 48 :limit => @topic_pages.items_per_page,
49 49 :offset => @topic_pages.current.offset)
50 50 @message = Message.new(:board => @board)
51 51 render :action => 'show', :layout => !request.xhr?
52 52 }
53 53 format.atom {
54 54 @messages = @board.messages.find :all, :order => 'created_on DESC',
55 55 :include => [:author, :board],
56 56 :limit => Setting.feeds_limit.to_i
57 57 render_feed(@messages, :title => "#{@project}: #{@board}")
58 58 }
59 59 end
60 60 end
61 61
62 62 def new
63 63 @board = @project.boards.build
64 64 @board.safe_attributes = params[:board]
65 65 end
66 66
67 67 def create
68 68 @board = @project.boards.build
69 69 @board.safe_attributes = params[:board]
70 70 if @board.save
71 71 flash[:notice] = l(:notice_successful_create)
72 72 redirect_to_settings_in_projects
73 73 else
74 74 render :action => 'new'
75 75 end
76 76 end
77 77
78 78 def edit
79 79 end
80 80
81 81 def update
82 82 @board.safe_attributes = params[:board]
83 83 if @board.save
84 84 redirect_to_settings_in_projects
85 85 else
86 86 render :action => 'edit'
87 87 end
88 88 end
89 89
90 90 def destroy
91 91 @board.destroy
92 92 redirect_to_settings_in_projects
93 93 end
94 94
95 95 private
96 96 def redirect_to_settings_in_projects
97 97 redirect_to :controller => 'projects', :action => 'settings', :id => @project, :tab => 'boards'
98 98 end
99 99
100 100 def find_board_if_available
101 101 @board = @project.boards.find(params[:id]) if params[:id]
102 102 rescue ActiveRecord::RecordNotFound
103 103 render_404
104 104 end
105 105 end
General Comments 0
You need to be logged in to leave comments. Login now