| 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/Course/Archive/ |
Upload File : |
<?
// Course/Assignments.phpinc
// Displays course assignments and grades.
debugTrackBegin();
#if (debugOn()) { echo basename(__FILE__)," line ",__LINE__,": ","<b>".__FILE__."</b><br>\n"; }
if ( !isset($CDN[0]) || !isset($CDN[1]) || !isset($courseTitle) || !isset($f_courseId) ) { $thisFile=__FILE__; $thisLine=__LINE__; include('Course/courseInfo.phpinc'); }
$headTitle = '_CST_ - '.$CDN[0].$CDN[1].' '.$courseTitle.' - Assignments';
$pageTitle = $courseNumber.' '.$courseTitle.'<br>Assignments';
$pageMenu = 'Course/courseMenu.phpinc';
#printVar('$f_courseId',$f_courseId);
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageHeader.phpinc');
#printVar('$f_courseId',$f_courseId);
$sectionTitle = $courseNumber." Assignments";
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionHeader.phpinc');
// Is this user in the class?
if (!isset($f_classId)) {
$thisFile=__FILE__; $thisLine=__LINE__; include('Course/studentInClass.phpinc');
}
#printVar('$f_classId',$f_classId);
printVar('$f_courseId',$f_courseId);
if ( $f_classId ) {
if (!$f_ClassInstructor) {
// Student
$f_userId = $_SESSION['userId'];
$f_userFullName = $_SESSION['userFullName'];
$f_userStudentId = $_SESSION['userStudentId'];
$f_section = '';
include('Course/AssignmentGrades.phpinc');
} else {
// Instructor
// Get all classIds
$query = "
SELECT class.classid
FROM course
INNER JOIN class ON course.courseId = class.courseId
WHERE course.courseNumber = '".$courseNumber."'
AND class.YRTR = ".$_SESSION['YRTR_User']."
ORDER BY class.classSection
";
$classIdListResult = query_do($query);
$classIdListCount = $_SESSION['mysql_num_rows'];
#printVar('$classIdListCount',$classIdListCount);
$f_classIdList = query_to_list($classIdListResult);
// Get the class roster.
$query = "
SELECT classstudent.classId,
classstudent.userStudentId,
classstudent.userFirstName,
classstudent.userLastName,
user.userId,
user.userStudentId AS useruserStudentId,
user.userFirstName AS useruserFirstName,
user.userLastName AS useruserLastName,
user.userNickname,
user.userEmail,
user.userAccessTime,
class.classSection
FROM classstudent
LEFT JOIN user ON classstudent.userStudentId = user.userStudentId
LEFT JOIN class ON classstudent.classId = class.classId
WHERE classstudent.classId IN (".$f_classIdList.")
AND classstudent.classstudentInactive = 0
ORDER BY class.classSection, classstudent.userLastName, classstudent.userFirstName
";
#printVar("\$query",$query);
$classRosterResult = query_do($query);
#printVar("\$classRosterResult",$classRosterResult);
$classRosterCount = $_SESSION['mysql_num_rows'];
if ( $classRosterCount ) {
// Loop through students.
mysql_data_seek($classRosterResult, 0);
while ($classRosterRow = mysql_fetch_assoc($classRosterResult)) {
$f_userId = $classRosterRow['userId'];
if ( $f_userId ) {
$f_userFullName = $classRosterRow['useruserFirstName'];
if ( $classRosterRow['useruserLastName'] ) $f_userFullName = $classRosterRow['useruserLastName'].', '.$f_userFullName;
$f_userStudentId = $classRosterRow['useruserStudentId'];
} else {
$f_userFullName = $classRosterRow['userFirstName'];
if ( $classRosterRow['userLastName'] ) $f_userFullName = $classRosterRow['userLastName'].', '.$f_userFullName;
$f_userStudentId = $classRosterRow['userStudentId'];
}
$f_section = ' - '.$classRosterRow['classSection'];
#printVar('$f_userId',$f_userId);
if ( $f_userId ) include('Course/AssignmentGrades.phpinc');
}
}
}
} else {
// Not in class.
?>
<b>You do not seem to be in this class.</b><br />
If you feel this is an error, please contact your Instructor.
<?
}
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionFooter.phpinc');
debugTrackEnd();
setDebugOn();
#setDebugOff();
$_SESSION['Message'] = '';
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageFooter.phpinc');
?>