| 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/ |
Upload File : |
<?
// Schedule/js_write_Schedule.phpinc
// Set js variables needed for schedule management.
echo "
// BEGIN FILE ".basename(__FILE__)." ".currentDateTime()."
// BEGIN ".basename(__FILE__)." comments on line ".__LINE__.". /** /";
t_Begin(); // Begin TRACKing js_write_Schedule.phpinc.
// Get schedule info.
if (isset($_SESSION['user']['scheduleId'])) {
$query = "
SELECT departmentId
, sessionId
, scheduleName
FROM `schedule`
WHERE scheduleId = ".$_SESSION['user']['scheduleId']."
";
d_Var('scheduleInfo',$query,'q');
$scheduleInfo = query_info($query); // Also used in defining ScheduleInstructor[], Course{}, and Credential{}.
} else {
$scheduleId = 0;
$scheduleInfo = array();
$scheduleInfo['departmentId'] = 0;
$scheduleInfo['sessionId'] = 0;
$scheduleInfo['scheduleName'] = '';
}
d_Var('$scheduleInfo',$scheduleInfo);
$jsText = "";
$jsText .= "
console.log('%c\t".basename(__FILE__)."','background-color:#000; color: #ccc;');";
require('Schedule/js_write_Schedule_CollegeCampusBuildingRoom.phpinc');
require('Schedule/js_write_Schedule_Course.phpinc');
require('Schedule/js_write_Schedule_Credentials.phpinc');
require('Schedule/js_write_Schedule_Instructor.phpinc');
require('Schedule/js_write_Schedule_ScheduleCurrent.phpinc');
require('Schedule/js_write_Schedule_SessionCurrent.phpinc');
// ScheduleClass.
// Define the $ScheduleClassCourses[] array and the ScheduleClass object.
// ScheduleClass[] = { Course:"Dept+Number", courseId:"courseId", Section:"Section" }; Section needs to allow for multiple sections.
$ScheduleClassCourses = array(); // $ScheduleClassCourses is used in defining the SCMnow{} object.
require('getScheduleClasses.phpinc');
$jsText .= "\n"."
const ScheduleClass = {}; // Classes that are are on the schedule.";
if ( $scheduleclassCount ) {
$scIdMaxwidth = spaceMaxFill($scheduleclassResult, 'scheduleclassId');
query_seek($scheduleclassResult, 0);
while ($scheduleclassInfo = query_row($scheduleclassResult)) {
// Get scheduleclassSections.
$query = "SELECT scheduleclassSection FROM `scheduleclasssection` WHERE scheduleclassId = ".$scheduleclassInfo['scheduleclassId']." ORDER BY scheduleclassSection";
d_Var('scheduleclasssectionResult',$query,'q');
$scheduleclasssectionResult = query_do($query);
$scheduleclasssectionCount = $GLOBALS['_QUERY']['count'];
$scheduleclassInfo['scheduleclassSection'] = query_to_list($scheduleclasssectionResult);
$ScheduleClassCourses[$scheduleclassInfo['scheduleclassId']] = $Courses[$scheduleclassInfo['courseId']];
$sp = spaceFill($scheduleclassInfo['scheduleclassId'], $scIdMaxwidth);
$jsText .= "
ScheduleClass[".$scheduleclassInfo['scheduleclassId']."] ".$sp.'= { scId:'.$scheduleclassInfo['scheduleclassId'].', '.$sp.'Course:"'.$Courses[$scheduleclassInfo['courseId']].'", courseId:"'.$scheduleclassInfo['courseId'].'", Section:"'.$scheduleclassInfo['scheduleclassSection'].'", StartDate:"'.$scheduleclassInfo['scheduleclassStartDate'].'", EndDate:"'.$scheduleclassInfo['scheduleclassEndDate'].'", Online: "'.$scheduleclassInfo['scheduleclassOnline'].'" };';
}
}
//d_Var('$ScheduleClassCourses',$ScheduleClassCourses,'d+/');
// ClassMeetings.
// Define the SCMnow object.
// SCMnow[scId] = array of { scmId:scmId, sDate:'scheduleclassmeetingStartDate', eDate:'scheduleclassmeetingEndDate', bTime:'scheduleclassmeetingBeginTime', eTime:'scheduleclassmeetingEndTime', onCampus:'scheduleclassmeetingOnCampus', rooms:[], days:[], instructors:[], tdMinute:tdMinute };
// rooms[] is an array of roomIds.
// days[] is an array of day letters (weekdayD).
// instructors[] is and array of instructorIds (userIds).
// tdMinute is the minute part of the ScheduleCell div id. This should be removed from all javascript and php use. Then it can then be removed here.
$jsText .= "\n"."
const SCMold = {}; // Used to remember original values for drag/move of meeting and to detect if changes were made.";
$classMeetingName = 'SCMold';
require('Schedule/js_write_Schedule_ClassMeeting.phpinc');
$jsText .= "
const SCMnow = JSON.parse(JSON.stringify(SCMold)); // Class meetings for each class on the schedule.
";
/** /
$jsText .= "
const SCMnow = {}; // Class meetings for each class on the schedule.
";
$classMeetingName = 'SCMnow';
require('Schedule/js_write_Schedule_ClassMeeting.phpinc');
/**/
// BEGIN ClassMeeting_ScheduleClass{}.
// Define the ClassMeeting_ScheduleClass{} object.
// ClassMeeting_ScheduleClass[scheduleclassmeetingId] = scheduleclassId
$jsText .= "
var ClassMeeting_ScheduleClass = {}; // Reverse lookup from scmId to scId (ScheduleClass[scId]). Used by the Events_Prepare_MaxOverlap() function.";
if ( $scheduleclassCount ) { // Are there schedule classes?
query_seek($scheduleclassResult, 0);
while ($scheduleclassInfo = query_row($scheduleclassResult)) { // Loop thru schedule classes.
// Get scheduleclassmeeting.
$query = "
SELECT scheduleclassmeetingId
, scheduleclassmeetingStartDate
, scheduleclassmeetingEndDate
, scheduleclassmeetingBeginTime
, scheduleclassmeetingEndTime
, IFNULL(scheduleclassmeetingOnCampus, 1) AS scheduleclassmeetingOnCampus
FROM `scheduleclassmeeting`
WHERE scheduleclassId = ".$scheduleclassInfo['scheduleclassId']."
";
d_Var('scheduleclassmeetingResult',$query,'q');
$scheduleclassmeetingResult = query_do($query);
$scheduleclassmeetingCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingResult',$scheduleclassmeetingResult);
if ( $scheduleclassmeetingCount ) { // Are there class scheduleclassmeetings?
$scmIdMaxwidth = spaceMaxFill($scheduleclassmeetingResult, 'scheduleclassmeetingId');
if ( $scheduleclassInfo['scheduleclassId'] < 10 ) { $sp = ' '; } else { $sp = ''; }
query_seek($scheduleclassmeetingResult, 0);
while ($meetingInfo = query_row($scheduleclassmeetingResult)) { // Loop thru class scheduleclassmeetings.
$sp = spaceFill($meetingInfo['scheduleclassmeetingId'], $scmIdMaxwidth);
$jsText .= "
ClassMeeting_ScheduleClass[".$meetingInfo['scheduleclassmeetingId']."] ".$sp."= ".$scheduleclassInfo['scheduleclassId'].';';
} // Loop thru class scheduleclassmeetings.
} // Are there class scheduleclassmeetings?
} // Loop thru schedule classes.
} // Are there schedule classes?
// END ClassMeeting_ScheduleClass{}.
// BEGIN ScheduleDaysFullWeek and ScheduleDaysWorkWeek.
$ScheduleDaysFullWeek = '';
$ScheduleDaysWorkWeek = '';
// Get weekdays.
require('site/get_weekdays.phpinc');
if ( $weekdayCount ) { // Are there weekdays?
query_seek($weekdayResult, 0);
while ($weekdayInfo = query_row($weekdayResult)) { // Loop thru weekdays.
$ScheduleDaysFullWeek .= $weekdayInfo['weekdayD'];
if ( $weekdayInfo['weekdayNumber'] > 0 && $weekdayInfo['weekdayNumber'] < 6 ) { // Is this day in the work week?
$ScheduleDaysWorkWeek .= $weekdayInfo['weekdayD'];
} // Is this day in the work week?
} // Loop thru weekdays.
} // Are there weekdays?
$jsText .= "\n"."
// Days in the full and work week.
var ScheduleDaysFullWeek = '".$ScheduleDaysFullWeek."'; // Full week.
var ScheduleDaysWorkWeek = '".$ScheduleDaysWorkWeek."'; // Work week.";
// END ScheduleDaysFullWeek and ScheduleDaysWorkWeek.
// BEGIN Schedule view settings.
$jsText .= "\n"."
// Schedule view settings.";
if ( $_SESSION['user']['calendar_dayview'] == 'Work week' ) {
$jsText .= "
var ScheduleViewDays = ScheduleDaysWorkWeek;";
} else {
$jsText .= "
var ScheduleViewDays = ScheduleDaysFullWeek;";
}
if ( !$_SESSION['user']['calendar_showconflicts'] ) $_SESSION['user']['calendar_showconflicts'] = 0;
$jsText .= "
var ScheduleDayView = '". $_SESSION['user']['calendar_dayview']."'; // The days visible in the current view.
var ScheduleIncrementHeight = ".$_SESSION['user']['calendar_incrementheight']."; // The height in pixels for each row.
var ScheduleHeightMultiplier = ".$_SESSION['user']['calendar_incrementheight']/$_SESSION['user']['calendar_timeincrement']."; // The multiplier used to calculate class meeting heights.
var ScheduleTimeBegin = ".(int)$_SESSION['user']['calendar_timebegin']."; // The beginning hour in the current view.
var ScheduleTimeEnd = ".(int)$_SESSION['user']['calendar_timeend']."; // The ending hour in the current view.
var ScheduleTimeIncrement = ".$_SESSION['user']['calendar_timeincrement']."; // The increment in minutes from row-to-row.
var ScheduleHighlightView = '".$_SESSION['user']['calendar_showconflicts']."'; // The current highlight view setting. Needs to be changed to allow for all 5 selections." ;
// END Schedule view settings.
// BEGIN Semester date settings.
$jsText .= "\n"."
// Semester date settings: Full, 1st half, and 2nd half dates. Used to quickfill date fields.";
$query = "
SELECT sessionStart
, sessionEnd
FROM `session`
WHERE sessionId = ".$_SESSION['user']['sessionId']."
";
d_Var('sessionInfo',$query,'q');
$sessionInfo = query_info($query);
d_Var('$sessionInfo',$sessionInfo);
if ( $sessionInfo ) {
$semesterFullStart = $sessionInfo['sessionStart'];
$semesterFullEnd = $sessionInfo['sessionEnd'];
$semester1stStart = $sessionInfo['sessionStart'];
$semester1stEnd = date('Y-m-d',strtotime($sessionInfo['sessionStart'] . " + 53 days"));
$semester2ndStart = date('Y-m-d',strtotime($sessionInfo['sessionEnd'] . " - 60 days"));
//$semester2ndEnd = date('Y-m-d',strtotime($sessionInfo['sessionEnd'] . " - 7 days")); // Exclude finals week.
$semester2ndEnd = $sessionInfo['sessionEnd']; // Include finals week.
} else {
$semesterFullStart = '';
$semesterFullEnd = '';
$semester1stStart = '';
$semester1stEnd = '';
$semester2ndStart = '';
$semester2ndEnd = '';
}
$jsText .= "
var SemesterFullStart = '".$semesterFullStart."';
var SemesterFullEnd = '".$semesterFullEnd."';
var Semester1stStart = '".$semester1stStart."';
var Semester1stEnd = '".$semester1stEnd."';
var Semester2ndStart = '".$semester2ndStart."';
var Semester2ndEnd = '".$semester2ndEnd."';";
// END Semester date settings.
// BEGIN Weekdays.
// Define the Weekdays{} object.
// Weekdays[weekdayId] = { weekdayD:'weekdayD', weekdayWeekday:'weekdayWeekday' }
// Begin the Weekdays{} object.
$jsText .= "
// Weekdays.
var Weekdays = {}; ";
if ( $weekdayCount ) { // Are there weekdays?
query_seek($weekdayResult, 0);
while ($weekdayInfo = query_row($weekdayResult)) { // Loop thru weekdays.
$jsText .= "
Weekdays[".$weekdayInfo['weekdayId']."] = { weekdayId:'".$weekdayInfo['weekdayId']."', weekdayNumber:".$weekdayInfo['weekdayNumber'].", weekdayD:'".$weekdayInfo['weekdayD']."', weekdayWeekday:'".$weekdayInfo['weekdayWeekday']."' };";
} // Loop thru weekdays.
} // Are there weekdays?
// END Weekdays.
// BEGIN WeekdayD. Reverse lookup from D to weekdayId.
// Define the WeekdayD{} object.
// WeekdayD[weekdayD] = weekdayId
// Begin the Weekdays{} object.
$jsText .= "
// WeekdayD. Reverse lookup from D to weekdayId.
var WeekdayD = {}; ";
if ( $weekdayCount ) { // Are there weekdays?
query_seek($weekdayResult, 0);
while ($weekdayInfo = query_row($weekdayResult)) { // Loop thru weekdays.
$jsText .= "
WeekdayD['".$weekdayInfo['weekdayD']."'] = ".$weekdayInfo['weekdayId'].";";
} // Loop thru weekdays.
} // Are there weekdays?
// END WeekdayD.
$jsText .= "
";
echo "
// END ".basename(__FILE__)." comments on line ".__LINE__." /**/.
";
echo $jsText; // Write out the script.
echo "
// END FILE ".basename(__FILE__)."
";
t_End(); // End TRACKing js_write_Schedule.phpinc.
?>