addTable('users','u');
$q->addQuery('u.user_id, u.user_username, u.user_first_name, u.user_last_name');
$q->addJoin('user_setcap', 'us', 'u.user_id = us.user_id');
$q->addWhere('us.group_id = '.$company_id);
$q->addOrder('u.user_last_name');
if (!($rows = $q->loadList())) {
echo $AppUI->_('No data available').'
'.$AppUI->getMsg();
} else {
?>
| _( 'Username' );?>
| _( 'Name' );?>
|
';
$s .= ''.$row["user_username"].'';
$s .= ' | '.$row["user_last_name"].", ".$row["user_first_name"].' | ';
$s .= '';
}
echo $s;
?>