public function index()
{
// Find students without team assignments
$studentsWithoutTeams = \App\User::leftJoin('UserTeamAssociation', 'users.id', '=', 'UserTeamAssociation.userID')->where('UserTeamAssociation.userID', null)->leftJoin('UserRole', 'users.id', '=', 'UserRole.userID')->where('UserRole.role', 'student')->get()->pluck('name')->toArray();
// Load all students and teams
$teamIDs = \App\team::all()->pluck('id')->toArray();
$teamNames = \App\team::all()->pluck('teamName')->toArray();
$teamLanguages = \App\team::all()->pluck('language')->toArray();
$studentNames = \App\User::leftJoin('UserRole', 'users.id', '=', 'UserRole.userID')->where('UserRole.role', 'student')->get()->pluck('name')->toArray();
$studentIDs = \App\User::leftJoin('UserRole', 'users.id', '=', 'UserRole.userID')->where('UserRole.role', 'student')->get()->pluck('id')->toArray();
// Get info for each individual student
$studentInfo = array();
foreach ($teamIDs as $teamID) {
$tempStudentIDs = \App\User::leftJoin('UserTeamAssociation', 'users.id', '=', 'UserTeamAssociation.userID')->where('UserTeamAssociation.teamID', $teamID)->get()->pluck('id')->toArray();
array_push($studentInfo, "");
foreach ($tempStudentIDs as $studentID) {
$studentInfo[count($studentInfo) - 1] .= \App\User::where('id', $studentID)->get()->pluck('name')->toArray()[0];
$studentInfo[count($studentInfo) - 1] .= "<i><font color='#aaaaaa'> - ";
$studentInfo[count($studentInfo) - 1] .= \App\userPreferredTeamStyle::where('userID', $studentID)->get()->pluck('teamStyle')->toArray()[0];
$studentInfo[count($studentInfo) - 1] .= " - ";
$studentInfo[count($studentInfo) - 1] .= \App\userKnownLanguages::where('userID', $studentID)->get()->pluck('languageName')->toArray()[0];
$courseIDarray = \App\userCourseTaken::where('userID', $studentID)->get()->pluck('courseCode')->toArray();
foreach ($courseIDarray as $courseID) {
$studentInfo[count($studentInfo) - 1] .= " - ";
$studentInfo[count($studentInfo) - 1] .= $courseID;
}
$studentInfo[count($studentInfo) - 1] .= "</font></i><br>";
}
}
return view('teams/show')->with(['studentsWithoutTeams' => $studentsWithoutTeams, 'teamIDs' => $teamIDs, 'teamNames' => $teamNames, 'teamLanguages' => $teamLanguages, 'studentInfo' => $studentInfo, 'studentNames' => $studentNames, 'studentIDs' => $studentIDs]);
}
public function admin()
{
$teams = team::all()->get();
$teamnames = array();
foreach ($teams as $t) {
array_push($teamnames, $teams[0]->teamName);
}
return view('admin', compact('teamnames'));
}
public function admin()
{
$this->recalcTeamLanguages();
$teams = \App\team::all();
$members = DB::table('teams')->join('teamMembers', 'teams.id', '=', 'teamMembers.teamId')->join('users', 'teamMembers.studentId', '=', 'users.id')->select('teams.id', 'users.name', 'teamMembers.studentId')->get();
$leftovers = DB::table('teamMembers')->join('students', 'students.id', '=', 'teamMembers.studentId')->join('users', 'teamMembers.studentId', '=', 'users.id')->select('users.name', 'users.id', 'students.c', 'students.java', 'students.python')->where('teamMembers.teamId', '=', '0')->get();
return view('admin/teamInfo', compact('teams', 'members', 'leftovers'));
}
