/** * Display a listing of the resource. * * @return Response */ public function index() { $user = \Auth::user(); $term = 'First Term'; if ($_GET['class']) { $this->class = $_GET['class']; $this->subject = $_GET['subject']; \Session::put('class', $_GET['class']); \Session::put('subject', $_GET['subject']); } $classe_id = Classe::where('name', $this->class)->first()->id; $subject_id = Subject::where('name', $this->subject)->first()->id; $count = 1; $questions = Question::where('classe_id', $classe_id)->where('subject_id', $subject_id)->get(); return view('admin.questions.index', compact('questions', 'count', 'subject_id', 'classe_id', 'term', 'user')); }
/** * Show the application welcome screen to the user. * * @return Response */ public function index() { $user = \Auth::user(); $id = $user->userId; $teacher = Teacher::where('teacherId', $id)->get(); $student = Student::where('studentId', '=', $id)->get(); $classe_id = ""; if ($user->type === 'Student') { $class = Classe::where('name', $student[0]->class)->get(); $classe_id = $class[0]->id; } //return $classe_id; $staff = Teacher::orderBy('lastname', 'asc')->get(['id', 'lastname', 'firstname', 'teacherId']); $classList = Classe::orderBy('name', 'asc')->lists('name', 'id'); $subjectList = Subject::orderBy('name', 'asc')->lists('name', 'id'); $assigned = []; $teacher = []; foreach (Teacher::lists('id') as $id) { $teacher = Teacher::findOrFail($id); foreach ($teacher->classes as $st) { $assignedClassId[] = $st->pivot->classe_id; } foreach ($teacher->subjects as $st) { $assignedSubjectId[] = $st->pivot->teacher_id; } $assignedClass = Classe::whereIn('id', $assignedClassId)->get(); //return Classe::findOrFail(1)->subjects; foreach ($assignedClass as $ass) { $subjects[] = Classe::findOrFail($ass->id)->subjects; } foreach ($subjects[0] as $cl) { $subject[] = $cl->get(['id', 'name']); } /*return $allSubject = Subject::all(); //where('classe_id', 1)->get(); return $assignedClass[0]->id;*/ } return view('profile', compact('user', 'student', 'class', 'assignedClass', 'subject', 'classe_id')); }