| 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/ClassRosterProcess.phpinc
debugTrackBegin();
#$DEBUG_ClassRosterProcess = true;
#$DEBUG_ClassRosterProcess = false;
#d_Var("\$_SESSION",$_SESSION,'d');
#d_Var("\$_SERVER['REMOTE_ADDR']",$_SERVER['REMOTE_ADDR']);
#if ( $_SERVER['REMOTE_ADDR'] == '10.14.16.25' ) { $DEBUG_ClassRosterProcess = true; }
if (!isset($DEBUG_ClassRosterProcess)) { $DEBUG_ClassRosterProcess= false; }
if ($DEBUG_ClassRosterProcess) {
if ( !isset($_SESSION['PageHeaderLoaded']) || !$_SESSION['PageHeaderLoaded'] ) {
$headTitle = __FILE__;
$pageTitle = __FILE__;
include('common/pageHeader.phpinc');
}
}
$GLOBALS['debugOn'] = false;
if ($DEBUG_ClassRosterProcess) { echo basename(__FILE__),":",__LINE__,": ",".".__FILE__.".<br>\n"; }
if ($_SESSION['uuid'] != $f_uuid) {
if ($f_subtask == "Process Changes" || $f_subtask == "Process Adds Only") {
$f_classRosterAdd = 1;
} else {
$f_classRosterAdd = 0;
}
if ($f_subtask == "Process Changes" || $f_subtask == "Process Drops Only") {
$f_classRosterDrop = 1;
} else {
$f_classRosterDrop = 0;
}
$f_classRosterEnteredCount = formValue('classRosterEnteredCount');
if ($DEBUG_ClassRosterProcess) {
d_Var("\$f_classRosterAdd",$f_classRosterAdd,'d');
d_Var("\$f_classRosterDrop",$f_classRosterDrop,'d');
d_Var("\$f_classRosterEnteredCount",$f_classRosterEnteredCount,'d');
d_Var('$_POST',$_POST,'d');
}
if ($f_classRosterEnteredCount) {
for ($i=0; $i<$f_classRosterEnteredCount; $i++) {
if ($DEBUG_ClassRosterProcess) { d_Var('Student ',$i,'dabA/'); }
$f_Action = formValue('Action_'.$i);
$f_userStarID = formValue('userStarID_'.$i);
$f_userStudentId = formValue('userStudentId_'.$i);
$f_userFirstName = formValue('userFirstName_'.$i);
$f_userLastName = formValue('userLastName_'.$i);
$f_userMiddleName = formValue('userMiddleName_'.$i);
$f_userClassification = formValue('Classification_'.$i);
$f_credits = formValue('Credits_'.$i);
$f_userMajor = formValue('Major_'.$i);
$f_userAdvisor = formValue('Advisor_'.$i);
if ($DEBUG_ClassRosterProcess) {
d_Var("\$f_Action",$f_Action,'d');
d_Var("\$f_userStarID",$f_userStarID,'d');
d_Var("\$f_userStudentId",$f_userStudentId,'d');
d_Var("\$f_userFirstName",$f_userFirstName,'d');
d_Var("\$f_userLastName",$f_userLastName,'d');
d_Var("\$f_userMiddleName",$f_userMiddleName,'d');
d_Var("\$f_userClassification",$f_userClassification,'d');
d_Var("\$f_credits",$f_credits,'d');
d_Var("\$f_userMajor",$f_userMajor,'d');
d_Var("\$f_userAdvisor",$f_userAdvisor,'d');
#exit;
}
if ($f_classRosterAdd == 1 && $f_Action == "Add") {
if ($DEBUG_ClassRosterProcess) {
echo basename(__FILE__)," line ",__LINE__,": ",'<span class="user',$f_Action,'">',$f_userStudentId,' ',$f_userFirstName,' ',$f_userLastName,'</span> added.<br>';
}
$f_lastModified = currentDateTime();
$query = "
INSERT INTO classstudent (
classId,
classstudentCredits,
userStarID,
userStudentId,
userFirstName,
userMiddleName,
userLastName,
LastModified,
modifiedBy
) VALUES (
".$f_classId.",
".$f_credits.",
'".$f_userStarID."',
'".$f_userStudentId."',
'".$f_userFirstName."',
'".$f_userMiddleName."',
'".$f_userLastName."',
'".$f_lastModified."',
".$_SESSION['userId']."
)";
if ($DEBUG_ClassRosterProcess) {
d_Var("classstudentInsert",$query,'dq');
}
$classstudentInsert = query_do($query);
}
if ($f_classRosterDrop == 1 && $f_Action == "Drop") {
if ($DEBUG_ClassRosterProcess) {
echo basename(__FILE__)," line ",__LINE__,": ",'<span class="user',$f_Action,'">',$f_userStudentId,' ',$f_userFirstName,' ',$f_userLastName,'</span> dropped.<br>';
}
$query = "
DELETE FROM classstudent
WHERE classId = ".$f_classId."
AND userStudentId = '".$f_userStudentId."'
AND userFirstName = '".$f_userFirstName."'
AND userLastName = '".$f_userLastName."'
";
if ($DEBUG_ClassRosterProcess) {
d_Var("classstudentDelete",$query,'d');
}
$classstudentDelete = query_do($query);
}
if ($f_Action == "Both") {
if ($DEBUG_ClassRosterProcess) {
echo basename(__FILE__)," line ",__LINE__,": ",'<span class="user',$f_Action,'">',$f_userStudentId,' ',$f_userFirstName,' ',$f_userLastName,'</span> retained.<br>';
}
}
if ($f_Action == "Add" || $f_Action == "Both") {
// See if this user is in user table.
$query = "
SELECT *
FROM `user`
WHERE userUsername = '".$f_userStarID."'
";
$userResult = query_do($query);
$userCount = $_SESSION['qry']['count'];
if ($DEBUG_ClassRosterProcess) {
d_Var("userResult",$query,'dq');
d_Var('$userCount',$userCount,'d');
if ( $userCount ) { d_Var('$userResult',$userResult,'dk'); } else { echo '<b class="error bold">'.$f_userStarID.' not in user table.</b><br>'."\n"; }
}
if ( $userCount == 0 ) { // Is the user in the user table?
// No, INSERT the user.
$f_lastModified = currentDateTime();
$query = "
INSERT INTO `user` (
userUsername,
userStudentId,
userFirstName,
userMiddleName,
userLastName,
userIsStudent,
userComments,
lastModified,
modifiedBy
) VALUES (
'".$f_userStarID."',
'".$f_userStudentId."',
'".query_safe($f_userFirstName)."',
'".query_safe($f_userMiddleName)."',
'".query_safe($f_userLastName)."',
1,
'User added by class roster.',
'".$f_lastModified."',
".$_SESSION['userId']."
)";
if ($DEBUG_ClassRosterProcess) {
d_Var("userInsert",$query,'dq');
}
$userInsert = query_do($query);
} else { // Is the user in the user table?
// Yes, UPDATE user data.
$query = "
UPDATE `user`
SET userFirstName = '".query_safe($f_userFirstName)."',
userMiddleName = '".query_safe($f_userMiddleName)."',
userLastName = '".query_safe($f_userLastName)."',
userPasswordMD5 = NULL
WHERE userUsername = '".$f_userStarID."'
";
if ($DEBUG_ClassRosterProcess) {
d_Var("userUpdate",$query,'dq');
}
if ($DEBUG_ClassRosterProcess) {
#setDebugOn(); include('common/pageFooter.phpinc');
}
$userUpdate = query_do($query);
} // Is the user in the user table?
// See if this user is in userdata table.
$query = "
SELECT *
FROM userdata
WHERE userStudentId = '".$f_userStudentId."'
";
$userdataResult = query_do($query);
$userdataCount = $_SESSION['qry']['count'];
if ($DEBUG_ClassRosterProcess) {
d_Var("userdataResult",$query,'dq');
d_Var('$userdataCount',$userdataCount,'d');
d_Var('$userdataResult',$userdataResult,'dk');
}
if ($userdataCount) {
// The user is already in userdata. UPDATE the user data.
$query = "
UPDATE userdata
SET userStudentId = '".$f_userStudentId."',
userAdvisor = '".$f_userAdvisor."',
userClassification = '".$f_userClassification."',
userMajor = '".$f_userMajor."'
WHERE userStudentId = '".$f_userStudentId."'
";
if ($DEBUG_ClassRosterProcess) {
d_Var("\$userdataUpdate",$query,'dq');
}
$userdataUpdate = query_do($query);
} else {
// The user not in userdata. INSERT the user data.
$query = "
INSERT INTO userdata (
userStudentId,
userAdvisor,
userClassification,
userMajor
) VALUES ( '".$f_userStudentId."',
'".$f_userAdvisor."',
'".$f_userClassification."',
'".$f_userMajor."'
)";
if ($DEBUG_ClassRosterProcess) {
d_Var("userdataInsert",$query,'dq');
}
$userdataInsert = query_do($query);
}
}
}
}
if (!$DEBUG_ClassRosterProcess) {
$_SESSION['uuid'] = $f_uuid;
}
}
debugTrackEnd();
if ($DEBUG_ClassRosterProcess) {
setDebugOn(); include('common/pageFooter.phpinc');
}
?>