protected function teasubrel() { $class = $_GET['uid']; global $objPDO; $subject = array(); include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/subject_relations_class.php'; $sec = new SubjectRelations($objPDO); include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/subject_class.php'; include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/subject_class.php'; $subject_array = array(); $teacher_id = array(); $teacher = array(); $subject = $sec->getByClassId($class); for ($i = 0; $i < count($subject); $i++) { $subject_array[$subject[$i]] = Subject::getSubjectName($subject[$i]); if ($val = $this->getteasubrel($class, $subject[$i])) { $teacher_id[$subject[$i]] = $val; $teacher_profile = new Teacher($objPDO, $teacher_id[$subject[$i]]); $teacher[$teacher_id[$subject[$i]]] = $teacher_profile->getName($teacher_id[$subject[$i]]); } } include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/teacher_relation_template.php'; }
protected function newtime() { $class = $_GET['uid']; global $user; global $objPDO; $student = new student($objPDO, $user->getuserId()); $headMenu = array("username" => $student->getName()); if ($user->checkAdmin() == true) { include $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/timetable_settings_class.php'; $sett = new TimetableSettings($objPDO); $slots = $sett->getAllSlots(); if (!isset($slots)) { $num_slots = 0; } else { $num_slots = count($slots); } include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/subject_class.php'; include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/section_teacher_subject_class.php'; include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/timetable_class.php'; $rel = new SectionTeacherSubjectRelations($objPDO); $teasubrel = $rel->getByClass($class); $subjects = array(); for ($i = 0; $i < count($teasubrel); $i++) { $subjects[$teasubrel[$i]['subject_id']] = Subject::getSubjectName($teasubrel[$i]['subject_id']); } $tt = new Timetable($objPDO); $timetable = $tt->getBySection($class); include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/section_timetable.php'; } else { header('Location:http://localhost/cloud'); } }
public function searchBySubject($subject) { $subject_id = Subject::getSubjectNameLike($subject); $strQuery = "SELECT * FROM `" . $this->strTableName . "` WHERE `subject_id`='" . $subject_id . "' ;"; $objStatement = $this->objPDO->prepare($strQuery); $objStatement->execute(); $search_res = array(); while ($arRow = $objStatement->fetch(PDO::FETCH_ASSOC)) { $sub_name = Subject::getSubjectName($arRow['subject_id']); $arRow['subject_id'] = $sub_name; $search_res[] = $arRow; } return $search_res; }