| 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/SummerSession/ |
Upload File : |
<?
// SummerSession/SummerSessionListCourse.phpinc
// Get instructor information and set filter.
include('SummerSession/SummerSessionInstructorFilter.phpinc');
?>
<a href="/SummerSession/">Back to list</a>.
<?
if (!$f_sscId) {
?>
<!-- <a href="/SummerSession/?task=View%20all&sortBy=Student">Sort by student</a>. -->
<?
}
// Get the list of summer school courses with students.
$query = "
SELECT DISTINCT
course_summerschool.course_summerschoolId,
course_summerschool.courseId,
course_summerschool.sessionId,
course_summerschool.userId,
course.courseNumber,
course.courseTitle,
course.courseCredits,
course.courseCreditsMax,
user.userId,
user.userFirstName,
user.userLastName
FROM course_summerschool
INNER JOIN course ON course.courseId = course_summerschool.courseId
INNER JOIN user ON user.userId = course_summerschool.userId
INNER JOIN course_summerschool_user ON course_summerschool_user.course_summerschoolId = course_summerschool.course_summerschoolId
WHERE course_summerschool.sessionId = ".$_SESSION['YRTR']['SESSIONID_NEXT_SUMMER']."
";
$quantifier = 'WHERE';
$quantifier = 'AND';
if ($f_sscId) {
$query .= "
".$quantifier." course_summerschool.course_summerschoolId = ".$f_sscId."
";
$quantifier = ' AND';
}
if ($f_instructorIdList) {
$query .= "
".$quantifier." user.userId IN (".$f_instructorIdList.")
";
}
$query .= "
ORDER BY course.courseNumber
";
#printVar('$query',$query);
$course_summerschoolResult = query_do($query);
#printQuery('$course_summerschoolResult',$course_summerschoolResult);
$course_summerschoolCount = $_SESSION['qry']['count'];
#echo "'$f_instructorIdList' != '$v_instructorIdList'<br>\n";
$showInstructor = true;
$totalCredits = 0;
$emailAll = '';
if ($course_summerschoolCount) {
mysqli_data_seek($course_summerschoolResult, 0);
while ($course_summerschoolRow = mysqli_fetch_assoc($course_summerschoolResult)) {
?>
<p>
<?
if ($showInstructor && (!isset($v_instructorIdList) || ($f_instructorIdList != $v_instructorIdList))) {
$showInstructor = false;
?>
<span class="heading">Instructor: <?=$course_summerschoolRow['userFirstName']?> <?=$course_summerschoolRow['userLastName']?></span>
<?
}
?>
<fieldset><legend><?=$course_summerschoolRow['courseNumber']?> <?=$course_summerschoolRow['courseTitle']?></b> <?=$course_summerschoolRow['courseCredits']?><? if ($course_summerschoolRow['courseCreditsMax']) echo '-'.$course_summerschoolRow['courseCreditsMax']; ?>cr.
<?
if (isset($v_instructorIdList) && ($f_instructorIdList == $v_instructorIdList)) {
?>
Instructor: <?=$course_summerschoolRow['userFirstName']?> <?=$course_summerschoolRow['userLastName']?>
<?
}
?>
</legend>
<?
#printVar('$course_summerschoolRow',$course_summerschoolRow);
// Get list of students.
$query = "
SELECT user.userId,
user.userStudentId,
user.userFirstName,
user.userLastName,
user.userEmail,
user.userAccessTime
FROM user
INNER JOIN course_summerschool_user ON course_summerschool_user.userId = user.userId
WHERE course_summerschool_user.course_summerschoolId = ".$course_summerschoolRow['course_summerschoolId']."
ORDER BY user.userFirstName, user.userLastName
";
$studentResult = query_do($query);
$studentCount = $_SESSION['qry']['count'];
$course_summerschool_userCount = $studentCount;
$course_summerschool_userCredits = $course_summerschool_userCount * $course_summerschoolRow['courseCredits'];
$totalCredits += $course_summerschool_userCredits;
#printQuery('$studentResult',$studentResult);
if ($studentCount) {
?>
<b>Student interest list:</b> <span class="small">(<?=$course_summerschool_userCount?> students, <?=$course_summerschool_userCredits?> credits)</span><br>
<table cellpadding="0" cellspacing="0"><tr>
<?
$studentsPerColumn = (int) ($studentCount/4+.99);
mysqli_data_seek($studentResult, 0);
$studentsThisColumn = 0;
while ($studentRow = mysqli_fetch_assoc($studentResult)) {
if ($studentsThisColumn == 0) {
?>
<td style="padding-right:10px;">
<?
}
?>
<?=$studentRow['userStudentId']?> <span style="color:#000000;"><?=$studentRow['userFirstName']?> <?=$studentRow['userLastName']?></span>
<br>
<?
$studentsThisColumn++;
if ($studentsThisColumn == $studentsPerColumn) {
$studentsThisColumn = 0;
?>
</td>
<?
}
}
if ($studentsThisColumn != 0) {
?>
</td>
<?
}
}
?>
</tr></table>
<b>Email addresses:</b><br>
<?
$emailClass = '';
mysqli_data_seek($studentResult, 0);
while ($studentRow = mysqli_fetch_assoc($studentResult)) {
$emailClass .= $studentRow['userEmail'].";";
?>
<a href="mailto:<?=$studentRow['userEmail']?>"><?=$studentRow['userEmail']?></a>;
<?
}
$emailAll .= $emailClass;
?>
<br><a href="mailto:<?=$emailClass?>">Email class</a>
</fieldset>
<?
}
}
if (!$f_sscId) {
#if (isset($v_instructorIdList) && ($f_instructorIdList == $v_instructorIdList)) {
?>
<div class="heading" style="margin-left:10px;"><a href="mailto:<?=$emailAll?>">Email all</a><br><?=$totalCredits?> total credits.</div>
<?
}
?>