cafe-grader-web

Commit r633:49e05926711f public

parent | child
Description:
+ new list of user with remark
Commit status:
[Not Reviewed]
References:
java
Diff options:
Raw Diff | Patch Diff | Download Diff | Ignore whitespace | Increase context
Comments:
0 Commit comments 0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
Side by Side Unified
Expand All Files Collapse All Files Wide Mode Diff
Add another comment
Browse Files

r633:49e05926711f - - 1 file changed: 17 inserted, 5 deleted

Show file before | Show file after | Raw diff | Download diff | Ignore whitespace Increase context Show commentsHide comments
@@ -1,481 +1,493
1 1 require 'csv'
2 2
3 3 class UserAdminController < ApplicationController
4 4
5 5 include MailHelperMethods
6 6
7 7 before_filter :admin_authorization
8 8
9 9 # GETs should be safe (see http://www.w3.org/2001/tag/doc/whenToUseGet.html)
10 10 verify :method => :post, :only => [
11 11 :create, :create_from_list,
12 12 :update,
13 13 :manage_contest,
14 14 :bulk_mail
15 15 ],
16 16 :redirect_to => { :action => :list }
17 17
18 18 def index
19 19 @user_count = User.count
20 20 if params[:page] == 'all'
21 21 @users = User.all
22 22 @paginated = false
23 23 else
24 24 @users = User.paginate :page => params[:page]
25 25 @paginated = true
26 26 end
27 27 @hidden_columns = ['hashed_password', 'salt', 'created_at', 'updated_at']
28 28 @contests = Contest.enabled
29 29 end
30 30
31 31 def active
32 32 sessions = ActiveRecord::SessionStore::Session.where("updated_at >= ?", 60.minutes.ago)
33 33 @users = []
34 34 sessions.each do |session|
35 35 if session.data[:user_id]
36 36 @users << User.find(session.data[:user_id])
37 37 end
38 38 end
39 39 end
40 40
41 41 def show
42 42 @user = User.find(params[:id])
43 43 end
44 44
45 45 def new
46 46 @user = User.new
47 47 end
48 48
49 49 def create
50 50 @user = User.new(params[:user])
51 51 @user.activated = true
52 52 if @user.save
53 53 flash[:notice] = 'User was successfully created.'
54 54 redirect_to :action => 'index'
55 55 else
56 56 render :action => 'new'
57 57 end
58 58 end
59 59
60 60 def clear_last_ip
61 61 @user = User.find(params[:id])
62 62 @user.last_ip = nil
63 63 @user.save
64 64 redirect_to action: 'index', page: params[:page]
65 65 end
66 66
67 67 def create_from_list
68 68 lines = params[:user_list]
69 69
70 70 note = []
71 71
72 72 lines.split("\n").each do |line|
73 73 items = line.chomp.split(',')
74 74 if items.length>=2
75 75 login = items[0]
76 76 full_name = items[1]
77 + remark =''
78 + user_alias = ''
77 79
78 80 added_random_password = false
79 - if items.length>=3
81 + if items.length >= 3 and items[2].chomp(" ").length > 0;
80 82 password = items[2].chomp(" ")
81 - user_alias = (items.length>=4) ? items[3] : login
82 83 else
83 84 password = random_password
84 - user_alias = (items.length>=4) ? items[3] : login
85 - added_random_password = true
85 + add_random_password=true;
86 + end
87 +
88 + if items.length>= 4 and items[3].chomp(" ").length > 0;
89 + user_alias = items[3].chomp(" ")
90 + else
91 + user_alias = login
92 + end
93 +
94 + if items.length>=5
95 + remark = items[4].strip;
86 96 end
87 97
88 98 user = User.find_by_login(login)
89 99 if (user)
90 100 user.full_name = full_name
91 101 user.password = password
102 + user.remark = remark
92 103 else
93 104 user = User.new({:login => login,
94 105 :full_name => full_name,
95 106 :password => password,
96 107 :password_confirmation => password,
97 - :alias => user_alias})
108 + :alias => user_alias,
109 + :remark => remark})
98 110 end
99 111 user.activated = true
100 112 user.save
101 113
102 114 if added_random_password
103 115 note << "'#{login}' (+)"
104 116 else
105 117 note << login
106 118 end
107 119 end
108 120 end
109 121 flash[:notice] = 'User(s) ' + note.join(', ') +
110 122 ' were successfully created. ' +
111 123 '( (+) - created with random passwords.)'
112 124 redirect_to :action => 'index'
113 125 end
114 126
115 127 def edit
116 128 @user = User.find(params[:id])
117 129 end
118 130
119 131 def update
120 132 @user = User.find(params[:id])
121 133 if @user.update_attributes(user_params)
122 134 flash[:notice] = 'User was successfully updated.'
123 135 redirect_to :action => 'show', :id => @user
124 136 else
125 137 render :action => 'edit'
126 138 end
127 139 end
128 140
129 141 def destroy
130 142 User.find(params[:id]).destroy
131 143 redirect_to :action => 'index'
132 144 end
133 145
134 146 def user_stat
135 147 if params[:commit] == 'download csv'
136 148 @problems = Problem.all
137 149 else
138 150 @problems = Problem.available_problems
139 151 end
140 152 @users = User.includes(:contests, :contest_stat).where(enabled: true)
141 153 @scorearray = Array.new
142 154 @users.each do |u|
143 155 ustat = Array.new
144 156 ustat[0] = u
145 157 @problems.each do |p|
146 158 sub = Submission.find_last_by_user_and_problem(u.id,p.id)
147 159 if (sub!=nil) and (sub.points!=nil) and p and p.full_score
148 160 ustat << [(sub.points.to_f*100/p.full_score).round, (sub.points>=p.full_score)]
149 161 else
150 162 ustat << [0,false]
151 163 end
152 164 end
153 165 @scorearray << ustat
154 166 end
155 167 if params[:commit] == 'download csv' then
156 168 csv = gen_csv_from_scorearray(@scorearray,@problems)
157 169 send_data csv, filename: 'last_score.csv'
158 170 else
159 171 render template: 'user_admin/user_stat'
160 172 end
161 173 end
162 174
163 175 def user_stat_max
164 176 if params[:commit] == 'download csv'
165 177 @problems = Problem.all
166 178 else
167 179 @problems = Problem.available_problems
168 180 end
169 181 @users = User.includes(:contests).includes(:contest_stat).all
170 182 @scorearray = Array.new
171 183 #set up range from param
172 184 since_id = params.fetch(:since_id, 0).to_i
173 185 until_id = params.fetch(:until_id, 0).to_i
174 186 @users.each do |u|
175 187 ustat = Array.new
176 188 ustat[0] = u
177 189 @problems.each do |p|
178 190 max_points = 0
179 191 Submission.find_in_range_by_user_and_problem(u.id,p.id,since_id,until_id).each do |sub|
180 192 max_points = sub.points if sub and sub.points and (sub.points > max_points)
181 193 end
182 194 ustat << [(max_points.to_f*100/p.full_score).round, (max_points>=p.full_score)]
183 195 end
184 196 @scorearray << ustat
185 197 end
186 198
187 199 if params[:commit] == 'download csv' then
188 200 csv = gen_csv_from_scorearray(@scorearray,@problems)
189 201 send_data csv, filename: 'max_score.csv'
190 202 else
191 203 render template: 'user_admin/user_stat'
192 204 end
193 205 end
194 206
195 207 def import
196 208 if params[:file]==''
197 209 flash[:notice] = 'Error importing no file'
198 210 redirect_to :action => 'index' and return
199 211 end
200 212 import_from_file(params[:file])
201 213 end
202 214
203 215 def random_all_passwords
204 216 users = User.all
205 217 @prefix = params[:prefix] || ''
206 218 @non_admin_users = User.find_non_admin_with_prefix(@prefix)
207 219 @changed = false
208 220 if request.request_method == 'POST'
209 221 @non_admin_users.each do |user|
210 222 password = random_password
211 223 user.password = password
212 224 user.password_confirmation = password
213 225 user.save
214 226 end
215 227 @changed = true
216 228 end
217 229 end
218 230
219 231 # contest management
220 232
221 233 def contests
222 234 @contest, @users = find_contest_and_user_from_contest_id(params[:id])
223 235 @contests = Contest.enabled
224 236 end
225 237
226 238 def assign_from_list
227 239 contest_id = params[:users_contest_id]
228 240 org_contest, users = find_contest_and_user_from_contest_id(contest_id)
229 241 contest = Contest.find(params[:new_contest][:id])
230 242 if !contest
231 243 flash[:notice] = 'Error: no contest'
232 244 redirect_to :action => 'contests', :id =>contest_id
233 245 end
234 246
235 247 note = []
236 248 users.each do |u|
237 249 u.contests = [contest]
238 250 note << u.login
239 251 end
240 252 flash[:notice] = 'User(s) ' + note.join(', ') +
241 253 " were successfully reassigned to #{contest.title}."
242 254 redirect_to :action => 'contests', :id =>contest.id
243 255 end
244 256
245 257 def add_to_contest
246 258 user = User.find(params[:id])
247 259 contest = Contest.find(params[:contest_id])
248 260 if user and contest
249 261 user.contests << contest
250 262 end
251 263 redirect_to :action => 'index'
252 264 end
253 265
254 266 def remove_from_contest
255 267 user = User.find(params[:id])
256 268 contest = Contest.find(params[:contest_id])
257 269 if user and contest
258 270 user.contests.delete(contest)
259 271 end
260 272 redirect_to :action => 'index'
261 273 end
262 274
263 275 def contest_management
264 276 end
265 277
266 278 def manage_contest
267 279 contest = Contest.find(params[:contest][:id])
268 280 if !contest
269 281 flash[:notice] = 'You did not choose the contest.'
270 282 redirect_to :action => 'contest_management' and return
271 283 end
272 284
273 285 operation = params[:operation]
274 286
275 287 if not ['add','remove','assign'].include? operation
276 288 flash[:notice] = 'You did not choose the operation to perform.'
277 289 redirect_to :action => 'contest_management' and return
278 290 end
279 291
280 292 lines = params[:login_list]
281 293 if !lines or lines.blank?
282 294 flash[:notice] = 'You entered an empty list.'
283 295 redirect_to :action => 'contest_management' and return
284 296 end
285 297
286 298 note = []
287 299 users = []
288 300 lines.split("\n").each do |line|
289 301 user = User.find_by_login(line.chomp)
290 302 if user
291 303 if operation=='add'
292 304 if ! user.contests.include? contest
293 305 user.contests << contest
294 306 end
295 307 elsif operation=='remove'
296 308 user.contests.delete(contest)
297 309 else
298 310 user.contests = [contest]
299 311 end
300 312
301 313 if params[:reset_timer]
302 314 user.contest_stat.forced_logout = true
303 315 user.contest_stat.reset_timer_and_save
304 316 end
305 317
306 318 if params[:notification_emails]
307 319 send_contest_update_notification_email(user, contest)
308 320 end
309 321
310 322 note << user.login
311 323 users << user
312 324 end
313 325 end
314 326
315 327 if params[:reset_timer]
316 328 logout_users(users)
317 329 end
318 330
319 331 flash[:notice] = 'User(s) ' + note.join(', ') +
320 332 ' were successfully modified. '
321 333 redirect_to :action => 'contest_management'
322 334 end
323 335
324 336 # admin management
325 337
326 338 def admin
327 339 @admins = User.all.find_all {|user| user.admin? }
328 340 end
329 341
330 342 def grant_admin
331 343 login = params[:login]
332 344 user = User.find_by_login(login)
333 345 if user!=nil
334 346 admin_role = Role.find_by_name('admin')
335 347 user.roles << admin_role
336 348 else
337 349 flash[:notice] = 'Unknown user'
338 350 end
339 351 flash[:notice] = 'User added as admins'
340 352 redirect_to :action => 'admin'
341 353 end
342 354
343 355 def revoke_admin
344 356 user = User.find(params[:id])
345 357 if user==nil
346 358 flash[:notice] = 'Unknown user'
347 359 redirect_to :action => 'admin' and return
348 360 elsif user.login == 'root'
349 361 flash[:notice] = 'You cannot revoke admisnistrator permission from root.'
350 362 redirect_to :action => 'admin' and return
351 363 end
352 364
353 365 admin_role = Role.find_by_name('admin')
354 366 user.roles.delete(admin_role)
355 367 flash[:notice] = 'User permission revoked'
356 368 redirect_to :action => 'admin'
357 369 end
358 370
359 371 # mass mailing
360 372
361 373 def mass_mailing
362 374 end
363 375
364 376 def bulk_mail
365 377 lines = params[:login_list]
366 378 if !lines or lines.blank?
367 379 flash[:notice] = 'You entered an empty list.'
368 380 redirect_to :action => 'mass_mailing' and return
369 381 end
370 382
371 383 mail_subject = params[:subject]
372 384 if !mail_subject or mail_subject.blank?
373 385 flash[:notice] = 'You entered an empty mail subject.'
374 386 redirect_to :action => 'mass_mailing' and return
375 387 end
376 388
377 389 mail_body = params[:email_body]
378 390 if !mail_body or mail_body.blank?
379 391 flash[:notice] = 'You entered an empty mail body.'
380 392 redirect_to :action => 'mass_mailing' and return
381 393 end
382 394
383 395 note = []
384 396 users = []
385 397 lines.split("\n").each do |line|
386 398 user = User.find_by_login(line.chomp)
387 399 if user
388 400 send_mail(user.email, mail_subject, mail_body)
389 401 note << user.login
390 402 end
391 403 end
392 404
393 405 flash[:notice] = 'User(s) ' + note.join(', ') +
394 406 ' were successfully modified. '
395 407 redirect_to :action => 'mass_mailing'
396 408 end
397 409
398 410 protected
399 411
400 412 def random_password(length=5)
401 413 chars = 'abcdefghijkmnopqrstuvwxyz23456789'
402 414 newpass = ""
403 415 length.times { newpass << chars[rand(chars.size-1)] }
404 416 return newpass
405 417 end
406 418
407 419 def import_from_file(f)
408 420 data_hash = YAML.load(f)
409 421 @import_log = ""
410 422
411 423 country_data = data_hash[:countries]
412 424 site_data = data_hash[:sites]
413 425 user_data = data_hash[:users]
414 426
415 427 # import country
416 428 countries = {}
417 429 country_data.each_pair do |id,country|
418 430 c = Country.find_by_name(country[:name])
419 431 if c!=nil
420 432 countries[id] = c
421 433 @import_log << "Found #{country[:name]}\n"
422 434 else
423 435 countries[id] = Country.new(:name => country[:name])
424 436 countries[id].save
425 437 @import_log << "Created #{country[:name]}\n"
426 438 end
427 439 end
428 440
429 441 # import sites
430 442 sites = {}
431 443 site_data.each_pair do |id,site|
432 444 s = Site.find_by_name(site[:name])
433 445 if s!=nil
434 446 @import_log << "Found #{site[:name]}\n"
435 447 else
436 448 s = Site.new(:name => site[:name])
437 449 @import_log << "Created #{site[:name]}\n"
438 450 end
439 451 s.password = site[:password]
440 452 s.country = countries[site[:country_id]]
441 453 s.save
442 454 sites[id] = s
443 455 end
444 456
445 457 # import users
446 458 user_data.each_pair do |id,user|
447 459 u = User.find_by_login(user[:login])
448 460 if u!=nil
449 461 @import_log << "Found #{user[:login]}\n"
450 462 else
451 463 u = User.new(:login => user[:login])
452 464 @import_log << "Created #{user[:login]}\n"
453 465 end
454 466 u.full_name = user[:name]
455 467 u.password = user[:password]
456 468 u.country = countries[user[:country_id]]
457 469 u.site = sites[user[:site_id]]
458 470 u.activated = true
459 471 u.email = "empty-#{u.login}@none.com"
460 472 if not u.save
461 473 @import_log << "Errors\n"
462 474 u.errors.each { |attr,msg| @import_log << "#{attr} - #{msg}\n" }
463 475 end
464 476 end
465 477
466 478 end
467 479
468 480 def logout_users(users)
469 481 users.each do |user|
470 482 contest_stat = user.contest_stat(true)
471 483 if contest_stat and !contest_stat.forced_logout
472 484 contest_stat.forced_logout = true
473 485 contest_stat.save
474 486 end
475 487 end
476 488 end
477 489
478 490 def send_contest_update_notification_email(user, contest)
479 491 contest_title_name = GraderConfiguration['contest.name']
480 492 contest_name = contest.name
481 493 mail_subject = t('contest.notification.email_subject', {
You need to be logged in to leave comments. Login now