| 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/Class/ |
Upload File : |
<?
// Admin/Class/ClassAddFormPerform.phpinc
debugTrackBegin();
$ClassAddFormPerform_DEBUG = false;
if ( $ClassAddFormPerform_DEBUG ) {
/* */
printVar('$f_courseId',$f_courseId);
printVar('$f_maxMeetingRows',$f_maxMeetingRows);
printVar('$f_classId',$f_classId);
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);
echo "<br>\n";
/* */
}
if ($_SESSION['uuid'] != $f_uuid) {
// Get the course number.
$query = "
SELECT courseNumber
FROM `course`
WHERE courseId = ".$f_courseId."
";
$courseResult = query_do($query);
$courseResultCount = $_SESSION['qry']['count'];
if (!$courseResultCount) {
$courseRow = '';
$f_error = 'The courseId ('.$f_courseId.') was not found in the database.<span class="pv_fl"> '.basename(__FILE__).':'.__LINE__.'</span>';
include('common/displayErrorsAndMessages.phpinc');
include('common/pageFooter.phpinc');
}
mysqli_data_seek($courseResult, 0);
$courseRow = mysqli_fetch_assoc($courseResult);
if ( !$f_classId ) {
// INSERT the class.
$f_lastModified = currentDateTime();
$query = "
INSERT INTO class (
courseId,
YRTR,
RCclassId,
classSection,
modifiedBy,
lastModified
) VALUES (
".$f_courseId.",
'".$_SESSION['YRTR']['User']."',
'".$f_RCclassId."',
".$f_classSection.",
".$_SESSION['userId'].",
'".$f_lastModified."'
)";
if ( !$ClassAddFormPerform_DEBUG ) {
$classInsert = query_do($query);
$f_classId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
} else {
printVar("\$query",$query);
$f_classId = 'bogus classId';
}
// INSERT the classmeetings.
for ($index=0; $index<$f_maxMeetingRows; $index++) {
// Setup classTimeDescription, classTimeStart and classTimeStop if Arranged.
if ( $f_classDaysArray[$index] != '' ) {
// INSERT this classmeeting.
if ( $f_classTimeStartArray[$index] != '' && $f_classTimeStartArray[$index] != 'Arranged' ) {
// Normal or blank class time.
$f_classTimeDescription = '';
$f_classTimeStart = $f_classTimeStartArray[$index];
$f_classTimeStop = $f_classTimeStopArray[$index];
} else {
// Arranged class time.
$f_classTimeDescription = $f_classTimeStartArray[$index];
$f_classTimeStart = '';
$f_classTimeStop = '';
}
$query = "
INSERT
INTO `classmeeting` (
classId
";
if ( $f_classTimeDescription ) {
$query .= "
,classTimeDescription
";
}
if ( $f_classTimeStart ) {
$query .= "
,classTimeStart
";
}
if ( $f_classTimeStop ) {
$query .= "
,classTimeStop
";
}
if ( $f_classRoomBldgArray[$index] ) {
$query .= "
,classRoomBldg
";
}
if ( $f_classRoomNumberArray[$index] ) {
$query .= "
,classRoomNumber
";
}
if ( $f_classInstructorArray[$index] ) {
$query .= "
,classInstructor
";
}
$query .= "
) VALUES (
".$f_classId."
";
if ( $f_classTimeDescription ) {
$query .= "
,'".query_safe($f_classTimeDescription)."'
";
}
if ( $f_classTimeStart ) {
$query .= "
,'".query_safe(valid_time($f_classTimeStart,'24'))."'
";
}
if ( $f_classTimeStop ) {
$query .= "
,'".query_safe(valid_time($f_classTimeStop,'24'))."'
";
}
if ( $f_classRoomBldgArray[$index] ) {
$query .= "
,'".query_safe($f_classRoomBldgArray[$index])."'
";
}
if ( $f_classRoomNumberArray[$index] ) {
$query .= "
,'".query_safe($f_classRoomNumberArray[$index])."'
";
}
if ( $f_classInstructorArray[$index] ) {
$query .= "
,'".query_safe($f_classInstructorArray[$index])."'
";
}
$query .= "
)
";
if ( !$ClassAddFormPerform_DEBUG ) {
$classmeetingInsert = query_do($query);
$f_classmeetingId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
} else {
printVar("\$query",$query);
$f_classmeetingId = 'bogus classmeetingId';
}
/* */
// INSERT the classmeeting days.
$f_classDays = $f_classDaysArray[$index];
for ($i = 0, $j = strlen($f_classDays); $i < $j; $i++) {
$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');
}
mysqli_data_seek($weekdayResult, 0);
$weekdayRow = mysqli_fetch_assoc($weekdayResult);
$query = "
INSERT
INTO `classmeeting_weekday` (
classmeetingId,
weekdayId
) VALUES (
".$f_classmeetingId.",
".$weekdayRow['weekdayId']."
)
";
if ( !$ClassAddFormPerform_DEBUG ) {
$class_weekdayInsert = query_do($query);
} else {
printVar("\$query",$query);
}
}
/* */
}
} // for ($index=0; $index<$f_maxMeetingRows; $index++)
// Display add message and stop reload.
$f_message = $f_RCclassId.' '.$courseRow['courseNumber'].'-'.$f_classSection.' added.';;
$_SESSION['message'] = $f_message;
} else {
// UPDATE the class.
$f_lastModified = currentDateTime();
$query = "
UPDATE `class`
SET RCclassId = '".query_safe($f_RCclassId)."',
classSection = ".$f_classSection.",
lastModified = '".query_safe($f_lastModified)."',
modifiedBy = ".$_SESSION['trueuserId']."
WHERE classId = ".$f_classId."
";
$classUpdate = query_do($query);
// UPDATE classmeetings;
// Get classmeetingId for this class.
$f_classId = formValue('classId');
$f_courseNumber = formValue('courseNumber');
$f_classSection = formValue('classSection');
$query = "
SELECT classmeetingId
FROM `classmeeting`
WHERE classId = ".$f_classId."
";
$classmeetingResult = query_do($query);
$classmeetingResultCount = $_SESSION['qry']['count'];
if ( $classmeetingResultCount ) {
mysqli_data_seek($classmeetingResult, 0);
while ($classmeetingRow = mysqli_fetch_assoc($classmeetingResult)) {
// DELETE all classmeeting_weekday entries.
$query = "
DELETE
FROM `classmeeting_weekday`
WHERE classmeetingId = ".$classmeetingRow['classmeetingId']."
";
$classmeeting_weekdayDelete = query_do($query);
}
// DELETE all classmeeting entries.
$query = "
DELETE
FROM `classmeeting`
WHERE classId = ".$f_classId."
";
$classmeeting_weekdayDelete = query_do($query);
}
// INSERT the classmeetings.
for ($index=0; $index<$f_maxMeetingRows; $index++) {
// Setup classTimeDescription, classTimeStart and classTimeStop if Arranged.
if ( $f_classDaysArray[$index] != '' ) {
// INSERT this classmeeting.
if ( $f_classTimeStartArray[$index] != '' && $f_classTimeStartArray[$index] != 'Arranged' ) {
// Normal or blank class time.
$f_classTimeDescription = '';
$f_classTimeStart = $f_classTimeStartArray[$index];
$f_classTimeStop = $f_classTimeStopArray[$index];
} else {
// Arranged class time.
$f_classTimeDescription = $f_classTimeStartArray[$index];
$f_classTimeStart = '';
$f_classTimeStop = '';
}
$query = "
INSERT
INTO `classmeeting` (
classId
";
if ( $f_classTimeDescription ) {
$query .= "
,classTimeDescription
";
}
if ( $f_classTimeStart ) {
$query .= "
,classTimeStart
";
}
if ( $f_classTimeStop ) {
$query .= "
,classTimeStop
";
}
if ( $f_classRoomBldgArray[$index] ) {
$query .= "
,classRoomBldg
";
}
if ( $f_classRoomNumberArray[$index] ) {
$query .= "
,classRoomNumber
";
}
if ( $f_classInstructorArray[$index] ) {
$query .= "
,classInstructor
";
}
$query .= "
) VALUES (
".$f_classId."
";
if ( $f_classTimeDescription ) {
$query .= "
,'".query_safe($f_classTimeDescription)."'
";
}
if ( $f_classTimeStart ) {
$query .= "
,'".query_safe(valid_time($f_classTimeStart,'24'))."'
";
}
if ( $f_classTimeStop ) {
$query .= "
,'".query_safe(valid_time($f_classTimeStop,'24'))."'
";
}
if ( $f_classRoomBldgArray[$index] ) {
$query .= "
,'".query_safe($f_classRoomBldgArray[$index])."'
";
}
if ( $f_classRoomNumberArray[$index] ) {
$query .= "
,'".query_safe($f_classRoomNumberArray[$index])."'
";
}
if ( $f_classInstructorArray[$index] ) {
$query .= "
,'".query_safe($f_classInstructorArray[$index])."'
";
}
$query .= "
)
";
if ( !$ClassAddFormPerform_DEBUG ) {
$classmeetingInsert = query_do($query);
$f_classmeetingId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
} else {
printVar("\$query",$query);
$f_classmeetingId = 'bogus classmeetingId';
}
// INSERT the classmeeting days.
$f_classDays = $f_classDaysArray[$index];
for ($i = 0, $j = strlen($f_classDays); $i < $j; $i++) {
$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');
}
mysqli_data_seek($weekdayResult, 0);
$weekdayRow = mysqli_fetch_assoc($weekdayResult);
$query = "
INSERT
INTO `classmeeting_weekday` (
classmeetingId,
weekdayId
) VALUES (
".$f_classmeetingId.",
".$weekdayRow['weekdayId']."
)
";
if ( !$ClassAddFormPerform_DEBUG ) {
$class_weekdayInsert = query_do($query);
} else {
printVar("\$query",$query);
}
}
/* */
}
} // for ($index=0; $index<$f_maxMeetingRows; $index++)
// Display add message and stop reload.
$f_message = $f_RCclassId.' '.$courseRow['courseNumber'].'-'.$f_classSection.' updated.';
$_SESSION['message'] = $f_message;
}
if ( !$ClassAddFormPerform_DEBUG ) {
$_SESSION['uuid'] = $f_uuid;
}
} else {
$f_message = $_SESSION['message'];
}
debugTrackEnd();
?>