siteMap->getSectionName(substr($_SERVER["PHP_SELF"], strlen($default->rootUrl), strlen($_SERVER["PHP_SELF"]))); $sColor = $default->siteMap->getSectionColour($sSectionName, "th"); $sToRender = "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "

Modify Folder

\n"; return $sToRender; } 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) { 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"; $sql = $default->db; $sql->query($sQuery); $sToRender = "\n"; if ($sql->next_record()) { $sToRender .= "\n"; $sToRender .= "\n"; if (Folder::folderIsUnitRootFolder($iFolderID)) { $sToRender .= "\n"; } else { $sToRender .= "\n"; } $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; } $sToRender .= "

Name	" . $sql->f("name") . "	f("name") . "\" size=\"30\">
Description	f("description") . "\" size=\"30\">
Public	f("is_public") ? "CHECKED" : "") ." >

\n"; /*$aDisplayColumns = array("folder_name", "description", "is_public"); $aStoreColumns = array("name", "description" , "is_public"); $aColumnNames = array("Name", "Description", "Public"); $aDisplayColumnTypes = array(1,1,2); $aDatabaseColumnTypes = array(1,1,2); $aDropDownListTableNames = array(2 => "$default->owl_document_types_table"); $oPatternEditableListFromQuery = & new PatternEditableListFromQuery($sQuery, $default->owl_folders_table, $aDisplayColumns, $aStoreColumns, $aColumnNames, $aDisplayColumnTypes, $aDatabaseColumnTypes); $oPatternEditableListFromQuery->setUniqueName("folderEdit"); $oPatternEditableListFromQuery->setDropDownListTableNames($aDropDownListTableNames); $oPatternEditableListFromQuery->setColumnsRequired(array(1,0,1,0)); return $oPatternEditableListFromQuery->render();*/ return $sToRender; } function getFolderDocTypes($iFolderID) { 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, "90%", $aLinkURLs, $aDBColumnArray,$aQueryStringVariableNames); $oPatternTableSqlQuery->setTableHeading("Document Types"); $oPatternTableSqlQuery->setDisplayColumnHeadings(true); return $oPatternTableSqlQuery->render(); } function getFolderRouting($iFolderID) { global $default; $sQuery = "SELECT GFAL.id as id, GFAL.folder_id AS folder_id, G.name AS group_name, R.name AS role_name, GFAL.precedence AS precedence, 'Edit' as edit, 'Delete' as del " . "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 " . "WHERE GFAL.folder_id = $iFolderID " . "ORDER BY GFAL.precedence, role_name ASC"; $aColumns = array("group_name", "role_name", "precedence", "edit", "del"); $aColumnHeaders = array("Group", "Role", "Seq", "", ""); $aColumnTypes = array(1,1,1,3,3); $aDBColumnArray = array("id","folder_id"); $aQueryStringVariableNames = array("fFolderCollaborationID", "fFolderID"); $aLinkURLs = array(3=>"$default->rootUrl/control.php?action=modifyFolderCollaboration",4=>"$default->rootUrl/control.php?action=deleteFolderCollaboration"); $oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "90%", $aLinkURLs, $aDBColumnArray,$aQueryStringVariableNames); $oPatternTableSqlQuery->setTableHeading("Document Routing"); $oPatternTableSqlQuery->setDisplayColumnHeadings(true); return $oPatternTableSqlQuery->render(); } function getFolderGroupAccess($iFolderID) { 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, "90%", $aLinkURLs, $aDBColumnArray,$aQueryStringVariableNames); $oPatternTableSqlQuery->setTableHeading("Folder Permissions"); $oPatternTableSqlQuery->setDisplayColumnHeadings(true); return $oPatternTableSqlQuery->render(); } function getPage($iFolderID) { global $default; $sToRender = renderHeading(); $sToRender .= getFolderPath($iFolderID); $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "

\n"; $sToRender .= getLeftSide($iFolderID); $sToRender .= "

\n"; $sToRender .= getRightSide($iFolderID); $sToRender .= "

\n"; return $sToRender; } function getLeftSide($iFolderID) { global $default; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "

\n"; $sToRender .= getFolderData($iFolderID); $sToRender .= "

\n"; $sToRender .= "graphicsUrl/widgets/update.gif\" onClick=\"setActionAndSubmit('" . $_SERVER["PHP_SELF"] . "?fFolderID=$iFolderID&fForUpdate=1')\" border=\"0\" />\n"; $sToRender .= "

\n"; $sToRender .= getFolderRouting($iFolderID) . "\n"; $sToRender .= "

\n"; $sToRender .= "rootUrl/control.php?action=addFolderCollaboration&fFolderID=$iFolderID\">graphicsUrl/widgets/add.gif\" border=\"0\" />\n"; $sToRender .= "

\n"; return $sToRender; } function getRightSide($iFolderID) { global $default; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "

\n"; $sToRender .= getFolderDocTypes($iFolderID); $sToRender .= "

\n"; $sToRender .= "rootUrl/control.php?action=addFolderDocType&fFolderID=$iFolderID\">graphicsUrl/widgets/add.gif\" border=\"0\" />\n"; $sToRender .= "

\n"; $sToRender .= getFolderGroupAccess($iFolderID); $sToRender .= "

\n"; $sToRender .= "rootUrl/control.php?action=addGroupFolderLink&fFolderID=$iFolderID\">graphicsUrl/widgets/add.gif\" border=\"0\" />\n"; $sToRender .= "

\n"; return $sToRender; } function wrapInTable($sHtml) { return "\n\t\t\t

$sHtml

\n"; } ?>