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 = ? ORDER BY DT.datetime DESC", $iDocumentID); $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\">

\n"; return $sToRender; } ?>