| 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/Gradebook/ |
Upload File : |
<?
// Gradebook/GetGrade_by_userId_evaluationId.phpinc
// Get grade info by f_userId and f_evaluationId.
if (da()) debugTrackBegin();
if ( isset($_SESSION['userId']) && $_SESSION['userId'] == -1 ) {
$DEBUG_GetGrade_by_userId_evaluationId = true;
}
if ( !isset($DEBUG_GetGrade_by_userId_evaluationId) ) $DEBUG_GetGrade_by_userId_evaluationId = false;
#pageCleanupBegin();
// Check for existing grade.
$query = "
SELECT *
FROM `grade`
WHERE userId = ".$f_userId."
AND evaluationId = ".$f_evaluationId."
AND gradeInactive = 0
ORDER BY gradeGrade DESC
";
$__gradeResult = query_do($query);
$__gradeResultCount = $_SESSION['qry']['count'];
if ( $DEBUG_GetGrade_by_userId_evaluationId ) {
printVar('$query',$query,'q');
printVar('$__gradeResult',$__gradeResult,'f');
}
if ($__gradeResultCount) {
mysqli_data_seek($__gradeResult, 0);
$gradeInfo = mysqli_fetch_assoc($__gradeResult);
if ( $DEBUG_GetGrade_by_userId_evaluationId ) {
printVar('$gradeInfo',$gradeInfo,'f');
}
}
if ( $__gradeResultCount ) {
$f_gradeId = $gradeInfo['gradeId'];
$gradeGrade = trim(trim($gradeInfo['gradeGrade'],'0'),'.');
// Calculate the percentage.
$LabPercentage = gradePercentage($gradeGrade,$f_evaluationPoints);
if ( $gradeInfo['gradeGraded'] ) {
$GradeText = "
<p>\n
<fieldset><legend>".$evaluationType." ".$evaluationNumber." Grade</legend>\n
You currently have a grade of ".gradeClass(gradeLetterAC($LabPercentage))." for ".$evaluationType." ".$evaluationNumber.".\n
<br>\n
You got ".$gradeGrade." correct out of ".$f_evaluationPoints." (".$LabPercentage."%).
<div id=\"LabQuestionSee\"><a href=\"\" class=\"d_s_l\" onClick=\"divHide('LabQuestionSee');divShow('LabQuestionView');return false;\">See answers +</a></div>\n
<div id=\"LabQuestionView\" class=\"hidden\"><a href=\"\" onClick=\"divHide('LabQuestionView');divShow('LabQuestionSee');return false;\">Hide answers -</a>\n
".$gradeInfo['gradeComment']."\n
</div>\n
</fieldset>\n
";
} else {
$GradeText = '';
}
} else {
$f_gradeId = 0;
$gradeInfo = array();
$gradeInfo['gradeId'] = 0;
$GradeText = '';
}
if ( $DEBUG_GetGrade_by_userId_evaluationId ) {
printVar('$f_gradeId',$f_gradeId,'f');
printVar('$gradeInfo',$gradeInfo,'f');
printVar('$GradeText',$GradeText,'f');
}
unset($__gradeResult);
unset($__gradeResultCount);
if (da()) debugTrackEnd();
?>