| 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/evaluationUserIdList.phpinc
// Produce a list of userIds that have evaluations or grades for the classes.
// NEEDS:
// $f_classId = A list of classId's.
// $evaluationIdList = A list of $evaluationId's.
// RETURNS:
// $userIdClassRosterList = A list of userId's for students in the class roster.
// $userIdClassProfileList = A list of userId's for students who have entered a class profile for the classes.
// $userIdGradeList = A list of userId's for students who have grades for the classes.
// $userIdList = A merged list of the above.
if (da()) debugTrackBegin();
// Get a list of userIds from the class roster.
$query = "
SELECT DISTINCT classstudent.userStudentId, user.userId
FROM classstudent
LEFT JOIN user ON user.userStudentId = classstudent.userStudentId
WHERE classstudent.classId IN (".$f_classId.")
AND classstudent.classstudentInactive = 0
ORDER BY user.userId
";
$classstudentResult = query_do($query);
$classstudentCount = $_SESSION['qry']['count'];
$userIdClassRosterList = '';
$studentIdArray = array();
$studentIdNeverLoggedInArray = array();
if ( $classstudentCount ) {
mysqli_data_seek($classstudentResult, 0);
while ($classstudentRow = mysqli_fetch_assoc($classstudentResult)) {
if ( $classstudentRow['userId'] ) {
$userIdClassRosterList = listAppend($userIdClassRosterList,$classstudentRow['userId']);
$studentIdArray[$classstudentRow['userId']] = $classstudentRow['userStudentId'];
} else {
$studentIdNeverLoggedInArray[] = $classstudentRow['userStudentId'];
}
}
}
if (debugOn()) printVar('$userIdClassRosterList',$userIdClassRosterList);
#if (debugOn()) printVar('$studentIdClassRosterList',$studentIdClassRosterList);
// Get a list of userIds from CP entries.
$query = "
SELECT DISTINCT classprofile.userId, user.userStudentId
FROM `classprofile`
LEFT JOIN user ON user.userId = classprofile.userId
WHERE classId IN (".$f_classId.")
ORDER BY classprofile.userId
";
$classprofileResult = query_do($query);
$classprofileResultCount = $_SESSION['qry']['count'];
$userIdClassProfileList = '';
if ($classprofileResultCount) {
#$userIdClassProfileList = query_to_list($classprofileResult);
mysqli_data_seek($classprofileResult, 0);
while ($classprofileRow = mysqli_fetch_assoc($classprofileResult)) {
$userIdClassProfileList = listAppend($userIdClassProfileList,$classprofileRow['userId']);
if ( !isset($studentIdArray[$classprofileRow['userId']]) ) $studentIdArray[$classprofileRow['userId']] = $classprofileRow['userStudentId'];
}
}
if (debugOn()) printVar('$userIdClassProfileList',$userIdClassProfileList);
// Get a list of userIds from the gradebook
$query = "
SELECT DISTINCT grade.userId
FROM `grade`
WHERE evaluationId IN (".$evaluationIdList.")
ORDER BY userId
";
$gradeResult = query_do($query);
$gradeResultCount = $_SESSION['qry']['count'];
$userIdGradeList = '';
if ($gradeResultCount) {
#$userIdGradeList = query_to_list($gradeResult);
mysqli_data_seek($gradeResult, 0);
while ($gradeRow = mysqli_fetch_assoc($gradeResult)) {
$userIdGradeList = listAppend($userIdGradeList,$gradeRow['userId']);
if ( !isset($studentIdArray[$gradeRow['userId']]) ) $studentIdArray[$gradeRow['userId']] = $gradeRow['userStudentId'];
}
}
if (debugOn()) printVar('$userIdGradeList',$userIdGradeList);
// Create the userId list.
$userIdList = listSort(listUnique($userIdClassRosterList.",".$userIdClassProfileList.",".$userIdGradeList));
if (debugOn()) printVar('$userIdList',$userIdList);
if (debugOn()) printVar('$studentIdArray',$studentIdArray);
if (debugOn()) printVar('$studentIdNeverLoggedInArray',$studentIdNeverLoggedInArray);
// Get user info.
if (da()) debugTrackEnd();
?>