| 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/Admin/Advising/ParseClasses/ |
Upload File : |
<?
// Admin/Advising/ParseClasses/UpdateClasses.phpinc
// Update pclass data.
$d_O = d_O(); #d_On(); // Uncomment to DEBUG.
d_Line(basename(__FILE__),'bi');
d_Line('There are '.count($PCLASS).' classes','dbi');
d_Var('$PCLASS',$PCLASS);
// Set all classes for this YRTR to dropped.
$query = "
UPDATE `pclass`
SET IsDropped = 1
WHERE YRTR = '".query_safe($_SESSION['YRTR']['User'])."'
";
d_Var('pclassUPDATE',$query,'q');
$pclassUPDATE = query_do($query);
@d_Var('$pclassUPDATE',$pclassUPDATE);
if ( $trackCOU_ID ) {
$d_O = d_O(); d_On(); // Uncomment to DEBUG.
d_Line('PCLASS['.$PCLASScount.']: '.$PCLASS[$PCLASScount]['COU_ID'].' '.$PCLASS[$PCLASScount]['SUBJ'].$PCLASS[$PCLASScount]['NBR'].' '.$PCLASS[$PCLASScount]['TITLE'].'.','li');
if ( isset($d_O) && !$d_O ) d_Off();
}
foreach ( $PCLASS as $class ) { // Loop thru classes.
if ( $class['COU_ID'] == $trackCOU_ID ) {
$d_O = d_O(); d_On(); // Uncomment to DEBUG.
}
d_Var('$class',$class);
// Check for existing class.
$query = "
SELECT YRTR,
COU_ID
FROM `pclass`
WHERE YRTR = '".query_safe($_SESSION['YRTR']['User'])."'
AND COU_ID = '".query_safe($class['COU_ID'])."'
";
d_Var('pclassInfo',$query,'q');
$pclassInfo = query_info($query);
d_Var('$pclassInfo',$pclassInfo);
if ( $pclassInfo ) { // Is this an existing class?
// UPDATE pclass.
//if ( !isset($class['EMAX']) ) $class['EMAX'] = NULL;
$query = "
UPDATE `pclass`
SET SUBJ = '".query_safe($class['SUBJ'])."',
NBR = '".query_safe($class['NBR'])."',
SECT = '".query_safe($class['SECT'])."',
TITLE = '".query_safe($class['TITLE'])."',
CRHR = ".blankNULL($class['CRHR']).",
CRMAX = ".blankNULL($class['CRMAX']).",
INSTR_TYPE = '".query_safe($class['INSTR_TYPE'])."',
ENR = ".blankNULL($class['ENR']).",
EMAX = ".blankNULL($class['EMAX']).",
GRADE_METH = '".query_safe($class['GRADE_METH'])."',
COU_START = '".query_safe($class['COU_START'])."',
COU_END = '".query_safe($class['COU_END'])."',
campus = '".query_safe($class['campus'])."',
IsDropped = 0
WHERE YRTR = '".query_safe($_SESSION['YRTR']['User'])."'
AND COU_ID = '".query_safe($class['COU_ID'])."'
";
d_Var('pclassUPDATE',$query,'q');
$pclassUPDATE = query_do($query);
@d_Var('$pclassUPDATE',$pclassUPDATE);
} else { // Is this an existing class?
// INSERT pclass.
#if ( !isset($class['EMAX']) ) $class['EMAX'] = NULL;
$query = "
INSERT
INTO `pclass` (
YRTR,
COU_ID,
SUBJ,
NBR,
SECT,
TITLE,
CRHR,
CRMAX,
INSTR_TYPE,
ENR,
EMAX,
GRADE_METH,
COU_START,
COU_END,
campus,
IsDropped
) VALUES (
'".query_safe($_SESSION['YRTR']['User'])."',
'".query_safe($class['COU_ID'])."',
'".query_safe($class['SUBJ'])."',
'".query_safe($class['NBR'])."',
'".query_safe($class['SECT'])."',
'".query_safe($class['TITLE'])."',
".blankNULL($class['CRHR']).",
".blankNULL($class['CRMAX']).",
'".query_safe($class['INSTR_TYPE'])."',
".blankNULL($class['ENR']).",
".blankNULL($class['EMAX']).",
'".query_safe($class['GRADE_METH'])."',
'".query_safe($class['COU_START'])."',
'".query_safe($class['COU_END'])."',
'".query_safe($class['campus'])."',
IsDropped = 0
)
";
d_Var('pclassINSERT',$query,'q');
$pclassINSERT = query_do($query);
@d_Var('$pclassINSERT',$pclassINSERT);
#$pclassId = $_SESSION['qry']['insertId'];
} // Is this an existing class?
$d_O_Remember = d_O();
require('Admin/Advising/ParseClasses/UpdateClasses_Meetings.phpinc');
require('Admin/Advising/ParseClasses/UpdateClasses_Notes.phpinc');
if ( $d_O_Remember ) d_On(); $d_O = d_O();
#d_Var('d_O()',d_O(),'d');
if ( $class['COU_ID'] == $trackCOU_ID ) {
if ( isset($d_O) && !$d_O ) d_Off();
}
} // Loop thru classes.
function blankNULL($val) {
if ( $val == NULL || $val === '' ) $val = 'NULL';
return $val;
}
if ( isset($d_O) && !$d_O ) d_Off();
?>