public function rank($slot) { if (\App\Ranking::where('slot_code', '=', $slot->slot_code)->exists() == false) { $rank = new \App\Ranking(); $rank->slot_code = $slot->slot_code; $rank->user_id = $slot->user_id; $rank->save(); $rank->slot_rank = $rank->id; $rank->slot_exit = 0; $rank->save(); $tv1 = $rank->id; $tv2 = $rank->id * 2; $tv3 = $tv2 * 2; $tree = new \App\Tree(); $tree->down1 = $tv2; $tree->down2 = $tv2 + 1; $tree->down3 = $tv3; $tree->down4 = $tv3 + 1; $tree->down5 = $tv3 + 2; $tree->down6 = $tv3 + 3; $tree->save(); $rank->tree_id = $tree->id; $rank->save(); } }
/** * Store a newly created Cruiseline. * * @param Request $request * @param Cruiseline $brand * @return mixed */ public function store(CreateRank $request) { $rankings = Ranking::where('rankable_type', '=', 'App\\Brochure')->delete(); $rankable_type = $request->rankable_type; $count = count($request->rankable_id); for ($i = 0; $i < $count; $i++) { $ranking = Ranking::create(['rank' => $i + 1, 'rankable_type' => $rankable_type, 'rankable_id' => $request->rankable_id[$i]]); } return redirect('home/brochurerankings'); }
if (get_headers('http://www.r2sports.com/tourney/imageGallery/gallery/player/' . $player_id . '_normal.jpg')[0] != 'HTTP/1.1 404 Not Found') { $profile = 'http://www.r2sports.com/tourney/imageGallery/gallery/player/' . $player_id . '_normal.jpg'; } else { $profile = '/images/racquet-right.png'; } return $profile; }); Route::get('api/rankings/history', function () { $player_id = (int) Input::get('player_id'); $group_id = Input::get('group_id'); $location_id = (int) Input::get('location_id'); $location = Location::find($location_id); $player = Player::find($player_id); $rankings = Ranking::where('player_id', '=', $player_id)->select('ranking_date', 'location_id', 'ranking')->orderBy('ranking_date')->get(); /*National Ranking*/ $national = Ranking::where('player_id', '=', $player_id)->where('location_id', '=', 0)->select('ranking_date', 'ranking')->orderBy('ranking_date')->get(); $query = "\n\t\tSELECT \n\t\t\tdate_format(ranking_date, '%m/%d/%Y') as ranking_date,\n\t\t\tranking\n\t\tFROM\n\t\t\trankings\n\t\tWHERE\n\t\t\tplayer_id = {$player_id}\n\t\t\tAND location_id = 0\n\t\t\tAND group_id = {$group_id}\n\t\tORDER BY \n\t\t\tranking_date\n\t\t"; $national = \DB::select(DB::raw($query)); $arr_national = array(); foreach ($national as $key => $n) { $row = array(); $row['ranking_date'] = $n->ranking_date; $row['National'] = intval($n->ranking); array_push($arr_national, $row); } //dd($player); /*State Ranking*/ $query = "\n\t\tSELECT \n\t\t\tdate_format(ranking_date, '%m/%d/%Y') as ranking_date,\n\t\t\tranking\n\t\tFROM\n\t\t\trankings\n\t\tWHERE\n\t\t\tplayer_id = {$player_id}\n\t\t\tAND group_id = {$group_id}\n\t\t\tAND location_id = {$location_id}\n\t\tORDER BY \n\t\t\tranking_date\n\t\t"; $state = \DB::select(DB::raw($query)); $arr_state = array(); foreach ($state as $key => $n) {