cafe-grader-web

Commit r438:1c02c7fc8a89 public

parent | child
Description:
fix bug on calculating best of each lanuage
Commit status:
[Not Reviewed]
References:
algo
Diff options:
Raw Diff | Patch Diff | Download Diff | Show whitespace | Increase context
Comments:
0 Commit comments 0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
Side by Side Unified
Expand All Files Collapse All Files Wide Mode Diff
Add another comment
Browse Files

r438:1c02c7fc8a89 - - 1 file changed: 1 inserted, 1 deleted

Show file before | Show file after | Raw diff | Download diff | Show whitespace Increase context Show commentsHide comments
@@ -1,189 +1,189
1 class ReportController < ApplicationController
1 class ReportController < ApplicationController
2
2
3 before_filter :admin_authorization, only: [:login_stat,:submission_stat]
3 before_filter :admin_authorization, only: [:login_stat,:submission_stat]
4 before_filter(only: [:problem_hof]) { |c|
4 before_filter(only: [:problem_hof]) { |c|
5 return false unless authenticate
5 return false unless authenticate
6
6
7 if GraderConfiguration["right.user_view_submission"]
7 if GraderConfiguration["right.user_view_submission"]
8 return true;
8 return true;
9 end
9 end
10
10
11 admin_authorization
11 admin_authorization
12 }
12 }
13
13
14 def login_stat
14 def login_stat
15 @logins = Array.new
15 @logins = Array.new
16
16
17 date_and_time = '%Y-%m-%d %H:%M'
17 date_and_time = '%Y-%m-%d %H:%M'
18 begin
18 begin
19 @since_time = DateTime.strptime(params[:since_datetime],date_and_time)
19 @since_time = DateTime.strptime(params[:since_datetime],date_and_time)
20 rescue
20 rescue
21 @since_time = DateTime.new(1000,1,1)
21 @since_time = DateTime.new(1000,1,1)
22 end
22 end
23 begin
23 begin
24 @until_time = DateTime.strptime(params[:until_datetime],date_and_time)
24 @until_time = DateTime.strptime(params[:until_datetime],date_and_time)
25 rescue
25 rescue
26 @until_time = DateTime.new(3000,1,1)
26 @until_time = DateTime.new(3000,1,1)
27 end
27 end
28
28
29 User.all.each do |user|
29 User.all.each do |user|
30 @logins << { id: user.id,
30 @logins << { id: user.id,
31 login: user.login,
31 login: user.login,
32 full_name: user.full_name,
32 full_name: user.full_name,
33 count: Login.where("user_id = ? AND created_at >= ? AND created_at <= ?",
33 count: Login.where("user_id = ? AND created_at >= ? AND created_at <= ?",
34 user.id,@since_time,@until_time)
34 user.id,@since_time,@until_time)
35 .count(:id),
35 .count(:id),
36 min: Login.where("user_id = ? AND created_at >= ? AND created_at <= ?",
36 min: Login.where("user_id = ? AND created_at >= ? AND created_at <= ?",
37 user.id,@since_time,@until_time)
37 user.id,@since_time,@until_time)
38 .minimum(:created_at),
38 .minimum(:created_at),
39 max: Login.where("user_id = ? AND created_at >= ? AND created_at <= ?",
39 max: Login.where("user_id = ? AND created_at >= ? AND created_at <= ?",
40 user.id,@since_time,@until_time)
40 user.id,@since_time,@until_time)
41 .maximum(:created_at)
41 .maximum(:created_at)
42 }
42 }
43 end
43 end
44 end
44 end
45
45
46 def submission_stat
46 def submission_stat
47
47
48 date_and_time = '%Y-%m-%d %H:%M'
48 date_and_time = '%Y-%m-%d %H:%M'
49 begin
49 begin
50 @since_time = DateTime.strptime(params[:since_datetime],date_and_time)
50 @since_time = DateTime.strptime(params[:since_datetime],date_and_time)
51 rescue
51 rescue
52 @since_time = DateTime.new(1000,1,1)
52 @since_time = DateTime.new(1000,1,1)
53 end
53 end
54 begin
54 begin
55 @until_time = DateTime.strptime(params[:until_datetime],date_and_time)
55 @until_time = DateTime.strptime(params[:until_datetime],date_and_time)
56 rescue
56 rescue
57 @until_time = DateTime.new(3000,1,1)
57 @until_time = DateTime.new(3000,1,1)
58 end
58 end
59
59
60 @submissions = {}
60 @submissions = {}
61
61
62 User.find_each do |user|
62 User.find_each do |user|
63 @submissions[user.id] = { login: user.login, full_name: user.full_name, count: 0, sub: { } }
63 @submissions[user.id] = { login: user.login, full_name: user.full_name, count: 0, sub: { } }
64 end
64 end
65
65
66 Submission.where("submitted_at >= ? AND submitted_at <= ?",@since_time,@until_time).find_each do |s|
66 Submission.where("submitted_at >= ? AND submitted_at <= ?",@since_time,@until_time).find_each do |s|
67 if @submissions[s.user_id]
67 if @submissions[s.user_id]
68 if not @submissions[s.user_id][:sub].has_key?(s.problem_id)
68 if not @submissions[s.user_id][:sub].has_key?(s.problem_id)
69 a = nil
69 a = nil
70 begin
70 begin
71 a = Problem.find(s.problem_id)
71 a = Problem.find(s.problem_id)
72 rescue
72 rescue
73 a = nil
73 a = nil
74 end
74 end
75 @submissions[s.user_id][:sub][s.problem_id] =
75 @submissions[s.user_id][:sub][s.problem_id] =
76 { prob_name: (a ? a.full_name : '(NULL)'),
76 { prob_name: (a ? a.full_name : '(NULL)'),
77 sub_ids: [s.id] }
77 sub_ids: [s.id] }
78 else
78 else
79 @submissions[s.user_id][:sub][s.problem_id][:sub_ids] << s.id
79 @submissions[s.user_id][:sub][s.problem_id][:sub_ids] << s.id
80 end
80 end
81 @submissions[s.user_id][:count] += 1
81 @submissions[s.user_id][:count] += 1
82 end
82 end
83 end
83 end
84 end
84 end
85
85
86 def problem_hof
86 def problem_hof
87 # gen problem list
87 # gen problem list
88 @user = User.find(session[:user_id])
88 @user = User.find(session[:user_id])
89 @problems = @user.available_problems
89 @problems = @user.available_problems
90
90
91 # get selected problems or the default
91 # get selected problems or the default
92 if params[:id]
92 if params[:id]
93 begin
93 begin
94 @problem = Problem.available.find(params[:id])
94 @problem = Problem.available.find(params[:id])
95 rescue
95 rescue
96 redirect_to action: :problem_hof
96 redirect_to action: :problem_hof
97 flash[:notice] = 'Error: submissions for that problem are not viewable.'
97 flash[:notice] = 'Error: submissions for that problem are not viewable.'
98 return
98 return
99 end
99 end
100 end
100 end
101
101
102 if @problem
102 if @problem
103 #aggregrate by language
103 #aggregrate by language
104 @by_lang = {}
104 @by_lang = {}
105 Submission.where(problem_id: @problem.id).find_each do |sub|
105 Submission.where(problem_id: @problem.id).find_each do |sub|
106 lang = Language.find_by_id(sub.language_id)
106 lang = Language.find_by_id(sub.language_id)
107 next unless lang
107 next unless lang
108 next unless sub.points >= @problem.full_score
108 next unless sub.points >= @problem.full_score
109
109
110 #initialize
110 #initialize
111 unless @by_lang.has_key?(lang.pretty_name)
111 unless @by_lang.has_key?(lang.pretty_name)
112 @by_lang[lang.pretty_name] = {
112 @by_lang[lang.pretty_name] = {
113 runtime: { avail: false, value: 2**30-1 },
113 runtime: { avail: false, value: 2**30-1 },
114 memory: { avail: false, value: 2**30-1 },
114 memory: { avail: false, value: 2**30-1 },
115 length: { avail: false, value: 2**30-1 },
115 length: { avail: false, value: 2**30-1 },
116 first: { avail: false, value: DateTime.new(3000,1,1) }
116 first: { avail: false, value: DateTime.new(3000,1,1) }
117 }
117 }
118 end
118 end
119
119
120 if sub.max_runtime and sub.max_runtime < @by_lang[lang.pretty_name][:runtime][:value]
120 if sub.max_runtime and sub.max_runtime < @by_lang[lang.pretty_name][:runtime][:value]
121 @by_lang[lang.pretty_name][:runtime] = {
121 @by_lang[lang.pretty_name][:runtime] = {
122 avail: true,
122 avail: true,
123 user_id: sub.user_id,
123 user_id: sub.user_id,
124 value: sub.max_runtime,
124 value: sub.max_runtime,
125 sub_id: sub.id
125 sub_id: sub.id
126 }
126 }
127 end
127 end
128
128
129 if sub.peak_memory and sub.peak_memory < @by_lang[lang.pretty_name][:memory][:value]
129 if sub.peak_memory and sub.peak_memory < @by_lang[lang.pretty_name][:memory][:value]
130 @by_lang[lang.pretty_name][:memory] = {
130 @by_lang[lang.pretty_name][:memory] = {
131 avail: true,
131 avail: true,
132 user_id: sub.user_id,
132 user_id: sub.user_id,
133 value: sub.peak_memory,
133 value: sub.peak_memory,
134 sub_id: sub.id
134 sub_id: sub.id
135 }
135 }
136 end
136 end
137
137
138 if sub.submitted_at and sub.submitted_at < @by_lang[lang.pretty_name][:first][:value] and
138 if sub.submitted_at and sub.submitted_at < @by_lang[lang.pretty_name][:first][:value] and
139 !sub.user.admin?
139 !sub.user.admin?
140 @by_lang[lang.pretty_name][:first] = {
140 @by_lang[lang.pretty_name][:first] = {
141 avail: true,
141 avail: true,
142 user_id: sub.user_id,
142 user_id: sub.user_id,
143 value: sub.submitted_at,
143 value: sub.submitted_at,
144 sub_id: sub.id
144 sub_id: sub.id
145 }
145 }
146 end
146 end
147
147
148 if @by_lang[lang.pretty_name][:length][:value] > sub.effective_code_length
148 if @by_lang[lang.pretty_name][:length][:value] > sub.effective_code_length
149 @by_lang[lang.pretty_name][:length] = {
149 @by_lang[lang.pretty_name][:length] = {
150 avail: true,
150 avail: true,
151 user_id: sub.user_id,
151 user_id: sub.user_id,
152 value: sub.effective_code_length,
152 value: sub.effective_code_length,
153 sub_id: sub.id
153 sub_id: sub.id
154 }
154 }
155 end
155 end
156 end
156 end
157
157
158 #process user_id
158 #process user_id
159 @by_lang.each do |lang,prop|
159 @by_lang.each do |lang,prop|
160 prop.each do |k,v|
160 prop.each do |k,v|
161 v[:user] = User.exists?(v[:user_id]) ? User.find(v[:user_id]).full_name : "(NULL)"
161 v[:user] = User.exists?(v[:user_id]) ? User.find(v[:user_id]).full_name : "(NULL)"
162 end
162 end
163 end
163 end
164
164
165 #sum into best
165 #sum into best
166 if @by_lang and @by_lang.first
166 if @by_lang and @by_lang.first
167 - @best = @by_lang.first[1]
167 + @best = @by_lang.first[1].clone
168 @by_lang.each do |lang,prop|
168 @by_lang.each do |lang,prop|
169 if @best[:runtime][:value] >= prop[:runtime][:value]
169 if @best[:runtime][:value] >= prop[:runtime][:value]
170 @best[:runtime] = prop[:runtime]
170 @best[:runtime] = prop[:runtime]
171 @best[:runtime][:lang] = lang
171 @best[:runtime][:lang] = lang
172 end
172 end
173 if @best[:memory][:value] >= prop[:memory][:value]
173 if @best[:memory][:value] >= prop[:memory][:value]
174 @best[:memory] = prop[:memory]
174 @best[:memory] = prop[:memory]
175 @best[:memory][:lang] = lang
175 @best[:memory][:lang] = lang
176 end
176 end
177 if @best[:length][:value] >= prop[:length][:value]
177 if @best[:length][:value] >= prop[:length][:value]
178 @best[:length] = prop[:length]
178 @best[:length] = prop[:length]
179 @best[:length][:lang] = lang
179 @best[:length][:lang] = lang
180 end
180 end
181 if @best[:first][:value] >= prop[:first][:value]
181 if @best[:first][:value] >= prop[:first][:value]
182 @best[:first] = prop[:first]
182 @best[:first] = prop[:first]
183 @best[:first][:lang] = lang
183 @best[:first][:lang] = lang
184 end
184 end
185 end
185 end
186 end
186 end
187 end
187 end
188 end
188 end
189 end
189 end
You need to be logged in to leave comments. Login now