| 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_CollegeCampusBuildingRoom.phpinc
// Set js variables needed for schedule management.
echo "
// BEGIN FILE ".basename(__FILE__)." ".currentDateTime().".";
t_Begin(); // Begin TRACKing js_write_Schedule.phpinc.
$jsText .= "
console.log('%c\t\t".basename(__FILE__)."','background-color:#000; color: #ccc;');";
// BEGIN Campus, Building, and Room.
// Define the CollegeCampus[], CollegeBuilding[], and CollegeRoom[] arrays.
// Get the campuses.
$query = "
SELECT campusId
, campusCode
, campusName
FROM `campus`
ORDER BY campusName
";
d_Var('campusResult',$query,'q');
$campusResult = query_do($query);
$campusCount = $GLOBALS['_QUERY']['count'];
d_Var('$campusResult',$campusResult);
// BEGIN Calculate $campusCountMaxWidth, $buildingCountMaxWidth, $buildingIdMaxWidth $roomCountMaxWidth, and $roomIdMaxWidth.
$campusCountMaxWidth = spaceMaxFill($campusResult, 'campusId');
$buildingCountMaxWidth = 1;
$buildingIdMaxWidth = 1;
$roomCountMaxWidth = 1;
$roomIdMaxWidth = 1;
query_seek($campusResult, 0);
while ($campusInfo = query_row($campusResult)) { // Loop thru campuses.
// Get the buildingIds on this campus.
$query = "
SELECT buildingId
FROM `building`
WHERE campusId = ".$campusInfo['campusId']."
ORDER BY buildingCode
";
$buildingResult = query_do($query);
$buildingCount = $GLOBALS['_QUERY']['count'];
$maxwidth = strlen((string)$buildingCount);
if ( $maxwidth > $buildingCountMaxWidth ) $buildingCountMaxWidth = $maxwidth;
if ( $buildingCount ) { // Were buildings found on this campus?
query_seek($buildingResult, 0);
while ($buildingInfo = query_row($buildingResult)) { // Loop thru buildings.
$maxwidth = strlen($buildingInfo['buildingId']);
if ( $maxwidth > $buildingIdMaxWidth ) $buildingIdMaxWidth = $maxwidth;
// Get the roomIds in this building.
$query = "
SELECT roomId
FROM `room`
WHERE buildingId = ".$buildingInfo['buildingId']."
ORDER BY IF ( roomNumber REGEXP ('^[0-9]') ,10000 + roomNumber,roomNumber), roomNumber
";
d_Var('roomResult',$query,'q');
$roomResult = query_do($query);
$roomCount = $GLOBALS['_QUERY']['count'];
$maxwidth = strlen((string)$roomCount);
if ( $maxwidth > $roomCountMaxWidth ) $roomCountMaxWidth = $maxwidth;
if ( $roomCount ) { // Were rooms found in this building?
query_seek($roomResult, 0);
while ($roomInfo = query_row($roomResult)) { // Loop thru rooms.
$maxwidth = strlen($roomInfo['roomId']);
if ( $maxwidth > $roomIdMaxWidth ) $roomIdMaxWidth = $maxwidth;
} // Loop thru rooms.
} // Were rooms found in this building?
} // Loop thru buildings.
} // Were buildings found on this campus?
} // Loop thru campuses.
// END Calculate $campusCountMaxWidth, $buildingCountMaxWidth, $buildingIdMaxWidth $roomCountMaxWidth, and $roomIdMaxWidth.
// Define the CollegeCampus[] array.
// CollegeCampus[] = { campusId:campusId, Name:'campusName' };
$jsText .= "\n"."
// BEGIN Campus, Building, and Room variables.
const CollegeCampus = [";
if ( $campusCount ) { // Were campuses found?
// CollegeCampus[] = { campusId:campusId, Name:campusName };
query_seek($campusResult, 0);
$i=0; // CollegeCampus array index.
$prefix = ' ';
while ($campusInfo = query_row($campusResult)) { // Loop thru campuses.
$sp = spaceFill($i, $campusCountMaxWidth);
$jsText .= $prefix."{ campusId:".$campusInfo['campusId'].", Name:'".$campusInfo['campusName']."' }";
$prefix = ', ';
$i++;
}
$jsText .= ' ];';
}
// Define the CollegeBuilding[] array.
// CollegeBuilding[] = { buildingId:buildingId, campusId:campusId, Code:'buildingCode' };
$jsText .= "
const CollegeBuilding = [];";
query_seek($campusResult, 0);
$i=0; // CollegeBuilding array index.
while ($campusInfo = query_row($campusResult)) { // Loop thru campuses.
// Get the buildings on this campus.
$query = "
SELECT buildingId
, campusId
, buildingCode
, buildingName
FROM `building`
WHERE campusId = ".$campusInfo['campusId']."
ORDER BY buildingCode
";
d_Var('buildingResult',$query,'q');
$buildingResult = query_do($query);
$buildingCount = $GLOBALS['_QUERY']['count'];
d_Var('$buildingResult',$buildingResult);
if ( $buildingCount ) { // Were buildings found on this campus?
query_seek($buildingResult, 0);
while ($buildingInfo = query_row($buildingResult)) { // Loop thru buildings.
$sp = spaceFill($i, $buildingCountMaxWidth);
$spB = spaceFill($buildingInfo['buildingId'], $buildingIdMaxWidth);
$jsText .= "
CollegeBuilding[".$i."] ".$sp."= { buildingId:".$buildingInfo['buildingId'].",".$spB." campusId:".$buildingInfo['campusId'].", Code:'".$buildingInfo['buildingCode']."' };";
$i++;
} // Loop thru buildings.
} // Were buildings found on this campus?
} // Loop thru campuses.
// Define the CollegeRoom[] array.
// CollegeRoom[] = { roomId:roomId, buildingId:buildingId, Number:'roomNumber' };
$jsText .= "
const CollegeRoom = [];";
query_seek($campusResult, 0);
$i=0; // CollegeRoom array index.
while ($campusInfo = query_row($campusResult)) { // Loop thru campuses.
// Get the buildings on this campus.
$query = "
SELECT buildingId
, campusId
, buildingCode
, buildingName
FROM `building`
WHERE campusId = ".$campusInfo['campusId']."
ORDER BY buildingCode
";
d_Var('buildingResult',$query,'q');
$buildingResult = query_do($query);
$buildingCount = $GLOBALS['_QUERY']['count'];
d_Var('$buildingResult',$buildingResult);
if ( $buildingCount ) { // Were buildings found on this campus?
query_seek($buildingResult, 0);
while ($buildingInfo = query_row($buildingResult)) { // Loop thru building.
$spB = spaceFill($buildingInfo['buildingId'], $buildingIdMaxWidth);
// Get the rooms in this building.
$query = "
SELECT roomId
, buildingId
, roomNumber
FROM `room`
WHERE buildingId = ".$buildingInfo['buildingId']."
ORDER BY IF ( roomNumber REGEXP ('^[0-9]') ,10000 + roomNumber,roomNumber), roomNumber
";
d_Var('roomResult',$query,'q');
$roomResult = query_do($query);
$roomCount = $GLOBALS['_QUERY']['count'];
d_Var('$roomResult',$roomResult);
if ( $roomCount ) { // Were rooms found in this building?
query_seek($roomResult, 0);
while ($roomInfo = query_row($roomResult)) { // Loop thru rooms.
$sp = spaceFill($i, $roomCountMaxWidth);
$spR = spaceFill($roomInfo['roomId'], $roomIdMaxWidth);
$jsText .= "
CollegeRoom[".$i."] ".$sp."= { roomId:".$roomInfo['roomId'].",".$spR." buildingId:".$roomInfo['buildingId'].",".$spB." Number:'".$roomInfo['roomNumber']."' };";
$i++;
} // Loop thru rooms.
} // Were rooms found in this building?
} // Loop thru building.
} // Were buildings found on this campus?
} // Loop thru campuses.
$jsText .= "
const RoomLookup = {};";
query_seek($campusResult, 0);
$i=0; // CollegeRoom array index.
while ($campusInfo = query_row($campusResult)) { // Loop thru campuses.
// Get the buildings on this campus.
$query = "
SELECT buildingId
, campusId
, buildingCode
, buildingName
FROM `building`
WHERE campusId = ".$campusInfo['campusId']."
ORDER BY buildingCode
";
d_Var('buildingResult',$query,'q');
$buildingResult = query_do($query);
$buildingCount = $GLOBALS['_QUERY']['count'];
d_Var('$buildingResult',$buildingResult);
if ( $buildingCount ) { // Were buildings found on this campus?
query_seek($buildingResult, 0);
while ($buildingInfo = query_row($buildingResult)) { // Loop thru building.
$spB = spaceFill($buildingInfo['buildingId'], $buildingIdMaxWidth);
// Get the rooms in this building.
$query = "
SELECT roomId
, buildingId
, roomNumber
FROM `room`
WHERE buildingId = ".$buildingInfo['buildingId']."
ORDER BY IF ( roomNumber REGEXP ('^[0-9]') ,10000 + roomNumber,roomNumber), roomNumber
";
d_Var('roomResult',$query,'q');
$roomResult = query_do($query);
$roomCount = $GLOBALS['_QUERY']['count'];
d_Var('$roomResult',$roomResult);
if ( $roomCount ) { // Were rooms found in this building?
query_seek($roomResult, 0);
while ($roomInfo = query_row($roomResult)) { // Loop thru rooms.
$sp = spaceFill($i, $roomCountMaxWidth);
$spR = spaceFill($roomInfo['roomId'], $roomIdMaxWidth);
$roomNumber = str_replace('MAINHU','',$buildingInfo['buildingCode'].$roomInfo['roomNumber']);
$jsText .= "
RoomLookup['".$roomNumber."'] ".$sp."= { roomId:".$roomInfo['roomId'].",".$spR." buildingId:".$buildingInfo['buildingId'].",".$spB." campusId:'".$campusInfo['campusId']."' };";
$i++;
} // Loop thru rooms.
} // Were rooms found in this building?
} // Loop thru building.
} // Were buildings found on this campus?
} // Loop thru campuses.
// END Campus, Building, and Room.
$jsText .= "
// END Campus, Building, and Room variables.";
echo "
// END FILE ".basename(__FILE__)."
";
t_End(); // End TRACKing js_write_Schedule.phpinc.
?>