admin usertable paging and sort

[sql-web.git] / admin / main.php

<?php

require_once('../mitsql.cfg.php');
require_once('mitsql.lib.php');

if ((isAdmin() || isImpersonating()) && isset($i_impersonate)) {
	impersonate($i_impersonate);
	redirectStart();
	exit;
}

if (!isAdmin()) redirectStart();

empty($i_pagesize) && $i_pagesize=20;
empty($i_page) && $i_page=1;
empty($i_sortby) && $i_sortby='dSignup';
empty($i_sortorder) && $i_sortorder=0;

if ($i_sortorder>0) $sortSQL = 'ASC'; else $sortSQL = 'DESC';

$i_pagesize = mysql_escape_string($i_pagesize);
$i_page = mysql_escape_string($i_page);
$i_sortby = mysql_escape_string($i_sortby);

$columns = array('','Username','Name','nBytes','nBytesHard','nBytesOver','dSignup');

$userCount = 0;
$sqlc = "SELECT COUNT(*) as c FROM User WHERE bEnabled=1";
$r = fetchRows(DBSelect($sqlc));
$r = array_shift($r);
count($r) && $userCount = array_shift($r);

$sql = sprintf("SELECT User.UserId,Username,Name,dSignup,dLastCheck,nBytes,nBytesSoft,nBytesHard,
					IF(nBytes>nBytesHard,nBytes-nBytesHard,0) as nBytesOver
				FROM User
				NATURAL JOIN UserStat
				NATURAL JOIN UserQuota
				WHERE bEnabled=1
				ORDER BY $i_sortby $sortSQL");

$sql .= ' LIMIT '.($i_page-1)*$i_pagesize.','.$i_pagesize;
$pageArray = range(1,ceil($userCount/$i_pagesize));
$pageCount = count($pageArray);

$users = fetchRows(DBSelect($sql),'UserId');

include 'tpl/head.php';

?>
<style>
table.usertable td {
	border: 1px solid black;
	padding: 0px 2px 0px 2px;
}
</style>
<?php

echo '<em>',$userCount,' users</em> | ';
if ($i_page > 1) $tPagePrev = ' <a href="'.$URI.newQS('page',$i_page-1).'">Prev</a>'; else $tPagePrev = 'First';
if ($i_page < $pageCount) $tPageNext = ' <a href="'.$URI.newQS('page',$i_page+1).'">Next</a>'; else $tPageNext = 'Last';
if (!empty($tPageNext) && empty($tPagePrev)) echo($tPageNext);
elseif (empty($tPageNext) && !empty($tPagePrev)) echo($tPagePrev);
else echo "$tPagePrev | $tPageNext";

/*
echo ' | Skip to: ';
foreach($pageArray as $availablePage) {
	echo ' <a href="'.$URI.newQS('page',$availablePage).'">'.$availablePage.'</a>';
}
*/

echo ' | Page '.$i_page.' of '.$pageCount.' by '.$i_sortby;

echo '<table cellspacing="0" cellpadding="0" class="usertable">';
echo '<thead>';
foreach($columns as $column) {
	if (!empty($column)) {
		$qsa = array('sortby'=>$column);
		if ($column==$i_sortby)
			$qsa['sortorder']=abs($i_sortorder-1);
		echo '<td><a href="'.$URI.newQSA($qsa).'">'.$column.'</a></td>';
	} else echo '<td></td>';
}
echo '</thead>';
foreach($users as $id=>$user) {
	echo '<tr><td>',
		$user['UserId'],
		'</td><td>',
		'<a href="do/admin/main',newQSA(array('impersonate'=>$id)),'">',
		$user['Username'],
		'</a></td><td><a href="http://web.mit.edu/bin/cgicso?query='.$user['Username'].'" target="_new">',
		$user['Name'],
		'</a></td><td>',
		sprintSize($user['nBytes']),
		'</td><td>',
		sprintSize($user['nBytesHard']),
		'</td><td>',
		sprintSize($user['nBytesOver']),
		'</td><td>',
		$user['dSignup'],
//		'</td><td>',
//		$user['dLastCheck'],
		'</td></tr>';
}
echo '</table>';

include 'tpl/foot.php';

?>