$_REQUEST['query']); } $sortOptions = array('name' => 'user.name', 'email' => 'email.address', 'status' => 'account_status', 'organization' => 'organization', 'create' => 'user.created', 'update' => 'user.updated'); $orderWays = array('DESC'=>'DESC','ASC'=>'ASC'); $sort= ($_REQUEST['sort'] && $sortOptions[strtolower($_REQUEST['sort'])]) ? strtolower($_REQUEST['sort']) : 'name'; //Sorting options... if ($sort && $sortOptions[$sort]) $order_column =$sortOptions[$sort]; $order_column = $order_column ?: 'user.name'; if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) $order = $orderWays[strtoupper($_REQUEST['order'])]; $order=$order ?: 'ASC'; if ($order_column && strpos($order_column,',')) $order_column = str_replace(','," $order,",$order_column); $x=$sort.'_sort'; $$x=' class="'.strtolower($order).'" '; $order_by="$order_column $order "; $total=db_count('SELECT count(DISTINCT user.id) '.$from.' '.$where); $page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1; $pageNav=new Pagenate($total,$page,PAGE_LIMIT); $qstr = '&'. Http::build_query($qs); $qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']); $pageNav->setURL('users.php', $qs); $qstr.='&order='.($order=='DESC' ? 'ASC' : 'DESC'); $select .= ', count(DISTINCT ticket.ticket_id) as tickets '; $from .= ' LEFT JOIN '.TICKET_TABLE.' ticket ON (ticket.user_id = user.id) '; $query="$select $from $where GROUP BY user.id ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit(); //echo $query; $qhash = md5($query); $_SESSION['users_qs_'.$qhash] = $query; ?>

showing(); else $showing .= __('No users found!'); ?>


	href="users.php?&sort=name">	href="users.php?&sort=status">	href="users.php?&sort=organization">	href="users.php?&sort=create">	href="users.php?&sort=update">
	(%d)', $row['tickets']); ?>
: '; echo __('Query returned 0 results.'); echo ''; } ?>

'.__('Page').': %s '.__('Export').'', $pageNav->getPageLinks(), $qhash); endif; ?>