| 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/StudentProfile/ |
Upload File : |
<?
// StudentProfile/StudentProfiles.phpinc
// Display a list of student Student Profiles.
if (!isset($courseNumber)) if (isset($f_courseNumber)) { $courseNumber = $f_courseNumber; } else { $courseNumber = ''; }
#printVar('$f_classId',$f_classId);
if ( !isset($sortBy) ) $sortBy = '';
switch ($sortBy) {
case 'Firstname':
$orderBy = "user.userFirstName, user.userLastName, user.userStudentId";
break;
case 'StudentId':
$orderBy = "user.userStudentId";
break;
default: // Lastname
$orderBy = "user.userLastName, user.userFirstName, user.userStudentId";
break;
}
#printQuery('$classRosterResult',$classRosterResult);
#printVar('$classRosterCount',$classRosterCount);
$f_classRoster_userId = query_to_list($classRosterResult,'userId',true,0);
if ($f_classRoster_userId) {
// Get count of Graded Student Profiles.
$query = "SELECT studentprofileId FROM studentprofile WHERE studentprofileGraded = 1 AND userId IN (".$f_classRoster_userId.")";
$result = query_do($query);
$GradedClassProfileCount = $_SESSION['qry']['count'];
#printVar('$GradedClassProfileCount',$GradedClassProfileCount);
// Get count of Ungraded Student Profiles.
$query = "SELECT studentprofileId FROM studentprofile WHERE studentProfileSubmitted = 1 AND studentprofileGraded = 0 AND userId IN (".$f_classRoster_userId.")";
$result = query_do($query);
$UngradedClassProfileCount = $_SESSION['qry']['count'];
#printVar('$UngradedClassProfileCount',$UngradedClassProfileCount);
// Get count of Unsubmitted Student Profiles.
$query = "SELECT studentprofileId FROM studentprofile WHERE studentProfileSubmitted = 0 AND userId IN (".$f_classRoster_userId.")";
$result = query_do($query);
$UnsubmittedClassProfileCount = $_SESSION['qry']['count'];
#printVar('$UnsubmittedClassProfileCount',$UnsubmittedClassProfileCount);
$NotEnteredClassProfileCount = $classRosterCount - $GradedClassProfileCount - $UngradedClassProfileCount - $UnsubmittedClassProfileCount;
#printVar('$NotEnteredClassProfileCount',$NotEnteredClassProfileCount);
#printVar('$classRosterCount',$classRosterCount);
#printVar('listLen($f_classRoster_userId)',listLen($f_classRoster_userId));
$classRoster_userId_Array = explode(',',$f_classRoster_userId);
// Get user information.
$query = "
SELECT user.userId,
user.userStudentId,
user.userFirstName,
user.userLastName,
user.userNickname,
user.userEmail,
user.userAccessTime
FROM user
WHERE user.userId IN (".$f_classRoster_userId.")
ORDER BY ".$orderBy."
";
} else {
$GradedClassProfileCount = 0;
$UngradedClassProfileCount = 0;
$UnsubmittedClassProfileCount = 0;
$NotEnteredClassProfileCount = 0;
$classRoster_userId_Array = array();
}
$StudentProfilestartedCountText = '<span class="normal">'.$classRosterCount.' total, <span class="userGraded">'.$GradedClassProfileCount.' Graded</span>, <span class="userUnGraded">'.$UngradedClassProfileCount.' Ungraded</span>, <span class="userNotSubmitted">'.$UnsubmittedClassProfileCount.' Un-submitted</span>, <span class="userNoEntry">'.$NotEnteredClassProfileCount.' Not entered</span>'.'</span>';
$studentsThisColumn = 0;
$query = "
SELECT studentProfilePoints
FROM class
WHERE classId IN (".$f_classId.")
";
$classProfilePointsResult = query_do($query);
$classProfilePointsCount = $_SESSION['qry']['count'];
if ($classProfilePointsCount) {
$classProfilePointsRow = mysqli_fetch_assoc($classProfilePointsResult);
$studentProfilePoints = $classProfilePointsRow['studentProfilePoints'];
} else {
$studentProfilePoints = 0;
}
?>
<fieldset><legend>Student Profile <span class="smaller">(<?=$StudentProfilestartedCountText?>)</span></legend>
<?
if ($classRosterCount) {
$studentsPerColumn = (int) ($classRosterCount/4+.99);
//echo $studentsPerColumn."<br>\n";
?>
<table cellpadding="0" cellspacing="0"><tr><td>
<?
#printQuery('$classRosterResult',$classRosterResult);
#mysqli_data_seek($classRosterResult, 0);
$studentsThisColumn = 0;
#echo count($classRoster_userId_Array);
foreach ($classRoster_userId_Array as $classRoster_userId) {
#echo $classRoster_userId;
#while ($classRosterRow = mysqli_fetch_assoc($classRosterResult)) {
// Get user info.
$query = "
SELECT user.userId,
user.userStudentId,
user.userFirstName,
user.userLastName,
user.userNickname,
user.userEmail,
user.userAccessTime
FROM user
WHERE user.userId = ".$classRoster_userId."
";
$userResult = query_do($query);
$userCount = $_SESSION['qry']['count'];
$userRow = mysqli_fetch_assoc($userResult);
#printVar('$userCount',$userCount);
#printQuery('$userResult',$userResult);
// Get the ClassProfile information for this user.
$query = "
SELECT studentprofileId,
studentProfileSubmitted,
studentprofileGraded,
lastModified,
studentprofileGradedOn
FROM studentprofile
WHERE userId = ".$classRoster_userId."
";
$studentprofileResult = query_do($query);
$studentprofileCount = $_SESSION['qry']['count'];
#printVar('$studentprofileCount',$studentprofileCount);
#printQuery('$studentprofileResult',$studentprofileResult);
if ($studentprofileCount) {
$studentprofileRow = mysqli_fetch_assoc($studentprofileResult);
} else {
$studentprofileRow = array();
$studentprofileRow['studentprofileId'] = 0;
$studentprofileRow['studentProfileSubmitted'] = 0;
$studentprofileRow['studentprofileGraded'] = 0;
$studentprofileRow['lastModified'] = 0;
$studentprofileRow['studentprofileGradedOn'] = 0;
}
$studentprofileRowText = stripslashes($userRow['userFirstName']." ".$userRow['userLastName']);
#$task = '';
#printVar('$studentprofileRow',$studentprofileRow);
if ($studentprofileRow['studentprofileId']) {
if ($studentprofileRow['studentProfileSubmitted']) {
// Student Profile submitted.
if ($studentprofileRow['studentprofileGraded']) {
// Student Profile graded.
$status = "Graded";
$studentprofileRowText .= ' graded on '.substr($studentprofileRow['lastModified'],2,8);
$task = '&f_task=Student Profile&f_subtask=Grade';
} else {
// Student Profile ready to grade.
$status = "UnGraded";
$studentprofileRowText = "Grade ".$studentprofileRowText.' Student Profile submitted on '.substr($studentprofileRow['lastModified'],2,8);
$task = '&f_task=Student Profile&f_subtask=Grade';
}
} else {
// Student Profile not submitted.
$status = "NotSubmitted";
$studentprofileRowText = "Grade ".$studentprofileRowText.' Student Profile updated on '.substr($studentprofileRow['lastModified'],2,8);
$task = '&f_task=Student Profile&f_subtask=Grade';
}
} else {
// Student Profile never entered.
$status = "NoEntry";
$studentprofileRowText = "Grade ".$studentprofileRowText.' Student Profile never entered';
$task = '&f_task=Student Profile&f_subtask=Grade';
}
if ($studentsThisColumn == 0) {
?>
<td style="padding-right:10px;">
<?
}
if ($studentprofileRowText != '') {
?>
<a href="<?=$_SERVER['PHP_SELF']?>?f_userId=<?=$userRow['userId']?>&Course=<?=$courseNumber?>&f_classId=<?=$f_classId?><?=$task?>" class="normal user<?=$status?>" title="<?=$studentprofileRowText?>"><?=$userRow['userStudentId']?> <?=stripslashes($userRow['userFirstName'])?> <?=stripslashes($userRow['userLastName'])?><!-- <?=$userRow['userId']?> <?=$userRow['userStudentId']?> --></a>
<!--
<a href="<?=$_SERVER['PHP_SELF']?>?f_userId=<?=$userRow['userId']?>&Course=<?=$courseNumber?>&f_classRoster_userId=<?=$f_classRoster_userId?><?=$task?>" class="normal user<?=$status?>" title="<?=$studentprofileRowText?>"><?=$userRow['userStudentId']?> <?=stripslashes($userRow['userFirstName'])?> <?=stripslashes($userRow['userLastName'])?></a>
-->
<?
} else {
?>
<span class="normal user<?=$status?>" title="<?=$studentprofileRowText?>"><?=$userRow['userStudentId']?> <?=stripslashes($userRow['userFirstName'])?> <?=stripslashes($userRow['userLastName'])?><!-- <?=$userRow['userId']?> --></span>
<?
}
?>
<br>
<?
$studentsThisColumn++;
if ($studentsThisColumn == $studentsPerColumn) {
$studentsThisColumn = 0;
?>
</td>
<?
}
}
if ($studentsThisColumn != 0) {
?>
</td>
<?
/* */
}
?>
</td>
</tr></table>
Status:
<span class="userGraded">Green = Graded</span>,
<span class="userUnGraded">Blue = Ungraded</span>,
<span class="userNotSubmitted">Orange = Un-submitted</span>,
<span class="userNoEntry">Red = Not entered</span>,
<span class="userNotInClass">Black = Not registered for class</span>.
<br>
<?
if($studentProfilePoints) {
?>
Student Profiles are worth <?=$studentProfilePoints?> points.
<?
} else {
?>
Student Profiles were not assigned.
<?
}
} else {
?>
No Student Profiles are available.
<?
}
?>
</span></fieldset>