/** * Execute the console command. * * @return mixed */ public function handle() { // \Log::info('I was here @' . Carbon::now() ); $thisDate = Date::where('endDate', '<', Carbon::now())->orderby('endDate', 'DESC')->first(); $competitors = Competitor::where('created_at', '>', $thisDate->startDate)->where('created_at', '<', $thisDate->endDate)->where('is_deleted', '=', false)->get(); if (!count($thisDate->winner) && count($competitors)) { // var_dump($competitors); $winner = $competitors->first(); foreach ($competitors as $competitor) { var_dump($competitor->getTotalVotes()); echo '</br>'; if ($competitor->getTotalVotes() > $winner->getTotalVotes()) { $winner = $competitor; } } $newWinner = new Winner(); $newWinner->competitor_id = $winner->id; $newWinner->date_id = $thisDate->id; $newWinner->save(); } }
public function test() { $thisDate = Date::where('endDate', '<', Carbon::now())->orderby('endDate', 'DESC')->first(); $competitors = Competitor::where('created_at', '>', $thisDate->startDate)->where('created_at', '<', $thisDate->endDate)->get(); if (!count($thisDate->winner) && count($competitors)) { // var_dump($competitors); $winner = $competitors->first(); foreach ($competitors as $competitor) { var_dump($competitor->getTotalVotes()); echo '</br>'; if ($competitor->getTotalVotes() > $winner->getTotalVotes()) { $winner = $competitor; } } $newWinner = new Winner(); $newWinner->competitor_id = $winner->id; $newWinner->date_id = $thisDate->id; $newWinner->save(); } // $thisDate = Date::where('endDate', '<', Carbon::now())->orderby('endDate', 'DESC')->first(); // var_dump($thisDate); // echo '</br>'; // if (count($thisDate->winner)) // { // echo 'er is reeds een winnaar'; // } else // { // echo 'er is nog geen winnaar'; // } }
public function view($id) { $competitors = Competitor::where('instructor_id', $id)->get(); return view('register.competitor.view')->with('competitors', $competitors); }
public function entry_save(EntrySaveFormRequest $request, $id) { $competitiongroup = Competitiongroup::whereId($id)->firstOrFail(); foreach ($request->competitors as $selected_cat) { $result = new Result(); $result->competitor_id = $selected_cat; $result->competitiongroup_id = $id; $result->sex = $competitiongroup->sex; $result->age_group = $competitiongroup->age_group; $result->save(); $competitor = Competitor::where('id', '=', $selected_cat)->firstOrFail(); $competitor->in_competition = 1; $competitor->save(); } return redirect('/admin/competitiongroups/' . $id . '/entry')->with('status', 'Nevezés leadva'); }