acl(); if (! $perms->checkModule($m, 'view','',$AppUI->user_groups[-1])) $AppUI->redirect('m=public&a=access_denied'); if (! $perms->checkModule('users', 'view','',$AppUI->user_groups[-1])) $AppUI->redirect('m=public&a=access_denied'); $AppUI->savePlace(); if (isset( $_GET['tab'] )) { $AppUI->setState( 'UserIdxTab', $_GET['tab'] ); } $tab = $AppUI->getState( 'UserIdxTab' ) !== NULL ? $AppUI->getState( 'UserIdxTab' ) : 0; if (isset( $_GET['stub'] )) { $AppUI->setState( 'UserIdxStub', $_GET['stub'] ); $AppUI->setState( 'UserIdxWhere', '' ); } else if (isset( $_POST['where'] )) { $AppUI->setState( 'UserIdxWhere', $_POST['where'] ); $AppUI->setState( 'UserIdxStub', '' ); } $stub = $AppUI->getState( 'UserIdxStub' ); $where = $AppUI->getState( 'UserIdxWhere' ); if (isset( $_GET['orderby'] )) { $AppUI->setState( 'UserIdxOrderby', $_GET['orderby'] ); } $orderby = $AppUI->getState( 'UserIdxOrderby' ) ? $AppUI->getState( 'UserIdxOrderby' ) : 'user_username'; // Pull First Letters $let = ":"; $q = new DBQuery; $q->addTable('users','u'); $q->addQuery('DISTINCT UPPER(SUBSTRING(user_username, 1, 1)) AS L'); $arr = $q->loadList(); foreach( $arr as $L ) { $let .= $L['L']; } $q = new DBQuery; $q->addTable('users','u'); $q->addQuery('DISTINCT UPPER(SUBSTRING(user_first_name, 1, 1)) AS L'); $arr = $q->loadList(); foreach( $arr as $L ) { if ($L['L']) $let .= strpos($let, $L['L']) ? '' : $L['L']; } $q = new DBQuery; $q->addTable('users','u'); $q->addQuery('DISTINCT UPPER(SUBSTRING(user_last_name, 1, 1)) AS L'); $arr = $q->loadList(); foreach( $arr as $L ) { if ($L['L']) $let .= strpos($let, $L['L']) ? '' : $L['L']; } $a2z = "\n"; $a2z .= "\n"; $a2z .= ''; $a2z .= ''; for ($c=65; $c < 91; $c++) { $cu = chr( $c ); $cell = strpos($let, "$cu") > 0 ? "$cu" : "$cu"; $a2z .= "\n\t"; } $a2z .= "\n\n

' . $AppUI->_('Show'). ':

' . $AppUI->_('All') . '

$cell

"; // setup the title block $titleBlock = new CTitleBlock( 'User Management', 'helix-setup-users.png', $m, "$m.$a"); if ($perms->checkModule('admin', 'add', '', $AppUI->user_groups[-1])) $titleBlock->addCrumb("?m=admin&a=addedituser","Add user"); $where = dPformSafe( $where, true ); $titleBlock->addCrumb("?m=admin&reload=1","Reload user"); $titleBlock->addCell( $a2z ); $titleBlock->show(); ?> '; // tabbed information boxes $tabBox = new CTabBox( "?m=admin", "{$dPconfig['root_dir']}/modules/admin/", $tab ); $tabBox->add( 'vw_active_usr', 'Active Users' ); $tabBox->add( 'vw_inactive_usr', 'Inactive Users' ); $tabBox->add( 'vw_usr_log', 'User Log' ); $tabBox->show( $extra ); ?>