fileSystemRoot/lib/documentmanagement/Document.inc"); /** * $Id$ * * Presentation information used for folder editing. Used by editBL.php. * * Copyright (c) 2003 Jam Warehouse http://www.jamwarehouse.com * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * * @version $Revision$ * @author Rob Cherry, Jam Warehouse (Pty) Ltd, South Africa * @package foldermanagement */ function getFolderPath($iFolderID) { global $default; global $default; $sSectionName = $default->siteMap->getSectionName(substr($_SERVER["PHP_SELF"], strlen($default->rootUrl), strlen($_SERVER["PHP_SELF"]))); $sTDBGColour = $default->siteMap->getSectionColour($sSectionName, "td"); return "
" . displayFolderPathLink(Folder::getFolderPathAsArray($iFolderID), Folder::getFolderPathNamesAsArray($iFolderID), "$default->rootUrl/control.php?action=browse") . "
\n"; } function getFolderData($iFolderID, $sDivName, $sStatusMessage = "") { global $default; $sSectionName = $default->siteMap->getSectionName(substr($_SERVER["PHP_SELF"], strlen($default->rootUrl), strlen($_SERVER["PHP_SELF"]))); $sTDBGColour = $default->siteMap->getSectionColour($sSectionName, "td"); /*ok*/ $sQuery = array("SELECT F.id, F.name, F.description, F.is_public " . "FROM $default->folders_table AS F " . "WHERE F.id = ?", $iFolderID); $aColumns = array("name", "description", "is_public"); $aColumnHeaders = array(_("Name"), _("Description"), _("Public")); $aColumnTypes = array(1,1,2); $oPatternListFromQuery = & new PatternListFromQuery($sQuery, $aColumns, $aColumnHeaders, $aColumnTypes); $oPatternListFromQuery->setTableHeading(_("Folder Data")); $oPatternListFromQuery->setTableWidth("610"); $sToRender .= ""; if (strlen($sStatusMessage) > 0) { $sToRender .= ""; } $sToRender .= ""; $sToRender .= ""; $sToRender .= "
$sStatusMessage
" . $oPatternListFromQuery->render() . "
rootUrl/control.php?action=modifyFolderData&fFolderID=$iFolderID\">
";; if ($sStatusMessage) { return $sToRender; } else { return renderSectionDiv($sDivName, $sToRender); } } function getFolderRouting($iFolderID, $sDivName, $bCollaboration) { global $default; //had to use coalesce and left outer join for user_id because this column was a new addition //and the user_ids for existing documents before this change will be null /*ok*/ $sQuery = array("SELECT GFAL.id as id, GFAL.folder_id AS folder_id, COALESCE(G.name, 'Not Assigned') AS group_name, G.id AS group_id, GFAL.role_id AS role_id, R.name AS role_name, GFAL.precedence AS precedence, COALESCE(U.id, -1) AS user_id, COALESCE(U.name, 'Not Assigned') AS user_name, 'Edit' as edit, 'Delete' as del, 'Dependant docs' as depn " . "FROM $default->groups_folders_approval_table AS GFAL INNER JOIN roles AS R ON GFAL.role_id = R.id " . "LEFT OUTER JOIN $default->groups_table AS G ON G.id = GFAL.group_id " . "LEFT OUTER JOIN $default->users_table AS U ON U.id = GFAL.user_id " . "WHERE GFAL.folder_id = ? " . "ORDER BY GFAL.precedence, role_name ASC", $iFolderID); $aColumns = array("group_name", "role_name", "precedence", "user_name", "edit", "del", "depn"); $aColumnHeaders = array(_("Group"), _("Role"), _("Seq"), _("User"), "", ""); $aColumnTypes = array(1,1,1,1,3,3,3); $aDBColumnArray = array("id","folder_id","group_id","user_id","precedence","role_id"); $aQueryStringVariableNames = array("fFolderCollaborationID", "fFolderID", "fGroupID","fUserID","fSequenceNumber","fRoleID"); $aLinkURLs = array(4=>"$default->rootUrl/control.php?action=modifyFolderCollaboration",5=>"$default->rootUrl/control.php?action=deleteFolderCollaboration", 6=>"$default->rootUrl/control.php?action=viewDependantDocument"); $oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "610", $aLinkURLs, $aDBColumnArray,$aQueryStringVariableNames); $oPatternTableSqlQuery->setTableHeading(_("Document Routing")); $oPatternTableSqlQuery->setDisplayColumnHeadings(true); $sToRender .= ""; if ($bCollaboration) { $sToRender .= ""; } $sToRender .= ""; if (!$bCollaboration) { $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; } $sToRender .= "
" . _("Documents in this folder are currently undergoing this collaboration process, so these steps can't be altered") . "
" . $oPatternTableSqlQuery->render() . "
\n"; $sToRender .= "rootUrl/control.php?action=addFolderCollaboration&fFolderID=$iFolderID\">\n"; $sToRender .= "
"; return renderSectionDiv($sDivName, $sToRender); } function getFolderDocTypes($iFolderID, $sDivName) { global $default; /*ok*/ $sQuery = array("SELECT FDL.id, FDL.folder_id, FDL.document_type_id, DTL.name, 'Remove' AS del " . "FROM $default->folder_doctypes_table AS FDL INNER JOIN $default->document_types_table AS DTL ON FDL.document_type_id = DTL.id " . "WHERE FDL.folder_id = ? " . "ORDER BY DTL.name ASC", $iFolderID); $aColumns = array("name", "del"); $aColumnHeaders = array("",""); $aColumnTypes = array(1,3,3); $aDBColumnArray = array("id","folder_id"); $aQueryStringVariableNames = array("fFolderDocTypeID", "fFolderID"); $aLinkURLs = array(1=>"$default->rootUrl/control.php?action=deleteFolderDocType"); $oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "610", $aLinkURLs, $aDBColumnArray,$aQueryStringVariableNames); $oPatternTableSqlQuery->setTableHeading(_("Document Types")); $oPatternTableSqlQuery->setDisplayColumnHeadings(true); $sToRender .= ""; $sToRender .= ""; $sToRender .= ""; $sToRender .= "
" . $oPatternTableSqlQuery->render() . "
rootUrl/control.php?action=addFolderDocType&fFolderID=$iFolderID\">
"; return renderSectionDiv($sDivName, $sToRender); } function getFolderGroupAccess($iFolderID, $sDivName) { global $default; /*ok*/ $sQuery = "SELECT GFL.id as id, GFL.group_id AS group_id, GFL.folder_id AS folder_id, GFL.can_read AS can_read, GFL.can_write AS can_write, GL.name AS group_name, 'Edit' as edit, 'Delete' as del " . "FROM $default->groups_folders_table AS GFL " . "INNER JOIN $default->groups_table AS GL ON GFL.group_id = GL.id " . "WHERE GFL.folder_id = ?"; $iInheritedFolderID = $iFolderID; $bFoundPermissions = false; $bInherited = false; $oInheritedFolder = Folder::get($iInheritedFolderID); while ($bFoundPermissions !== true) { /*ok*/$aCheckQuery = array('SELECT id FROM groups_folders_link WHERE folder_id = ? LIMIT 1', $iInheritedFolderID); if (count(DBUtil::getResultArrayKey($aCheckQuery, 'id')) == 0) { $default->log->info('No direct permissions on folder ' . $iInheritedFolderID); $bInherited = true; $iInheritedFolderID = $oInheritedFolder->getParentID(); $oInheritedFolder = Folder::get($iInheritedFolderID); if ($oInheritedFolder === false) { $iInheritedFolderID = false; break; } $default->log->info('... trying parent: ' . $iInheritedFolderID); } else { $default->log->info('Found direct permissions on folder ' . $iInheritedFolderID); break; } } $aColumns = array("group_name", "can_read", "can_write", "edit", "del"); $aColumnHeaders = array(_("Group"), _("Read"), _("Write"), "", ""); $aColumnTypes = array(1,2,2,3,3); $aDBColumnArray = array("id","folder_id"); $aQueryStringVariableNames = array("fGroupFolderLinkID", "fFolderID"); $aLinkURLs = array(3=>"$default->rootUrl/control.php?action=modifyGroupFolderLink",4=>"$default->rootUrl/control.php?action=deleteGroupFolderLink"); $oPatternTableSqlQuery = & new PatternTableSqlQuery(array($sQuery, $iInheritedFolderID), $aColumns, $aColumnTypes, $aColumnHeaders, "610", $aLinkURLs, $aDBColumnArray,$aQueryStringVariableNames); $oPatternTableSqlQuery->setTableHeading(_("Folder Permissions")); $oPatternTableSqlQuery->setDisplayColumnHeadings(true); if ($bInherited === true) { $oPatternTableSqlQuery->setDisabled(true); $oPatternTableSqlQuery->setTableHeading(_("Folder Permissions") . "(" . _("inherited") . ")"); } $sToRender .= ""; $sToRender .= ""; if (($bInherited === true) && ($iInheritedFolderID !== false)) { $sSectionName = $default->siteMap->getSectionName(substr($_SERVER["PHP_SELF"], strlen($default->rootUrl), strlen($_SERVER["PHP_SELF"]))); $sTDBGColour = $default->siteMap->getSectionColour($sSectionName, "td"); $sToRender .= '"; } else { $sToRender .= ""; } $sToRender .= "
" . $oPatternTableSqlQuery->render() . "
Inherited from: '; $sToRender .= displayFolderPathLink(Folder::getFolderPathAsArray($iInheritedFolderID), Folder::getFolderPathNamesAsArray($iInheritedFolderID), "$default->rootUrl/control.php?action=editFolder"); $sToRender .= ""; $sToRender .= " (" . generateLink("/control.php", "action=copyFolderPermissions&fFolderID=$iFolderID&fInheritedFolderID=$iInheritedFolderID", _("Copy")) . ")"; $sToRender .= "
rootUrl/control.php?action=addGroupFolderLink&fFolderID=$iFolderID\">
"; return renderSectionDiv($sDivName, $sToRender); } function renderSectionDiv($sDivName, $sHtml) { global $default; if ($default->bNN4) { return ""; } else { return ""; } } function renderFolderSection($sSectionName, $sHeadingText, $bDisplayLink, $iFolderID) { if ($bDisplayLink) { $sLink = generateControllerLink("editFolder", "fFolderID=$iFolderID&fShowSection=$sSectionName", $sHeadingText); } else { $sLink = "$sHeadingText"; } return "$sLink\n"; } function getPage($iFolderID, $sStatusMessage, $bCollaboration = false) { global $default; $sToRender = "
"; $sToRender .= renderHeading(_("Modify Folder Properties")); $sToRender .= getFolderPath($iFolderID); $sToRender .= ""; $sToRender .= "
"; $sToRender .= ""; // if we have a status message, then make the section links refresh to viewDocument with the fShowSection variable // ie. effectively removes statusMessage on next click $bDisplayLink = ($sStatusMessage) ? true : false; $sToRender .= renderFolderSection("folderData", _("Folder Data"), $bDisplayLink, $iFolderID); $sToRender .= renderFolderSection("folderRouting", _("Document Routing"), $bDisplayLink, $iFolderID); $sToRender .= renderFolderSection("documentTypes", _("Document Types"), $bDisplayLink, $iFolderID); $sToRender .= renderFolderSection("folderPermissions", _("Folder Permissions"), $bDisplayLink, $iFolderID); $sToRender .= "
"; $sToRender .= "		"; $sToRender .= "
"; $sToRender .= "
"; // ugly netscape hacks if (!$default->bNN4) { $sToRender .= ""; } return $sToRender; } function getStatusPage($iFolderID, $sStatusMessage) { global $default; $sToRender = "
"; $sToRender .= renderHeading(_("Modify Folder Properties")); $sToRender .= getFolderPath($iFolderID); $sToRender .= ""; // if we have a status message, then make the section links refresh to viewDocument with the fShowSection variable // ie. effectively removes statusMessage on next click $bDisplayLink = ($sStatusMessage) ? true : false; $sToRender .= renderFolderSection("folderData", _("Folder Data"), $bDisplayLink, $iFolderID); $sToRender .= renderFolderSection("folderRouting", _("Document Routing"), $bDisplayLink, $iFolderID); $sToRender .= renderFolderSection("documentTypes", _("Document Types"), $bDisplayLink, $iFolderID); $sToRender .= renderFolderSection("folderPermissions", _("Folder Permissions"), $bDisplayLink, $iFolderID); $sToRender .= "
"; $sToRender .= "
"; $sToRender .= getFolderData($iFolderID, "folderData", $sStatusMessage); return $sToRender; } ?>