LLC Reservation Management
$semester $syear
|
Edit
|
Open from $startmonth/$startday/$startyear to $endmonth/$endday/$endyear
|
END;
static $day_headings = array('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday');
$query = "SELECT Weekday, OpenTime, CloseTime from SR_opentime WHERE Year = '$syear' AND Semester = '$semester' order by Weekday";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_row($result))
{
$i = (integer)$row[0];
list ($openhour, $openminute, $opensec) = split (':', $row[1]);
list ($closehour, $closeminute, $closesec) = split (':', $row[2]);
print <<
|
$day_headings[$i]
|
END;
if ($row[1] == '00:00:00')
{
print <<Closed
END;
}
else
{
print <<$openhour:$openminute to $closehour:$closeminute
END;
}
print <<
END;
}
print <<
|
Add
|
Closed Dates
|
END;
$query = "SELECT CloseDate, Description from SR_closedate WHERE Year = '$syear' AND Semester = '$semester' order by CloseDate";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_row($result))
{
list ($year, $month, $day) = split ('-', $row[0]);
print <<
Delete
|
$month/$day/$year $row[1]
|
END;
}
print <<
END;
$dif = date("w", mktime (0,0,0, $startmonth, $startday, $startyear));
$firstmonday = mktime (0,0,0, $startmonth, $startday+1-$dif, $startyear);
$lasttime = mktime (0,0,0, $endmonth, $endday, $endyear);
$weekstart = $firstmonday;
$i = 0;
while ( $weekstart <= $lasttime)
{
$thismonday = date("Y-m-d", $weekstart);
$from = date("m/d/Y", $weekstart);
$to = date("m/d/Y", mktime (0,0,0, $startmonth, $startday+1-$dif+$i*7+5, $startyear));
$i++;
print <<| Week $i: $from - $to |
END;
$weekstart = mktime (0,0,0, $startmonth, $startday+1-$dif+$i*7, $startyear);
}
print <<
END;
$query = "SELECT Date, Time, User from SR_reminder order by Date Desc limit 0,1";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
list ($lastyear, $lastmonth, $lastday) = split ('-', $row[0]);
if (date("W", mktime (0,0,0, $lastmonth, $lastday, $lastyear)) == date("W"))
{
print <<Next week's reminder emails have been sent out on $lastmonth/$lastday $row[1] by $row[2].
Send out reminder emails for next week's reservations AGAIN
END;
}
else
{
print <<Send out reminder emails for next week's reservations
END;
}
print <<
|
Add
|
Future Reservations
|
END;
$query = "SELECT Title, Date, StartTime, SR_reservation.EndTime, CourseID, FirstName, LastName, SR_reservation.ClassID, SR_reservation.RoomNo from SR_reservation, SR_instructor, SR_course, SR_room WHERE Date >= CURDATE() and Date >= '$startdate' and Date <= '$enddate' AND (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, StartTime";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
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]);
print <<
View
|
$row[0]
|
$month/$day/$year
|
From $sh:$sm to $eh:$em
|
By $row[5] $row[6]
|
For $row[4]
|
END;
}
print <<
|
|
Past Reservations
|
END;
$query = "SELECT Title, Date, StartTime, SR_reservation.EndTime, CourseID, FirstName, LastName, SR_reservation.ClassID, SR_reservation.RoomNo from SR_reservation, SR_instructor, SR_course, SR_room WHERE Date < CURDATE() and Date >= '$startdate' AND (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, StartTime";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
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]);
print <<
View
|
$row[0]
|
$month/$day/$year
|
From $sh:$sm to $eh:$em
|
By $row[5] $row[6]
|
For $row[4]
|
END;
}
print <<
|
|
Cancelled Reservations
|
END;
$query = "SELECT Title, Date, StartTime, SR_reservation.EndTime, CourseID, FirstName, LastName, SR_reservation.ClassID, SR_reservation.RoomNo, SR_reservation.InstructorID from SR_reservation, SR_instructor, SR_course, SR_room WHERE Date <= '$enddate' and Date >= '$startdate' AND SR_reservation.Status = '3' 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, StartTime";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
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]);
print <<
View
|
$row[0]
|
$month/$day/$year
|
From $sh:$sm to $eh:$em
|
By $row[5] $row[6]
|
For $row[4]
|
END;
}
print <<
|
|
Absent Reservations
|
END;
$query = "SELECT Title, Date, StartTime, SR_reservation.EndTime, CourseID, FirstName, LastName, SR_reservation.ClassID, SR_reservation.RoomNo, SR_reservation.InstructorID from SR_reservation, SR_instructor, SR_course, SR_room WHERE Date <= '$enddate' and Date >= '$startdate' AND SR_reservation.Status = '4' 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, StartTime";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
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]);
print <<
View
|
$row[0]
|
$month/$day/$year
|
From $sh:$sm to $eh:$em
|
By $row[5] $row[6]
|
For $row[4]
|
END;
}
print <<
END;
?>
| | | |
