| 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/admin/parse/ |
Upload File : |
<?
// admin/parse/parseProcess.phpinc
// INSERT or UPDATE classes, departments, rooms, and users from array.
t_Begin(); // Begin TRACKing include_filename.phpinc.
// Get weekdayIds into an indexed array by weekdayD.
require('site/get_weekdays.phpinc');
if ( $weekdayCount ) {
$weekdayIds = array();
query_seek($weekdayResult, 0);
while ($weekdayInfo = query_row($weekdayResult)) {
$weekdayIds[$weekdayInfo['weekdayD']] = $weekdayInfo['weekdayId'];
}
} else {
programmingError("There are no weekdays!");
}
d_Var('$weekdayIds',$weekdayIds);
// Get campusIds into an indexed array by campusName.
$query = "
SELECT campusId
, campusName
FROM `campus`
ORDER BY campusName
";
d_Var('campusResult',$query,'q');
$campusResult = query_do($query);
$campusCount = $GLOBALS['_QUERY']['count'];
if ( $campusCount ) {
$campusIds = array();
query_seek($campusResult, 0);
while ($campusInfo = query_row($campusResult)) {
$campusIds[$campusInfo['campusName']] = $campusInfo['campusId'];
}
} else {
programmingError("There are no campuss!");
}
d_Var('$campusIds',$campusIds);
$departmentId = array(); // $departmentId[departmentCode] = departmentId
d_Var('$class',$class,'');
d_Var('$department',$department,'');
divShowHideBegin('<span class="info large">Add classes for '.$sessionInfo['YRTR'].'</span>');
$addClassCount = 0;
$updateClassCount = 0;
?>
<table>
<tr>
<td>#</td>
<th>ClassId</th>
<th>Class Num</th>
<th>Sec</th>
<th>Class Title</th>
<th></th>
</tr>
<?
foreach ( $class as $thisClass ) {
if ( !isset($departmentId[$thisClass['departmentCode']]) ) require('parseProcess_Get_departmentId.phpinc'); // Get departmentId.
require('parseProcess_Get_courseId.phpinc'); // Get courseId.
d_Var('$thisClass',$thisClass);
// See if the class is already in the database.
$query = "
SELECT classId
FROM `class`
WHERE YRTR = '".query_safe($sessionInfo['YRTR'])."'
AND classQId = '".query_safe($thisClass['classQId'])."'
";
d_Var('classInfo',$query,'q');
$classInfo = query_info($query);
d_Var('$classInfo',$classInfo);
// Calc classStartDate and classEndDate.
$thisClass['classStartDate'] = '9999-99-99';
$thisClass['classEndDate'] = '0000-00-00';
foreach ( $thisClass['meeting'] as $thisClassMeeting ) {
if ( $thisClassMeeting['classmeetingStartDate'] < $thisClass['classStartDate'] ) {
$thisClass['classStartDate'] = $thisClassMeeting['classmeetingStartDate'];
}
if ( $thisClassMeeting['classmeetingEndDate'] > $thisClass['classEndDate'] ) {
$thisClass['classEndDate'] = $thisClassMeeting['classmeetingEndDate'];
}
}
// +++++ Do we want to update or should we delete all and then insert? +++++
if ( $classInfo ) { // Is the class already in the database?
// Yes, UPDATE class.
$thisClass['classId'] = $classInfo['classId'];
require('parseProcess_class_UPDATE.phpinc');
// DELETE any class meetings.
require('parseProcess_classmeeting_DELETE.phpinc');
?>
<tr>
<td><?=$addClassCount+$updateClassCount?></td>
<td><?=$thisClass['classQId']?></td>
<td><?=$thisClass['departmentCode']?><?=$thisClass['courseNumber']?></td>
<td><?=$thisClass['classSection']?></td>
<td><?=$thisClass['courseTitle']?></td>
<td>updated <?=$departmentInfo['departmentId']?></td>
</tr>
<?
$updateClassCount++;
// DELETE any class notes.
// require('parseProcess_classnote_DELETE.phpinc'); // Removed, parsed schedule has no notes.
} else { // Is the class already in the database?
// No, INSERT class.
require('parseProcess_class_INSERT.phpinc');
?>
<tr>
<td><?=$addClassCount+$updateClassCount?></td>
<td><?=$thisClass['classQId']?></td>
<td><?=$thisClass['departmentCode']?><?=$thisClass['courseNumber']?></td>
<td><?=$thisClass['classSection']?></td>
<td><?=$thisClass['courseTitle']?></td>
<td>added <?=$departmentInfo['departmentId']?></td>
</tr>
<?
$addClassCount++;
} // Is the class already in the database?
require('parseProcess_classmeeting.phpinc');
}
?>
</table>
<?
divShowHideEnd();
?>
<h4>Total classes added: <?=$addClassCount?>, updated: <?=$updateClassCount?></h4>
<?
t_End(); // End TRACKing include_filename.phpinc.
?>