cafe-grader-web Commit - r507:5af12f2a9a30

cafe-grader-web

Commit `r507:5af12f2a9a30` public

parent | child

Description:

add cheat detail

Commit status:

[Not Reviewed]

References:

algo

Diff options:

| | | |

Comments:

0 Commit comments 0 Inline Comments

Unresolved TODOs:

There are no unresolved TODOs

Add another comment

r507:5af12f2a9a30 - Thu, 07 May 2015 07:44:20 - 2 files changed: 52 inserted, 20 deleted

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

               class ReportController < ApplicationController
-            -   before_filter :admin_authorization, only: [:login_stat,:submission_stat, :stuck]
+            +   before_filter :admin_authorization, only: [:login_stat,:submission_stat, :stuck, :cheat_report, :cheat_scruntinize]
+            +
                 before_filter(only: [:problem_hof]) { |c|
                   return false unless authenticate
                   if GraderConfiguration["right.user_view_submission"]
                     return true;
                   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
+            +       @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.ago( 90.minutes)
+            +       @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
                           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])
-            - #  st =
+            +   end
-            - #      " INNER JOIN" +
-            - #      "(SELECT u.id,l.ip_address,COUNT(DISTINCT ip_address) as count " +
+            +   def cheat_scruntinize
-            - #      " FROM logins l INNER JOIN users u ON l.user_id = u.id "+
+            +     #convert date & time
-            - #      " WHERE l.created_at >= '#{@since_time.in_time_zone("UTC")}' and l.created_at <= '#{@until_time.in_time_zone("UTC")}' " +
+            +     date_and_time = '%Y-%m-%d %H:%M'
-            - #      " GROUP BY u.id" +
+            +     begin
-            - #      " HAVING count > 1) ml "
+            +       md = params[:since_datetime].match(/(\d+)-(\d+)-(\d+) (\d+):(\d+)/)
-            - #  #ml detail
+            +       @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)
-            - #  @mld = Login.joins(st + "ON logins.user_id = ml.id").
+            +     rescue
-            - #    where("logins.created_at >= ? and logins.created_at <= ?",@since_time,@until_time).
+            +       @since_time = Time.zone.now.ago( 90.minutes)
-            - #    order("ip_address")
+            +     end
-            - #
+            +     begin
-            - #  #submissions
+            +       md = params[:until_datetime].match(/(\d+)-(\d+)-(\d+) (\d+):(\d+)/)
-            - #  @subs =  Submission.joins(:problem).joins(st + "ON submissions.user_id = ml.id").
+            +       @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)
-            - #    where("submissions.submitted_at >= ? and submissions.submitted_at <= ?",@since_time,@until_time).
+            +     rescue
-            - #    order("submissions.ip_address")
+            +       @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
               end

app/views/report/_report_menu.html.haml ¶ +2 -1

               .task-menu
                 Reports
                 %br/
                 = link_to '[Hall of Fame]', :action => 'problem_hof'
                 = link_to '[Struggle]', :action => 'stuck'
-            -   = link_to '[Login]', :action => 'login_stat'
+            +   = link_to '[Cheat Detection]', :action => 'cheat_report'
+            +   = link_to '[Cheat Detail]', :action => 'cheat_scruntinize'
                 = link_to '[Multiple Login]', :action => 'multiple_login'

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

r507:5af12f2a9a30 - Thu, 07 May 2015 07:44:20 - 2 files changed: 52 inserted, 20 deleted

Sign in to your account

Commit r507:5af12f2a9a30 public

Author

r507:5af12f2a9a30 - Thu, 07 May 2015 07:44:20 - 2 files changed: 52 inserted, 20 deleted

Commit `r507:5af12f2a9a30` public