PHP cacl_html::show_roles Examples

Example #1

File: admin.community_acl.php Project: vincethecoder/community_acl

            $msg = JText::_('Group saved');
            $mainframe->redirect('index.php?option=com_community_acl&task=' . $redirect, $msg);
            break;
    }
}
function showRoles($option)
{
    global $mainframe;
    $limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
    $limitstart = $mainframe->getUserStateFromRequest($option . '.limitstart', 'limitstart', 0, 'int');
    $group_id = $mainframe->getUserStateFromRequest($option . '.roles.group_id', 'group_id', 0, 'int');
    $db =& JFactory::getDBO();
    $query = "SELECT COUNT(*) FROM `#__community_acl_roles` " . ($group_id > 0 ? " WHERE `group_id` = '{$group_id}' " : '');
    $db->setQuery($query);
    $total = $db->loadResult();
    jimport('joomla.html.pagination');
    $pageNav = new JPagination($total, $limitstart, $limit);
    $query = "SELECT a.*, b.name AS group_name FROM `#__community_acl_roles` AS a LEFT JOIN `#__community_acl_groups` AS b ON b.id = a.group_id " . ($group_id > 0 ? " WHERE a.group_id = '{$group_id}' " : '') . " ORDER BY b.name, a.name";
    $db->setQuery($query, $pageNav->limitstart, $pageNav->limit);
    $rows = $db->loadObjectList();
    if ($db->getErrorNum()) {
        echo $db->stderr();
        return;
    }
    // get list of sections for dropdown filter
    $javascript = 'onchange="document.adminForm.submit();"';
    $groups[] = JHTML::_('select.option', '-1', '- ' . JText::_('Select Group') . ' -');
    $query = 'SELECT id AS value, name AS text' . ' FROM `#__community_acl_groups`' . ' ORDER BY name';