$oldDatephp = strtotime($row[1]);
if ($oldAdvisorID != 0) {
$sql2 = "select * from Proj2Advisors where `id` = '{$oldAdvisorID}'";
$rs2 = $COMMON->executeQuery($sql2, $_SERVER["SCRIPT_NAME"]);
$row2 = mysql_fetch_row($rs2);
$oldAdvisorName = $row2[1] . " " . $row2[2];
} else {
$oldAdvisorName = "Group";
}
echo "<h2>Previous Appointment</h2>";
echo "<label for='info'>";
echo "Advisor: ", $oldAdvisorName, "<br>";
echo "Appointment: ", date('l, F d, Y g:i A', $oldDatephp), "</label><br>";
}
$currentAdvisorName;
$currentAdvisorID = getAdvisor();
$currentDatephp = strtotime($_SESSION["appTime"]);
if ($currentAdvisorID != 0) {
$sql2 = "select * from Proj2Advisors where `id` = '{$currentAdvisorID}'";
$rs2 = $COMMON->executeQuery($sql2, $_SERVER["SCRIPT_NAME"]);
$row2 = mysql_fetch_row($rs2);
$currentAdvisorName = $row2[1] . " " . $row2[2];
} else {
$currentAdvisorName = "Group";
}
echo "<h2>Current Appointment</h2>";
echo "<label for='newinfo'>";
echo "Advisor: ", $currentAdvisorName, "<br>";
echo "Appointment: ", date('l, F d, Y g:i A', $currentDatephp), "</label>";
?>
</div>
<title>Select Appointment</title>
<link rel='stylesheet' type='text/css' href='css/standard.css'/>
</head>
<body>
<div id="login">
<div id="form">
<div class="top">
<h1>Select Appointment Time</h1>
<div class="field">
<form action = "10StudConfirmSch.php" method = "post" name = "SelectTime">
<?php
// http://php.net/manual/en/function.time.php fpr SQL statements below
// Comparing timestamps, could not remember.
$curtime = time();
if (getAdvisor() != "Group") {
$sql = "select * from Proj2Appointments where {$temp} `EnrolledNum` = 0 \n\t\t\t\t\tand (`Major` like '%{$localMaj}%' or `Major` = '') and `Time` > '" . date('Y-m-d H:i:s') . "' and `AdvisorID` = " . $_POST['advisor'] . " \n\t\t\t\t\torder by `Time` ASC limit 30";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
echo "<h2>Individual Advising</h2><br>";
echo "<label for='prompt'>Select appointment with ", $advisorName, ":</label><br>";
} else {
$temp = "";
if ($localAdvisor != "Group") {
$temp = "`AdvisorID` = '{$localAdvisor}' and ";
}
$sql = "select * from Proj2Appointments where {$temp} `EnrolledNum` < `Max` and `Max` > 1 and (`Major` like '%{$localMaj}%' or `Major` = '') and `Time` > '" . date('Y-m-d H:i:s') . "' order by `Time` ASC limit 30";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
echo "<h2>Group Advising</h2><br>";
echo "<label for='prompt'>Select appointment:</label><br>";
}
while ($row = mysql_fetch_row($rs)) {
$sql = "update `Proj2Appointments` set `EnrolledNum` = EnrolledNum+1, `EnrolledID` = '{$studid}' where `AdvisorID` = '{$advisor}' and `Time` = '{$apptime}'";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
}
$_SESSION["status"] = "complete";
} elseif ($_POST["finish"] == 'Reschedule') {
//remove stud from EnrolledID
$sql = "select * from Proj2Appointments where `EnrolledID` like '%{$studid}%'";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
$row = mysql_fetch_row($rs);
$oldAdvisorID = $row[2];
$oldAppTime = $row[1];
$newIDs = str_replace($studid, "", $row[4]);
$sql = "update `Proj2Appointments` set `EnrolledNum` = EnrolledNum-1, `EnrolledID` = '{$newIDs}' where `AdvisorID` = '{$oldAdvisorID}' and `Time` = '{$oldAppTime}'";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
//schedule new app
if (getAdvisor() == 'Group') {
$sql = "select * from Proj2Appointments where `Time` = '{$apptime}' and `AdvisorID` = 0";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
$row = mysql_fetch_row($rs);
$groupids = $row[4];
$sql = "update `Proj2Appointments` set `EnrolledNum` = EnrolledNum+1, `EnrolledID` = '{$groupids} {$studid}' where `Time` = '{$apptime}' and `AdvisorID` = 0";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
} else {
$sql = "update `Proj2Appointments` set `EnrolledNum` = EnrolledNum+1, `EnrolledID` = '{$studid}' where `Time` = '{$apptime}' and `AdvisorID` = '{$advisor}'";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
}
$_SESSION["status"] = "resch";
}
//update stud status to ''
$sql = "update `Proj2Students` set `Status` = '' where `StudentID` = '{$studid}'";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
