siteMap->getSectionName(substr($_SERVER["PHP_SELF"], strlen($default->rootUrl), strlen($_SERVER["PHP_SELF"])));
$sTDBGColour = $default->siteMap->getSectionColour($sSectionName, "td");
$sDocumentPath = displayFolderPathLink(Folder::getFolderPathAsArray($oDocument->getFolderID()), Folder::getFolderPathNamesAsArray($oDocument->getFolderID()), "$default->rootUrl/control.php?action=browse") . " > ";
$sDocumentPath .= "rootUrl/presentation/lookAndFeel/knowledgeTree/documentmanagement/viewBL.php?fDocumentID=" . $oDocument->getID() . "&fForInlineView=1\">" . $oDocument->getName() . "";
return "\n";
}
function renderDocumentData($oDocument) {
global $default;
$sQuery = "SELECT D.name, D.modified, DTT.datetime AS created, U.name AS initiator, CONCAT(CONCAT(D.major_version, '.'), D.minor_version) AS version, WDSL.name AS status, DTL.name AS document_type, D.is_checked_out, COALESCE(U2.name, '') AS c_user " .
"FROM $default->owl_documents_table AS D INNER JOIN $default->owl_web_documents_table AS WD ON WD.document_id = D.ID " .
"INNER JOIN $default->owl_web_documents_status_table AS WDSL ON WD.status_id = WDSL.id " .
"INNER JOIN $default->owl_users_table AS U ON U.id = D.creator_id " .
"INNER JOIN $default->owl_document_transactions_table AS DTT ON DTT.document_id = D.id " .
"INNER JOIN $default->owl_transaction_types_table AS TT ON DTT.transaction_id = TT.id " .
"INNER JOIN $default->owl_document_types_table AS DTL ON DTL.id = D.document_type_id " .
"LEFT OUTER JOIN $default->owl_users_table AS U2 ON U2.id = D.checked_out_user_id " .
"WHERE D.id = " . $oDocument->getID() . " " .
"AND TT.name LIKE 'Create'";
$aColumns = array("name", "modified", "created", "initiator", "document_type", "version", "status", "c_user");
$aColumnNames = array("Document title", "Last updated", "Created", "Document initiator", "Document Type", "Version", "Status", "Checked out by");
$aColumnTypes = array(1,1,1,1,1,1,1,1);
$oPatternListFromQuery = & new PatternListFromQuery($sQuery, $aColumns, $aColumnNames, $aColumnTypes);
$oPatternListFromQuery->setTableHeading("Document Data");
$oPatternListFromQuery->setTableWidth("90%");
return $oPatternListFromQuery->render();
}
function renderEditableLinkedDocuments($oDocument) {
global $default;
$sQuery = "SELECT D.id AS child_document_id, D.name, DL.id as document_link_id, DL.parent_document_id AS parent_document_id, 'Unlink' AS unlink " .
"FROM documents AS D INNER JOIN document_link AS DL ON D.id = DL.child_document_id " .
"WHERE DL.parent_document_id = " . $oDocument->getID();
$aColumns = array("name", "unlink");
$aColumnHeaders = array("Document");
$aColumnTypes = array(3,3);
$aDBColumnArray = array("parent_document_id", "child_document_id","document_link_id");
$aQueryStringVariableNames = array("fParentDocumentID","fChildDocumentID", "fDocumentLinkID");
$aLinkURLs = array(0=>"$default->rootUrl/control.php?action=viewDocument", 1=>"$default->rootUrl/control.php?action=removeDocumentLink");
$oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "100%", $aLinkURLs,$aDBColumnArray,$aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Linked documents");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
return $oPatternTableSqlQuery->render();
}
function renderNonEditableLinkedDocuments($oDocument) {
global $default;
$sQuery = "SELECT D.id, D.name, 'Delete' AS del " .
"FROM documents AS D INNER JOIN document_link AS DL ON D.id = DL.child_document_id " .
"WHERE DL.parent_document_id = " . $oDocument->getID();
$aColumns = array("name","del");
$aColumnNames = array("Document");
$aColumnTypes = array(1,3);
$oPatternListFromQuery = & new PatternListFromQuery($sQuery, $aColumns, $aColumnNames, $aColumnTypes);
$oPatternListFromQuery->setTableHeading("Linked documents");
$oPatternListFromQuery->setTableWidth("90%");
return $oPatternListFromQuery->render();
}
function renderGenericMetaData($oDocument) {
global $default;
$sQuery = "SELECT DF.name AS name, DFL.value as value " .
"FROM $default->owl_documents_table AS D INNER JOIN $default->owl_document_fields_table AS DFL ON D.id = DFL.document_id " .
"INNER JOIN $default->owl_fields_table AS DF ON DF.id = DFL.document_field_id " .
"WHERE document_id = " . $oDocument->getID() . " " .
"AND DF.is_generic = 1";
$aColumns = array("name", "value");
$aColumnHeaders = array("Tag", "Value");
$aColumnTypes = array(1,1);
$oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "90%");
$oPatternTableSqlQuery->setTableHeading("Generic Meta Data");
return $oPatternTableSqlQuery->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' " .
"AND DF.is_generic = 0";
$aColumns = array("name", "value");
$aColumnHeaders = array("Tag", "Value");
$aColumnTypes = array(1,1);
$oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "90%");
$oPatternTableSqlQuery->setTableHeading("Type Specific Meta Data");
$oPatternTableSqlQuery->setEmptyTableMessage("No Type Specific Meta Data");
return $oPatternTableSqlQuery->render();
}
function renderEditableDocumentRouting($oDocument) {
global $default;
$sQuery = "SELECT D.id as document_id, GFAL.id as id, R.name AS role_name, COALESCE(U.Name, 'Not assigned') AS name, GFAL.precedence AS precedence, COALESCE(FURL.active,0) AS active, COALESCE(FURL.done, 0) AS done, 'Edit' as edit " .
"FROM documents AS D INNER JOIN $default->owl_groups_folders_approval_table 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.group_folder_approval_id = GFAL.id AND FURL.document_id = D.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", "active", "done", "edit");
$aColumnHeaders = array("Role", "User", "Seq", "Active", "Done", "");
$aColumnTypes = array(1,1,1,1,1,3);
$aDBColumnArray = array("id","document_id","active","done");
$aQueryStringVariableNames = array("fFolderCollaborationID", "fDocumentID","fIsActive","fIsDone");
$aLinkURLs = array(5=>"$default->rootUrl/control.php?action=modifyDocumentRouting");
$oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "10%", $aLinkURLs,$aDBColumnArray,$aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Document Routing");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
return $oPatternTableSqlQuery->render();
}
function renderNonEditableDocumentRouting($oDocument) {
global $default;
$sQuery = "SELECT D.id as document_id, GFAL.id as id, R.name AS role_name, COALESCE(U.Name, 'Not assigned') AS name, GFAL.precedence AS precedence, COALESCE(FURL.active,0) AS active, COALESCE(FURL.done, 0) AS done " .
"FROM documents AS D INNER JOIN $default->owl_groups_folders_approval_table 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.group_folder_approval_id = GFAL.id AND FURL.document_id = D.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", "active", "done");
$aColumnHeaders = array("Role", "User", "Seq", "Active", "Done");
$aColumnTypes = array(1,1,1,1,1);
$oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "10%", "$default->rootUrl/control.php?action=modifyDocumentRouting",$aDBColumnArray,$aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Document Routing");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
return $oPatternTableSqlQuery->render();
}
function renderDocumentArchiveSettings($oDocument) {
global $default;
$sQuery = "SELECT d.id, atl.name, 'Edit' AS edit FROM $default->owl_document_archiving_table AS da " .
"INNER JOIN $default->owl_archiving_type_lookup_table AS atl ON da.archiving_type_id=atl.id " .
"INNER JOIN $default->owl_documents_table AS d ON da.document_id=d.id " .
"WHERE d.id = " . $oDocument->getID();
$aColumns = array("name", "edit");
$aColumnHeaders = array("Archiving Type");
$aColumnTypes = array(1,3);
$aDBColumnArray = array("id");
$aQueryStringVariableNames = array("fDocumentID");
$aLinkURLs = array(1=>"$default->rootUrl/control.php?action=modifyDocumentArchiveSettings");
$oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "90%", $aLinkURLs ,$aDBColumnArray,$aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Archiving Settings");
$oPatternTableSqlQuery->setEmptyTableMessage("No archiving settings");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
return $oPatternTableSqlQuery->render();
}
function displayActionButtons($oDocument, $bEdit) {
global $default;
if ($bEdit) {
// display the check in button if the document is checked out and you checked the document out
if ($oDocument->getIsCheckedOut() && ($oDocument->getCheckedOutUserID() == $_SESSION["userID"])) {
$sToRender = "![](\"$default-) graphicsUrl/widgets/checkin.gif\" border=\"0\" /> | \n";
// otherwise display the check out button
} else {
$sToRender = "graphicsUrl/widgets/checkout.gif\" border=\"0\" /> | \n";
}
}
$sToRender .= "graphicsUrl/widgets/email.gif\" border=\"0\" /> | \n";
if ($bEdit) {
$sToRender .= "graphicsUrl/widgets/delete.gif\" border=\"0\" /> | \n";
}
$sToRender .= "graphicsUrl/widgets/history.gif\" border=\"0\" /> | \n";
if ($bEdit) {
$sToRender .= "graphicsUrl/widgets/move.gif\" border=\"0\" /> | \n";
}
// display the unsubscribe button if the user is subscribed to the document
if (Subscription::exists($_SESSION["userID"], $oDocument->getID(), SubscriptionConstants::subscriptionType("DocumentSubscription"))) {
$sToRender .= "graphicsUrl/widgets/unsubscribe.gif\" border=\"0\" /> | \n";
// otherwise display the subscribe button
} else {
$sToRender .= "graphicsUrl/widgets/subscribe.gif\" border=\"0\" /> | \n";
}
$sToRender .= "graphicsUrl/widgets/download.gif\" border=\"0\" /> | \n";
$sToRender .= "graphicsUrl/widgets/discussion.gif\" border=\"0\" /> | \n";
// only display the archive button for available documents
if (!$oDocument->getIsCheckedOut() || !$oDocument->hasCollaboration() || (!DocumentCollaboration::documentCollaborationStarted($oDocument->getID()))) {
$sToRender .= "graphicsUrl/widgets/archive.gif\" border=\"0\" /> | \n";
}
return $sToRender;
}
function getEditPage($oDocument) {
global $default;
$iDocumentID = $oDocument->getID();
$sToRender = renderHeading("Document Detail") . renderDocumentPath($oDocument) . "\n
\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= displayActionButtons($oDocument, true);
$sToRender .= "
\n";
$sToRender .= "
\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "| \n";
$sToRender .= "\t\n";
$sToRender .= " | \n";
$sToRender .= "\n";
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . renderDocumentArchiveSettings($oDocument) . " | \n";
$sToRender .= "\t ";
// if there are no archiving settings then allow their addition
$oDocumentArchiving = DocumentArchiving::getFromDocumentID($iDocumentID);
if (!$oDocumentArchiving) {
$sToRender .= "\t\n";
$sToRender .= "\t\t| rootUrl/control.php?action=addDocumentArchiveSettings&fDocumentID=$iDocumentID\">graphicsUrl/widgets/add.gif\" border=\"0\"/> | \n";
$sToRender .= "\t ";
}
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . renderEditableDocumentRouting($oDocument) . " | \n";
$sToRender .= "\t ";
$sToRender .= "\t\n";
// collaboration cannot be started or approved/rejected unless the document is not checked out
if (!$oDocument->getIsCheckedOut() && $oDocument->hasCollaboration() && (!DocumentCollaboration::documentCollaborationStarted($oDocument->getID())) && ($_SESSION["userID"] == $oDocument->getCreatorID())) {
//if not all collaboration steps have been set, then you cannot start the collaboration process
//only the creator of the document can start the collaboration process
$sToRender .= "\t\t| graphicsUrl/widgets/begin.gif\" border=\"0\"/>";
$sToRender .= " | \n";
} else if (DocumentCollaboration::userIsPerformingCurrentCollaborationStep($oDocument->getID())) {
//if the current user is responsible for an active step in the collaboration process
$sToRender .= "\t\t | \n";
}
if (!DocumentCollaboration::documentIsPendingWebPublishing($iDocumentID) && !DocumentCollaboration::documentIsPublished($iDocumentID)) {
// only display for unpublished documents
// if there is collaboration
if ($oDocument->hasCollaboration()) {
// only display publish button if collaboration is complete and you're the last user in the collaboration process
if (DocumentCollaboration::documentCollaborationDone($oDocument->getID()) && ($_SESSION["userID"] == DocumentCollaboration::getLastCollaboratorID($iDocumentID))) {
$sToRender .= "graphicsUrl/widgets/publish.gif\" border=\"0\"/> | \n";
}
} else if ($_SESSION["userID"] == $oDocument->getCreatorID()) {
// no collaboration for this folder, so only the creator can request publication
// ??: or an administrator?
$sToRender .= "graphicsUrl/widgets/publish.gif\" border=\"0\"/> | \n";
}
}
$sToRender .= "\t ";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . renderEditableLinkedDocuments($oDocument) . " | \n";
$sToRender .= "\t ";
$sToRender .= "\t\n";
$sToRender .= "| rootUrl/control.php?action=addDocumentLink&fDocumentID=" . $oDocument->getID() ."\">graphicsUrl/widgets/add.gif\" border=\"0\"/> | \n";
$sToRender .= "\t ";
$sToRender .= "\t ";
$sToRender .= " | \n";
$sToRender .= "
\n";
$sToRender .= "
\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= displayActionButtons($oDocument, true);
$sToRender .= "
\n";
$sToRender .= "
\n";
return $sToRender;
}
function getViewPage($oDocument) {
global $default;
$iDocumentID = $oDocument->getID();
$sToRender = renderHeading("Document Detail") . renderDocumentPath($oDocument) . "\n
\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= displayActionButtons($oDocument, false);
$sToRender .= "
\n";
$sToRender .= "
\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . renderDocumentData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t\n";
$sToRender .= "\t| " . renderGenericMetaData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t \n";
$sToRender .= "\t\t| " . renderTypeSpecificMetaData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t \n";
$sToRender .= " | \n";
$sToRender .= "\n";
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . renderNonEditableDocumentRouting($oDocument) . " | \n";
$sToRender .= "\t ";
if (DocumentCollaboration::userIsPerformingCurrentCollaborationStep($oDocument->getID())) {
//if the current user is responsible for an active step in the collaboration process
$sToRender .= "\t\t | \n";
}
$sToRender .= "\t ";
$sToRender .= " | \n";
$sToRender .= "
\n";
$sToRender .= "
";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= displayActionButtons($oDocument, false);
$sToRender .= "
\n";
$sToRender .= "
\n";
return $sToRender;
}
/**
* Displays the document view page with additional input controls
* for checking out the document
*
* @param object the document to view and check out
*/
function getCheckOutEditPage($oDocument, $bCheckedOut = false) {
global $default;
$sToRender = renderHeading("Document Detail") . renderDocumentPath($oDocument) . "\n
\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . renderDocumentData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t\n";
$sToRender .= "\t| " . renderGenericMetaData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t \n";
$sToRender .= "\t\t| " . renderTypeSpecificMetaData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t \n";
$sToRender .= " | \n";
$sToRender .= "\n";
$sToRender .= "\t";
$sToRender .= " | \n";
$sToRender .= "
\n";
$sToRender .= "
";
return $sToRender;
}
/**
* Displays the document view page with additional input controls
* for checking in the document
*
* @param object the document to view and check out
*/
function getCheckInEditPage($oDocument) {
global $default;
$sToRender = renderHeading("Document Detail") . renderDocumentPath($oDocument) . "\n
\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . renderDocumentData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t\n";
$sToRender .= "\t| " . renderGenericMetaData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t \n";
$sToRender .= "\t\t| " . renderTypeSpecificMetaData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t \n";
$sToRender .= " | \n";
$sToRender .= "\n";
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . renderNonEditableDocumentRouting($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t \n";
$sToRender .= "\t\t| " . renderCheckInPage($oDocument) . " | \n";
$sToRender .= "\t ";
$sToRender .= "\t ";
$sToRender .= " | \n";
$sToRender .= "
\n";
$sToRender .= "
";
return $sToRender;
}
function getWebPublishPage($oDocument) {
global $default;
$oPatternListBox = & new PatternListBox($default->owl_web_sites_table, "web_site_name", "id", "fWebSiteID");
$sToRender = renderHeading("Document Detail") . renderDocumentPath($oDocument) . "\n
\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\n";
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . renderDocumentData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t\n";
$sToRender .= "\t| " . renderGenericMetaData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t \n";
$sToRender .= "\t\t| " . renderTypeSpecificMetaData($oDocument) . " | \n";
$sToRender .= "\t \n";
$sToRender .= "\t \n";
$sToRender .= " | \n";
$sToRender .= "\n";
$sToRender .= "\t";
$sToRender .= " | \n";
$sToRender .= "
\n";
$sToRender .= "
";
return $sToRender;
}
function wrapInTable($sHtml) {
return "\n\t\t\t\n";
}
?>