rootUrl/control.php?action=browse"); } function getFolderData($iFolderID) { global $default; $sQuery = "SELECT F.id, F.name AS folder_name, F.description, F.document_type_id, DTL.name AS document_type_name, F.is_public " . "FROM $default->owl_folders_table AS F LEFT OUTER JOIN $default->owl_document_types_table AS DTL ON F.document_type_id = DTL.ID " . "WHERE F.id = $iFolderID"; $aDisplayColumns = array("folder_name", "description", "document_type_name", "is_public"); $aStoreColumns = array("name", "description" , "document_type_id", "is_public"); $aColumnNames = array("Name", "Description", "Document type", "Public"); $aDisplayColumnTypes = array(1,1,3,2); $aDatabaseColumnTypes = array(1,1,0,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(); } 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 getPage($iFolderID) { global $default; $sToRender = "

" . getFolderPath($iFolderID) . "

\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "

" . wrapInTable(getFolderData($iFolderID)) . "

" . wrapInTable(getFolderRouting($iFolderID)) . "

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

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

$sHtml

\n"; } ?>