siteMap->getSectionName(substr($_SERVER["PHP_SELF"], strlen($default->rootUrl), strlen($_SERVER["PHP_SELF"])));
$sTDBGColour = $default->siteMap->getSectionColour($sSectionName, "td");
if ($bDisplayActions) {
$sDocumentPath = displayFolderPathLink(Folder::getFolderPathAsArray($oDocument->getFolderID()), Folder::getFolderPathNamesAsArray($oDocument->getFolderID()), "$default->rootUrl/control.php?action=browse") . " > ";
$sDocumentPath .= "" . $oDocument->getName() . "";
} else {
$sDocumentPath = $oDocument->getDisplayPath();
}
return "| $sDocumentPath | " . ($bDisplayActions ? "Actions | " : "") . "
\n";
}
function renderDocumentData($oDocument, $bEditable, $sStatusMessage = "") {
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("400");
if ($sStatusMessage) {
$sToRender .= "$sStatusMessage";
}
$sToRender .= "\t\n";
return $sToRender;
}
function renderGenericMetaData($oDocument, $bEditable) {
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, "500");
$oPatternTableSqlQuery->setTableHeading("Generic Meta Data");
$sToRender .= "\t\n";
return $sToRender;
}
function renderTypeSpecificMetaData($oDocument, $bEditable) {
global $default;
$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, "500");
$oPatternTableSqlQuery->setTableHeading("Type Specific Meta Data");
$oPatternTableSqlQuery->setEmptyTableMessage("No Type Specific Meta Data");
$sToRender .= "\t\n";
return $sToRender;
}
function renderEditableDocumentArchiveSettings($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, "500", $aLinkURLs ,$aDBColumnArray,$aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Archiving Settings");
$oPatternTableSqlQuery->setEmptyTableMessage("No archiving settings");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
return $oPatternTableSqlQuery->render();
}
function renderNonEditableDocumentArchiveSettings($oDocument) {
global $default;
$sQuery = "SELECT d.id, atl.name 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");
$aColumnHeaders = array("Archiving Type");
$aColumnTypes = array(1);
$oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "500", $aLinkURLs ,$aDBColumnArray,$aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Archiving Settings");
$oPatternTableSqlQuery->setEmptyTableMessage("No archiving settings");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
return $oPatternTableSqlQuery->render();
}
function renderDocumentArchiveSettings($oDocument, $bEditable) {
global $default;
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . ($bEditable ? renderEditableDocumentArchiveSettings($oDocument) : renderNonEditableDocumentArchiveSettings($oDocument)) . " | \n";
$sToRender .= "\t
";
if ($bEditable) {
$sToRender .= "\t\n";
// if there are no archiving settings then allow their addition
$oDocumentArchiving = DocumentArchiving::getFromDocumentID($oDocument->getID());
$sToRender .= "\t\t" . ($oDocumentArchiving ? "" : generateControllerLink("addDocumentArchiveSettings", "fDocumentID=" . $oDocument->getID(), "![](\"$default-) graphicsUrl/widgets/add.gif\" border=\"0\"/>")) . " | \n";
$sToRender .= "\t
";
}
$sToRender .= "\t
\n";
return $sToRender;
}
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, "500", $aLinkURLs,$aDBColumnArray,$aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Document Routing");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . $oPatternTableSqlQuery->render() . " | \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($oDocument->getID())) {
// 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($oDocument->getID()))) {
$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";
return $sToRender;
}
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, "500", "$default->rootUrl/control.php?action=modifyDocumentRouting",$aDBColumnArray,$aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Document Routing");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . $oPatternTableSqlQuery->render() . " | \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
\n";
return $sToRender;
}
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", "child_document_id");
$aQueryStringVariableNames = array("fParentDocumentID","fChildDocumentID", "fDocumentLinkID", "fDocumentID");
$aLinkURLs = array(0=>"$default->rootUrl/control.php?action=viewDocument", 1=>"$default->rootUrl/control.php?action=removeDocumentLink");
$oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "500", $aLinkURLs, $aDBColumnArray, $aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Linked documents");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
$sToRender .= "\t\n";
return $sToRender;
}
function renderNonEditableLinkedDocuments($oDocument) {
global $default;
$sQuery = "SELECT D.id, D.name " .
"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");
$aColumnHeaders = array("Document");
$aColumnTypes = array(3);
$aDBColumnArray = array("id");
$aQueryStringVariableNames = array("fDocumentID");
$aLinkURLs = array(0=>"$default->rootUrl/control.php?action=viewDocument");
$oPatternTableSqlQuery = & new PatternTableSqlQuery($sQuery, $aColumns, $aColumnTypes, $aColumnHeaders, "500", $aLinkURLs, $aDBColumnArray, $aQueryStringVariableNames);
$oPatternTableSqlQuery->setTableHeading("Linked documents");
$oPatternTableSqlQuery->setDisplayColumnHeadings(true);
$sToRender .= "\t\n";
$sToRender .= "\t\n";
$sToRender .= "\t\t| " . $oPatternTableSqlQuery->render() . " | \n";
$sToRender .= "\t
";
$sToRender .= "\t
\n";
return $sToRender;
}
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 .= "| graphicsUrl/widgets/docactions/checkin.gif\" border=\"0\" /> |
\n";
// otherwise display the check out button
} else {
$sToRender .= "| graphicsUrl/widgets/docactions/checkout.gif\" border=\"0\" /> |
\n";
}
}
$sToRender .= "| graphicsUrl/widgets/docactions/email.gif\" border=\"0\" /> |
\n";
if ($bEdit) {
$sToRender .= "| graphicsUrl/widgets/docactions/delete.gif\" border=\"0\" /> |
\n";
}
$sToRender .= "| graphicsUrl/widgets/docactions/history.gif\" border=\"0\" /> |
\n";
if ($bEdit) {
$sToRender .= "| graphicsUrl/widgets/docactions/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/docactions/unsubscribe.gif\" border=\"0\" /> |
\n";
// otherwise display the subscribe button
} else {
$sToRender .= "| graphicsUrl/widgets/docactions/subscribe.gif\" border=\"0\" /> |
\n";
}
$sToRender .= "| graphicsUrl/widgets/docactions/download.gif\" border=\"0\" /> |
\n";
$sToRender .= "| graphicsUrl/widgets/docactions/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/docactions/archive.gif\" border=\"0\" /> |
\n";
}
$sToRender .= "graphicsUrl/widgets/docactions/dependentdoc.gif\" border=\"0\" /> | \n";
return $sToRender;
}
function renderSectionDiv($sDivName, $sHtml) {
global $default;
$bNN4 = (($default->browser == "moz") && ($default->version <= "4.79"));
if ($bNN4) {
return "$sHtml
";
} else {
return "$sHtml
";
}
}
function renderDocumentSection($sSectionName, $sHeadingText, $bDisplayLink, $iDocumentID) {
if ($bDisplayLink) {
$sLink = generateControllerLink("viewDocument", "fDocumentID=$iDocumentID&fShowSection=$sSectionName", $sHeadingText);
} else {
$sLink = "$sHeadingText";
}
return "| $sLink |
\n";
}
function getPage($oDocument, $bEdit, $sStatusMessage = "") {
global $default;
$sToRender = "";
$sToRender .= renderHeading("Document Detail");
$sToRender .= renderDocumentPath($oDocument, true) . "\n\n";
$sToRender .= "
";
$sToRender .= "";
$sToRender .= "";
// if we have a status message, then make the section links refresh to viewDocument with the fShowSection variable
// ie. effectively removes statusMessage on next click
$bDisplayLink = ($sStatusMessage) ? true : false;
$sToRender .= renderDocumentSection("documentData", "Document Data", $bDisplayLink, $oDocument->getID());
$sToRender .= renderDocumentSection("genericMetaData", "Generic Meta Data", $bDisplayLink, $oDocument->getID());
$sToRender .= renderDocumentSection("typeSpecificMetaData", "Type Specific Meta Data", $bDisplayLink, $oDocument->getID());
$sToRender .= renderDocumentSection("archiveSettings", "Archive Settings", $bDisplayLink, $oDocument->getID());
$sToRender .= renderDocumentSection("documentRouting", "Document Routing", $bDisplayLink, $oDocument->getID());
$sToRender .= renderDocumentSection("linkedDocuments", "Linked Documents", $bDisplayLink, $oDocument->getID());
$sToRender .= " ";
$sToRender .= " | ";
$sToRender .= "\n";
$sToRender .= displayActionButtons($oDocument, $bEdit);
$sToRender .= " \n";
$sToRender .= " |
";
$sToRender .= "
";
$sToRender .= "
";
}
$sToRender .= renderSectionDiv("documentData", renderDocumentData($oDocument, $bEdit, $sStatusMessage));
$sToRender .= renderSectionDiv("genericMetaData", renderGenericMetaData($oDocument, $bEdit));
$sToRender .= renderSectionDiv("typeSpecificMetaData", renderTypeSpecificMetaData($oDocument, $bEdit));
$sToRender .= renderSectionDiv("archiveSettings", renderDocumentArchiveSettings($oDocument, $bEdit));
if ($bEdit) {
$sToRender .= renderSectionDiv("documentRouting", renderEditableDocumentRouting($oDocument));
$sToRender .= renderSectionDiv("linkedDocuments", renderEditableLinkedDocuments($oDocument));
} else {
$sToRender .= renderSectionDiv("documentRouting", renderNonEditableDocumentRouting($oDocument));
$sToRender .= renderSectionDiv("linkedDocuments", renderNonEditableLinkedDocuments($oDocument, $bEdit));
}
if (!$bNN4) {
$sToRender .= "
";
}
return $sToRender;
}
function getStatusPage($oDocument, $sStatusMessage) {
global $default;
$sToRender .= renderHeading("Document Detail");
$sToRender .= renderDocumentPath($oDocument, false) . "\n\n";
$sToRender .= "";
// if we have a status message, then make the section links refresh to viewDocument with the fShowSection variable
// ie. effectively removes statusMessage on next click
$bDisplayLink = ($sStatusMessage) ? true : false;
$sToRender .= renderDocumentSection("documentData", "Document Data", $bDisplayLink, $oDocument->getID());
$sToRender .= renderDocumentSection("genericMetaData", "Generic Meta Data", $bDisplayLink, $oDocument->getID());
$sToRender .= renderDocumentSection("typeSpecificMetaData", "Type Specific Meta Data", $bDisplayLink, $oDocument->getID());
$sToRender .= renderDocumentSection("archiveSettings", "Archive Settings", $bDisplayLink, $oDocument->getID());
$sToRender .= renderDocumentSection("documentRouting", "Document Routing", $bDisplayLink, $oDocument->getID());
$sToRender .= renderDocumentSection("linkedDocuments", "Linked Documents", $bDisplayLink, $oDocument->getID());
$sToRender .= "
";
$sToRender .= renderDocumentData($oDocument, false, $sStatusMessage);
return $sToRender;
}
function getWebPublishPage($oDocument) {
global $default;
$oPatternListBox = & new PatternListBox($default->owl_web_sites_table, "web_site_name", "id", "fWebSiteID");
$sToRender .= renderHeading("Document Detail");
$sToRender .= renderDocumentPath($oDocument, false) . "\n\n";
$sToRender .= "\n";
$sToRender .= "\n\n\n\n";
$sToRender .= renderDocumentData($oDocument, $bEdit);
return $sToRender;
}
function wrapInTable($sHtml) {
return "\n\t\t\t\n";
}
?>