function ALU_showList($option)
{
$db =& JFactory::GetDbo();
$app =& JFactory::getApplication('administrator');
$limit = intval($app->getUserStateFromRequest("viewlistlimit{$option}_group_managers", 'limit', $app->getCfg('list_limit')));
$limitstart = intval($app->getUserStateFromRequest("view{$option}_lms_group_managers_limitstart", 'limitstart', 0));
$filt_groups = intval($app->getUserStateFromRequest("filt_groups{$option}", 'filt_groups', 0));
$filt_users = intval($app->getUserStateFromRequest("filt_users{$option}", 'filt_users', 0));
$query = "SELECT COUNT(a.user_id)" . "\n FROM #__lms_user_assign_groups as a, #__lms_users as b, #__lms_usergroups as c, #__users as d" . "\n WHERE a.user_id = b.user_id" . "\n AND a.group_id = c.id" . "\n AND b.user_id = d.id" . ($filt_groups ? "\n AND a.group_id = '{$filt_groups}'" : '') . ($filt_users ? "\n AND b.user_id = '{$filt_users}'" : '');
$db->setQuery($query);
$total = $db->loadResult();
require_once JPATH_SITE . DS . 'components' . DS . 'com_joomla_lms' . DS . 'includes' . DS . 'classes' . DS . 'lms.pagination.new.php';
$pageNav = new JLMSPagination($total, $limitstart, $limit);
// get the subset (based on limits) of required records
$query = "SELECT d.name, d.username, c.ug_name, a.user_id, a.group_id" . "\n FROM #__lms_user_assign_groups as a, #__lms_users as b, #__lms_usergroups as c, #__users as d" . "\n WHERE a.user_id = b.user_id" . "\n AND a.group_id = c.id" . "\n AND b.user_id = d.id" . ($filt_groups ? "\n AND a.group_id = '{$filt_groups}'" : '') . ($filt_users ? "\n AND b.user_id = '{$filt_users}'" : '') . "\n ORDER BY d.name, d.username, c.ug_name" . "\n LIMIT {$pageNav->limitstart}, {$pageNav->limit}";
$db->setQuery($query);
$rows = $db->loadObjectList();
$lists = array();
$query = "SELECT id as value, ug_name as text FROM #__lms_usergroups WHERE course_id = 0 AND parent_id = 0 ORDER by ug_name";
$db->setQuery($query);
$sf_groups = array();
$sf_groups[] = mosHTML::makeOption('0', _JLMS_USERS_SLCT_GR_);
$sf_groups = array_merge($sf_groups, $db->loadObjectList());
$lists['jlms_groups'] = mosHTML::selectList($sf_groups, 'filt_groups', 'class="text_area" size="1" style="width: 266px;" onchange="document.adminForm.submit();"', 'value', 'text', $filt_groups);
$query = "SELECT c.id as value, c.name as text FROM #__lms_user_assign_groups as a, #__lms_users as b, #__users as c WHERE a.user_id = b.user_id AND c.id = b.user_id group by c.id order by c.name";
$db->setQuery($query);
$sf_users = array();
$sf_users[] = mosHTML::makeOption('0', _JLMS_USERS_SLCT_USER_);
$sf_users = array_merge($sf_users, $db->loadObjectList());
$lists['jlms_users'] = mosHTML::selectList($sf_users, 'filt_users', 'class="text_area" size="1" style="width: 266px;" onchange="document.adminForm.submit();"', 'value', 'text', $filt_users);
ALU_html::JLMS_showGroup_managers($rows, $pageNav, $lists, $option);
}
