$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"]);