Day |
7:00- |
8:00- |
9:00- |
10:00- |
11:00- |
12:00- |
1:00- |
2:00- |
3:00- |
4:00- |
5:00- |
6:00- |
7:00- |
8:00- |
$shortweekday[$i]
$month/$day |
END;
$lasthour = 8;
$lastminute = 0;
$start=0;
$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 Date = '$Date' and ";
$query .= "SR_reservation.RoomNo='$Room' 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 StartTime";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_row($result))
{
list ($openhour, $openminute, $opensec) = split (':', $row[2]);
list ($closehour, $closeminute, $closesec) = split (':', $row[3]);
(integer)$j=($openhour-$lasthour)*4 + ($openminute - $lastminute)/15;
if ($j>0)
{
$width = $j*22;
if ($start==1)
{
print <<|
|
|
|
|
|
|
END;
}
else
{
print <<
END;
$start=1;
}
}
(integer)$j=($closehour-$openhour)*4 + ($closeminute - $openminute)/15;
$width = $j*22;
// $HTML = str_replace("\n",$row[14].$row[15]);
list ($line1, $line2, $line3, $line4) = split("\n",$row[14].$row[15]);
$line1 = substr($line1, 0, 4*$j-2);
$line2 = substr($line2, 0, 4*$j-2);
$line3 = substr($line3, 0, 4*$j-2);
$line4 = substr($line4, 0, 4*$j-2);
if ($j == 1)
{
print <<| $openhour:$openminute - $closehour:$closeminute
| $row[5] $row[6]
| $row[4]
| $line1
END;
}
else
{
print <<| $openhour:$openminute - $closehour:$closeminute
| $row[5] $row[6]
| $row[4]
| $line1
| $line2
| $line3
| $line4
END;
}
$start=1;
$lasthour = $closehour;
$lastminute = $closeminute;
if ($bgcolor1=="#F8E8FF")
{$bgcolor1="#DDDDDD";}
else
{$bgcolor1="#F8E8FF";}
}
if ( mysql_num_rows($result)== 0)
{ print "
| ";}
else
{
(integer)$j=(21-$lasthour)*4 + (0 - $lastminute)/15;
if ($j>0)
{
$width = $j*22;
print <<|
|
|
|
|
|
|
END;
}
}
print <<
|
END;
if ($bgcolor=="#F5F5F5")
{$bgcolor="#DDDDDD";}
else
{$bgcolor="#F5F5F5";}
$Date = date("Y-m-d", mktime (0,0,0, $month, $day+1, $year));
list ($year, $month, $day) = split ('-', $Date);
$i++;
}
?>
