public static function get($id) { global $db; $query = "SELECT * FROM `observership_reflections` WHERE `id` = " . $db->qstr($id); $result = $db->getRow($query); if ($result) { $obs = ObservershipReflection::fromArray($result); return $obs; } }
} else { $observership_reflection = ObservershipReflection::get($observership->getReflection()); if (!$observership_reflection && $observership->getStatus() == "confirmed") { add_error("This observership has been confirmed, a reflection can not be added at this time. You will be redirected to the observerships page in 5 seconds."); echo display_error(); $ONLOAD[] = "setTimeout('window.location=\\'" . ENTRADA_URL . "/profile/observerships\\'', 5000)"; } else { switch ($STEP) { case 2: if ($observership->getStatus() != "confirmed") { if ($observership_reflection) { $_POST["id"] = $observership_reflection->getID(); $observership_reflection->mapArray($_POST, "update"); $observership_reflection->update($observership_reflection->getID()); } else { $observership_reflection = ObservershipReflection::fromArray($_POST, "create"); $observership_reflection = $observership_reflection->create(); $query = "UPDATE `student_observerships` SET `reflection_id` = " . $db->qstr($observership_reflection->getID()) . " WHERE `id` = " . $db->qstr($observership->getID()); $db->Execute($query); $preceptor_name = ($observership->getPreceptorPrefix() ? $observership->getPreceptorPrefix() . " " : "") . $observership->getPreceptorFirstname() . " " . $observership->getPreceptorLastname(); $message = $preceptor_name . ",\n\n"; $message .= "You have been indicated as the preceptor on an Observership:\n" . "======================================================\n" . "Submitted at: " . date("Y-m-d H:i", time()) . "\n" . "Submitted by: " . $ENTRADA_USER->getFullname(false) . "\n" . "E-Mail Address: " . $ENTRADA_USER->getEmail() . "\n" . "Observership details:\n" . "---------------------\n" . "Title: " . $observership->getTitle() . "\n" . "Activity Type: " . $observership->getActivityType() . "\n" . ($observership->getActivityType() == "ipobservership" ? "IP Observership Details: " . $observership->getObservershipDetails() . "\n" : "") . "Clinical Discipline: " . $observership->getClinicalDiscipline() . "\n" . "Organisation: " . $observership->getOrganisation() . "\n" . "Address: " . $observership->getAddressLine1() . "\n" . "Preceptor: " . $observership->getPreceptorFirstname() . " " . $observership->getPreceptorLastname() . "\n" . "Start date: " . date("Y-m-d", $observership->getStart()) . "\n" . "End date: " . date("Y-m-d", $observership->getEnd()) . "\n\n" . "The observership request can be approved or rejected at the following address:\n" . ENTRADA_URL . "/confirm_observership?unique_id=" . $observership->getUniqueID(); $mail = new Zend_Mail(); $mail->addHeader("X-Section", "Observership Notification System", true); $mail->setFrom($AGENT_CONTACTS["observership"]["email"], $AGENT_CONTACTS["observership"]["name"]); $mail->clearSubject(); $mail->setSubject("Observership Request Created"); $mail->setBodyText($message); $mail->clearRecipients(); $mail->addTo($observership->getPreceptorEmail(), $preceptor_name); try {