| 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/Scheduler/Schedule/ |
Upload File : |
<?
// Schedule/js_write_Schedule_ClassMeeting.phpinc
// Add SCMold and SCMnow data to site_js.php.
$jsText .= "
// ".basename(__FILE__).".";
#$DEBUG_js_write_Schedule_ClassMeeting = true;
#if ( $_SESSION['gameId'] == 0 ) $DEBUG_js_write_Schedule_ClassMeeting = true; // DEBUG by gameId.
#if ( $_SESSION['userId'] == 0 ) $DEBUG_js_write_Schedule_ClassMeeting = true; // DEBUG by userId.
if ( !isset($DEBUG_js_write_Schedule_ClassMeeting) ) $DEBUG_js_write_Schedule_ClassMeeting = d_O(); // DEBUG by passthrough.
#if ( !isset($DEBUG_js_write_Schedule_ClassMeeting) ) $DEBUG_js_write_Schedule_ClassMeeting = false; // Default false.
#if ( $DEBUG_js_write_Schedule_ClassMeeting ) d_On(); // Use instead of t_Begin() for AJAX call.
t_Begin($DEBUG_js_write_Schedule_ClassMeeting); // Begin TRACKing js_write_Schedule_ClassMeeting.phpinc.
if ( $scheduleclassCount ) { // Are there schedule classes?
// Calculate $scmIdMaxwidth to align js output for SCMnow{}.
query_seek($scheduleclassResult, 0);
$scmIdMaxwidth = 1;
while ($scheduleclassInfo = query_row($scheduleclassResult)) { // Loop thru schedule classes.
// Get meetings
$query = "
SELECT scheduleclassmeetingId
FROM `scheduleclassmeeting`
WHERE scheduleclassId = ".$scheduleclassInfo['scheduleclassId']."
";
d_Var('scheduleclassmeetingResult',$query,'q');
$scheduleclassmeetingResult = query_do($query);
$scheduleclassmeetingCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingResult',$scheduleclassmeetingResult);
if ( $scheduleclassmeetingCount ) { // Are there class meetings?
query_seek($scheduleclassmeetingResult, 0);
while ($meetingInfo = query_row($scheduleclassmeetingResult)) { // Loop thru class meetings.
$maxwdth = spaceMaxFill($scheduleclassmeetingResult, 'scheduleclassmeetingId');
if ( $maxwdth > $scmIdMaxwidth ) $scmIdMaxwidth = $maxwdth;
} // Loop thru class meetings.
} // Are there class meetings?
} // Loop thru schedule classes.
query_seek($scheduleclassResult, 0);
while ($scheduleclassInfo = query_row($scheduleclassResult)) { // Loop thru schedule classes.
// Get meetings
require('Schedule/GetScheduleClassMeeting.phpinc');
d_Var('$scheduleclassmeetingResult',$scheduleclassmeetingResult);
if ( $scheduleclassmeetingCount ) { // Are there class meetings?
$sp = spaceFill($scheduleclassInfo['scheduleclassId'], $scIdMaxwidth);
$jsText .= "
".$classMeetingName."[".$scheduleclassInfo['scheduleclassId']."] ".$sp." = [];";
query_seek($scheduleclassmeetingResult, 0);
$meetingIndex=0;
while ($meetingInfo = query_row($scheduleclassmeetingResult)) { // Loop thru class meetings.
$sp2 = spaceFill($meetingInfo['scheduleclassmeetingId'], $scmIdMaxwidth);
// Get meeting rooms.
$query = "
SELECT scheduleclassmeetingId
, room.roomId
, buildingCode
, roomNumber
FROM `scheduleclassmeetingroom`
JOIN `room` ON room.roomId = scheduleclassmeetingroom.roomId
JOIN `building` ON building.buildingId = room.buildingId
JOIN `campus` ON campus.campusId = building.campusId
WHERE scheduleclassmeetingId = ".$meetingInfo['scheduleclassmeetingId']."
ORDER BY campusName, buildingCode, 10000 + roomNumber
";
d_Var('scheduleclassmeetingroomResult',$query,'q');
$scheduleclassmeetingroomResult = query_do($query);
$scheduleclassmeetingroomCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingroomResult',$scheduleclassmeetingroomResult);
$meetingInfo['rooms'] = array();
if ( $scheduleclassmeetingroomCount ) {
query_seek($scheduleclassmeetingroomResult, 0);
while ($scheduleclassmeetingroomInfo = query_row($scheduleclassmeetingroomResult)) {
$meetingInfo['rooms'][$scheduleclassmeetingroomInfo['roomId']]['buildingCode'] = str_replace('MAINHU','',$scheduleclassmeetingroomInfo['buildingCode']);
$meetingInfo['rooms'][$scheduleclassmeetingroomInfo['roomId']]['roomNumber'] = $scheduleclassmeetingroomInfo['roomNumber'];
}
}
#d_Var("\$meetingInfo['rooms']",$meetingInfo['rooms'],'d');
$meetingInfo['roomList'] = '';
foreach ( $meetingInfo['rooms'] as $roomId => $room ) {
$meetingInfo['roomList'] = listAppend($meetingInfo['roomList'],$room['buildingCode'].$room['roomNumber']);
}
#d_Var("\$meetingInfo['roomList']",$meetingInfo['roomList'],'d');
// Get meeting days.
$query = "
SELECT weekdayD
FROM `scheduleclassmeetingweekday`
JOIN `weekday` ON weekday.weekdayId = scheduleclassmeetingweekday.weekdayId
WHERE scheduleclassmeetingId = ".$meetingInfo['scheduleclassmeetingId']."
ORDER BY weekday.weekdayId
";
d_Var('scheduleclassmeetingweekdayResult',$query,'q');
$scheduleclassmeetingweekdayResult = query_do($query);
$weekdayCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingweekdayResult',$scheduleclassmeetingweekdayResult);
$weekdays = '';
$prefix = '';
if ( $weekdayCount ) { // Are there meeting days?
query_seek($scheduleclassmeetingweekdayResult, 0);
while ($weekdayInfo = query_row($scheduleclassmeetingweekdayResult)) { // Loop thru meeting days.
$weekdays .= $prefix."'".$weekdayInfo['weekdayD']."'";
$prefix = ',';
} // Loop thru meeting days.
} // Are there meeting days?
// Get instructors.
$query = "
SELECT userId
FROM `scheduleclassmeetinginstructor`
WHERE scheduleclassmeetingId = ".$meetingInfo['scheduleclassmeetingId']."
";
d_Var('scheduleclassmeetinginstructorResult',$query,'q');
$scheduleclassmeetinginstructorResult = query_do($query);
$scheduleclassmeetinginstructorCount = $GLOBALS['_QUERY']['count'];
d_Var('scheduleclassmeetinginstructorResult',$scheduleclassmeetinginstructorResult);
$instructors = '';
$prefix = '';
if ( $scheduleclassmeetinginstructorCount ) { // Are there $instructors?
query_seek($scheduleclassmeetinginstructorResult, 0);
while ($instructoryInfo = query_row($scheduleclassmeetinginstructorResult)) { // Loop thru meeting days.
$instructors .= $prefix."'".$instructoryInfo['userId']."'";
$prefix = ',';
} // Loop thru meeting days.
} // Are there meeting days?
if ( $scheduleclassInfo['scheduleclassId'] < 10 ) { $sp = ' '; } else { $sp = ''; }
if ( $meetingInfo['scheduleclassmeetingBeginTime'] && $meetingInfo['scheduleclassmeetingBeginTime'] !== '00:00:00' ) {
$arranged = 'false';
$tdMinute = explode(':',$meetingInfo['scheduleclassmeetingBeginTime']);
$tdMinute = $tdMinute[0] * 60 + $tdMinute[1];
// subtract calendar begin time??? $tdMinute -= (int)( ( $_SESSION['user']['calendar_timebegin'] * 60 ) / $_SESSION['user']['calendar_timeincrement'] ) * $_SESSION['user']['calendar_timeincrement'];
$tdMinute = (int)$tdMinute;
} else {
$arranged = 'true';
$meetingInfo['scheduleclassmeetingBeginTime'] = '';
$meetingInfo['scheduleclassmeetingEndTime'] = '';
$tdMinute = 0;
}
$course = $ScheduleClassCourses[$scheduleclassInfo['scheduleclassId']];
$scheduleclassmeetingOnCampus = $meetingInfo['scheduleclassmeetingOnCampus'];
if ($scheduleclassmeetingOnCampus == '') { $scheduleclassmeetingOnCampus = '0'; }
$jsText .= "
".$classMeetingName."[".$scheduleclassInfo['scheduleclassId']."][".$meetingIndex."] ".$sp."= { scmId:'".$meetingInfo['scheduleclassmeetingId']."',".$sp2." sDate:'".$meetingInfo['scheduleclassmeetingStartDate']."', eDate:'".$meetingInfo['scheduleclassmeetingEndDate']."', arranged:".$arranged.", bTime:'".$meetingInfo['scheduleclassmeetingBeginTime']."', eTime:'".$meetingInfo['scheduleclassmeetingEndTime']."', onCampus:'".$scheduleclassmeetingOnCampus."', rooms:[";
$prefix = '';
foreach ( $meetingInfo['rooms'] as $roomId => $room ) {
$jsText .= $prefix."'".$room['buildingCode'].$room['roomNumber']."'";
$prefix = ',';
}
$jsText .= "], days:[".$weekdays."], instructors:[".$instructors."], tdMinute:".$tdMinute." };";
$meetingIndex++;
} // Loop thru class meetings.
} // Are there class meetings?
} // Loop thru schedule classes.
} // Are there schedule classes?
#if ( $DEBUG_js_write_Schedule_ClassMeeting ) d_Off(); // Use instead of t_End() for AJAX call.
unset($DEBUG_js_write_Schedule_ClassMeeting);
t_End(); // End TRACKing js_write_Schedule_ClassMeeting.phpinc.
?>