Description:
report only enabled user
Commit status:
[Not Reviewed]
References:
Comments:
0 Commit comments 0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
Add another comment

r550:6d57d5eff450 - - 1 file changed: 1 inserted, 1 deleted

@@ -1,337 +1,337
1 require 'csv'
1 require 'csv'
2
2
3 class UserAdminController < ApplicationController
3 class UserAdminController < ApplicationController
4
4
5 include MailHelperMethods
5 include MailHelperMethods
6
6
7 before_filter :admin_authorization
7 before_filter :admin_authorization
8
8
9 # GETs should be safe (see http://www.w3.org/2001/tag/doc/whenToUseGet.html)
9 # GETs should be safe (see http://www.w3.org/2001/tag/doc/whenToUseGet.html)
10 verify :method => :post, :only => [ :destroy,
10 verify :method => :post, :only => [ :destroy,
11 :create, :create_from_list,
11 :create, :create_from_list,
12 :update,
12 :update,
13 :manage_contest,
13 :manage_contest,
14 :bulk_mail
14 :bulk_mail
15 ],
15 ],
16 :redirect_to => { :action => :list }
16 :redirect_to => { :action => :list }
17
17
18 def index
18 def index
19 list
19 list
20 render :action => 'list'
20 render :action => 'list'
21 end
21 end
22
22
23 def list
23 def list
24 @user_count = User.count
24 @user_count = User.count
25 if params[:page] == 'all'
25 if params[:page] == 'all'
26 @users = User.all
26 @users = User.all
27 @paginated = false
27 @paginated = false
28 else
28 else
29 @users = User.paginate :page => params[:page]
29 @users = User.paginate :page => params[:page]
30 @paginated = true
30 @paginated = true
31 end
31 end
32 @hidden_columns = ['hashed_password', 'salt', 'created_at', 'updated_at']
32 @hidden_columns = ['hashed_password', 'salt', 'created_at', 'updated_at']
33 @contests = Contest.enabled
33 @contests = Contest.enabled
34 end
34 end
35
35
36 def active
36 def active
37 sessions = ActiveRecord::SessionStore::Session.find(:all, :conditions => ["updated_at >= ?", 60.minutes.ago])
37 sessions = ActiveRecord::SessionStore::Session.find(:all, :conditions => ["updated_at >= ?", 60.minutes.ago])
38 @users = []
38 @users = []
39 sessions.each do |session|
39 sessions.each do |session|
40 if session.data[:user_id]
40 if session.data[:user_id]
41 @users << User.find(session.data[:user_id])
41 @users << User.find(session.data[:user_id])
42 end
42 end
43 end
43 end
44 end
44 end
45
45
46 def show
46 def show
47 @user = User.find(params[:id])
47 @user = User.find(params[:id])
48 end
48 end
49
49
50 def new
50 def new
51 @user = User.new
51 @user = User.new
52 end
52 end
53
53
54 def create
54 def create
55 @user = User.new(params[:user])
55 @user = User.new(params[:user])
56 @user.activated = true
56 @user.activated = true
57 if @user.save
57 if @user.save
58 flash[:notice] = 'User was successfully created.'
58 flash[:notice] = 'User was successfully created.'
59 redirect_to :action => 'list'
59 redirect_to :action => 'list'
60 else
60 else
61 render :action => 'new'
61 render :action => 'new'
62 end
62 end
63 end
63 end
64
64
65 def clear_last_ip
65 def clear_last_ip
66 @user = User.find(params[:id])
66 @user = User.find(params[:id])
67 @user.last_ip = nil
67 @user.last_ip = nil
68 @user.save
68 @user.save
69 redirect_to action: 'list', page: params[:page]
69 redirect_to action: 'list', page: params[:page]
70 end
70 end
71
71
72 def create_from_list
72 def create_from_list
73 lines = params[:user_list]
73 lines = params[:user_list]
74
74
75 note = []
75 note = []
76
76
77 lines.split("\n").each do |line|
77 lines.split("\n").each do |line|
78 items = line.chomp.split(',')
78 items = line.chomp.split(',')
79 if items.length>=2
79 if items.length>=2
80 login = items[0]
80 login = items[0]
81 full_name = items[1]
81 full_name = items[1]
82
82
83 added_random_password = false
83 added_random_password = false
84 if items.length>=3
84 if items.length>=3
85 password = items[2].chomp(" ")
85 password = items[2].chomp(" ")
86 user_alias = (items.length>=4) ? items[3] : login
86 user_alias = (items.length>=4) ? items[3] : login
87 else
87 else
88 password = random_password
88 password = random_password
89 user_alias = (items.length>=4) ? items[3] : login
89 user_alias = (items.length>=4) ? items[3] : login
90 added_random_password = true
90 added_random_password = true
91 end
91 end
92
92
93 user = User.find_by_login(login)
93 user = User.find_by_login(login)
94 if (user)
94 if (user)
95 user.full_name = full_name
95 user.full_name = full_name
96 user.password = password
96 user.password = password
97 else
97 else
98 user = User.new({:login => login,
98 user = User.new({:login => login,
99 :full_name => full_name,
99 :full_name => full_name,
100 :password => password,
100 :password => password,
101 :password_confirmation => password,
101 :password_confirmation => password,
102 :alias => user_alias})
102 :alias => user_alias})
103 end
103 end
104 user.activated = true
104 user.activated = true
105 user.save
105 user.save
106
106
107 if added_random_password
107 if added_random_password
108 note << "'#{login}' (+)"
108 note << "'#{login}' (+)"
109 else
109 else
110 note << login
110 note << login
111 end
111 end
112 end
112 end
113 end
113 end
114 flash[:notice] = 'User(s) ' + note.join(', ') +
114 flash[:notice] = 'User(s) ' + note.join(', ') +
115 ' were successfully created. ' +
115 ' were successfully created. ' +
116 '( (+) - created with random passwords.)'
116 '( (+) - created with random passwords.)'
117 redirect_to :action => 'list'
117 redirect_to :action => 'list'
118 end
118 end
119
119
120 def edit
120 def edit
121 @user = User.find(params[:id])
121 @user = User.find(params[:id])
122 end
122 end
123
123
124 def update
124 def update
125 @user = User.find(params[:id])
125 @user = User.find(params[:id])
126 if @user.update_attributes(params[:user])
126 if @user.update_attributes(params[:user])
127 flash[:notice] = 'User was successfully updated.'
127 flash[:notice] = 'User was successfully updated.'
128 redirect_to :action => 'show', :id => @user
128 redirect_to :action => 'show', :id => @user
129 else
129 else
130 render :action => 'edit'
130 render :action => 'edit'
131 end
131 end
132 end
132 end
133
133
134 def destroy
134 def destroy
135 User.find(params[:id]).destroy
135 User.find(params[:id]).destroy
136 redirect_to :action => 'list'
136 redirect_to :action => 'list'
137 end
137 end
138
138
139 def user_stat
139 def user_stat
140 if params[:commit] == 'download csv'
140 if params[:commit] == 'download csv'
141 @problems = Problem.all
141 @problems = Problem.all
142 else
142 else
143 @problems = Problem.find_available_problems
143 @problems = Problem.find_available_problems
144 end
144 end
145 - @users = User.find(:all, :include => [:contests, :contest_stat])
145 + @users = User.includes(:contests, :contest_stat).where(enabled: true) #find(:all, :include => [:contests, :contest_stat]).where(enabled: true)
146 @scorearray = Array.new
146 @scorearray = Array.new
147 @users.each do |u|
147 @users.each do |u|
148 ustat = Array.new
148 ustat = Array.new
149 ustat[0] = u
149 ustat[0] = u
150 @problems.each do |p|
150 @problems.each do |p|
151 sub = Submission.find_last_by_user_and_problem(u.id,p.id)
151 sub = Submission.find_last_by_user_and_problem(u.id,p.id)
152 if (sub!=nil) and (sub.points!=nil) and p and p.full_score
152 if (sub!=nil) and (sub.points!=nil) and p and p.full_score
153 ustat << [(sub.points.to_f*100/p.full_score).round, (sub.points>=p.full_score)]
153 ustat << [(sub.points.to_f*100/p.full_score).round, (sub.points>=p.full_score)]
154 else
154 else
155 ustat << [0,false]
155 ustat << [0,false]
156 end
156 end
157 end
157 end
158 @scorearray << ustat
158 @scorearray << ustat
159 end
159 end
160 if params[:commit] == 'download csv' then
160 if params[:commit] == 'download csv' then
161 csv = gen_csv_from_scorearray(@scorearray,@problems)
161 csv = gen_csv_from_scorearray(@scorearray,@problems)
162 send_data csv, filename: 'last_score.csv'
162 send_data csv, filename: 'last_score.csv'
163 else
163 else
164 render template: 'user_admin/user_stat'
164 render template: 'user_admin/user_stat'
165 end
165 end
166 end
166 end
167
167
168 def user_stat_max
168 def user_stat_max
169 if params[:commit] == 'download csv'
169 if params[:commit] == 'download csv'
170 @problems = Problem.all
170 @problems = Problem.all
171 else
171 else
172 @problems = Problem.find_available_problems
172 @problems = Problem.find_available_problems
173 end
173 end
174 @users = User.find(:all, :include => [:contests, :contest_stat])
174 @users = User.find(:all, :include => [:contests, :contest_stat])
175 @scorearray = Array.new
175 @scorearray = Array.new
176 #set up range from param
176 #set up range from param
177 since_id = params.fetch(:since_id, 0).to_i
177 since_id = params.fetch(:since_id, 0).to_i
178 until_id = params.fetch(:until_id, 0).to_i
178 until_id = params.fetch(:until_id, 0).to_i
179 @users.each do |u|
179 @users.each do |u|
180 ustat = Array.new
180 ustat = Array.new
181 ustat[0] = u
181 ustat[0] = u
182 @problems.each do |p|
182 @problems.each do |p|
183 max_points = 0
183 max_points = 0
184 Submission.find_in_range_by_user_and_problem(u.id,p.id,since_id,until_id).each do |sub|
184 Submission.find_in_range_by_user_and_problem(u.id,p.id,since_id,until_id).each do |sub|
185 max_points = sub.points if sub and sub.points and (sub.points > max_points)
185 max_points = sub.points if sub and sub.points and (sub.points > max_points)
186 end
186 end
187 ustat << [(max_points.to_f*100/p.full_score).round, (max_points>=p.full_score)]
187 ustat << [(max_points.to_f*100/p.full_score).round, (max_points>=p.full_score)]
188 end
188 end
189 @scorearray << ustat
189 @scorearray << ustat
190 end
190 end
191
191
192 if params[:commit] == 'download csv' then
192 if params[:commit] == 'download csv' then
193 csv = gen_csv_from_scorearray(@scorearray,@problems)
193 csv = gen_csv_from_scorearray(@scorearray,@problems)
194 send_data csv, filename: 'max_score.csv'
194 send_data csv, filename: 'max_score.csv'
195 else
195 else
196 render template: 'user_admin/user_stat'
196 render template: 'user_admin/user_stat'
197 end
197 end
198 end
198 end
199
199
200 def import
200 def import
201 if params[:file]==''
201 if params[:file]==''
202 flash[:notice] = 'Error importing no file'
202 flash[:notice] = 'Error importing no file'
203 redirect_to :action => 'list' and return
203 redirect_to :action => 'list' and return
204 end
204 end
205 import_from_file(params[:file])
205 import_from_file(params[:file])
206 end
206 end
207
207
208 def random_all_passwords
208 def random_all_passwords
209 users = User.find(:all)
209 users = User.find(:all)
210 @prefix = params[:prefix] || ''
210 @prefix = params[:prefix] || ''
211 @non_admin_users = User.find_non_admin_with_prefix(@prefix)
211 @non_admin_users = User.find_non_admin_with_prefix(@prefix)
212 @changed = false
212 @changed = false
213 if request.request_method == 'POST'
213 if request.request_method == 'POST'
214 @non_admin_users.each do |user|
214 @non_admin_users.each do |user|
215 password = random_password
215 password = random_password
216 user.password = password
216 user.password = password
217 user.password_confirmation = password
217 user.password_confirmation = password
218 user.save
218 user.save
219 end
219 end
220 @changed = true
220 @changed = true
221 end
221 end
222 end
222 end
223
223
224 # contest management
224 # contest management
225
225
226 def contests
226 def contests
227 @contest, @users = find_contest_and_user_from_contest_id(params[:id])
227 @contest, @users = find_contest_and_user_from_contest_id(params[:id])
228 @contests = Contest.enabled
228 @contests = Contest.enabled
229 end
229 end
230
230
231 def assign_from_list
231 def assign_from_list
232 contest_id = params[:users_contest_id]
232 contest_id = params[:users_contest_id]
233 org_contest, users = find_contest_and_user_from_contest_id(contest_id)
233 org_contest, users = find_contest_and_user_from_contest_id(contest_id)
234 contest = Contest.find(params[:new_contest][:id])
234 contest = Contest.find(params[:new_contest][:id])
235 if !contest
235 if !contest
236 flash[:notice] = 'Error: no contest'
236 flash[:notice] = 'Error: no contest'
237 redirect_to :action => 'contests', :id =>contest_id
237 redirect_to :action => 'contests', :id =>contest_id
238 end
238 end
239
239
240 note = []
240 note = []
241 users.each do |u|
241 users.each do |u|
242 u.contests = [contest]
242 u.contests = [contest]
243 note << u.login
243 note << u.login
244 end
244 end
245 flash[:notice] = 'User(s) ' + note.join(', ') +
245 flash[:notice] = 'User(s) ' + note.join(', ') +
246 " were successfully reassigned to #{contest.title}."
246 " were successfully reassigned to #{contest.title}."
247 redirect_to :action => 'contests', :id =>contest.id
247 redirect_to :action => 'contests', :id =>contest.id
248 end
248 end
249
249
250 def add_to_contest
250 def add_to_contest
251 user = User.find(params[:id])
251 user = User.find(params[:id])
252 contest = Contest.find(params[:contest_id])
252 contest = Contest.find(params[:contest_id])
253 if user and contest
253 if user and contest
254 user.contests << contest
254 user.contests << contest
255 end
255 end
256 redirect_to :action => 'list'
256 redirect_to :action => 'list'
257 end
257 end
258
258
259 def remove_from_contest
259 def remove_from_contest
260 user = User.find(params[:id])
260 user = User.find(params[:id])
261 contest = Contest.find(params[:contest_id])
261 contest = Contest.find(params[:contest_id])
262 if user and contest
262 if user and contest
263 user.contests.delete(contest)
263 user.contests.delete(contest)
264 end
264 end
265 redirect_to :action => 'list'
265 redirect_to :action => 'list'
266 end
266 end
267
267
268 def contest_management
268 def contest_management
269 end
269 end
270
270
271 def manage_contest
271 def manage_contest
272 contest = Contest.find(params[:contest][:id])
272 contest = Contest.find(params[:contest][:id])
273 if !contest
273 if !contest
274 flash[:notice] = 'You did not choose the contest.'
274 flash[:notice] = 'You did not choose the contest.'
275 redirect_to :action => 'contest_management' and return
275 redirect_to :action => 'contest_management' and return
276 end
276 end
277
277
278 operation = params[:operation]
278 operation = params[:operation]
279
279
280 if not ['add','remove','assign'].include? operation
280 if not ['add','remove','assign'].include? operation
281 flash[:notice] = 'You did not choose the operation to perform.'
281 flash[:notice] = 'You did not choose the operation to perform.'
282 redirect_to :action => 'contest_management' and return
282 redirect_to :action => 'contest_management' and return
283 end
283 end
284
284
285 lines = params[:login_list]
285 lines = params[:login_list]
286 if !lines or lines.blank?
286 if !lines or lines.blank?
287 flash[:notice] = 'You entered an empty list.'
287 flash[:notice] = 'You entered an empty list.'
288 redirect_to :action => 'contest_management' and return
288 redirect_to :action => 'contest_management' and return
289 end
289 end
290
290
291 note = []
291 note = []
292 users = []
292 users = []
293 lines.split("\n").each do |line|
293 lines.split("\n").each do |line|
294 user = User.find_by_login(line.chomp)
294 user = User.find_by_login(line.chomp)
295 if user
295 if user
296 if operation=='add'
296 if operation=='add'
297 if ! user.contests.include? contest
297 if ! user.contests.include? contest
298 user.contests << contest
298 user.contests << contest
299 end
299 end
300 elsif operation=='remove'
300 elsif operation=='remove'
301 user.contests.delete(contest)
301 user.contests.delete(contest)
302 else
302 else
303 user.contests = [contest]
303 user.contests = [contest]
304 end
304 end
305
305
306 if params[:reset_timer]
306 if params[:reset_timer]
307 user.contest_stat.forced_logout = true
307 user.contest_stat.forced_logout = true
308 user.contest_stat.reset_timer_and_save
308 user.contest_stat.reset_timer_and_save
309 end
309 end
310
310
311 if params[:notification_emails]
311 if params[:notification_emails]
312 send_contest_update_notification_email(user, contest)
312 send_contest_update_notification_email(user, contest)
313 end
313 end
314
314
315 note << user.login
315 note << user.login
316 users << user
316 users << user
317 end
317 end
318 end
318 end
319
319
320 if params[:reset_timer]
320 if params[:reset_timer]
321 logout_users(users)
321 logout_users(users)
322 end
322 end
323
323
324 flash[:notice] = 'User(s) ' + note.join(', ') +
324 flash[:notice] = 'User(s) ' + note.join(', ') +
325 ' were successfully modified. '
325 ' were successfully modified. '
326 redirect_to :action => 'contest_management'
326 redirect_to :action => 'contest_management'
327 end
327 end
328
328
329 # admin management
329 # admin management
330
330
331 def admin
331 def admin
332 @admins = User.find(:all).find_all {|user| user.admin? }
332 @admins = User.find(:all).find_all {|user| user.admin? }
333 end
333 end
334
334
335 def grant_admin
335 def grant_admin
336 login = params[:login]
336 login = params[:login]
337 user = User.find_by_login(login)
337 user = User.find_by_login(login)
You need to be logged in to leave comments. Login now