PHP DBUtil::getOneResult方法代码示例

 function transform()
 {
     global $default;
     $iMimeTypeId = $this->oDocument->getMimeTypeId();
     $sMimeType = KTMime::getMimeTypeName($iMimeTypeId);
     $sFileName = $this->oDocument->getFileName();
     $aTestTypes = array('application/octet-stream', 'application/zip', 'application/x-zip');
     if (in_array($sMimeType, $aTestTypes)) {
         $sExtension = KTMime::stripAllButExtension($sFileName);
         $sTable = KTUtil::getTableName('mimetypes');
         $sQuery = "SELECT id, mimetypes FROM {$sTable} WHERE LOWER(filetypes) = ?";
         $aParams = array($sExtension);
         $aRow = DBUtil::getOneResult(array($sQuery, $aParams));
         if (PEAR::isError($aRow)) {
             $default->log->debug("ODI: error in query: " . print_r($aRow, true));
             return;
         }
         if (empty($aRow)) {
             $default->log->debug("ODI: query returned entry");
             return;
         }
         $id = $aRow['id'];
         $mimetype = $aRow['mimetypes'];
         $default->log->debug("ODI: query returned: " . print_r($aRow, true));
         if (in_array($mimetype, $aTestTypes)) {
             // Haven't changed, really not an OpenDocument file...
             return;
         }
         if ($id) {
             $this->oDocument->setMimeTypeId($id);
             $this->oDocument->update();
         }
     }
     parent::transform();
 }

 /**
  * Setup the plugin: add the processor, viewlet action and template location
  *
  */
 function setup()
 {
     $plugin_dir = dirname(__FILE__) . DIRECTORY_SEPARATOR;
     $dir = $plugin_dir . 'thumbnails.php';
     $this->registerProcessor('thumbnailGenerator', 'thumbnails.generator.processor', $dir);
     $this->registerAction('documentviewlet', 'ThumbnailViewlet', 'thumbnail.viewlets', $dir);
     require_once KT_LIB_DIR . '/templating/templating.inc.php';
     $oTemplating =& KTTemplating::getSingleton();
     $oTemplating->addLocation('thumbnails', $plugin_dir . 'templates', 'thumbnails.generator.processor.plugin');
     // check for existing config settings entry and only add if not already present
     $sql = 'SELECT id FROM `config_settings` WHERE group_name = "externalBinary" AND item = "convertPath"';
     $result = DBUtil::getOneResult($sql);
     if (PEAR::isError($result) || empty($result)) {
         DBUtil::runQuery('INSERT INTO `config_settings` (group_name, display_name, description, item, value, default_value, type, options, can_edit) ' . 'VALUES ("externalBinary", "convert", "The path to the ImageMagick \\"convert\\" binary", "convertPath", "default", "convert", ' . '"string", NULL, 1);');
     }
 }

 /**
  * Set all tables in the DB to auto increment, thereby removing the use of the zseq tables
  */
 function addAutoIncrementToTables()
 {
     static $doneTables = array();
     global $default;
     DBUtil::setupAdminDatabase();
     $db = $default->_admindb;
     // Get all tables in the database
     $query = "SHOW TABLES";
     $tableList = DBUtil::getResultArray($query, $db);
     // Loop through tables and add auto increment
     foreach ($tableList as $tableArr) {
         $key = key($tableArr);
         $tableName = $tableArr[$key];
         if (in_array($tableName, $doneTables)) {
             // already been set - skip
             continue;
         }
         $doneTables[] = $tableName;
         if (strpos($tableName, 'zseq_', 0) !== false) {
             // ignore zseq tables
             continue;
         }
         $query = "SELECT max(id) FROM {$tableName}";
         $aId = DBUtil::getOneResult($query);
         // If there's no result, then the table may be empty
         if (!PEAR::isError($aId)) {
             $id = (int) $aId['max(id)'] + 1;
             $query = "UPDATE {$tableName} SET id = {$id} WHERE id = 0";
             $res = DBUtil::runQuery($query, $db);
         } else {
             $default->log->error('Add auto_increment, fail on get max id: ' . $aId->getMessage());
         }
         // Update the table, set id to auto_increment
         $query = "ALTER TABLE {$tableName} CHANGE `id` `id` int (11) NOT NULL AUTO_INCREMENT";
         $res = DBUtil::runQuery($query, $db);
         if (PEAR::isError($res)) {
             $default->log->error('Add auto_increment, fail on change id to auto_increment: ' . $res->getMessage());
             // try again with mediumint
             $query = "ALTER TABLE {$tableName} CHANGE `id` `id` mediumint (9) NOT NULL AUTO_INCREMENT";
             $res = DBUtil::runQuery($query, $db);
         }
     }
 }

 function copy($oSrcFolder, $oDestFolder, $oUser, $sReason, $sDestFolderName = NULL, $copyAll = true)
 {
     $sDestFolderName = empty($sDestFolderName) ? $oSrcFolder->getName() : $sDestFolderName;
     if (KTFolderUtil::exists($oDestFolder, $sDestFolderName)) {
         return PEAR::raiseError(_kt("Folder with the same name already exists in the new parent folder"));
     }
     //
     // FIXME the failure cleanup code here needs some serious work.
     //
     $oPerm = KTPermission::getByName('ktcore.permissions.read');
     $oBaseFolderPerm = KTPermission::getByName('ktcore.permissions.addFolder');
     if (!KTPermissionUtil::userHasPermissionOnItem($oUser, $oBaseFolderPerm, $oDestFolder)) {
         return PEAR::raiseError(_kt('You are not allowed to create folders in the destination.'));
     }
     // Check if the source folder inherits its permissions
     // Get source PO id and its parent PO id
     $iSrcPoId = $oSrcFolder->getPermissionObjectID();
     $oSrcParent = Folder::get($oSrcFolder->getParentID());
     $iSrcParentPoId = $oSrcParent->getPermissionObjectID();
     // If the folder defines its own permissions then we copy the permission object
     // If the source folder inherits permissions we must change it to inherit from the new parent folder
     $bInheritPermissions = false;
     if ($iSrcPoId == $iSrcParentPoId) {
         $bInheritPermissions = true;
     }
     $aFolderIds = array();
     // of oFolder
     $aDocuments = array();
     // of oDocument
     $aFailedDocuments = array();
     // of String
     $aFailedFolders = array();
     // of String
     $aRemainingFolders = array($oSrcFolder->getId());
     DBUtil::startTransaction();
     while (!empty($aRemainingFolders) && $copyAll) {
         $iFolderId = array_pop($aRemainingFolders);
         $oFolder = Folder::get($iFolderId);
         if (PEAR::isError($oFolder) || $oFolder == false) {
             DBUtil::rollback();
             return PEAR::raiseError(sprintf(_kt('Failure resolving child folder with id = %d.'), $iFolderId));
         }
         // don't just stop ... plough on.
         if (KTPermissionUtil::userHasPermissionOnItem($oUser, $oPerm, $oFolder)) {
             $aFolderIds[] = $iFolderId;
         } else {
             $aFailedFolders[] = $oFolder->getName();
         }
         // child documents
         $aChildDocs = Document::getList(array('folder_id = ?', array($iFolderId)));
         foreach ($aChildDocs as $oDoc) {
             if (KTPermissionUtil::userHasPermissionOnItem($oUser, $oPerm, $oDoc)) {
                 $aDocuments[] = $oDoc;
             } else {
                 $aFailedDocuments[] = $oDoc->getName();
             }
         }
         // child folders.
         $aCFIds = Folder::getList(array('parent_id = ?', array($iFolderId)), array('ids' => true));
         $aRemainingFolders = kt_array_merge($aRemainingFolders, $aCFIds);
     }
     if (!empty($aFailedDocuments) || !empty($aFailedFolders)) {
         $sFD = '';
         $sFF = '';
         if (!empty($aFailedDocuments)) {
             $sFD = _kt('Documents: ') . implode(', ', $aFailedDocuments) . '. ';
         }
         if (!empty($aFailedFolders)) {
             $sFF = _kt('Folders: ') . implode(', ', $aFailedFolders) . '.';
         }
         return PEAR::raiseError(_kt('You do not have permission to copy these items. ') . $sFD . $sFF);
     }
     // first we walk the tree, creating in the new location as we go.
     // essentially this is an "ok" pass.
     $oStorage =& KTStorageManagerUtil::getSingleton();
     $aFolderMap = array();
     $sTable = 'folders';
     $sGetQuery = 'SELECT * FROM ' . $sTable . ' WHERE id = ? ';
     $aParams = array($oSrcFolder->getId());
     $aRow = DBUtil::getOneResult(array($sGetQuery, $aParams));
     unset($aRow['id']);
     $aRow['name'] = $sDestFolderName;
     $aRow['description'] = $sDestFolderName;
     $aRow['parent_id'] = $oDestFolder->getId();
     $aRow['parent_folder_ids'] = sprintf('%s,%s', $oDestFolder->getParentFolderIDs(), $oDestFolder->getId());
     $aRow['full_path'] = $oDestFolder->getFullPath() . '/' . $aRow['name'];
     $id = DBUtil::autoInsert($sTable, $aRow);
     if (PEAR::isError($id)) {
         DBUtil::rollback();
         return $id;
     }
     $sSrcFolderId = $oSrcFolder->getId();
     $aFolderMap[$sSrcFolderId]['parent_id'] = $id;
     $aFolderMap[$sSrcFolderId]['parent_folder_ids'] = $aRow['parent_folder_ids'];
     $aFolderMap[$sSrcFolderId]['full_path'] = $aRow['full_path'];
     $aFolderMap[$sSrcFolderId]['name'] = $aRow['name'];
     $oNewBaseFolder = Folder::get($id);
     $res = $oStorage->createFolder($oNewBaseFolder);
     if (PEAR::isError($res)) {
         // it doesn't exist, so rollback and raise..
//.........这里部分代码省略.........

 /**
  * postValidate method for trigger
  *
  * @return unknown
  */
 function postValidate()
 {
     global $default;
     $oDocument =& $this->aInfo['document'];
     $aMeta =& $this->aInfo['aOptions'];
     // get document id
     $iDocId = $oDocument->getID();
     // get all tags that are linked to the document
     $sQuery = 'SELECT tw.id FROM tag_words AS tw, document_tags AS dt, documents AS d ' . 'WHERE dt.tag_id = tw.id ' . 'AND dt.document_id = d.id ' . 'AND d.id = ?';
     $aParams = array($iDocId);
     $aTagId = DBUtil::getResultArray(array($sQuery, $aParams));
     if (PEAR::isError($aTagId)) {
         // XXX: log error
         return false;
     }
     // if there are any related tags proceed
     if ($aTagId) {
         // delete all entries from document_tags table for the document
         $sQuery = 'DELETE FROM document_tags ' . 'WHERE document_id = ?';
         $aParams = array($iDocId);
         $removed = DBUtil::runQuery(array($sQuery, $aParams));
         if (PEAR::isError($removed)) {
             // XXX: log error
             return false;
         }
     }
     // proceed to add the tags as per normal
     $sQuery = 'SELECT df.id AS id FROM document_fields AS df ' . 'WHERE df.name = \'Tag\'';
     $sTags = DBUtil::getOneResultKey(array($sQuery), 'id');
     if (PEAR::isError($sTags)) {
         // XXX: log error
         return false;
     }
     $tagString = '';
     if ($sTags) {
         // it is actually correct using $aMeta. It is different to the add trigger above...
         if (count($aMeta) > 0) {
             foreach ($aMeta as $aMetaData) {
                 $oProxy = $aMetaData[0];
                 if ($oProxy->iId == $sTags) {
                     $tagString = $aMetaData[1];
                     break;
                 }
             }
         }
         if ($tagString != '') {
             $words_table = KTUtil::getTableName('tag_words');
             $tagString = str_replace('  ', ' ', $tagString);
             $tags = explode(',', $tagString);
             $aTagIds = array();
             foreach ($tags as $sTag) {
                 $sTag = trim($sTag);
                 if (mb_detect_encoding($sTag) == 'ASCII') {
                     $sTag = strtolower($sTag);
                 }
                 $res = DBUtil::getOneResult(array("SELECT id FROM {$words_table} WHERE tag = ?", array($sTag)));
                 if (PEAR::isError($res)) {
                     return $res;
                 }
                 if (is_null($res)) {
                     $id =& DBUtil::autoInsert($words_table, array('tag' => $sTag));
                     $aTagIds[$sTag] = $id;
                 } else {
                     $aTagIds[$sTag] = $res['id'];
                 }
             }
             $doc_tags = KTUtil::getTableName('document_tags');
             foreach ($aTagIds as $sTag => $tagid) {
                 DBUtil::autoInsert($doc_tags, array('document_id' => $iDocId, 'tag_id' => $tagid), array('noid' => true));
             }
         }
     }
 }

 function _getIconPath($iMimeTypeId)
 {
     $sQuery = 'SELECT icon_path FROM mime_types WHERE id = ?';
     $res = DBUtil::getOneResult(array($sQuery, array($iMimeTypeId)));
     if ($res['icon_path'] !== null) {
         return $res['icon_path'];
     } else {
         return 'unspecified_type';
     }
 }

 function _mimeHelper($iMimeTypeId)
 {
     // FIXME lazy cache this.
     // FIXME extend mime_types to have something useful to say.
     $sQuery = 'SELECT * FROM mime_types WHERE id = ?';
     $res = DBUtil::getOneResult(array($sQuery, array($iMimeTypeId)));
     if (PEAR::isError($res)) {
         return _kt('unknown type');
     }
     if (!empty($res['friendly_name'])) {
         return _kt($res['friendly_name']);
     } else {
         return sprintf(_kt('%s File'), strtoupper($res['filetypes']));
     }
 }

 public function loadDocumentInfo()
 {
     global $default;
     $sql = "SELECT\n\t\t\t\t\td.folder_id, f.full_path, f.name, dcv.size as filesize, dcv.major_version,\n\t\t\t\t\tdcv.minor_version, dcv.filename, cou.name as checkoutuser, w.human_name as workflow, ws.human_name as workflowstate,\n\t\t\t\t\tmt.mimetypes as mimetype, md.mime_doc as mimedoc, d.checkedout, mbu.name as modifiedbyuser, d.modified,\n\t\t\t\t\tcbu.name as createdbyuser, ou.name as owneruser, d.immutable, d.status_id, d.created,dcv.storage_path, dtl.name as document_type,\n\t\t\t\t\tmt.icon_path as mime_icon_path, mt.friendly_name as mime_display, d.oem_no, dmv.name as title\n\t\t\t\tFROM\n\t\t\t\t\tdocuments d\n\t\t\t\t\tINNER JOIN document_metadata_version dmv ON d.metadata_version_id = dmv.id\n\t\t\t\t\tINNER JOIN document_content_version dcv ON dmv.content_version_id = dcv.id\n\t\t\t\t\tINNER JOIN mime_types mt ON dcv.mime_id=mt.id\n\t\t\t\t\tLEFT JOIN document_types_lookup dtl ON dtl.id=dmv.document_type_id\n\t\t\t\t\tLEFT JOIN folders f ON f.id=d.folder_id\n\t\t\t\t\tLEFT JOIN users cou ON d.checked_out_user_id=cou.id\n\t\t\t\t\tLEFT JOIN workflows w ON dmv.workflow_id=w.id\n\t\t\t\t\tLEFT JOIN workflow_states ws ON dmv.workflow_state_id = ws.id\n\t\t\t\t\tLEFT JOIN mime_documents md ON mt.mime_document_id = md.id\n\t\t\t\t\tLEFT JOIN users mbu ON d.modified_user_id=mbu.id\n\t\t\t\t\tLEFT JOIN users cbu ON d.creator_id=cbu.id\n\t\t\t\t\tLEFT JOIN users ou ON d.owner_id=ou.id\n\t\t\t\tWHERE\n\t\t\t\t\td.id={$this->id}";
     if ($this->inclStatus) {
         $sql .= " AND d.status_id = 1";
     }
     $result = DBUtil::getOneResult($sql);
     if (PEAR::isError($result) || empty($result)) {
         $this->live = false;
         if (PEAR::isError($result)) {
             throw new Exception('Database exception! There appears to be an error in the system: ' . $result->getMessage());
         }
         $default->log->error('QueryResultItem: $result is null');
         $msg = 'The database did not have a record matching the result from the document indexer. This may occur if there is an inconsistency between the document indexer and the repository. The indexer needs to be repaired.';
         $default->log->error('QueryResultItem: ' . $msg);
         // TODO: repair process where we scan documents in index, and delete those for which there is nothing in the repository
         throw new IndexerInconsistencyException(sprintf(_kt('%s'), $msg));
     }
     // document_id, relevance, text, title
     $this->documentType = $result['document_type'];
     $this->filename = $result['filename'];
     $this->filesize = KTUtil::filesizeToString($result['filesize']);
     $this->folderId = $result['folder_id'];
     $this->title = $result['title'];
     $this->createdBy = $result['createdbyuser'];
     $this->dateCreated = $result['created'];
     $this->modifiedBy = $result['modifiedbyuser'];
     $this->dateModified = $result['modified'];
     $this->checkedOutUser = $result['checkoutuser'];
     $this->dateCheckedout = $result['checkedout'];
     $this->owner = $result['owneruser'];
     $this->version = $result['major_version'] . '.' . $result['minor_version'];
     $this->immutable = $result['immutable'] + 0 ? _kt('Immutable') : '';
     $this->workflow = $result['workflow'];
     $this->workflowState = $result['workflowstate'];
     $this->oemDocumentNo = $result['oem_no'];
     if (empty($this->oemDocumentNo)) {
         $this->oemDocumentNo = 'n/a';
     }
     if (is_null($result['name'])) {
         $this->fullpath = '(orphaned)';
     } else {
         $this->fullpath = $result['full_path'];
     }
     $this->mimeType = $result['mimetype'];
     $this->mimeIconPath = $result['mime_icon_path'];
     if (empty($this->mimeIconPath)) {
         $this->mimeIconPath = 'unspecified_type';
     }
     $this->mimeDisplay = $result['mime_display'];
     $this->storagePath = $result['storage_path'];
     $this->status = Document::getStatusString($result['status_id']);
 }

 /**
  * Get the updated position of the column
  *
  * @param int $iId
  * @return int
  */
 function getNewPosition($iId)
 {
     // Get the new position
     $sql = "SELECT id, position FROM column_entries\n    \t       WHERE id = ?";
     $aParams = array($iId);
     $result = DBUtil::getOneResult(array($sql, $aParams));
     if (PEAR::isError($result) || empty($result)) {
         return false;
     }
     return $result['position'];
 }

/**
 * Check if the last user logging in from the same IP as the current user timed out in the last hour.
 *
 * @param unknown_type $userId
 * @return unknown
 */
function checkLastSessionUserID($userId)
{
    // Get the current users IP Address
    $sIp = '%' . $_SERVER['REMOTE_ADDR'];
    // Get the time for a day ago and an hour ago
    $dif = time() - 24 * 60 * 60;
    $sDayAgo = date('Y-m-d H:i:s', $dif);
    $dif2 = time() - 60 * 60;
    $sHourAgo = date('Y-m-d H:i:s', $dif2);
    // Get the session id for the last user to log in from the current IP address within the last day
    // Use the session id to find if that user logged out or timed out within the last hour.
    $sQuery = 'SELECT user_id, action_namespace FROM user_history
        WHERE datetime > ? AND
        session_id = (SELECT session_id FROM user_history WHERE comments LIKE ? AND datetime > ? ORDER BY id DESC LIMIT 1)
        ORDER BY id DESC LIMIT 1';
    $aParams = array($sHourAgo, $sIp, $sDayAgo);
    $res = DBUtil::getOneResult(array($sQuery, $aParams));
    if (PEAR::isError($res) || empty($res)) {
        return false;
    }
    // Check whether the user timed out and whether it was the current user or a different one
    if ($res['action_namespace'] == 'ktcore.user_history.timeout' && $res['user_id'] != $userId) {
        return true;
    }
    return false;
}

 function getMembershipReason($oUser, $oGroup)
 {
     $aGroupArray = GroupUtil::buildGroupArray();
     // short circuit
     if ($oGroup->hasMember($oUser)) {
         return sprintf(_kt('%s is a direct member.'), $oUser->getName());
     }
     $aSubgroups = (array) $aGroupArray[$oGroup->getId()];
     if (empty($aSubgroups)) {
         return null;
         // not a member, no subgroups.
     }
     $sTable = KTUtil::getTableName('users_groups');
     $sQuery = 'SELECT group_id FROM ' . $sTable . ' WHERE user_id = ? AND group_id IN (' . DBUtil::paramArray($aSubgroups) . ')';
     $aParams = array($oUser->getId());
     $aParams = kt_array_merge($aParams, $aSubgroups);
     $res = DBUtil::getOneResult(array($sQuery, $aParams));
     if (PEAR::isError($res)) {
         return $res;
     } else {
         if (is_null($res)) {
             return null;
             // not a member
         }
     }
     // else {
     $oSubgroup = Group::get($res['group_id']);
     if (PEAR::isError($oSubgroup)) {
         return $oSubgroup;
     }
     return sprintf(_kt('%s is a member of %s'), $oUser->getName(), $oSubgroup->getName());
     // could be error, but errors are caught.
     // }
 }

 function _upgradeTableInstalled()
 {
     $query = "SELECT COUNT(id) FROM upgrades";
     $res = DBUtil::getOneResult($query);
     if (PEAR::isError($res)) {
         return false;
     }
     return true;
 }

 /**
  * This function will return a folder by it's name (not ID)
  *
  * @author KnowledgeTree Team
  * @access public
  * @param KTAPI $ktapi
  * @param string $foldername
  * @param int $folderid
  * @return KTAPI_Folder
  */
 function _get_folder_by_name($ktapi, $foldername, $folderid)
 {
     $foldername = trim($foldername);
     if (empty($foldername)) {
         return new PEAR_Error('A valid folder name must be specified.');
     }
     $split = explode('/', $foldername);
     foreach ($split as $foldername) {
         if (empty($foldername)) {
             continue;
         }
         $foldername = KTUtil::replaceInvalidCharacters($foldername);
         $foldername = sanitizeForSQL($foldername);
         $sql = "SELECT id FROM folders WHERE\n\t\t\t\t\t(name='{$foldername}' and parent_id={$folderid}) OR\n\t\t\t\t\t(name='{$foldername}' and parent_id is null and {$folderid}=1)";
         $row = DBUtil::getOneResult($sql);
         if (is_null($row) || PEAR::isError($row)) {
             return new KTAPI_Error(KTAPI_ERROR_FOLDER_INVALID, $row);
         }
         $folderid = $row['id'];
     }
     return KTAPI_Folder::get($ktapi, $folderid);
 }

 function copy($oDocument, $oDestinationFolder, $sReason = null, $sDestinationDocName = null)
 {
     // 1. generate a new triad of content, metadata and core objects.
     // 2. update the storage path.
     //print '--------------------------------- BEFORE';
     //print_r($oDocument);
     // TODO: this is not optimal. we have get() functions that will do SELECT when we already have the data in arrays
     // get the core record to be copied
     $sDocumentTable = KTUtil::getTableName('documents');
     $sQuery = 'SELECT * FROM ' . $sDocumentTable . ' WHERE id = ?';
     $aParams = array($oDocument->getId());
     $aCoreRow = DBUtil::getOneResult(array($sQuery, $aParams));
     // we unset the id as a new one will be created on insert
     unset($aCoreRow['id']);
     // get a copy of the latest metadata version for the copied document
     $iOldMetadataId = $aCoreRow['metadata_version_id'];
     $sMetadataTable = KTUtil::getTableName('document_metadata_version');
     $sQuery = 'SELECT * FROM ' . $sMetadataTable . ' WHERE id = ?';
     $aParams = array($iOldMetadataId);
     $aMDRow = DBUtil::getOneResult(array($sQuery, $aParams));
     // we unset the id as a new one will be created on insert
     unset($aMDRow['id']);
     // set the name for the document, possibly using name collission
     if (empty($sDestinationDocName)) {
         $aMDRow['name'] = KTDocumentUtil::getUniqueDocumentName($oDestinationFolder, $aMDRow['name']);
     } else {
         $aMDRow['name'] = $sDestinationDocName;
     }
     // get a copy of the latest content version for the copied document
     $iOldContentId = $aMDRow['content_version_id'];
     $sContentTable = KTUtil::getTableName('document_content_version');
     $sQuery = 'SELECT * FROM ' . $sContentTable . ' WHERE id = ?';
     $aParams = array($iOldContentId);
     $aContentRow = DBUtil::getOneResult(array($sQuery, $aParams));
     // we unset the id as a new one will be created on insert
     unset($aContentRow['id']);
     // set the filename for the document, possibly using name collission
     if (empty($sDestinationDocName)) {
         $aContentRow['filename'] = KTDocumentUtil::getUniqueFilename($oDestinationFolder, $aContentRow['filename']);
     } else {
         $aContentRow['filename'] = $sDestinationDocName;
     }
     // create the new document record
     $aCoreRow['modified'] = date('Y-m-d H:i:s');
     $aCoreRow['folder_id'] = $oDestinationFolder->getId();
     // new location.
     $id = DBUtil::autoInsert($sDocumentTable, $aCoreRow);
     if (PEAR::isError($id)) {
         return $id;
     }
     $iNewDocumentId = $id;
     // create the new metadata record
     $aMDRow['document_id'] = $iNewDocumentId;
     $aMDRow['description'] = $aMDRow['name'];
     $id = DBUtil::autoInsert($sMetadataTable, $aMDRow);
     if (PEAR::isError($id)) {
         return $id;
     }
     $iNewMetadataId = $id;
     // the document metadata version is still pointing to the original
     $aCoreUpdate = array();
     $aCoreUpdate['metadata_version_id'] = $iNewMetadataId;
     $aCoreUpdate['metadata_version'] = 0;
     // create the new content version
     $aContentRow['document_id'] = $iNewDocumentId;
     $id = DBUtil::autoInsert($sContentTable, $aContentRow);
     if (PEAR::isError($id)) {
         return $id;
     }
     $iNewContentId = $id;
     // the metadata content version is still pointing to the original
     $aMetadataUpdate = array();
     $aMetadataUpdate['content_version_id'] = $iNewContentId;
     $aMetadataUpdate['metadata_version'] = 0;
     // apply the updates to the document and metadata records
     $res = DBUtil::autoUpdate($sDocumentTable, $aCoreUpdate, $iNewDocumentId);
     if (PEAR::isError($res)) {
         return $res;
     }
     $res = DBUtil::autoUpdate($sMetadataTable, $aMetadataUpdate, $iNewMetadataId);
     if (PEAR::isError($res)) {
         return $res;
     }
     // now, we have a semi-sane document object. get it.
     $oNewDocument = Document::get($iNewDocumentId);
     //print '--------------------------------- AFTER';
     //print_r($oDocument);
     //print '======';
     //print_r($oNewDocument);
     // copy the metadata from old to new.
     $res = KTDocumentUtil::copyMetadata($oNewDocument, $iOldMetadataId);
     if (PEAR::isError($res)) {
         return $res;
     }
     // Ensure the copied document is not checked out
     $oNewDocument->setIsCheckedOut(false);
     $oNewDocument->setCheckedOutUserID(-1);
     // finally, copy the actual file.
     $oStorage =& KTStorageManagerUtil::getSingleton();
     $res = $oStorage->copy($oDocument, $oNewDocument);
//.........这里部分代码省略.........

    public function is_latest_version($documentID, $contentID)
    {
        $sql = 'SELECT COUNT(document_content_version.id) AS newdocumentcount
		FROM document_content_version
		WHERE document_content_version.document_id ="' . $documentID . '" AND
		document_content_version.id > "' . $contentID . '"';
        $row = DBUtil::getOneResult($sql);
        $row = (int) $row['newdocumentcount'];
        if ($row > 0) {
            $response['is_latest'] = 'FALSE';
        } else {
            $response['is_latest'] = 'TRUE';
        }
        $response['status_code'] = 0;
        return $response;
    }