| 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/Course/ |
Upload File : |
<?
// Course/ScheduleLink.phpinc
// Generate the schedule link.
if (isset($CDN)) {
$f_courseNumber = $CDN[0].$CDN[1];
} else {
if ( !isset($f_courseNumber) ) $f_courseNumber = $courseNumber;
}
// Get the course information.
$query = "
SELECT
course.courseId,
course.userId,
course.courseNumber,
course.courseWebsite,
course.courseBase,
course.courseAssignments,
course.courseInstructionalGuide,
course.courseSchedule,
course.courseSyllabus,
course.courseInactive,
user.userFirstName,
user.userLastName,
user.userNickname,
course.courseResources,
CASE user.userNickname WHEN '' THEN user.userNickname ELSE user.userFirstName END AS preferredName
FROM course
LEFT JOIN user ON course.userId = user.userId
";
if ( isset($f_courseId) ) {
if ( strpos($f_courseId,',') !== false ) {
$query .= "
WHERE courseId IN ( ".$f_courseId." )";
} else {
$query .= "
WHERE courseId = ".$f_courseId;
}
} else {
$query .= "
WHERE courseNumber = '".$f_courseNumber."'
";
}
$query .= "
AND course.courseInactive = 0
ORDER BY preferredName,user.userLastName
";
$courseMenuResult = query_do($query);
$courseCount = $_SESSION['qry']['count'];
#if ( $courseMenu_DEBUG ) printVar('$courseCount',$courseCount);
#if ( $courseMenu_DEBUG ) printVar('$courseMenuResult',$courseMenuResult);
if ($courseCount) {
mysqli_data_seek($courseMenuResult, 0);
$courseMenuRow = mysqli_fetch_assoc($courseMenuResult);
#while ($courseMenuRow = mysqli_fetch_assoc($courseMenuResult)) {
#$f_courseId = $courseMenuRow['courseId'];
if ( $courseMenuRow['courseBase'] ) { $v_courseBase = $courseMenuRow['courseWebsite']; } else { $v_courseBase = ''; }
if ($courseMenuRow['courseInactive'] == 0 && ($courseMenuRow['courseWebsite'] != '' || $courseMenuRow['courseInstructionalGuide'] != '' || $courseMenuRow['courseSchedule'] != '' || $courseMenuRow['courseSyllabus'] != '')) {
// The file is on this server.
// Get a list of class section numbers.
$query = "
SELECT class.classId,
class.courseId,
class.YRTR,
class.RCclassId,
class.classSection,
class.modifiedBy,
courseNumber
FROM `class`
JOIN `course` ON course.courseId = class.courseId";
if ( strpos($f_courseId,',') !== false ) {
$query .= "
WHERE class.courseId IN ( ".$f_courseId." )";
} else {
$query .= "
WHERE class.courseId = ".$f_courseId;
}
$query .= "
AND class.YRTR = ".$_SESSION['YRTR']['User']."
ORDER BY courseNumber, classSection
";
#d_Var('$query',$query,'q',false,true);
$classSectionResult = query_do($query);
$classSectionResultCount = $_SESSION['qry']['count'];
#printDivVar('$classResult',$classResult);
if ($classSectionResultCount) {
// Search for files with -## section number extension.
// Explode the Schedule file name into dirname, basename, extension, and filename parts.
$pathinfo = pathinfo($courseMenuRow['courseSchedule']);
if ( $pathinfo['dirname'] == '.' ) { $pathinfo['dirname'] = ''; } else { $pathinfo['dirname'] .= '/'; }
if ( !isset($pathinfo['extension']) ) {
$pathinfo['extension'] = '';
} else {
$pathinfo['extension'] = '.'.$pathinfo['extension'];
}
#printVar('$pathinfo',$pathinfo);
// Determine where to find the schedule file.
#printVar('$courseMenuRow',$courseMenuRow);
if ( substr($courseMenuRow['courseSchedule'],0,1) != '/' ) {
if ( $courseMenuRow['courseBase'] ) {
// Use $_SESSION['DIRECTORY_ROOT'].$courseMenuRow['courseWebsite']
$dir = $_SESSION['DIRECTORY_ROOT'].$courseMenuRow['courseWebsite'];
#printVar('courseWebsite',$dir);
} else {
// Use dirname($_SERVER['SCRIPT_FILENAME'])
$dir = dirname($_SERVER['SCRIPT_FILENAME']).'/';
#printVar('SCRIPT_FILENAME',$dir);
}
} else {
// Use $_SESSION['DIRECTORY_ROOT']
$dir = $_SESSION['DIRECTORY_ROOT'];
}
#printVar('$dir',$dir);
// Initialize fileArray
$scheduleDayTimeArray = array();
$scheduleLinkArray = array();
$scheduleSectionArray = array();
$schedulecourseNumberArray = array();
$classSectionPrevious = 0;
mysqli_data_seek($classSectionResult, 0);
// Loop through class sections.
while ($classRow = mysqli_fetch_assoc($classSectionResult)) {
if ( $classRow['classSection'] != $classSectionPrevious ) {
#printVar('$classRow',$classRow);
$fileToFind = $dir.$pathinfo['filename'].'-'.$classRow['classSection'].$pathinfo['extension'];
#printVar('$fileToFind',$fileToFind);
if ( file_exists($fileToFind) ) {
$scheduleDayTimeArray[] = classDayTime($classRow['classId']);
$scheduleLinkArray[] = $pathinfo['dirname'].$pathinfo['filename'].'-'.$classRow['classSection'].$pathinfo['extension'];
$scheduleSectionArray[] = $classRow['classSection'];
$schedulecourseNumberArray[] = $classRow['courseNumber'];
}
#$classSectionPrevious = $classRow['classSection'];
}
}
#printVar('$scheduleLinkArray',$scheduleLinkArray);
}
#d_Var('scheduleLinkArray',$scheduleLinkArray,'d');
#d_Var('f_Schedule_Link',$f_Schedule_Link,'d');
#d_Var("\$courseMenuRow['courseSchedule']",$courseMenuRow['courseSchedule'],'d');
#d_Var("isCurrentPage(".$courseMenuRow['courseSchedule'].")",isCurrentPage($courseMenuRow['courseSchedule']),'d');
if ( !isset($scheduleLinkArray) || !count($scheduleLinkArray) ) {
// No Schedules found for different sections.
if (isCurrentPage($courseMenuRow['courseSchedule']) && $f_task == '') {
$f_Schedule_Link .= '<span class="menuCurrent" title="'.$courseMenuRow['courseNumber'].' Schedule.">Schedule</span>';
} else {
$this_Schedule_Link = '<a href="'.$v_courseBase.$courseMenuRow['courseSchedule'].'" title="'.$courseMenuRow['courseNumber'].' Schedule.">Schedule</a>';
if ( $this_Schedule_Link != $f_Schedule_Link ) {
if ( $f_Schedule_Link != '' ) $f_Schedule_Link .= ' ';
$f_Schedule_Link .= $this_Schedule_Link;
}
}
} else {
$f_Schedule_Link = '';
// Show links to the different sections.
#d_Var('$scheduleSectionArray',$scheduleSectionArray,'d');
#d_Var('scheduleLinkArray',$scheduleLinkArray,'d');
$f_Schedule_URL = array();
for ($index=0; $index<count($scheduleLinkArray); $index++) {
$thisTitle = "Schedule for ".$schedulecourseNumberArray[$index]." section ".$scheduleSectionArray[$index]." (".$scheduleDayTimeArray[$index].").";
$f_Schedule_URL[] = $v_courseBase.$scheduleLinkArray[$index];
if (isCurrentPage($scheduleLinkArray[$index]) && $f_task == '') {
$f_Schedule_Link .= ' <span class="menuCurrent" title="'.$thisTitle.'">-'.$scheduleSectionArray[$index].'</span>';
} else {
$f_Schedule_Link .= ' <a href="'.$v_courseBase.$scheduleLinkArray[$index].'" title="'.$thisTitle.'">-'.$scheduleSectionArray[$index].'</a>';
}
}
}
#d_Var('$f_Schedule_Link',$f_Schedule_Link,'d');
if ( $f_Schedule_Link == '' ) $f_Schedule_Link = '<span class="menuCurrent">Schedule</span>';
echo $f_Schedule_Link;
}
#}
}
?>