##// END OF EJS Templates
Eager load group projects to avoid N SQL queries....
Jean-Philippe Lang -
r3621:e417d755e94e
parent child
Show More
@@ -1,162 +1,162
1 1 # Redmine - project management software
2 2 # Copyright (C) 2006-2009 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 GroupsController < ApplicationController
19 19 layout 'admin'
20 20
21 21 before_filter :require_admin
22 22
23 23 helper :custom_fields
24 24
25 25 # GET /groups
26 26 # GET /groups.xml
27 27 def index
28 28 @groups = Group.find(:all, :order => 'lastname')
29 29
30 30 respond_to do |format|
31 31 format.html # index.html.erb
32 32 format.xml { render :xml => @groups }
33 33 end
34 34 end
35 35
36 36 # GET /groups/1
37 37 # GET /groups/1.xml
38 38 def show
39 39 @group = Group.find(params[:id])
40 40
41 41 respond_to do |format|
42 42 format.html # show.html.erb
43 43 format.xml { render :xml => @group }
44 44 end
45 45 end
46 46
47 47 # GET /groups/new
48 48 # GET /groups/new.xml
49 49 def new
50 50 @group = Group.new
51 51
52 52 respond_to do |format|
53 53 format.html # new.html.erb
54 54 format.xml { render :xml => @group }
55 55 end
56 56 end
57 57
58 58 # GET /groups/1/edit
59 59 def edit
60 @group = Group.find(params[:id])
60 @group = Group.find(params[:id], :include => :projects)
61 61 end
62 62
63 63 # POST /groups
64 64 # POST /groups.xml
65 65 def create
66 66 @group = Group.new(params[:group])
67 67
68 68 respond_to do |format|
69 69 if @group.save
70 70 flash[:notice] = l(:notice_successful_create)
71 71 format.html { redirect_to(groups_path) }
72 72 format.xml { render :xml => @group, :status => :created, :location => @group }
73 73 else
74 74 format.html { render :action => "new" }
75 75 format.xml { render :xml => @group.errors, :status => :unprocessable_entity }
76 76 end
77 77 end
78 78 end
79 79
80 80 # PUT /groups/1
81 81 # PUT /groups/1.xml
82 82 def update
83 83 @group = Group.find(params[:id])
84 84
85 85 respond_to do |format|
86 86 if @group.update_attributes(params[:group])
87 87 flash[:notice] = l(:notice_successful_update)
88 88 format.html { redirect_to(groups_path) }
89 89 format.xml { head :ok }
90 90 else
91 91 format.html { render :action => "edit" }
92 92 format.xml { render :xml => @group.errors, :status => :unprocessable_entity }
93 93 end
94 94 end
95 95 end
96 96
97 97 # DELETE /groups/1
98 98 # DELETE /groups/1.xml
99 99 def destroy
100 100 @group = Group.find(params[:id])
101 101 @group.destroy
102 102
103 103 respond_to do |format|
104 104 format.html { redirect_to(groups_url) }
105 105 format.xml { head :ok }
106 106 end
107 107 end
108 108
109 109 def add_users
110 110 @group = Group.find(params[:id])
111 111 users = User.find_all_by_id(params[:user_ids])
112 112 @group.users << users if request.post?
113 113 respond_to do |format|
114 114 format.html { redirect_to :controller => 'groups', :action => 'edit', :id => @group, :tab => 'users' }
115 115 format.js {
116 116 render(:update) {|page|
117 117 page.replace_html "tab-content-users", :partial => 'groups/users'
118 118 users.each {|user| page.visual_effect(:highlight, "user-#{user.id}") }
119 119 }
120 120 }
121 121 end
122 122 end
123 123
124 124 def remove_user
125 125 @group = Group.find(params[:id])
126 126 @group.users.delete(User.find(params[:user_id])) if request.post?
127 127 respond_to do |format|
128 128 format.html { redirect_to :controller => 'groups', :action => 'edit', :id => @group, :tab => 'users' }
129 129 format.js { render(:update) {|page| page.replace_html "tab-content-users", :partial => 'groups/users'} }
130 130 end
131 131 end
132 132
133 133 def autocomplete_for_user
134 134 @group = Group.find(params[:id])
135 135 @users = User.active.like(params[:q]).find(:all, :limit => 100) - @group.users
136 136 render :layout => false
137 137 end
138 138
139 139 def edit_membership
140 140 @group = Group.find(params[:id])
141 141 @membership = Member.edit_membership(params[:membership_id], params[:membership], @group)
142 142 @membership.save if request.post?
143 143 respond_to do |format|
144 144 format.html { redirect_to :controller => 'groups', :action => 'edit', :id => @group, :tab => 'memberships' }
145 145 format.js {
146 146 render(:update) {|page|
147 147 page.replace_html "tab-content-memberships", :partial => 'groups/memberships'
148 148 page.visual_effect(:highlight, "member-#{@membership.id}")
149 149 }
150 150 }
151 151 end
152 152 end
153 153
154 154 def destroy_membership
155 155 @group = Group.find(params[:id])
156 156 Member.find(params[:membership_id]).destroy if request.post?
157 157 respond_to do |format|
158 158 format.html { redirect_to :controller => 'groups', :action => 'edit', :id => @group, :tab => 'memberships' }
159 159 format.js { render(:update) {|page| page.replace_html "tab-content-memberships", :partial => 'groups/memberships'} }
160 160 end
161 161 end
162 162 end
General Comments 0
You need to be logged in to leave comments. Login now