public function listAll() { $toReturn = array(); $teachers = User::where('role', 'teacher')->get()->toArray(); $toReturn['dormitory'] = dormitories::get()->toArray(); $toReturn['subject'] = array(); $subjects = subject::get(); foreach ($subjects as $value) { $toReturn['subject'][$value->id] = $value->subjectTitle; } $toReturn['classes'] = array(); $classes = \DB::table('classes')->leftJoin('dormitories', 'dormitories.id', '=', 'classes.dormitoryId')->select('classes.id as id', 'classes.className as className', 'classes.classTeacher as classTeacher', 'classes.classSubjects as classSubjects', 'dormitories.id as dormitory', 'dormitories.dormitory as dormitoryName')->where('classAcademicYear', $this->panelInit->selectAcYear)->get(); $toReturn['teachers'] = array(); while (list($teacherKey, $teacherValue) = each($teachers)) { $toReturn['teachers'][$teacherValue['id']] = $teacherValue; } while (list($key, $class) = each($classes)) { $toReturn['classes'][$key] = $class; $toReturn['classes'][$key]->classSubjects = json_decode($toReturn['classes'][$key]->classSubjects); if ($toReturn['classes'][$key]->classTeacher != "") { $toReturn['classes'][$key]->classTeacher = json_decode($toReturn['classes'][$key]->classTeacher, true); if (is_array($toReturn['classes'][$key]->classTeacher)) { while (list($teacherKey, $teacherID) = each($toReturn['classes'][$key]->classTeacher)) { if (isset($toReturn['teachers'][$teacherID]['fullName'])) { $toReturn['classes'][$key]->classTeacher[$teacherKey] = $toReturn['teachers'][$teacherID]['fullName']; } else { unset($toReturn['classes'][$key]->classTeacher[$teacherKey]); } } $toReturn['classes'][$key]->classTeacher = implode($toReturn['classes'][$key]->classTeacher, ", "); } } } return $toReturn; }
function edit($id) { $dormitories = dormitories::find($id); $dormitories->dormitory = Input::get('dormitory'); $dormitories->dormDesc = Input::get('dormDesc'); $dormitories->save(); return $this->panelInit->apiOutput(true, $this->panelInit->language['editDorm'], $this->panelInit->language['dormUpdated'], $dormitories->toArray()); }