diff --git a/app/controllers/report_controller.rb b/app/controllers/report_controller.rb --- a/app/controllers/report_controller.rb +++ b/app/controllers/report_controller.rb @@ -217,14 +217,37 @@ 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 - @multiple = [] + first = 0 + @users = [] raw.each do |r| if last != r.user.login count = 1 + last = r.user.login + first = r else - @multiple << r + @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