$element = trim($element);
$sql = "UPDATE `Proj2Students` SET `Status`='C' WHERE `StudentID` = '{$element}'";
$rs = $COMMON->executeQuery($sql, "Advising Appointments");
// Get student info from database
$student = new Student($COMMON, $element);
$eml = $student->getEmail();
$message = "The following group appointment has been deleted by the adminstration of your advisor: " . "\r\n" . "Time: " . $appt->getTime() . "\r\n" . "To schedule for a new appointment, please log back into the UMBC COEIT Engineering and Computer Science Advising webpage." . "\r\n" . "http://coeadvising.umbc.edu -> COEIT Advising Scheduling \r\n Reminder, this is only accessible on campus.";
mail($eml, "Your COE Advising Appointment Has Been Deleted", $message);
}
}
$sql = "DELETE FROM `Proj2Appointments` WHERE `id`='{$appID}'";
$rs = $COMMON->executeQuery($sql, "Advising Appointments");
echo "Time: " . date('l, F d, Y g:i A', strtotime($appt->getTime())) . "<br>";
echo "Majors included: ";
if ($appt->getMajor()) {
echo $appt->convertMajor(', ') . "<br>";
} else {
echo "Available to all majors<br>";
}
echo "Number of students enrolled: " . $appt->getEnrolledNum() . "<br>";
echo "Student limit: " . $appt->getMax();
echo "<br><br>";
echo "<form method=\"link\" action=\"AdminUI.php\">";
echo "<input type=\"submit\" name=\"next\" class=\"button large go\" value=\"Return to Home\">";
echo "</form>";
echo "</div>";
echo "<div class=\"bottom\">";
if ($stds[0]) {
echo "<p style='color:red'>Students have been notified of the cancellation.</p>";
}
} else {
// Get appointment info from the database
$appt = new Appointment($COMMON, $indID);
$adv = $appt->getAdvisorID();
$advisor = new Advisor($COMMON, $adv);
if ($appt->getEnrolledID()) {
$student = new Student($COMMON, trim($appt->getEnrolledID()));
$std = $student->getFirstName() . " " . $student->getLastName();
$eml = $student->getEmail();
}
$sql = "DELETE FROM `Proj2Appointments` WHERE `id`='{$indID}'";
$rs = $COMMON->executeQuery($sql, "Advising Appointments");
echo "Time: " . date('l, F d, Y g:i A', strtotime($appt->getTime())) . "<br>";
echo "Advisor: " . $advisor->convertFullName() . "<br>";
echo "Majors included: ";
if ($appt->getMajor()) {
echo $appt->convertMajor() . "<br>";
} else {
echo "Available to all majors<br>";
}
echo "Enrolled: ";
if ($appt->getEnrolledID()) {
echo "{$std}</b>";
$sql = "UPDATE `Proj2Students` SET `Status`='C' WHERE `StudentID` = '" . trim($appt->getEnrolledID()) . "'";
$rs = $COMMON->executeQuery($sql, "Advising Appointments");
$message = "The following appointment has been deleted by the adminstration of your advisor: " . "\r\n" . "Time: " . $appt->getTime() . "\r\n" . "Advisor: " . $advisor->convertFullName() . "\r\n" . "Student: {$std}" . "\r\n" . "To schedule for a new appointment, please log back into the UMBC COEIT Engineering and Computer Science Advising webpage." . "\r\n" . "http://coeadvising.umbc.edu -> COEIT Advising Scheduling \r\n Reminder, this is only accessible on campus.";
mail($eml, "Your Advising Appointment Has Been Deleted", $message);
} else {
echo "Empty";
}
?>
<br><br>