\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= _("Document Field is not Lookup enabled."); $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "rootUrl/control.php?action=listDocFields\">graphicsUrl/widgets/back.gif\" border = \"0\" />"; $sToRender .= "\n"; $sToRender .= "\n"; return $sToRender ; } // get page for removal function getPage($iUserID) { global $default; $oUser = null; $oGroup = null; // change headings if User selected if (isset($iUserID)) { $oUser = User::get($iUserID); } else { $heading = "" . _("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; } // get page for removal function getGroupPage($fDocFieldID) { global $default; $oDocField = DocumentField::get($fDocFieldID); $LookupDisplay .= "" . _("Current Lookups") . "
\n"; $sQuery = " Select * " . " From " . $default->metadata_table . " WHERE document_field_id=" . $fDocFieldID; $aColumns = array("name"); $aColumnNames = array(_("Lookup name")); $aColumnTypes = array(1); $aDBColumnArray = array("id"); $aQueryStringVariableNames = array("fDocFieldLookupID"); $oSearchResults = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnNames, "100%", $aHyperLinkURL,$aDBColumnArray,$aQueryStringVariableNames); $oSearchResults->setEmptyTableMessage("" . _("You must enter at least one value!") . ""); $LookupDisplay .= $oSearchResults->render() ; $sFontTag .= ""; $sTableTag .= ""; $sBgColor = "#F5F6EE"; $sToRender .= renderHeading("Edit Document Field Lookups"); $sToRender .= "
"; $sToRender .= "\n"; $sToRender .= "

" . _("Field Name") . ":  " . $oDocField->getName() . "

"; $sToRender .= "rootUrl/control.php?action=listDocFields\">graphicsUrl/widgets/back.gif\" border = \"0\" />"; $sToRender .= "
"; $sToRender .= ""; $sToRender .= "
"; $sToRender .= ""; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "
" . $LookupDisplay . "

"; $sToRender .= "
\n"; $sToRender .= "\n"; $sToRender .= ""; $sToRender .= ""; $iDocFieldLookupCount = DocumentField::getLookupCount($fDocFieldID); if ($iDocFieldLookupCount > 0) { $sToRender .= ""; $sToRender .= ""; } $sToRender .= "
Options
"; $sToRender .= "
rootUrl/control.php?action=addMetaDataForField&fDocFieldID=$fDocFieldID\">  " . _("Add Document Field Lookups") . "

"; $sToRender .= "
"; $sToRender .= "
"; $sToRender .= "
rootUrl/control.php?action=editMetadataForField&fDocFieldID=$fDocFieldID\">  " . _("Edit Document Field Lookups") . "

"; $sToRender .= "
"; $sToRender .= "
"; $sToRender .= "
rootUrl/control.php?action=removeMetaDataFromField&fDocFieldID=$fDocFieldID\">  " . _("Remove Document Field Lookups") . "

"; $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->users_table, "username", "id", "fUserID"); if (Permission::userIsUnitAdministrator()) { $oPatternListBox->setFromClause("INNER JOIN $default->users_groups_table UGL on ST.id=UGL.user_id " . "INNER JOIN $default->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->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->groups_table, "name", "id", "fOtherGroupID"); $oPatternListBox->setFromClause("INNER JOIN $default->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; } // 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"; } } ?>