| 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/evaluationInfo.phpinc
// Returns various evaluation information for the classes.
// NEEDS:
// $f_classId = A classId.
// RETURNS:
// $classResult = Contains the class query results.
// $classSection = The class section number.
// $evaluationResult = Contains the evaluation query results.
// $evaluationResultCount = Contains the number of evaluations.
// $evaluationIdArray = An array of evaluationId's.
// $evaluationIdList = A list of evaluationId's.
// $eInfo = An array of the evaluation points by evaluationId.
// Student profile index = -2, Class profile index = -1.
// Contains: title, description, points, weight, critical, extra, and due.
// $evaluationTotalGradedPoints = Contains the total points for evaluations excluding extra credit.
// $evaluationExtraCreditPoints = Contains the total points for extra credit evaluations.
// $evaluationTotalPoints = Contains the total points for evaluations.
// $evaluationCritical = True if there are critical evaluations, else false.
// $evaluationExtraCredit = True if there are extra credit evaluations. else false.
if (da()) debugTrackBegin();
//if ( isset($_SESSION['userId']) && $_SESSION['userId'] == 1 ) { $evaluationInfoDEBUG = true; }
if (false || dc()) { $evaluationInfoDEBUG = true; }
if ( !isset($evaluationInfoDEBUG) ) { $evaluationInfoDEBUG = false; }
if ( $evaluationInfoDEBUG ) { d_On(); }
#if ( $_SERVER['REMOTE_ADDR'] == '173.25.109.5' ) d_On();
/** /
if ( $_SERVER['REMOTE_ADDR'] == '50.82.158.167' ) {
printVar('$f_classId',$f_classId);
}
/**/
$SP = -2;
$CP = -1;
$evaluationIdArray = array();
$evaluationIdList = '';
$eInfo = array(); // Contains the evaluation point by evaluationId. Student profile = SP, Class profile = CP.
$evaluationTotalGradedPoints = 0; // Contains the total points for evaluations that have been graded.
$evaluationExtraCreditPoints = 0; // Contains the total points for extra credit evaluations.
$evaluationTotalPoints = 0; // Contains the total points for evaluations excluding extra credit.
$evaluationCritical = false; // True if there are critical evaluations, else false.
$evaluationExtraCredit = false; // True if there are extra credit evaluations, else false.
// Get Class info with Student and Class profile points.
$query = "
SELECT
classId,
courseId,
YRTR,
classSection,
studentProfilePoints,
classProfilePoints,
modifiedBy,
lastModified
FROM class
WHERE classId = ".$f_classId."
";
$classResult = query_do($query);
if ( $evaluationInfoDEBUG ) {
d_Var('$f_classId',$f_classId);
d_Var('$query',$query,'q');
d_Var('$classResult',$classResult);
}
$classResultCount = $_SESSION['qry']['count'];
if ( $classResultCount ) {
$classRow = mysqli_fetch_assoc($classResult);
$classSection = $classRow['classSection'];
$eInfo[$SP] = array();
$eInfo[$SP]['classId'] = $classRow['classId'];
$eInfo[$SP]['title'] = 'SP';
$eInfo[$SP]['description'] = 'Student Profile';
$eInfo[$SP]['points'] = $classRow['studentProfilePoints'];
$eInfo[$SP]['weight'] = 1;
$eInfo[$SP]['critical'] = 0; if ( $eInfo[$SP]['critical'] ) $evaluationCritical = true;
$eInfo[$SP]['extra'] = 0; if ( $eInfo[$SP]['extra'] ) $evaluationExtraCredit = true;
$eInfo[$SP]['due'] = '';
$eInfo[$CP] = array();
$eInfo[$CP]['title'] = 'CP';
$eInfo[$CP]['description'] = 'Class Profile';
$eInfo[$CP]['points'] = $classRow['classProfilePoints'];
$eInfo[$CP]['weight'] = 1;
$eInfo[$CP]['critical'] = 0; if ( $eInfo[$CP]['critical'] ) $evaluationCritical = true;
$eInfo[$CP]['extra'] = 0; if ( $eInfo[$CP]['extra'] ) $evaluationExtraCredit = true;
$eInfo[$CP]['due'] = '';
} else {
$f_messageError = "No class found for classId ($f_classId).";
include('common/programmingError.phpinc');
}
// Get Evaluation Info.
$query = "
SELECT evaluationId,
classId,
evaluationOrder,
evaluationSubOrder,
evaluationType,
evaluationTitle,
evaluationDescription,
evaluationPoints,
evaluationWeight,
evaluationCritical,
evaluationExtraCredit,
evaluationDueDate,
evaluationIsHidden,
evaluationInactive,
lastModified,
modifiedBy
FROM evaluation
WHERE classId = ".$f_classId."
AND evaluationPoints > 0
AND evaluationIsHidden = 0
AND evaluationInactive = 0
ORDER BY evaluationOrder, evaluationSubOrder
";
$evaluationResult = query_do($query);
$evaluationResultCount = $_SESSION['qry']['count'];
if ( $evaluationInfoDEBUG ) {
d_Var('$query',$query,'q');
d_Var('$evaluationResult',$evaluationResult);
}
if ( $evaluationResultCount ) {
mysqli_data_seek($evaluationResult, 0);
while ($evaluationRow = mysqli_fetch_assoc($evaluationResult)) {
$evaluationId = $evaluationRow['evaluationId'];
$evaluationIdArray[] = $evaluationId;
$evaluationIdList = listAppend($evaluationIdList,$evaluationId);
$eInfo[$evaluationId] = array();
$eInfo[$evaluationId]['classId'] = $evaluationRow['classId'];
$eInfo[$evaluationId]['title'] = $evaluationRow['evaluationTitle'];
$eInfo[$evaluationId]['description'] = $evaluationRow['evaluationDescription'];
$eInfo[$evaluationId]['points'] = $evaluationRow['evaluationPoints'];
$eInfo[$evaluationId]['weight'] = $evaluationRow['evaluationWeight'];
$eInfo[$evaluationId]['critical'] = $evaluationRow['evaluationCritical']; if ( $eInfo[$evaluationId]['critical'] ) $evaluationCritical = true;
$eInfo[$evaluationId]['extra'] = $evaluationRow['evaluationExtraCredit']; if ( $eInfo[$evaluationId]['extra'] ) $evaluationExtraCredit = true;
$eInfo[$evaluationId]['due'] = $evaluationRow['evaluationDueDate'];
if ( !$eInfo[$evaluationId]['extra'] ) {
$evaluationTotalGradedPoints += $eInfo[$evaluationId]['points'] * $eInfo[$evaluationId]['weight'];
} else {
$evaluationExtraCreditPoints += $eInfo[$evaluationId]['points'] * $eInfo[$evaluationId]['weight'];
}
$evaluationTotalPoints += $eInfo[$evaluationId]['points'] * $eInfo[$evaluationId]['weight'];
}
}
// Add CP info.
if ( $eInfo[$CP]['points'] ) {
array_unshift($evaluationIdArray,$CP);
$evaluationIdList = listPrepend($evaluationIdList,$CP);
if ( !$eInfo[$CP]['extra'] ) {
$evaluationTotalGradedPoints += $eInfo[$CP]['points'];
}
$evaluationTotalPoints += $eInfo[$CP]['points'];
} else {
unset($eInfo[$CP]);
}
// Add SP info.
if ( $eInfo[$SP]['points'] ) {
array_unshift($evaluationIdArray,$SP);
$evaluationIdList = listPrepend($evaluationIdList,$SP);
if ( !$eInfo[$SP]['extra'] ) {
$evaluationTotalGradedPoints += $eInfo[$SP]['points'];
}
$evaluationTotalPoints += $eInfo[$SP]['points'];
} else {
unset($eInfo[$SP]);
}
if ( $evaluationIdList == '' ) $evaluationIdList = '0';
if ( $_SERVER['REMOTE_ADDR'] == '_173.25.109.5' ) { d_On(); $evaluationInfoDEBUG = true; }
if ($evaluationInfoDEBUG) {
d_Var('$evaluationIdList',$evaluationIdList);
d_Var('$evaluationIdArray',$evaluationIdArray);
d_Var('$eInfo',$eInfo);
d_Var('$evaluationTotalGradedPoints',$evaluationTotalGradedPoints);
d_Var('$evaluationExtraCreditPoints',$evaluationExtraCreditPoints);
d_Var('$evaluationTotalPoints',$evaluationTotalPoints);
d_Var('$evaluationCritical',$evaluationCritical);
d_Var('$evaluationExtraCredit',$evaluationExtraCredit);
}
if ( isset($_GET['eInfo']) ) printVar('$eInfo',$eInfo);
#if ( $_SERVER['REMOTE_ADDR'] == '173.25.109.5' ) d_Off();
if ( $evaluationInfoDEBUG ) { setDebugOn(); }
if (da()) debugTrackEnd();
?>