|
|
class Problem < ActiveRecord::Base
|
|
|
|
|
|
belongs_to :description
|
|
|
has_and_belongs_to_many :contests, :uniq => true
|
|
|
|
|
|
#has_and_belongs_to_many :groups
|
|
|
has_many :groups_problems, class_name: 'GroupProblem'
|
|
|
has_many :groups, :through => :groups_problems
|
|
|
|
|
|
has_many :problems_tags, class_name: 'ProblemTag'
|
|
|
has_many :tags, through: :problems_tags
|
|
|
|
|
|
has_many :test_pairs, :dependent => :delete_all
|
|
|
has_many :testcases, :dependent => :destroy
|
|
|
|
|
|
has_many :submissions
|
|
|
|
|
|
validates_presence_of :name
|
|
|
validates_format_of :name, :with => /\A\w+\z/
|
|
|
validates_presence_of :full_name
|
|
|
|
|
|
scope :available, -> { where(available: true) }
|
|
|
|
|
|
DEFAULT_TIME_LIMIT = 1
|
|
|
DEFAULT_MEMORY_LIMIT = 32
|
|
|
|
|
|
def get_jschart_history
|
|
|
start = 4.month.ago.beginning_of_day
|
|
|
start_date = start.to_date
|
|
|
count = Submission.where(problem: self).where('submitted_at >= ?', start).group('DATE(submitted_at)').count
|
|
|
i = 0
|
|
|
label = []
|
|
|
value = []
|
|
|
while (start_date + i < Time.zone.now.to_date)
|
|
|
if (start_date+i).day == 1
|
|
|
#label << (start_date+i).strftime("%d %b %Y")
|
|
|
#label << (start_date+i).strftime("%d")
|
|
|
else
|
|
|
#label << ' '
|
|
|
#label << (start_date+i).strftime("%d")
|
|
|
end
|
|
|
label << (start_date+i).strftime("%d-%b")
|
|
|
value << (count[start_date+i] || 0)
|
|
|
i+=1
|
|
|
end
|
|
|
return {labels: label,datasets: [label:'sub',data: value, backgroundColor: 'rgba(54, 162, 235, 0.2)', borderColor: 'rgb(75, 192, 192)']}
|
|
|
end
|
|
|
|
|
|
def self.available_problems
|
|
|
available.order(date_added: :desc).order(:name)
|
|
|
#Problem.available.all(:order => "date_added DESC, name ASC")
|
|
|
end
|
|
|
|
|
|
def self.create_from_import_form_params(params, old_problem=nil)
|
|
|
org_problem = old_problem || Problem.new
|
|
|
import_params, problem = Problem.extract_params_and_check(params,
|
|
|
org_problem)
|
|
|
|
|
|
if !problem.errors.empty?
|
|
|
return problem, 'Error importing'
|
|
|
end
|
|
|
|
|
|
problem.full_score = 100
|
|
|
problem.date_added = Time.new
|
|
|
problem.test_allowed = true
|
|
|
problem.output_only = false
|
|
|
problem.available = false
|
|
|
|
|
|
if not problem.save
|
|
|
return problem, 'Error importing'
|
|
|
end
|
|
|
|
|
|
import_to_db = params.has_key? :import_to_db
|
|
|
|
|
|
importer = TestdataImporter.new(problem)
|
|
|
|
|
|
if not importer.import_from_file(import_params[:file],
|
|
|
import_params[:time_limit],
|
|
|
import_params[:memory_limit],
|
|
|
import_params[:checker_name],
|
|
|
import_to_db)
|
|
|
problem.errors.add(:base,'Import error.')
|
|
|
end
|
|
|
|
|
|
return problem, importer.log_msg
|
|
|
end
|
|
|
|
|
|
def self.download_file_basedir
|
|
|
return "#{Rails.root}/data/tasks"
|
|
|
end
|
|
|
|
|
|
def get_submission_stat
|
|
|
result = Hash.new
|
|
|
#total number of submission
|
|
|
result[:total_sub] = Submission.where(problem_id: self.id).count
|
|
|
result[:attempted_user] = Submission.where(problem_id: self.id).group(:user_id)
|
|
|
result[:pass] = Submission.where(problem_id: self.id).where("points >= ?",self.full_score).count
|
|
|
return result
|
|
|
end
|
|
|
|
|
|
def long_name
|
|
|
"[#{name}] #{full_name}"
|
|
|
end
|
|
|
|
|
|
protected
|
|
|
|
|
|
def self.to_i_or_default(st, default)
|
|
|
if st!=''
|
|
|
result = st.to_i
|
|
|
end
|
|
|
result ||= default
|
|
|
end
|
|
|
|
|
|
def self.to_f_or_default(st, default)
|
|
|
if st!=''
|
|
|
result = st.to_f
|
|
|
end
|
|
|
result ||= default
|
|
|
end
|
|
|
|
|
|
def self.extract_params_and_check(params, problem)
|
|
|
time_limit = Problem.to_f_or_default(params[:time_limit],
|
|
|
DEFAULT_TIME_LIMIT)
|
|
|
memory_limit = Problem.to_i_or_default(params[:memory_limit],
|
|
|
DEFAULT_MEMORY_LIMIT)
|
|
|
|
|
|
if time_limit<=0 or time_limit >60
|
|
|
problem.errors.add(:base,'Time limit out of range.')
|
|
|
end
|
|
|
|
|
|
if memory_limit==0 and params[:memory_limit]!='0'
|
|
|
problem.errors.add(:base,'Memory limit format errors.')
|
|
|
elsif memory_limit<=0 or memory_limit >512
|
|
|
problem.errors.add(:base,'Memory limit out of range.')
|
|
|
end
|
|
|
|
|
|
if params[:file]==nil or params[:file]==''
|
|
|
problem.errors.add(:base,'No testdata file.')
|
|
|
end
|
|
|
|
|
|
checker_name = 'text'
|
|
|
if ['text','float'].include? params[:checker]
|
|
|
checker_name = params[:checker]
|
|
|
end
|
|
|
|
|
|
file = params[:file]
|
|
|
|
|
|
if !problem.errors.empty?
|
|
|
return nil, problem
|
|
|
end
|
|
|
|
|
|
problem.name = params[:name]
|
|
|
if params[:full_name]!=''
|
|
|
problem.full_name = params[:full_name]
|
|
|
else
|
|
|
problem.full_name = params[:name]
|
|
|
end
|
|
|
|
|
|
return [{
|
|
|
:time_limit => time_limit,
|
|
|
:memory_limit => memory_limit,
|
|
|
:file => file,
|
|
|
:checker_name => checker_name
|
|
|
},
|
|
|
problem]
|
|
|
end
|
|
|
|
|
|
end
|
|
|
|
