| 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/SummerSessionForm.phpinc
debugTrackBegin();
$css = "printing";
$js .= ",openCenteredWindow";
include('common/pageHeader.phpinc');
// function courseDepartment($courseNumber)
// Returns the department part of the course number.
function courseDepartment($courseNumber) {
if (strtoupper(substr($courseNumber,3,1)) < 'A') {
return substr($courseNumber,0,3);
} else {
return substr($courseNumber,0,4);
}
}
// function courseNumber($courseNumber)
// Returns the number part of the course number.
function courseNumber($courseNumber) {
if (strtoupper(substr($courseNumber,3,1)) < 'A') {
return substr($courseNumber,3);
} else {
return substr($courseNumber,4);
}
}
// Get a list of summer session courses.
$query = "
SELECT course_summerschool.course_summerschoolId,
course_summerschool.courseId,
course_summerschool.sessionId,
course_summerschool.userId,
course.courseNumber,
course.courseTitle,
course.courseCredits,
course.courseCreditsMax,
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
WHERE course_summerschool.sessionId = ".$_SESSION['YRTR']['SESSIONID_NEXT_SUMMER']."
ORDER BY course.courseNumber
";
#printVar('$query',$query);
$course_summerschoolResult = query_do($query);
$course_summerschoolCount = $_SESSION['qry']['count'];
#$course_summerschoolCount = 0;
#printQuery('$course_summerschoolResult',$course_summerschoolResult);
$sectionTitle = 'Summer Session';
include('common/sectionHeader.phpinc');
?>
<br>
Registration for Summer School is now open. <a href="https://eservices.minnstate.edu/eservices/login.html?campusid=308">Please register online</a>.
<br><br>
<?
if ($course_summerschoolCount) {
if (isset($_SESSION['userId']) && $_SESSION['userId']) { $colspan = 8; } else { $colspan = 7; }
?>
<form name="form_summerSchool" action="<?=str_replace('index.php','',$_SERVER['PHP_SELF']);?>" method="post" style="display:inline;">
<input name="f_uuid" type="hidden" value="<?=uuid()?>">
<input name="f_form" type="hidden" value="form_summerSchool">
<span class="heading">CST is offering classes for Summer Session <?=$_SESSION['YRTR']['YR']?>.</span><br>
A decision on which (if any) classes will run this summer will be based on student interest.
The final decision will be made before the end of March. Please re-visit this page for updated information.
<br>
<br>
If you are interested in taking any of the following classes this summer:<br>
<?
if (isset($_SESSION['userId']) && $_SESSION['userId']) {
?>
<b>Check all classes you might take this summer and click <input type="submit" name="f_task" class="small" value="Update" /></b>.
<?
} else {
?>
<b><a href="https://cst.ridgewater.edu/login/?loginReturn=/SummerSession/">Login</a>.</b><br>
Then check all classes you might take this summer and click <input type="submit" name="f_task" class="small" value="Update" disabled="disabled" />.
<?
}
?>
<br><br>
<?
if ($f_task == 'Update') {
?>
<span class="attention">Summer Session selection updated.</span><br><br>
<?
}
?>
<table cellpadding="0" cellspacing="0">
<tr class="bottom">
<?
if (isset($_SESSION['userId']) && $_SESSION['userId']) {
?>
<th class="padRight center">
</th>
<?
}
?>
<th class="padRight center">Course<br>Number</th>
<th class="padRight">Course Title</th>
<th class="padRight center">Cr</th>
<th class="padRight center">Instructor</th>
<th class="padRight center">Interested<br>Students</th>
<th class="padLeft center">Credits</th>
<?
if (isset($_SESSION['userPermissions']) && in_array('ADMIN',$_SESSION['userPermissions'])) {
?>
<th class="padRight center"><a href="?task=View%20all">View all</a></th>
<?
}
?>
</tr>
<?
// Multiple row results.
$class='row_odd';
$courseList = '';
$totalCredits = 0;
mysqli_data_seek($course_summerschoolResult, 0);
while ($course_summerschoolRow = mysqli_fetch_assoc($course_summerschoolResult)) {
$courseList = listAppend($courseList,$course_summerschoolRow['course_summerschoolId']);
// Get the number of interested students.
$query = "
SELECT *
FROM course_summerschool_user
WHERE course_summerschoolId = ".$course_summerschoolRow['course_summerschoolId']."
";
$course_summerschool_userResult = query_do($query);
#printVar('$query',$query);
#printQuery('$course_summerschool_userResult',$course_summerschool_userResult);
$course_summerschool_userCount = $_SESSION['qry']['count'];
$course_summerschool_userCredits = $course_summerschool_userCount * $course_summerschoolRow['courseCredits'];
$totalCredits += $course_summerschool_userCredits;
// See if the student has interest in this course.
$checked = '';
$bold = '';
if (isset($_SESSION['userId'])) {
$query = "
SELECT course_summerschool_userId,
course_summerschoolId,
userId
FROM course_summerschool_user
WHERE course_summerschoolId = ".$course_summerschoolRow['course_summerschoolId']."
AND userId = ".$_SESSION['userId']."
";
$course_summerschool_userCourseResult = query_do($query);
$course_summerschool_userCourseCount = $_SESSION['qry']['count'];
if ($course_summerschool_userCourseCount) {
$checked = ' checked="checked"';
$bold = ' bold';
}
}
?>
<tr>
<?
if (isset($_SESSION['userId']) && $_SESSION['userId']) {
?>
<td class="padRight right <?=$class?>">
<input type="checkbox" name="f_courseId_<?=$course_summerschoolRow['course_summerschoolId']?>" id="f_courseId_<?=$course_summerschoolRow['course_summerschoolId']?>"<?=$checked?> />
</td>
<?
}
?>
<td class="padRight right <?=$class?><?=$bold?>"><a href="http://legacy.ridgewater.edu/Courses/?CD=<?=courseDepartment($course_summerschoolRow['courseNumber'])?>&CN=<?=courseNumber($course_summerschoolRow['courseNumber'])?>" onclick="openCenteredWindow('http://legacy.ridgewater.edu/Courses/?CD=<?=courseDepartment($course_summerschoolRow['courseNumber'])?>&CN=<?=courseNumber($course_summerschoolRow['courseNumber'])?>'); return false;"><?=$course_summerschoolRow['courseNumber']?></a></td>
<td class="padRight <?=$class?><?=$bold?>"><?=$course_summerschoolRow['courseTitle']?></td>
<td class="padRight center <?=$class?><?=$bold?>"><?=$course_summerschoolRow['courseCredits']?><? if ($course_summerschoolRow['courseCreditsMax']) echo '-'.$course_summerschoolRow['courseCreditsMax']; ?></td>
<td class="padRight <?=$class?>"><?=stripslashes($course_summerschoolRow['userFirstName'])?> <?=stripslashes($course_summerschoolRow['userLastName'])?></td>
<td class="padRight center <?=$class?>"><?=$course_summerschool_userCount?></td>
<td class="padLeft center <?=$class?>"><?=$course_summerschool_userCredits?></td>
<?
if ($course_summerschool_userCount && isset($_SESSION['userId']) && $_SESSION['userId']) {
?>
<td class="padRight center">
<?
if (isset($_SESSION['userPermissions']) && in_array('ADMIN',$_SESSION['userPermissions'])) {
?>
<!-- View student list -->
<a href="?task=View%20list&sscId=<?=$course_summerschoolRow['course_summerschoolId']?>">View list</a>
<?
}
?>
</td>
<?
}
?>
</tr>
<?
if ($class == 'row_odd') { $class = 'row_even'; } else { $class = 'row_odd'; }
}
$colspanTotal = $colspan-2;
?>
<tr><th colspan="<?=$colspanTotal?>" class="padRight right">Total Credits:</th><th class="padLeft center"><?=$totalCredits?></th></tr>
<tr><td colspan="<?=$colspan?>" class="center">
<?
if (isset($_SESSION['userId']) && $_SESSION['userId']) {
?>
<input type="submit" name="f_task" class="small" value="Update" />
<?
} else {
?>
<?
}
?>
<input type="hidden" name="f_courseList" value="<?=$courseList?>" />
</td></tr>
</table>
</form>
<p>
<img src="Summer 2010 Schedule.png" />
</p>
03-08 Summer Session interest form goes on-line.
<br>
<?
} else {
// No results.
?>
<span class="heading">CST is currently not offering any classes for Summer Session <?=$_SESSION['YRTR']['YR']?>.</span><br>
<br>
<?
}
include('common/sectionFooter.phpinc');
debugTrackEnd();
include('common/pageFooter.phpinc');
?>