| \n";
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 " |
";
}
if ($sStatusMessage) {
$sToRender .= "
";
}
$sToRender .= getFolderData($iFolderID, "folderData");
$sToRender .= getFolderRouting($iFolderID, "folderRouting", $bCollaboration);
$sToRender .= getFolderDocTypes($iFolderID, "documentTypes");
$sToRender .= getFolderGroupAccess($iFolderID, "folderPermissions");
if (!$bNN4) {
$sToRender .= "
";
}
$sToRender .= getFolderData($iFolderID, "folderData", $sStatusMessage);
if (!$bNN4) {
$sToRender .= "
";
}
return $sToRender;
}
?>