| 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/MoveClassMeetings.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['DEBUG'] == 1
$f['difference_day'] == 0
$f['difference_mTime'] == -120
$f['form'] == 'Schedule_form'
$f['moveMeeting_2'] == 'M'
$f['moveMeeting_4'] == 'W'
$f['moveMeeting_6'] == 'F'
$f['scheduleclassId'] == 8
$f['scheduleclassmeetingId'] == 442
$f['subtask'] is NULL
$f['task'] == 'Move meetings'
$f['uuid'] == '56f39b15c04a531c2aacdfc037d9a81d'
/**/
f('difference_day');
f('difference_mTime');
f('scheduleclassId');
f('scheduleclassmeetingId');
if ( $f['DEBUG'] ) {
?>
<h1><?=__FILE__?></h1>
<?
d_V();
}
// Get class meeting weekdays
$query = "
SELECT scheduleclassmeetingId
, weekdayId
FROM `scheduleclassmeetingweekday`
WHERE scheduleclassmeetingId = ".$f['scheduleclassmeetingId']."
ORDER BY weekdayId
";
d_Var('scheduleclassmeetingweekdayResult',$query,'q');
$scheduleclassmeetingweekdayResult = query_do($query);
$scheduleclassmeetingweekdayCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingweekdayResult',$scheduleclassmeetingweekdayResult);
#if ( $scheduleclassmeetingweekdayCount != 1 ) programmingError('The scheduleclassmeetingId ('.$scheduleclassmeetingId.') and weekdayId ('.$weekdayId.') did not return one record. '.$scheduleclassmeetingweekdayCount.' returned.');
#if ( !$scheduleclassmeetingweekdayCount ) programmingError('The scheduleclassmeetingId ('.$scheduleclassmeetingId.') and weekdayId ('.$weekdayId.') did not return any records.');
if ( $scheduleclassmeetingweekdayCount ) {
query_seek($scheduleclassmeetingweekdayResult, 0);
while ($scheduleclassmeetingweekdayInfo = query_row($scheduleclassmeetingweekdayResult)) {
}
}
#d_Var('scheduleclassmeetingweekdayInfo',$query,'q');
#$scheduleclassmeetingweekdayInfo = query_info($query);
#d_Var('$scheduleclassmeetingweekdayInfo',$scheduleclassmeetingweekdayInfo);
// Now that we have the weekdayIds we can check for formvalues moveMeeting_? where ? is the weekdayId.
// This tells us chich days were checked.
// NOTE: As move is checked/unchecked in the Move Class dialog, the calendar class meeting positions should reflect this.
exit;
// 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.
?>