groups_table, "name", "id", "fGroupID"); $oPatternListBox->setFromClause("LEFT OUTER JOIN groups_units_link GUL on ST.id=GUL.group_id " . "LEFT OUTER JOIN units_lookup UL on GUL.unit_id=UL.id"); $oPatternListBox->setCompositeDisplayName("DISTINCT COALESCE(CONCAT(CONCAT(UL.name, '-'),ST.name),ST.name)"); } else if (Permission::userIsUnitAdministrator()) { // else if this is a unit administrator, only display the groups in your unit $oPatternListBox = & new PatternListBox($default->groups_table, "name", "id", "fGroupID"); $oPatternListBox->setFromClause("INNER JOIN $default->groups_units_table GUL on ST.id=GUL.group_id"); $oPatternListBox->setWhereClause("GUL.unit_id=" . User::getUnitID($_SESSION["userID"])); $oPatternListBox->setIncludeDefaultValue(false); } $oPatternListBox->setPostBackOnChange(true); if ($iGroupID != 0) { $oPatternListBox->setSelectedValue($iGroupID); } return "

Filter By Group

" . $oPatternListBox->render() . "

"; } function getUsers($fGroupID) { global $default; $sQuery = "SELECT DISTINCT U.id as userID, U.name as name, U.username, " . "'Edit', 'Delete', 'Edit Groups' " . "FROM $default->users_table U " . "INNER JOIN $default->users_groups_table UGL ON U.id = UGL.user_id " . "INNER JOIN $default->groups_table GL ON UGL.group_id = GL.id "; // filter by group if ($fGroupID) { $sWhereClause = "WHERE UGL.group_id = $fGroupID "; } // #2978 don't display sys admin accounts if you're not a sysadmin if (!Permission::userIsSystemAdministrator()) { $sRestrictUsers = " GL.is_sys_admin = 0 "; if (strlen($sWhereClause) > 0) { $sWhereClause .= " AND $sRestrictUsers"; } else { $sWhereClause = "WHERE $sRestrictUsers"; } } $sQuery .= $sWhereClause . "ORDER BY U.name"; $aColumns = array("name", "username", "Edit", "Delete", "Edit Groups"); $aColumnNames = array("Name", "Username", "Edit", "Delete", "Edit Groups"); $aColumnTypes = array(1,1,3,3,3); $aDBColumnArray = array("userID"); $aQueryStringVariableNames = array("fUserID"); $aHyperLinkURL = array( 2=> "$default->rootUrl/control.php?action=editUser", 3=> "$default->rootUrl/control.php?action=removeUser", 4=> "$default->rootUrl/control.php?action=editUserGroups"); $oSearchResults = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnNames, "100%", $aHyperLinkURL,$aDBColumnArray,$aQueryStringVariableNames); $oSearchResults->setDisplayColumnHeadings(true); return $oSearchResults->render() ; } function getPage($fGroupID) { global $default; $sToRender .= renderHeading("User Management"); // add user link if you're a sysadmin if (Permission::userIsSystemAdministrator()) { $sToRender .= getAddLink("addUser", "Add A User"); } $sToRender .= getGroupDisplay($fGroupID); $sToRender .= getUsers($fGroupID); return $sToRender; } ?>