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