| 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/displayScheduleClassDiv.phpinc
// Create a class div.
#$DEBUG_displayScheduleClassDiv = true;
if ( !isset($DEBUG_displayScheduleClassDiv) ) $DEBUG_displayScheduleClassDiv = false;
t_Begin($DEBUG_displayScheduleClassDiv); // Begin TRACKing displayScheduleClassDiv.phpinc.
if ( !isset($showOuterDiv) ) $showOuterDiv = true; // Normally true. Set to false by MoveClassMeetings.phpinc.
// BEGIN Get $ScheduleDaysVisible.
$ScheduleDaysVisible = '';
// Get weekdays.
require('site/get_weekdays.phpinc');
if ( $weekdayCount ) { // Are there weekdays?
query_seek($weekdayResult, 0);
while ($weekdayInfo = query_row($weekdayResult)) { // Loop thru weekdays.
if ( $weekdayInfo['weekdayNumber'] > 0 && $weekdayInfo['weekdayNumber'] < 6 ) { // Is this day in the work week?
$ScheduleDaysVisible .= $weekdayInfo['weekdayD'];
} // Is this day in the work week?
} // Loop thru weekdays.
} // Are there weekdays?
#d_Var('$ScheduleDaysVisible',$ScheduleDaysVisible,'d');
// END Get $ScheduleDaysVisible.
#d_Var('$scheduleclassInfo',$scheduleclassInfo,'d+');
// Get course info.
$totalClassMeetingsDays = 0;
$query = "
SELECT courseId
, userId
, departmentCode
, courseNumber
, courseTitle
, courseShortTitle
, courseCredits
, courseCreditsMax
, courseLecture
, courseLab
, courseOther
FROM `course`
JOIN `department` ON department.departmentId = course.departmentId
WHERE courseId = ".$scheduleclassInfo['courseId']."
";
d_Var('courseInfo',$query,'q');
$courseInfo = query_info($query);
d_Var('$courseInfo',$courseInfo,'');
require('Schedule/GetScheduleClassMeeting.phpinc'); // Get meetings.
d_Var('$scheduleclassmeetingResult',$scheduleclassmeetingResult,'');
if ( $scheduleclassmeetingCount ) { // Are there class meetings?
// Check for class meetings that are on the calendar.
$totalClassMeetingsOnTheCalendar = 0;
$OffCampus = false;
query_seek($scheduleclassmeetingResult, 0);
while ( $scheduleclassmeetingInfo = query_row($scheduleclassmeetingResult) ) { // Loop thru class meetings.
if ( $scheduleclassmeetingInfo['scheduleclassmeetingOnCampus'] != '' && $scheduleclassmeetingInfo['scheduleclassmeetingOnCampus'] == 0 ) {
$OffCampus = true;
}
#d_Var($courseInfo['courseNumber'].' $scheduleclassmeetingInfo',$scheduleclassmeetingInfo,'d');
if ( $scheduleclassmeetingInfo['scheduleclassmeetingBeginTime']
&& ( $scheduleclassmeetingInfo['scheduleclassmeetingBeginTime'] != '00:00:00'
|| ( $scheduleclassmeetingInfo['scheduleclassmeetingBeginTime'] == '00:00:00'
&& $scheduleclassmeetingInfo['scheduleclassmeetingBeginTime'] != $scheduleclassmeetingInfo['scheduleclassmeetingEndTime'] )
)
) { // Is this meeting on the calendar? NOTE: This code does not take into account if the meeting will actually be visible. The meeting may be on a day not displayed or a time BEFORE or AFTER the schedule displayed.
// Get meeting days.
$query = "
SELECT weekdayD
FROM `scheduleclassmeetingweekday`
JOIN `weekday` ON weekday.weekdayId = scheduleclassmeetingweekday.weekdayId
WHERE scheduleclassmeetingId = ".$scheduleclassmeetingInfo['scheduleclassmeetingId']."
ORDER BY weekday.weekdayNumber
";
d_Var('scheduleclassmeetingscheduleclassmeetingweekdayResult',$query,'q');
$scheduleclassmeetingweekdayResult = query_do($query);
$scheduleclassmeetingweekdayCount = $GLOBALS['_QUERY']['count'];
$totalClassMeetingsDays += $scheduleclassmeetingweekdayCount;
#d_Var($courseInfo['courseNumber'].' $scheduleclassmeetingweekdayResult',$scheduleclassmeetingweekdayResult,'d');
#d_Var($courseInfo['courseNumber'].' $scheduleclassmeetingweekdayCount',$scheduleclassmeetingweekdayCount,'d');
if ( $scheduleclassmeetingweekdayCount ) { // Are there meeting days?
query_seek($scheduleclassmeetingweekdayResult, 0);
while ( $scheduleclassmeetingweekdayInfo = query_row($scheduleclassmeetingweekdayResult) ) { // Loop thru meeting days.
if ( stripos($ScheduleDaysVisible,$scheduleclassmeetingweekdayInfo['weekdayD']) !== false ) { // Is this day not vivible?
$totalClassMeetingsOnTheCalendar++;
} // Is this day not vivible?
} // Loop thru meeting days.
} // Are there meeting days?
} // Is this meeting on the calendar?
} // Loop thru class meetings.
#d_Var($courseInfo['courseNumber'].' $totalClassMeetingsOnTheCalendar',$totalClassMeetingsOnTheCalendar,'d');
#d_Var($courseInfo['courseNumber'].' $totalClassMeetingsDays',$totalClassMeetingsDays,'d');
query_seek($scheduleclassmeetingResult, 0);
while ( $scheduleclassmeetingInfo = query_row($scheduleclassmeetingResult) ) { // Loop thru class meetings.
if ( $scheduleclassmeetingInfo['scheduleclassmeetingBeginTime'] ) {
$timeParts = explode(':',$scheduleclassmeetingInfo['scheduleclassmeetingBeginTime']);
$beginMinutes = (int)( $timeParts[0] * 60 + $timeParts[1] );
$tdMinutes = (int)($beginMinutes);
$timeParts = explode(':',$scheduleclassmeetingInfo['scheduleclassmeetingEndTime']);
$endMinutes = (int)( $timeParts[0] * 60 + $timeParts[1] );
} else {
$beginMinutes = 0;
$tdMinutes = 0;
$endMinutes = 0;
}
// Get meeting rooms.
$query = "
SELECT scheduleclassmeetingId
, room.roomId
, roomNumber
, buildingCode
, campusName
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 = ".$scheduleclassmeetingInfo['scheduleclassmeetingId']."
ORDER BY campusName, buildingCode, IF ( roomNumber REGEXP ('^[0-9]') ,10000 + roomNumber,roomNumber), roomNumber
";
d_Var('scheduleclassmeetingroomResult',$query,'q');
$scheduleclassmeetingroomResult = query_do($query);
$scheduleclassmeetingroomCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingroomResult',$scheduleclassmeetingroomResult);
$scheduleclassmeetingInfo['rooms'] = array();
if ( $scheduleclassmeetingroomCount ) {
query_seek($scheduleclassmeetingroomResult, 0);
while ($scheduleclassmeetingroomInfo = query_row($scheduleclassmeetingroomResult)) {
$scheduleclassmeetingInfo['rooms'][$scheduleclassmeetingroomInfo['roomId']]['buildingCode'] = str_replace('MAINHU','',$scheduleclassmeetingroomInfo['buildingCode']);
$scheduleclassmeetingInfo['rooms'][$scheduleclassmeetingroomInfo['roomId']]['roomNumber'] = $scheduleclassmeetingroomInfo['roomNumber'];
$scheduleclassmeetingInfo['rooms'][$scheduleclassmeetingroomInfo['roomId']]['Campus'] = $scheduleclassmeetingroomInfo['campusName'];
}
}
#d_Var("\$scheduleclassmeetingInfo['rooms']",$scheduleclassmeetingInfo['rooms'],'d');
$scheduleclassmeetingInfo['roomList'] = '';
$scheduleclassmeetingInfo['campusList'] = '';
foreach ( $scheduleclassmeetingInfo['rooms'] as $roomId => $room ) {
$scheduleclassmeetingInfo['roomList'] = listAppend($scheduleclassmeetingInfo['roomList'],$room['buildingCode'].$room['roomNumber']);
if ( !strstr($scheduleclassmeetingInfo['campusList'],$room['Campus']) ) $scheduleclassmeetingInfo['campusList'] .= $room['Campus'];
}
#d_Var("\$scheduleclassmeetingInfo['roomList']",$scheduleclassmeetingInfo['roomList'],'d');
// Get the instructor names.
$query = "
SELECT CONCAT(IFNULL(userNickname,userFirstname),IF (ISNULL(userMiddlename),'',CONCAT(' ',userMiddlename)),IF (ISNULL(userLastname),'',CONCAT(' ',userLastname))) AS instructorName
FROM `user`
JOIN `user_department` ON user_department.userId = user.userId
JOIN `scheduleclassmeetinginstructor` ON scheduleclassmeetinginstructor.userId = user.userId
WHERE userInactive = 0
AND user_department.departmentId = ".$scheduleInfo['departmentId']."
AND scheduleclassmeetinginstructor.scheduleclassmeetingId = ".$scheduleclassmeetingInfo['scheduleclassmeetingId']."
ORDER BY instructorName
";
d_Var('instructorResult',$query,'q');
$instructorResult = query_do($query);
$instructorCount = $GLOBALS['_QUERY']['count'];
$instructorList = query_to_list($instructorResult);
d_Var('$instructorList',$instructorList,'');
// Get meeting days.
$query = "
SELECT weekdayD
FROM `scheduleclassmeetingweekday`
JOIN `weekday` ON weekday.weekdayId = scheduleclassmeetingweekday.weekdayId
WHERE scheduleclassmeetingId = ".$scheduleclassmeetingInfo['scheduleclassmeetingId']."
ORDER BY weekday.weekdayNumber
";
d_Var('scheduleclassmeetingscheduleclassmeetingweekdayResult',$query,'q');
$scheduleclassmeetingweekdayResult = query_do($query);
$scheduleclassmeetingweekdayCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingweekdayResult',$scheduleclassmeetingweekdayResult);
d_Var(' $scheduleclassmeetingweekdayCount',$scheduleclassmeetingweekdayCount);
$weekdays = '';
//$prefix = ''; // un-needed jfm
if ( $scheduleclassmeetingweekdayCount ) {
query_seek($scheduleclassmeetingweekdayResult, 0);
while ( $weekdayInfo = query_row($scheduleclassmeetingweekdayResult) ) { // Loop thru meeting days.
$weekdays .= $weekdayInfo['weekdayD'];
}
}
// Create div content.
query_seek($scheduleclassmeetingweekdayResult, 0);
$dayNumber = 0;
$doOneTime = true;
while ( ( $weekdayInfo = query_row($scheduleclassmeetingweekdayResult) ) || $doOneTime ) { // Loop thru meeting days.
if ( !$weekdayCount ) { $weekdayInfo['weekdayD'] = 'A'; }
#d_Var('$weekdayInfo',$weekdayInfo,'d');
$doOneTime = false;
$dayNumber++;
$div_innetHTML = "";
$div_innetHTML .= '<div class="relative inside">';
if ( $OffCampus ) {
$div_innetHTML .= '<div class="offcampus float_right small">OFF</div>';
}
if ( $scheduleclassInfo['scheduleclassOnline'] ) {
$div_innetHTML .= '<div class="online float_right small">ON</div>';
}
// Course number and sections.
$div_innetHTML .= $courseInfo['departmentCode'].$courseInfo['courseNumber'];
$div_innetHTML .= ' ';
$div_innetHTML .= '<span class="nowrap">'.'- '.$scheduleclassInfo['scheduleclassSection'].'</span>';
// Credits.
$cr = $courseInfo['courseCredits']+0;
$crMax = $courseInfo['courseCreditsMax']+0;
$div_innetHTML .= " ";
$div_innetHTML .= '<span class="nowrap">'.$cr; if ( $crMax ) { $div_innetHTML .= "-".$crMax; } $div_innetHTML .= 'cr'.'</span>';
// Course title.
$div_innetHTML .= "<br>";
$div_innetHTML .= $courseInfo['courseTitle'];
// Days.
$div_innetHTML .= "<br>";
$div_innetHTML .= '<span id="days_'.$scheduleclassmeetingInfo['scheduleclassmeetingId'].'_'.$dayNumber.'">'.$weekdays.'</span>';
// Times.
$meetingBeginTime = valid_time($scheduleclassmeetingInfo['scheduleclassmeetingBeginTime'],'US');
$meetingEndTime = valid_time($scheduleclassmeetingInfo['scheduleclassmeetingEndTime'],'US');
if ( $meetingBeginTime.$meetingEndTime ) {
$div_innetHTML .= ' <span id="bTime_'.$scheduleclassmeetingInfo['scheduleclassmeetingId'].'_'.$dayNumber.'">'.$meetingBeginTime.'</span>';
$div_innetHTML .= '-<span id="eTime_'.$scheduleclassmeetingInfo['scheduleclassmeetingId'].'_'.$dayNumber.'">'.$meetingEndTime.'</span>';
} else {
$div_innetHTML .= ' <span id="bTime_'.$scheduleclassmeetingInfo['scheduleclassmeetingId'].'_'.$dayNumber.'">'.'</span>';
$div_innetHTML .= 'Arranged<span id="eTime_'.$scheduleclassmeetingInfo['scheduleclassmeetingId'].'_'.$dayNumber.'">'.'</span>';
}
// Rooms.
if ( $scheduleclassmeetingInfo['scheduleclassmeetingOnCampus'] ) { // Is the class on campus?
$div_innetHTML .= "<br>";
if ( listLen($scheduleclassmeetingInfo['roomList']) > 0 ) {
$div_innetHTML .= "rm";
if ( listLen($scheduleclassmeetingInfo['roomList']) > 1 ) {
$div_innetHTML .= "s";
}
$div_innetHTML .= " ".listAnd(listSort($scheduleclassmeetingInfo['roomList']));
} else {
$div_innetHTML .= 'no room';
}
$div_innetHTML .= '.';
} // Is the class on campus?
// Instructors.
$div_innetHTML .= "<br>";
$div_innetHTML .= listAnd($instructorList);
// Start and end dates.
$div_innetHTML .= "<br>";
$div_innetHTML .= valid_date($scheduleclassmeetingInfo['scheduleclassmeetingStartDate'],'US').'-'.valid_date($scheduleclassmeetingInfo['scheduleclassmeetingEndDate'],'US');
// BEGIN debug text.
// scheduleclassId.
$div_innetHTML .= "<br>";
$div_innetHTML .= "scId:".$scheduleclassInfo['scheduleclassId']." ";
// scheduleclassmeetingId.
$div_innetHTML .= " scmId:".$scheduleclassmeetingInfo['scheduleclassmeetingId']." ";
// courseId.
//$div_innetHTML .= "<br>";
$div_innetHTML .= " courseId:".$courseInfo['courseId']." ";
// Qid
$div_innetHTML .= "<br>";
//$div_innetHTML .= "QId:".$scheduleclassInfo['scheduleclassQId']." ";
// END debug text.
// Campus / city logo.
if (!isset($weekdayInfo['weekdayD']) || !$weekdayInfo['weekdayD']) {
$weekdayInfo['weekdayD'] = "";
}
$div_innetHTML .=
'<div id="campus_'.$scheduleclassInfo['scheduleclassId']
.'_'
.$weekdayInfo['weekdayD']
.'_'.$scheduleclassmeetingInfo['campusList']
.'" class="campus '
.$scheduleclassmeetingInfo['campusList']
.'">'
# BEGIN Remove when css is fixed.
/** /
.'<img src="'
.$_SESSION['ROOT']['http']
.'/images/'
.$scheduleclassmeetingInfo['campusList']
.'_40_21.png">'
/**/
# END Remove when css is fixed.
.'</div>';
$div_innetHTML .= "</div>";
#d_Var('$totalClassMeetingsDays',$totalClassMeetingsDays ,'d');
if ( $totalClassMeetingsDays ) {
#d_Var('$totalClassMeetingsOnTheCalendar',$totalClassMeetingsOnTheCalendar ,'d');
#d_Var("( stripos(\$ScheduleDaysVisible,\$weekdayInfo['weekdayD']) !== false )",( stripos($ScheduleDaysVisible,$weekdayInfo['weekdayD']) !== false ), 'd');
if ( stripos($ScheduleDaysVisible,$weekdayInfo['weekdayD']) !== false ) { // Is this day vivible?
$divClass = 'calendar_class';
$ScheduleInstructions = 'ScheduleInstructions_class';
} else {
if ( $totalClassMeetingsDays == $totalClassMeetingsOnTheCalendar ) {
$divClass = 'calendar_hidden';
$ScheduleInstructions = 'null';
} else {
$divClass = 'calendar_arranged';
$ScheduleInstructions = 'ScheduleInstructions_arranged';
}
} // Is this day not vivible?
} else {
$divClass = 'calendar_arranged';
$ScheduleInstructions = 'ScheduleInstructions_arranged';
}
?>
<? if ( $showOuterDiv ) { ?>
<div id="calendar_class_<?=$scheduleclassInfo['scheduleclassId']?>_<?=$weekdayInfo['weekdayD']?><?=$tdMinutes?>" class="<?=$divClass?> <?=$scheduleclassmeetingInfo['campusList']?>" onmouseover="ttLoad(this, '', <?=$ScheduleInstructions?>, '', true);" onmouseout="ttHide();"><? } ?><?=$div_innetHTML?><? if ( $showOuterDiv ) { ?></div>
<? } ?>
<?
} // Loop thru meeting days.
} // Loop thru class meetings.
} // Are there class meetings?
unset($showOuterDiv);
unset($DEBUG_displayScheduleClassDiv);
t_End(); // End TRACKing displayScheduleClassDiv.phpinc.
?>