| 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/ScheduleImportClasses/ |
Upload File : |
<?
// Schedule/ScheduleImportClasses/ImportParsedClasses_NewClass.phpinc
// Import the new schedule class and INSERT into scheduleclass.
#$DEBUG_ImportParsedClasses_NewClass = true;
#if ( $_SESSION['gameId'] == 0 ) $DEBUG_ImportParsedClasses_NewClass = true; // DEBUG by gameId.
#if ( $_SESSION['userId'] == 0 ) $DEBUG_ImportParsedClasses_NewClass = true; // DEBUG by userId.
if ( !isset($DEBUG_ImportParsedClasses_NewClass) ) $DEBUG_ImportParsedClasses_NewClass = d_O(); // DEBUG by passthrough.
#if ( !isset($DEBUG_ImportParsedClasses_NewClass) ) $DEBUG_ImportParsedClasses_NewClass = false; // Default false.
#if ( $DEBUG_ImportParsedClasses_NewClass ) d_On(); // Use instead of t_Begin() for AJAX call.
t_Begin($DEBUG_ImportParsedClasses_NewClass); // Begin TRACKing ImportParsedClasses_NewClass.phpinc.
// Is this scheduleclass already in the database?
// No, Add the class to the schedule.
// Determine if the class is online or off campus. Note: classmeetingOnOff; NULL = neither, 1 = Online, 0 = Off Campus.
$query = "
SELECT classmeetingOnOff
FROM `classmeeting`
WHERE classId = ".$classInfo['classId']."
";
d_Var('classmeetingResult',$query,'q');
$classmeetingResult = query_do($query);
$classmeetingCount = $GLOBALS['_QUERY']['count'];
d_Var('$classmeetingResult',$classmeetingResult);
$classInfo['classOnline'] = 0;
if ( $classmeetingCount ) {
query_seek($classmeetingResult, 0);
while ($classmeetingInfo = query_row($classmeetingResult)) {
if ( (int)$classmeetingInfo['classmeetingOnOff'] === 1 ) $classInfo['classOnline'] = 1;
}
}
d_Var("\$classInfo['classOnline']",$classInfo['classOnline']);
// INSERT the scheduleclass.
$query = "
INSERT INTO `scheduleclass` (
scheduleId
, YRTR
, scheduleclassQId
, courseId
, scheduleclassEnr
, scheduleclassMax";
if ( $classInfo['YRTR'] == $scheduleInfo['YRTR'] ) {
$query .= "
, scheduleclassStartDate
, scheduleclassEndDate";
}
$query .= "
, scheduleclassOnline
) VALUES (
".$_SESSION['user']['scheduleId']."
, '".query_safe($scheduleInfo['YRTR'])."'
, ".$classInfo['classQId']."
, ".$classInfo['courseId']."
, ".$classInfo['classEnr']."
, ".$classInfo['classMax'];
if ( $classInfo['YRTR'] == $scheduleInfo['YRTR'] ) {
$query .= "
, '".query_safe($classInfo['classStartDate'])."'
, '".query_safe($classInfo['classEndDate'])."'";
}
$query .= "
, ".$classInfo['classOnline']."
)
";
d_Var('scheduleclassINSERT',$query,'q');
$scheduleclassINSERT = query_do($query);
$f['scheduleclassId'] = $GLOBALS['_QUERY']['insertId'];
@d_Var('$scheduleclassINSERT',$scheduleclassINSERT);
d_V('scheduleclassId');
// INSERT the scheduleclasssection.
$query = "
INSERT INTO `scheduleclasssection` (
scheduleclassId
, scheduleclassSection
) VALUES (
".$f['scheduleclassId']."
, '".query_safe($classInfo['classSection'])."'
)
";
d_Var('scheduleclasssectionINSERT',$query,'q');
$scheduleclasssectionINSERT = query_do($query);
d_Var('$scheduleclasssectionINSERT',$scheduleclasssectionINSERT,'l');
#if ( $DEBUG_ImportParsedClasses_NewClass ) d_Off(); // Use instead of t_End() for AJAX call.
unset($DEBUG_ImportParsedClasses_NewClass);
t_End(); // End TRACKing ImportParsedClasses_NewClass.phpinc.
?>