| 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_Course.phpinc
// Set js variables needed for schedule management.
echo "
// BEGIN FILE ".basename(__FILE__)." ".currentDateTime().".";
t_Begin(); // Begin TRACKing js_write_Schedule.phpinc.
$jsText .= "
console.log('%c\t\t".basename(__FILE__)."','background-color:#000; color: #ccc;');";
// BEGIN Course.
// Create $Courses array and define js Course{} object.
// Course[courseId] = { Id:courseId, Dept:'departmentCode', Number:'courseNumber',Title:'courseTitle', Cr:'courseCredits', CrMax:'courseCreditsMax', credentials:[{Id:credentialId, Yr:'courseYear'}]
// credentials:[] is an array of credentialIds and courseYears.
$Courses = []; // Course information.
// Get courses. Currently gets inactive courses
$query = "
SELECT courseId
, departmentCode
, courseNumber
, courseTitle
, courseCredits
, courseCreditsMax
, YRTR
FROM `course`
JOIN department ON department.departmentId = course.departmentId
WHERE department.departmentId = ".$scheduleInfo['departmentId']."
ORDER BY departmentCode, courseNumber
";
// Include the line below in the query to exclude inactive courses.
// AND courseInactive = 0
d_Var('courseIdResult',$query,'q');
$courseIdResult = query_do($query);
$courseIdCount = $_QUERY['count'];
d_Var('$courseIdResult',$courseIdResult);
// Begin the Course{} object.
$jsText .= "\n"."
var Course = {}; // Courses offered by this department.";
if ( $courseIdCount ) {
query_seek($courseIdResult, 0);
while ($courseIdInfo = query_row($courseIdResult)) { // Loop thru the courses.
if ( !$courseIdInfo['courseCreditsMax'] ) $courseIdInfo['courseCreditsMax'] = 0;
$Courses[$courseIdInfo['courseId']] = $courseIdInfo['departmentCode'].$courseIdInfo['courseNumber'];
$jsText .= '
Course["'.$courseIdInfo['courseId'].'"] = { Id:"'.$courseIdInfo['courseId'].'", Dept:"'.$courseIdInfo['departmentCode'].'", Number:"'.$courseIdInfo['courseNumber'].'", Title:"'.$courseIdInfo['courseTitle'].'", Cr:'.(int)$courseIdInfo['courseCredits'].', YRTR:"'.(int)$courseIdInfo['YRTR'].'", CrMax:'.(int)$courseIdInfo['courseCreditsMax'].', credentials:[ ';
// Get credentialIds and courseYears.
$query = "
SELECT credentialId
, courseYear
FROM `credential_course`
WHERE courseId = ".$courseIdInfo['courseId']."
";
d_Var('credential_courseResult',$query,'q');
$credential_courseResult = query_do($query);
$credential_courseCount = $GLOBALS['_QUERY']['count'];
d_Var('$credential_courseResult',$credential_courseResult);
if ( $credential_courseCount ) { // Is this course used by credentials?
query_seek($credential_courseResult, 0);
$prefix = '';
while ($credential_courseInfo = query_row($credential_courseResult)) { // Loop thru credentials that use this course.
$jsText .= $prefix.'{Id:'.$credential_courseInfo['credentialId'].', Yr:'.$credential_courseInfo['courseYear'].'}'; // Add this credential to the array.
$prefix = ', ';
} // Loop thru credentials that use this course.
} // Is this course used by credentials?
$jsText .= ' ] };';
} // Loop thru the courses.
}
// CourseIds.
// Define the CourseIds[] array.
$jsText .= "\n"."
var CourseIds = [ ";
if ( $courseIdCount ) {
query_seek($courseIdResult, 0);
$prefix = '';
while ($courseIdInfo = query_row($courseIdResult)) {
$optionText = $courseIdInfo['courseId'];
$jsText .= $prefix.'"'.$optionText.'"';
$prefix = ', ';
}
}
$jsText .= " ]; // Course Ids offered by this department.";
// END Course.
echo "
// END FILE ".basename(__FILE__)."
";
t_End(); // End TRACKing js_write_Schedule.phpinc.
?>