| 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/MichaelMalz/ |
Upload File : |
<?
// MichaelMalz/index.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
#echo __FILE__;
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
$skipAuthentication = true;
require('application.phpinc');
$filePath = explode('/',$_SERVER['PHP_SELF']);
require('common/InstructorInfo.phpinc');
$headTitle = '_CST_ - '.$Instructor['Name'];
$pageTitle = '_CST_<br>'.$Instructor['Name'];
require('common/pageHeader.phpinc');
// Get the current list of active courses.
$totalToGrade = 0;
$query = "
SELECT courseId
, courseNumber
, courseTitle
, IFNULL(courseShortTitle,courseTitle) as courseShortTitle
, courseCredits
, IFNULL(courseCreditsMax,0) as courseCreditsMax
, courseWebsite
, courseBase
FROM `course`
WHERE courseInactive = 0
AND userId = 1688
ORDER BY courseNumber
";
$courseResult = query_do($query);
$courseResultCount = $_SESSION['qry']['count'];
#if (isset($_SESSION['userId']) && $_SESSION['userId'] == 1688) { d_Var('$courseResult',$courseResult,'d'); }
?>
<fieldset><legend>Links</legend>
<?
//include ('MichaelMalz/Web_ExLink.phpinc');
include ('MichaelMalz/WebMeetingLink.phpinc');
?>
<!--<br><a href="<?=php_self()?>#ContactInformation"><?=$Instructor['Name']?>'s Contact Information</a>-->
<?
// Merge CST and MMDT courses.
$Classes = array();
if ($courseResultCount) {
mysqli_data_seek($courseResult, 0);
while ($courseRow = mysqli_fetch_assoc($courseResult)) { // Loop thru courses.
$courseRow['Dept'] = preg_replace('/[0-9]/','',$courseRow['courseNumber']);
$courseRow['Number'] = preg_replace('/[A-Z]/','',$courseRow['courseNumber']);
/** /
if (isset($_SESSION['userId']) && $_SESSION['userId'] == 1688) {
d_Var('$courseRow',$courseRow,'d');
d_Var("\$courseRow['courseNumber']",$courseRow['courseNumber'],'d');
}
/**/
$courseNumberOther = str_replace('MMDT','CST',$courseRow['courseNumber']);
/** /if (isset($_SESSION['userId']) && $_SESSION['userId'] == 1688) { d_Var('$courseNumberOther',$courseNumberOther,'d'); }/**/
if ( !isset($Classes[$courseRow['courseNumber']]) && !isset($Classes[$courseNumberOther]) ) {
$Classes[$courseRow['courseNumber']] = $courseRow;
} else {
if ( isset($Classes[$courseNumberOther]) ) {
if ( $Classes[$courseNumberOther]['Number'] == $courseRow['Number'] ) {
if ( $courseRow['Dept'] == 'MMDT' ) {
$Classes[$courseNumberOther]['courseNumber'] = listPrepend($Classes[$courseNumberOther]['courseNumber'],$courseRow['courseNumber']);
$Classes[$courseNumberOther]['courseId'] = listPrepend($Classes[$courseNumberOther]['courseId'],$courseRow['courseId']);
$Classes[$courseRow['courseNumber']] = $Classes[$courseNumberOther];
unset($Classes[$courseNumberOther]);
} else {
$Classes[$courseNumberOther]['courseNumber'] = listAppend($Classes[$courseNumberOther]['courseNumber'],$courseRow['courseNumber']);
$Classes[$courseNumberOther]['courseId'] = listAppend($Classes[$courseNumberOther]['courseId'],$courseRow['courseId']);
}
}
}
}
} // Loop thru courses.
}
/** /if (isset($_SESSION['userId']) && $_SESSION['userId'] == 1688) { d_Var('$Classes',$Classes,'d'); }/**/
if ($courseResultCount) {
?>
<div class="p">
<span class="attention">Current semester class links:</span>
<table>
<?
$rowClass = '';
foreach ( $Classes as $Class ) { // Loop thru classes.
$needsGrading = 0;
$ClassNumbers = explode(',',$Class['courseNumber']);
$ClassNumberTitle = '';
$ClassNumberText = '';
foreach ($ClassNumbers as $ClassNumber) {
$ClassNumberTitle = listAppend($ClassNumberTitle,$ClassNumber);
$ClassNumberText = listAppend($ClassNumberText,'<b>'.$ClassNumber.'</b>');
}
$ClassNumberTitle = listAnd($ClassNumberTitle,',','or');
$ClassNumberText = listAnd($ClassNumberText,',','or');
if (isset($_SESSION['userId']) && $_SESSION['userId'] == 1688) { if ( $rowClass == '' ) { $rowClass = 'row_odd'; } else { $rowClass = ''; } }
?>
<tr class="<?=$rowClass?>">
<?
?>
<td><a href="<?=$Class['courseWebsite']?>" title="<?=$ClassNumberTitle?> <?=$Class['courseTitle']?> class homepage."><?=$ClassNumberText?> <?=$Class['courseTitle']?></a></td>
<?
if (isset($_SESSION['userId']) && $_SESSION['userId'] == 1688) {
// Get current classes.
$query = "
SELECT classId
, YRTR
, RCclassId
, classSection
, studentProfilePoints
, classProfilePoints
FROM `class`
WHERE courseId IN ( ".$Class['courseId']." )
AND YRTR = ".$_SESSION['YRTR']['CURRENT']."
ORDER BY classSection
";
$classResult = query_do($query);
$classResultCount = $_SESSION['qry']['count'];
/** /if (isset($_SESSION['userId']) && $_SESSION['userId'] == 1688) { ?><td><? d_Var('$classResult',$classResult,'d'); ?></td><? }/**/
if ( $classResultCount ) {
$evaluationIds = array();
mysqli_data_seek($classResult, 0);
while ($classRow = mysqli_fetch_assoc($classResult)) {
// Get class evaluationIds
$evaluationQuery = "
SELECT evaluationId
FROM `evaluation`
WHERE classId = ".$classRow['classId']."
AND evaluationInactive = 0
";
$evaluationResult = query_do($evaluationQuery);
$evaluationResultCount = $_SESSION['qry']['count'];
if ( $evaluationResultCount ) $evaluationIds = array_merge($evaluationIds,query_to_array($evaluationResult));
}
/** /if (isset($_SESSION['userId']) && $_SESSION['userId'] == 1688) { ?><td><? d_Var('evaluationIds',$evaluationIds,'d'); ?></td><? }/**/
if ( count($evaluationIds) ) {
// Get ng assignments.
#d_Var('arrayToList($evaluationIds)',arrayToList($evaluationIds),'d');
$gradeQuery = "
SELECT userFirstName
, userLastName
, grade.*
FROM `grade`
JOIN `user` ON user.userId = grade.userId
WHERE evaluationId IN ( ".arrayToList($evaluationIds)." )
AND gradeSubmitted = 1
AND ( gradeGraded = 0 OR gradeGraded IS NULL )
";
#d_Var('gradeQuery',$gradeQuery,'dq');
$gradeResult = query_do($gradeQuery);
#d_Var('gradeResult',$gradeResult,'d');
$gradeResultCount = $_SESSION['qry']['count'];
$needsGrading += $gradeResultCount;
}
}
?>
<td>
</td>
<td>
<?
if ( isset($needsGrading) && $needsGrading ) {
$totalToGrade += $needsGrading;
?><a href="<?=$Class['courseWebsite']?>?Gradebook">Gradebook</a><?
}
if ( !$needsGrading ) { $needsGrading = ''; }
?>
</td>
<td class="right">
<?=$needsGrading?>
</td>
<?
}
/** /
if (isset($_SESSION['userId']) && $_SESSION['userId'] == 1688) { ?><td><? d_Var('needsGrading',$needsGrading,'d'); d_Var('evaluationQuery',$evaluationQuery,'d'); d_Var('evaluationResult',$evaluationResult,'d'); d_Var('gradeQuery',$gradeQuery,'d'); d_Var('gradeResult',$gradeResult,'d'); ?></td><? }
/**/
?>
</tr>
<?
} // Loop thru classes.
if ( isset($_SESSION['userId']) && in_array('ADMIN',$_SESSION['userPermissions']) ) {
// Look for Student Profiles that need grading.
$query = "
SELECT studentprofile.*
, user.userUsername
, user.userFirstName
, user.userLastName
FROM `studentprofile`
JOIN `user` USING(userId)
WHERE studentprofile.studentprofileSubmitted = true
AND studentprofile.studentprofileGraded = false
#AND studentprofile.lastModified BETWEEN '".query_safe($_SESSION['YRTR']['User_Start'])." 00:00:00' AND '".query_safe($_SESSION['YRTR']['User_End'])." 23:59:59'
";
#d_Var('studentprofilegradeResult',$query,'dq');
$studentprofilegradeResult = query_do($query);
#d_Var('$studentprofilegradeResult',$studentprofilegradeResult,'d+');
$studentprofilegradeResultCount = $_SESSION['qry']['count'];
#d_Var('$studentprofilegradeResultCount',$studentprofilegradeResultCount,'d');
if ($studentprofilegradeResultCount) {
$totalToGrade += $studentprofilegradeResultCount;
$plural = ''; $verbplural = 'needs'; if ($studentprofilegradeResultCount > 1) { $plural = 's'; $verbplural = 'need'; }
?>
<tr><td class="right" colspan="3"><a href="https://cst.ridgewater.edu/StudentProfile/List/" target="_blank">Student Profile<?=$plural?> <?=$verbplural?> grading:</a></td><td><a href="https://cst.ridgewater.edu/StudentProfile/List/" target="_blank"><?=$studentprofilegradeResultCount?></a></td></tr>
<?
} else {
?>
<tr><td class="center" colspan="3">No Student Profiles need grading.</td><td></td></tr>
<?
}
}
if ( $totalToGrade ) {
?>
<tr><td class="right" colspan="3">Total to grade:</td><td><?=$totalToGrade?></td></tr>
<?
}
?>
</table>
<?
}
?>
</div>
</fieldset>
<fieldset id="General"><legend>Gerneral class information</legend>
Classes are delivered via <a href="https://cst.ridgewater.edu/Zoom/" target="_blank">Zoom</a> web meeting on the day and time listed for the class.
<p>
Attendance is not required, but I highly recommend that you attend the class <a href="https://minnstate.zoom.us/my/michael.malz/">meeting</a>.
Students who do so regularly have better grades.
<br>
Please use a headset with microphone. Do not use the built-in microphone on a laptop as it can produce feedback and echoing.
<br>
Meetings are recorded and links to the recordings will be posted on the class Schedule page for later viewing.
If you cannot attend the class meeting you can use these recordings to see what was covered that day.
You can also use the recordings for review.
</p>
<?
$date_current = date("Y-m-d").' 00:00:00';
#d_Var('$date_current',$date_current,'d');
#d_Var("\$_SESSION['YRTR']['User_Start']",$_SESSION['YRTR']['User_Start'],'d');
$date_week=date_create($_SESSION['YRTR']['User_Start']);
date_add($date_week,date_interval_create_from_date_string("7 days"));
#d_Var('$date_week',$date_week,'d');
$date_string = $date_week->format('Y-m-d H:i:s');
#d_Var('$date_string',$date_string,'d');
if ( $date_current < $date_string ) {
?>
<p>
<span class="attention">First day of class:</span>
<br>
<b>Join your first <a href="https://minnstate.zoom.us/my/michael.malz/" target="_blank">class meeting</a> broadcast at least 10 minutes early to get the software downloaded and configured.</b>
<br>
If you cannot attend the first class meeting please call or email me that you cannot do so. If you do not you may be dropped from the class.
</p>
<?
}
?>
<p>
Below is <a href="#ContactInformation">Contact Information</a>. My email address and work number are listed there.
My <a href="#ClassSchedule">Class Schedule</a> is also below.
</p>
</fieldset>
<?
if (file_exists('ContactInformation.phpinc')) { require('ContactInformation.phpinc'); }
?>
<a href="#top">Back to top of page</a>.
<?
#setDebugOn();
#d_Var('$_SESSION',$_SESSION,'d');
require('common/pageFooter.phpinc');
?>