| 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/Admin/Class/ |
Upload File : |
<?
// Admin/Class/Classes.phpinc
debugTrackBegin();
#if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","<b>".__FILE__."</b><br>\n"; }
$headTitle = '_CST_ - Classes';
$pageTitle = '_CST_<br>Classes';
include('common/pageHeader.phpinc');
#d_Var('$_SESSION',$_SESSION,'d');
#d_Var("\$_SERVER['HTTP_USER_AGENT']",$_SERVER['HTTP_USER_AGENT'],'d');
$sectionTitle = '_CST_ - Classes';
include('common/sectionHeader.phpinc');
include('common/sessionList.phpinc');
// Get list of courses.
$query = "
SELECT courseId,
courseNumber
FROM course
WHERE userId = ".$_SESSION['userId']."
AND courseInactive = 0
ORDER BY courseNumber
";
$courseResult = query_do($query);
$courseCount = $_SESSION['qry']['count'];
#printVar('$courseResult',$courseResult);
// Get weekdays.
$query = "
SELECT weekdayId,
weekday1
FROM `weekday`
ORDER BY weekdayId
";
$weekdayResult = query_do($query);
$weekdayResultCount = $_SESSION['qry']['count'];
if (!$weekdayResultCount) {
$weekdayRow = '';
$f_error = 'No weekdays found in database.<span class="pv_fl"> '.basename(__FILE__).':'.__LINE__.'</span>';
include('common/displayErrorsAndMessages.phpinc');
include('common/pageFooter.phpinc');
}
if (dc()) printVar('$courseCount',$courseCount);
if ($courseCount) {
?>
<br>
<table border="0" class="grayborder pad5" cellpadding="0" cellspacing="0">
<tr>
<td colspan="10" class="grayline">
<?
if ($sessionCount) {
?>
Session:
<?
include('common/sessionListSelect.phpinc');
} else {
?>
None available.
<?
}
?>
<br>
</td>
</tr>
<tr><td class="center grayline" colspan="10">
<form action="<?=php_self()?>" method="post" name="form_classaddlist" id="form_classaddlist" style="display:inline;">
<input name="f_uuid" type="hidden" value="<?=uuid()?>" />
<input name="f_form" type="hidden" value="form_classaddlist" />
<input type="submit" name="f_task" value="Create classes from list" class="" />
</form>
<form action="Folders.php" method="post" name="form_classaddlist" id="form_classaddlist" style="display:inline;">
<input name="f_uuid" type="hidden" value="<?=uuid()?>" />
<input name="f_form" type="hidden" value="form_classaddlist" />
<input type="submit" name="f_task" value="Create directories" class="" />
</form>
</td></tr>
<?
mysqli_data_seek($courseResult , 0);
while ($courseRow = mysqli_fetch_assoc($courseResult)) {
// Get class information.
$query = "
SELECT *
FROM class
WHERE courseId = ".$courseRow['courseId']."
AND YRTR = '".$_SESSION['YRTR']['User']."'
ORDER BY RCclassId
";
$query = "
SELECT class.*,
weekdayId,
classTimeStart,
classTimeStop,
classRoomBldg,
classRoomNumber
FROM class
LEFT JOIN classmeeting ON classmeeting.classId = class.classId
LEFT JOIN classmeeting_weekday ON classmeeting_weekday.classmeetingId = classmeeting.classmeetingId
WHERE class.courseId = ".$courseRow['courseId']."
AND class.YRTR = '".$_SESSION['YRTR']['User']."'
AND ( weekdayId = ( SELECT MIN(weekdayId) FROM classmeeting_weekday WHERE classmeeting_weekday.classmeetingId = classmeeting.classmeetingId ) OR weekdayId IS NULL )
ORDER BY classRoomBldg, weekdayId, classTimeStart, classTimeStop, classSection
";
$query = "
SELECT class.*,
classTimeStart,
classTimeStop,
classRoomBldg,
classRoomNumber
FROM class
LEFT JOIN classmeeting ON classmeeting.classId = class.classId
WHERE class.courseId = ".$courseRow['courseId']."
AND class.YRTR = '".$_SESSION['YRTR']['User']."'
ORDER BY classSection
";
/**/
$query = "
SELECT class.*,
weekdayId,
classTimeStart,
classTimeStop,
classRoomBldg,
classRoomNumber
FROM class
LEFT JOIN classmeeting ON classmeeting.classId = class.classId
LEFT JOIN classmeeting_weekday ON classmeeting_weekday.classmeetingId = classmeeting.classmeetingId
WHERE class.courseId = ".$courseRow['courseId']."
AND class.YRTR = '".$_SESSION['YRTR']['User']."'
AND ( ( weekdayId = ( SELECT MIN(weekdayId) FROM classmeeting_weekday WHERE classmeeting_weekday.classmeetingId = classmeeting.classmeetingId ) )
OR ( weekdayId IS NULL )
)
ORDER BY classRoomBldg, weekdayId, classTimeStart, classTimeStop, classSection
";
/**/
$classResult = query_do($query);
$classCount = $_SESSION['qry']['count'];
$rowCount = $classCount + 1;
?>
<form action="<?=php_self()?>" method="post" name="form_classadd" id="form_classadd" style="display:inline;">
<input name="f_uuid" type="hidden" value="<?=uuid()?>" />
<input name="f_form" type="hidden" value="form_classadd" />
<input name="f_courseId" type="hidden" value="<?=$courseRow['courseId']?>" />
<input name="f_courseNumber" type="hidden" value="<?=$courseRow['courseNumber']?>" />
<tr>
<th class="info right">ClassId</th>
<th class="info center">Class #</th>
<th class="info left">Sec</th>
<th class="info center">Enr</th>
<th class="info center">Days</th>
<th class="info center">Start</th>
<th class="info center">Stop</th>
<th class="info center">Bldg</th>
<th class="info center">Rm</th>
<td>
<input type="submit" name="f_task" value="Add" class="small" />
<?
if ($classCount > 1) {
?>
<input type="submit" name="f_task" value="Drop All" class="small" />
<?
}
?>
</td>
</tr>
</form>
<?
if ($classCount) {
$classRow = mysqli_fetch_assoc($classResult);
mysqli_data_seek($classResult, 0);
$previous_classId = 0;
while ($classRow = mysqli_fetch_assoc($classResult)) { // Loop thru classes.
if ($classRow['classId'] != $previous_classId ) {
// Get the classStudentCount.
$query = "
SELECT
classstudentId
FROM classstudent
WHERE classId = ".$classRow['classId']."
";
$classstudentResult = query_do($query);
$classStudentCount = $_SESSION['qry']['count'];
// Get class meetings.
$query = "
SELECT classmeetingId,
classTimeStart,
classTimeStop,
classRoomBldg,
classRoomNumber
FROM `classmeeting`
WHERE classId = ".$classRow['classId']."
ORDER BY classTimeStart, classTimeStop
";
$classmeetingResult = query_do($query);
$classmeetingResultCount = $_SESSION['qry']['count'];
/** / ?> <tr><td colspan="10"> <? d_On(); d_Var('$classmeetingResult',$classmeetingResult); d_Off(); /**/
$index = 0;
$classDays = array();
$classTimeStart = array();
$classTimeStop = array();
$classRoomBldg = array();
$classRoomNumber = array();
if ($classmeetingResultCount) {
mysqli_data_seek($classmeetingResult, 0);
while ($classmeetingRow = mysqli_fetch_assoc($classmeetingResult)) {
// Get class days.
$query = "
SELECT weekdayId
FROM `classmeeting_weekday`
WHERE classmeetingId = ".$classmeetingRow['classmeetingId']."
ORDER BY weekdayId
";
$class_weekdayResult = query_do($query);
$class_weekdayResultCount = $_SESSION['qry']['count'];
#d_On(); d_Var('$class_weekdayResult',$class_weekdayResult); d_Off();
$days = classDays($weekdayResult,$class_weekdayResult);
$classDays[] = $days;
$classTimeStart[] = valid_time($classmeetingRow['classTimeStart']);
$classTimeStop[] = valid_time($classmeetingRow['classTimeStop']);
$classRoomBldg[] = $classmeetingRow['classRoomBldg'];
$classRoomNumber[] = $classmeetingRow['classRoomNumber'];
$index += 1;
} // while ($classmeetingRow = mysqli_fetch_assoc($classmeetingResult))
} // if ($classmeetingResultCount)
/** / ?> </td></tr> <? /**/
?>
<tr>
<td class="right">
<form action="<?=php_self()?>" method="post" name="form_classadd" id="form_classadd" style="display:inline;">
<input name="f_uuid" type="hidden" value="<?=uuid()?>" />
<input name="f_form" type="hidden" value="form_class" />
<input name="f_courseId" type="hidden" value="<?=$courseRow['courseId']?>" />
<input name="f_courseNumber" type="hidden" value="<?=$courseRow['courseNumber']?>" />
<input name="f_classId" type="hidden" value="<?=$classRow['classId']?>" />
<input name="f_classSection" type="hidden" value="<?=$classRow['classSection']?>" />
<input name="f_RCclassId" type="hidden" value="<?=$classRow['RCclassId']?>" />
<?=$classRow['RCclassId']?></td> <!-- ClassId -->
<td><?=$courseRow['courseNumber']?></td> <!-- Course -->
<td class="left"><?=$classRow['classSection']?></td> <!-- Section -->
<td class="right"><?=$classStudentCount?></td> <!-- Students -->
<td class="right" style="font-family:'Courier New', Courier, monospace; white-space:pre;"><?=arrayBR($classDays)?></td> <!-- Days -->
<td class="right"><?=arrayBR($classTimeStart)?></td> <!-- Start -->
<td class="right"><?=arrayBR($classTimeStop)?></td> <!-- Stop -->
<td class="right"><?=arrayBR($classRoomBldg)?></td> <!-- Bldg -->
<td class="right"><?=arrayBR($classRoomNumber)?></td> <!-- Room -->
<td>
<input type="submit" name="f_task" value="Drop" class="small" />
<input type="submit" name="f_task" value="Edit" class="small" />
<input type="submit" name="f_task" value="Evaluations" class="small" />
<input type="submit" name="f_task" value="Events" class="small" />
<input type="submit" name="f_task" value="Gradebook" class="small" />
<input type="submit" name="f_task" value="Roster" class="small" />
<span class="small">#<?=$classRow['classId']?></span>
<? $previous_classId = $classRow['classId']; ?>
</form>
</td>
<tr>
</tr>
<td colspan="9">
</td>
<td>
</td>
</tr>
<?
}
} // Loop thru classes.
} else {
?>
<tr>
<td><?=$courseRow['courseNumber']?></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<?
}
?>
<tr><td colspan="10" class="grayline"></td></tr>
<?
}
?>
</table>
<?
} else {
?>
<table cellpadding="0" cellspacing="0"><tr><th colspan="6">
You have no course links at this time.
<br> You may
<form action="CourseLinks.php" method="post" name="form_courseadd" id="form_courseadd" style="display:inline;">
<input name="f_uuid" type="hidden" value="<?=uuid()?>" />
<input name="f_form" type="hidden" value="form_courseadd" />
<input name="f_courseId" type="hidden" value="0" />
<input type="submit" name="f_task" value="Add" class="small" />
</form>
a course link.
</th></tr>
<tr><th colspan="6"> </th></tr></table>
<?
}
function arrayBR($array) {
$text = '';
$textEnd = '';
if ( isset($array) && count($array) ) {
foreach ($array as $key => $value) {
$text .= $textEnd.$value;
$textEnd = '<br>';
}
}
return $text;
}
?>
<?
include('common/sectionFooter.phpinc');
debugTrackEnd();
#setDebugOn();
#setDebugOff();
include('common/pageFooter.phpinc');
?>