| 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/admin/credential/ |
Upload File : |
<?
// admin/credential/credential_courses.phpinc
// Get required courses and courseList for credential.
t_Begin(); // Begin TRACKing new_phpinc.phpinc.
$courseList = array();
$courseCreditsTotal = 0;
$courseCreditsMaxTotal = 0;
$query = "
SELECT course.courseId
, departmentCode
, courseNumber
, courseYear
, courseCredits
, courseCreditsMax
FROM `course`
JOIN `department` ON department.departmentId = course.departmentId
JOIN credential_course ON credential_course.courseId = course.courseId AND credential_course.credentialId = ".$f['credentialId']."
WHERE course.courseId IN ( SELECT credential_course.courseId FROM credential_course WHERE credentialId = ".$f['credentialId']." )
ORDER BY courseYear, departmentCode, courseNumber, YRTR DESC
";
d_Var('credentialcourseResult',$query,'q');
$credentialcourseResult = query_do($query);
$credentialcourseCount = $GLOBALS['_QUERY']['count'];
d_Var('$credentialcourseResult',$credentialcourseResult);
if ( $credentialcourseCount ) {
$year = NULL;
query_seek($credentialcourseResult, 0);
while ($courseInfo = query_row($credentialcourseResult)) {
if ( $year != $courseInfo['courseYear'] ) {
$year = $courseInfo['courseYear'];
if ( !isset($courseList[$year]) ) $courseList[$year] = '';
}
if ( !listFind($courseList[$year], $courseInfo['departmentCode'].$courseInfo['courseNumber'], ' ') ) {
$courseList[$year] = listAppend($courseList[$year],$courseInfo['departmentCode'].$courseInfo['courseNumber'], ' ');
$courseCreditsTotal += $courseInfo['courseCredits'];
if ( !$courseInfo['courseCreditsMax'] ) {
$courseCreditsMaxTotal += $courseInfo['courseCredits'];
} else {
$courseCreditsMaxTotal += $courseInfo['courseCreditsMax'];
}
}
}
}
d_Var('$courseList',$courseList);
d_Var('$courseCreditsTotal',$courseCreditsTotal);
d_Var('$courseCreditsMaxTotal',$courseCreditsMaxTotal);
t_End(); // End TRACKing new_phpinc.phpinc.
?>