getFolderID()) . " > " . $oDocument->getName(); return "

$sDocumentPath

\n"; } function renderDocumentGenericMetaData($oDocument) { echo "\n"; } function renderGenericDocumentMetaData($oDocument) { $sQuery = "SELECT D.name AS name, DT.datetime AS created_date, D.modified as last_modified, U.name as initiator, DFL.value as authors, CONCAT(CONCAT(D.major_version, \".\"), D.minor_version) AS version, WDSL.name AS status, DFL2.value AS category " . "FROM documents AS D INNER JOIN document_fields_link AS DFL on D.id = DFL.document_id " . "INNER JOIN users AS U on D.creator_id = U.id " . "INNER JOIN document_transactions AS DT on DT.document_id = D.id " . "INNER JOIN document_fields AS DF ON DF.id = DFL.document_field_id " . "INNER JOIN document_transaction_types_lookup AS DTTL ON DTTL.id = DT.transaction_id " . "INNER JOIN document_fields_link AS DFL2 ON DFL2.document_id = D.id " . "INNER JOIN document_fields AS DF2 ON DF2.id = DFL2.document_field_id " . "INNER JOIN web_documents AS WD ON WD.document_id = D.ID " . "INNER JOIN web_documents_status_lookup AS WDSL ON WD.status_id = WDSL.id " . "WHERE D.id = " . $oDocument->getID() . " " . "AND DF.name LIKE 'Author' " . "AND DF2.name LIKE 'Category' " . "AND DTTL.name LIKE 'Create'"; $aColumns = array("name", "created_date", "last_modified", "initiator", "authors", "version", "status", "category"); $aColumnNames = array("Document title", "Date created", "Last updated", "Document initiator", "Author(s)", "Version", "Status", "Category"); $aColumnTypes = array(1,1,1,1,1,1,1,1); $oPatternListFromQuery = & new PatternListFromQuery($sQuery, $aColumns, $aColumnNames, $aColumnTypes); $oPatternListFromQuery->setTableHeading("Generic Meta Data"); //$oPatternListFromQuery->setRenderIndividualTableForEachResult(true); return $oPatternListFromQuery->render(); } function renderTypeSpecificMetaData($oDocument) { $sQuery = "SELECT DF.name AS name, DFL.value AS value " . "FROM documents AS D INNER JOIN document_fields_link AS DFL ON D.id = DFL.document_id " . "INNER JOIN document_fields AS DF ON DF.ID = DFL.document_field_id " . "WHERE D.id = " . $oDocument->getID() . " " . "AND DF.name NOT LIKE 'Author' " . "AND DF.name NOT LIKE 'Category'"; $aColumns = array("name", "value"); $aColumnHeaders = array("Tag", "Value"); $oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnHeaders, 300); $oPatternTableSqlQuery->setTableHeading("Type Specific Meta Data"); return $oPatternTableSqlQuery->render(); } function renderDocumentRouting($oDocument) { $sQuery = "SELECT R.name AS role_name, COALESCE(U.Name, 'Not assigned') AS name, GFAL.precedence AS precedence " . "FROM documents AS D INNER JOIN groups_folders_approval_link AS GFAL ON D.folder_id = GFAL.folder_id " . "INNER JOIN roles AS R ON GFAL.role_id = R.id " . "LEFT OUTER JOIN folders_users_roles_link AS FURL ON FURL.folder_id = D.folder_id " . "LEFT OUTER JOIN users AS U ON FURL.user_id = U.id " . "WHERE D.id = " . $oDocument->getID() . " " . "ORDER BY GFAL.precedence, role_name ASC"; $aColumns = array("role_name", "name", "precedence"); $aColumnHeaders = array("Role", "Player", "Sequence"); $oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnHeaders, 300, true); $oPatternTableSqlQuery->setTableHeading("Document Routing"); return $oPatternTableSqlQuery->render(); } function renderPage($oDocument) { $sToRender = renderDocumentPath($oDocument) . "\n
\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "

\n"; $sToRender .= "\t\n"; $sToRender .= "\t\n"; $sToRender .= "\t\t\n"; $sToRender .= "\t\n"; $sToRender .= "\t\n"; $sToRender .= "\t\t\n"; $sToRender .= "\t\n"; $sToRender .= "\t " . wrapInTable(renderGenericDocumentMetaData($oDocument)) . " " . wrapInTable(renderTypeSpecificMetaData($oDocument)) . " \n"; $sToRender .= "

\n"; $sToRender .= "\t\n"; $sToRender .= "\t\n"; $sToRender .= "\t\t\n"; $sToRender .= "\t"; $sToRender .= "\t " . wrapInTable(renderDocumentRouting($oDocument)) . " "; $sToRender .= "

"; echo $sToRender; /*$sToRender = "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= ""; $sToRender .= "

" . wrapInTable(renderDocumentPath($oDocument)) . "
" . wrapInTable(renderGenericDocumentMetaData($oDocument)) . "	" . wrapInTable(renderDocumentRouting($oDocument)) . "
" . wrapInTable(renderTypeSpecificMetaData($oDocument)) . "

"; echo $sToRender;*/ } function wrapInTable($sHtml) { return "

$sHtml

"; } ?>