$row[1] $row[2]'s Information
| Department: |
$row[0] |
| First Name: |
$row[1] |
| Last Name: |
$row[2] |
| Extension: |
$row[4] |
| Mt. SAC Email: |
$row[3] |
| Home Phone: |
$row[5] |
| Cell Phone: |
$row[6] |
| I would like to be contacted by |
$Contact |
END;
print <<
Current class list for $row[1] $row[2]:
| Add |
Semester |
Ticket # |
Course ID |
Title |
Days |
Begin Time |
End Time |
|
END;
if ($Semester == "")
{
//echo "nothing here";
$query = "SELECT Semester, Year, StartDate, EndDate, OpenDate from SR_semester WHERE EndDate >= CURDATE()";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_row($result))
{
$Semester = $row[0]." ".$row[1];
}
}
// $query = "SELECT CourseID, CourseTitle, ClassID, Days, BeginTime, EndTime from SR_course WHERE InstructorID='$ID' and Year='$Syear' and Semester='$Semester'";
$query = "SELECT CourseID, CourseTitle, ClassID, Days, BeginTime, EndTime, SR_course.Year, SR_course.Semester from SR_course, SR_semester WHERE InstructorID='$ID' and SR_semester.Year=SR_course.Year and SR_semester.Semester=SR_course.Semester and SR_semester.Status='1'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_row($result))
{
print <<
Delete |
$row[7] $row[6] |
$row[2] |
$row[0] |
$row[1] |
$row[3] |
$row[4] |
$row[5] |
Transfer |
END;
}
print <<
END;
if ($Semester != '')
{
list ($semester, $syear) = split (' ', $Semester);
$query = "select StartDate, EndDate from SR_semester where Year='$syear' and Semester='$semester'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$StartDate = $row[0];
$EndDate = $row[1];
$query = "SELECT Title, Date, StartTime, SR_reservation.EndTime, CourseID, FirstName, LastName, SR_reservation.ClassID, SR_reservation.RoomNo, Home, Cell, Extension, Email, SR_reservation.StudentNum, Tasks, SpecialNeeds, CourseTitle, Days, SR_course.BeginTime, SR_course.EndTime, SR_reservation.InstructorID, SR_reservation.Memo from SR_reservation, SR_instructor, SR_course, SR_room WHERE ";
$query .= "Date<='$EndDate' and Date>='$StartDate' and SR_reservation.InstructorID='$ID' AND ";
$query .= "(SR_reservation.Status='1' or SR_reservation.Status='2') and SR_reservation.RoomNo=SR_room.RoomNo and SR_reservation.ClassID=SR_course.ClassID and SR_reservation.InstructorID=SR_instructor.InstructorID and CONCAT(SR_course.Semester, ' ', SR_course.Year) = '$Semester' order by Date";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$num_rows = mysql_num_rows($result);
print <<$Semester Reservation List: $num_rows
END;
while ($row = mysql_fetch_row($result))
{
list ($year, $month, $day) = split ('-', $row[1]);
list ($sh, $sm, $ss) = split (':', $row[2]);
list ($eh, $em, $es) = split (':', $row[3]);
$HTMLtasks = str_replace("\n","
",$row[14]);
$HTMLneeds = str_replace("\n","
",$row[15]);
$HTMLmemo = str_replace("\n","
",$row[21]);
print <<
|
Date:
|
$month/$day/$year |
Room:
|
$row[0] - $row[8] |
|
Start:
|
$sh:$sm |
End:
|
$eh:$em |
|
Class:
|
$row[7] - $row[4] -- $row[16] $row[17] From $row[18] to $row[19] |
|
Instructor:
|
$row[5] $row[6] |
Number of Students:
|
$row[13] |
|
Tasks:
|
$HTMLtasks |
Brief Lesson Plan:
|
$HTMLneeds |
|
Memo:
|
$HTMLmemo |
|
Cancel this reservation
|
Edit this reservation
|
END;
/*
Cancel this reservation
Edit this reservation
*/
}
}
?>
| 