Show More
Commit Description:
add current score by group
Commit Description:
add current score by group
References:
File last commit:
Show/Diff file:
Action:
app/controllers/user_admin_controller.rb
| 617 lines
| 16.2 KiB
| text/x-ruby
| RubyLexer
|
r449 | require 'csv' | |||
|
r0 | class UserAdminController < ApplicationController | ||
|
r336 | include MailHelperMethods | ||
r745 | before_action :admin_authorization | |||
|
r0 | |||
|
r320 | def index | ||
|
r299 | @user_count = User.count | ||
|
r300 | if params[:page] == 'all' | ||
@users = User.all | ||||
@paginated = false | ||||
else | ||||
@users = User.paginate :page => params[:page] | ||||
@paginated = true | ||||
end | ||||
r691 | @users = User.all | |||
|
r162 | @hidden_columns = ['hashed_password', 'salt', 'created_at', 'updated_at'] | ||
|
r297 | @contests = Contest.enabled | ||
|
r0 | end | ||
|
r190 | def active | ||
r619 | sessions = ActiveRecord::SessionStore::Session.where("updated_at >= ?", 60.minutes.ago) | |||
|
r190 | @users = [] | ||
sessions.each do |session| | ||||
if session.data[:user_id] | ||||
@users << User.find(session.data[:user_id]) | ||||
end | ||||
end | ||||
end | ||||
|
r0 | def show | ||
@user = User.find(params[:id]) | ||||
end | ||||
def new | ||||
@user = User.new | ||||
end | ||||
def create | ||||
r637 | @user = User.new(user_params) | |||
|
r155 | @user.activated = true | ||
|
r0 | if @user.save | ||
flash[:notice] = 'User was successfully created.' | ||||
r571 | redirect_to :action => 'index' | |||
|
r0 | else | ||
render :action => 'new' | ||||
|
r308 | end | ||
|
r0 | end | ||
r541 | def clear_last_ip | |||
@user = User.find(params[:id]) | ||||
@user.last_ip = nil | ||||
@user.save | ||||
r571 | redirect_to action: 'index', page: params[:page] | |||
r541 | end | |||
|
r4 | def create_from_list | ||
lines = params[:user_list] | ||||
|
r200 | |||
note = [] | ||||
r762 | error_note = [] | |||
ok_user = [] | ||||
|
r200 | |||
|
r4 | lines.split("\n").each do |line| | ||
|
r139 | items = line.chomp.split(',') | ||
|
r200 | if items.length>=2 | ||
login = items[0] | ||||
full_name = items[1] | ||||
r633 | remark ='' | |||
user_alias = '' | ||||
|
r200 | |||
added_random_password = false | ||||
r633 | if items.length >= 3 and items[2].chomp(" ").length > 0; | |||
|
r307 | password = items[2].chomp(" ") | ||
|
r200 | else | ||
password = random_password | ||||
r633 | add_random_password=true; | |||
end | ||||
if items.length>= 4 and items[3].chomp(" ").length > 0; | ||||
user_alias = items[3].chomp(" ") | ||||
else | ||||
user_alias = login | ||||
end | ||||
if items.length>=5 | ||||
remark = items[4].strip; | ||||
|
r200 | end | ||
r469 | user = User.find_by_login(login) | |||
if (user) | ||||
user.full_name = full_name | ||||
user.password = password | ||||
r633 | user.remark = remark | |||
r469 | else | |||
user = User.new({:login => login, | ||||
:full_name => full_name, | ||||
:password => password, | ||||
:password_confirmation => password, | ||||
r633 | :alias => user_alias, | |||
:remark => remark}) | ||||
r469 | end | |||
|
r155 | user.activated = true | ||
|
r200 | |||
r762 | if user.save | |||
if added_random_password | ||||
note << "'#{login}' (+)" | ||||
else | ||||
note << login | ||||
end | ||||
ok_user << user | ||||
|
r200 | else | ||
r762 | error_note << "#{login}" | |||
|
r200 | end | ||
r762 | ||||
|
r4 | end | ||
end | ||||
r762 | ||||
#add to group | ||||
if params[:add_to_group] | ||||
group = Group.where(id: params[:group_id]).first | ||||
if group | ||||
group.users << ok_user | ||||
end | ||||
end | ||||
# show flash | ||||
r634 | flash[:success] = 'User(s) ' + note.join(', ') + | |||
|
r200 | ' were successfully created. ' + | ||
'( (+) - created with random passwords.)' | ||||
r762 | if error_note.size > 0 | |||
flash[:error] = "Following user(s) failed to be created: " + error_note.join(', ') | ||||
end | ||||
r571 | redirect_to :action => 'index' | |||
|
r4 | end | ||
|
r0 | def edit | ||
@user = User.find(params[:id]) | ||||
end | ||||
def update | ||||
@user = User.find(params[:id]) | ||||
r617 | if @user.update_attributes(user_params) | |||
|
r0 | flash[:notice] = 'User was successfully updated.' | ||
redirect_to :action => 'show', :id => @user | ||||
else | ||||
render :action => 'edit' | ||||
end | ||||
end | ||||
def destroy | ||||
User.find(params[:id]).destroy | ||||
r571 | redirect_to :action => 'index' | |||
|
r0 | end | ||
def user_stat | ||||
r449 | if params[:commit] == 'download csv' | |||
@problems = Problem.all | ||||
else | ||||
r619 | @problems = Problem.available_problems | |||
r449 | end | |||
r619 | @users = User.includes(:contests, :contest_stat).where(enabled: true) | |||
|
r0 | @scorearray = Array.new | ||
@users.each do |u| | ||||
ustat = Array.new | ||||
|
r162 | ustat[0] = u | ||
|
r0 | @problems.each do |p| | ||
r350 | sub = Submission.find_last_by_user_and_problem(u.id,p.id) | |||
r527 | if (sub!=nil) and (sub.points!=nil) and p and p.full_score | |||
r350 | ustat << [(sub.points.to_f*100/p.full_score).round, (sub.points>=p.full_score)] | |||
else | ||||
ustat << [0,false] | ||||
end | ||||
end | ||||
@scorearray << ustat | ||||
end | ||||
r499 | if params[:commit] == 'download csv' then | |||
csv = gen_csv_from_scorearray(@scorearray,@problems) | ||||
send_data csv, filename: 'last_score.csv' | ||||
else | ||||
render template: 'user_admin/user_stat' | ||||
end | ||||
r480 | end | |||
def user_stat_max | ||||
r449 | if params[:commit] == 'download csv' | |||
@problems = Problem.all | ||||
else | ||||
r619 | @problems = Problem.available_problems | |||
r449 | end | |||
r619 | @users = User.includes(:contests).includes(:contest_stat).all | |||
r350 | @scorearray = Array.new | |||
#set up range from param | ||||
since_id = params.fetch(:since_id, 0).to_i | ||||
until_id = params.fetch(:until_id, 0).to_i | ||||
@users.each do |u| | ||||
ustat = Array.new | ||||
ustat[0] = u | ||||
@problems.each do |p| | ||||
max_points = 0 | ||||
Submission.find_in_range_by_user_and_problem(u.id,p.id,since_id,until_id).each do |sub| | ||||
max_points = sub.points if sub and sub.points and (sub.points > max_points) | ||||
end | ||||
ustat << [(max_points.to_f*100/p.full_score).round, (max_points>=p.full_score)] | ||||
|
r0 | end | ||
@scorearray << ustat | ||||
end | ||||
r430 | ||||
r449 | if params[:commit] == 'download csv' then | |||
csv = gen_csv_from_scorearray(@scorearray,@problems) | ||||
send_data csv, filename: 'max_score.csv' | ||||
else | ||||
render template: 'user_admin/user_stat' | ||||
end | ||||
|
r0 | end | ||
|
r106 | |||
def import | ||||
if params[:file]=='' | ||||
flash[:notice] = 'Error importing no file' | ||||
r571 | redirect_to :action => 'index' and return | |||
|
r106 | end | ||
import_from_file(params[:file]) | ||||
end | ||||
|
r200 | def random_all_passwords | ||
r619 | users = User.all | |||
|
r200 | @prefix = params[:prefix] || '' | ||
@non_admin_users = User.find_non_admin_with_prefix(@prefix) | ||||
@changed = false | ||||
r752 | if params[:commit] == 'Go ahead' | |||
|
r200 | @non_admin_users.each do |user| | ||
password = random_password | ||||
user.password = password | ||||
user.password_confirmation = password | ||||
user.save | ||||
end | ||||
@changed = true | ||||
end | ||||
end | ||||
r541 | ||||
|
r280 | # contest management | ||
|
r297 | def contests | ||
|
r298 | @contest, @users = find_contest_and_user_from_contest_id(params[:id]) | ||
@contests = Contest.enabled | ||||
end | ||||
def assign_from_list | ||||
contest_id = params[:users_contest_id] | ||||
org_contest, users = find_contest_and_user_from_contest_id(contest_id) | ||||
contest = Contest.find(params[:new_contest][:id]) | ||||
if !contest | ||||
flash[:notice] = 'Error: no contest' | ||||
redirect_to :action => 'contests', :id =>contest_id | ||||
|
r297 | end | ||
|
r298 | |||
note = [] | ||||
users.each do |u| | ||||
u.contests = [contest] | ||||
note << u.login | ||||
|
r297 | end | ||
|
r298 | flash[:notice] = 'User(s) ' + note.join(', ') + | ||
" were successfully reassigned to #{contest.title}." | ||||
redirect_to :action => 'contests', :id =>contest.id | ||||
|
r297 | end | ||
|
r280 | def add_to_contest | ||
user = User.find(params[:id]) | ||||
contest = Contest.find(params[:contest_id]) | ||||
if user and contest | ||||
user.contests << contest | ||||
end | ||||
r571 | redirect_to :action => 'index' | |||
|
r280 | end | ||
def remove_from_contest | ||||
user = User.find(params[:id]) | ||||
contest = Contest.find(params[:contest_id]) | ||||
if user and contest | ||||
user.contests.delete(contest) | ||||
end | ||||
r571 | redirect_to :action => 'index' | |||
|
r280 | end | ||
def contest_management | ||||
end | ||||
def manage_contest | ||||
contest = Contest.find(params[:contest][:id]) | ||||
if !contest | ||||
flash[:notice] = 'You did not choose the contest.' | ||||
redirect_to :action => 'contest_management' and return | ||||
end | ||||
operation = params[:operation] | ||||
|
r281 | if not ['add','remove','assign'].include? operation | ||
|
r280 | flash[:notice] = 'You did not choose the operation to perform.' | ||
redirect_to :action => 'contest_management' and return | ||||
end | ||||
lines = params[:login_list] | ||||
if !lines or lines.blank? | ||||
flash[:notice] = 'You entered an empty list.' | ||||
redirect_to :action => 'contest_management' and return | ||||
end | ||||
note = [] | ||||
|
r295 | users = [] | ||
|
r280 | lines.split("\n").each do |line| | ||
user = User.find_by_login(line.chomp) | ||||
if user | ||||
if operation=='add' | ||||
|
r294 | if ! user.contests.include? contest | ||
user.contests << contest | ||||
end | ||||
|
r281 | elsif operation=='remove' | ||
user.contests.delete(contest) | ||||
|
r280 | else | ||
|
r281 | user.contests = [contest] | ||
|
r280 | end | ||
|
r294 | |||
|
r295 | if params[:reset_timer] | ||
user.contest_stat.forced_logout = true | ||||
user.contest_stat.reset_timer_and_save | ||||
end | ||||
|
r289 | |||
|
r296 | if params[:notification_emails] | ||
send_contest_update_notification_email(user, contest) | ||||
end | ||||
|
r280 | note << user.login | ||
|
r295 | users << user | ||
|
r280 | end | ||
end | ||||
|
r294 | |||
if params[:reset_timer] | ||||
|
r295 | logout_users(users) | ||
|
r294 | end | ||
|
r280 | flash[:notice] = 'User(s) ' + note.join(', ') + | ||
' were successfully modified. ' | ||||
redirect_to :action => 'contest_management' | ||||
end | ||||
|
r200 | |||
|
r233 | # admin management | ||
def admin | ||||
r619 | @admins = User.all.find_all {|user| user.admin? } | |||
|
r233 | end | ||
def grant_admin | ||||
login = params[:login] | ||||
user = User.find_by_login(login) | ||||
if user!=nil | ||||
admin_role = Role.find_by_name('admin') | ||||
user.roles << admin_role | ||||
else | ||||
flash[:notice] = 'Unknown user' | ||||
end | ||||
flash[:notice] = 'User added as admins' | ||||
redirect_to :action => 'admin' | ||||
end | ||||
def revoke_admin | ||||
user = User.find(params[:id]) | ||||
if user==nil | ||||
flash[:notice] = 'Unknown user' | ||||
redirect_to :action => 'admin' and return | ||||
elsif user.login == 'root' | ||||
flash[:notice] = 'You cannot revoke admisnistrator permission from root.' | ||||
redirect_to :action => 'admin' and return | ||||
end | ||||
admin_role = Role.find_by_name('admin') | ||||
user.roles.delete(admin_role) | ||||
flash[:notice] = 'User permission revoked' | ||||
redirect_to :action => 'admin' | ||||
end | ||||
|
r309 | # mass mailing | ||
def mass_mailing | ||||
end | ||||
def bulk_mail | ||||
lines = params[:login_list] | ||||
if !lines or lines.blank? | ||||
flash[:notice] = 'You entered an empty list.' | ||||
redirect_to :action => 'mass_mailing' and return | ||||
end | ||||
|
r331 | mail_subject = params[:subject] | ||
if !mail_subject or mail_subject.blank? | ||||
|
r309 | flash[:notice] = 'You entered an empty mail subject.' | ||
redirect_to :action => 'mass_mailing' and return | ||||
end | ||||
|
r331 | |||
mail_body = params[:email_body] | ||||
if !mail_body or mail_body.blank? | ||||
flash[:notice] = 'You entered an empty mail body.' | ||||
redirect_to :action => 'mass_mailing' and return | ||||
end | ||||
|
r309 | |||
note = [] | ||||
users = [] | ||||
lines.split("\n").each do |line| | ||||
user = User.find_by_login(line.chomp) | ||||
if user | ||||
|
r336 | send_mail(user.email, mail_subject, mail_body) | ||
|
r309 | note << user.login | ||
end | ||||
end | ||||
flash[:notice] = 'User(s) ' + note.join(', ') + | ||||
' were successfully modified. ' | ||||
redirect_to :action => 'mass_mailing' | ||||
end | ||||
r643 | #bulk manage | |||
def bulk_manage | ||||
begin | ||||
r675 | @users = User.where('(login REGEXP ?) OR (remark REGEXP ?)',params[:regex],params[:regex]) if params[:regex] | |||
r643 | @users.count if @users #i don't know why I have to call count, but if I won't exception is not raised | |||
rescue Exception | ||||
flash[:error] = 'Regular Expression is malformed' | ||||
@users = nil | ||||
end | ||||
if params[:commit] | ||||
@action = {} | ||||
@action[:set_enable] = params[:enabled] | ||||
@action[:enabled] = params[:enable] == "1" | ||||
@action[:gen_password] = params[:gen_password] | ||||
r671 | @action[:add_group] = params[:add_group] | |||
@action[:group_name] = params[:group_name] | ||||
r643 | end | |||
if params[:commit] == "Perform" | ||||
if @action[:set_enable] | ||||
@users.update_all(enabled: @action[:enabled]) | ||||
end | ||||
if @action[:gen_password] | ||||
@users.each do |u| | ||||
password = random_password | ||||
u.password = password | ||||
u.password_confirmation = password | ||||
u.save | ||||
end | ||||
end | ||||
r672 | if @action[:add_group] and @action[:group_name] | |||
@group = Group.find(@action[:group_name]) | ||||
r678 | ok = [] | |||
failed = [] | ||||
@users.each do |user| | ||||
begin | ||||
@group.users << user | ||||
ok << user.login | ||||
rescue => e | ||||
failed << user.login | ||||
end | ||||
end | ||||
flash[:success] = "The following users are added to the 'group #{@group.name}': " + ok.join(', ') if ok.count > 0 | ||||
flash[:alert] = "The following users are already in the 'group #{@group.name}': " + failed.join(', ') if failed.count > 0 | ||||
r671 | end | |||
r643 | end | |||
end | ||||
|
r106 | protected | ||
|
r200 | def random_password(length=5) | ||
chars = 'abcdefghijkmnopqrstuvwxyz23456789' | ||||
newpass = "" | ||||
length.times { newpass << chars[rand(chars.size-1)] } | ||||
return newpass | ||||
end | ||||
|
r106 | def import_from_file(f) | ||
data_hash = YAML.load(f) | ||||
@import_log = "" | ||||
country_data = data_hash[:countries] | ||||
site_data = data_hash[:sites] | ||||
user_data = data_hash[:users] | ||||
# import country | ||||
countries = {} | ||||
country_data.each_pair do |id,country| | ||||
c = Country.find_by_name(country[:name]) | ||||
if c!=nil | ||||
countries[id] = c | ||||
@import_log << "Found #{country[:name]}\n" | ||||
else | ||||
countries[id] = Country.new(:name => country[:name]) | ||||
countries[id].save | ||||
@import_log << "Created #{country[:name]}\n" | ||||
end | ||||
end | ||||
# import sites | ||||
sites = {} | ||||
site_data.each_pair do |id,site| | ||||
s = Site.find_by_name(site[:name]) | ||||
if s!=nil | ||||
@import_log << "Found #{site[:name]}\n" | ||||
else | ||||
s = Site.new(:name => site[:name]) | ||||
@import_log << "Created #{site[:name]}\n" | ||||
end | ||||
s.password = site[:password] | ||||
s.country = countries[site[:country_id]] | ||||
s.save | ||||
sites[id] = s | ||||
end | ||||
# import users | ||||
user_data.each_pair do |id,user| | ||||
u = User.find_by_login(user[:login]) | ||||
if u!=nil | ||||
@import_log << "Found #{user[:login]}\n" | ||||
else | ||||
u = User.new(:login => user[:login]) | ||||
@import_log << "Created #{user[:login]}\n" | ||||
end | ||||
u.full_name = user[:name] | ||||
u.password = user[:password] | ||||
u.country = countries[user[:country_id]] | ||||
u.site = sites[user[:site_id]] | ||||
|
r162 | u.activated = true | ||
u.email = "empty-#{u.login}@none.com" | ||||
if not u.save | ||||
@import_log << "Errors\n" | ||||
u.errors.each { |attr,msg| @import_log << "#{attr} - #{msg}\n" } | ||||
end | ||||
|
r106 | end | ||
end | ||||
|
r295 | def logout_users(users) | ||
users.each do |user| | ||||
contest_stat = user.contest_stat(true) | ||||
if contest_stat and !contest_stat.forced_logout | ||||
contest_stat.forced_logout = true | ||||
contest_stat.save | ||||
|
r294 | end | ||
end | ||||
end | ||||
|
r296 | def send_contest_update_notification_email(user, contest) | ||
|
r320 | contest_title_name = GraderConfiguration['contest.name'] | ||
|
r296 | contest_name = contest.name | ||
|
r331 | mail_subject = t('contest.notification.email_subject', { | ||
:contest_title_name => contest_title_name, | ||||
:contest_name => contest_name }) | ||||
mail_body = t('contest.notification.email_body', { | ||||
:full_name => user.full_name, | ||||
:contest_title_name => contest_title_name, | ||||
:contest_name => contest.name, | ||||
}) | ||||
|
r296 | |||
|
r331 | logger.info mail_body | ||
|
r336 | send_mail(user.email, mail_subject, mail_body) | ||
|
r296 | end | ||
|
r298 | |||
def find_contest_and_user_from_contest_id(id) | ||||
if id!='none' | ||||
@contest = Contest.find(id) | ||||
else | ||||
@contest = nil | ||||
end | ||||
if @contest | ||||
@users = @contest.users | ||||
else | ||||
@users = User.find_users_with_no_contest | ||||
end | ||||
return [@contest, @users] | ||||
end | ||||
r449 | ||||
def gen_csv_from_scorearray(scorearray,problem) | ||||
CSV.generate do |csv| | ||||
#add header | ||||
header = ['User','Name', 'Activated?', 'Logged in', 'Contest'] | ||||
problem.each { |p| header << p.name } | ||||
header += ['Total','Passed'] | ||||
csv << header | ||||
#add data | ||||
scorearray.each do |sc| | ||||
total = num_passed = 0 | ||||
row = Array.new | ||||
sc.each_index do |i| | ||||
if i == 0 | ||||
row << sc[i].login | ||||
row << sc[i].full_name | ||||
row << sc[i].activated | ||||
r610 | row << (sc[i].try(:contest_stat).try(:started_at).nil? ? 'no' : 'yes') | |||
r449 | row << sc[i].contests.collect {|c| c.name}.join(', ') | |||
else | ||||
row << sc[i][0] | ||||
total += sc[i][0] | ||||
num_passed += 1 if sc[i][1] | ||||
end | ||||
end | ||||
row << total | ||||
row << num_passed | ||||
csv << row | ||||
end | ||||
end | ||||
end | ||||
r617 | ||||
private | ||||
def user_params | ||||
r639 | params.require(:user).permit(:login,:password,:password_confirmation,:email, :alias, :full_name,:remark) | |||
r617 | end | |||
|
r0 | end | ||