cafe-grader-web

Commit r449:c1892413ee46 public

parent | child
Description:
add download score as csv
Commit status:
[Not Reviewed]
References:
algo
Diff options:
Raw Diff | Patch Diff | Download Diff | Ignore 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

r449:c1892413ee46 - - 2 files changed: 62 inserted, 5 deleted

Show file before | Show file after | Raw diff | Download diff | Ignore whitespace Increase context Show commentsHide comments
@@ -1,5 +1,8
1 + require 'csv'
2 +
1 3 class UserAdminController < ApplicationController
2 4
5 +
3 6 include MailHelperMethods
4 7
5 8 before_filter :admin_authorization
@@ -122,7 +125,11
122 125 end
123 126
124 127 def user_stat
125 - @problems = Problem.find_available_problems
128 + if params[:commit] == 'download csv'
129 + @problems = Problem.all
130 + else
131 + @problems = Problem.find_available_problems
132 + end
126 133 @users = User.find(:all, :include => [:contests, :contest_stat])
127 134 @scorearray = Array.new
128 135 @users.each do |u|
@@ -138,10 +145,21
138 145 end
139 146 @scorearray << ustat
140 147 end
148 +
149 + if params[:commit] == 'download csv' then
150 + csv = gen_csv_from_scorearray(@scorearray,@problems)
151 + send_data csv, filename: 'last_score.csv'
152 + else
153 + render template: 'user_admin/user_stat'
154 + end
141 155 end
142 156
143 157 def user_stat_max
144 - @problems = Problem.find_available_problems
158 + if params[:commit] == 'download csv'
159 + @problems = Problem.all
160 + else
161 + @problems = Problem.find_available_problems
162 + end
145 163 @users = User.find(:all, :include => [:contests, :contest_stat])
146 164 @scorearray = Array.new
147 165 #set up range from param
@@ -160,7 +178,12
160 178 @scorearray << ustat
161 179 end
162 180
163 - render template: 'user_admin/user_stat'
181 + if params[:commit] == 'download csv' then
182 + csv = gen_csv_from_scorearray(@scorearray,@problems)
183 + send_data csv, filename: 'max_score.csv'
184 + else
185 + render template: 'user_admin/user_stat'
186 + end
164 187 end
165 188
166 189 def import
@@ -475,4 +498,35
475 498 end
476 499 return [@contest, @users]
477 500 end
501 +
502 + def gen_csv_from_scorearray(scorearray,problem)
503 + CSV.generate do |csv|
504 + #add header
505 + header = ['User','Name', 'Activated?', 'Logged in', 'Contest']
506 + problem.each { |p| header << p.name }
507 + header += ['Total','Passed']
508 + csv << header
509 + #add data
510 + scorearray.each do |sc|
511 + total = num_passed = 0
512 + row = Array.new
513 + sc.each_index do |i|
514 + if i == 0
515 + row << sc[i].login
516 + row << sc[i].full_name
517 + row << sc[i].activated
518 + row << (sc[i].try(:contest_stat).try(:started_at)!=nil ? 'yes' : 'no')
519 + row << sc[i].contests.collect {|c| c.name}.join(', ')
520 + else
521 + row << sc[i][0]
522 + total += sc[i][0]
523 + num_passed += 1 if sc[i][1]
524 + end
525 + end
526 + row << total
527 + row << num_passed
528 + csv << row
529 + end
530 + end
531 + end
478 532 end
Show file before | Show file after | Raw diff | Download diff | Ignore whitespace Increase context Show commentsHide comments
@@ -18,10 +18,13
18 18
19 19 = render partial: 'submission_range'
20 20
21 - - if params[:action] == 'user_stat'
22 - = "latest score"
21 + - if params[:action] == 'user_stat'
22 + %h3 Latest score
23 + = link_to '[download csv with all problems]', controller: :user_admin, action: :user_stat, commit: 'download csv'
23 24 - else
25 + %h3 Max score
24 26 = link_to '[Show only latest submissions]', controller: :user_admin, action: :user_stat
27 + = link_to '[download csv with all problems]', controller: :user_admin, action: :user_stat_max, commit: 'download csv'
25 28
26 29 %table.tablesorter-cafe#my_table
27 30 %thead
You need to be logged in to leave comments. Login now