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;
     }
 }
Ejemplo n.º 2
0
 } 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 {