| 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/Admin/_Archive/ |
Upload File : |
<?
// Admin/ClassAddFormParsePerform.phpinc
$ClassAddFormParsePerform_DEBUG = false;
#$ClassAddFormParsePerform_DEBUG = true;
#if ( $ClassAddFormParsePerform_DEBUG ) printVar('$classDataArray',$classDataArray);
$f_maxMeetingRows = formValue('maxMeetingRows');
$courseCreateArray = array();
$courseCreateArrayIndex = 0;
$userCreateArray = array();
$userCreateArrayIndex = 0;
$f_YRTR = $_SESSION['YRTR']['User'];
$f_message = '';
foreach ($classDataArray as $key => $classData) { // Loop through the classDataArray.
#$f_classId = $classData['classId'];
$f_courseNumber = $classData['courseNumber'];
$f_RCclassId = $classData['RCclassId'];
$f_classSection = $classData['classSection'];
$f_classDaysArray = $classData['classDays']; // classDays = array();
$f_classDateStartArray = $classData['classDateStart']; // classTimeStart = array();
$f_classDateStopArray = $classData['classDateStop']; // classTimeStop = array();
if ( !isset($classData['classTimeStart']) ) $classData['classTimeStart'] = '';
$f_classTimeStartArray = $classData['classTimeStart']; // classTimeStart = array();
if ( !isset($classData['classTimeStop']) ) $classData['classTimeStop'] = '';
$f_classTimeStopArray = $classData['classTimeStop']; // classTimeStop = array();
if ( !isset($classData['classRoomBldg']) ) $classData['classRoomBldg'] = '';
$f_classRoomBldgArray = $classData['classRoomBldg']; // classRoomBldg = array();
if ( !isset($classData['classRoomNumber']) ) $classData['classRoomNumber'] = '';
$f_classRoomNumberArray = $classData['classRoomNumber']; // classRoomNumber = array();
if ( !isset($classData['classInstructor']) ) $classData['classInstructor'] = '';
$f_classInstructorArray = $classData['classInstructor']; // classInstructor = array();
if ( $ClassAddFormParsePerform_DEBUG ) {
echo "<br>\n";
/* */
printVar('$f_courseNumber',$f_courseNumber);
printVar('$f_RCclassId',$f_RCclassId);
printVar('$f_classSection',$f_classSection);
#printVar('$f_classDaysArray',$f_classDaysArray);
#printVar('$f_classTimeStartArray',$f_classTimeStartArray);
#printVar('$f_classTimeStopArray',$f_classTimeStopArray);
#printVar('$f_classRoomBldgArray',$f_classRoomBldgArray);
#printVar('$f_classRoomNumberArray',$f_classRoomNumberArray);
#printVar('$f_classInstructorArray',$f_classInstructorArray);
/* */
}
/* * /
for ($i=count($f_classDaysArray); $i<$f_maxMeetingRows; $i++) { $f_classDaysArray[$i] = ''; }
for ($i=count($f_classTimeStartArray); $i<$f_maxMeetingRows; $i++) { $f_classTimeStartArray[$i] = ''; }
for ($i=count($f_classTimeStopArray); $i<$f_maxMeetingRows; $i++) { $f_classTimeStopArray[$i] = ''; }
for ($i=count($f_classRoomBldgArray); $i<$f_maxMeetingRows; $i++) { $f_classRoomBldgArray[$i] = ''; }
for ($i=count($f_classRoomNumberArray); $i<$f_maxMeetingRows; $i++) { $f_classRoomNumberArray[$i] = ''; }
for ($i=count($f_classInstructorArray); $i<$f_maxMeetingRows; $i++) { $f_classInstructorArray[$i] = ''; }
/* */
for ($instructorIndex=0; $instructorIndex<count($f_classInstructorArray); $instructorIndex++) { // Loop through all of the instructors.
if ( $ClassAddFormParsePerform_DEBUG ) printVar('<br>'.$f_classInstructorArray[$instructorIndex],$f_courseNumber);
if ( strstr($f_classInstructorArray[$instructorIndex],',') ) {
// Last,First
list($f_userLastName,$f_userFirstName) = explode(",",$f_classInstructorArray[$instructorIndex]);
} else {
// Staff ?
$f_userLastName = '';
$f_userFirstName = $f_classInstructorArray[$instructorIndex];
}
// Get this instructor's userId.
$query = "
SELECT userId
FROM `user`
WHERE userFirstName = '".mysql_safe($f_userFirstName)."'
AND userLastName = '".mysql_safe($f_userLastName)."'
ORDER BY userFirstName, userLastName
";
$userResult = query_do($query);
$userResultCount = $_SESSION['qry']['count'];
if (!$userResultCount) {
// Try using Nickname.
// Get this instructor's userId.
$query = "
SELECT userId
FROM `user`
WHERE userNickName = '".mysql_safe($f_userFirstName)."'
AND userLastName = '".mysql_safe($f_userLastName)."'
ORDER BY userFirstName, userLastName
";
$userResult = query_do($query);
$userResultCount = $_SESSION['qry']['count'];
}
#if ($userResultCount != 1) {
if ($userResultCount) {
mysql_data_seek($userResult, 0);
$userRow = mysql_fetch_assoc($userResult);
$f_userId = $userRow['userId'];
if ( $ClassAddFormParsePerform_DEBUG ) printVar('$f_userId',$f_userId);
} else {
// userId not found.
// INSERT the user.
$f_lastModified = currentDateTime();
if ( $f_userFirstName != '') { $f_userUsername = $f_userFirstName.'_'.substr($f_userLastName,0,1); } else { $f_userUsername = $f_userFirstName; }
$query = "
INSERT
INTO `user` (
userUsername,
userFirstName,
userLastName,
lastModified,
modifiedBy
) VALUES (
'".mysql_safe($f_userUsername)."',
'".mysql_safe($f_userFirstName)."',
'".mysql_safe($f_userLastName)."',
'".mysql_safe($f_lastModified)."',
".$_SESSION['trueuserId']."
)
";
if ( $ClassAddFormParsePerform_DEBUG ) {
printVar('userInsert',$query);
$f_userId = 0;
} else {
$userInsert = query_do($query);
$f_userId = mysql_insert_id();
}
$f_message .= "User $f_userFirstName $f_userLastName created ($f_userUsername) (#$f_userId).<br>";
}
#if ( $ClassAddFormParsePerform_DEBUG ) printVar('$f_userId',$f_userId);
// Find the courseId for this class and user.
$query = "
SELECT *
FROM `course`
WHERE courseNumber = '".mysql_safe($f_courseNumber)."'
AND userId = '".$f_userId."'
ORDER BY courseId
";
$courseResult = query_do($query);
$courseResultCount = $_SESSION['qry']['count'];
#if ( $ClassAddFormParsePerform_DEBUG ) printVar('$courseResultCount',$courseResultCount);
if ( $courseResultCount ) {
// Use the user's course.
mysql_data_seek($userResult, 0);
$courseRow = mysql_fetch_assoc($courseResult);
$f_courseId = $courseRow['courseId'];
$f_class_facultyIsPrimary_userId = $f_userId;
if ( $ClassAddFormParsePerform_DEBUG ) printVar('Course found',$f_courseId);
} else {
// courseId not found for this user.
// Try to find this courseId for any user.
$query = "
SELECT *
FROM `course`
WHERE courseNumber = '".mysql_safe($f_courseNumber)."'
ORDER BY lastModified DESC
";
$courseResult = query_do($query);
$courseResultCount = $_SESSION['qry']['count'];
#if ( $ClassAddFormParsePerform_DEBUG ) printVar('$courseResultCount',$courseResultCount);
if ( $courseResultCount ) {
// Found another user's course.
// Copy this course but as inactive.
mysql_data_seek($courseResult, 0);
$courseRow = mysql_fetch_assoc($courseResult);
$f_class_facultyIsPrimary_userId = $courseRow['userId'];
$f_courseNumber = $courseRow['courseNumber'];
$f_courseTitle = $courseRow['courseTitle']; if (is_null($f_courseTitle)) $f_courseTitle = '';
$f_courseShortTitle = $courseRow['courseShortTitle']; if (is_null($f_courseShortTitle)) $f_courseShortTitle = '';
$f_courseCredits = $courseRow['courseCredits']; if (is_null($f_courseCredits)) $f_courseCredits = 0;
$f_courseCreditsMax = $courseRow['courseCreditsMax']; if (is_null($f_courseCreditsMax)) $f_courseCreditsMax = 0;
$f_courseDescription = $courseRow['courseDescription']; if (is_null($f_courseDescription)) $f_courseDescription = '';
$f_coursePrerequisite = $courseRow['coursePrerequisite']; if (is_null($f_coursePrerequisite)) $f_coursePrerequisite = '';
$f_courseCorequisite = $courseRow['courseCorequisite']; if (is_null($f_courseCorequisite)) $f_courseCorequisite = '';
$f_lastModified = currentDateTime();
$query = "
INSERT
INTO `course` (
userId,
YRTR,
courseNumber,
courseTitle,
courseShortTitle,
courseCredits,
courseCreditsMax,
courseInactive,
lastModified,
modifiedBy,
courseDescription,
coursePrerequisite,
courseCorequisite
) VALUES (
".$f_userId.",
'".mysql_safe($f_YRTR)."',
'".mysql_safe($f_courseNumber)."',
'".mysql_safe($f_courseTitle)."',
'".mysql_safe($f_courseShortTitle)."',
".$f_courseCredits.",
".$f_courseCreditsMax.",
1,
'".mysql_safe($f_lastModified)."',
".$_SESSION['trueuserId'].",
'".mysql_safe($f_courseDescription)."',
'".mysql_safe($f_coursePrerequisite)."',
'".mysql_safe($f_courseCorequisite)."'
)
";
if ( $ClassAddFormParsePerform_DEBUG ) {
printVar('courseInsert',$query);
$f_courseId = 0;
} else {
$courseInsert = query_do($query);
$f_courseId = mysql_insert_id();
}
$f_message .= "Course $f_courseNumber copied from ".username($f_class_facultyIsPrimary_userId)." to ".username($f_userId)." (#$f_courseId).<br>";
if ( $ClassAddFormParsePerform_DEBUG ) printVar('Course copied',$f_courseId);
} else {
// No course found anywhere.
$f_class_facultyIsPrimary_userId = $f_userId;
// Create the course but as inactive
$f_lastModified = currentDateTime();
$query = "
INSERT
INTO `course` (
userId,
YRTR,
courseNumber,
courseInactive,
lastModified,
modifiedBy
) VALUES (
".$f_userId.",
'".mysql_safe($f_YRTR)."',
'".mysql_safe($f_courseNumber)."',
1,
'".mysql_safe($f_lastModified)."',
".$_SESSION['trueuserId']."
)
";
if ( $ClassAddFormParsePerform_DEBUG ) {
printVar('userInsert',$f_courseId);
$f_courseId = 0;
} else {
$courseInsert = query_do($query);
$f_courseId = mysql_insert_id();
}
$f_message .= "Course $f_courseNumber created for ".username($f_userId)." (#$f_courseId).<br>";
if ( $ClassAddFormParsePerform_DEBUG ) printVar('Course created',$f_courseId);
}
}
// We have a courseId and userId.
// See if this class already exists.
$query = "
SELECT classId
FROM `class`
WHERE courseId = ".$f_courseId."
AND YRTR = '".mysql_safe($f_YRTR)."'
AND RCclassId = '".mysql_safe($f_RCclassId)."'
";
$classResult = query_do($query);
$classResultCount = $_SESSION['qry']['count'];
if ($classResultCount) {
mysql_data_seek($classResult, 0);
$classRow = mysql_fetch_assoc($classResult);
$f_classId = $classRow['classId'];
// UPDATE the class information.
$f_lastModified = currentDateTime();
$query = "
UPDATE `class`
SET classSection = ".$f_classSection.",
lastModified = '".mysql_safe($f_lastModified)."',
modifiedBy = ".$_SESSION['trueuserId']."
WHERE classId = ".$f_classId."
";
if ( $ClassAddFormParsePerform_DEBUG ) {
printVar('classUpdate',$query);
} else {
$classUpdate = query_do($query);
}
$f_message .= "Class $f_courseNumber updated for ".username($f_userId).". (#$f_classId)<br>";
if ( $ClassAddFormParsePerform_DEBUG ) printVar('Class found',$f_classId);
} else {
// This class does not exist so create it.
$f_lastModified = currentDateTime();
$query = "
INSERT
INTO `class` (
courseId,
YRTR,
RCclassId,
classSection,
lastModified,
modifiedBy
) VALUES (
".$f_courseId.",
'".mysql_safe($f_YRTR)."',
'".mysql_safe($f_RCclassId)."',
".$f_classSection.",
'".mysql_safe($f_lastModified)."',
".$_SESSION['trueuserId']."
)
";
if ( $ClassAddFormParsePerform_DEBUG ) {
printVar('classInsert',$query);
$f_classId = 0;
} else {
$classInsert = query_do($query);
$f_classId = mysql_insert_id();
}
$f_message .= "Class $f_courseNumber created for ".username($f_userId).". (#$f_classId)<br>";
if ( $ClassAddFormParsePerform_DEBUG ) printVar('Class created',$f_classId);
}
// UPDATE classmeeting.
// First SELECT existing classmeeting records.
$query = "
SELECT classmeetingId
FROM `classmeeting`
WHERE classId = ".$f_classId."
";
$classmeetingResult = query_do($query);
$classmeetingResultCount = $_SESSION['qry']['count'];
if ($classmeetingResultCount) {
mysql_data_seek($classmeetingResult, 0);
while ($classmeetingRow = mysql_fetch_assoc($classmeetingResult)) {
$f_classmeetingId = $classmeetingRow['classmeetingId'];
// Second DELETE existing classmeeting_weekday records.
$query = "
DELETE
FROM `classmeeting_weekday`
WHERE classmeetingId = ".$f_classmeetingId."
";
if ( $ClassAddFormParsePerform_DEBUG ) {
printVar('classmeeting_weekdayDelete',$query);
} else {
$classmeeting_weekdayDelete = query_do($query);
}
}
// Third DELETE existing classmeeting records.
$query = "
DELETE
FROM `classmeeting`
WHERE classId = ".$f_classId."
";
if ( $ClassAddFormParsePerform_DEBUG ) {
printVar('classmeetingDelete',$query);
} else {
$classmeetingDelete = query_do($query);
}
}
// Clean up data.
#if ( !isset($f_classDaysArray[$instructorIndex]) ) $f_classDaysArray[$instructorIndex] = '';
#if ( !isset($f_classTimeStartArray[$instructorIndex]) ) $f_classTimeStartArray[$instructorIndex] = '';
#if ( !isset($f_classTimeStopArray[$instructorIndex]) ) $f_classTimeStopArray[$instructorIndex] = '';
#if ( !isset($f_classRoomBldgArray[$instructorIndex]) ) $f_classRoomBldgArray[$instructorIndex] = '';
#if ( !isset($f_classRoomNumberArray[$instructorIndex]) ) $f_classRoomNumberArray[$instructorIndex] = '';
// INSERT classmeeting records.
if ( $ClassAddFormParsePerform_DEBUG ) printVar('classDateStart',$f_classDateStartArray[$instructorIndex]);
if ( $ClassAddFormParsePerform_DEBUG ) printVar('classDateStop',$f_classDateStopArray[$instructorIndex]);
if ( $ClassAddFormParsePerform_DEBUG ) printVar('classTimeStart',$f_classTimeStartArray[$instructorIndex]);
if ( $ClassAddFormParsePerform_DEBUG ) printVar('classTimeStop',$f_classTimeStopArray[$instructorIndex]);
if ( $ClassAddFormParsePerform_DEBUG ) printVar('classRoomBldg',$f_classRoomBldgArray[$instructorIndex]);
if ( $ClassAddFormParsePerform_DEBUG ) printVar('classRoomNumber',$f_classRoomNumberArray[$instructorIndex]);
if ( $ClassAddFormParsePerform_DEBUG ) printVar('classInstructor',$f_classInstructorArray[$instructorIndex]);
// Setup variables for INSERT
$f_classDateStart = $f_classDateStartArray[$instructorIndex];
$f_classDateStop = $f_classDateStopArray[$instructorIndex];
if ( valid_time($f_classTimeStartArray[$instructorIndex]) ) {
$f_classTimeStart = valid_time($f_classTimeStartArray[$instructorIndex],'24');
$f_classTimeDescription = '';
} else {
$f_classTimeStart = '';
$f_classTimeDescription = $f_classTimeStartArray[$instructorIndex];
}
if ( isset($f_classTimeStopArray[$instructorIndex]) ) {
$f_classTimeStop = valid_time($f_classTimeStopArray[$instructorIndex],'24');
} else {
$f_classTimeStop = '';
}
if ( isset($f_classRoomBldgArray[$instructorIndex]) ) {
$f_classRoomBldg = $f_classRoomBldgArray[$instructorIndex];
} else {
$f_classRoomBldg = '';
}
$f_classRoomNumber = $f_classRoomNumberArray[$instructorIndex];
$f_classInstructor = $f_classInstructorArray[$instructorIndex];
$query = "
INSERT
INTO `classmeeting` (
classId,
";
if ( $f_classDateStart != '') {
$query .= "
classDateStart,
";
}
if ( $f_classDateStop != '') {
$query .= "
classDateStop,
";
}
if ( $f_classTimeDescription != '') {
$query .= "
classTimeDescription,
";
}
if ( $f_classTimeStart != '') {
$query .= "
classTimeStart,
";
}
if ( $f_classTimeStop != '') {
$query .= "
classTimeStop,
";
}
$query .= "
classRoomBldg,
classRoomNumber,
classInstructor
) VALUES (
".$f_classId.",
";
if ( $f_classDateStart != '') {
$query .= "
'".mysql_safe($f_classDateStart)."',
";
}
if ( $f_classDateStop != '') {
$query .= "
'".mysql_safe($f_classDateStop)."',
";
}
if ( $f_classTimeDescription != '') {
$query .= "
'".mysql_safe($f_classTimeDescription)."',
";
}
if ( $f_classTimeStart != '') {
$query .= "
'".mysql_safe($f_classTimeStart)."',
";
}
if ( $f_classTimeStop != '') {
$query .= "
'".mysql_safe($f_classTimeStop)."',
";
}
$query .= "
'".mysql_safe($f_classRoomBldg)."',
'".mysql_safe($f_classRoomNumber)."',
'".mysql_safe($f_classInstructor)."'
)
";
if ( $ClassAddFormParsePerform_DEBUG ) {
printVar('classmeetingInsert',$query);
$f_classmeetingId = 0;
} else {
$classmeetingInsert = query_do($query);
$f_classmeetingId = mysql_insert_id();
}
// UPDATE classmeeting_weekday
if ( $ClassAddFormParsePerform_DEBUG ) printVar('classDays',$f_classDaysArray[$instructorIndex]);
$f_classDays = $f_classDaysArray[$instructorIndex];
// INSERT the classmeeting days.
for ($i = 0, $j = strlen($f_classDays); $i < $j; $i++) {
// Find the weekday
$query = "
SELECT weekdayId,
weekday1
FROM `weekday`
WHERE weekday1 = '".strtoupper($f_classDays[$i])."'
";
$weekdayResult = query_do($query);
$weekdayResultCount = $_SESSION['qry']['count'];
if (!$weekdayResultCount) {
$weekdayRow = '';
$f_error = 'Day ('.$f_classDays[$i].') is not a valid day (UMTWHFS).<span class="pv_fl"> '.basename(__FILE__).':'.__LINE__.'</span>';
include('common/displayErrorsAndMessages.phpinc');
include('common/pageFooter.phpinc');
}
mysql_data_seek($weekdayResult, 0);
$weekdayRow = mysql_fetch_assoc($weekdayResult);
$query = "
INSERT
INTO `classmeeting_weekday` (
classmeetingId,
weekdayId
) VALUES (
".$f_classmeetingId.",
".$weekdayRow['weekdayId']."
)
";
if ( $ClassAddFormParsePerform_DEBUG ) {
printVar("\$class_weekdayInsert",$query);
} else {
$class_weekdayInsert = query_do($query);
}
}
// See if this user has a classfaculty record for this class.
$query = "
SELECT classfacultyId
FROM `classfaculty`
WHERE classId = ".$f_classId."
AND userId = ".$f_userId."
";
$classfacultyResult = query_do($query);
$classfacultyResultCount = $_SESSION['qry']['count'];
#if ($classfacultyResultCount != 1) {
if ($classfacultyResultCount) {
// There is alread a classfaculty record so do nothing
} else {
// There is no classfaculty record for this user.
// See if there are any classfaculty records for this class.
$query = "
SELECT classfacultyId
FROM `classfaculty`
WHERE classId = ".$f_classId."
";
$classfacultyResult = query_do($query);
$classfacultyResultCount = $_SESSION['qry']['count'];
if ( $f_class_facultyIsPrimary_userId == $f_userId ) {
// There are no classfaculty records for any user or this user is the primary.
// This user is the primary.
$f_class_facultyIsPrimary = 1;
} else {
// There is a classfaculty record for another user.
// This user is not the primary.
$f_class_facultyIsPrimary = 0;
}
if ( $ClassAddFormParsePerform_DEBUG ) printVar('$f_class_facultyIsPrimary_userId',$f_class_facultyIsPrimary_userId);
if ( $ClassAddFormParsePerform_DEBUG ) printVar('$f_userId',$f_userId);
if ( $ClassAddFormParsePerform_DEBUG ) printVar('$f_class_facultyIsPrimary',$f_class_facultyIsPrimary);
// INSERT the classfaculty record for this user.
$f_lastModified = currentDateTime();
$query = "
INSERT
INTO `classfaculty` (
classId,
userId,
class_facultyIsPrimary,
lastModified,
modifiedBy
) VALUES (
".$f_classId.",
".$f_userId.",
".$f_class_facultyIsPrimary.",
'".mysql_safe($f_lastModified)."',
".$_SESSION['trueuserId']."
)
";
if ( $ClassAddFormParsePerform_DEBUG ) {
printVar('classfacultyInsert',$query);
$f_classfacultyId = 0;
} else {
$classfacultyInsert = query_do($query);
$f_classfacultyId = mysql_insert_id();
}
if ( $f_class_facultyIsPrimary ) {
$f_message .= "Faculty record created for ".username($f_userId)." as primary instructor (#$f_classfacultyId).<br>";
} else {
$f_message .= "Faculty record created for ".username($f_userId)." as secondary instructor (#$f_classfacultyId).<br>";
}
if ( $ClassAddFormParsePerform_DEBUG ) printVar('Class faculty record created',$f_classfacultyId);
}
} // Loop through all of the instructors.
} // Loop through the classDataArray.
?>