| 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 : |
<?
// classRosterVerify.phpinc
debugTrackBegin();
#setDebugOn();
setDebugOff();
#d_On();
$js = "ClassEvaluations,wforms";
$headTitle = '_CST_ - '.$f_courseNumber;
$pageTitle = '_CST_<br>'.$f_courseNumber;
include('common/pageHeader.phpinc');
#if (dc()) echo "<b>".__FILE__."</b><br>\n";
$f_classRoster = formValue('classRoster');
$sectionTitle = '_CST_ - '.$f_courseNumber.' Class Roster';
include('common/sectionHeader.phpinc');
// Get current class roster.
$classRosterCurrent = array();
$query = "
SELECT
userStudentId,
userFirstName,
userLastName
FROM classstudent
WHERE classstudent.classId = ".$f_classId."
";
$classstudentResult = query_do($query);
$classstudentCount = $_SESSION['mysql_num_rows'];
$classRosterCurrentCount = 0;
if ($classstudentCount) {
mysql_data_seek($classstudentResult, 0);
while ($classstudentRow = mysql_fetch_assoc($classstudentResult)) {
//$classRosterCurrent[$i] = array();
$classRosterCurrent['userStudentId'][$classRosterCurrentCount] = $classstudentRow['userStudentId'];
$classRosterCurrent['userLastName'][$classRosterCurrentCount] = $classstudentRow['userLastName'];
$classRosterCurrent['userFirstName'][$classRosterCurrentCount] = $classstudentRow['userFirstName'];
$classRosterCurrentCount++;
}
} else {
$classRosterCurrent = array();
$classRosterCurrent['userStudentId'] = array();
}
if (dc()) {
printVar("\$classRosterCurrent",$classRosterCurrent);
}
$classRosterAdd = 0;
// Get class roster entered.
$classRosterEntered = array();
$classRosterLines = explode("\n",$f_classRoster);
$classRosterLineCount = count($classRosterLines);
if (dc()) {
printVar("\$classRosterLineCount",$classRosterLineCount);
}
$classRosterEntered = array();
if ( $classRosterLineCount ) {
// Parse the class roster line.
$classRosterEnteredCount = 0;
for( $i=0; $i<$classRosterLineCount; $i++ ) {
#echo "<br>\$classRosterLines[$i]=".$classRosterLines[$i]." ".__LINE__."<br>\n";
#if (dc()) printVar("\$classRosterLines[$i]",$classRosterLines[$i]);
if ( strstr($classRosterLines[$i],"\t") ) {
// Class line contains tab - copied with Firefox.
$classRosterLine = explode("|",str_replace(" \t","|",$classRosterLines[$i]));
if (dc()) printVar("\$classRosterLine",$classRosterLine);
if ( $classRosterLine[6] != 'W' ) {
// No 'W' found. This is a current student line.
if (dc()) printLine("Process line.");
$classRosterLines[$i] = trim($classRosterLines[$i]);
// The userStudentId is the first 8 characters. Get the userStudentId.
$classRosterEntered['userStudentId'][$classRosterEnteredCount] = $classRosterLine[0];
if (dc()) printVar("\$classRosterEntered['userStudentId'][$classRosterEnteredCount]",$classRosterEntered['userStudentId'][$classRosterEnteredCount],'f');
// Get the user name.
$userName = explode(" ",str_replace(",","",$classRosterLine[1]));
#printVar('$userName',$userName);
if ( count($userName) > 1 ) {
// The userLastName is the first one.
$classRosterEntered['userLastName'][$classRosterEnteredCount] = array_shift($userName);
// The userFirstName is the second one.
$classRosterEntered['userFirstName'][$classRosterEnteredCount] = array_shift($userName);
// The userMiddleName is the rest.
$classRosterEntered['userMiddleName'][$classRosterEnteredCount] = str_replace(","," ",arrayToList($userName));
} else {
// The userFirstName is the only one.
$classRosterEntered['userFirstName'][$classRosterEnteredCount] = array_shift($userName);
$classRosterEntered['userLastName'][$classRosterEnteredCount] = '';
$classRosterEntered['userMiddleName'][$classRosterEnteredCount] = '';
}
if (dc()) {
printVar("\$classRosterEntered['userFirstName'][$classRosterEnteredCount]",$classRosterEntered['userFirstName'][$classRosterEnteredCount],'f');
printVar("\$classRosterEntered['userLastName'][$classRosterEnteredCount]",$classRosterEntered['userLastName'][$classRosterEnteredCount],'f');
printVar("\$classRosterEntered['userMiddleName'][$classRosterEnteredCount]",$classRosterEntered['userMiddleName'][$classRosterEnteredCount],'f');
}
// Get the major.
$classRosterEntered['Major'][$classRosterEnteredCount] = $classRosterLine[2];
// Get the classification.
$classRosterEntered['Classification'][$classRosterEnteredCount] = $classRosterLine[3];
if (dc()) {
printVar("\$classRosterEntered['Classification'][$classRosterEnteredCount]",$classRosterEntered['Classification'][$classRosterEnteredCount],'f');
printVar("\$classRosterEntered['Major'][$classRosterEnteredCount]",$classRosterEntered['Major'][$classRosterEnteredCount],'f');
}
// Get credits.
$classRosterEntered['Credits'][$classRosterEnteredCount] = floatval($classRosterLine[4]);
// Get the student Advisor.
$classRosterEntered['Advisor'][$classRosterEnteredCount] = $classRosterLine[6];
if (dc()) {
printVar("\$classRosterEntered['Advisor'][$classRosterEnteredCount]",$classRosterEntered['Advisor'][$classRosterEnteredCount],'f');
printVar("\$classRosterEntered['Credits'][$classRosterEnteredCount]",$classRosterEntered['Credits'][$classRosterEnteredCount],'f');
}
// Is the entered user in the current array.
if ( in_array($classRosterEntered['userStudentId'][$classRosterEnteredCount],$classRosterCurrent['userStudentId']) ) {
$classRosterEntered['Action'][$classRosterEnteredCount] = 'Both';
} else {
$classRosterEntered['Action'][$classRosterEnteredCount] = 'Add';
$classRosterAdd = 1;
}
if (dc()) {
printVar("\$classRosterEntered['Action'][$classRosterEnteredCount]",$classRosterEntered['Action'][$classRosterEnteredCount]);
}
$classRosterEnteredCount++;
} else {
#$classRosterEnteredCount--;
if (dc()) printLine("Do not process 'W'.");
}
} else {
//No tabs.
$classRosterLine = explode("|",str_replace(" ","|",$classRosterLines[$i]));
if (dc()) printVar("\$classRosterLine",$classRosterLine);
if ( substr($classRosterLine[3],0,1) != 'W' ) {
// No 'W' found. This is a current student line.
if (dc()) printLine("Process line.");
$classRosterLines[$i] = trim($classRosterLines[$i]);
// The userStudentId is the first 8 characters. Get the userStudentId.
$classRosterEntered['userStudentId'][$classRosterEnteredCount] = substr($classRosterLine[0],0,8);
if (dc()) printVar("\$classRosterEntered['userStudentId'][$classRosterEnteredCount]",$classRosterEntered['userStudentId'][$classRosterEnteredCount],'f');
// Strip the userStudentId.
$classRosterLine[0] = trim(substr($classRosterLine[0],8));
// Get the user name.
#$userName = explode(" ",str_replace(",","",$classRosterLine[0]));
$userName = explode(",",$classRosterLine[0]);
if (dc()) printVar('$userName',$userName);
if ( count($userName) > 1 ) {
// The userLastName is the first one.
$classRosterEntered['userLastName'][$classRosterEnteredCount] = trim(array_shift($userName));
// The userFirstName and userMiddleName is in the second one.
$userName = explode(" ",trim($userName[0]));
if (dc()) printVar('$userName',$userName);
// The userFirstName is the first one.
$classRosterEntered['userFirstName'][$classRosterEnteredCount] = array_shift($userName);
if ( count($userName) > 0 ) {
// The userMiddleName is the rest.
if (dc()) printVar('$userName',$userName);
$classRosterEntered['userMiddleName'][$classRosterEnteredCount] = arrayToList($userName,' ');
} else {
// The userMiddleName is the rest.
$classRosterEntered['userMiddleName'][$classRosterEnteredCount] = '';
}
} else {
// The userFirstName is the only one.
$classRosterEntered['userFirstName'][$classRosterEnteredCount] = array_shift($userName);
$classRosterEntered['userLastName'][$classRosterEnteredCount] = '';
$classRosterEntered['userMiddleName'][$classRosterEnteredCount] = '';
}
if (dc()) {
printVar("\$classRosterEntered['userFirstName'][$classRosterEnteredCount]",$classRosterEntered['userFirstName'][$classRosterEnteredCount],'f');
printVar("\$classRosterEntered['userLastName'][$classRosterEnteredCount]",$classRosterEntered['userLastName'][$classRosterEnteredCount],'f');
printVar("\$classRosterEntered['userMiddleName'][$classRosterEnteredCount]",$classRosterEntered['userMiddleName'][$classRosterEnteredCount],'f');
}
// Get the major and classification.
$userMajorClassification = explode(" ",$classRosterLine[1]);
// Classification is the last element.
$classRosterEntered['Classification'][$classRosterEnteredCount] = array_pop($userMajorClassification);
// Major is the rest.
$classRosterEntered['Major'][$classRosterEnteredCount] = str_replace(","," ",arrayToList($userMajorClassification));
if (dc()) {
printVar("\$classRosterEntered['Classification'][$classRosterEnteredCount]",$classRosterEntered['Classification'][$classRosterEnteredCount],'f');
printVar("\$classRosterEntered['Major'][$classRosterEnteredCount]",$classRosterEntered['Major'][$classRosterEnteredCount],'f');
}
// Get the student Advisor.
$classRosterEntered['Advisor'][$classRosterEnteredCount] = $classRosterLine[4];
// Get credits.
$classRosterEntered['Credits'][$classRosterEnteredCount] = floatval($classRosterLine[2]);
if (dc()) {
printVar("\$classRosterEntered['Advisor'][$classRosterEnteredCount]",$classRosterEntered['Advisor'][$classRosterEnteredCount],'f');
printVar("\$classRosterEntered['Credits'][$classRosterEnteredCount]",$classRosterEntered['Credits'][$classRosterEnteredCount],'f');
}
// Is the entered user in the current array.
if ( in_array($classRosterEntered['userStudentId'][$classRosterEnteredCount],$classRosterCurrent['userStudentId']) ) {
$classRosterEntered['Action'][$classRosterEnteredCount] = 'Both';
} else {
$classRosterEntered['Action'][$classRosterEnteredCount] = 'Add';
$classRosterAdd = 1;
}
if (dc()) {
printVar("\$classRosterEntered['Action'][$classRosterEnteredCount]",$classRosterEntered['Action'][$classRosterEnteredCount]);
}
$classRosterEnteredCount++;
} else {
#$classRosterEnteredCount--;
if (dc()) printLine("Do not process 'W'.");
}
}
}
} else {
$classRosterEnteredCount = 0;
}
if (dc()) printVar("\$classRosterEnteredCount",$classRosterEnteredCount);
#setDebugOn();
// Loop through the current array and ensure all users are in the entered array.
$classRosterDrop = 0;
if ( $classRosterCurrentCount ) {
for( $i=0; $i<$classRosterCurrentCount; $i++ ) {
if ( !in_array($classRosterCurrent['userStudentId'][$i],$classRosterEntered['userStudentId']) ) {
$classRosterEntered['Action'][$classRosterEnteredCount] = 'Drop';
$classRosterEntered['Advisor'][$classRosterEnteredCount] = '';
$classRosterEntered['Classification'][$classRosterEnteredCount] = '';
$classRosterEntered['Credits'][$classRosterEnteredCount] = '';
$classRosterEntered['Major'][$classRosterEnteredCount] = '';
$classRosterEntered['userStudentId'][$classRosterEnteredCount] = $classRosterCurrent['userStudentId'][$i];
$classRosterEntered['userLastName'][$classRosterEnteredCount] = $classRosterCurrent['userLastName'][$i];
$classRosterEntered['userFirstName'][$classRosterEnteredCount] = $classRosterCurrent['userFirstName'][$i];
$classRosterEntered['userMiddleName'][$classRosterEnteredCount] = '';
if (dc()) {
printVar("\$classRosterEntered['userStudentId'][$classRosterEnteredCount]",$classRosterEntered['userStudentId'][$classRosterEnteredCount]);
printVar("\$classRosterEntered['userLastName'][$classRosterEnteredCount]",$classRosterEntered['userLastName'][$classRosterEnteredCount]);
printVar("\$classRosterEntered['userFirstName'][$classRosterEnteredCount]",$classRosterEntered['userFirstName'][$classRosterEnteredCount]);
printVar("\$classRosterEntered['Action'][$classRosterEnteredCount]",$classRosterEntered['Action'][$classRosterEnteredCount]);
printVar("\$classRosterEntered['userMiddleName'][$classRosterEnteredCount]",$classRosterEntered['userMiddleName'][$classRosterEnteredCount]);
}
$classRosterEnteredCount++;
$classRosterDrop = 1;
}
}
}
// Sort classRosterEntered.
$changeMade = true;
while ($changeMade) {
$changeMade = false;
for($i=0; $i<$classRosterEnteredCount-1; $i++) {
$j = $i+1;
$tempi = $classRosterEntered['userLastName'][$i].' '.$classRosterEntered['userFirstName'][$i].' '.$classRosterEntered['userMiddleName'][$i].' '.$classRosterEntered['userStudentId'][$i];
$tempj = $classRosterEntered['userLastName'][$j].' '.$classRosterEntered['userFirstName'][$j].' '.$classRosterEntered['userMiddleName'][$j].' '.$classRosterEntered['userStudentId'][$j];
if ($tempi > $tempj) {
$tempi = $classRosterEntered['userStudentId'][$i];
$tempj = $classRosterEntered['userStudentId'][$j];
$classRosterEntered['userStudentId'][$i] = $tempj;
$classRosterEntered['userStudentId'][$j] = $tempi;
$tempi = $classRosterEntered['Advisor'][$i];
$tempj = $classRosterEntered['Advisor'][$j];
$classRosterEntered['Advisor'][$i] = $tempj;
$classRosterEntered['Advisor'][$j] = $tempi;
$tempi = $classRosterEntered['Classification'][$i];
$tempj = $classRosterEntered['Classification'][$j];
$classRosterEntered['Classification'][$i] = $tempj;
$classRosterEntered['Classification'][$j] = $tempi;
$tempi = $classRosterEntered['Credits'][$i];
$tempj = $classRosterEntered['Credits'][$j];
$classRosterEntered['Credits'][$i] = $tempj;
$classRosterEntered['Credits'][$j] = $tempi;
$tempi = $classRosterEntered['Major'][$i];
$tempj = $classRosterEntered['Major'][$j];
$classRosterEntered['Major'][$i] = $tempj;
$classRosterEntered['Major'][$j] = $tempi;
$tempi = $classRosterEntered['userLastName'][$i];
$tempj = $classRosterEntered['userLastName'][$j];
$classRosterEntered['userLastName'][$i] = $tempj;
$classRosterEntered['userLastName'][$j] = $tempi;
$tempi = $classRosterEntered['userFirstName'][$i];
$tempj = $classRosterEntered['userFirstName'][$j];
$classRosterEntered['userFirstName'][$i] = $tempj;
$classRosterEntered['userFirstName'][$j] = $tempi;
$tempi = $classRosterEntered['userMiddleName'][$i];
$tempj = $classRosterEntered['userMiddleName'][$j];
$classRosterEntered['userMiddleName'][$i] = $tempj;
$classRosterEntered['userMiddleName'][$j] = $tempi;
$tempi = $classRosterEntered['Action'][$i];
$tempj = $classRosterEntered['Action'][$j];
$classRosterEntered['Action'][$i] = $tempj;
$classRosterEntered['Action'][$j] = $tempi;
if (dc()) {
#printVar("\$classRosterEntered['userStudentId'][$i] > \$classRosterEntered['userStudentId'][$j]",$classRosterEntered['userStudentId'][$i].' '.$classRosterEntered['userStudentId'][$j].' After change.','');
}
$changeMade = true;
}
}
}
if (dc()) {
printVar("\$classRosterEntered",$classRosterEntered);
}
#printVar("\$classRosterEntered",$classRosterEntered);
if (dc()) {
#printVar("exit",'','fn'); exit;
}
// Display class roster changes.
?>
<form name="form_classlistenter" action="<?=php_self()?>" method="post" style="display:inline;">
<input name="f_uuid" type="hidden" value="<?=uuid()?>">
<input name="f_form" type="hidden" value="form_classlistenter">
<input name="f_classId" type="hidden" value="<?=$f_classId?>">
<input name="f_courseNumber" type="hidden" value="<?=$f_courseNumber?>">
<input name="f_courseId" type="hidden" value="<?=$f_courseId?>">
<input name="f_classRosterEnteredCount" type="hidden" value="<?=$classRosterEnteredCount?>">
<input name="f_task" type="hidden" value="Class Roster">
<fieldset><legend>Class Roster Changes</legend>
<?
if ($classRosterEnteredCount) {
$studentsPerColumn = (int) ($classRosterEnteredCount/4+.99);
//echo $studentsPerColumn."<br>\n";
?>
<table cellpadding="0" cellspacing="0"><tr>
<?
$studentsThisColumn = 0;
for ($i=0; $i<$classRosterEnteredCount; $i++) {
if ($studentsThisColumn == 0) {
?>
<td style="padding-right:10px;">
<?
}
?>
<span class="user<?=$classRosterEntered['Action'][$i]?>"><?=$classRosterEntered['userStudentId'][$i]?> <?=$classRosterEntered['userFirstName'][$i]?> <?=$classRosterEntered['userLastName'][$i]?></span><br />
<input type="hidden" name="f_Action_<?=$i?>" value="<?=$classRosterEntered['Action'][$i]?>" />
<input type="hidden" name="f_Advisor_<?=$i?>" value="<?=$classRosterEntered['Advisor'][$i]?>" />
<input type="hidden" name="f_Classification_<?=$i?>" value="<?=$classRosterEntered['Classification'][$i]?>" />
<input type="hidden" name="f_Credits_<?=$i?>" value="<?=$classRosterEntered['Credits'][$i]?>" />
<input type="hidden" name="f_Major_<?=$i?>" value="<?=$classRosterEntered['Major'][$i]?>" />
<input type="hidden" name="f_userFirstName_<?=$i?>" value="<?=$classRosterEntered['userFirstName'][$i]?>" />
<input type="hidden" name="f_userLastName_<?=$i?>" value="<?=$classRosterEntered['userLastName'][$i]?>" />
<input type="hidden" name="f_userMiddleName_<?=$i?>" value="<?=$classRosterEntered['userMiddleName'][$i]?>" />
<input type="hidden" name="f_userStudentId_<?=$i?>" value="<?=$classRosterEntered['userStudentId'][$i]?>" />
<?
$studentsThisColumn++;
if ($studentsThisColumn == $studentsPerColumn) {
$studentsThisColumn = 0;
?>
</td>
<?
}
}
if ($studentsThisColumn != 0) {
?>
</td>
<?
}
?>
</tr></table>
<?
} else {
?>
No students are in the class list.
<?
}
?>
</fieldset>
<?
if ( $classRosterAdd == 1 || $classRosterDrop == 1 ) {
?>
<input type="submit" name="f_subtask" value="Process Changes" class="small">
<?
}
if ( $classRosterAdd == 1 && $classRosterDrop == 1 ) {
?>
<input type="submit" name="f_subtask" value="Process Adds Only" class="small">
<?
}
if ( $classRosterAdd == 1 && $classRosterDrop == 1 ) {
?>
<input type="submit" name="f_subtask" value="Process Drops Only" class="small">
<?
}
if ( $classRosterAdd == 1 || $classRosterDrop == 1 ) {
?>
<input type="submit" name="f_subtask" value="Cancel" class="small50"><br />
<?
}
if ( $classRosterAdd == 0 && $classRosterDrop == 0 ) {
?>
<input type="submit" name="f_subtask" value="Done" class="small50"><br />
<?
}
?>
</form>
<span class="userBoth">Green = Student is already on the current class roster.</span><br />
<span class="userAdd">Blue = Student is not on the current class roster and will be added.</span><br />
<span class="userDrop">Red = Student is not on the new class roster and will be dropped.</span><br />
<?
include('common/sectionFooter.phpinc');
debugTrackEnd();
?>