PHP CActiveRecord::findAll方法代碼示例

 /**
  * fetch data
  */
 protected function fetchData()
 {
     $criteria = $this->_criteria;
     $criteria->offset = $this->_offset;
     $criteria->limit = $this->batchSize;
     $this->_batch = $this->_model->findAll($criteria);
     $this->_offset += $this->batchSize;
 }

 public function getValidParents()
 {
     $result = array();
     $criteria = new CDbCriteria();
     if (!$this->_model->getIsNewRecord()) {
         $criteria->addNotInCondition($this->getPK(), $this->getDescendantsIds($this->_model));
     }
     foreach ($this->_model->findAll($criteria) as $model) {
         $result[$model->{$this->getPK()}] = $model->getCaption();
     }
     return $result;
 }

 public function findAll($condition = '', $params = array())
 {
     $stores = parent::findAll($condition, $params);
     // add default store
     $default = self::getDefaultStore();
     array_unshift($stores, $default);
     return $stores;
 }

 /**
  * {@inheritDoc}
  * @see Iterator::rewind()
  */
 public function rewind()
 {
     $this->_current_index = 0;
     $this->_criteria->offset = 0;
     $this->_max_count = (int) $this->_model->count($this->_criteria);
     $this->_current_records = $this->_model->findAll($this->_criteria);
     $this->_current_records_size = count($this->_current_records);
 }

 /**
  * {@inheritDoc}
  * @see Iterator::rewind()
  */
 public function rewind()
 {
     $this->_current_index = 0;
     $this->_current_offset = 0;
     $this->_max_count = $this->_model->count($this->_criteria);
     $newcriteria = clone $this->_criteria;
     $this->_current_records = $this->_model->findAll($newcriteria);
     $this->_current_records_size = count($this->_current_records);
 }

 /**
  * {@inheritDoc}
  * @see Iterator::rewind()
  */
 public function rewind()
 {
     $this->_current_index = 0;
     $this->_current_offset = 0;
     $timedCriteria = clone $this->_criteria;
     $timedCriteria->compare($this->_date_field, $this->_date_value);
     $this->_max_count = $this->_model->count($timedCriteria);
     $this->_current_records = $this->_model->findAll($timedCriteria);
     $this->_current_records_size = count($this->_current_records);
 }

 /**
  * @param CActiveRecord $model
  * @param string $valueField defaults to primary key field
  * @param string $textField defaults to primary key field
  * @return array
  */
 public static function listData($model, $valueField = '', $textField = '')
 {
     $pk = $model->metaData->tableSchema->primaryKey;
     if ($valueField === '') {
         $valueField = $pk;
     }
     if ($textField === '') {
         $textField = $valueField;
     }
     return CHtml::listData($model->findAll(array('select' => $valueField == $textField ? $valueField : $valueField . ',' . $textField)), $valueField, $textField);
 }

 /**
  * @param CActiveRecord $model
  * @param string|array $inValues
  * @param string $column
  * @return CActiveRecord
  */
 public static function GET_DATA_IN($model, $column = 'id', $inValues)
 {
     $criteria = new CDbCriteria();
     if (is_string($inValues)) {
         $inValues = explode(',', $inValues);
     }
     $criteria->addInCondition($column, $inValues);
     return $model->findAll($criteria);
 }

 /**
  * @param CActiveRecord $model
  * @param CDbCriteria $criteria
  * @param int $length
  * @return CDbCriteria
  */
 public static function GET_RANDOM_CRITERIA_OFFSET($model, $criteria, $length = NULL)
 {
     $criteriaTmp = $criteria;
     $criteriaTmp->select = 't.id';
     $randomMax = count($model->findAll($criteriaTmp));
     if ($randomMax > $length) {
         if ($length == NULL) {
             $random = rand(0, $randomMax - 1);
         } else {
             $random = rand(0, $randomMax - $length);
         }
         $criteria->offset = $random;
     }
     return $criteria;
 }

 /**
  * Finds all active records satisfying the specified condition, selecting only the requested
  * attributes and, if specified, the primary keys.
  * See {@link CActiveRecord::find} for detailed explanation about $condition and $params.
  * #MethodTracker
  * This method is based on {@link CActiveRecord::findAll}, from version 1.1.7 (r3135). Changes:
  * <ul>
  * <li>Selects only the specified attributes.</li>
  * <li>Detects and selects the representing column.</li>
  * <li>Detects and selects the PK attribute.</li>
  * </ul>
  * @param string|array $attributes The names of the attributes to be selected.
  * Optional. If not specified, the {@link representingColumn} will be used.
  * @param boolean $withPk Specifies if the primary keys will be selected.
  * @param mixed $condition Query condition or criteria.
  * @param array $params Parameters to be bound to an SQL statement.
  * @return array List of active records satisfying the specified condition. An empty array is returned if none is found.
  * @uses representingColumn
  */
 public function findAllAttributes($attributes = null, $withPk = false, $condition = '', $params = array())
 {
     Yii::trace(get_class($this) . '.findAllAttributes()', 'giix.components.GxActiveRecord');
     $criteria = $this->getCommandBuilder()->createCriteria($condition, $params);
     if ($attributes === null) {
         $attributes = $this->representingColumn();
     }
     if ($withPk) {
         $pks = self::model(get_class($this))->getTableSchema()->primaryKey;
         if (!is_array($pks)) {
             $pks = array($pks);
         }
         if (!is_array($attributes)) {
             $attributes = array($attributes);
         }
         $attributes = array_merge($pks, $attributes);
     }
     $criteria->select = $attributes;
     return parent::findAll($criteria);
 }

 /**
  *
  * @param string $condition
  * @param array $params
  * @return array 
  */
 public function findAll($condition = '', $params = array())
 {
     if (CStubActiveRecord::isUnittests()) {
         return CallFactory::call($this, 'findAll');
     }
     return parent::findAll($condition, $params);
 }

 public function findAll($condition = '', $params = array())
 {
     return $this->prepareRecords(parent::findAll($this->prepareCondition($condition), $params));
 }

 /**
  * Don't use now.
  *
  * @param \CActiveRecord $model - model class name.
  * @param array $params - params list.
  * @param int $page - current page.
  * @param int $min - left border
  * @param int $max - right border
  * @return int page number
  */
 private function countTotalPages($model, $params, $page, $min = 0, $max = 0)
 {
     if (!empty($model->findAll(array('limit' => 1, 'offset' => $params['limit'] * ($page - 1))))) {
         if (empty($model->findAll(array('limit' => 1, 'offset' => $params['limit'] * $page)))) {
             return $page;
         }
         $min = $page;
         $page = $max == 0 ? ceil($page * 1.5) : ceil($page + ($max - $page) / 2);
     } else {
         $max = $page;
         $page = $min == 0 ? ceil($page / 2) : ceil(($page - $min) * 1.5);
     }
     return $this->countTotalPages($model, $params, $page, $min, $max);
 }