| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST2146/VM_Data/Data_WWW/scheduler/Schedule/ |
Upload File : |
<?
// displaySchedule.phpinc
// Display the schedule.
t_Begin(true); // Begin TRACKing displaySchedule.phpinc.
sectionHeader();
// Get imported or added sessions.
$query = "
SELECT DISTINCT
YRTR
FROM `class`
ORDER BY YRTR
";
d_Var('classYRTRResult',$query,'q');
$classYRTRResult = query_do($query);
$classYRTRCount = $GLOBALS['_QUERY']['count'];
d_Var('$classYRTRResult',$classYRTRResult);
$YRTRlist = query_to_list_quoted($classYRTRResult); if ( $YRTRlist == '' ) $YRTRlist = "'0'";
d_Var('$YRTRlist',$YRTRlist);
$query = "
SELECT sessionId
, YRTR
, sessionName
, sessionDescription
FROM `session`
WHERE YRTR IN ( ".$YRTRlist." )
ORDER BY YRTR DESC
";
d_Var('sessionResult',$query,'q');
$sessionResult = query_do($query);
$sessionCount = $GLOBALS['_QUERY']['count'];
d_Var('$sessionResult',$sessionResult);
// Import classes from a session.
?>
<form name="form_name" action="<?=php_self()?>" method="post">
<input type="hidden" name="form" value="form_name">
<input type="hidden" name="uuid" value="<?=uuid()?>">
Import from: <select name="sessionId">
<option value=""></option>
<?
if ( $sessionCount ) {
query_seek($sessionResult, 0);
while ($sessionInfo = query_row($sessionResult)) {
?>
<option value="<?=$sessionInfo['sessionId']?>"><?=$sessionInfo['sessionName']?> (<?=$sessionInfo['YRTR']?>)</option>
<?
}
}
?>
</select>
<input type="submit" name="task" value="Import">
<?
// Display the schedule.
$f['scheduleId'] = $_SESSION['user']['scheduleId'];
d_V('scheduleId');
d_Var('$scheduleclassCount',$scheduleclassCount);
d_Var('$scheduleclassResult',$scheduleclassResult);
// Display schedule table.
$f['dayview'] = 'work'; // Type of view (work or full).
$f['timestart'] = 8; // beginning hour (24hr format.
$f['timeend'] = 19; // ending hour (24hr format.
$f['timeinc'] = 30; // Minutes between rows.
$dh = 24; // Row height.
switch ( $f['dayview'] ) {
case 'work':
$daystart = 'Mon';
$dayend = 'Fri';
break;
case 'full':
$daystart = 'Sun';
$dayend = 'Sat';
break;
}
$query = "
SELECT weekdayNumber
FROM `weekday`
WHERE weekdayDay = '".query_safe($daystart)."'
";
d_Var('weekdayStartInfo',$query,'q');
$weekdayStartInfo = query_info($query);
d_Var('$weekdayStartInfo',$weekdayStartInfo);
$query = "
SELECT weekdayNumber
FROM `weekday`
WHERE weekdayDay = '".query_safe($dayend)."'
";
d_Var('weekdayEndInfo',$query,'q');
$weekdayEndInfo = query_info($query);
d_Var('$weekdayEndInfo',$weekdayEndInfo);
// Calculate days to show.
$daysToShow = $weekdayEndInfo['weekdayNumber'] - $weekdayStartInfo['weekdayNumber'] +1;
switch ( $daysToShow ) {
case 5:
$dayClass = ' workweek';
break;
case 7:
$dayClass = ' fullweek';
break;
}
// Get weekdays we are to use.
$query = "
SELECT weekdayId
, weekdayNumber
, weekdayD
, weekdayDay
, weekdayWeekday
FROM `weekday`
WHERE weekdayNumber >= ".$weekdayStartInfo['weekdayNumber']."
AND weekdayNumber <= ".$weekdayEndInfo['weekdayNumber']."
ORDER BY weekdayNumber
";
d_Var('weekdayResult',$query,'q');
$weekdayResult = query_do($query);
$weekdayCount = $GLOBALS['_QUERY']['count'];
d_Var('$weekdayResult',$weekdayResult);
// BEGIN schedule table.
// Table header.
?>
<div class="schedulecontainer">
<table class="schedule">
<tr><td class="time"></td>
<?
query_seek($weekdayResult, 0);
while ($weekdayInfo = query_row($weekdayResult)) {
?><th class="<?=$dayClass?>"><?=$weekdayInfo['weekdayWeekday']?></th><?
}
?>
</tr>
<?
// Table rows.
$rows = (int)( ( ( $f['timeend'] - $f['timestart'] + 1 ) * 60 ) / $f['timeinc'] );
$tIdClasses = array(); // Array to count number of classes in a td.
for ( $time=$f['timestart']*60; $time<$f['timeend']*60; $time+=$f['timeinc'] ) {
$displayTime = valid_time((int)($time/60).':'.($time%60),'USA');
#d_Var('$displayTime',$displayTime);
?>
<tr><td class="dh<?=$dh?>"><?=$displayTime?></td>
<?
query_seek($weekdayResult, 0);
while ($weekdayInfo = query_row($weekdayResult)) {
$tdId = $weekdayInfo['weekdayD'].str_replace(array('am','pm',':'),'',$time);
$tIdClasses[$tdId] = array();
$tIdClasses[$tdId]['time'] = $time;
$tIdClasses[$tdId]['count'] = 0; // Init to 0;
?><td id="<?=$tdId?>" class="dh<?=$dh?> <?=$dayClass?>"><?=$tdId?></td><?
}
?>
</tr>
<?
}
?>
}
</table>
</div>
<?
// END schedule table.
// BEGIN create class divs.
if ( $scheduleclassCount ) {
$classes = array();
query_seek($scheduleclassResult, 0);
while ($scheduleclassInfo = query_row($scheduleclassResult)) {
d_Var('$scheduleclassInfo',$scheduleclassInfo);
// Get class info.
$query = "
SELECT classId
, class.YRTR
, classQId
, course.courseId
, classSection
, classEnr
, classMax
, classStartDate
, classEndDate
, courseinsttypeId
, departmentCode
, courseNumber
, courseTitle
, courseCredits
, courseCreditsMax
FROM `class`
JOIN `course` ON course.courseId = class.courseId
JOIN `department` ON department.departmentId = course.departmentId
WHERE classId = ".$scheduleclassInfo['classId']."
";
// ORDER BY departmentCode, courseNumber, classSection
d_Var('classInfo',$query,'q');
$classInfo = query_info($query);
d_Var('$classInfo',$classInfo);
$cId = $classInfo['classId'];
$classes[$cId] = array();
foreach ( $classInfo as $index => $value ) {
$classes[$cId][$index] = $value;
}
// Get classmeeting info.
$query = "
SELECT classmeetingId
, classId
, classmeetingStartDate
, classmeetingEndDate
, classmeetingBeginTime
, classmeetingEndTime
, classmeetingOnOff
, roomNumber
, buildingCode
FROM `classmeeting`
JOIN `room` ON room.roomId = classmeeting.roomId
JOIN `building` ON building.buildingId = room.buildingId
WHERE classId = ".$classInfo['classId']."
ORDER BY classmeetingStartDate, classmeetingBeginTime
";
d_Var('classmeetingResult',$query,'q');
$classmeetingResult = query_do($query);
$classmeetingCount = $GLOBALS['_QUERY']['count'];
d_Var('$classmeetingResult',$classmeetingResult);
// Create room list.
$roomList = '';
$classes[$cId]['classmeeting'] = array();
if ( $classmeetingCount ) {
query_seek($classmeetingResult, 0);
while ($classmeetingInfo = query_row($classmeetingResult)) {
$cmId = $classmeetingInfo['classmeetingId'];
$classes[$cId]['classmeeting'][$cmId] = array();
foreach ( $classmeetingInfo as $index => $value ) {
$classes[$cId]['classmeeting'][$cmId][$index] = $value;
}
$roomList = listAppend($roomList,$classmeetingInfo['buildingCode'].$classmeetingInfo['roomNumber']);
$meetingTime = valid_time($classmeetingInfo['classmeetingBeginTime'],'USA').'-'.valid_time($classmeetingInfo['classmeetingEndTime'],'USA');
// Get classmeetingweekdays.
$query = "
SELECT classmeetingweekday.weekdayId
, weekdayD
FROM `classmeetingweekday`
JOIN `weekday` ON weekday.weekdayId = classmeetingweekday.weekdayId
WHERE classmeetingId = ".$classmeetingInfo['classmeetingId']."
ORDER BY weekdayNumber
";
d_Var('classmeetingweekdayResult',$query,'q');
$classmeetingweekdayResult = query_do($query);
$classmeetingweekdayCount = $GLOBALS['_QUERY']['count'];
d_Var('$classmeetingweekdayResult',$classmeetingweekdayResult);
$classes[$cId]['classmeeting'][$cmId]['weekday'] = array();
if ( $classmeetingweekdayCount ) {
$classes[$cId]['classmeeting'][$cmId]['weekday'] = array();
$classes[$cId]['classmeeting'][$cmId]['tdId'] = array();
$classes[$cId]['classmeeting'][$cmId]['min'] = array();
query_seek($classmeetingweekdayResult, 0);
while ($classmeetingweekdayInfo = query_row($classmeetingweekdayResult)) {
$wId = $classmeetingweekdayInfo['weekdayId'];
#foreach ( $classmeetingweekdayInfo as $D ) {
$classes[$cId]['classmeeting'][$cmId]['weekday'][$wId] = array();
$classes[$cId]['classmeeting'][$cmId]['weekday'][$wId]['weekdayD'] = $classmeetingweekdayInfo['weekdayD'];
$beginMin = explode(':',$classmeetingInfo['classmeetingBeginTime']);
$beginMin = $beginMin[0] * 60 + $beginMin[1];
$endMin = explode(':',$classmeetingInfo['classmeetingEndTime']);
$endMin = $endMin[0] * 60 + $endMin[1];
$classes[$cId]['classmeeting'][$cmId]['weekday'][$wId]['tdId'] = $classmeetingweekdayInfo['weekdayD'].$beginMin;
$classes[$cId]['classmeeting'][$cmId]['weekday'][$wId]['beginMin'] = $beginMin;
$classes[$cId]['classmeeting'][$cmId]['weekday'][$wId]['endMin'] = $endMin;
// Add class across tIds.
for ( $min=$beginMin; $min<$endMin; $min+=$f['timeinc'] ) {
$tIdClasses[$classmeetingweekdayInfo['weekdayD'].$min]['count']++;
}
#}
}
}
}
}
// td id format: M480. Day + minutes since midnight.
// div id is classId.
d_Var("\$classes[$cId]",$classes[$cId]);
?>
<div id="<?=$classInfo['classId']?>" class="class">
<?
$cr = $classInfo['courseCredits']+0;
$crMax = $classInfo['courseCreditsMax']+0;
?>
<?=$classInfo['departmentCode']?><?=$classInfo['courseNumber']?>-<?=$classInfo['classSection']?>
<?=$cr?><? if ( $crMax ) { ?>-<?=$crMax?><? } ?>cr
<?=listAnd(str_replace('MAINHU','',$roomList))?>
<br>
<?=$meetingTime?>
<?
?>
</div>
<?
// Position the class div.
?>
<script>
<?
?>
</script>
<?
}
}
d_Var("\$tIdClasses",$tIdClasses);
// END create class divs.
?>
</form>
<?
sectionFooter();
t_End(); // End TRACKing displaySchedule.phpinc.
?>