annotate(array('ticket_count'=>SqlAggregate::COUNT('tickets'))); if ($_REQUEST['query']) { $search = $_REQUEST['query']; $users->filter(Q::any(array( 'emails__address__contains' => $search, 'name__contains' => $search, 'org__name__contains' => $search, // TODO: Add search for cdata ))); $qs += array('query' => $_REQUEST['query']); } $sortOptions = array('name' => 'name', 'email' => 'emails__address', 'status' => 'account__status', 'organization' => 'org__name', 'create' => 'created', 'update' => 'updated'); $orderWays = array('DESC'=>'-','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 ?: 'name'; if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) $order = $orderWays[strtoupper($_REQUEST['order'])]; if ($order_column && strpos($order_column,',')) $order_column = str_replace(','," $order,",$order_column); $x=$sort.'_sort'; $$x=' class="'.($order == '' ? 'asc' : 'desc').'" '; $total = $users->count(); $page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1; $pageNav=new Pagenate($total,$page,PAGE_LIMIT); $pageNav->paginate($users); $qstr = '&'. Http::build_query($qs); $qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']); $pageNav->setURL('users.php', $qs); $qstr.='&order='.($order=='-' ? 'ASC' : 'DESC'); //echo $query; $_SESSION[':Q:users'] = $users; $users->values('id', 'name', 'default_email__address', 'account__id', 'account__status', 'org__name', 'created', 'updated'); $users->order_by($order . $order_column); ?>

hasPerm(User::PERM_CREATE)) { ?>
    hasPerm(User::PERM_EDIT)) { ?>
    • getClientRegistrationMode()) { ?>
    • hasPerm(User::PERM_MANAGE)) { ?>
    • hasPerm(User::PERM_DELETE)) { ?>
exists(true)) $showing .= $pageNav->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)', $U['ticket_count']); ?>  
:           '; echo __('Query returned 0 results.'); echo ''; } ?>
 '.__('Page').': %s   '.__('Export').'', $pageNav->getPageLinks(), $qhash); } ?>