public function moveStudent(Requests\MoveStudentRequest $request)
{
$requestArray = $request->all();
$preferredLanguage = \App\userKnownLanguages::where('userID', (int) $requestArray['students'])->get()->pluck('languageName')->toArray()[0];
// Place student in new team
$newTeamID = 0;
if ($requestArray['teams'] == "-1") {
$newTeam = \App\team::create(['teamName' => 'Untitled Team', 'language' => $preferredLanguage]);
$newTeamID = $newTeam->id;
} else {
$newTeamID = (int) $requestArray['teams'];
}
// Delete the student's old team if the team is empty
if (count(\App\userTeamAssociation::where('userID', (int) $requestArray['students'])->get()->toArray()) == 0) {
\App\userTeamAssociation::create(['userID' => (int) $requestArray['students'], 'teamID' => $newTeamID]);
} else {
\App\userTeamAssociation::where('userID', (int) $requestArray['students'])->update(['teamID' => $newTeamID]);
\App\team::leftJoin('UserTeamAssociation', 'Team.id', '=', 'UserTeamAssociation.teamID')->where('UserTeamAssociation.teamID', null)->delete();
}
return redirect('/teams');
}
