| 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/ScheduleClassUpdate/ |
Upload File : |
<?
// Schedule/ScheduleClass/ScheduleClassUpdate/MoveClassMeeting.phpinc
// Handle the MoveClassMeeting task.
if ( !isset($DEBUG_MoveClassMeeting) ) { $DEBUG_MoveClassMeeting = false; }
if ( $DEBUG_MoveClassMeeting ) { $f['DEBUG'] = 1; }
t_Begin($DEBUG_MoveClassMeeting); // Begin TRACKing MoveClassMeeting.
if ( !is_null($pageHeaderCall) ) d_On();
#echo 'hello';
#return;
f('scId');
f('scmId');
f('bTime');
f('eTime');
f('days');
if ( $f['DEBUG'] ) {
?>
<h1><?=__FILE__?></h1>
<?
d_V();
}
// Verify scId (scheduleclassId).
$query = "
SELECT *
FROM `scheduleclass`
WHERE scheduleclassId = ".$f['scId']."
";
d_Var('scheduleclassInfo',$query,'q');
$scheduleclassInfo = query_info($query);
d_Var('$scheduleclassInfo',$scheduleclassInfo,'+');
// Get scheduleclassSections.
$query = "SELECT scheduleclassSection FROM `scheduleclasssection` WHERE scheduleclassId = ".$f['scId']." ORDER BY scheduleclassSection";
d_Var('scheduleclasssectionResult',$query,'q');
$scheduleclasssectionResult = query_do($query);
$scheduleclasssectionCount = $GLOBALS['_QUERY']['count'];
$scheduleclassInfo['scheduleclassSection'] = query_to_list($scheduleclasssectionResult);
// Verify scmId (scheduleclassmeetingId).
$scheduleclassmeetingInfo = false;
if ( $scheduleclassInfo ) {
$query = "
SELECT *
FROM `scheduleclassmeeting`
WHERE scheduleclassmeetingId = ".$f['scmId']."
";
d_Var('scheduleclassmeetingInfo',$query,'q');
$scheduleclassmeetingInfo = query_info($query);
d_Var('scheduleclassmeetingInfo',$scheduleclassmeetingInfo,'+');
}
// Verify days.
$daysOK = false;
if ( $scheduleclassInfo && $scheduleclassmeetingInfo ) {
$daysOK = true;
$days = str_split($f['days']);
d_Var('$days',$days);
$weekdayIds = array();
foreach ($days as $weekdayD) { // Loop thru days.
// Get the weekdayId.
$query = "
SELECT weekdayId
FROM `weekday`
WHERE weekdayD = '".query_safe($weekdayD)."'
";
d_Var('weekdayInfo',$query,'q');
$weekdayInfo = query_info($query);
d_Var('$weekdayInfo',$weekdayInfo,'+');
if ( $weekdayInfo ) {
$weekdayIds[] = $weekdayInfo['weekdayId'];
} else {
$daysOK = false;
}
} // Loop thru days.
}
if ( !$scheduleclassInfo || !$scheduleclassmeetingInfo || !$daysOK ) {
// Verify failed.
echo 'Verify failed.';
return;
}
// UPDATE scheduleclassmeeting.
$query = "
UPDATE `scheduleclassmeeting`
SET scheduleclassmeetingBeginTime = '".query_safe($f['bTime'])."'
, scheduleclassmeetingEndTime = '".query_safe($f['eTime'])."'
WHERE scheduleclassmeetingId = ".$f['scmId']."
";
d_Var('scheduleclassmeetingUPDATE',$query,'q+');
if ( !$f['DEBUG'] ) $scheduleclassmeetingUPDATE = query_do($query);
@d_Var('$scheduleclassmeetingUPDATE',$scheduleclassmeetingUPDATE,'l');
// DELETE current scheduleclassmeetingweekday.
$query = "
DELETE FROM `scheduleclassmeetingweekday`
WHERE scheduleclassmeetingId = ".$f['scmId']."
";
d_Var('scheduleclassmeetingweekdayDELETE',$query,'q+');
if ( !$f['DEBUG'] ) $scheduleclassmeetingweekdayDELETE = query_do($query);
@d_Var('$scheduleclassmeetingweekdayDELETE',$scheduleclassmeetingweekdayDELETE,'l');
// INSERT days.
foreach ( $weekdayIds as $weekdayId ) { // Loop thru weekdayIds
$query = "
INSERT INTO `scheduleclassmeetingweekday` (
scheduleclassmeetingId
, weekdayId
) VALUES (
".$f['scmId']."
, ".$weekdayId."
)
";
d_Var('scheduleclassmeetingweekdayINSERT',$query,'q+');
if ( !$f['DEBUG'] ) $scheduleclassmeetingweekdayINSERT = query_do($query);
@d_Var('$scheduleclassmeetingweekdayINSERT',$scheduleclassmeetingweekdayINSERT,'l');
} // Loop thru weekdayIds
$f['departmentId'] = $_SESSION['user']['departmentId'];
$f['sessionId'] = $_SESSION['user']['sessionId'];
if ( $f['DEBUG'] ) $DEBUG_getSchedule = true;
require('Schedule/getSchedule.phpinc');
$showOuterDiv = false; // Create only the div contents.
if ( $f['DEBUG'] ) {
$DEBUG_displayScheduleClassDiv = true;
$showOuterDiv = true; // Show the outer div when DEBUGging.
}
require('Schedule/displayScheduleClassDiv.phpinc');
t_End(); // End TRACKing MoveClassMeeting.
?>