/**
* 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');
}
