| 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/User/ |
Upload File : |
<?
// User/userList.phpinc
// Display a list of Users.
if (!isset($_SESSION['sortBy'])) { $_SESSION['sortBy'] = ""; }
#if (!isset($_SESSION['sortByOrder'])) { $_SESSION['sortByOrder'] = "ASC"; }
$sortBy = formValue('sortBy','');
if ( $sortBy != '' ) {
list($part1, $part2, $sortByOrder) = explode(' ',$sortBy);
$sortBy = $part1.' '.$part2;
unset($part1);
unset($part2);
} else {
$sortByOrder = 'ASC';
}
$_SESSION['sortByOrder'] = $sortByOrder;
$_SESSION['sortBy'] = $sortBy;
#printVar('$sortBy',$sortBy);
#printVar("\$_SESSION['sortBy']",$_SESSION['sortBy']);
#printVar("\$_SESSION['sortByOrder']",$_SESSION['sortByOrder']);
#printVar("\$_SESSION['sortByOrder']",$_SESSION['sortByOrder']);
if ($_SESSION['sortBy'] == '') { $_SESSION['sortBy'] = 'First Name'; }
switch ($_SESSION['sortBy']) {
case '':
case 'First Name':
#$f_orderBy = "CASE WHEN userNickname='' or userNickname is null THEN userFirstName ELSE userNickname END ".$_SESSION['sortByOrder'].', userLastName';
$f_orderBy = "IF ( userNickname='' or userNickname IS NULL, userFirstName, userNickname ) ".$_SESSION['sortByOrder'].', userLastName';
break;
case 'Last Name':
$f_orderBy = 'userLastName '.$_SESSION['sortByOrder'].', userFirstName';
break;
case 'Student Id':
$f_orderBy = 'userStudentId '.$_SESSION['sortByOrder'];
break;
case 'User Id':
$f_orderBy = 'userId '.$_SESSION['sortByOrder'];
break;
default:
$f_orderBy = "CASE WHEN userNickname='' or userNickname is null THEN userFirstName ELSE userNickname END ".$_SESSION['sortByOrder'].', userLastName';
break;
}
$query = "
SELECT *
FROM user
WHERE userIsInactive = 0
ORDER BY ".$f_orderBy."
";
#printVar('$query',$query);
$userResult = query_do($query);
#printQuery('$userResult',$userResult);
$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 <?=$_SESSION['sortBy']?>) <span class="smaller">(Sort by:
<?
if ( $_SESSION['sortBy'] == 'First Name' ) { $class = 'menuCurrent'; if ( $_SESSION['sortByOrder'] == "ASC" ) { $sortChar = '↓'; $sortByOrder = 'DESC'; } else { $sortChar = '↑'; $sortByOrder = 'ASC'; } } else { $class = ''; $sortChar = '↑'; $sortByOrder = 'ASC'; }
?>
<a href="<?=$_SERVER['PHP_SELF']?>?sortBy=First Name <?=$sortByOrder?>"><span class="<?=$class?>">First Name<?=$sortChar?></span></a>,
<?
if ( $_SESSION['sortBy'] == 'Last Name' ) { $class = 'menuCurrent'; if ( $_SESSION['sortByOrder'] == "ASC" ) { $sortChar = '↓'; $sortByOrder = 'DESC'; } else { $sortChar = '↑'; $sortByOrder = 'ASC'; } } else { $class = ''; $sortChar = '↑'; $sortByOrder = 'ASC'; }
?>
<a href="<?=$_SERVER['PHP_SELF']?>?sortBy=Last Name <?=$sortByOrder?>"><span class="<?=$class?>">Last Name<?=$sortChar?></span></a>,
<?
if ( $_SESSION['sortBy'] == 'Student Id' ) { $class = 'menuCurrent'; if ( $_SESSION['sortByOrder'] == "ASC" ) { $sortChar = '↓'; $sortByOrder = 'DESC'; } else { $sortChar = '↑'; $sortByOrder = 'ASC'; } } else { $class = ''; $sortChar = '↑'; $sortByOrder = 'ASC'; }
?>
<a href="<?=$_SERVER['PHP_SELF']?>?sortBy=Student Id <?=$sortByOrder?>"><span class="<?=$class?>">Student Id<?=$sortChar?></span></a>,
<?
if ( $_SESSION['sortBy'] == 'User Id' ) { $class = 'menuCurrent'; if ( $_SESSION['sortByOrder'] == "ASC" ) { $sortChar = '↓'; $sortByOrder = 'DESC'; } else { $sortChar = '↑'; $sortByOrder = 'ASC'; } } else { $class = ''; $sortChar = '↑'; $sortByOrder = 'ASC'; }
?>
<a href="<?=$_SERVER['PHP_SELF']?>?sortBy=User Id <?=$sortByOrder?>"><span class="<?=$class?>">User Id<?=$sortChar?></span></a>,
)</span></span></legend>
<?
if ($userCount) {
$usersPerColumn = (int) ($userCount/4+.99);
//echo $usersPerColumn."<br>\n";
?>
<table cellpadding="0" cellspacing="0"><tr>
<?
mysqli_data_seek($userResult, 0);
$usersThisColumn = 0;
while ($userRow = mysqli_fetch_assoc($userResult)) {
if ($userRow['userLoginCount']) {
// User has logged in.
if (date_difference($userRow['userAccessTime'], currentDateTime()) <= 14) {
// User has logged in within the last two weeks.
$status = "Current";
} else {
if (date_difference($userRow['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";
}
}
} else {
// User has never logged in.
$status = "Never";
}
if ($usersThisColumn == 0) {
?>
<td style="padding-right:10px; font-size:0.8em;">
<?
}
if ( $userRow['userNickname'] == '' ) {
$userDisplay = $userRow['userStudentId'].' '.stripslashes($userRow['userFirstName'].' '.$userRow['userLastName']).' #'.$userRow['userId'];
} else {
$userDisplay = $userRow['userStudentId'].' '.stripslashes($userRow['userNickname'].' ('.$userRow['userFirstName'].') '.$userRow['userLastName']).' #'.$userRow['userId'];
}
?>
<a href="/Admin/Classes.php?f_userId=<?=$userRow['userId']?>&f_task=Student Profile&f_subtask=View">
<span class="normal user<?=$status?>" title="lastLogin=<?=valid_date($userRow['userAccessTime'])?>"><?=$userDisplay?></span></a>
<br>
<?
$usersThisColumn++;
if ($usersThisColumn == $usersPerColumn) {
$usersThisColumn = 0;
?>
</td>
<?
}
}
if ($usersThisColumn != 0) {
?>
</td>
<?
}
?>
</tr>
<?
// Get list of users in classes.
/** /
$query = "
SELECT DISTINCT
user.userUsername,
user.userStudentId,
user.userId,
user.userFirstName,
user.userLastName,
user.userEmail,
classstudent.userStudentId AS classStudentId
FROM user
INNER JOIN classstudent ON classstudent.userStudentId = user.userStudentId
INNER JOIN class ON class.classId = classstudent.classId
WHERE class.YRTR = '".$_SESSION['YRTR']['CURRENT']."'
ORDER BY user.userEmail ";
/**/
$query = "
SELECT DISTINCT
user.userUsername,
user.userStudentId,
user.userId,
user.userFirstName,
user.userLastName,
user.userEmail,
classstudent.userStudentId AS classStudentId
FROM user
INNER JOIN classstudent ON classstudent.userStudentId = user.userStudentId
INNER JOIN class ON class.classId = classstudent.classId
WHERE class.YRTR = '".$_SESSION['YRTR']['User']."'
ORDER BY user.userEmail ";
$userResult = query_do($query);
$userResultCount = $_SESSION['qry']['count'];
if ($userResultCount) {
?>
<tr><td colspan="4">
<?
mysqli_data_seek($userResult, 0);
while ($userRow = mysqli_fetch_assoc($userResult)) {
echo $userRow['userEmail']."; ";
}
?>
</td></tr>
<?
} else {
}
?>
</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 {
?>
The user list is empty.
<?
}
?>
</fieldset>
<?
#setDebugOn();
include('common/sectionFooter.phpinc');
?>