, Jam Warehouse (Pty) Ltd, South Africa * @package lib.archiving */ class ArchiveRestorationRequest extends KTEntity { /** * The primary key */ var $iId; /** * The document to be restored */ var $iDocumentID; /** * The user requesting the restoration */ var $iRequestUserID; /** * The administrator to perform the restore */ var $iAdminUserID; /** * Timestamp */ var $dDateTime; /** * Constructs an archive restoration request instance * * @param integer the document id * @param integer the request user id * @param integer the admin user id */ function ArchiveRestorationRequest($iNewDocumentID, $iNewRequestUserID, $iNewAdminUserID, $dNewDateTime = "") { global $default; // primary key not set as this is not stored yet $this->iId = -1; $this->iDocumentID = $iNewDocumentID; $this->iRequestUserID = $iNewRequestUserID; $this->iAdminUserID = $iNewAdminUserID; $this->dDateTime = strlen($dNewDateTime) == 0 ? getCurrentDateTime() : $dNewDateTime; } /** * Gets the primary key */ function getID(){ return $this->iId; } /** * Gets the document id */ function getDocumentID(){ return $this->iDocumentID; } /** * Sets the document id * * @param integer the new document id */ function setDocumentID($iNewDocumentID){ $this->iDocumentID = $iNewDocumentID; } /** * Gets the request user */ function getRequestUserID(){ return $this->iRequestUserID; } /** * Sets the request user * * @param integer the new user id */ function setRequestUserID($iNewRequestUserID){ $this->iRequestUserID = $iNewRequestUserID; } /** * Gets the admin user */ function getAdminUserID(){ return $this->iAdminUserID; } /** * Sets the admin user * * @param integer the new user id */ function setAdminUserID($iNewAdminUserID){ $this->iAdminUserID = $iNewAdminUserID; } /** * Gets the datetime */ function getDateTime(){ return $this->dDateTime; } /** * Sets the datetime * * @param datetime the new date time */ function setDateTime($dNewDateTime){ $this->dDateTime = $dNewDateTime; } function _fieldValues () { return array( 'document_id' => $this->iDocumentID, 'request_user_id' => $this->iRequestUserID, 'admin_user_id' => $this->iAdminUserID, 'datetime' => $this->dDateTime, ); } function _table () { global $default; return $default->archive_restoration_table; } /** * Static function. Given a document primary key will create * a ArchiveRestorationRequest object and populate it with the corresponding * database values * * @return ArchiveRestorationRequest populated ArchiveRestorationRequest object on success, false otherwise */ function & getFromDocumentID($iDocumentID) { global $default; $sql = $default->db; $sql->query(array("SELECT * FROM $default->archive_restoration_table WHERE document_id = ?", $iDocumentID));/*ok*/ if ($sql->next_record()) { $oArchiveRestorationRequest = & new ArchiveRestorationRequest($sql->f("document_id"), $sql->f("request_user_id"), $sql->f("admin_user_id"), $sql->f("datetime")); $oArchiveRestorationRequest->iId = $sql->f("id"); return $oArchiveRestorationRequest; } return false; } /** * Static function. Given a news item primary key will create * a ArchiveRestorationRequest object and populate it with the corresponding * database values * * @return ArchiveRestorationRequest populated ArchiveRestorationRequest object on success, false otherwise */ function & get($iArchiveRestorationRequestID) { global $default; $sql = $default->db; $sql->query(array("SELECT * FROM $default->archive_restoration_table WHERE id = ?", $iArchiveRestorationRequestID));/*ok*/ if ($sql->next_record()) { $oArchiveRestorationRequest = & new ArchiveRestorationRequest($sql->f("document_id"), $sql->f("request_user_id"), $sql->f("admin_user_id"), $sql->f("datetime")); $oArchiveRestorationRequest->iId = $iArchiveRestorationRequestID; return $oArchiveRestorationRequest; } return false; } /** * Static function * Get a list of ArchiveRestorationRequest objects * * @param String Where clause (optional) * @return Array array of ArchiveRestorationRequest objects, false otherwise */ function getList($sWhereClause = null) { return KTEntityUtil::getList(ArchiveRestorationRequest::_table(), 'ArchiveRestorationRequest', $sWhereClause); } }