<div class="top">
<h1>Removed Appointment</h1><br>
<div class="field">
<?php
$debug = false;
include '../CommonMethods.php';
include '../Appointment.php';
include '../Student.php';
include '../Advisor.php';
$COMMON = new Common($debug);
$indID = $_POST["IndApp"];
// 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: ";
$delete = !isset($_POST["edit"]);
// Get appointment ID from post or get
if (isset($_POST["GroupApp"])) {
$appID = $_POST["GroupApp"];
} else {
$appID = $_GET["app"];
}
include '../CommonMethods.php';
include '../Appointment.php';
include '../Student.php';
$COMMON = new Common($debug);
// Get appointment info
$appt = new Appointment($COMMON, $appID);
if ($delete == true) {
echo "<h1>Removed Appointment</h1><br>";
$stds = $appt->getEnrolledID();
$stds = trim($stds);
// had some side white spaces sometimes
$stds = split(" ", $stds);
if ($debug) {
var_dump("\n<BR>EMAILS ARE: {$stds} \n<BR>");
}
// foreach($stds as $element) { echo("->".$element."\n"); }
if ($stds[0]) {
foreach ($stds as $element) {
$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();
// ************************ Lupoli 9-1-2015
// we have to check to make sure someone did not steal that spot just before them!! (deadlock)
// if the spot was taken, need to stop and reset
if (isStillAvailable($_POST['appID'])) {
} else {
if ($debug == false) {
header('Location: 13StudDenied.php');
return;
}
}
if ($_POST["finish"] == 'Reschedule') {
// Get info from database about old appointment
$oldApptID = $_POST["oldAppID"];
$oldAppt = new Appointment($COMMON, $oldApptID);
//remove stud from EnrolledID
$newIDs = str_replace($studid, "", $oldAppt->getEnrolledID());
if ($debug) {
echo "Old IDs: " . $oldAppt->getEnrolledID() . "<br>";
echo "New IDs: {$newIDs}<br>";
}
$sql = "update `Proj2Appointments` set `EnrolledNum` = EnrolledNum-1, `EnrolledID` = '{$newIDs}' where `id`='{$oldApptID}'";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
// Status is rescheduled appointment
$stat = 'r';
} else {
// Status is normal appointment scheduling
$stat = 'co';
}
// Schedule new app
// Add new student ID to list of ID's and update enrollment total
$newIDs = $newAppt->getEnrolledID() . " {$studid}";
