| 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 : /nginx/html/Scheduler/admin/parse/ |
Upload File : |
<?
// parseProcess_Get_courseId.phpinc
// Get courseId.
t_Begin(); // Begin TRACKing parseProcess_Get_courseId.phpinc.
d_Var('$thisClass',$thisClass);
/** / // Now uses session YRTR insteal of max YRTR.
AND YRTR = (
SELECT max(YRTR)
FROM `course`
WHERE departmentId = ".$departmentId[$thisClass['departmentCode']]."
AND courseNumber = '".query_safe($thisClass['courseNumber'])."'
)
/**/
$query = "
SELECT courseId
FROM `course`
WHERE departmentId = ".$departmentId[$thisClass['departmentCode']]."
AND courseNumber = '".query_safe($thisClass['courseNumber'])."'
AND YRTR = ".$sessionInfo['YRTR']."
";
d_Var('courseInfo',$query,'q');
$courseInfo = query_info($query);
d_Var('$courseInfo',$courseInfo);
if ( $courseInfo ) { // Is this course in the database?
$thisClass['courseId'] = $courseInfo['courseId'];
} else { // Is this course in the database?
d_Var('$departmentId['.$thisClass['departmentCode'].']',$departmentId[$thisClass['departmentCode']]);
// Check for variable course credits.
#d_Var("is_numeric(\$thisClass['courseCredits'])",is_numeric($thisClass['courseCredits']),'d');
if ( is_numeric($thisClass['courseCredits']) ) {
$thisClass['courseCredits'] = $thisClass['courseCredits']+0;
$thisClass['courseCreditsMax'] = NULL;
} else {
//$thisClass['courseCredits'] = explode('-',$thisClass['courseCredits']);
$thisClass['courseCredits'] = NULL;//$thisClass['courseCredits'][0]+0;
$thisClass['courseCreditsMax'] = NULL;//$thisClass['courseCredits'][1]+0;
}
// INSERT course.
$query = "
INSERT INTO `course` (
userId
, YRTR
, departmentId
, courseNumber
, courseTitle";
if ( $thisClass['courseCredits'] !== NULL ) {
$query .= "
, courseCredits";
}
if ( $thisClass['courseCreditsMax'] !== NULL ) {
$query .= "
, courseCreditsMax";
}
$query .= "
) VALUES (
".$_SESSION['user']['trueId']."
, '".query_safe($sessionInfo['YRTR'])."'
, ".$departmentId[$thisClass['departmentCode']]."
, '".query_safe($thisClass['courseNumber'])."'
, '".query_safe($thisClass['courseTitle'])."'";
if ( $thisClass['courseCredits'] !== NULL ) {
$query .= "
, ".$thisClass['courseCredits'];
}
if ( $thisClass['courseCreditsMax'] !== NULL ) {
$query .= "
, ".$thisClass['courseCreditsMax'];
}
$query .= "
)
";
d_Var('courseINSERT',$query,'q');
$courseINSERT = query_do($query);
d_Var('$courseINSERT',$courseINSERT,'l');
$thisClass['courseId'] = $GLOBALS['_QUERY']['insertId'];
d_Var("\$thisClass['courseId']",$thisClass['courseId']);
?>
<article class="info">New <?=$thisClass['departmentCode']?><?=$thisClass['courseNumber']?> <?=$thisClass['courseTitle']?> course found on line <?=$thisClass['!line']?>.</article>
<?
} // Is this course in the database?
t_End(); // End TRACKing parseProcess_Get_courseId.phpinc.
?>