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