예제 #1
0
            $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 {
예제 #2
0
// 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>