| 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/Schedule/ScheduleImportClasses/ |
Upload File : |
<?
// Schedule/ScheduleImportClasses/InsertNewClass.phpinc
// Import the new schedule class and INSERT into scheduleclass.
#$DEBUG_InsertNewClass = true;
#$DEBUG_InsertNewClass = false;
#if ( $_SESSION['userId'] == 0 ) $DEBUG_InsertNewClass = true; // DEBUG by userId.
if ( !isset($DEBUG_InsertNewClass) ) $DEBUG_InsertNewClass = d_O(); // DEBUG by passthrough.
#if ( !isset($DEBUG_InsertNewClass) ) $DEBUG_InsertNewClass = false; // Default false.
#if ( $DEBUG_InsertNewClass ) d_On(); // Use instead of t_Begin() for AJAX call.
t_Begin($DEBUG_InsertNewClass); // Begin TRACKing InsertNewClass.phpinc.
// INSERT the new class.
if ( is_null($thisCLASS['courseinsttypeId']) ) { $thisCLASS['courseinsttypeId'] = 'NULL'; }
$query = "
INSERT INTO `scheduleclass` (
scheduleId
, YRTR
, scheduleclassQId
, courseId
, scheduleclassEnr
, scheduleclassMax
, scheduleclassStartDate
, scheduleclassEndDate
, courseinsttypeId
, scheduleclassOnline
) VALUES (
".$_SESSION['user']['scheduleId']."
, '".query_safe($thisCLASS['YRTR'])."'
, '".query_safe($thisCLASS['scheduleclassQId'])."'
, ".$thisCLASS['courseId']."
, ".$thisCLASS['scheduleclassEnr']."
, ".$thisCLASS['scheduleclassMax']."
, '".query_safe($thisCLASS['scheduleclassStartDate'])."'
, '".query_safe($thisCLASS['scheduleclassEndDate'])."'
, ".$thisCLASS['courseinsttypeId']."
, ".$thisCLASS['scheduleclassOnline']."
)
";
d_Var('scheduleclassINSERT',$query,'q');
$scheduleclassINSERT = query_do($query);
d_Var('$scheduleclassINSERT',$scheduleclassINSERT,'l');
$f['scheduleclassId'] = $GLOBALS['_QUERY']['insertId'];
@d_Var("\$f['scheduleclassId']",$f['scheduleclassId']);
// INSERT the scheduleclasssection.
$query = "
INSERT INTO `scheduleclasssection` (
scheduleclassId
, scheduleclassSection
) VALUES (
".$f['scheduleclassId']."
, '".query_safe($thisCLASS['scheduleclassSection'])."'
)
";
d_Var('scheduleclasssectionINSERT',$query,'q');
$scheduleclasssectionINSERT = query_do($query);
d_Var('$scheduleclasssectionINSERT',$scheduleclasssectionINSERT,'l');
// INSERT scheduleclassmeetings.
foreach ( $thisCLASS['meeting'] as $thisMeeting ) { // Loop thru scheduleclassmeetings.
// INSERT scheduleclassmeeting.
if ( $thisMeeting['scheduleclassmeetingBeginTime'] == '' ) {
$thisMeeting['scheduleclassmeetingBeginTime'] = 'NULL';
$qcBeginTime = '';
} else {
$qcBeginTime = "'";
}
if ( $thisMeeting['scheduleclassmeetingEndTime'] == '' ) {
$thisMeeting['scheduleclassmeetingEndTime'] = 'NULL';
$qcEndTime = '';
} else {
$qcEndTime = "'";
}
$query = "
INSERT INTO `scheduleclassmeeting` (
scheduleclassId
, scheduleclassmeetingStartDate
, scheduleclassmeetingEndDate
, scheduleclassmeetingBeginTime
, scheduleclassmeetingEndTime
, scheduleclassmeetingOnCampus
) VALUES (
".$f['scheduleclassId']."
, '".query_safe($thisMeeting['scheduleclassmeetingStartDate'])."'
, '".query_safe($thisMeeting['scheduleclassmeetingEndDate'])."'
, ".$qcBeginTime.query_safe($thisMeeting['scheduleclassmeetingBeginTime']).$qcBeginTime."
, ".$qcEndTime.query_safe($thisMeeting['scheduleclassmeetingEndTime']).$qcEndTime."
, ".$thisMeeting['scheduleclassmeetingOnCampus']."
)
";
d_Var('scheduleclassmeetingINSERT',$query,'q/');
$scheduleclassmeetingINSERT = query_do($query);
d_Var('$scheduleclassmeetingINSERT',$scheduleclassmeetingINSERT,'l');
$f['scheduleclassmeetingId'] = $GLOBALS['_QUERY']['insertId'];
@d_Var("\$f['scheduleclassmeetingId']",$f['scheduleclassmeetingId']);
if ( count($thisMeeting['days']) ) {
// INSERT scheduleclassmeeting days.
foreach ( $thisMeeting['days'] as $thisDay ) { // Loop thru scheduleclassmeeting days.
// INSERT scheduleclassmeeting day.
$query = "
INSERT INTO `scheduleclassmeetingweekday` (
scheduleclassmeetingId
, weekdayId
) VALUES (
".$f['scheduleclassmeetingId']."
, ".$thisDay."
)
";
d_Var('scheduleclassmeetingweekdayINSERT',$query,'q/');
$scheduleclassmeetingweekdayINSERT = query_do($query);
d_Var('$scheduleclassmeetingweekdayINSERT',$scheduleclassmeetingweekdayINSERT,'l');
} // Loop thru scheduleclassmeeting days.
}
d_Var("count(\$thisMeeting['rooms'])",count($thisMeeting['rooms']));
if ( count($thisMeeting['rooms']) ) { // Are there scheduleclassmeeting rooms?
// INSERT scheduleclassmeeting rooms.
foreach ( $thisMeeting['rooms'] as $thisRoom ) { // Loop thru scheduleclassmeeting rooms.
d_Var('$thisRoom',$thisRoom);
if ( $thisRoom ) { // Is $thisRoom set?
// INSERT scheduleclassmeeting room.
$query = "
INSERT INTO `scheduleclassmeetingroom` (
scheduleclassmeetingId
, roomId
) VALUES (
".$f['scheduleclassmeetingId']."
, ".$thisRoom."
)
";
d_Var('scheduleclassmeetingroomINSERT',$query,'q');
$scheduleclassmeetingroomINSERT = query_do($query);
d_Var('$scheduleclassmeetingroomINSERT',$scheduleclassmeetingroomINSERT,'l');
} // Is $thisRoom set?
} // Loop thru scheduleclassmeeting rooms.
} // Are there scheduleclassmeeting rooms?
if ( count($thisMeeting['instructors']) ) { // Are there scheduleclassmeeting instructors?
// INSERT scheduleclassmeeting rooms.
foreach ( $thisMeeting['instructors'] as $thisInstructor ) { // Loop thru scheduleclassmeeting instructors.
d_Var('$thisInstructor',$thisInstructor);
$query = "
INSERT INTO `scheduleclassmeetinginstructor` (
scheduleclassmeetingId
, userId
) VALUES (
".$f['scheduleclassmeetingId']."
, ".$thisInstructor."
)
";
d_Var('scheduleclassmeetinginstructorINSERT',$query,'q');
$scheduleclassmeetinginstructorINSERT = query_do($query);
d_Var('$scheduleclassmeetinginstructorINSERT',$scheduleclassmeetinginstructorINSERT,'l');
} // Loop thru scheduleclassmeeting instructors.
} // Are there scheduleclassmeeting instructors?
} // Loop thru scheduleclassmeetings.
#if ( $DEBUG_InsertNewClass ) d_Off(); // Use instead of t_End() for AJAX call.
unset($DEBUG_InsertNewClass);
t_End(); // End TRACKing InsertNewClass.phpinc.
?>