PHP xPDOObject::_loadCollectionInstance方法代码示例

 /**
  * Load a collection of xPDOObject instances.
  *
  * @static
  * @param xPDO &$xpdo A valid xPDO instance.
  * @param string $className Name of the class.
  * @param mixed $criteria A valid primary key, criteria array, or xPDOCriteria instance.
  * @param boolean|integer $cacheFlag Indicates if the objects should be
  * cached and optionally, by specifying an integer value, for how many
  * seconds.
  * @return array An array of xPDOObject instances or an empty array if no instances are loaded.
  */
 public static function loadCollection(xPDO &$xpdo, $className, $criteria = null, $cacheFlag = true)
 {
     $objCollection = array();
     $fromCache = false;
     if (!($className = $xpdo->loadClass($className))) {
         return $objCollection;
     }
     $rows = false;
     $fromCache = false;
     $collectionCaching = (int) $xpdo->getOption(xPDO::OPT_CACHE_DB_COLLECTIONS, array(), 1);
     if (!is_object($criteria)) {
         $criteria = $xpdo->getCriteria($className, $criteria, $cacheFlag);
     }
     if (is_object($criteria)) {
         $criteria = $xpdo->addDerivativeCriteria($className, $criteria);
     }
     if ($collectionCaching > 0 && $xpdo->_cacheEnabled && $cacheFlag) {
         $rows = $xpdo->fromCache($criteria);
         $fromCache = is_array($rows) && !empty($rows);
     }
     if (!$fromCache && is_object($criteria)) {
         $rows = xPDOObject::_loadRows($xpdo, $className, $criteria);
     }
     if (is_array($rows)) {
         foreach ($rows as $row) {
             xPDOObject::_loadCollectionInstance($xpdo, $objCollection, $className, $criteria, $row, $fromCache, $cacheFlag);
         }
     } elseif (is_object($rows)) {
         $cacheRows = array();
         while ($row = $rows->fetch(PDO::FETCH_ASSOC)) {
             xPDOObject::_loadCollectionInstance($xpdo, $objCollection, $className, $criteria, $row, $fromCache, $cacheFlag);
             if ($collectionCaching > 0 && $xpdo->_cacheEnabled && $cacheFlag && !$fromCache) {
                 $cacheRows[] = $row;
             }
         }
         if ($collectionCaching > 0 && $xpdo->_cacheEnabled && $cacheFlag && !$fromCache) {
             $rows =& $cacheRows;
         }
     }
     if (!$fromCache && $xpdo->_cacheEnabled && $collectionCaching > 0 && $cacheFlag && !empty($rows)) {
         $xpdo->toCache($criteria, $rows, $cacheFlag);
     }
     return $objCollection;
 }

 /**
  * Run the search based on the specified search string.
  *
  * @param string $string The string to run the search on.
  * @param int $limit The number of results to limit to.
  * @param int $start The starting result index to search from.
  * @param array $conditions An array of conditions to add to the search filter.
  * @return array An array of search results.
  */
 public function run($string, $limit = 10, $start = 0, array $conditions = array())
 {
     $response = array('results' => array(), 'total' => 0);
     $grouped = $this->modx->getOption('discuss.group_by_thread', '', 1);
     $c = $this->modx->newQuery('disPost');
     $c->innerJoin('disThread', 'Thread');
     $c->innerJoin('disBoard', 'Board');
     $c->innerJoin('disUser', 'Author');
     $c->where(array("MATCH (disPost.title,disPost.message) AGAINST ({$this->modx->quote($string, PDO::PARAM_STR)} IN BOOLEAN MODE)", 'Thread.private' => 0));
     if ($this->discuss->user->isLoggedIn) {
         $ignoreBoards = $this->discuss->user->get('ignore_boards');
         if (!empty($ignoreBoards)) {
             $c->where(array('Board.id:NOT IN' => explode(',', $ignoreBoards)));
         }
     }
     if (!empty($conditions['board'])) {
         $c->where(array('Board.id:IN' => $conditions['board']));
     }
     if (!empty($conditions['author'])) {
         if (is_string($conditions['author'])) {
             $c->where(array('Author.username' => $conditions['author']));
         } else {
             $c->where(array('author' => $conditions['author']));
         }
     }
     if (!empty($conditions['class_key'])) {
         $c->where(array('Thread.class_key' => $conditions['class_key']));
         if (!empty($conditions['answered']) && !is_null($conditions['answered'])) {
             $c->where(array('Thread.answered' => $conditions['answered']));
         }
     }
     if (!empty($conditions['createdon'])) {
         $c->where(array("{$this->modx->escape('disPost')}.{$this->modx->escape('createdon')} {$conditions['createdon']}"));
     }
     $c->select(array($this->modx->getSelectColumns('disPost', 'disPost', 'group_', array('thread')), 'replies' => 'Thread.replies', 'username' => 'Author.username', 'board_name' => 'Board.name', "MATCH (disPost.title,disPost.message) AGAINST ({$this->modx->quote($string, PDO::PARAM_STR)} IN BOOLEAN MODE) AS score"));
     $c->select($this->modx->getSelectColumns('disPost', 'disPost'));
     $c->sortby('score', 'DESC');
     $rowsFetched = (int) $this->modx->getOption('discuss.max_search_results', '', 500);
     if ($grouped) {
         $rowsFetched += (int) $this->modx->getOption('discuss.search_results_buffer', '', 200);
     }
     $c->limit($rowsFetched);
     $c->prepare();
     if (!$c->stmt->execute()) {
         $errorInfo = $c->stmt->errorInfo();
         $this->modx->log(xPDO::LOG_LEVEL_ERROR, "Error " . $c->stmt->errorCode() . " executing statement:\n" . $c->toSQL() . "\n" . print_r($errorInfo, true));
         return $response;
     }
     $threads = array();
     $i = 0;
     // used for thread grouping
     $skip = 0;
     // skip to start, if necessary
     $posts = array();
     if ($grouped) {
         $rows = $c->stmt->fetchAll(PDO::FETCH_ASSOC | PDO::FETCH_GROUP);
     } else {
         $rows = $c->stmt->fetchAll(PDO::FETCH_ASSOC);
     }
     foreach ($rows as $row) {
         if ($skip < $start) {
             // Scroll to start or skip thread if found already
             $skip++;
             continue;
         }
         if ($grouped) {
             $row = $row[0];
         }
         xPDOObject::_loadCollectionInstance($this->modx, $posts, 'disPost', $c, $row, false, false);
         $i++;
         if ($i == $limit || $i == count($rows)) {
             // $limit results found; get total row count, closeCursor (just in case) and exit while loop
             $response['total'] = count($rows) > (int) $this->modx->getOption('discuss.max_search_results', '', 500) ? (int) $this->modx->getOption('discuss.max_search_results', '', 500) : count($rows);
             $c->stmt->closeCursor();
             break;
         }
     }
     foreach ($posts as $post) {
         $postArray = $post->toArray('', true, true);
         $postArray['message'] = $post->getContent();
         $response['results'][] = $postArray;
     }
     return $response;
 }