Sorry, you must select a task or write down your Brief Lesson Plan to make this reservation.";
exit();
}
//if (isset($_POST['task2'])){$Tasks .= $_POST['task2']."\n";}
//$Tasks .= isset($_POST['task1']) ? $_POST['task1']."\n" : "";
if ($StartHour*60+$StartMinute >= $EndHour*60+$EndMinute)
{
print "Sorry, your selected time $StartHour:$StartMinute - $EndHour:$EndMinute is invalid. Please go back and change your time selection.
";
exit();
}
$selectday = mktime (0,0,0, $Month, $Day, $Year);
$p4dayslater = mktime (0,0,0, date("m"), date("d")+4, date("Y"));
$p18dayslater = mktime (0,0,0, date("m"), date("d")+18, date("Y"));
if ($manage==0)
{
if ($Tag == '0' and $selectday>$p18dayslater)
{
print "Sorry, you cannot make a reservation on $Month/$Day/$Year which is more than 18 days away. Please go back and change your date.
";
exit();
}
else if ($selectday<$p4dayslater)
{
print "Sorry, you cannot make a reservation on $Month/$Day/$Year which is less than 4 days away. Please call the LLC to make the reservation or go back and change your date.
";
exit();
}
}
$query = "SELECT Date from SR_reservation WHERE InstructorID = '$ID' and RoomNo = '$Room' and ClassID='$Course' and (Status='1' or Status='2') and year(Date)=year('$Date') and week(Date)=week('$Date') and (RoomNo <> '$Room0' or Date <> '$Date0' or StartTime<>'$Time0')";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_row($result))
{
print "Sorry, you've had a reservation for this class in that week already on $row[0]. Please go back and change your week or class selection.
";
exit();
}
$query = "SELECT StartTime, EndTime from SR_reservation WHERE Date = '$Date' and RoomNo = '$Room' and (Status='1' or Status='2') and (RoomNo <> '$Room0' or Date <> '$Date0' or StartTime<>'$Time0')";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_row($result))
{
list ($starthour, $startminute, $startsec) = split (':', $row[0]);
list ($endhour, $endminute, $endsec) = split (':', $row[1]);
if ($starthour*60+$startminute >= $EndHour*60+$EndMinute or $endhour*60+$endminute <= $StartHour*60+$StartMinute)
{continue;}
else
{
print "Sorry, your selected time $StartHour:$StartMinute - $EndHour:$EndMinute is not avaliable. Please go back and change your time selection.
";
exit();
}
}
$query = "SELECT Title from SR_room WHERE RoomNo = '$Room'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$Title = $row[0];
$query = "SELECT CourseTitle from SR_course WHERE ClassID = '$Course'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$CourseTitle = $row[0];
//$HTMLtasks = str_replace("\n","
",$Tasks);
//$HTMLneeds = str_replace("\n","
",$Needs);
$today = date("F j, Y, g:i a"); // March 10, 2001, 5:16 pm
$query = "update SR_reservation set RoomNo= '$Room', Date= '$Date', StartTime='$StartTime', EndTime='$EndTime', InstructorID='$ID', ClassID = '$Course', StudentNum='$Student', Tasks='$Tasks', SpecialNeeds='$Needs1'";
if ($manage==1){$query .= ", Memo=CONCAT(Memo, '\n$today - Reservation changed by LLC $user'), Status='2'";}
else {$query .= ", Memo=CONCAT(Memo, '\n$today - Reserved by instructor $ID'), Status='1'";}
$query .= " where RoomNo = '$Room0' and Date = '$Date0' and StartTime='$Time0'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$query = "SELECT FirstName, LastName, Email, Extension, Home, Cell from SR_instructor WHERE InstructorID = '$ID'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$FirstName = $row[0];
$LastName = $row[1];
$Email = $row[2];
$Extension = $row[3];
$Home = $row[4];
$Cell = $row[5];
$query = "SELECT CourseID, Days, BeginTime, EndTime from SR_course WHERE ClassID = '$Course' and Year = '$syear' and Semester='$semester'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$Course .= ' '.$row[0].' - '.$row[1].' - From '.$row[2].' to '.$row[3];
include("../SendMail.php");
$TEXT="Dear Prof. $FirstName $LastName\n\n";
$TEXT=$TEXT."We have received your REVISED reservation request for:\n\n";
$TEXT=$TEXT."$Title - $Room\n";
$TEXT=$TEXT."On $Month/$Day/$Year\n";
$TEXT=$TEXT."From $StartTime to $EndTime\n";
$TEXT=$TEXT."For class: $Course\n";
$TEXT=$TEXT."Number of students: $Student\n";
$TEXT=$TEXT."You will use:\n$Tasks\n";
$TEXT=$TEXT."Brief Lesson Plan:\n$Needs\n\n";
$TEXT=$TEXT."Original Reservation:\n";
$TEXT=$TEXT."Date: $Month0/$Day0/$Year0\n";
$TEXT=$TEXT."Start Time: $Time0\n";
$TEXT=$TEXT."Room: $Room0\n\n";
$TEXT=$TEXT."Email: $Email\n";
$TEXT=$TEXT."Extension: $Extension\n";
$TEXT=$TEXT."Home Phone: $Home\n";
$TEXT=$TEXT."Cell Phone: $Cell\n\n";
$TEXT=$TEXT."If you have any question, please call us at 909-274-4580, or simply Reply All to this email. We will get back to you as soon as we can.\n\n";
$TEXT=$TEXT."Thank you, Language Learning Center\n";
//include("../include/email.php"); //this line defines $cc2
if ($Email == '')
{
SendMail(
"langlab@mtsac.edu","Language Learning Center", //sender
"langlab@mtsac.edu", $FirstName." ".$LastName, //recipient
$cc2, // copy to
"REVISED your LLC reservation ".$Date." ".$LastName, //subject
$TEXT,$HTML,$ATTM); //body and attachment(s)
}
else
{
SendMail(
"langlab@mtsac.edu","Language Learning Center", //sender
$Email, $FirstName." ".$LastName, //recipient
"langlab@mtsac.edu,".$cc2, // copy to
"REVISED your LLC reservation ".$Date." ".$LastName, //subject
$TEXT,$HTML,$ATTM); //body and attachment(s)
}
header("Location: completion.php?semester=$Semester&id=$ID&rm=$Room&tag=$Tag&dpt=$Department");
exit();
?>