Chronyms /
Qitsune
| @@ 22-31 (lines=10) @@ | ||
| 19 | return view('leader.ranking', ['rankArray' => $rankArray, 'userRank' => $userRank])->renderSections()['dynamicRanking']; |
|
| 20 | } |
|
| 21 | ||
| 22 | private function setRank() |
|
| 23 | { |
|
| 24 | $totalPoints = CodeCount::getTotalPoints(); |
|
| 25 | $rankObj = DB::select('SELECT * FROM users WHERE total_points = '.$totalPoints.' ORDER BY TIMEDIFF(start, end) DESC;'); |
|
| 26 | ||
| 27 | for($i = 0; $i < count($rankObj); $i++){ |
|
| 28 | DB::table('users')->where('name_gen', $rankObj[$i]->name_gen)->update(['rank' => (++$i)]); |
|
| 29 | $i--; |
|
| 30 | } |
|
| 31 | } |
|
| 32 | } |
|
| 33 | ||
| @@ 24-33 (lines=10) @@ | ||
| 21 | return view('leader.ranking', ['rankArray' => $rankArray, 'userRank' => $userRank]); |
|
| 22 | } |
|
| 23 | ||
| 24 | private function setRank() |
|
| 25 | { |
|
| 26 | $totalPoints = CodeCount::getTotalPoints(); |
|
| 27 | $rankObj = DB::select('SELECT * FROM users WHERE total_points = '.$totalPoints.' ORDER BY TIMEDIFF(start, end) DESC;'); |
|
| 28 | ||
| 29 | for($i = 0; $i < count($rankObj); $i++){ |
|
| 30 | DB::table('users')->where('name_gen', $rankObj[$i]->name_gen)->update(['rank' => (++$i)]); |
|
| 31 | $i--; |
|
| 32 | } |
|
| 33 | } |
|
| 34 | } |
|
| 35 | ||
