Description:
add options for bulk manage add user to group (not finished)
Commit status:
[Not Reviewed]
References:
Diff options:
Comments:
0 Commit comments
0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
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