| 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/Admin/Advising/ParseClasses/parse/ |
Upload File : |
<?
// Admin/Admin/Advising/ParseClasses/parse/parse21.phpinc
// Parse first class line.
$d_O = d_O(); #d_On(); // Uncomment to DEBUG.
d_Line(basename(__FILE__));
d_Var($index.': $ln',$ln); d_Var('$lnAsize',$lnAsize); d_Var('$lnA',$lnA);
$class['COU_ID'] = $lnA[0];
$class['SUBJ'] = $lnA[1];
$class['NBR'] = $lnA[2];
$class['SECT'] = $lnA[3];
$class['TITLE'] = trim(substr($ln,24,28));
$class['campus'] = $campus;
if ( $showParsing || $class['COU_ID'] == $trackCOU_ID ) {
d_On(); // Uncomment to DEBUG.
d_Var($index.': $ln',$ln); d_Var('$lnAsize',$lnAsize); d_Var('$lnA',$lnA);
d_Line($index.': '.$class['COU_ID'].' '.$class['SUBJ'].$class['NBR'].' '.$class['TITLE'].'.','li');
if ( isset($d_O) && !$d_O ) d_Off();
}
$class['CRHR'] = (int)trim(substr($ln,53,10));
if ( stripos($class['CRHR'],'-') !== false ) { // Is this a variable credit class?
$class['CRMAX'] = explode('-',$class['CRHR']);
$class['CRHR'] = (int)$class['CRMAX'][0];
$class['CRMAX'] = (int)$class['CRMAX'][1];
} else {
$class['CRMAX'] = 0;
}
$class['INSTR_TYPE'] = trim(substr($ln,64,13));
$class['ENR'] = trim(substr($ln,76,5));
$class['EMAX'] = trim(substr($ln,83,5));
d_Var('$class',$class);
#d_Var("\$class['EMAX']",$class['EMAX'],'d');
if ( $find_departmentCode ) { // Are we looking for a departmentCode?
// Check for an existing department with this code.
$query = "
SELECT departmentId,
departmentCode,
departmentName,
lastModified,
modifiedBy
FROM `department`
WHERE departmentCode = '".query_safe($class['SUBJ'])."'
";
d_Var('departmentInfo',$query,'q');
$departmentInfo = query_info($query);
d_Var('$departmentInfo',$departmentInfo);
if ( !$departmentInfo ) { // Is this a new department?
$department['Code'] = $class['SUBJ'];
// INSERT the new department.
d_On(); d_Line('Inserting new department '.$department['Code'].' '.$department['Name'].'.','lw'); if ( isset($d_O) && !$d_O ) d_Off();
$f_lastModified = currentDateTime();
$query = "
INSERT
INTO `department` (
departmentCode,
departmentName,
lastModified,
modifiedBy
) VALUES (
'".query_safe($department['Code'])."',
'".query_safe($department['Name'])."',
'".query_safe($f_lastModified)."',
".$_SESSION['trueuserId']."
)
";
d_Var('departmentINSERT',$query,'q');
$departmentINSERT = query_do($query);
@d_Var('$departmentINSERT',$departmentINSERT);
} else if ( $department['Name'] != $departmentInfo['departmentName'] ) {
// departmentName has changed.
$department['Code'] = $class['SUBJ'];
d_On(); d_Line('Department '.$department['Code'].' name changed to ['.$department['Name'].'].','lw'); if ( isset($d_O) && !$d_O ) d_Off();
$f_lastModified = currentDateTime();
$query = "
UPDATE `department`
SET departmentName = '".query_safe($department['Name'])."',
lastModified = '".query_safe($f_lastModified)."',
modifiedBy = ".$_SESSION['trueuserId']."
WHERE departmentCode = '".query_safe($department['Code'])."'
";
d_Var('departmentUPDATE',$query,'q');
$departmentUPDATE = query_do($query);
@d_Var('$departmentUPDATE',$departmentUPDATE);
} // Is this a new department?
$find_departmentCode = false;
}
set_state(22); // Parse second class line.
if ( isset($d_O) && !$d_O ) d_Off();
?>