public function getList($studend) { // interrogazione della tabella $sql = "SELECT * FROM esami WHERE id_studente='{$studend->id}'"; $auth = $this->connector->query($sql); $list = array(); if (mysql_num_rows($auth) > 0) { while ($res = $this->connector->getObjectResult($auth)) { $exam = new Exam(get_object_vars($res)); //Calcolo le informazioni di servizio $plan = new Plan(); $plan->setConnector($this->connector); $student_plan = $plan->getById($studend->id_plan); foreach ($student_plan->subjects as $subj) { if ($exam->id_subject == $subj->subject_id) { $exam->year = $subj->year; break; } } $subject = new Subject(); $subject->setConnector($this->connector); $exam->subject_name = $subject->getById($exam->id_subject)->name; $list[] = $exam; } } return $list; }
public function getListForStudent($student, $order = "data_esame") { $order = trim(filter_var($order, FILTER_SANITIZE_STRING)); //interrogazione tabella $sql = "select * from appelli where id_piano = '{$student->id_plan}' and id_appello not in (select id_appello from prenotazioni where id_studente = '{$student->id}') ORDER BY {$order}"; $auth = $this->connector->query($sql); $list = array(); // controllo sul risultato dell'interrogazione if (mysql_num_rows($auth) > 0) { $plan = new Plan(); $plan->setConnector($this->connector); $subject = new Subject(); $subject->setConnector($this->connector); while ($res = $this->connector->getObjectResult($auth)) { $book = new Booking($res->id_appello, $res->id_piano, $res->id_materia, $res->anno, $res->docente, $res->data_esame); //Calcolo le informazioni di servizio $currPlan = $plan->getById($book->plan_id); $book->course_name = $currPlan->course_name; $book->plan_code = $currPlan->plan_code; $book->subject_name = $subject->getById($book->subject_id)->name; $list[] = $book; } } return $list; }
function showSubject() { global $connector; $subject = new Subject(); $subject->setConnector($connector); if (isset($_POST['operation'])) { list($operation, $params) = explode("#", $_POST['operation']); switch ($operation) { case 'saveChanges': $subject->storeFormValues($_POST); $error_msg = $subject->insert(); if ($error_msg) { $result['edit'] = $subject; } break; case 'delete': $error_msg = $subject->delete($params); break; case 'edit': $result['edit'] = $subject->getById($params); break; case 'editChanges': $subject->storeFormValues($_POST); $error_msg = $subject->update(); break; default: $error_msg = "Operazione non valida"; } if ($error_msg != "") { $result["errorMessage"] = $error_msg; } elseif ($operation != 'edit') { $result["statusMessage"] = "Operazione completata!"; } } if (isset($_POST['search'])) { $result["subjects"] = $subject->search($_POST['search']); } else { $result["subjects"] = $subject->getList(); } $page = "subject.php"; include_once BASE_PATH . "template.php"; }