| 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/ScheduleClass/ |
Upload File : |
<?
// Schedule/ScheduleClass/ScheduleClassForm_Process.phpinc
// Process the scheduleclassmeeting form.
#$DEBUG_ScheduleClassForm_Process = true;
#$DEBUG_ScheduleClassForm_Process_No = true;
if ( !isset($DEBUG_ScheduleClassForm_Process_No) ) $DEBUG_ScheduleClassForm_Process_No = false;
if ( $DEBUG_ScheduleClassForm_Process_No ) $DEBUG_ScheduleClassForm_Process = true;
if ( !isset($DEBUG_ScheduleClassForm_Process) ) $DEBUG_ScheduleClassForm_Process = false;
t_Begin($DEBUG_ScheduleClassForm_Process); // Begin TRACKing included file.
#d_V(false,'d');
d_Var('$sessionInfo',$sessionInfo);
d_Var("\$f['uuid']",$f['uuid']);
d_Var("\$_SESSION['uuid']",$_SESSION['uuid']);
if ( false || $f['uuid'] != $_SESSION['uuid'] ) {
// Not a page reload.
//d_V(false,'d');
// scheduleclass table.
if ( $f['scheduleclassId'] ) {
// UPDATE scheduleclass.
$query = "
UPDATE `scheduleclass`
SET scheduleId = ".$f['scheduleId']."
, courseId = ".$f['courseId']."
, scheduleclassStartDate = '".query_safe($f['scheduleclassStartDate'])."'
, scheduleclassEndDate = '".query_safe($f['scheduleclassEndDate'])."'
, scheduleclassOnline = ".$f['scheduleclassOnline']."
WHERE scheduleclassId = ".$f['scheduleclassId']."
";
d_Var('scheduleclassUPDATE',$query,'q');
if ( !$DEBUG_ScheduleClassForm_Process_No ) $scheduleclassUPDATE = query_do($query);
@d_Var('$scheduleclassUPDATE',$scheduleclassUPDATE,'l');
// BEGIN UPDATE scheduleclasssection table.
// DELETE current scheduleclassSections.
$query = "
DELETE FROM `scheduleclasssection`
WHERE scheduleclassId = ".$f['scheduleclassId']."
";
d_Var('scheduleclasssectionDELETE',$query,'q');
$scheduleclasssectionDELETE = query_do($query);
d_Var('$scheduleclasssectionDELETE',$scheduleclasssectionDELETE,'l');
// INSERT each scheduleclassSection.
$scheduleclassSections = explode(',',$f['scheduleclassSection']);
$scheduleclassSectionsINSERTed = array();
foreach ( $scheduleclassSections as $scheduleclassSection ) {
if ( !in_array($scheduleclassSection,$scheduleclassSectionsINSERTed) ) {
$query = "
INSERT INTO `scheduleclasssection` (
scheduleclassId
, scheduleclassSection
) VALUES (
".$f['scheduleclassId']."
, '".query_safe(trim($scheduleclassSection))."'
)
";
#d_Var('scheduleclasssectionINSERT',$query,'q');
$scheduleclasssectionINSERT = query_do($query);
#d_Var('$scheduleclasssectionINSERT',$scheduleclasssectionINSERT,'l');
$scheduleclassSectionsINSERTed[] = $scheduleclassSection;
}
}
// END UPDATE scheduleclasssection table.
//displayMessage('Scheduleclass updated.');
$query = "
DELETE FROM `scheduleclassmeeting`
WHERE scheduleclassId = ".$f['scheduleclassId']."
";
d_Var('scheduleclassmeetingDELETE',$query,'q');
if ( !$DEBUG_ScheduleClassForm_Process_No ) $scheduleclassmeetingDELETE = query_do($query);
@d_Var('$scheduleclassmeetingDELETE',$scheduleclassmeetingDELETE,'l');
} else {
// INSERT scheduleclass.
$query = "
INSERT INTO `scheduleclass` (
scheduleId
, YRTR
, courseId
, scheduleclassStartDate
, scheduleclassEndDate
, scheduleclassOnline
) VALUES (
".$f['scheduleId']."
, '".query_safe($sessionInfo['YRTR'])."'
, ".$f['courseId']."
, '".query_safe($f['scheduleclassStartDate'])."'
, '".query_safe($f['scheduleclassEndDate'])."'
, ".$f['scheduleclassOnline']."
)
";
# , '".query_safe($f['scheduleclassSection'])."'
d_Var('scheduleclassINSERT',$query,'q');
if ( !$DEBUG_ScheduleClassForm_Process_No ) $scheduleclassINSERT = query_do($query);
@d_Var('$scheduleclassINSERT',$scheduleclassINSERT,'l');
$f['scheduleclassId'] = $GLOBALS['_QUERY']['insertId'];
@d_Var("\$f['scheduleclassId']",$f['scheduleclassId']);
// INSERT each scheduleclassSection.
$scheduleclassSections = explode(',',$f['scheduleclassSection']);
foreach ( $scheduleclassSections as $scheduleclassSection ) {
$query = "
INSERT INTO `scheduleclasssection` (
scheduleclassId
, scheduleclassSection
) VALUES (
".$f['scheduleclassId']."
, '".query_safe(trim($scheduleclassSection))."'
)
";
#d_Var('scheduleclasssectionINSERT',$query,'q');
$scheduleclasssectionINSERT = query_do($query);
#d_Var('$scheduleclasssectionINSERT',$scheduleclasssectionINSERT,'l');
}
//displayMessage('Scheduleclass added.');
}
foreach ( $f['scheduleclassmeetingIds'] as $scheduleclassmeetingId ) { // Loop thru scheduleclassmeetingIds.
// scheduleclassmeeting table.
// INSERT scheduleclassmeetings. $scheduleclassmeetingStartDate[243] == '2017-03-13'
$query = "
INSERT INTO `scheduleclassmeeting` (
scheduleclassId
, scheduleclassmeetingStartDate
, scheduleclassmeetingEndDate
, scheduleclassmeetingBeginTime
, scheduleclassmeetingEndTime
, scheduleclassmeetingOnCampus
) VALUES (
".$f['scheduleclassId']."
, '".query_safe($scheduleclassmeetingStartDate[$scheduleclassmeetingId])."'
, '".query_safe($scheduleclassmeetingEndDate[$scheduleclassmeetingId])."'
, '".query_safe($scheduleclassmeetingBeginTime[$scheduleclassmeetingId])."'
, '".query_safe($scheduleclassmeetingEndTime[$scheduleclassmeetingId])."'
, ".$f['scheduleclassmeetingOnCampus'][$scheduleclassmeetingId]."
)
";
d_Var('scheduleclassmeetingINSERT',$query,'q');
if ( !$DEBUG_ScheduleClassForm_Process_No ) $scheduleclassmeetingINSERT = query_do($query);
@d_Var('$scheduleclassmeetingINSERT',$scheduleclassmeetingINSERT,'l');
$f['scheduleclassmeetingId'] = $GLOBALS['_QUERY']['insertId'];
@d_Var("\$f['scheduleclassmeetingId']",$f['scheduleclassmeetingId']);
if ( $DEBUG_ScheduleClassForm_Process_No ) $f['scheduleclassmeetingId'] = 'DEBUG';
//displayMessage('Scheduleclassmeeting '.$f['scheduleclassmeetingStartDate'].' added.');
// INSERT scheduleclassmeetinginstructors.
foreach ( $f['instructorIds'][$scheduleclassmeetingId] as $instructorId ) {
$query = "
INSERT INTO `scheduleclassmeetinginstructor` (
scheduleclassmeetingId
, userId
) VALUES (
".$f['scheduleclassmeetingId']."
, ".$instructorId."
)
";
d_Var('scheduleclassmeetinginstructorINSERT',$query,'q');
if ( !$DEBUG_ScheduleClassForm_Process_No ) $scheduleclassmeetinginstructorINSERT = query_do($query);
@d_Var('$scheduleclassmeetinginstructorINSERT',$scheduleclassmeetinginstructorINSERT,'l');
}
// INSERT scheduleclassmeetingrooms.
if ( isset($f['roomIds'][$scheduleclassmeetingId]) && count($f['roomIds'][$scheduleclassmeetingId]) ) {
$query = "
INSERT INTO `scheduleclassmeetingroom` (
scheduleclassmeetingId
, roomId
)
VALUES";
$prefix = ' ';
foreach ( $f['roomIds'][$scheduleclassmeetingId] as $roomId ) {
$query .= "
".$prefix."(
".$f['scheduleclassmeetingId']."
, ".$roomId."
)";
$prefix = ',';
}
$query .= "
";
d_Var('scheduleclassmeetingroomINSERT',$query,'q');
if ( !$DEBUG_ScheduleClassForm_Process_No ) $scheduleclassmeetingroomINSERT = query_do($query);
@d_Var('$scheduleclassmeetingroomINSERT',$scheduleclassmeetingroomINSERT,'l');
}
// INSERT scheduleclassmeetingweekdays.
if ( count($f['weekdayIds'][$scheduleclassmeetingId]) ) {
$query = "
INSERT INTO `scheduleclassmeetingweekday` (
scheduleclassmeetingId
, weekdayId
)
VALUES";
$prefix = ' ';
foreach ( $f['weekdayIds'][$scheduleclassmeetingId] as $weekdayId ) {
$query .= "
".$prefix."(
".$f['scheduleclassmeetingId']."
, ".$weekdayId."
)";
$prefix = ',';
}
$query .= "
";
d_Var('scheduleclassmeetingweekdayINSERT',$query,'q');
if ( !$DEBUG_ScheduleClassForm_Process_No ) $scheduleclassmeetingweekdayINSERT = query_do($query);
@d_Var('$scheduleclassmeetingweekdayINSERT',$scheduleclassmeetingweekdayINSERT,'l');
}
} // Loop thru scheduleclassmeetingIds.
// Remember that the form was processed.
$_SESSION['uuid'] = $f['uuid'];
#} else {
// Page was reloaded.
# displayMessage('Page reloaded.','warn');
}
t_End(); // End TRACKing included file.
?>