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";
}
