fileSystemRoot/lib/documentmanagement/Document.inc");
/**
* $Id$
*
* Presentation information used for folder editing. Used by editBL.php
*
* Licensed under the GNU GPL. For full terms see the file DOCS/COPYING.
*
* @author Rob Cherry, Jam Warehouse (Pty) Ltd, South Africa
* @date 2 February 2003
* @package presentation.lookAndFeel.knowledgeTree.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");
$sQuery = "SELECT F.id, F.name, F.description, F.is_public " .
"FROM $default->owl_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 ($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
$sQuery = "SELECT GFAL.id as id, GFAL.folder_id AS folder_id, G.name 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->owl_groups_folders_approval_table AS GFAL INNER JOIN roles AS R ON GFAL.role_id = R.id " .
"INNER JOIN $default->owl_groups_table AS G ON G.id = GFAL.group_id " .
"LEFT OUTER JOIN $default->owl_users_table AS U ON U.id = GFAL.user_id " .
"WHERE GFAL.folder_id = $iFolderID " .
"ORDER BY GFAL.precedence, role_name ASC";
$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 .= "";
return renderSectionDiv($sDivName, $sToRender);
}
function getFolderDocTypes($iFolderID, $sDivName) {
global $default;
$sQuery = "SELECT FDL.id, FDL.folder_id, FDL.document_type_id, DTL.name, 'Remove' AS del " .
"FROM $default->owl_folder_doctypes_table AS FDL INNER JOIN $default->owl_document_types_table AS DTL ON FDL.document_type_id = DTL.id " .
"WHERE FDL.folder_id = $iFolderID " .
"ORDER BY DTL.name ASC";
$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 .= "";
return renderSectionDiv($sDivName, $sToRender);
}
function getFolderGroupAccess($iFolderID, $sDivName) {
global $default;
$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->owl_groups_folders_table AS GFL " .
"INNER JOIN $default->owl_groups_table AS GL ON GFL.group_id = GL.id " .
"WHERE GFL.folder_id = $iFolderID";
$aColumns = array("group_name", "can_read", "can_write", "edit", "del");
$aColumnHeaders = array("Group", "Read", "Write", "", "");
$aColumnTypes = array(1,1,1,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($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "610", $aLinkURLs, $aDBColumnArray,$aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Folder Permissions");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
$sToRender .= "";
return renderSectionDiv($sDivName, $sToRender);
}
function renderSectionDiv($sDivName, $sHtml) {
global $default;
$bNN4 = (($default->browser == "moz") && ($default->version <= "4.79"));
if ($bNN4) {
return "" . $sHtml . "
";
} else {
return "$sHtml
";
}
}
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 .= getFolderData($iFolderID, "folderData");
$sToRender .= getFolderRouting($iFolderID, "folderRouting", $bCollaboration);
$sToRender .= getFolderDocTypes($iFolderID, "documentTypes");
$sToRender .= getFolderGroupAccess($iFolderID, "folderPermissions");
if (!$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);
if (!$bNN4) {
$sToRender .= "
";
}
return $sToRender;
}
?>