| 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 : |
<?
// ClassAdd.phpinc
debugTrackBegin();
$f_courseId = formValue('courseId');
$f_courseNumber = formValue('courseNumber');
$f_classId = formValue('classId');
$f_RCclassId = formValue('RCclassId');
$f_classSection = formValue('classSection');
$f_classDays = strtoupper(str_replace(" ","",formValue('classDays'))); // classDays = array();
$f_classTimeStart = formValue('classTimeStart'); // classTimeStart = array();
$f_classTimeStop = formValue('classTimeStop'); // classTimeStop = array();
$f_classRoomBldg = formValue('classRoomBldg'); // classRoomBldg = array();
$f_classRoomNumber = formValue('classRoomNumber'); // classRoomNumber = array();
$error = false;
$f_error = '';
// RCclassId
if (strlen($f_RCclassId) != 6 || !is_numeric($f_RCclassId)) {
$error = true;
$f_error .= 'ClassId ('.$f_RCclassId.') is not 6 digits long or is not a number.<br />';
}
// classSection
if ($f_classSection == '' || !is_numeric($f_classSection)) {
$error = true;
$f_error .= 'Section ('.$f_classSection.') is not a number.<br />';
}
// classDays
if ( preg_match_all("/[Uu]/",$f_classDays,$matches) > 1 ) {
$error = true;
$f_error .= 'Days ('.$f_classDays.') has more than one Sunday (U).<br />';
}
if ( preg_match_all("/[Mm]/",$f_classDays,$matches) > 1 ) {
$error = true;
$f_error .= 'Days ('.$f_classDays.') has more than one Monday (M).<br />';
}
if ( preg_match_all("/[Tt]/",$f_classDays,$matches) > 1 ) {
$error = true;
$f_error .= 'Days ('.$f_classDays.') has more than one Tuesday (T).<br />';
}
if ( preg_match_all("/[Ww]/",$f_classDays,$matches) > 1 ) {
$error = true;
$f_error .= 'Days ('.$f_classDays.') has more than one Wednesday (W).<br />';
}
if ( preg_match_all("/[Hh]/",$f_classDays,$matches) > 1 ) {
$error = true;
$f_error .= 'Days ('.$f_classDays.') has more than one Thursday (H).<br />';
}
if ( preg_match_all("/[Ff]/",$f_classDays,$matches) > 1 ) {
$error = true;
$f_error .= 'Days ('.$f_classDays.') has more than one Friday (F).<br />';
}
if ( preg_match_all("/[Ss]/",$f_classDays,$matches) > 1 ) {
$error = true;
$f_error .= 'Days ('.$f_classDays.') has more than one Saturday (S).<br />';
}
if ( preg_match_all("/[^UuMmTtWwHhFfSs]/",$f_classDays,$matches) > 0 ) {
$error = true;
$f_error .= 'Days ('.$f_classDays.') has non-day characters (UMTWHFS).<br />';
}
// classTimeStart
if ( valid_time($f_classTimeStart) ) {
$f_classTimeStart = valid_time($f_classTimeStart);
} else {
$error = true;
$f_error .= 'Start time ('.$f_classTimeStart.') is not a valid time.<br />';
}
#printVar('valid_time($f_classTimeStart,24,true)',valid_time($f_classTimeStart,24,true));
// classTimeStop
if ( valid_time($f_classTimeStop) ) {
$f_classTimeStop = valid_time($f_classTimeStop);
#printVar('strtotime($f_classTimeStart)',strtotime($f_classTimeStart));
#printVar('strtotime($f_classTimeStop)',strtotime($f_classTimeStop));
if ( strtotime($f_classTimeStart) >= strtotime($f_classTimeStop) ) {
$error = true;
$f_error .= 'Start time ('.$f_classTimeStart.') is not before Stop time ('.$f_classTimeStop.').<br />';
}
} else {
$error = true;
$f_error .= 'Start time ('.$f_classTimeStop.') is not a valid time.<br />';
}
// classRoomBldg
if ($f_classRoomBldg == '') {
$error = true;
$f_error .= 'Bldg is blank.<br />';
}
// classRoomNumber
if ($f_classRoomNumber == '') {
$error = true;
$f_error .= 'Rm is blank.<br />';
}
if (!$error) {
if ($_SESSION['uuid'] != $f_uuid) {
// 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."'
)";
printVar("\$query",$query);
#$classInsert = query_do($query);
$f_classId = mysql_insert_id();
// INSERT the classmeetings.
// INSERT the classmeeting days.
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');
}
mysql_data_seek($weekdayResult, 0);
$weekdayRow = mysql_fetch_assoc($weekdayResult);
$query = "
INSERT
INTO `class_weekday` (
classId,
weekdayId
) VALUES (
".$f_classId.",
".$weekdayRow['weekdayId']."
)
";
printVar("\$query",$query);
#$class_weekdayInsert = query_do($query);
}
// Display add message and stop reload.
$f_message = $f_RCclassId.' '.$f_courseNumber.' '.$f_classSection.' class added.';
#$_SESSION['uuid'] = $f_uuid;
$_SESSION['message'] = $f_message;
} else {
$f_message = $_SESSION['message'];
}
}
debugTrackEnd();
?>