Please select a User:\n"; } $sToRender .= renderHeading("Edit User Groups"); $sToRender .= "\n"; $sToRender .= $heading; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "
User Name: " . getUserDisplay($oUser) . "
\n"; return $sToRender; } function getGroupUnitsList($fGroupID){ $sQuery = "SELECT groups_lookup.id as groupID, units_lookup.name as name, units_lookup.id as UnitID " . "FROM (groups_lookup inner join groups_units_link on groups_lookup.id = groups_units_link.group_id) " . "inner join units_lookup on units_lookup.id = groups_units_link.unit_id " . "Where groups_lookup.id = $fGroupID " . "ORDER BY groups_lookup.name "; $aColumns = array("name"); $aColumnNames = array("Current Units"); $aColumnTypes = array(1); $aDBColumnArray = array("UnitID"); $aQueryStringVariableNames = array("fUnitID"); $oSearchResults = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnNames, "100%", $aDBColumnArray,$aQueryStringVariableNames); $oSearchResults->setDisplayColumnHeadings(true); $htmlTables = $oSearchResults->render() ; return $htmlTables; } // get page for removal function getUnitPage($iGroupID) { global $default; $oUser = null; $oGroup = null; $sWhereClause = "WHERE " . $default->owl_groups_units_table . ".group_id = $iGroupID"; $aGroupUnitLink = GroupUnitLink::getList($sWhereClause); // change headings if User selected if (isset($iGroupID)) { $oGroup = Group::get($iGroupID); } $sFontTag .= ""; $sTableTag .= ""; $sBgColor = "#F5F6EE"; $sToRender .= renderHeading("Edit Group Units"); $sToRender .= "
"; $sToRender .= "\n"; $sToRender .= "
Group Name: " . $oGroup->getName() . ""; $sToRender .= "rootUrl/control.php?action=listGroups\">graphicsUrl/widgets/back.gif\" border = \"0\" />"; $sToRender .= "
"; $sToRender .= ""; $sToRender .= "
"; $sToRender .= ""; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "
" . getGroupUnitsList($iGroupID) . "

"; $sToRender .= "
\n"; $sToRender .= "\n"; $sToRender .= ""; $sToRender .= ""; $sToRender .= ""; $sToRender .= "
Options
"; $sToRender .= "
rootUrl/control.php?action=assignGroupToUnit&fGroupID=$iGroupID\">  Add Group to a Unit

"; $sToRender .= "
"; $sToRender .= "
"; $sToRender .= "
rootUrl/control.php?action=removeGroupFromUnit&fGroupSet=1&fGroupID=$iGroupID\">  Remove Group from a Unit

"; $sToRender .= "
"; $sToRender .= "
\n"; $sToRender .= "
\n"; return $sToRender; } // get page for removal function getDeleteConfirmedPage($iUserID,$fGroupID) { global $default; $oUser = null; $oGroup = null; // change headings if User selected if (isset($iUserID)) { $oUser = User::get($iUserID); $heading = "Are you sure you wish to remove this user from the Group?"; } // change headings if User selected if (isset($fGroupID)) { $oGroup = Group::get($fGroupID); $Groupdisplay = "Group Name: " . $oGroup->getName() . "\n"; } $sToRender .= "" . renderHeading("Edit User Groups") . "
"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= $heading; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= $Groupdisplay; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "
User Name: " . getUserDisplay($oUser) . "
" . getDeleteButton($oUser); $sToRender .= "" . getCancelButton($oUser); $sToRender .= "
\n"; return $sToRender; } // show paig if deletion fails function getPageFail() { global $default; $sToRender .= "" . renderHeading("Edit User Groups") . "
"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "
Sorry, Removal Failed
rootUrl/control.php?action=removeUserFromGroup\">graphicsUrl/widgets/back.gif\" border = \"0\" />
\n"; return $sToRender; } // show success page if removed from Group successfully function getPageSuccess() { global $default; $sToRender .= "" . renderHeading("Edit User Groups") . "
"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "
Success!
The User was successfully removed from the Group
rootUrl/control.php?action=listUsers\">graphicsUrl/widgets/back.gif\" border = \"0\" />
\n"; return $sToRender; } // show listbox of Users belonging to Users_Groups_link table function getUserDisplay($oUser) { global $default; if (!isset($oUser)) { $oPatternListBox = & new PatternListBox($default->owl_users_table, "username", "id", "fUserID"); if (Permission::userIsUnitAdministrator()) { $oPatternListBox->setFromClause("INNER JOIN $default->owl_users_groups_table UGL on ST.id=UGL.user_id " . "INNER JOIN $default->owl_groups_units_table GUL on UGL.group_id=GUL.group_id"); $oPatternListBox->setWhereClause("GUL.unit_id=" . User::getUnitID($_SESSION["userID"])); } $oPatternListBox->setPostBackOnChange(true); return $oPatternListBox->render(); } else { return "iId . "\">\n" . $oUser->getUserName(); } } // display the listbox initially ..then just display the text function getOtherGroupDisplay($oGroup) { global $default; if (!isset($oGroup)) { if (Permission::userIsSystemAdministrator()) { // if this is the system administrator, prepend group names with unit name $oPatternListBox = & new PatternListBox($default->owl_groups_table, "name", "id", "fOtherGroupID"); $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->owl_groups_table, "name", "id", "fOtherGroupID"); $oPatternListBox->setFromClause("INNER JOIN $default->owl_groups_units_table GUL on ST.id=GUL.group_id"); $oPatternListBox->setWhereClause("GUL.unit_id=" . User::getUnitID($_SESSION["userID"])); } return $oPatternListBox->render(); } else { return "iId . "\">\n" . $oGroup->getName(); } } // show Group details on confirm deletion page function getGroupDisplay($aGroup) { global $default; $sBgColor = "#F5F6EE"; $oGroup= null; $sGroup = ""; for ($i=0;$i < count($aGroup);$i++) { $oGroup= Group::get($aGroup[$i]); $Options .= "\n"; } $sGroup .= $Options . "
" . ($i+1) . "". $oGroup->getName() ."
"; return $sGroup; /*$oGroup= null; $sGroup = ""; return $sGroup;*/ } // show delete button or select button function getDeleteButton($oUser) { global $default; if (!isset($oUser)) { return "graphicsUrl/widgets/select.gif\" value=\"submit\" border=\"0\"/>\n"; } else { return "graphicsUrl/widgets/delete.gif\" value=\"submit\" border=\"0\"/>\n"; } } // show delete button or select button function getSelectButton($oUser) { global $default; if (!isset($oUser)) { return "graphicsUrl/widgets/select.gif\" value=\"submit\" border=\"0\"/>\n"; } else { return "graphicsUrl/widgets/select.gif\" value=\"submit\" border=\"0\"/>\n"; } } // show cancel button function getCancelButton($oUser) { global $default; if (!isset($oUser)) { //return "rootUrl/control.php?action=UserManagement\">graphicsUrl/widgets/cancel.gif\" value=\"cancel\" />\n"; } else { return "rootUrl/control.php?action=listUsers\">graphicsUrl/widgets/cancel.gif\" border = \"0\" />\n"; } } ?>