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); }