Description:
add options for bulk manage add user to group (not finished)
Commit status:
[Not Reviewed]
References:
Comments:
0 Commit comments 0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
Add another comment

r671:52ce712479a1 - - 2 files changed: 17 inserted, 0 deleted

@@ -183,96 +183,97
183 #set up range from param
183 #set up range from param
184 since_id = params.fetch(:since_id, 0).to_i
184 since_id = params.fetch(:since_id, 0).to_i
185 until_id = params.fetch(:until_id, 0).to_i
185 until_id = params.fetch(:until_id, 0).to_i
186 @users.each do |u|
186 @users.each do |u|
187 ustat = Array.new
187 ustat = Array.new
188 ustat[0] = u
188 ustat[0] = u
189 @problems.each do |p|
189 @problems.each do |p|
190 max_points = 0
190 max_points = 0
191 Submission.find_in_range_by_user_and_problem(u.id,p.id,since_id,until_id).each do |sub|
191 Submission.find_in_range_by_user_and_problem(u.id,p.id,since_id,until_id).each do |sub|
192 max_points = sub.points if sub and sub.points and (sub.points > max_points)
192 max_points = sub.points if sub and sub.points and (sub.points > max_points)
193 end
193 end
194 ustat << [(max_points.to_f*100/p.full_score).round, (max_points>=p.full_score)]
194 ustat << [(max_points.to_f*100/p.full_score).round, (max_points>=p.full_score)]
195 end
195 end
196 @scorearray << ustat
196 @scorearray << ustat
197 end
197 end
198
198
199 if params[:commit] == 'download csv' then
199 if params[:commit] == 'download csv' then
200 csv = gen_csv_from_scorearray(@scorearray,@problems)
200 csv = gen_csv_from_scorearray(@scorearray,@problems)
201 send_data csv, filename: 'max_score.csv'
201 send_data csv, filename: 'max_score.csv'
202 else
202 else
203 render template: 'user_admin/user_stat'
203 render template: 'user_admin/user_stat'
204 end
204 end
205 end
205 end
206
206
207 def import
207 def import
208 if params[:file]==''
208 if params[:file]==''
209 flash[:notice] = 'Error importing no file'
209 flash[:notice] = 'Error importing no file'
210 redirect_to :action => 'index' and return
210 redirect_to :action => 'index' and return
211 end
211 end
212 import_from_file(params[:file])
212 import_from_file(params[:file])
213 end
213 end
214
214
215 def random_all_passwords
215 def random_all_passwords
216 users = User.all
216 users = User.all
217 @prefix = params[:prefix] || ''
217 @prefix = params[:prefix] || ''
218 @non_admin_users = User.find_non_admin_with_prefix(@prefix)
218 @non_admin_users = User.find_non_admin_with_prefix(@prefix)
219 @changed = false
219 @changed = false
220 if request.request_method == 'POST'
220 if request.request_method == 'POST'
221 @non_admin_users.each do |user|
221 @non_admin_users.each do |user|
222 password = random_password
222 password = random_password
223 user.password = password
223 user.password = password
224 user.password_confirmation = password
224 user.password_confirmation = password
225 user.save
225 user.save
226 end
226 end
227 @changed = true
227 @changed = true
228 end
228 end
229 end
229 end
230
230
231 +
231 # contest management
232 # contest management
232
233
233 def contests
234 def contests
234 @contest, @users = find_contest_and_user_from_contest_id(params[:id])
235 @contest, @users = find_contest_and_user_from_contest_id(params[:id])
235 @contests = Contest.enabled
236 @contests = Contest.enabled
236 end
237 end
237
238
238 def assign_from_list
239 def assign_from_list
239 contest_id = params[:users_contest_id]
240 contest_id = params[:users_contest_id]
240 org_contest, users = find_contest_and_user_from_contest_id(contest_id)
241 org_contest, users = find_contest_and_user_from_contest_id(contest_id)
241 contest = Contest.find(params[:new_contest][:id])
242 contest = Contest.find(params[:new_contest][:id])
242 if !contest
243 if !contest
243 flash[:notice] = 'Error: no contest'
244 flash[:notice] = 'Error: no contest'
244 redirect_to :action => 'contests', :id =>contest_id
245 redirect_to :action => 'contests', :id =>contest_id
245 end
246 end
246
247
247 note = []
248 note = []
248 users.each do |u|
249 users.each do |u|
249 u.contests = [contest]
250 u.contests = [contest]
250 note << u.login
251 note << u.login
251 end
252 end
252 flash[:notice] = 'User(s) ' + note.join(', ') +
253 flash[:notice] = 'User(s) ' + note.join(', ') +
253 " were successfully reassigned to #{contest.title}."
254 " were successfully reassigned to #{contest.title}."
254 redirect_to :action => 'contests', :id =>contest.id
255 redirect_to :action => 'contests', :id =>contest.id
255 end
256 end
256
257
257 def add_to_contest
258 def add_to_contest
258 user = User.find(params[:id])
259 user = User.find(params[:id])
259 contest = Contest.find(params[:contest_id])
260 contest = Contest.find(params[:contest_id])
260 if user and contest
261 if user and contest
261 user.contests << contest
262 user.contests << contest
262 end
263 end
263 redirect_to :action => 'index'
264 redirect_to :action => 'index'
264 end
265 end
265
266
266 def remove_from_contest
267 def remove_from_contest
267 user = User.find(params[:id])
268 user = User.find(params[:id])
268 contest = Contest.find(params[:contest_id])
269 contest = Contest.find(params[:contest_id])
269 if user and contest
270 if user and contest
270 user.contests.delete(contest)
271 user.contests.delete(contest)
271 end
272 end
272 redirect_to :action => 'index'
273 redirect_to :action => 'index'
273 end
274 end
274
275
275 def contest_management
276 def contest_management
276 end
277 end
277
278
278 def manage_contest
279 def manage_contest
@@ -378,110 +379,117
378 if !lines or lines.blank?
379 if !lines or lines.blank?
379 flash[:notice] = 'You entered an empty list.'
380 flash[:notice] = 'You entered an empty list.'
380 redirect_to :action => 'mass_mailing' and return
381 redirect_to :action => 'mass_mailing' and return
381 end
382 end
382
383
383 mail_subject = params[:subject]
384 mail_subject = params[:subject]
384 if !mail_subject or mail_subject.blank?
385 if !mail_subject or mail_subject.blank?
385 flash[:notice] = 'You entered an empty mail subject.'
386 flash[:notice] = 'You entered an empty mail subject.'
386 redirect_to :action => 'mass_mailing' and return
387 redirect_to :action => 'mass_mailing' and return
387 end
388 end
388
389
389 mail_body = params[:email_body]
390 mail_body = params[:email_body]
390 if !mail_body or mail_body.blank?
391 if !mail_body or mail_body.blank?
391 flash[:notice] = 'You entered an empty mail body.'
392 flash[:notice] = 'You entered an empty mail body.'
392 redirect_to :action => 'mass_mailing' and return
393 redirect_to :action => 'mass_mailing' and return
393 end
394 end
394
395
395 note = []
396 note = []
396 users = []
397 users = []
397 lines.split("\n").each do |line|
398 lines.split("\n").each do |line|
398 user = User.find_by_login(line.chomp)
399 user = User.find_by_login(line.chomp)
399 if user
400 if user
400 send_mail(user.email, mail_subject, mail_body)
401 send_mail(user.email, mail_subject, mail_body)
401 note << user.login
402 note << user.login
402 end
403 end
403 end
404 end
404
405
405 flash[:notice] = 'User(s) ' + note.join(', ') +
406 flash[:notice] = 'User(s) ' + note.join(', ') +
406 ' were successfully modified. '
407 ' were successfully modified. '
407 redirect_to :action => 'mass_mailing'
408 redirect_to :action => 'mass_mailing'
408 end
409 end
409
410
410 #bulk manage
411 #bulk manage
411 def bulk_manage
412 def bulk_manage
412
413
413 begin
414 begin
414 @users = User.where('login REGEXP ?',params[:regex]) if params[:regex]
415 @users = User.where('login REGEXP ?',params[:regex]) if params[:regex]
415 @users.count if @users #i don't know why I have to call count, but if I won't exception is not raised
416 @users.count if @users #i don't know why I have to call count, but if I won't exception is not raised
416 rescue Exception
417 rescue Exception
417 flash[:error] = 'Regular Expression is malformed'
418 flash[:error] = 'Regular Expression is malformed'
418 @users = nil
419 @users = nil
419 end
420 end
420
421
421 if params[:commit]
422 if params[:commit]
422 @action = {}
423 @action = {}
423 @action[:set_enable] = params[:enabled]
424 @action[:set_enable] = params[:enabled]
424 @action[:enabled] = params[:enable] == "1"
425 @action[:enabled] = params[:enable] == "1"
425 @action[:gen_password] = params[:gen_password]
426 @action[:gen_password] = params[:gen_password]
427 + @action[:add_group] = params[:add_group]
428 + @action[:group_name] = params[:group_name]
426 end
429 end
427
430
428 if params[:commit] == "Perform"
431 if params[:commit] == "Perform"
429 if @action[:set_enable]
432 if @action[:set_enable]
430 @users.update_all(enabled: @action[:enabled])
433 @users.update_all(enabled: @action[:enabled])
431 end
434 end
432 if @action[:gen_password]
435 if @action[:gen_password]
433 @users.each do |u|
436 @users.each do |u|
434 password = random_password
437 password = random_password
435 u.password = password
438 u.password = password
436 u.password_confirmation = password
439 u.password_confirmation = password
437 u.save
440 u.save
438 end
441 end
439 end
442 end
443 + if @action[:add_group]
444 + @uses.each do |u|
445 +
446 + end
447 + end
440 end
448 end
441 end
449 end
442
450
443 protected
451 protected
444
452
445 def random_password(length=5)
453 def random_password(length=5)
446 chars = 'abcdefghijkmnopqrstuvwxyz23456789'
454 chars = 'abcdefghijkmnopqrstuvwxyz23456789'
447 newpass = ""
455 newpass = ""
448 length.times { newpass << chars[rand(chars.size-1)] }
456 length.times { newpass << chars[rand(chars.size-1)] }
449 return newpass
457 return newpass
450 end
458 end
451
459
452 def import_from_file(f)
460 def import_from_file(f)
453 data_hash = YAML.load(f)
461 data_hash = YAML.load(f)
454 @import_log = ""
462 @import_log = ""
455
463
456 country_data = data_hash[:countries]
464 country_data = data_hash[:countries]
457 site_data = data_hash[:sites]
465 site_data = data_hash[:sites]
458 user_data = data_hash[:users]
466 user_data = data_hash[:users]
459
467
460 # import country
468 # import country
461 countries = {}
469 countries = {}
462 country_data.each_pair do |id,country|
470 country_data.each_pair do |id,country|
463 c = Country.find_by_name(country[:name])
471 c = Country.find_by_name(country[:name])
464 if c!=nil
472 if c!=nil
465 countries[id] = c
473 countries[id] = c
466 @import_log << "Found #{country[:name]}\n"
474 @import_log << "Found #{country[:name]}\n"
467 else
475 else
468 countries[id] = Country.new(:name => country[:name])
476 countries[id] = Country.new(:name => country[:name])
469 countries[id].save
477 countries[id].save
470 @import_log << "Created #{country[:name]}\n"
478 @import_log << "Created #{country[:name]}\n"
471 end
479 end
472 end
480 end
473
481
474 # import sites
482 # import sites
475 sites = {}
483 sites = {}
476 site_data.each_pair do |id,site|
484 site_data.each_pair do |id,site|
477 s = Site.find_by_name(site[:name])
485 s = Site.find_by_name(site[:name])
478 if s!=nil
486 if s!=nil
479 @import_log << "Found #{site[:name]}\n"
487 @import_log << "Found #{site[:name]}\n"
480 else
488 else
481 s = Site.new(:name => site[:name])
489 s = Site.new(:name => site[:name])
482 @import_log << "Created #{site[:name]}\n"
490 @import_log << "Created #{site[:name]}\n"
483 end
491 end
484 s.password = site[:password]
492 s.password = site[:password]
485 s.country = countries[site[:country_id]]
493 s.country = countries[site[:country_id]]
486 s.save
494 s.save
487 sites[id] = s
495 sites[id] = s
@@ -1,77 +1,86
1 %h1 Bulk Manage User
1 %h1 Bulk Manage User
2
2
3 = form_tag bulk_manage_user_admin_path
3 = form_tag bulk_manage_user_admin_path
4 .row
4 .row
5 .col-md-6
5 .col-md-6
6 .panel.panel-primary
6 .panel.panel-primary
7 .panel-title.panel-heading
7 .panel-title.panel-heading
8 Filter User
8 Filter User
9 .panel-body
9 .panel-body
10 Filtering users whose login match the following MySQL regex
10 Filtering users whose login match the following MySQL regex
11 .form-group
11 .form-group
12 = label_tag "regex", 'Regex Pattern'
12 = label_tag "regex", 'Regex Pattern'
13 = text_field_tag "regex", params[:regex], class: 'form-control'
13 = text_field_tag "regex", params[:regex], class: 'form-control'
14 %p
14 %p
15 Example
15 Example
16 %ul
16 %ul
17 %li
17 %li
18 %code root
18 %code root
19 matches every user whose login contains "root"
19 matches every user whose login contains "root"
20 %li
20 %li
21 %code ^56
21 %code ^56
22 matches every user whose login starts with "56"
22 matches every user whose login starts with "56"
23 %li
23 %li
24 %code 21$
24 %code 21$
25 matches every user whose login ends with "21"
25 matches every user whose login ends with "21"
26 .col-md-6
26 .col-md-6
27 .panel.panel-primary
27 .panel.panel-primary
28 .panel-title.panel-heading
28 .panel-title.panel-heading
29 Action
29 Action
30 .panel-body
30 .panel-body
31 .row.form-group
31 .row.form-group
32 .col-md-6
32 .col-md-6
33 %label.checkbox-inline
33 %label.checkbox-inline
34 = check_box_tag "enabled", true, params[:enabled]
34 = check_box_tag "enabled", true, params[:enabled]
35 Change "Enabled" to
35 Change "Enabled" to
36 .col-md-3
36 .col-md-3
37 %label.radio-inline
37 %label.radio-inline
38 = radio_button_tag "enable", 1, params[:enable] == '1', id: 'enable-yes'
38 = radio_button_tag "enable", 1, params[:enable] == '1', id: 'enable-yes'
39 Yes
39 Yes
40 .col-md-3
40 .col-md-3
41 %label.radio-inline
41 %label.radio-inline
42 = radio_button_tag "enable", 0, params[:enable] == '0', id: 'enable-no'
42 = radio_button_tag "enable", 0, params[:enable] == '0', id: 'enable-no'
43 No
43 No
44 .row.form-group
44 .row.form-group
45 .col-md-6
45 .col-md-6
46 %label.checkbox-inline
46 %label.checkbox-inline
47 = check_box_tag "gen_password", true, params[:gen_password]
47 = check_box_tag "gen_password", true, params[:gen_password]
48 Generate new random password
48 Generate new random password
49 + .row.form-group
50 + .col-md-4
51 + %label.checkbox-inline
52 + = check_box_tag "add_group", true, params[:add_group]
53 + Add users to group
54 + %label.col-md-3.control-label.text-right Group name
55 + .col-md-5
56 + = text_field_tag "group_name", params[:group_name], id: 'group_name',class: 'form-control select2'
57 +
49
58
50 .row
59 .row
51 .col-md-12
60 .col-md-12
52 = submit_tag "Preview Result", class: 'btn btn-default'
61 = submit_tag "Preview Result", class: 'btn btn-default'
53 - if @users
62 - if @users
54 .row
63 .row
55 .col-md-4
64 .col-md-4
56 - if @action
65 - if @action
57 %h2 Confirmation
66 %h2 Confirmation
58 - if @action[:set_enable]
67 - if @action[:set_enable]
59 .alert.alert-info The following users will be set #{(@action[:enabled] ? 'enable' : 'disable')}.
68 .alert.alert-info The following users will be set #{(@action[:enabled] ? 'enable' : 'disable')}.
60 - if @action[:gen_password]
69 - if @action[:gen_password]
61 .alert.alert-info The password of the following users will be randomly generated.
70 .alert.alert-info The password of the following users will be randomly generated.
62 .row
71 .row
63 .col-md-4
72 .col-md-4
64 = submit_tag "Perform", class: 'btn btn-primary'
73 = submit_tag "Perform", class: 'btn btn-primary'
65 .row
74 .row
66 .col-md-12
75 .col-md-12
67 The pattern matches #{@users.count} following users.
76 The pattern matches #{@users.count} following users.
68 %br
77 %br
69 - @users.each do |user|
78 - @users.each do |user|
70 = user.login
79 = user.login
71 = ' '
80 = ' '
72 = user.full_name
81 = user.full_name
73 = ' '
82 = ' '
74 = "(#{user.remark})" if user.remark
83 = "(#{user.remark})" if user.remark
75 %br
84 %br
76
85
77
86
You need to be logged in to leave comments. Login now