| 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/CheckForSameExistingClassMeeting.phpinc
// Check for same existing scheduleclass meeting.
// Meeting is the same only if the following is the same:
// ??? Section number
// Begin and end dates
// Begin and end times
// Rm(s)
// Instructor(s)
#$DEBUG_CheckForSameExistingClassMeeting = true;
#if ( $_SESSION['gameId'] == 0 ) $DEBUG_CheckForSameExistingClassMeeting = true; // DEBUG by gameId.
#if ( $_SESSION['userId'] == 0 ) $DEBUG_CheckForSameExistingClassMeeting = true; // DEBUG by userId.
if ( !isset($DEBUG_CheckForSameExistingClassMeeting) ) $DEBUG_CheckForSameExistingClassMeeting = d_O(); // DEBUG by passthrough.
#if ( !isset($DEBUG_CheckForSameExistingClassMeeting) ) $DEBUG_CheckForSameExistingClassMeeting = false; // Default false.
#if ( $DEBUG_CheckForSameExistingClassMeeting ) d_On(); // Use instead of t_Begin() for AJAX call.
t_Begin($DEBUG_CheckForSameExistingClassMeeting); // Begin TRACKing CheckForSameExistingClassMeeting.phpinc.
// Check for any scheduleclassmeetings with the same begin and end dates.
$query = "
SELECT scheduleclassmeetingId
FROM `scheduleclassmeeting`
WHERE scheduleclassId = ".$f['scheduleclassId']."
AND scheduleclassmeetingStartDate = '".query_safe($classmeetingInfo['classmeetingStartDate'])."'
AND scheduleclassmeetingEndDate = '".query_safe($classmeetingInfo['classmeetingStartDate'])."'
";
d_Var('sameDatesResult',$query,'q');
$sameDatesResult = query_do($query);
$sameDatesCount = $GLOBALS['_QUERY']['count'];
d_Var('$sameDatesCount',$sameDatesCount);
d_Var('$sameDatesResult',$sameDatesResult);
if ( !$sameDatesCount ) { // Are there no scheduleclassmeetings with the same begin and end dates?
// Check for any scheduleclassmeetings with the same begin and end times.
$query = "
SELECT scheduleclassmeetingId
FROM `scheduleclassmeeting`
WHERE scheduleclassId = ".$f['scheduleclassId'];
if ( !empty($classmeetingInfo['classmeetingBeginTime']) ) {
$query .= "
AND scheduleclassmeetingBeginTime = '".query_safe($classmeetingInfo['classmeetingBeginTime']);
} else {
$query .= "
AND scheduleclassmeetingBeginTime IS NOT NULL'";
}
if ( !empty($classmeetingInfo['classmeetingEndTime']) ) {
$query .= "
AND scheduleclassmeetingEndTime = '".query_safe($classmeetingInfo['classmeetingEndTime']);
} else {
$query .= "
AND scheduleclassmeetingEndTime IS NOT NULL'";
}
$query .= "
";
d_Var('sameTimesResult',$query,'q');
$sameTimesResult = query_do($query);
$sameTimesCount = $GLOBALS['_QUERY']['count'];
d_Var('$sameTimesCount',$sameTimesCount);
d_Var('$sameTimesResult',$sameTimesResult);
if ( !$sameTimesCount ) { // Are there no scheduleclassmeetings with the same begin and end times?
// Check for any scheduleclassmeetings with the same room(s).
$query = "
SELECT scheduleclassmeetingId
, roomId
FROM `scheduleclassmeetingroom`
WHERE scheduleclassmeetingId = ".$f['scheduleclassmeetingId']."
AND roomId = ".$classmeetingInfo['roomId']."
ORDER BY
";
d_Var('scheduleclassmeetingroomResult',$query,'q');
$scheduleclassmeetingroomResult = query_do($query);
$scheduleclassmeetingroomCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingroomResult',$scheduleclassmeetingroomResult);
#if ( $scheduleclassmeetingroomCount != 1 ) programmingError('The scheduleclassmeetingId ('.$scheduleclassmeetingId.') and roomId ('.$roomId.') did not return one record. '.$scheduleclassmeetingroomCount.' returned.');
#if ( !$scheduleclassmeetingroomCount ) programmingError('The scheduleclassmeetingId ('.$scheduleclassmeetingId.') and roomId ('.$roomId.') did not return any records.');
if ( $scheduleclassmeetingroomCount ) {
query_seek($scheduleclassmeetingroomResult, 0);
while ($scheduleclassmeetingroomInfo = query_row($scheduleclassmeetingroomResult)) {
}
}
#d_Var('scheduleclassmeetingroomInfo',$query,'q');
#$scheduleclassmeetingroomInfo = query_info($query);
#d_Var('$scheduleclassmeetingroomInfo',$scheduleclassmeetingroomInfo);
// Rm(s) $classmeetingInfo['roomId'] == 31 $classmeetingInfo['roomId'] is NULL
// Instructor(s)
} // Are there no scheduleclassmeetings with the same begin and end times?
} // Are there no scheduleclassmeetings with the same begin and end dates?
#if ( $DEBUG_CheckForSameExistingClassMeeting ) d_Off(); // Use instead of t_End() for AJAX call.
unset($DEBUG_CheckForSameExistingClassMeeting);
t_End(); // End TRACKing CheckForSameExistingClassMeeting.phpinc.
?>