| 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/common/Class/ |
Upload File : |
<?
// common/Class/ClassProfiles.phpinc
// Display a list of student Class Profiles.
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;
}
$classRoster_userId_List = query_to_list($classRosterResult,'userId',true,0);
if ($classRoster_userId_List) {
// Get count of Graded class profiles.
$query = "SELECT classprofileId FROM classprofile WHERE classprofileGraded = 1 AND classId IN (".$f_classId.")";
$result = query_do($query);
$GradedClassProfileCount = $_SESSION['qry']['count'];
#printVar('$GradedClassProfileCount',$GradedClassProfileCount);
// Get count of Ungraded class profiles.
$query = "SELECT classprofileId FROM classprofile WHERE classprofileSubmitted = 1 AND classprofileGraded = 0 AND classId IN (".$f_classId.")";
#printVar('$query',$query);
$result = query_do($query);
$UngradedClassProfileCount = $_SESSION['qry']['count'];
#printVar('$UngradedClassProfileCount',$UngradedClassProfileCount);
// Get count of Unsubmitted class profiles.
$query = "SELECT classprofileId FROM classprofile WHERE classprofileSubmitted = 0 AND classId IN (".$f_classId.")";
$result = query_do($query);
$UnsubmittedClassProfileCount = $_SESSION['qry']['count'];
#printVar('$UnsubmittedClassProfileCount',$UnsubmittedClassProfileCount);
// Get count of Not registered for class class profiles.
// Get userIds for users that have a Class Profile but are not on the class roster.
#printVar('$classRoster_userId_List',$classRoster_userId_List);
$query = "
SELECT user.userId
FROM user
LEFT JOIN classprofile ON classprofile.userId = user.userId
WHERE classprofile.classId IN (".$f_classId.")
AND user.userIsInactive = 0
AND classprofile.userId NOT IN (".$classRoster_userId_List.")
ORDER BY ".$orderBy."
";
$classProfileNotInClassResult = query_do($query);
$classProfileNotInClassCount = $_SESSION['qry']['count'];
$NotRegisteredForClassClassProfileCount = $classProfileNotInClassCount;
$TotalClassProfileCount = $classRosterCount + $NotRegisteredForClassClassProfileCount;
$NotEnteredClassProfileCount = $TotalClassProfileCount - $GradedClassProfileCount - $UngradedClassProfileCount - $UnsubmittedClassProfileCount;
#printVar('$NotEnteredClassProfileCount',$NotEnteredClassProfileCount);
#printVar('$NotRegisteredForClassClassProfileCount',$NotRegisteredForClassClassProfileCount);
#printVar('$TotalClassProfileCount',$TotalClassProfileCount);
$classProfileNotInClass_userId_List = query_to_list($classProfileNotInClassResult);
#printVar('$classProfileNotInClass_userId_List',$classProfileNotInClass_userId_List);
$classProfile_userId_List = listAppend($classRoster_userId_List,$classProfileNotInClass_userId_List);
#printVar('$classProfile_userId_List',$classProfile_userId_List);
$classProfile_userId_Array = explode(',',$classProfile_userId_List);
#printVar('$classProfile_userId_Array',$classProfile_userId_Array);
// 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 (".$classProfile_userId_List.")
AND user.userIsInactive = 0
ORDER BY ".$orderBy."
";
#printVar('$query',$query);
#$userResult = query_do($query);
#$userCount = $_SESSION['qry']['count'];
#printVar('$userCount',$userCount);
#printQuery('$userResult',$userResult);
} else {
$GradedClassProfileCount = 0;
$UngradedClassProfileCount = 0;
$UnsubmittedClassProfileCount = 0;
$classRoster_userId_List = array();
$classProfileNotInClassCount = 0;
$NotRegisteredForClassClassProfileCount = $classProfileNotInClassCount;
$TotalClassProfileCount = $classRosterCount + $NotRegisteredForClassClassProfileCount;
$NotEnteredClassProfileCount = $TotalClassProfileCount - $GradedClassProfileCount - $UngradedClassProfileCount - $UnsubmittedClassProfileCount;
$classProfileNotInClass_userId_List = array();
$classProfile_userId_List = listAppend($classRoster_userId_List,$classProfileNotInClass_userId_List);
$classProfile_userId_Array = array();
}
$classprofileStartedCountText = '<span class="normal">'.$TotalClassProfileCount.' 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 class="userNotInClass">'.$NotRegisteredForClassClassProfileCount.' Not registered for class</span>'.'</span>';
$studentsThisColumn = 0;
?>
<fieldset><legend>Class Profile <span class="smaller">(<?=$classprofileStartedCountText?>)</span></legend>
<?
$classProfileTotalCount = $classRosterCount + $classProfileNotInClassCount;
$query = "
SELECT classProfilePoints
FROM class
WHERE classId IN (".$f_classId.")
";
$classProfilePointsResult = query_do($query);
$classProfilePointsCount = $_SESSION['qry']['count'];
if ($classProfilePointsCount) {
$classProfilePointsRow = mysqli_fetch_assoc($classProfilePointsResult);
$classProfilePoints = $classProfilePointsRow['classProfilePoints'];
} else {
$classProfilePoints = 0;
}
if($classProfilePoints) {
if ($classProfileTotalCount) {
$studentsPerColumn = (int) ($classProfileTotalCount/4+.99);
//echo $studentsPerColumn."<br>\n";
?>
<table cellpadding="0" cellspacing="0"><tr><td>
<?
#mysqli_data_seek($classRosterResult, 0);
$studentsThisColumn = 0;
$UnSubmittedEmailList = '';
$NotenteredEmailList = '';
foreach ($classProfile_userId_Array as $classProfile_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 = ".$classProfile_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 classprofile.classprofileId,
classprofile.classprofileSubmitted,
classprofile.classprofileGraded,
classprofile.lastModified,
classprofile.classprofileGradedOn,
class.classProfilePoints,
classstudent.userStudentId
FROM classprofile
LEFT JOIN class ON classprofile.classId = class.classId
LEFT JOIN user ON classprofile.userId = user.userId
LEFT JOIN classstudent ON user.userStudentId = classstudent.userStudentId
WHERE classprofile.userId = ".$classProfile_userId."
AND classprofile.classId IN (".$f_classId.")
";
$classprofileResult = query_do($query);
$classprofileCount = $_SESSION['qry']['count'];
#printVar('$classprofileCount',$classprofileCount);
#printQuery('$classprofileResult',$classprofileResult);
if ($classprofileCount) {
$classprofileRow = mysqli_fetch_assoc($classprofileResult);
} else {
$classprofileRow = array();
$classprofileRow['classprofileId'] = 0;
$classprofileRow['classprofileSubmitted'] = 0;
$classprofileRow['classprofileGraded'] = 0;
$classprofileRow['lastModified'] = 0;
$classprofileRow['classprofileGradedOn'] = 0;
$classprofileRow['userStudentId'] = 0;
}
$classprofileRowText = stripslashes($userRow['userFirstName']." ".$userRow['userLastName']);
#$task = '';
#printVar('$classprofileRow',$classprofileRow);
if ($classprofileRow['classprofileId']) {
if ($classprofileRow['classprofileSubmitted']) {
// Class profile submitted.
if ($classprofileRow['classprofileGraded']) {
// Class profile graded.
$status = "Graded";
$classprofileRowText .= ' graded on '.substr($classprofileRow['lastModified'],2,8);
$task = '&f_task=Class Profile&f_subtask=Grade';
} else {
// Class profile ready to grade.
$status = "UnGraded";
$classprofileRowText = "Grade ".$classprofileRowText.' Class Profile submitted on '.substr($classprofileRow['lastModified'],2,8);
$task = '&f_task=Class Profile&f_subtask=Grade';
}
} else {
// Class profile not submitted.
$status = "NotSubmitted";
$UnSubmittedEmailListn = listAppend($UnSubmittedEmailList,$userRow['userEmail'],';');
$classprofileRowText = "Grade ".$classprofileRowText.' Class Profile updated on '.substr($classprofileRow['lastModified'],2,8);
$task = '&f_task=Class Profile&f_subtask=Grade';
}
if (!$classprofileRow['userStudentId']) {
$status = "NotInClass";
}
} else {
// Class profile never entered.
$status = "NoEntry";
#printVar('$classProfile_userId',$classProfile_userId);
$NotenteredEmailList = listAppend($NotenteredEmailList,$userRow['userEmail'],';');
#printVar('$NotenteredEmailList',$NotenteredEmailList);
// Get email address for this user.
#$query="
#SELECT userEmail
#FROM user
#WHERE userId = ".$classProfile_userId."
#";
#$emailResult = query_do($query);
#$emailCount = $_SESSION['qry']['count'];
#$emailRow = mysqli_fetch_assoc($userResult);
$classprofileRowText = "Grade ".$classprofileRowText.' Class Profile never entered';
$task = '&f_task=Class Profile&f_subtask=Grade';
}
if ($studentsThisColumn == 0) {
?>
<td style="padding-right:10px;">
<?
}
if ($classprofileRowText != '') {
?>
<a href="<?=$_SERVER['PHP_SELF']?>?f_userId=<?=$userRow['userId']?>&f_classId=<?=$f_classId?><?=$task?>" class="normal user<?=$status?>" title="<?=$classprofileRowText?>"><?=$userRow['userStudentId']?> <?=stripslashes($userRow['userFirstName'])?> <?=stripslashes($userRow['userLastName'])?><!-- <?=$userRow['userId']?> <?=$classprofileRow['classProfilePoints']?> <?=$classprofileRow['userStudentId']?> --></a>
<?
} else {
?>
<span class="normal user<?=$status?>" title="<?=$classprofileRowText?>"><?=$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>
Class Profiles are worth <?=$classProfilePoints?> points.
<?
} else {
?>
Class Profiles were not assigned.
<?
}
} else {
if ($classRoster_userId_List) {
if (!isset($classProfilePoints)) $classProfilePoints = 0;
if($classProfilePoints) {
?>
No Class Profiles are available.
<?
} else {
?>
Class Profiles were not assigned.
<?
}
} else {
?>
No Class Profiles are available.
<?
}
}
?>
</span></fieldset>