Description:
add download score as csv
Commit status:
[Not Reviewed]
References:
Diff options:
Comments:
0 Commit comments
0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
Author
-
r449:c1892413ee46 - - 2 files changed: 62 inserted, 5 deleted
| @@ -1,8 +1,11 | |||
|
|
1 | + require 'csv' | |
|
|
2 | + | |
|
|
1 | 3 | class UserAdminController < ApplicationController |
|
|
2 | 4 | |
|
|
5 | + | |
|
|
3 | 6 | include MailHelperMethods |
|
|
4 | 7 | |
|
|
5 | 8 | before_filter :admin_authorization |
|
|
6 | 9 | |
|
|
7 | 10 | # GETs should be safe (see http://www.w3.org/2001/tag/doc/whenToUseGet.html) |
|
|
8 | 11 | verify :method => :post, :only => [ :destroy, |
| @@ -119,13 +122,17 | |||
|
|
119 | 122 | def destroy |
|
|
120 | 123 | User.find(params[:id]).destroy |
|
|
121 | 124 | redirect_to :action => 'list' |
|
|
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| |
|
|
129 | 136 | ustat = Array.new |
|
|
130 | 137 | ustat[0] = u |
|
|
131 | 138 | @problems.each do |p| |
| @@ -135,16 +142,27 | |||
|
|
135 | 142 | else |
|
|
136 | 143 | ustat << [0,false] |
|
|
137 | 144 | end |
|
|
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 |
|
|
148 | 166 | since_id = params.fetch(:since_id, 0).to_i |
|
|
149 | 167 | until_id = params.fetch(:until_id, 0).to_i |
|
|
150 | 168 | @users.each do |u| |
| @@ -157,13 +175,18 | |||
|
|
157 | 175 | end |
|
|
158 | 176 | ustat << [(max_points.to_f*100/p.full_score).round, (max_points>=p.full_score)] |
|
|
159 | 177 | end |
|
|
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 |
|
|
167 | 190 | if params[:file]=='' |
|
|
168 | 191 | flash[:notice] = 'Error importing no file' |
|
|
169 | 192 | redirect_to :action => 'list' and return |
| @@ -472,7 +495,38 | |||
|
|
472 | 495 | @users = @contest.users |
|
|
473 | 496 | else |
|
|
474 | 497 | @users = User.find_users_with_no_contest |
|
|
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 |
| @@ -15,16 +15,19 | |||
|
|
15 | 15 | |
|
|
16 | 16 | - if @problem and @problem.errors |
|
|
17 | 17 | =error_messages_for 'problem' |
|
|
18 | 18 | |
|
|
19 | 19 | = render partial: 'submission_range' |
|
|
20 | 20 | |
|
|
21 |
- - if params[:action] == 'user_stat' |
|
|
|
22 |
- |
|
|
|
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 |
|
|
28 | 31 | %tr |
|
|
29 | 32 | %th User |
|
|
30 | 33 | %th Name |
You need to be logged in to leave comments.
Login now