document_transactions_table AS DT INNER JOIN $default->users_table AS U ON DT.user_id = U.id " . "INNER JOIN $default->transaction_types_table AS DTT ON DTT.id = DT.transaction_id " . "WHERE DT.document_id = $iDocumentID ORDER BY DT.datetime DESC"; $sql = $default->db; $sToRender = "\n"; $sToRender .= "\n"; $sql->query($sQuery); if ($sql->num_rows() == 0) { $sToRender .= "\n"; $sToRender .= "\t\n"; $sToRender .= "\n"; } else { $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $i = 0; while ($sql->next_record()) { if ($sql->f("transaction_name") == "Check Out") { $sVersion = generateControllerLink("downloadDocument", "fDocumentID=$iDocumentID&fVersion=" . $sql->f("version"), "" . $sql->f("version") . ""); } else { $sVersion = $sql->f("version"); } $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; } $sToRender .= "

Transaction History

No Transaction History data
Type	Users	Version	Comment	Datetime
" . $sql->f("transaction_name") . "	" . $sql->f("user_name") . "	$sVersion	" . displaySpace($sql->f("comment")) . "	" . $sql->f("datetime") . "

\n"; } return $sToRender; } function displaySpace($sHtml) { if ($sHtml == "") { return " "; } else { return $sHtml; } } function getPage($iDocumentID, $iFolderID, $sDocumentName) { global $default; $sToRender = renderHeading("Document History"); $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "\n"; $sToRender .= "

" . displayDocumentPath($iDocumentID) . "

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

" . getDocumentHistory($iDocumentID) . "

rootUrl/control.php?action=viewDocument&fDocumentID=$iDocumentID\">graphicsUrl/widgets/back.gif\" border=\"0\" />

\n"; return $sToRender; } ?>