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,529 +1,529
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)
338 if user!=nil
338 if user!=nil
339 admin_role = Role.find_by_name('admin')
339 admin_role = Role.find_by_name('admin')
340 user.roles << admin_role
340 user.roles << admin_role
341 else
341 else
342 flash[:notice] = 'Unknown user'
342 flash[:notice] = 'Unknown user'
343 end
343 end
344 flash[:notice] = 'User added as admins'
344 flash[:notice] = 'User added as admins'
345 redirect_to :action => 'admin'
345 redirect_to :action => 'admin'
346 end
346 end
347
347
348 def revoke_admin
348 def revoke_admin
349 user = User.find(params[:id])
349 user = User.find(params[:id])
350 if user==nil
350 if user==nil
351 flash[:notice] = 'Unknown user'
351 flash[:notice] = 'Unknown user'
352 redirect_to :action => 'admin' and return
352 redirect_to :action => 'admin' and return
353 elsif user.login == 'root'
353 elsif user.login == 'root'
354 flash[:notice] = 'You cannot revoke admisnistrator permission from root.'
354 flash[:notice] = 'You cannot revoke admisnistrator permission from root.'
355 redirect_to :action => 'admin' and return
355 redirect_to :action => 'admin' and return
356 end
356 end
357
357
358 admin_role = Role.find_by_name('admin')
358 admin_role = Role.find_by_name('admin')
359 user.roles.delete(admin_role)
359 user.roles.delete(admin_role)
360 flash[:notice] = 'User permission revoked'
360 flash[:notice] = 'User permission revoked'
361 redirect_to :action => 'admin'
361 redirect_to :action => 'admin'
362 end
362 end
363
363
364 # mass mailing
364 # mass mailing
365
365
366 def mass_mailing
366 def mass_mailing
367 end
367 end
368
368
369 def bulk_mail
369 def bulk_mail
370 lines = params[:login_list]
370 lines = params[:login_list]
371 if !lines or lines.blank?
371 if !lines or lines.blank?
372 flash[:notice] = 'You entered an empty list.'
372 flash[:notice] = 'You entered an empty list.'
373 redirect_to :action => 'mass_mailing' and return
373 redirect_to :action => 'mass_mailing' and return
374 end
374 end
375
375
376 mail_subject = params[:subject]
376 mail_subject = params[:subject]
377 if !mail_subject or mail_subject.blank?
377 if !mail_subject or mail_subject.blank?
378 flash[:notice] = 'You entered an empty mail subject.'
378 flash[:notice] = 'You entered an empty mail subject.'
379 redirect_to :action => 'mass_mailing' and return
379 redirect_to :action => 'mass_mailing' and return
380 end
380 end
381
381
382 mail_body = params[:email_body]
382 mail_body = params[:email_body]
383 if !mail_body or mail_body.blank?
383 if !mail_body or mail_body.blank?
384 flash[:notice] = 'You entered an empty mail body.'
384 flash[:notice] = 'You entered an empty mail body.'
385 redirect_to :action => 'mass_mailing' and return
385 redirect_to :action => 'mass_mailing' and return
386 end
386 end
387
387
388 note = []
388 note = []
389 users = []
389 users = []
390 lines.split("\n").each do |line|
390 lines.split("\n").each do |line|
391 user = User.find_by_login(line.chomp)
391 user = User.find_by_login(line.chomp)
392 if user
392 if user
393 send_mail(user.email, mail_subject, mail_body)
393 send_mail(user.email, mail_subject, mail_body)
394 note << user.login
394 note << user.login
395 end
395 end
396 end
396 end
397
397
398 flash[:notice] = 'User(s) ' + note.join(', ') +
398 flash[:notice] = 'User(s) ' + note.join(', ') +
399 ' were successfully modified. '
399 ' were successfully modified. '
400 redirect_to :action => 'mass_mailing'
400 redirect_to :action => 'mass_mailing'
401 end
401 end
402
402
403 protected
403 protected
404
404
405 def random_password(length=5)
405 def random_password(length=5)
406 chars = 'abcdefghijkmnopqrstuvwxyz23456789'
406 chars = 'abcdefghijkmnopqrstuvwxyz23456789'
407 newpass = ""
407 newpass = ""
408 length.times { newpass << chars[rand(chars.size-1)] }
408 length.times { newpass << chars[rand(chars.size-1)] }
409 return newpass
409 return newpass
410 end
410 end
411
411
412 def import_from_file(f)
412 def import_from_file(f)
413 data_hash = YAML.load(f)
413 data_hash = YAML.load(f)
414 @import_log = ""
414 @import_log = ""
415
415
416 country_data = data_hash[:countries]
416 country_data = data_hash[:countries]
417 site_data = data_hash[:sites]
417 site_data = data_hash[:sites]
418 user_data = data_hash[:users]
418 user_data = data_hash[:users]
419
419
420 # import country
420 # import country
421 countries = {}
421 countries = {}
422 country_data.each_pair do |id,country|
422 country_data.each_pair do |id,country|
423 c = Country.find_by_name(country[:name])
423 c = Country.find_by_name(country[:name])
424 if c!=nil
424 if c!=nil
425 countries[id] = c
425 countries[id] = c
426 @import_log << "Found #{country[:name]}\n"
426 @import_log << "Found #{country[:name]}\n"
427 else
427 else
428 countries[id] = Country.new(:name => country[:name])
428 countries[id] = Country.new(:name => country[:name])
429 countries[id].save
429 countries[id].save
430 @import_log << "Created #{country[:name]}\n"
430 @import_log << "Created #{country[:name]}\n"
431 end
431 end
432 end
432 end
433
433
434 # import sites
434 # import sites
435 sites = {}
435 sites = {}
436 site_data.each_pair do |id,site|
436 site_data.each_pair do |id,site|
437 s = Site.find_by_name(site[:name])
437 s = Site.find_by_name(site[:name])
438 if s!=nil
438 if s!=nil
439 @import_log << "Found #{site[:name]}\n"
439 @import_log << "Found #{site[:name]}\n"
440 else
440 else
441 s = Site.new(:name => site[:name])
441 s = Site.new(:name => site[:name])
442 @import_log << "Created #{site[:name]}\n"
442 @import_log << "Created #{site[:name]}\n"
443 end
443 end
444 s.password = site[:password]
444 s.password = site[:password]
445 s.country = countries[site[:country_id]]
445 s.country = countries[site[:country_id]]
446 s.save
446 s.save
447 sites[id] = s
447 sites[id] = s
448 end
448 end
449
449
450 # import users
450 # import users
451 user_data.each_pair do |id,user|
451 user_data.each_pair do |id,user|
452 u = User.find_by_login(user[:login])
452 u = User.find_by_login(user[:login])
453 if u!=nil
453 if u!=nil
454 @import_log << "Found #{user[:login]}\n"
454 @import_log << "Found #{user[:login]}\n"
455 else
455 else
456 u = User.new(:login => user[:login])
456 u = User.new(:login => user[:login])
457 @import_log << "Created #{user[:login]}\n"
457 @import_log << "Created #{user[:login]}\n"
458 end
458 end
459 u.full_name = user[:name]
459 u.full_name = user[:name]
460 u.password = user[:password]
460 u.password = user[:password]
461 u.country = countries[user[:country_id]]
461 u.country = countries[user[:country_id]]
462 u.site = sites[user[:site_id]]
462 u.site = sites[user[:site_id]]
463 u.activated = true
463 u.activated = true
464 u.email = "empty-#{u.login}@none.com"
464 u.email = "empty-#{u.login}@none.com"
465 if not u.save
465 if not u.save
466 @import_log << "Errors\n"
466 @import_log << "Errors\n"
467 u.errors.each { |attr,msg| @import_log << "#{attr} - #{msg}\n" }
467 u.errors.each { |attr,msg| @import_log << "#{attr} - #{msg}\n" }
468 end
468 end
469 end
469 end
470
470
471 end
471 end
472
472
473 def logout_users(users)
473 def logout_users(users)
474 users.each do |user|
474 users.each do |user|
475 contest_stat = user.contest_stat(true)
475 contest_stat = user.contest_stat(true)
476 if contest_stat and !contest_stat.forced_logout
476 if contest_stat and !contest_stat.forced_logout
477 contest_stat.forced_logout = true
477 contest_stat.forced_logout = true
478 contest_stat.save
478 contest_stat.save
479 end
479 end
480 end
480 end
481 end
481 end
482
482
483 def send_contest_update_notification_email(user, contest)
483 def send_contest_update_notification_email(user, contest)
484 contest_title_name = GraderConfiguration['contest.name']
484 contest_title_name = GraderConfiguration['contest.name']
485 contest_name = contest.name
485 contest_name = contest.name
486 mail_subject = t('contest.notification.email_subject', {
486 mail_subject = t('contest.notification.email_subject', {
487 :contest_title_name => contest_title_name,
487 :contest_title_name => contest_title_name,
488 :contest_name => contest_name })
488 :contest_name => contest_name })
489 mail_body = t('contest.notification.email_body', {
489 mail_body = t('contest.notification.email_body', {
490 :full_name => user.full_name,
490 :full_name => user.full_name,
491 :contest_title_name => contest_title_name,
491 :contest_title_name => contest_title_name,
492 :contest_name => contest.name,
492 :contest_name => contest.name,
493 })
493 })
494
494
495 logger.info mail_body
495 logger.info mail_body
496 send_mail(user.email, mail_subject, mail_body)
496 send_mail(user.email, mail_subject, mail_body)
497 end
497 end
498
498
499 def find_contest_and_user_from_contest_id(id)
499 def find_contest_and_user_from_contest_id(id)
500 if id!='none'
500 if id!='none'
501 @contest = Contest.find(id)
501 @contest = Contest.find(id)
502 else
502 else
503 @contest = nil
503 @contest = nil
504 end
504 end
505 if @contest
505 if @contest
506 @users = @contest.users
506 @users = @contest.users
507 else
507 else
508 @users = User.find_users_with_no_contest
508 @users = User.find_users_with_no_contest
509 end
509 end
510 return [@contest, @users]
510 return [@contest, @users]
511 end
511 end
512
512
513 def gen_csv_from_scorearray(scorearray,problem)
513 def gen_csv_from_scorearray(scorearray,problem)
514 CSV.generate do |csv|
514 CSV.generate do |csv|
515 #add header
515 #add header
516 header = ['User','Name', 'Activated?', 'Logged in', 'Contest']
516 header = ['User','Name', 'Activated?', 'Logged in', 'Contest']
517 problem.each { |p| header << p.name }
517 problem.each { |p| header << p.name }
518 header += ['Total','Passed']
518 header += ['Total','Passed']
519 csv << header
519 csv << header
520 #add data
520 #add data
521 scorearray.each do |sc|
521 scorearray.each do |sc|
522 total = num_passed = 0
522 total = num_passed = 0
523 row = Array.new
523 row = Array.new
524 sc.each_index do |i|
524 sc.each_index do |i|
525 if i == 0
525 if i == 0
526 row << sc[i].login
526 row << sc[i].login
527 row << sc[i].full_name
527 row << sc[i].full_name
528 row << sc[i].activated
528 row << sc[i].activated
529 row << (sc[i].try(:contest_stat).try(:started_at)!=nil ? 'yes' : 'no')
529 row << (sc[i].try(:contest_stat).try(:started_at)!=nil ? 'yes' : 'no')
You need to be logged in to leave comments. Login now