ZsgsDesign / NOJ

app/Models/ContestModel.php

Spacing +231 added lines, -231 removed lines

@@ -113,8 +113,8 @@ 
 
     public function gcode($cid)
     {
-        $gid = $this->gid($cid);
-        return DB::table('group')->where('gid','=',$gid)->first()["gcode"];
+        $gid=$this->gid($cid);
+        return DB::table('group')->where('gid', '=', $gid)->first()["gcode"];
     }
 
     public function runningContest()
@@ -139,19 +139,19 @@ 
 
     public function listForSetting($gid)
     {
-        $uid = Auth::user()->id;
-        $group_contests = DB::table('contest')
-            ->where('gid',$gid)
-            ->orderBy('begin_time','desc')
+        $uid=Auth::user()->id;
+        $group_contests=DB::table('contest')
+            ->where('gid', $gid)
+            ->orderBy('begin_time', 'desc')
             ->get()->all();
-        $groupModel = new GroupModel();
-        $group_clearance = $groupModel->judgeClearance($gid,$uid);
+        $groupModel=new GroupModel();
+        $group_clearance=$groupModel->judgeClearance($gid, $uid);
         foreach ($group_contests as &$contest) {
-            $contest['is_admin'] = ($contest['assign_uid'] == $uid || $group_clearance == 3);
-            $contest['begin_stamps'] = strtotime($contest['begin_time']);
-            $contest['end_stamps'] = strtotime($contest['end_time']);
-            $contest['status'] = time() >= $contest['end_stamps'] ? 1
-                : (time() <= $contest['begin_stamps'] ? -1 : 0);
+            $contest['is_admin']=($contest['assign_uid']==$uid || $group_clearance==3);
+            $contest['begin_stamps']=strtotime($contest['begin_time']);
+            $contest['end_stamps']=strtotime($contest['end_time']);
+            $contest['status']=time()>=$contest['end_stamps'] ? 1
+                : (time()<=$contest['begin_stamps'] ? -1 : 0);
             $contest["rule_parsed"]=$this->rule[$contest["rule"]];
             $contest["date_parsed"]=[
                 "date"=>date_format(date_create($contest["begin_time"]), 'j'),
@@ -159,11 +159,11 @@ 
             ];
             $contest["length"]=$this->calcLength($contest["begin_time"], $contest["end_time"]);
         }
-        usort($group_contests,function($a,$b){
-            if($a['is_admin'] == $b['is_admin']){
-                return $b['begin_stamps'] - $a['begin_stamps'];
+        usort($group_contests, function($a, $b) {
+            if ($a['is_admin']==$b['is_admin']) {
+                return $b['begin_stamps']-$a['begin_stamps'];
             }
-            return $b['is_admin'] - $a['is_admin'];
+            return $b['is_admin']-$a['is_admin'];
         });
         return $group_contests;
     }
@@ -174,9 +174,9 @@ 
         //     "gid"=>$gid
         // ])->orderBy('begin_time', 'desc')->get()->all();
         $preQuery=DB::table($this->tableName);
-        $paginator=$preQuery->where('gid','=',$gid)->orderBy('begin_time', 'desc')->paginate(10);
+        $paginator=$preQuery->where('gid', '=', $gid)->orderBy('begin_time', 'desc')->paginate(10);
         $contest_list=$paginator->all();
-        if(empty($contest_list)){
+        if (empty($contest_list)) {
             return null;
         }
 
@@ -201,7 +201,7 @@ 
         ])->first()["rule"];
     }
 
-    public function list($filter,$uid)
+    public function list($filter, $uid)
     {
         if ($uid) {
             //$paginator=DB::select('SELECT DISTINCT contest.* FROM group_member inner join contest on group_member.gid=contest.gid left join contest_participant on contest.cid=contest_participant.cid where (public=1 and audit=1) or (group_member.uid=:uid and group_member.role>0 and (contest_participant.uid=:uidd or ISNULL(contest_participant.uid)) and (registration=0 or (registration=1 and not ISNULL(contest_participant.uid))))',["uid"=>$uid,"uidd"=>$uid])->paginate(10);
@@ -225,15 +225,15 @@ 
                 if ($filter['practice']) {
                     $paginator=$paginator->where(["practice"=>$filter['practice']]);
                 }
-                $paginator = $paginator ->paginate(10);
-            }elseif($filter['public']=='0'){
+                $paginator=$paginator ->paginate(10);
+            }elseif ($filter['public']=='0') {
                 $paginator=DB::table('group_member')
                 ->groupBy('contest.cid')
                 ->select('contest.*')
                 ->join('contest', 'group_member.gid', '=', 'contest.gid')
                 ->leftJoin('contest_participant', 'contest.cid', '=', 'contest_participant.cid')
                 ->where(
-                    function ($query) use ($filter,$uid) {
+                    function($query) use ($filter, $uid) {
                         if ($filter['rule']) {
                             $query=$query->where(["rule"=>$filter['rule']]);
                         }
@@ -256,14 +256,14 @@ 
                 )
                 ->orderBy('contest.begin_time', 'desc')
                 ->paginate(10);
-            }else{
+            } else {
                 $paginator=DB::table('group_member')
                 ->groupBy('contest.cid')
                 ->select('contest.*')
                 ->join('contest', 'group_member.gid', '=', 'contest.gid')
                 ->leftJoin('contest_participant', 'contest.cid', '=', 'contest_participant.cid')
                 ->where(
-                    function ($query) use ($filter) {
+                    function($query) use ($filter) {
                         if ($filter['rule']) {
                             $query=$query->where(["rule"=>$filter['rule']]);
                         }
@@ -284,7 +284,7 @@ 
                     }
                 )
                 ->orWhere(
-                    function ($query) use ($filter,$uid) {
+                    function($query) use ($filter, $uid) {
                         if ($filter['rule']) {
                             $query=$query->where(["rule"=>$filter['rule']]);
                         }
@@ -330,7 +330,7 @@ 
             if ($filter['practice']) {
                 $paginator=$paginator->where(["practice"=>$filter['practice']]);
             }
-            $paginator = $paginator ->paginate(10);
+            $paginator=$paginator ->paginate(10);
         }
         $contest_list=$paginator->all();
         foreach ($contest_list as &$c) {
@@ -368,14 +368,14 @@ 
         }
     }
 
-    public function registContest($cid,$uid)
+    public function registContest($cid, $uid)
     {
         $registered=DB::table("contest_participant")->where([
             "cid"=>$cid,
             "uid"=>$uid
         ])->first();
 
-        if(empty($registered)){
+        if (empty($registered)) {
             DB::table("contest_participant")->insert([
                 "cid"=>$cid,
                 "uid"=>$uid,
@@ -383,7 +383,7 @@ 
             ]);
             $name=User::find($uid)->name;
             $contest=$this->basic($cid);
-            $url=route('contest.detail',['cid' => $cid]);
+            $url=route('contest.detail', ['cid' => $cid]);
             sendMessage([
                 'receiver' => $uid,
                 'sender' => 1, // potential bugs
@@ -417,9 +417,9 @@ 
     public function problems($cid)
     {
         return DB::table('contest_problem')
-            ->join('problem','contest_problem.pid','=','problem.pid')
-            ->where('cid',$cid)
-            ->select('problem.pid as pid','pcode','number')
+            ->join('problem', 'contest_problem.pid', '=', 'problem.pid')
+            ->where('cid', $cid)
+            ->select('problem.pid as pid', 'pcode', 'number')
             ->orderBy('number')
             ->get()->all();
     }
@@ -441,18 +441,18 @@ 
         $end_time=strtotime(DB::table("contest")->where(["cid"=>$cid])->select("end_time")->first()["end_time"]);
 
         foreach ($problemSet as &$p) {
-            if($p['practice']){
-                $tags = DB::table("group_problem_tag")
-                ->where('gid',$p['gid'])
-                ->where('pid',$p['pid'])
+            if ($p['practice']) {
+                $tags=DB::table("group_problem_tag")
+                ->where('gid', $p['gid'])
+                ->where('pid', $p['pid'])
                 ->get()->all();
-                $tags_arr = [];
-                if(!empty($tags)){
+                $tags_arr=[];
+                if (!empty($tags)) {
                     foreach ($tags as $value) {
-                        array_push($tags_arr,$value['tag']);
+                        array_push($tags_arr, $value['tag']);
                     }
                 }
-                $p['tags'] = $tags_arr;
+                $p['tags']=$tags_arr;
             }
             if ($contest_rule==1) {
                 $prob_stat=DB::table("submission")->select(
@@ -713,7 +713,7 @@ 
                     "problem_detail" => $prob_detail
                 ];
             }
-            usort($ret, function ($a, $b) {
+            usort($ret, function($a, $b) {
                 if ($a["score"]==$b["score"]) {
                     if ($a["penalty"]==$b["penalty"]) {
                         return 0;
@@ -760,7 +760,7 @@ 
                     "problem_detail" => $prob_detail
                 ];
             }
-            usort($ret, function ($a, $b) {
+            usort($ret, function($a, $b) {
                 if ($a["score"]==$b["score"]) {
                     if ($a["solved"]==$b["solved"]) {
                         return 0;
@@ -782,7 +782,7 @@ 
         return $ret;
     }
 
-    public function contestRank($cid, $uid = 0)
+    public function contestRank($cid, $uid=0)
     {
         // [ToDo] If the current user's in the organizer group show nick name
         // [ToDo] The participants determination
@@ -800,35 +800,35 @@ 
             "gid" => $contest_info["gid"]
         ])->where("role", ">", 0)->first());
 
-        $clearance = $this -> judgeClearance($cid, $uid);
+        $clearance=$this -> judgeClearance($cid, $uid);
 
         /** New Version With MySQL */
         $end_time=strtotime(DB::table("contest")->where(["cid"=>$cid])->select("end_time")->first()["end_time"]);
 
-        if(time() < $end_time){
-            if($clearance == 3){
+        if (time()<$end_time) {
+            if ($clearance==3) {
                 $contestRankRaw=Cache::tags(['contest', 'rank'])->get("contestAdmin$cid");
-            }else{
+            } else {
                 $contestRankRaw=Cache::tags(['contest', 'rank'])->get($cid);
             }
-            if(!isset($contestRankRaw)){
+            if (!isset($contestRankRaw)) {
                 $contestRankRaw=$this->contestRankCache($cid);
             }
-        }else{
-            if($clearance == 3){
+        } else {
+            if ($clearance==3) {
                 $contestRankRaw=Cache::tags(['contest', 'rank'])->get("contestAdmin$cid");
                 if (!isset($contestRankRaw)) {
                     $contestRankRaw=$this->getContestRankFromMySQL($cid);
-                    if(!isset($contestRankRaw)){
+                    if (!isset($contestRankRaw)) {
                         $contestRankRaw=$this->contestRankCache($cid);
                         $this->storeContestRankInMySQL($cid, $contestRankRaw);
                     }
                 }
-            }else{
+            } else {
                 $contestRankRaw=$this->getContestRankFromMySQL($cid);
-                if(!isset($contestRankRaw)){
+                if (!isset($contestRankRaw)) {
                     $contestRankRaw=Cache::tags(['contest', 'rank'])->get($cid);
-                    if(!isset($contestRankRaw)){
+                    if (!isset($contestRankRaw)) {
                         $contestRankRaw=$this->contestRankCache($cid);
                     }
                     $this->storeContestRankInMySQL($cid, $contestRankRaw);
@@ -846,15 +846,15 @@ 
         //         $contestRankRaw=$this->contestRankCache($cid);
         //     }
         // }
-        if($contest_info["rule"]==1){
+        if ($contest_info["rule"]==1) {
             foreach ($contestRankRaw as &$cr) {
-                $solved = 0;
-                foreach($cr['problem_detail'] as $pd){
-                    if(!empty($pd['solved_time_parsed'])){
-                        $solved ++;
+                $solved=0;
+                foreach ($cr['problem_detail'] as $pd) {
+                    if (!empty($pd['solved_time_parsed'])) {
+                        $solved++;
                     }
                 }
-                $cr['solved'] = $solved;
+                $cr['solved']=$solved;
             }
         }
 
@@ -903,16 +903,16 @@ 
 
     public function getClarificationList($cid)
     {
-        $uid = Auth::user()->id;
-        $clearance = $this -> judgeClearance($cid, $uid);
-        if($clearance == 3){
+        $uid=Auth::user()->id;
+        $clearance=$this -> judgeClearance($cid, $uid);
+        if ($clearance==3) {
             return DB::table("contest_clarification")->where([
                 "cid"=>$cid
             ])->orderBy('create_time', 'desc')->get()->all();
-        }else{
+        } else {
             return DB::table("contest_clarification")->where([
                 "cid"=>$cid
-            ])->where(function ($query) {
+            ])->where(function($query) {
                 $query->where([
                     "public"=>1
                 ])->orWhere([
@@ -1058,7 +1058,7 @@ 
     public function getContestRecord($filter, $cid)
     {
         $basicInfo=$this->basic($cid);
-        $userInfo=DB::table('group_member')->where('gid',$basicInfo["gid"])->where('uid',Auth::user()->id)->get()->first();
+        $userInfo=DB::table('group_member')->where('gid', $basicInfo["gid"])->where('uid', Auth::user()->id)->get()->first();
         $problemSet_temp=DB::table("contest_problem")->join("problem", "contest_problem.pid", "=", "problem.pid")->where([
             "cid"=>$cid
         ])->orderBy('ncode', 'asc')->select("ncode", "alias", "contest_problem.pid as pid", "title", "points", "tot_score")->get()->all();
@@ -1071,14 +1071,14 @@ 
         $end_time=strtotime(DB::table("contest")->where(["cid"=>$cid])->select("end_time")->first()["end_time"]);
         $contestEnd=time()>$end_time;
 
-        $filter['pid'] = array_search($filter['ncode'], array_column($problemSet_temp, 'ncode'));
-        if($filter['pid']==false){
-            $filter['pid'] = null;
-        }else{
-            $filter['pid'] = $problemSet_temp[$filter['pid']]['pid'];
+        $filter['pid']=array_search($filter['ncode'], array_column($problemSet_temp, 'ncode'));
+        if ($filter['pid']==false) {
+            $filter['pid']=null;
+        } else {
+            $filter['pid']=$problemSet_temp[$filter['pid']]['pid'];
         }
 
-        if($userInfo==null || $userInfo["role"]!=3){
+        if ($userInfo==null || $userInfo["role"]!=3) {
             if ($basicInfo["status_visibility"]==2) {
                 // View all
                 $paginator=DB::table("submission")->where([
@@ -1092,7 +1092,7 @@ 
                     "users.id",
                     "=",
                     "submission.uid"
-                )->where(function ($query) use ($frozen_time) {
+                )->where(function($query) use ($frozen_time) {
                     $query->where(
                         "submission_date",
                         "<",
@@ -1119,15 +1119,15 @@ 
                     'desc'
                 );
 
-                if($filter["pid"]){
+                if ($filter["pid"]) {
                     $paginator=$paginator->where(["pid"=>$filter["pid"]]);
                 }
 
-                if($filter["result"]){
+                if ($filter["result"]) {
                     $paginator=$paginator->where(["verdict"=>$filter["result"]]);
                 }
 
-                if($filter["account"]){
+                if ($filter["account"]) {
                     $paginator=$paginator->where(["name"=>$filter["account"]]);
                 }
 
@@ -1163,15 +1163,15 @@ 
                     'desc'
                 );
 
-                if($filter["pid"]){
+                if ($filter["pid"]) {
                     $paginator=$paginator->where(["pid"=>$filter["pid"]]);
                 }
 
-                if($filter["result"]){
+                if ($filter["result"]) {
                     $paginator=$paginator->where(["verdict"=>$filter["result"]]);
                 }
 
-                if($filter["account"]){
+                if ($filter["account"]) {
                     $paginator=$paginator->where(["name"=>$filter["account"]]);
                 }
 
@@ -1182,7 +1182,7 @@ 
                     "records"=>[]
                 ];
             }
-        }else{
+        } else {
             if ($basicInfo["status_visibility"]==2) {
                 // View all
                 $paginator=DB::table("submission")->where([
@@ -1214,15 +1214,15 @@ 
                     'desc'
                 );
 
-                if($filter["pid"]){
+                if ($filter["pid"]) {
                     $paginator=$paginator->where(["pid"=>$filter["pid"]]);
                 }
 
-                if($filter["result"]){
+                if ($filter["result"]) {
                     $paginator=$paginator->where(["verdict"=>$filter["result"]]);
                 }
 
-                if($filter["account"]){
+                if ($filter["account"]) {
                     $paginator=$paginator->where(["name"=>$filter["account"]]);
                 }
 
@@ -1258,15 +1258,15 @@ 
                     'desc'
                 );
 
-                if($filter["pid"]){
+                if ($filter["pid"]) {
                     $paginator=$paginator->where(["pid"=>$filter["pid"]]);
                 }
 
-                if($filter["result"]){
+                if ($filter["result"]) {
                     $paginator=$paginator->where(["verdict"=>$filter["result"]]);
                 }
 
-                if($filter["account"]){
+                if ($filter["account"]) {
                     $paginator=$paginator->where(["name"=>$filter["account"]]);
                 }
 
@@ -1322,21 +1322,21 @@ 
         if ($uid==0) {
             return 0;
         }
-        $groupModel = new GroupModel();
+        $groupModel=new GroupModel();
         $contest_info=DB::table("contest")->where("cid", $cid)->first();
-        $userInfo=DB::table('group_member')->where('gid',$contest_info["gid"])->where('uid',$uid)->get()->first();
+        $userInfo=DB::table('group_member')->where('gid', $contest_info["gid"])->where('uid', $uid)->get()->first();
 
-        if(empty($contest_info)){
+        if (empty($contest_info)) {
             // contest not exist
             return 0;
         }
 
-        if($uid == $contest_info['assign_uid'] || $groupModel->judgeClearance($contest_info['gid'],$uid) == 3){
+        if ($uid==$contest_info['assign_uid'] || $groupModel->judgeClearance($contest_info['gid'], $uid)==3) {
             return 3;
         }
 
-        $contest_started = strtotime($contest_info['begin_time']) < time();
-        $contest_ended = strtotime($contest_info['end_time']) < time();
+        $contest_started=strtotime($contest_info['begin_time'])<time();
+        $contest_ended=strtotime($contest_info['end_time'])<time();
         if (!$contest_started) {
             // not started or do not exist
             return 0;
@@ -1427,12 +1427,12 @@ 
     public function updateProfessionalRate($cid)
     {
         $basic=$this->basic($cid);
-        if($basic["rated"]&&!$basic["is_rated"]){
+        if ($basic["rated"] && !$basic["is_rated"]) {
             $ratingCalculator=new RatingCalculator($cid);
-            if($ratingCalculator->calculate()){
+            if ($ratingCalculator->calculate()) {
                 $ratingCalculator->storage();
                 return true;
-            }else{
+            } else {
                 return false;
             }
         } else {
@@ -1440,26 +1440,26 @@ 
         }
     }
 
-    public function contestUpdate($cid,$data,$problems)
+    public function contestUpdate($cid, $data, $problems)
     {
-        if($problems !== false){
-            $old_problmes = array_column(
+        if ($problems!==false) {
+            $old_problmes=array_column(
                 DB::table('contest_problem')
-                ->where('cid',$cid)
+                ->where('cid', $cid)
                 ->get()->all(),
                 'pid'
             );
-            DB::transaction(function () use ($cid, $data, $problems,$old_problmes) {
+            DB::transaction(function() use ($cid, $data, $problems, $old_problmes) {
                 DB::table($this->tableName)
-                    ->where('cid',$cid)
+                    ->where('cid', $cid)
                     ->update($data);
                 DB::table('contest_problem')
-                    ->where('cid',$cid)
+                    ->where('cid', $cid)
                     ->delete();
-                $new_problems = [];
+                $new_problems=[];
                 foreach ($problems as $p) {
                     $pid=DB::table("problem")->where(["pcode"=>$p["pcode"]])->select("pid")->first()["pid"];
-                    array_push($new_problems,$pid);
+                    array_push($new_problems, $pid);
                     DB::table("contest_problem")->insert([
                         "cid"=>$cid,
                         "number"=>$p["number"],
@@ -1469,29 +1469,29 @@ 
                         "points"=>$p["points"]
                     ]);
                 }
-                foreach($old_problmes as $op) {
-                    if(!in_array($op,$new_problems)){
+                foreach ($old_problmes as $op) {
+                    if (!in_array($op, $new_problems)) {
                         DB::table('submission')
-                            ->where('cid',$cid)
-                            ->where('pid',$op)
+                            ->where('cid', $cid)
+                            ->where('pid', $op)
                             ->delete();
                     }
                 }
             }, 5);
-            $contestRankRaw = $this->contestRankCache($cid);
+            $contestRankRaw=$this->contestRankCache($cid);
             Cache::tags(['contest', 'rank'])->put($cid, $contestRankRaw);
             Cache::tags(['contest', 'rank'])->put("contestAdmin$cid", $contestRankRaw);
-        }else{
+        } else {
             DB::table($this->tableName)
-                ->where('cid',$cid)
+                ->where('cid', $cid)
                 ->update($data);
         }
     }
 
-    public function contestUpdateProblem($cid,$problems)
+    public function contestUpdateProblem($cid, $problems)
     {
         DB::table('contest_problem')
-                ->where('cid',$cid)
+                ->where('cid', $cid)
                 ->delete();
         foreach ($problems as $p) {
             DB::table("contest_problem")->insertGetId([
@@ -1507,8 +1507,8 @@ 
 
     public function arrangeContest($gid, $config, $problems)
     {
-        $cid = -1;
-        DB::transaction(function () use ($gid, $config, $problems,&$cid) {
+        $cid=-1;
+        DB::transaction(function() use ($gid, $config, $problems, &$cid) {
             $cid=DB::table($this->tableName)->insertGetId([
                 "gid"=>$gid,
                 "name"=>$config["name"],
@@ -1522,7 +1522,7 @@ 
                 "rule"=>1, //todo
                 "begin_time"=>$config["begin_time"],
                 "end_time"=>$config["end_time"],
-                "vcid"=>isset($config["vcid"])?$config["vcid"]:null,
+                "vcid"=>isset($config["vcid"]) ? $config["vcid"] : null,
                 "public"=>$config["public"],
                 "registration"=>0, //todo
                 "registration_due"=>null, //todo
@@ -1530,7 +1530,7 @@ 
                 "froze_length"=>0, //todo
                 "status_visibility"=>2, //todo
                 "create_time"=>date("Y-m-d H:i:s"),
-                "crawled" => isset($config['vcid'])?$config['crawled'] : null,
+                "crawled" => isset($config['vcid']) ? $config['crawled'] : null,
                 "audit_status"=>$config["public"] ? 0 : 1
             ]);
 
@@ -1549,13 +1549,13 @@ 
         return $cid;
     }
 
-    public function updateContestRankTable($cid,$sub)
+    public function updateContestRankTable($cid, $sub)
     {
-        $lock = Cache::lock("contestrank$cid",10);
-        try{
-            if($lock->get()){
-                if(Cache::tags(['contest','rank'])->get($cid) != null){
-                    $ret = Cache::tags(['contest','rank'])->get($cid);
+        $lock=Cache::lock("contestrank$cid", 10);
+        try {
+            if ($lock->get()) {
+                if (Cache::tags(['contest', 'rank'])->get($cid)!=null) {
+                    $ret=Cache::tags(['contest', 'rank'])->get($cid);
                     $chache=[];
                     $chache['contest_info']=DB::table("contest")->where("cid", $cid)->first();
                     $chache['problemSet']=DB::table("contest_problem")->join("problem", "contest_problem.pid", "=", "problem.pid")->where([
@@ -1564,27 +1564,27 @@ 
                     $chache['frozen_time']=DB::table("contest")->where(["cid"=>$cid])->select(DB::raw("UNIX_TIMESTAMP(end_time)-froze_length as frozen_time"))->first()["frozen_time"];
                     $chache['end_time']=strtotime(DB::table("contest")->where(["cid"=>$cid])->select("end_time")->first()["end_time"]);
 
-                    $id = 0;
+                    $id=0;
 
-                    foreach($chache['problemSet'] as $key => $p){
-                        if ($p['pid'] == $sub['pid']){
-                            $chache['problemSet'][$key]['cpid'] = $key;
-                            $id = $key;
+                    foreach ($chache['problemSet'] as $key => $p) {
+                        if ($p['pid']==$sub['pid']) {
+                            $chache['problemSet'][$key]['cpid']=$key;
+                            $id=$key;
                         }
                     }
 
-                    $ret = $this->updateContestRankDetail($chache['contest_info'],$chache['problemSet'][$id],$cid,$sub['uid'],$ret);
-                    $ret = $this->sortContestRankTable($chache['contest_info'],$cid,$ret);
+                    $ret=$this->updateContestRankDetail($chache['contest_info'], $chache['problemSet'][$id], $cid, $sub['uid'], $ret);
+                    $ret=$this->sortContestRankTable($chache['contest_info'], $cid, $ret);
 
-                    if (time() < $chache['frozen_time']){
+                    if (time()<$chache['frozen_time']) {
                         Cache::tags(['contest', 'rank'])->put($cid, $ret);
                     }
                     Cache::tags(['contest', 'rank'])->put("contestAdmin$cid", $ret);
-                    if(time() > $chache['end_time']){
+                    if (time()>$chache['end_time']) {
                         $this->storeContestRankInMySQL($cid, $ret);
                     }
                 }
-                else{
+                else {
                     $ret=[];
                     $chache=[];
                     $chache['contest_info']=DB::table("contest")->where("cid", $cid)->first();
@@ -1599,7 +1599,7 @@ 
                             "cid"=>$cid,
                             "audit"=>1
                         ])->select('uid')->get()->all();
-                    }else{
+                    } else {
                         $submissionUsers=DB::table("submission")->where([
                             "cid"=>$cid
                         ])->where(
@@ -1612,39 +1612,39 @@ 
                         ])->select('uid')->groupBy('uid')->get()->all();
                     }
 
-                    $chacheAdmin = $chache;
+                    $chacheAdmin=$chache;
 
                     foreach ($submissionUsers as $s) {
                         foreach ($chache['problemSet'] as $key => $p) {
-                            $p['cpid'] = $key;
-                            $ret = $this->updateContestRankDetail($chache['contest_info'],$p,$cid,$s['uid'],$ret);
+                            $p['cpid']=$key;
+                            $ret=$this->updateContestRankDetail($chache['contest_info'], $p, $cid, $s['uid'], $ret);
                         }
                     }
-                    $ret = $this->sortContestRankTable($chache['contest_info'],$cid,$ret);
+                    $ret=$this->sortContestRankTable($chache['contest_info'], $cid, $ret);
                     Cache::tags(['contest', 'rank'])->put($cid, $ret);
 
                     $retAdmin=[];
                     foreach ($submissionUsersAdmin as $s) {
                         foreach ($chacheAdmin['problemSet'] as $key => $p) {
-                            $p['cpid'] = $key;
-                            $retAdmin = $this->updateContestRankDetail($chacheAdmin['contest_info'],$p,$cid,$s['uid'],$retAdmin);
+                            $p['cpid']=$key;
+                            $retAdmin=$this->updateContestRankDetail($chacheAdmin['contest_info'], $p, $cid, $s['uid'], $retAdmin);
                         }
                     }
-                    $retAdmin = $this->sortContestRankTable($chacheAdmin['contest_info'],$cid,$retAdmin);
+                    $retAdmin=$this->sortContestRankTable($chacheAdmin['contest_info'], $cid, $retAdmin);
                     Cache::tags(['contest', 'rank'])->put("contestAdmin$cid", $retAdmin);
                 }
             }
-        }catch(LockTimeoutException $e){
+        } catch (LockTimeoutException $e) {
             Log::warning("Contest Rank Lock Timed Out");
-        }finally{
+        } finally {
             optional($lock)->release();
         }
     }
 
-    public function sortContestRankTable($contest_info,$cid,$ret)
+    public function sortContestRankTable($contest_info, $cid, $ret)
     {
-        if ($contest_info["rule"]==1){
-            usort($ret, function ($a, $b) {
+        if ($contest_info["rule"]==1) {
+            usort($ret, function($a, $b) {
                 if ($a["score"]==$b["score"]) {
                     if ($a["penalty"]==$b["penalty"]) {
                         return 0;
@@ -1659,8 +1659,8 @@ 
                     return 1;
                 }
             });
-        }else if ($contest_info["rule"]==2){
-            usort($ret, function ($a, $b) {
+        } else if ($contest_info["rule"]==2) {
+            usort($ret, function($a, $b) {
                 if ($a["score"]==$b["score"]) {
                     if ($a["solved"]==$b["solved"]) {
                         return 0;
@@ -1679,21 +1679,21 @@ 
         return $ret;
     }
 
-    public function updateContestRankDetail($contest_info,$problem,$cid,$uid,$ret)
+    public function updateContestRankDetail($contest_info, $problem, $cid, $uid, $ret)
     {
-        $id = count($ret);
-        foreach($ret as $key => $r){
-            if($r['uid'] == $uid)
-                $id = $key;
+        $id=count($ret);
+        foreach ($ret as $key => $r) {
+            if ($r['uid']==$uid)
+                $id=$key;
         }
         if ($contest_info["rule"]==1) {
             // ACM/ICPC Mode
-            if($id == count($ret)){
-                $prob_detail = [];
-                $totPen = 0;
-                $totScore = 0;
-            }else{
-                $prob_detail = $ret[$id]['problem_detail'];
+            if ($id==count($ret)) {
+                $prob_detail=[];
+                $totPen=0;
+                $totScore=0;
+            } else {
+                $prob_detail=$ret[$id]['problem_detail'];
                 $totPen=$ret[$id]['penalty'];
                 $totScore=$ret[$id]['score'];
             };
@@ -1711,7 +1711,7 @@ 
                 "uid"=>$uid,
             ])->orderBy('submission_date', 'desc')->first();
 
-            if ($ac_times<=1 && isset($last_record) && $last_record['verdict']!="Waiting" && $last_record['verdict']!="Submission Error" && $last_record['verdict']!="System Error"){
+            if ($ac_times<=1 && isset($last_record) && $last_record['verdict']!="Waiting" && $last_record['verdict']!="Submission Error" && $last_record['verdict']!="System Error") {
                 $prob_stat=$this->contestProblemInfoACM($cid, $problem["pid"], $uid);
 
                 $prob_detail[$problem['cpid']]=[
@@ -1743,12 +1743,12 @@ 
             }
         } elseif ($contest_info["rule"]==2) {
             // IOI Mode
-            if($id == count($ret)){
-                $prob_detail = [];
-                $totSolved = 0;
-                $totScore = 0;
-            }else{
-                $prob_detail = $ret[$id]['problem_detail'];
+            if ($id==count($ret)) {
+                $prob_detail=[];
+                $totSolved=0;
+                $totScore=0;
+            } else {
+                $prob_detail=$ret[$id]['problem_detail'];
                 $totSolved=$ret[$id]['solved'];
                 $totScore=$ret[$id]['score'];
             };
@@ -1781,47 +1781,47 @@ 
         return $ret;
     }
 
-    public function assignMember($cid,$uid){
+    public function assignMember($cid, $uid) {
         return DB::table("contest")->where(["cid"=>$cid])->update([
             "assign_uid"=>$uid
         ]);
     }
 
-    public function canUpdateContestTime($cid,$time = [])
+    public function canUpdateContestTime($cid, $time=[])
     {
-        $begin_time_new = $time['begin'] ?? null;
-        $end_time_new = $time['end'] ?? null;
+        $begin_time_new=$time['begin'] ?? null;
+        $end_time_new=$time['end'] ?? null;
 
-        $hold_time = DB::table('contest')
-            ->where('cid',$cid)
-            ->select('begin_time','end_time')
+        $hold_time=DB::table('contest')
+            ->where('cid', $cid)
+            ->select('begin_time', 'end_time')
             ->first();
-        $begin_stamps = strtotime($hold_time['begin_time']);
-        $end_stamps = strtotime($hold_time['end_time']);
+        $begin_stamps=strtotime($hold_time['begin_time']);
+        $end_stamps=strtotime($hold_time['end_time']);
         /*
         -1 : have not begun
          0 : ing
          1 : end
         */
-        $status = time() >= $end_stamps ? 1
-                : (time() <= $begin_stamps ? -1 : 0);
-        if($status === -1){
-            if(time() > $begin_time_new){
+        $status=time()>=$end_stamps ? 1
+                : (time()<=$begin_stamps ? -1 : 0);
+        if ($status===-1) {
+            if (time()>$begin_time_new) {
                 return false;
             }
             return true;
-        }else if($status === 0){
-            if($begin_time_new !== null){
+        } else if ($status===0) {
+            if ($begin_time_new!==null) {
                 return false;
             }
-            if($end_time_new !== null){
-                if(strtotime($end_time_new) <= time()){
+            if ($end_time_new!==null) {
+                if (strtotime($end_time_new)<=time()) {
                     return false;
-                }else{
+                } else {
                     return true;
                 }
             }
-        }else{
+        } else {
             return false;
         }
 
@@ -1830,22 +1830,22 @@ 
 
     public function replyClarification($ccid, $content)
     {
-        return DB::table("contest_clarification")->where('ccid','=',$ccid)->update([
+        return DB::table("contest_clarification")->where('ccid', '=', $ccid)->update([
             "reply"=>$content
         ]);
     }
 
     public function setClarificationPublic($ccid, $public)
     {
-        if($public)
+        if ($public)
         {
-            return DB::table("contest_clarification")->where('ccid','=',$ccid)->update([
+            return DB::table("contest_clarification")->where('ccid', '=', $ccid)->update([
                 "public"=>1
             ]);
         }
         else
         {
-            return DB::table("contest_clarification")->where('ccid','=',$ccid)->update([
+            return DB::table("contest_clarification")->where('ccid', '=', $ccid)->update([
                 "public"=>0
             ]);
         }
@@ -1858,90 +1858,90 @@ 
 
     public function praticeAnalysis($cid)
     {
-        $gid = DB::table('contest')
-            ->where('cid',$cid)
+        $gid=DB::table('contest')
+            ->where('cid', $cid)
             ->first()['gid'];
-        $contestRank = $this->contestRank($cid,Auth::user()->id);
-        if(!empty($contestRank)){
-            $all_problems = DB::table('problem')
-            ->whereIn('pid',array_column($contestRank[0]['problem_detail'],'pid'))
-            ->select('pid','title')
+        $contestRank=$this->contestRank($cid, Auth::user()->id);
+        if (!empty($contestRank)) {
+            $all_problems=DB::table('problem')
+            ->whereIn('pid', array_column($contestRank[0]['problem_detail'], 'pid'))
+            ->select('pid', 'title')
             ->get()->all();
-        }else{
-            $all_problems = [];
+        } else {
+            $all_problems=[];
         }
-        $tags = DB::table('group_problem_tag')
+        $tags=DB::table('group_problem_tag')
             ->where('gid', $gid)
-            ->whereIn('pid', array_column($all_problems,'pid'))
+            ->whereIn('pid', array_column($all_problems, 'pid'))
             ->get()->all();
-        $all_tags = array_unique(array_column($tags,'tag'));
-        $memberData = [];
-        foreach($contestRank as $member){
-            $m = [
+        $all_tags=array_unique(array_column($tags, 'tag'));
+        $memberData=[];
+        foreach ($contestRank as $member) {
+            $m=[
                 'uid' => $member['uid'],
                 'name' => $member['name'],
                 'nick_name' => $member['nick_name'],
             ];
-            $completion = [];
-            foreach ($all_tags as $tag){
-                $completion[$tag] = [];
+            $completion=[];
+            foreach ($all_tags as $tag) {
+                $completion[$tag]=[];
                 foreach ($tags as $t) {
-                    if($t['tag'] == $tag){
+                    if ($t['tag']==$tag) {
                         foreach ($member['problem_detail'] as $pd) {
-                            if($pd['pid'] == $t['pid']){
-                                $completion[$tag][$t['pid']] = $pd['solved_time_parsed'] == "" ? 0 : 1;
+                            if ($pd['pid']==$t['pid']) {
+                                $completion[$tag][$t['pid']]=$pd['solved_time_parsed']=="" ? 0 : 1;
                             }
                         }
                     }
                 }
             }
-            $m['completion'] = $completion;
-            $memberData[] = $m;
+            $m['completion']=$completion;
+            $memberData[]=$m;
         }
         return $memberData;
     }
 
     public function storeContestRankInMySQL($cid, $data)
     {
-        $contestRankJson = json_encode($data);
-        return DB::table('contest')->where('cid','=',$cid)->update([
+        $contestRankJson=json_encode($data);
+        return DB::table('contest')->where('cid', '=', $cid)->update([
             'rank' => $contestRankJson
         ]);
     }
 
     public function getContestRankFromMySQL($cid)
     {
-        $contestRankJson = DB::table('contest')->where('cid','=',$cid)->pluck('rank')->first();
-        $data = json_decode($contestRankJson, true);
+        $contestRankJson=DB::table('contest')->where('cid', '=', $cid)->pluck('rank')->first();
+        $data=json_decode($contestRankJson, true);
         return $data;
     }
 
     public function isVerified($cid)
     {
-        return DB::table('contest')->where('cid','=',$cid)->pluck('verified')->first();
+        return DB::table('contest')->where('cid', '=', $cid)->pluck('verified')->first();
     }
 
     public function getScrollBoardData($cid)
     {
-        $members = DB::table("submission")
-            ->join('users','users.id','=','submission.uid')
+        $members=DB::table("submission")
+            ->join('users', 'users.id', '=', 'submission.uid')
             ->join('contest', 'contest.cid', '=', 'submission.cid')
             ->join('group_member', 'users.id', '=', 'group_member.uid')
-            ->where('submission.cid', $cid)->select('users.id as uid','users.name as name','group_member.nick_name as nick_name')
+            ->where('submission.cid', $cid)->select('users.id as uid', 'users.name as name', 'group_member.nick_name as nick_name')
             ->groupBy('uid')->get()->all();
-        $submissions = DB::table("submission")
+        $submissions=DB::table("submission")
             ->where('cid', $cid)
             ->select('sid', 'verdict', 'submission_date', 'pid', 'uid')
             ->orderBy('submission_date')
             ->get()->all();
-        $problems = DB::table('contest_problem')
+        $problems=DB::table('contest_problem')
             ->where('cid', $cid)
-            ->select('ncode','pid')
+            ->select('ncode', 'pid')
             ->orderBy('ncode')
             ->get()->all();
-        $contest = DB::table('contest')
-            ->where('cid',$cid)
-            ->select('begin_time','end_time','froze_length')
+        $contest=DB::table('contest')
+            ->where('cid', $cid)
+            ->select('begin_time', 'end_time', 'froze_length')
             ->first();
         return [
             'members' => $members,
@@ -1953,16 +1953,16 @@ 
 
     public function judgeOver($cid)
     {
-        $submissions =  DB::table('submission')
+        $submissions=DB::table('submission')
             ->where(['cid' => $cid])
-            ->whereIn('verdict',['Waiting','Pending'])
+            ->whereIn('verdict', ['Waiting', 'Pending'])
             ->select('sid')
             ->get()->all();
-        if(empty($submissions)){
+        if (empty($submissions)) {
             return [
                 'result' => true
             ];
-        }else{
+        } else {
             return [
                 'result' => false,
                 'sid' => $submissions