cafe-grader-web Commit - r788:3241620ac7e7

cafe-grader-web

Commit `r788:3241620ac7e7` public

parent | child

Description:

submission stat

Commit status:

[Not Reviewed]

References:

default

Diff options:

| | | |

Comments:

0 Commit comments 0 Inline Comments

Unresolved TODOs:

There are no unresolved TODOs

Add another comment

r788:3241620ac7e7 - Sat, 04 Apr 2020 08:37:50 - 10 files changed: 425 inserted, 296 deleted

app/views/report/submission.html.haml created 644 ¶ +61

@@ -0,0 +1,61
	1	+ - content_for :header do
	2	+ = javascript_include_tag 'local_jquery'
	3	+
	4	+ %h1 Submissions detail
	5	+
	6	+ .row
	7	+ .col-md-4
	8	+ = render partial: 'shared/problem_select'
	9	+ .col-md-4
	10	+ = render partial: 'shared/problem_select'
	11	+ .col-md-4
	12	+ = render partial: 'shared/user_select'
	13	+
	14	+
	15	+ .row
	16	+ .col-12
	17	+ %table.table.table-hover.table-condense.datatable
	18	+ -#
	19	+ %thead
	20	+ %tr
	21	+ %th User
	22	+ %th Problem
	23	+ %th Subbmission ID
	24	+ %th Submit Time
	25	+ %th Score
	26	+ %th detail
	27	+ %tbody
	28	+ - @submissions.each do \|s\|
	29	+ %tr
	30	+ %td= s.user.login
	31	+ %td= s.problem.long_name
	32	+ %td= s.id
	33	+ %td= s.submitted_at
	34	+ %td= s.points
	35	+ %td= s.grader_comment
	36	+
	37	+
	38	+ :javascript
	39	+ $('.datatable').DataTable({
	40	+ columns: [
	41	+ {title: 'User', data: 'login'},
	42	+ {title: 'Problem', data: 'problem.long_name'},
	43	+ {title: 'Sub ID', data: 'id'},
	44	+ {title: 'Submit at', data: 'submitted_at'},
	45	+ {title: 'Points', data: 'points'},
	46	+ {title: 'detail', data: 'grader_comment'},
	47	+ ],
	48	+ ajax: {
	49	+ url: '#{submission_query_report_path}',
	50	+ type: 'POST',
	51	+ data: (d) => {
	52	+ d.since_datetime = '1123'
	53	+ d.until_datetime = 'xxx'
	54	+ },
	55	+ dataType: 'json',
	56	+ beforeSend: (request) => {
	57	+ request.setRequestHeader('X-CSRF-Token', $('meta[name="csrf-token"]').attr('content'));
	58	+ },
	59	+ }, //end ajax
	60	+ 'pageLength': 50
	61	+ });

app/views/report/submission_query.json.jbuilder created 644 ¶ +15

@@ -0,0 +1,15
	1	+ json.draw params['draw']&.to_i
	2	+ json.recordsTotal @recordsTotal
	3	+ json.recordsFiltered @recordsFiltered
	4	+ json.data do
	5	+ json.array! @submissions do \|sub\|
	6	+ json.extact! sub, :id, :points, :grader_comment
	7	+ json.submitted_at sub.submitted_at
	8	+ json.problem do
	9	+ json.long_name sub.problem&.long_name
	10	+ end
	11	+ json.user do
	12	+ json.login sub.user&.login
	13	+ end
	14	+ end
	15	+ end

app/views/shared/_problem_select.html.haml created 644 ¶ +10

@@ -0,0 +1,10
	1	+ .panel.panel-primary
	2	+ .panel-heading
	3	+ Problems
	4	+ .panel-body
	5	+ %p
	6	+ Select problem(s) that we wish to know the score.
	7	+ = label_tag :problem_id, "Problems"
	8	+ = select_tag 'problem_id[]',
	9	+ options_for_select(Problem.all.collect {\|p\| ["[#{p.name}] #{p.full_name}", p.id]},params[:problem_id]),
	10	+ { class: 'select2 form-control', multiple: "true" }

app/views/shared/_user_select.html.haml created 644 ¶ +12

@@ -0,0 +1,12
	1	+ .panel.panel-primary
	2	+ .panel-heading
	3	+ Users
	4	+ .panel-body
	5	+ .radio
	6	+ %label
	7	+ = radio_button_tag 'users', 'all', (params[:users] == "all")
	8	+ All users
	9	+ .radio
	10	+ %label
	11	+ = radio_button_tag 'users', 'enabled', (params[:users] == "enabled")
	12	+ Only enabled users

Gemfile.lock ¶ +81 -86

               GEM
                 remote: https://rubygems.org/
                 specs:
                   RubyInline (3.12.4)
                     ZenTest (~> 4.3)
                   ZenTest (4.11.2)
                   ace-rails-ap (4.2)
-            -     actioncable (5.2.3)
+            +     actioncable (5.2.4.2)
-            -       actionpack (= 5.2.3)
+            +       actionpack (= 5.2.4.2)
                     nio4r (~> 2.0)
                     websocket-driver (>= 0.6.1)
-            -     actionmailer (5.2.3)
+            +     actionmailer (5.2.4.2)
-            -       actionpack (= 5.2.3)
+            +       actionpack (= 5.2.4.2)
-            -       actionview (= 5.2.3)
+            +       actionview (= 5.2.4.2)
-            -       activejob (= 5.2.3)
+            +       activejob (= 5.2.4.2)
                     mail (~> 2.5, >= 2.5.4)
                     rails-dom-testing (~> 2.0)
-            -     actionpack (5.2.3)
+            +     actionpack (5.2.4.2)
-            -       actionview (= 5.2.3)
+            +       actionview (= 5.2.4.2)
-            -       activesupport (= 5.2.3)
+            +       activesupport (= 5.2.4.2)
-            -       rack (~> 2.0)
+            +       rack (~> 2.0, >= 2.0.8)
                     rack-test (>= 0.6.3)
                     rails-dom-testing (~> 2.0)
                     rails-html-sanitizer (~> 1.0, >= 1.0.2)
-            -     actionview (5.2.3)
+            +     actionview (5.2.4.2)
-            -       activesupport (= 5.2.3)
+            +       activesupport (= 5.2.4.2)
                     builder (~> 3.1)
                     erubi (~> 1.4)
                     rails-dom-testing (~> 2.0)
                     rails-html-sanitizer (~> 1.0, >= 1.0.3)
-            -     activejob (5.2.3)
+            +     activejob (5.2.4.2)
-            -       activesupport (= 5.2.3)
+            +       activesupport (= 5.2.4.2)
                     globalid (>= 0.3.6)
-            -     activemodel (5.2.3)
+            +     activemodel (5.2.4.2)
-            -       activesupport (= 5.2.3)
+            +       activesupport (= 5.2.4.2)
-            -     activerecord (5.2.3)
+            +     activerecord (5.2.4.2)
-            -       activemodel (= 5.2.3)
+            +       activemodel (= 5.2.4.2)
-            -       activesupport (= 5.2.3)
+            +       activesupport (= 5.2.4.2)
                     arel (>= 9.0)
                   activerecord-session_store (1.1.3)
                     actionpack (>= 4.0)
                     activerecord (>= 4.0)
                     multi_json (~> 1.11, >= 1.11.2)
                     rack (>= 1.5.2, < 3)
                     railties (>= 4.0)
-            -     activestorage (5.2.3)
+            +     activestorage (5.2.4.2)
-            -       actionpack (= 5.2.3)
+            +       actionpack (= 5.2.4.2)
-            -       activerecord (= 5.2.3)
+            +       activerecord (= 5.2.4.2)
                     marcel (~> 0.3.1)
-            -     activesupport (5.2.3)
+            +     activesupport (5.2.4.2)
                     concurrent-ruby (~> 1.0, >= 1.0.2)
                     i18n (>= 0.7, < 2)
                     minitest (~> 5.1)
                     tzinfo (~> 1.1)
-            -     addressable (2.6.0)
+            +     addressable (2.7.0)
-            -       public_suffix (>= 2.0.2, < 4.0)
+            +       public_suffix (>= 2.0.2, < 5.0)
                   ansi (1.5.0)
                   arel (9.0.0)
-            -     autoprefixer-rails (9.5.1.1)
+            +     autoprefixer-rails (9.5.1)
                     execjs
                   best_in_place (3.0.3)
                     actionpack (>= 3.2)
                     railties (>= 3.2)
-            -     bindex (0.7.0)
+            +     bindex (0.8.1)
-            -     bootsnap (1.4.4)
+            +     bootsnap (1.4.6)
                     msgpack (~> 1.0)
                   bootstrap-datepicker-rails (1.8.0.1)
                     railties (>= 3.0)
                   bootstrap-sass (3.4.1)
                     autoprefixer-rails (>= 5.2.1)
                     sassc (>= 2.0.0)
                   bootstrap-switch-rails (3.3.4)
                   bootstrap-toggle-rails (2.2.1.0)
                   bootstrap3-datetimepicker-rails (4.17.47)
                     momentjs-rails (>= 2.8.1)
-            -     builder (3.2.3)
+            +     builder (3.2.4)
                   byebug (11.0.1)
-            -     capybara (3.25.0)
+            +     capybara (3.15.1)
                     addressable
                     mini_mime (>= 0.1.3)
                     nokogiri (~> 1.8)
                     rack (>= 1.6.0)
                     rack-test (>= 0.6.3)
-            -       regexp_parser (~> 1.5)
+            +       regexp_parser (~> 1.2)
                     xpath (~> 3.2)
-            -     capybara-console (0.0.4)
+            +     childprocess (3.0.0)
-            -       capybara
-            -       rails (>= 3.0)
-            -     childprocess (1.0.1)
-            -       rake (< 13.0)
                   coffee-rails (4.2.2)
                     coffee-script (>= 2.2.0)
                     railties (>= 4.0.0)
                   coffee-script (2.4.1)
                     coffee-script-source
                     execjs
                   coffee-script-source (1.12.2)
-            -     concurrent-ruby (1.1.5)
+            +     concurrent-ruby (1.1.6)
-            -     crass (1.0.4)
+            +     crass (1.0.6)
                   dynamic_form (1.1.4)
-            -     erubi (1.8.0)
+            +     erubi (1.9.0)
                   erubis (2.7.0)
                   execjs (2.7.0)
-            -     ffi (1.11.1)
+            +     ffi (1.10.0)
                   fuzzy-string-match (1.0.1)
                     RubyInline (>= 3.8.6)
                   globalid (0.4.2)
                     activesupport (>= 4.2.0)
-            -     haml (5.1.0)
+            +     haml (5.0.4)
                     temple (>= 0.8.0)
                     tilt
                   haml-rails (1.0.0)
                     actionpack (>= 4.0.1)
                     activesupport (>= 4.0.1)
                     haml (>= 4.0.6, < 6.0)
                     html2haml (>= 1.0.1)
                     railties (>= 4.0.1)
                   html2haml (2.2.0)
                     erubis (~> 2.7.0)
                     haml (>= 4.0, < 6)
                     nokogiri (>= 1.6.0)
                     ruby_parser (~> 3.5)
-            -     i18n (1.6.0)
+            +     i18n (1.8.2)
                     concurrent-ruby (~> 1.0)
                   in_place_editing (1.2.0)
-            -     jbuilder (2.9.1)
+            +     jbuilder (2.10.0)
-            -       activesupport (>= 4.2.0)
+            +       activesupport (>= 5.0.0)
                   jquery-countdown-rails (2.0.2)
                   jquery-datatables-rails (3.4.0)
                     actionpack (>= 3.1)
                     jquery-rails
                     railties (>= 3.1)
                     sass-rails
                   jquery-rails (4.3.3)
                     rails-dom-testing (>= 1, < 3)
                     railties (>= 4.2.0)
                     thor (>= 0.14, < 2.0)
                   jquery-tablesorter (1.26.1)
                     railties (>= 3.2, < 6)
                   jquery-timepicker-addon-rails (1.4.1)
                     railties (>= 3.1)
                   jquery-ui-rails (6.0.1)
                     railties (>= 3.2.16)
                   listen (3.1.5)
                     rb-fsevent (~> 0.9, >= 0.9.4)
                     rb-inotify (~> 0.9, >= 0.9.7)
                     ruby_dep (~> 1.2)
-            -     loofah (2.2.3)
+            +     loofah (2.4.0)
                     crass (~> 1.0.2)
                     nokogiri (>= 1.5.9)
                   mail (2.7.1)
                     mini_mime (>= 0.1.1)
                   marcel (0.3.3)
                     mimemagic (~> 0.3.2)
-            -     method_source (0.9.2)
+            +     method_source (1.0.0)
-            -     mimemagic (0.3.3)
+            +     mimemagic (0.3.4)
-            -     mini_mime (1.0.1)
+            +     mini_mime (1.0.2)
                   mini_portile2 (2.4.0)
-            -     minitest (5.11.3)
+            +     minitest (5.14.0)
                   minitest-reporters (1.3.6)
                     ansi
                     builder
                     minitest (>= 5.0)
                     ruby-progressbar
                   momentjs-rails (2.20.1)
                     railties (>= 3.1)
-            -     msgpack (1.3.0)
+            +     msgpack (1.3.3)
                   multi_json (1.13.1)
                   mysql2 (0.5.2)
-            -     nio4r (2.3.1)
+            +     nio4r (2.5.2)
-            -     nokogiri (1.10.3)
+            +     nokogiri (1.10.9)
                     mini_portile2 (~> 2.4.0)
-            -     public_suffix (3.1.1)
+            +     public_suffix (4.0.3)
-            -     puma (4.0.0)
+            +     puma (4.3.3)
                     nio4r (~> 2.0)
-            -     rack (2.0.7)
+            +     rack (2.2.2)
                   rack-test (1.1.0)
                     rack (>= 1.0, < 3)
-            -     rails (5.2.3)
+            +     rails (5.2.4.2)
-            -       actioncable (= 5.2.3)
+            +       actioncable (= 5.2.4.2)
-            -       actionmailer (= 5.2.3)
+            +       actionmailer (= 5.2.4.2)
-            -       actionpack (= 5.2.3)
+            +       actionpack (= 5.2.4.2)
-            -       actionview (= 5.2.3)
+            +       actionview (= 5.2.4.2)
-            -       activejob (= 5.2.3)
+            +       activejob (= 5.2.4.2)
-            -       activemodel (= 5.2.3)
+            +       activemodel (= 5.2.4.2)
-            -       activerecord (= 5.2.3)
+            +       activerecord (= 5.2.4.2)
-            -       activestorage (= 5.2.3)
+            +       activestorage (= 5.2.4.2)
-            -       activesupport (= 5.2.3)
+            +       activesupport (= 5.2.4.2)
                     bundler (>= 1.3.0)
-            -       railties (= 5.2.3)
+            +       railties (= 5.2.4.2)
                     sprockets-rails (>= 2.0.0)
                   rails-controller-testing (1.0.4)
                     actionpack (>= 5.0.1.x)
                     actionview (>= 5.0.1.x)
                     activesupport (>= 5.0.1.x)
                   rails-dom-testing (2.0.3)
                     activesupport (>= 4.2.0)
                     nokogiri (>= 1.6)
-            -     rails-html-sanitizer (1.0.4)
+            +     rails-html-sanitizer (1.3.0)
-            -       loofah (~> 2.2, >= 2.2.2)
+            +       loofah (~> 2.3)
                   rails_bootstrap_sortable (2.0.6)
                     momentjs-rails (>= 2.8.3)
-            -     railties (5.2.3)
+            +     railties (5.2.4.2)
-            -       actionpack (= 5.2.3)
+            +       actionpack (= 5.2.4.2)
-            -       activesupport (= 5.2.3)
+            +       activesupport (= 5.2.4.2)
                     method_source
                     rake (>= 0.8.7)
                     thor (>= 0.19.0, < 2.0)
-            -     rake (12.3.2)
+            +     rake (13.0.1)
                   rb-fsevent (0.10.3)
                   rb-inotify (0.10.0)
                     ffi (~> 1.0)
                   rdiscount (2.2.0.1)
-            -     regexp_parser (1.5.1)
+            +     regexp_parser (1.7.0)
                   rouge (3.3.0)
                   ruby-progressbar (1.10.0)
                   ruby_dep (1.5.0)
                   ruby_parser (3.13.1)
                     sexp_processor (~> 4.9)
-            -     rubyzip (1.2.3)
+            +     rubyzip (1.3.0)
                   sass (3.7.4)
                     sass-listen (~> 4.0.0)
                   sass-listen (4.0.0)
                     rb-fsevent (~> 0.9, >= 0.9.4)
                     rb-inotify (~> 0.9, >= 0.9.7)
                   sass-rails (5.0.7)
                     railties (>= 4.0.0, < 6)
                     sass (~> 3.1)
                     sprockets (>= 2.8, < 4.0)
                     sprockets-rails (>= 2.0, < 4.0)
                     tilt (>= 1.1, < 3)
-            -     sassc (2.0.1)
+            +     sassc (2.2.1)
                     ffi (~> 1.9)
-            -       rake
+            +     sassc-rails (2.1.2)
-            -     sassc-rails (2.1.1)
                     railties (>= 4.0.0)
                     sassc (>= 2.0)
                     sprockets (> 3.0)
                     sprockets-rails
                     tilt
                   select2-rails (4.0.3)
                     thor (~> 0.14)
-            -     selenium-webdriver (3.142.3)
+            +     selenium-webdriver (3.142.7)
-            -       childprocess (>= 0.5, < 2.0)
+            +       childprocess (>= 0.5, < 4.0)
-            -       rubyzip (~> 1.2, >= 1.2.2)
+            +       rubyzip (>= 1.2.2)
                   sexp_processor (4.12.0)
-            -     simple_form (4.1.0)
+            +     simple_form (5.0.2)
                     actionpack (>= 5.0)
                     activemodel (>= 5.0)
-            -     spring (2.1.0)
+            +     spring (2.0.2)
+            +       activesupport (>= 4.2)
                   spring-watcher-listen (2.0.1)
                     listen (>= 2.7, < 4.0)
                     spring (>= 1.2, < 3.0)
                   sprockets (3.7.2)
                     concurrent-ruby (~> 1.0)
                     rack (> 1, < 3)
                   sprockets-rails (3.2.1)
                     actionpack (>= 4.0)
                     activesupport (>= 4.0)
                     sprockets (>= 3.0.0)
                   sqlite3 (1.4.1)
                   temple (0.8.1)
                   thor (0.20.3)
                   thread_safe (0.3.6)
                   tilt (2.0.9)
-            -     tzinfo (1.2.5)
+            +     tzinfo (1.2.7)
                     thread_safe (~> 0.1)
                   uglifier (4.1.20)
                     execjs (>= 0.3.0, < 3)
                   web-console (3.7.0)
                     actionview (>= 5.0)
                     activemodel (>= 5.0)
                     bindex (>= 0.4.0)
                     railties (>= 5.0)
-            -     webdriver (0.1.0)
+            +     webdriver (0.5.0)
                   websocket-driver (0.7.1)
                     websocket-extensions (>= 0.1.0)
                   websocket-extensions (0.1.4)
                   will_paginate (3.0.12)
                   xpath (3.2.0)
                     nokogiri (~> 1.8)
                   yaml_db (0.7.0)
                     rails (>= 3.0)
                     rake (>= 0.8.7)
               PLATFORMS
                 ruby
               DEPENDENCIES
                 ace-rails-ap
                 activerecord-session_store
                 autoprefixer-rails
                 best_in_place (~> 3.0.1)
                 bootsnap (>= 1.1.0)
                 bootstrap-datepicker-rails
                 bootstrap-sass (~> 3.4.1)
                 bootstrap-switch-rails
                 bootstrap-toggle-rails
                 bootstrap3-datetimepicker-rails
                 byebug
                 capybara (>= 2.15)
-            -   capybara-console
                 coffee-rails
                 dynamic_form
                 fuzzy-string-match
                 haml
                 haml-rails
                 in_place_editing
                 jbuilder (~> 2.5)
                 jquery-countdown-rails
                 jquery-datatables-rails
                 jquery-rails
                 jquery-tablesorter
                 jquery-timepicker-addon-rails
                 jquery-ui-rails
                 listen (>= 3.0.5, < 3.2)
                 mail
                 minitest-reporters
                 momentjs-rails
                 mysql2
                 puma
                 rails (~> 5.2)
                 rails-controller-testing
                 rails_bootstrap_sortable
                 rdiscount
                 rouge
                 sassc-rails
                 select2-rails
                 selenium-webdriver
                 simple_form
                 spring
                 spring-watcher-listen (~> 2.0.0)
                 sqlite3
                 uglifier
                 web-console (>= 3.3.0)
                 webdriver
                 will_paginate (~> 3.0.7)
                 yaml_db
               BUNDLED WITH
-            -    1.17.2
+            +    1.16.2

app/controllers/application_controller.rb ¶ +61

               require 'ipaddr'
               class ApplicationController < ActionController::Base
                 protect_from_forgery
                 before_action :current_user
                 SINGLE_USER_MODE_CONF_KEY = 'system.single_user_mode'
                 MULTIPLE_IP_LOGIN_CONF_KEY = 'right.multiple_ip_login'
                 WHITELIST_IGNORE_CONF_KEY = 'right.whitelist_ignore'
                 WHITELIST_IP_CONF_KEY = 'right.whitelist_ip'
                 #report and redirect for unauthorized activities
                 def unauthorized_redirect(notice = 'You are not authorized to view the page you requested')
                   flash[:notice] = notice
                   redirect_to login_main_path
                 end
                 # Returns the current logged-in user (if any).
                 def current_user
                   return nil unless session[:user_id]
                   @current_user ||= User.find(session[:user_id])
                 end
                 def admin_authorization
                   return false unless check_valid_login
                   user = User.includes(:roles).find(session[:user_id])
                   unless user.admin?
                     unauthorized_redirect
                     return false
                   end
                   return true
                 end
                 def authorization_by_roles(allowed_roles)
                   return false unless check_valid_login
                   user = User.find(session[:user_id])
                   unless user.roles.detect { |role| allowed_roles.member?(role.name) }
                     unauthorized_redirect
                     return false
                   end
                 end
                 def testcase_authorization
                   #admin always has privileged
                   if @current_user.admin?
                     return true
                   end
                   unauthorized_redirect unless GraderConfiguration["right.view_testcase"]
                 end
                 protected
                 #redirect to root (and also force logout)
                 #if the user is not logged_in or the system is in "ADMIN ONLY" mode
                 def check_valid_login
                   #check if logged in
                   unless session[:user_id]
                     if GraderConfiguration[SINGLE_USER_MODE_CONF_KEY]
                       unauthorized_redirect('You need to login but you cannot log in at this time')
                     else
                       unauthorized_redirect('You need to login')
                     end
                     return false
                   end
                   # check if run in single user mode
                   if GraderConfiguration[SINGLE_USER_MODE_CONF_KEY]
                     if @current_user==nil || (!@current_user.admin?)
                       unauthorized_redirect('You cannot log in at this time')
                       return false
                     end
                   end
                   # check if the user is enabled
                   unless @current_user.enabled? || @current_user.admin?
                     unauthorized_redirect 'Your account is disabled'
                     return false
                   end
                   # check if user ip is allowed
                   unless @current_user.admin? || GraderConfiguration[WHITELIST_IGNORE_CONF_KEY]
                     unless is_request_ip_allowed?
                       unauthorized_redirect 'Your IP is not allowed to login at this time.'
                       return false
                     end
                   end
                   if GraderConfiguration.multicontests?
                     return true if @current_user.admin?
                     begin
                       if @current_user.contest_stat(true).forced_logout
                         flash[:notice] = 'You have been automatically logged out.'
                         redirect_to :controller => 'main', :action => 'index'
                       end
                     rescue
                     end
                   end
                   return true
                 end
                 #redirect to root (and also force logout)
                 #if the user use different ip from the previous connection
                 #  only applicable when MULTIPLE_IP_LOGIN options is false only
                 def authenticate_by_ip_address
                   #this assume that we have already authenticate normally
                   unless GraderConfiguration[MULTIPLE_IP_LOGIN_CONF_KEY]
                     user = User.find(session[:user_id])
                     if (!user.admin? && user.last_ip && user.last_ip != request.remote_ip)
                       flash[:notice] = "You cannot use the system from #{request.remote_ip}. Your last ip is #{user.last_ip}"
                       redirect_to :controller => 'main', :action => 'login'
                       return false
                     end
                     unless user.last_ip
                       user.last_ip = request.remote_ip
                       user.save
                     end
                   end
                   return true
                 end
                 def authorization
                   return false unless check_valid_login
                   user = User.find(session[:user_id])
                   unless user.roles.detect { |role|
                       role.rights.detect{ |right|
                         right.controller == self.class.controller_name and
                           (right.action == 'all' || right.action == action_name)
                       }
                     }
                     flash[:notice] = 'You are not authorized to view the page you requested'
                     #request.env['HTTP_REFERER'] ? (redirect_to :back) : (redirect_to :controller => 'login')
                     redirect_to :controller => 'main', :action => 'login'
                     return false
                   end
                 end
                 def verify_time_limit
                   return true if session[:user_id]==nil
                   user = User.find(session[:user_id], :include => :site)
                   return true if user==nil || user.site == nil
                   if user.contest_finished?
                     flash[:notice] = 'Error: the contest you are participating is over.'
                     redirect_to :back
                     return false
                   end
                   return true
                 end
                 def is_request_ip_allowed?
                   unless GraderConfiguration[WHITELIST_IGNORE_CONF_KEY]
                     user_ip = IPAddr.new(request.remote_ip)
                     GraderConfiguration[WHITELIST_IP_CONF_KEY].delete(' ').split(',').each do |ips|
                       allow_ips = IPAddr.new(ips)
                       if allow_ips.include?(user_ip)
                         return true
                       end
                     end
                     return false
                   end
                   return true
                 end
+            +   #function for datatable ajax query
+            +   #return record,total_count,filter_count
+            +   def process_query_record(record,
+            +                            total_count: nil,
+            +                            select: '',
+            +                            global_search: [],
+            +                            no_search: false,
+            +                            force_order: '',
+            +                            date_filter: '', date_param_since: 'date_since',date_param_until: 'date_until')
+            +     arel_table = record.model.arel_table
+            +
+            +     if !no_search && params['search']
+            +       global_value = record.model.sanitize_sql(params['search']['value'].strip.downcase)
+            +       if !global_value.blank?
+            +         global_value.split.each do |value|
+            +           global_where = global_search.map{|f| "LOWER(#{f}) like '%#{value}%'"}.join(' OR ')
+            +           record = record.where(global_where)
                       end
+            +       end
+            +
+            +       params['columns'].each do |i, col|
+            +         if !col['search']['value'].blank?
+            +           record = record.where(arel_table[col['name']].lower.matches("%#{col['search']['value'].strip.downcase}%"))
+            +         end
+            +       end
+            +     end
+            +
+            +     if !date_filter.blank?
+            +       date_since = Time.parse( params[:date_since] ) rescue Time.new(1,1,1)
+            +       date_until = Time.parse( params[:date_until] ) rescue Time.zone.now()
+            +       date_range = date_since..date_until
+            +       record = record.where(date_filter.to_sym => date_range)
+            +     end
+            +
+            +     if force_order.blank?
+            +       if params['order']
+            +         params['order'].each do |i, o|
+            +           colName = params['columns'][o['column']]['name']
+            +           colName = "#{record.model.table_name}.#{colName}" if colName.upcase == 'ID'
+            +           record = record.order("#{colName} #{o['dir'].casecmp('desc') != 0 ? 'ASC' : 'DESC'}") unless colName.blank?
+            +         end
+            +       end
+            +     else
+            +       record = record.order(force_order)
+            +     end
+            +
+            +     filterCount = record.count(record.model.primary_key)
+            +     # if .group() is used, filterCount might be like {id_1: count_1, id_2: count_2, ...}
+            +     # so we should count the result again..
+            +     if filterCount.is_a? Hash
+            +       filterCount = filterCount.count
+            +     end
+            +
+            +     record = record.offset(params['start'] || 0).limit(params['length'] || 100)
+            +     if (!select.blank?)
+            +       record = record.select(select)
+            +     end
+            +
+            +     return record, total_count || record.model.count, filterCount
+            +   end
+            +
+            + end

app/controllers/report_controller.rb ¶ +15 -19

               require 'csv'
               class ReportController < ApplicationController
                 before_action :check_valid_login
                 before_action :admin_authorization, only: [:login_stat,:submission_stat, :stuck, :cheat_report, :cheat_scruntinize, :show_max_score, :current_score]
                 before_action(only: [:problem_hof]) { |c|
                   return false unless check_valid_login
                   admin_authorization unless GraderConfiguration["right.user_view_submission"]
                 }
                 def max_score
                 end
                 def current_score
                   @problems = Problem.available_problems
                   if params[:group_id]
                     @group = Group.find(params[:group_id])
                     @users = @group.users.where(enabled: true)
                   else
                     @users = User.includes(:contests).includes(:contest_stat).where(enabled: true)
                   end
                   @scorearray = calculate_max_score(@problems, @users,0,0,true)
                   #rencer accordingly
                   if params[:button] == 'download' then
                     csv = gen_csv_from_scorearray(@scorearray,@problems)
                     send_data csv, filename: 'max_score.csv'
                   else
                     #render template: 'user_admin/user_stat'
                     render 'current_score'
                   end
                 end
                 def show_max_score
                   #process parameters
                   #problems
                   @problems = []
                   if params[:problem_id]
                     params[:problem_id].each do |id|
                       next unless id.strip != ""
                       pid = Problem.find_by_id(id.to_i)
                       @problems << pid if pid
                     end
                   end
                   #users
                   @users = if params[:users] == "all" then
                              User.includes(:contests).includes(:contest_stat)
                            else
                              User.includes(:contests).includes(:contest_stat).where(enabled: true)
                            end
                   #set up range from param
                   @since_id = params.fetch(:from_id, 0).to_i
                   @until_id = params.fetch(:to_id, 0).to_i
                   @since_id = nil if @since_id == 0
                   @until_id = nil if @until_id == 0
                   #calculate the routine
                   @scorearray = calculate_max_score(@problems, @users, @since_id, @until_id)
                   #rencer accordingly
                   if params[:button] == 'download' then
                     csv = gen_csv_from_scorearray(@scorearray,@problems)
                     send_data csv, filename: 'max_score.csv'
                   else
                     #render template: 'user_admin/user_stat'
                     render 'max_score'
                   end
                 end
                 def score
                   if params[:commit] == 'download csv'
                     @problems = Problem.all
                   else
                     @problems = Problem.available_problems
                   end
                   @users = User.includes(:contests, :contest_stat).where(enabled: true)
                   @scorearray = Array.new
                   @users.each do |u|
                     ustat = Array.new
                     ustat[0] = u
                     @problems.each do |p|
                       sub = Submission.find_last_by_user_and_problem(u.id,p.id)
                       if (sub!=nil) and (sub.points!=nil) and p and p.full_score
                         ustat << [(sub.points.to_f*100/p.full_score).round, (sub.points>=p.full_score)]
                       else
                         ustat << [0,false]
                       end
                     end
                     @scorearray << ustat
                   end
                   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
                 end
                 def login_stat
                   @logins = Array.new
                   date_and_time = '%Y-%m-%d %H:%M'
                   begin
                     md = params[:since_datetime].match(/(\d+)-(\d+)-(\d+) (\d+):(\d+)/)
                     @since_time = Time.zone.local(md[1].to_i,md[2].to_i,md[3].to_i,md[4].to_i,md[5].to_i)
                   rescue
                     @since_time = DateTime.new(1000,1,1)
                   end
                   begin
                     md = params[:until_datetime].match(/(\d+)-(\d+)-(\d+) (\d+):(\d+)/)
                     @until_time = Time.zone.local(md[1].to_i,md[2].to_i,md[3].to_i,md[4].to_i,md[5].to_i)
                   rescue
                     @until_time = DateTime.new(3000,1,1)
                   end
                   User.all.each do |user|
                     @logins << { id: user.id,
                                  login: user.login,
                                  full_name: user.full_name,
                                  count: Login.where("user_id = ? AND created_at >= ? AND created_at <= ?",
                                                     user.id,@since_time,@until_time)
                                         .count(:id),
                                  min: Login.where("user_id = ? AND created_at >= ? AND created_at <= ?",
                                                     user.id,@since_time,@until_time)
                                         .minimum(:created_at),
                                  max: Login.where("user_id = ? AND created_at >= ? AND created_at <= ?",
                                                     user.id,@since_time,@until_time)
                                         .maximum(:created_at),
                                   ip: Login.where("user_id = ? AND created_at >= ? AND created_at <= ?",
                                                     user.id,@since_time,@until_time)
                                         .select(:ip_address).uniq
                                }
                   end
                 end
-            -   def submission_stat
+            +   def submission
                   date_and_time = '%Y-%m-%d %H:%M'
                   begin
                     @since_time = DateTime.strptime(params[:since_datetime],date_and_time)
                   rescue
                     @since_time = DateTime.new(1000,1,1)
                   end
                   begin
                     @until_time = DateTime.strptime(params[:until_datetime],date_and_time)
                   rescue
                     @until_time = DateTime.new(3000,1,1)
                   end
-            -     @submissions = {}
+            +     @submissions = Submission
+            +       .joins(:problem).joins(:user)
-            -     User.find_each do |user|
+            +       .where("submitted_at >= ? AND submitted_at <= ?",@since_time,@until_time)
-            -       @submissions[user.id] = { login: user.login, full_name: user.full_name, count: 0, sub: { } }
                 end
-            -     Submission.where("submitted_at >= ? AND submitted_at <= ?",@since_time,@until_time).find_each do |s|
+            +   def submission_query
-            -       if @submissions[s.user_id]
+            +     @submissions = Submission
-            -         if not @submissions[s.user_id][:sub].has_key?(s.problem_id)
+            +       .joins(:problem).joins(:user)
-            -           a = Problem.find_by_id(s.problem_id)
+            +       .where("submitted_at >= ? AND submitted_at <= ?",@since_time,@until_time)
-            -           @submissions[s.user_id][:sub][s.problem_id] =
-            -             { prob_name: (a ? a.full_name : '(NULL)'),
+            +     @submissions, @recordsTotal, @recordsFiltered = process_query_record( @submissions,
-            -               sub_ids: [s.id] }
+            +       global_search: ['user.login','user.full_name','problem.name','problem.full_name','points'],
-            -         else
+            +       date_filter: 'submitted_at',
-            -           @submissions[s.user_id][:sub][s.problem_id][:sub_ids] << s.id
+            +       date_param_since: 'since_datetime',
-            -         end
+            +       date_param_until: 'until_datetime',
-            -         @submissions[s.user_id][:count] += 1
+            +     )
-            -       end
-            -     end
                 end
                 def problem_hof
                   # gen problem list
                   @user = User.find(session[:user_id])
                   @problems = @user.available_problems
                   # get selected problems or the default
                   if params[:id]
                     begin
                       @problem = Problem.available.find(params[:id])
                     rescue
                       redirect_to action: :problem_hof
                       flash[:notice] = 'Error: submissions for that problem are not viewable.'
                       return
                     end
                   end
                   return unless @problem
                   @by_lang = {} #aggregrate by language
                   range =65
                   @histogram = { data: Array.new(range,0), summary: {} }
                   @summary = {count: 0, solve: 0, attempt: 0}
                   user = Hash.new(0)
                   Submission.where(problem_id: @problem.id).find_each do |sub|
                     #histogram
                     d = (DateTime.now.in_time_zone - sub.submitted_at) / 24 / 60 / 60
                     @histogram[:data][d.to_i] += 1 if d < range
                     next unless sub.points
                     @summary[:count] += 1
                     user[sub.user_id] = [user[sub.user_id], (sub.points >= @problem.full_score) ? 1 : 0].max
                     lang = Language.find_by_id(sub.language_id)
                     next unless lang
                     next unless sub.points >= @problem.full_score
                     #initialize
                     unless @by_lang.has_key?(lang.pretty_name)
                       @by_lang[lang.pretty_name] = {
                         runtime: { avail: false, value: 2**30-1 },
                         memory: { avail: false, value: 2**30-1 },
                         length: { avail: false, value: 2**30-1 },
                         first: { avail: false, value: DateTime.new(3000,1,1) }
                       }
                     end
                     if sub.max_runtime and sub.max_runtime < @by_lang[lang.pretty_name][:runtime][:value]
                       @by_lang[lang.pretty_name][:runtime] = { avail: true, user_id: sub.user_id, value: sub.max_runtime, sub_id: sub.id }
                     end
                     if sub.peak_memory and sub.peak_memory < @by_lang[lang.pretty_name][:memory][:value]
                       @by_lang[lang.pretty_name][:memory] = { avail: true, user_id: sub.user_id, value: sub.peak_memory, sub_id: sub.id }
                     end
                     if sub.submitted_at and sub.submitted_at < @by_lang[lang.pretty_name][:first][:value] and sub.user and
                         !sub.user.admin?
                       @by_lang[lang.pretty_name][:first] = { avail: true, user_id: sub.user_id, value: sub.submitted_at, sub_id: sub.id }
                     end
                     if @by_lang[lang.pretty_name][:length][:value] > sub.effective_code_length
                       @by_lang[lang.pretty_name][:length] = { avail: true, user_id: sub.user_id, value: sub.effective_code_length, sub_id: sub.id }
                     end
                   end
                   #process user_id
                   @by_lang.each do |lang,prop|
                     prop.each do |k,v|
                       v[:user] = User.exists?(v[:user_id]) ? User.find(v[:user_id]).full_name : "(NULL)"
                     end
                   end
                   #sum into best
                   if @by_lang and @by_lang.first
                     @best = @by_lang.first[1].clone
                     @by_lang.each do |lang,prop|
                       if @best[:runtime][:value] >= prop[:runtime][:value]
                         @best[:runtime] = prop[:runtime]
                         @best[:runtime][:lang] = lang
                       end
                       if @best[:memory][:value] >= prop[:memory][:value]
                         @best[:memory] = prop[:memory]
                         @best[:memory][:lang] = lang
                       end
                       if @best[:length][:value] >= prop[:length][:value]
                         @best[:length] = prop[:length]
                         @best[:length][:lang] = lang
                       end
                       if @best[:first][:value] >= prop[:first][:value]
                         @best[:first] = prop[:first]
                         @best[:first][:lang] = lang
                       end
                     end
                   end
                   @histogram[:summary][:max] = [@histogram[:data].max,1].max
                   @summary[:attempt] = user.count
                   user.each_value { |v| @summary[:solve] += 1 if v == 1 }
                 end
                 def stuck #report struggling user,problem
                   # init
                   user,problem = nil
                   solve = true
                   tries = 0
                   @struggle = Array.new
                   record = {}
                   Submission.includes(:problem,:user).order(:problem_id,:user_id).find_each do |sub|
                     next unless sub.problem and sub.user
                     if user != sub.user_id or problem != sub.problem_id
                       @struggle << { user: record[:user], problem: record[:problem], tries: tries } unless solve
                       record = {user: sub.user, problem: sub.problem}
                       user,problem = sub.user_id, sub.problem_id
                       solve = false
                       tries = 0
                     end
                     if sub.points >= sub.problem.full_score
                       solve = true
                     else
                       tries += 1
                     end
                   end
                   @struggle.sort!{|a,b| b[:tries] <=> a[:tries] }
                   @struggle = @struggle[0..50]
                 end
                 def multiple_login
                   #user with multiple IP
                   raw = Submission.joins(:user).joins(:problem).where("problems.available != 0").group("login,ip_address").order(:login)
                   last,count = 0,0
                   first = 0
                   @users = []
                   raw.each do |r|
                     if last != r.user.login
                       count = 1
                       last = r.user.login
                       first = r
                     else
                       @users << first if count == 1
                       @users << r
                       count += 1
                     end
                   end
                   #IP with multiple user
                   raw = Submission.joins(:user).joins(:problem).where("problems.available != 0").group("login,ip_address").order(:ip_address)
                   last,count = 0,0
                   first = 0
                   @ip = []
                   raw.each do |r|
                     if last != r.ip_address
                       count = 1
                       last = r.ip_address
                       first = r
                     else
                       @ip << first if count == 1
                       @ip << r
                       count += 1
                     end
                   end
                 end
                 def cheat_report
                   date_and_time = '%Y-%m-%d %H:%M'
                   begin
                     md = params[:since_datetime].match(/(\d+)-(\d+)-(\d+) (\d+):(\d+)/)
                     @since_time = Time.zone.local(md[1].to_i,md[2].to_i,md[3].to_i,md[4].to_i,md[5].to_i)
                   rescue
                     @since_time = Time.zone.now.ago( 90.minutes)
                   end
                   begin
                     md = params[:until_datetime].match(/(\d+)-(\d+)-(\d+) (\d+):(\d+)/)
                     @until_time = Time.zone.local(md[1].to_i,md[2].to_i,md[3].to_i,md[4].to_i,md[5].to_i)
                   rescue
                     @until_time = Time.zone.now
                   end
                   #multi login
                   @ml = Login.joins(:user).where("logins.created_at >= ? and logins.created_at <= ?",@since_time,@until_time).select('users.login,count(distinct ip_address) as count,users.full_name').group("users.id").having("count > 1")
                   st = <<-SQL
                 SELECT l2.*
                   FROM logins l2 INNER JOIN
                   (SELECT u.id,COUNT(DISTINCT ip_address) as count,u.login,u.full_name
                     FROM logins l
                     INNER JOIN users u ON l.user_id =  u.id
                     WHERE l.created_at >= '#{@since_time.in_time_zone("UTC")}' and l.created_at <= '#{@until_time.in_time_zone("UTC")}'
                     GROUP BY u.id
                     HAVING count > 1
                   ) ml ON l2.user_id = ml.id
                   WHERE l2.created_at >= '#{@since_time.in_time_zone("UTC")}' and l2.created_at <= '#{@until_time.in_time_zone("UTC")}'
               UNION
                 SELECT l2.*
                   FROM logins l2 INNER JOIN
                   (SELECT l.ip_address,COUNT(DISTINCT u.id) as count
                     FROM logins l
                     INNER JOIN users u ON l.user_id =  u.id
                     WHERE l.created_at >= '#{@since_time.in_time_zone("UTC")}' and l.created_at <= '#{@until_time.in_time_zone("UTC")}'
                     GROUP BY l.ip_address
                     HAVING count > 1
                   ) ml on ml.ip_address = l2.ip_address
                   INNER JOIN users u ON l2.user_id = u.id
                   WHERE l2.created_at >= '#{@since_time.in_time_zone("UTC")}' and l2.created_at <= '#{@until_time.in_time_zone("UTC")}'
               ORDER BY ip_address,created_at
                             SQL
                   @mld = Login.find_by_sql(st)
                   st = <<-SQL
                 SELECT s.id,s.user_id,s.ip_address,s.submitted_at,s.problem_id
                   FROM submissions s INNER JOIN
                   (SELECT u.id,COUNT(DISTINCT ip_address) as count,u.login,u.full_name
                     FROM logins l
                     INNER JOIN users u ON l.user_id =  u.id
                     WHERE l.created_at >= ? and l.created_at <= ?
                     GROUP BY u.id
                     HAVING count > 1
                   ) ml ON s.user_id = ml.id
                   WHERE s.submitted_at >= ? and s.submitted_at <= ?
               UNION
                 SELECT s.id,s.user_id,s.ip_address,s.submitted_at,s.problem_id
                   FROM submissions s INNER JOIN
                   (SELECT l.ip_address,COUNT(DISTINCT u.id) as count
                     FROM logins l
                     INNER JOIN users u ON l.user_id =  u.id
                     WHERE l.created_at >= ? and l.created_at <= ?
                     GROUP BY l.ip_address
                     HAVING count > 1
                   ) ml on ml.ip_address = s.ip_address
                   WHERE s.submitted_at >= ? and s.submitted_at <= ?
               ORDER BY ip_address,submitted_at
                           SQL
                   @subs = Submission.joins(:problem).find_by_sql([st,@since_time,@until_time,
                                                      @since_time,@until_time,
                                                      @since_time,@until_time,
                                                      @since_time,@until_time])
                 end
                 def cheat_scruntinize
                   #convert date & time
                   date_and_time = '%Y-%m-%d %H:%M'
                   begin
                     md = params[:since_datetime].match(/(\d+)-(\d+)-(\d+) (\d+):(\d+)/)
                     @since_time = Time.zone.local(md[1].to_i,md[2].to_i,md[3].to_i,md[4].to_i,md[5].to_i)
                   rescue
                     @since_time = Time.zone.now.ago( 90.minutes)
                   end
                   begin
                     md = params[:until_datetime].match(/(\d+)-(\d+)-(\d+) (\d+):(\d+)/)
                     @until_time = Time.zone.local(md[1].to_i,md[2].to_i,md[3].to_i,md[4].to_i,md[5].to_i)
                   rescue
                     @until_time = Time.zone.now
                   end
                   #convert sid
                   @sid = params[:SID].split(/[,\s]/) if params[:SID]
                   unless @sid and @sid.size > 0
                     return
                     redirect_to actoin: :cheat_scruntinize
                     flash[:notice] = 'Please enter at least 1 student id'
                   end
                   mark = Array.new(@sid.size,'?')
                   condition = "(u.login = " + mark.join(' OR u.login = ') + ')'
                   @st = <<-SQL
                 SELECT l.created_at as submitted_at ,-1 as id,u.login,u.full_name,l.ip_address,"" as problem_id,"" as points,l.user_id
                 FROM logins l INNER JOIN users u on l.user_id  = u.id
                 WHERE l.created_at >= ? AND l.created_at <= ? AND #{condition}
               UNION
                 SELECT s.submitted_at,s.id,u.login,u.full_name,s.ip_address,s.problem_id,s.points,s.user_id
                 FROM submissions s INNER JOIN users u ON s.user_id = u.id
                 WHERE s.submitted_at >= ? AND s.submitted_at <= ? AND #{condition}
               ORDER BY submitted_at
                 SQL
                   p = [@st,@since_time,@until_time] + @sid + [@since_time,@until_time] + @sid
                   @logs = Submission.joins(:problem).find_by_sql(p)
                 end
                 protected
                 def calculate_max_score(problems, users,since_id,until_id, get_last_score = false)
                   #scorearray[i] = user #i's user stat where i is the index (not id)
                   scorearray = Array.new
                   users.each do |u|
                     ustat = Array.new
                     ustat[0] = u
                     problems.each do |p|
                       unless get_last_score
                         #get max score
                         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)]
                       else
                         #get latest score
                         sub = Submission.find_last_by_user_and_problem(u.id,p.id)
                         if (sub!=nil) and (sub.points!=nil) and p and p.full_score
                           ustat << [(sub.points.to_f*100/p.full_score).round, (sub.points>=p.full_score)]
                         else
                           ustat << [0,false]
                         end
                       end
                     end
                     scorearray << ustat
                   end
                   return scorearray
                 end
                 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
                           row << (sc[i].try(:contest_stat).try(:started_at)!=nil ? 'yes' : 'no')
                           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
               end

config/routes.rb ¶ +2

               Rails.application.routes.draw do
                 resources :tags
                 get "sources/direct_edit"
                 root :to => 'main#login'
                 #logins
                 match 'login/login',  to: 'login#login', via: [:get,:post]
                 resources :contests
                 resources :sites
                 resources :test
                 resources :messages do
                   member do
                     get 'hide'
                     post 'reply'
                   end
                   collection do
                     get 'console'
                     get 'list_all'
                   end
                 end
                 resources :announcements do
                   member do
                     get 'toggle','toggle_front'
                   end
                 end
                 resources :problems do
                   member do
                     get 'toggle'
                     get 'toggle_test'
                     get 'toggle_view_testcase'
                     get 'stat'
                   end
                   collection do
                     get 'turn_all_off'
                     get 'turn_all_on'
                     get 'import'
                     get 'manage'
                     get 'quick_create'
                     post 'do_manage'
                     post 'do_import'
                   end
                 end
                 resources :groups do
                   member do
                     post 'add_user', to: 'groups#add_user', as: 'add_user'
                     delete 'remove_user/:user_id', to: 'groups#remove_user', as: 'remove_user'
                     delete 'remove_all_user', to: 'groups#remove_all_user', as: 'remove_all_user'
                     post 'add_problem', to: 'groups#add_problem', as: 'add_problem'
                     delete 'remove_problem/:problem_id', to: 'groups#remove_problem', as: 'remove_problem'
                     delete 'remove_all_problem', to: 'groups#remove_all_problem', as: 'remove_all_problem'
                   end
                   collection do
                   end
                 end
                 resources :testcases, only: [] do
                   member do
                     get 'download_input'
                     get 'download_sol'
                   end
                   collection do
                     get 'show_problem/:problem_id(/:test_num)' => 'testcases#show_problem', as: 'show_problem'
                   end
                 end
                 resources :grader_configuration, controller: 'configurations' do
                   collection do
                     get 'set_exam_right(/:value)', action: 'set_exam_right', as: 'set_exam_right'
                   end
                 end
                 resources :users do
                   member do
                     get 'toggle_activate', 'toggle_enable'
                     get 'stat'
                   end
                   collection do
                     get 'profile'
                     post 'chg_passwd'
                   end
                 end
                 resources :submissions do
                   member do
                     get 'download'
                     get 'compiler_msg'
                     get 'rejudge'
                     get 'source'
                   end
                   collection do
                     get 'prob/:problem_id', to: 'submissions#index', as: 'problem'
                     get 'direct_edit_problem/:problem_id(/:user_id)', to: 'submissions#direct_edit_problem', as: 'direct_edit_problem'
                     get 'get_latest_submission_status/:uid/:pid', to: 'submissions#get_latest_submission_status', as: 'get_latest_submission_status'
                   end
                 end
                 #user admin
                 resources :user_admin  do
                   collection do
                     match 'bulk_manage', via: [:get, :post]
                     get 'bulk_mail'
                     get 'user_stat'
                     get 'import'
                     get 'new_list'
                     get 'admin'
                     get 'active'
                     get 'mass_mailing'
                     get 'revoke_admin'
                     post 'grant_admin'
                     match 'create_from_list', via: [:get, :post]
                     match 'random_all_passwords', via: [:get, :post]
                   end
                   member do
                     get 'clear_last_ip'
                   end
                 end
                 resources :contest_management, only: [:index] do
                   collection do
                     get 'user_stat'
                     get 'clear_stat'
                     get 'clear_all_stat'
                     get 'change_contest_mode'
                   end
                 end
                 #get 'user_admin', to: 'user_admin#index'
                 #get 'user_admin/bulk_manage', to: 'user_admin#bulk_manage', as: 'bulk_manage_user_admin'
                 #post 'user_admin', to: 'user_admin#create'
                 #delete 'user_admin/:id', to: 'user_admin#destroy', as: 'user_admin_destroy'
                 #singular resource
                 #---- BEWARE ---- singular resource maps to plural controller by default, we can override by provide controller name directly
                 #report
                 resource :report, only: [], controller: 'report' do
                   get 'login'
                   get 'multiple_login'
                   get 'problem_hof(/:id)', action: 'problem_hof', as: 'problem_hof'
                   get 'current_score(/:group_id)', action: 'current_score', as: 'current_score'
                   get 'max_score'
                   post 'show_max_score'
                   get 'stuck'
                   get 'cheat_report'
                   post 'cheat_report'
                   get 'cheat_scruntinize'
                   post 'cheat_scruntinize'
+            +     get 'submission'
+            +     post 'submission_query'
                 end
                 #get 'report/current_score', to: 'report#current_score', as: 'report_current_score'
                 #get 'report/problem_hof(/:id)', to: 'report#problem_hof', as: 'report_problem_hof'
                 #get "report/login"
                 #get 'report/max_score', to: 'report#max_score', as: 'report_max_score'
                 #post 'report/show_max_score', to: 'report#show_max_score', as: 'report_show_max_score'
                 resource :main, only: [], controller: 'main' do
                   get 'login'
                   get 'logout'
                   get 'list'
                   get 'submission(/:id)', action: 'submission', as: 'main_submission'
                   get 'announcements'
                   get 'help'
                   post 'submit'
                 end
                 #main
                 #get "main/list"
                 #get 'main/submission(/:id)', to: 'main#submission', as: 'main_submission'
                 #post 'main/submit', to: 'main#submit'
                 #get 'main/announcements', to: 'main#announcements'
                 #
                 get 'tasks/view/:file.:ext' => 'tasks#view'
                 get 'tasks/download/:id/:file.:ext' => 'tasks#download'
                 get 'heartbeat/:id/edit' => 'heartbeat#edit'
                 #grader
                 get 'graders/list', to: 'graders#list', as: 'grader_list'
                 namespace :graders do
                   get 'task/:id/:type', action: 'task', as: 'task'
                   get 'view/:id/:type', action: 'view', as: 'view'
                   get 'clear/:id', action: 'clear', as: 'clear'
                   get 'stop'
                   get 'stop_all'
                   get 'clear_all'
                   get 'clear_terminated'
                   get 'start_grading'
                   get 'start_exam'
                 end
                 # See how all your routes lay out with "rake routes"
                 # This is a legacy wild controller route that's not recommended for RESTful applications.
                 # Note: This route will make all actions in every controller accessible via GET requests.
                 # match ':controller(/:action(/:id))(.:format)', via:  [:get, :post]
               end

db/schema.rb ¶ +168 -154

+            + # encoding: UTF-8
               # This file is auto-generated from the current state of the database. Instead
               # of editing this file, please use the migrations feature of Active Record to
               # incrementally modify your database, and then regenerate this schema definition.
               #
               # Note that this schema.rb definition is the authoritative source for your
               # database schema. If you need to create the application database on another
               # system, you should be using db:schema:load, not running all the migrations
               # from scratch. The latter is a flawed and unsustainable approach (the more migrations
               # you'll amass, the slower it'll run and the greater likelihood for issues).
               #
               # It's strongly recommended that you check this file into your version control system.
-            - ActiveRecord::Schema.define(version: 2018_06_12_102327) do
+            + ActiveRecord::Schema.define(version: 20180612102327) do
-            -   create_table "announcements", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "announcements", force: :cascade do |t|
-            -     t.string "author"
+            +     t.string   "author",       limit: 255
-            -     t.text "body"
+            +     t.text     "body",         limit: 65535
                   t.boolean  "published"
                   t.datetime "created_at"
                   t.datetime "updated_at"
                   t.boolean  "frontpage",                  default: false
                   t.boolean  "contest_only",               default: false
-            -     t.string "title"
+            +     t.string   "title",        limit: 255
-            -     t.string "notes"
+            +     t.string   "notes",        limit: 255
                 end
-            -   create_table "contests", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "contests", force: :cascade do |t|
-            -     t.string "title"
+            +     t.string   "title",      limit: 255
                   t.boolean  "enabled"
                   t.datetime "created_at"
                   t.datetime "updated_at"
-            -     t.string "name"
+            +     t.string   "name",       limit: 255
                 end
-            -   create_table "contests_problems", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "contests_problems", id: false, force: :cascade do |t|
-            -     t.integer "contest_id"
+            +     t.integer "contest_id", limit: 4
-            -     t.integer "problem_id"
+            +     t.integer "problem_id", limit: 4
                 end
-            -   create_table "contests_users", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "contests_users", id: false, force: :cascade do |t|
-            -     t.integer "contest_id"
+            +     t.integer "contest_id", limit: 4
-            -     t.integer "user_id"
+            +     t.integer "user_id",    limit: 4
                 end
-            -   create_table "countries", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "countries", force: :cascade do |t|
-            -     t.string "name"
+            +     t.string   "name",       limit: 255
                   t.datetime "created_at"
                   t.datetime "updated_at"
                 end
-            -   create_table "descriptions", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "descriptions", force: :cascade do |t|
-            -     t.text "body"
+            +     t.text     "body",       limit: 65535
                   t.boolean  "markdowned"
                   t.datetime "created_at"
                   t.datetime "updated_at"
                 end
-            -   create_table "grader_configurations", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "grader_configurations", force: :cascade do |t|
-            -     t.string "key"
+            +     t.string   "key",         limit: 255
-            -     t.string "value_type"
+            +     t.string   "value_type",  limit: 255
-            -     t.string "value"
+            +     t.string   "value",       limit: 255
                   t.datetime "created_at"
                   t.datetime "updated_at"
-            -     t.text "description"
+            +     t.text     "description", limit: 65535
                 end
-            -   create_table "grader_processes", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "grader_processes", force: :cascade do |t|
-            -     t.string "host"
+            +     t.string   "host",       limit: 255
-            -     t.integer "pid"
+            +     t.integer  "pid",        limit: 4
-            -     t.string "mode"
+            +     t.string   "mode",       limit: 255
                   t.boolean  "active"
                   t.datetime "created_at"
                   t.datetime "updated_at"
-            -     t.integer "task_id"
+            +     t.integer  "task_id",    limit: 4
-            -     t.string "task_type"
+            +     t.string   "task_type",  limit: 255
                   t.boolean  "terminated"
-            -     t.index ["host", "pid"], name: "index_grader_processes_on_host_and_pid"
                 end
-            -   create_table "groups", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "grader_processes", ["host", "pid"], name: "index_grader_processes_on_host_and_pid", using: :btree
-            -     t.string "name"
-            -     t.string "description"
+            +   create_table "groups", force: :cascade do |t|
+            +     t.string "name",        limit: 255
+            +     t.string "description", limit: 255
                 end
-            -   create_table "groups_problems", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "groups_problems", id: false, force: :cascade do |t|
-            -     t.integer "problem_id", null: false
+            +     t.integer "problem_id", limit: 4, null: false
-            -     t.integer "group_id", null: false
+            +     t.integer "group_id",   limit: 4, null: false
-            -     t.index ["group_id", "problem_id"], name: "index_groups_problems_on_group_id_and_problem_id"
                 end
-            -   create_table "groups_users", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "groups_problems", ["group_id", "problem_id"], name: "index_groups_problems_on_group_id_and_problem_id", using: :btree
-            -     t.integer "group_id", null: false
-            -     t.integer "user_id", null: false
+            +   create_table "groups_users", id: false, force: :cascade do |t|
-            -     t.index ["user_id", "group_id"], name: "index_groups_users_on_user_id_and_group_id"
+            +     t.integer "group_id", limit: 4, null: false
+            +     t.integer "user_id",  limit: 4, null: false
                 end
-            -   create_table "heart_beats", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "groups_users", ["user_id", "group_id"], name: "index_groups_users_on_user_id_and_group_id", using: :btree
-            -     t.integer "user_id"
-            -     t.string "ip_address"
+            +   create_table "heart_beats", force: :cascade do |t|
+            +     t.integer  "user_id",    limit: 4
+            +     t.string   "ip_address", limit: 255
                   t.datetime "created_at"
                   t.datetime "updated_at"
-            -     t.string "status"
+            +     t.string   "status",     limit: 255
-            -     t.index ["updated_at"], name: "index_heart_beats_on_updated_at"
                 end
-            -   create_table "languages", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "heart_beats", ["updated_at"], name: "index_heart_beats_on_updated_at", using: :btree
+            +
+            +   create_table "languages", force: :cascade do |t|
                   t.string "name",        limit: 10
-            -     t.string "pretty_name"
+            +     t.string "pretty_name", limit: 255
                   t.string "ext",         limit: 10
-            -     t.string "common_ext"
+            +     t.string "common_ext",  limit: 255
                 end
-            -   create_table "logins", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "logins", force: :cascade do |t|
-            -     t.integer "user_id"
+            +     t.integer  "user_id",    limit: 4
-            -     t.string "ip_address"
+            +     t.string   "ip_address", limit: 255
                   t.datetime "created_at"
                   t.datetime "updated_at"
                 end
-            -   create_table "messages", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "messages", force: :cascade do |t|
-            -     t.integer "sender_id"
+            +     t.integer  "sender_id",           limit: 4
-            -     t.integer "receiver_id"
+            +     t.integer  "receiver_id",         limit: 4
-            -     t.integer "replying_message_id"
+            +     t.integer  "replying_message_id", limit: 4
-            -     t.text "body"
+            +     t.text     "body",                limit: 65535
                   t.boolean  "replied"
                   t.datetime "created_at"
                   t.datetime "updated_at"
                 end
-            -   create_table "problems", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "problems", force: :cascade do |t|
                   t.string  "name",                 limit: 30
-            -     t.string "full_name"
+            +     t.string  "full_name",            limit: 255
-            -     t.integer "full_score"
+            +     t.integer "full_score",           limit: 4
                   t.date    "date_added"
                   t.boolean "available"
-            -     t.string "url"
+            +     t.string  "url",                  limit: 255
-            -     t.integer "description_id"
+            +     t.integer "description_id",       limit: 4
                   t.boolean "test_allowed"
                   t.boolean "output_only"
-            -     t.string "description_filename"
+            +     t.string  "description_filename", limit: 255
                   t.boolean "view_testcase"
                 end
-            -   create_table "problems_tags", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "problems_tags", force: :cascade do |t|
-            -     t.integer "problem_id"
+            +     t.integer "problem_id", limit: 4
-            -     t.integer "tag_id"
+            +     t.integer "tag_id",     limit: 4
-            -     t.index ["problem_id", "tag_id"], name: "index_problems_tags_on_problem_id_and_tag_id", unique: true
-            -     t.index ["problem_id"], name: "index_problems_tags_on_problem_id"
-            -     t.index ["tag_id"], name: "index_problems_tags_on_tag_id"
                 end
-            -   create_table "rights", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "problems_tags", ["problem_id", "tag_id"], name: "index_problems_tags_on_problem_id_and_tag_id", unique: true, using: :btree
-            -     t.string "name"
+            +   add_index "problems_tags", ["problem_id"], name: "index_problems_tags_on_problem_id", using: :btree
-            -     t.string "controller"
+            +   add_index "problems_tags", ["tag_id"], name: "index_problems_tags_on_tag_id", using: :btree
-            -     t.string "action"
+            +   create_table "rights", force: :cascade do |t|
+            +     t.string "name",       limit: 255
+            +     t.string "controller", limit: 255
+            +     t.string "action",     limit: 255
                 end
-            -   create_table "rights_roles", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "rights_roles", id: false, force: :cascade do |t|
-            -     t.integer "right_id"
+            +     t.integer "right_id", limit: 4
-            -     t.integer "role_id"
+            +     t.integer "role_id",  limit: 4
-            -     t.index ["role_id"], name: "index_rights_roles_on_role_id"
                 end
-            -   create_table "roles", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "rights_roles", ["role_id"], name: "index_rights_roles_on_role_id", using: :btree
-            -     t.string "name"
+            +   create_table "roles", force: :cascade do |t|
+            +     t.string "name", limit: 255
                 end
-            -   create_table "roles_users", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "roles_users", id: false, force: :cascade do |t|
-            -     t.integer "role_id"
+            +     t.integer "role_id", limit: 4
-            -     t.integer "user_id"
+            +     t.integer "user_id", limit: 4
-            -     t.index ["user_id"], name: "index_roles_users_on_user_id"
                 end
-            -   create_table "sessions", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "roles_users", ["user_id"], name: "index_roles_users_on_user_id", using: :btree
-            -     t.string "session_id"
-            -     t.text "data"
+            +   create_table "sessions", force: :cascade do |t|
+            +     t.string   "session_id", limit: 255
+            +     t.text     "data",       limit: 65535
                   t.datetime "updated_at"
-            -     t.index ["session_id"], name: "index_sessions_on_session_id"
-            -     t.index ["updated_at"], name: "index_sessions_on_updated_at"
                 end
-            -   create_table "sites", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "sessions", ["session_id"], name: "index_sessions_on_session_id", using: :btree
-            -     t.string "name"
+            +   add_index "sessions", ["updated_at"], name: "index_sessions_on_updated_at", using: :btree
+            +
+            +   create_table "sites", force: :cascade do |t|
+            +     t.string   "name",       limit: 255
                   t.boolean  "started"
                   t.datetime "start_time"
                   t.datetime "created_at"
                   t.datetime "updated_at"
-            -     t.integer "country_id"
+            +     t.integer  "country_id", limit: 4
-            -     t.string "password"
+            +     t.string   "password",   limit: 255
                 end
-            -   create_table "submission_view_logs", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "submission_view_logs", force: :cascade do |t|
-            -     t.integer "user_id"
+            +     t.integer  "user_id",       limit: 4
-            -     t.integer "submission_id"
+            +     t.integer  "submission_id", limit: 4
                   t.datetime "created_at"
                   t.datetime "updated_at"
                 end
-            -   create_table "submissions", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "submissions", force: :cascade do |t|
-            -     t.integer "user_id"
+            +     t.integer  "user_id",               limit: 4
-            -     t.integer "problem_id"
+            +     t.integer  "problem_id",            limit: 4
-            -     t.integer "language_id"
+            +     t.integer  "language_id",           limit: 4
                   t.text     "source",                limit: 16777215
-            -     t.binary "binary"
+            +     t.binary   "binary",                limit: 65535
                   t.datetime "submitted_at"
                   t.datetime "compiled_at"
-            -     t.text "compiler_message"
+            +     t.text     "compiler_message",      limit: 65535
                   t.datetime "graded_at"
-            -     t.integer "points"
+            +     t.integer  "points",                limit: 4
-            -     t.text "grader_comment"
+            +     t.text     "grader_comment",        limit: 65535
-            -     t.integer "number"
+            +     t.integer  "number",                limit: 4
-            -     t.string "source_filename"
+            +     t.string   "source_filename",       limit: 255
-            -     t.float "max_runtime"
+            +     t.float    "max_runtime",           limit: 24
-            -     t.integer "peak_memory"
+            +     t.integer  "peak_memory",           limit: 4
-            -     t.integer "effective_code_length"
+            +     t.integer  "effective_code_length", limit: 4
-            -     t.string "ip_address"
+            +     t.string   "ip_address",            limit: 255
-            -     t.index ["user_id", "problem_id", "number"], name: "index_submissions_on_user_id_and_problem_id_and_number", unique: true
-            -     t.index ["user_id", "problem_id"], name: "index_submissions_on_user_id_and_problem_id"
                 end
-            -   create_table "tags", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "submissions", ["user_id", "problem_id", "number"], name: "index_submissions_on_user_id_and_problem_id_and_number", unique: true, using: :btree
-            -     t.string "name", null: false
+            +   add_index "submissions", ["user_id", "problem_id"], name: "index_submissions_on_user_id_and_problem_id", using: :btree
-            -     t.text "description"
+            +   create_table "tags", force: :cascade do |t|
+            +     t.string   "name",        limit: 255,   null: false
+            +     t.text     "description", limit: 65535
                   t.boolean  "public"
                   t.datetime "created_at",                null: false
                   t.datetime "updated_at",                null: false
                 end
-            -   create_table "tasks", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "tasks", force: :cascade do |t|
-            -     t.integer "submission_id"
+            +     t.integer  "submission_id", limit: 4
                   t.datetime "created_at"
-            -     t.integer "status"
+            +     t.integer  "status",        limit: 4
                   t.datetime "updated_at"
-            -     t.index ["submission_id"], name: "index_tasks_on_submission_id"
                 end
-            -   create_table "test_pairs", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "tasks", ["submission_id"], name: "index_tasks_on_submission_id", using: :btree
-            -     t.integer "problem_id"
+            +   create_table "test_pairs", force: :cascade do |t|
+            +     t.integer  "problem_id", limit: 4
                   t.text     "input",      limit: 16777215
                   t.text     "solution",   limit: 16777215
                   t.datetime "created_at"
                   t.datetime "updated_at"
                 end
-            -   create_table "test_requests", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "test_requests", force: :cascade do |t|
-            -     t.integer "user_id"
+            +     t.integer  "user_id",          limit: 4
-            -     t.integer "problem_id"
+            +     t.integer  "problem_id",       limit: 4
-            -     t.integer "submission_id"
+            +     t.integer  "submission_id",    limit: 4
-            -     t.string "input_file_name"
+            +     t.string   "input_file_name",  limit: 255
-            -     t.string "output_file_name"
+            +     t.string   "output_file_name", limit: 255
-            -     t.string "running_stat"
+            +     t.string   "running_stat",     limit: 255
-            -     t.integer "status"
+            +     t.integer  "status",           limit: 4
                   t.datetime "updated_at"
                   t.datetime "submitted_at"
                   t.datetime "compiled_at"
-            -     t.text "compiler_message"
+            +     t.text     "compiler_message", limit: 65535
                   t.datetime "graded_at"
-            -     t.string "grader_comment"
+            +     t.string   "grader_comment",   limit: 255
                   t.datetime "created_at"
-            -     t.float "running_time"
+            +     t.float    "running_time",     limit: 24
-            -     t.string "exit_status"
+            +     t.string   "exit_status",      limit: 255
-            -     t.integer "memory_usage"
+            +     t.integer  "memory_usage",     limit: 4
-            -     t.index ["user_id", "problem_id"], name: "index_test_requests_on_user_id_and_problem_id"
                 end
-            -   create_table "testcases", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "test_requests", ["user_id", "problem_id"], name: "index_test_requests_on_user_id_and_problem_id", using: :btree
-            -     t.integer "problem_id"
-            -     t.integer "num"
+            +   create_table "testcases", force: :cascade do |t|
-            -     t.integer "group"
+            +     t.integer  "problem_id", limit: 4
-            -     t.integer "score"
+            +     t.integer  "num",        limit: 4
+            +     t.integer  "group",      limit: 4
+            +     t.integer  "score",      limit: 4
                   t.text     "input",      limit: 4294967295
                   t.text     "sol",        limit: 4294967295
                   t.datetime "created_at"
                   t.datetime "updated_at"
-            -     t.index ["problem_id"], name: "index_testcases_on_problem_id"
                 end
-            -   create_table "user_contest_stats", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   add_index "testcases", ["problem_id"], name: "index_testcases_on_problem_id", using: :btree
-            -     t.integer "user_id"
+            +   create_table "user_contest_stats", force: :cascade do |t|
+            +     t.integer  "user_id",       limit: 4
                   t.datetime "started_at"
                   t.datetime "created_at"
                   t.datetime "updated_at"
                   t.boolean  "forced_logout"
                 end
-            -   create_table "users", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "users", force: :cascade do |t|
                   t.string   "login",           limit: 50
-            -     t.string "full_name"
+            +     t.string   "full_name",       limit: 255
-            -     t.string "hashed_password"
+            +     t.string   "hashed_password", limit: 255
                   t.string   "salt",            limit: 5
-            -     t.string "alias"
+            +     t.string   "alias",           limit: 255
-            -     t.string "email"
+            +     t.string   "email",           limit: 255
-            -     t.integer "site_id"
+            +     t.integer  "site_id",         limit: 4
-            -     t.integer "country_id"
+            +     t.integer  "country_id",      limit: 4
                   t.boolean  "activated",                   default: false
                   t.datetime "created_at"
                   t.datetime "updated_at"
-            -     t.string "section"
+            +     t.string   "section",         limit: 255
                   t.boolean  "enabled",                     default: true
-            -     t.string "remark"
+            +     t.string   "remark",          limit: 255
-            -     t.string "last_ip"
+            +     t.string   "last_ip",         limit: 255
-            -     t.index ["login"], name: "index_users_on_login", unique: true
                 end
+            +   add_index "users", ["login"], name: "index_users_on_login", unique: true, using: :btree
+            +
                 add_foreign_key "problems_tags", "problems"
                 add_foreign_key "problems_tags", "tags"
               end

app/views/report/submission_stat.html.haml removed ¶ -37

deleted file

Write
Preview

You need to be logged in to leave comments. Login now

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository permissions settings

Sign in to your account

Author

r788:3241620ac7e7 - Sat, 04 Apr 2020 08:37:50 - 10 files changed: 425 inserted, 296 deleted

Sign in to your account

Commit r788:3241620ac7e7 public

Author

r788:3241620ac7e7 - Sat, 04 Apr 2020 08:37:50 - 10 files changed: 425 inserted, 296 deleted

Commit `r788:3241620ac7e7` public