PHP ActiveRecord::find方法代码示例

 public function search($params)
 {
     /* @var $query \yii\db\ActiveQuery */
     $query = $this->baseModel->find();
     $table_inheritance_joined = false;
     $dataProvider = new ActiveDataProvider(['query' => &$query, 'pagination' => ['pageSize' => 10], 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]);
     if (!$this->load($params)) {
         return $dataProvider;
     }
     $object = Object::getForClass($this->baseModel->className());
     $baseModelTableName = $this->baseModel->tableName();
     $eavJoinsCount = 0;
     $osvJoinsCount = 0;
     foreach ($this->propertyGroups as $groupId => $properties) {
         foreach ($properties as $key => $propertyValue) {
             /** @var \app\properties\PropertyValue $propertyValue */
             $prop = Property::findById($propertyValue->property_id);
             if (empty($this->{$prop->key}) === true && $this->{$prop->key} !== '0') {
                 continue;
             }
             // determine property storage type and join needed table if needed
             if ($prop->is_column_type_stored) {
                 if ($table_inheritance_joined === false) {
                     $table_inheritance_joined = true;
                     $query->join('INNER JOIN', $object->column_properties_table_name . ' ti', 'ti.object_model_id = ' . $baseModelTableName . '.id');
                 }
                 if ($prop->value_type === 'STRING' && $prop->property_handler_id !== 3) {
                     $query->andFilterWhere(['like', 'ti.' . $prop->key, $this->{$prop->key}]);
                 } else {
                     $query->andFilterWhere(['ti.' . $prop->key => $this->{$prop->key}]);
                 }
             } elseif ($prop->is_eav) {
                 $eavJoinsCount++;
                 $eavTableName = 'eav' . $eavJoinsCount;
                 $key = 'key' . $eavJoinsCount;
                 $query->join('INNER JOIN', "{$object->eav_table_name} {$eavTableName}", $eavTableName . '.object_model_id = ' . $baseModelTableName . ".id AND {$eavTableName}.key=:{$key}", [$key => $prop->key]);
                 if ($prop->value_type === 'STRING' && $prop->property_handler_id !== 3) {
                     $query->andFilterWhere(['like', $eavTableName . '.value', $this->{$prop->key}]);
                 } else {
                     // numeric - direct match
                     $query->andFilterWhere([$eavTableName . '.value' => $this->{$prop->key}]);
                 }
             } elseif ($prop->has_static_values) {
                 $osvJoinsCount++;
                 $osvTableName = 'osv' . $osvJoinsCount;
                 $query->join('INNER JOIN', "object_static_values {$osvTableName}", "{$osvTableName}.object_id={$object->id} AND {$osvTableName}.object_model_id={$baseModelTableName}.id");
                 // numeric - direct match
                 $query->andFilterWhere(["{$osvTableName}.property_static_value_id", $this->{$prop->key}]);
             }
         }
     }
     return $dataProvider;
 }

 public static function find()
 {
     if (array_key_exists('deleted', static::getTableSchema()->columns)) {
         return parent::find()->onCondition(static::tableName() . '.deleted = 0');
     } else {
         return parent::find();
     }
 }

 public static function find()
 {
     $user_id = Yii::$app->user->id;
     $find = parent::find();
     $find->andWhere('user_id=:user_id', [':user_id' => $user_id]);
     //        $find->andFilterWhere(['=', 'user_id', $user_id]);
     return $find;
 }

 public static function find()
 {
     $return = parent::find();
     if (in_array('deleted_at', parent::attributes())) {
         $tableName = static::getTableSchema()->name;
         $return->andWhere([$tableName . '.deleted_at' => null]);
     }
     return $return;
 }

 public static function getItems()
 {
     $items = [];
     $models = parent::find()->all();
     foreach ($models as $model) {
         $items[] = ['label' => $model->title, 'url' => $model->slug];
     }
     return $items;
 }

 public static function find()
 {
     $city_id = Yii::$app->request->cookies['city'];
     $p['store_id'] = 109;
     $query = parent::find();
     //        $query->where('(store_id=:store_id) and not(title is null) and (value_char != \'\')',$p);
     $query->where('(store_id=:store_id)', $p);
     return $query;
 }

 public static function find($onlyDeleted = null)
 {
     if (is_null($onlyDeleted)) {
         return parent::find()->where([self::tableName() . '.delete' => 0]);
     } elseif ($onlyDeleted === true) {
         return parent::find()->where([self::tableName() . '.delete' => 1]);
     } elseif ($onlyDeleted === false) {
         return parent::find();
     }
 }

 public static function getPoints()
 {
     $points = parent::find()->all();
     if (count($points) > 0) {
         $geoObject = ['type' => 'FeatureCollection'];
         foreach ($points as $point) {
             $geoObject['features'][] = ['type' => 'Feature', 'id' => $point->id, 'geometry' => ['type' => 'Point', 'coordinates' => explode(',', $point->point)], 'properties' => ['balloonContent' => $point->body, 'iconContent' => $point->title], 'options' => ['preset' => $point->preset]];
         }
     } else {
         $geoObject = false;
     }
     return $geoObject;
 }

 public static function find()
 {
     $tenantTableName = '{{%tenant}}';
     $field = '';
     $model = parent::find();
     if (parent::tableName() == $tenantTableName) {
         $field = '.id';
     } else {
         $field = '.tenant_id';
     }
     $model->where([parent::tableName() . $field => Yii::$app->session['tenant']]);
     return $model;
 }

 public static function find($tables = null)
 {
     $aWhere = [];
     if ($tables) {
         if (!is_array($tables)) {
             $tables = [$tables];
         }
         foreach ($tables as $table) {
             $aWhere[$table . '.disabled'] = self::STATUS_ENABLE;
         }
         return parent::find()->where($aWhere);
     }
     return parent::find()->where(['disabled' => self::STATUS_ENABLE]);
 }

 /**
  * @param ActiveRecord $model
  * @param array $opts
  * @return ActiveQuery | array
  */
 static function searchQuery($model, $opts = [])
 {
     $opts = ArrayHelper::merge(['data' => null, 'query' => null, 'columns' => [], 'filters' => []], $opts);
     $columns = $opts['columns'];
     $filters = $opts['filters'];
     $data = $opts['data'];
     if (null === $data) {
         $data = \Yii::$app->request->get();
     }
     $query = $opts['query'];
     if (is_string($query)) {
         $query = call_user_func([$model, $opts['query']]);
     } elseif (null === $query) {
         $query = $model->find();
         foreach (array_filter($model->getAttributes()) as $prop => $val) {
             $query->andWhere([$prop => $val]);
         }
     }
     if ($model->load($data) && $model->validate()) {
         foreach ($model->getAttributes($model->safeAttributes()) as $name => $value) {
             if ($model->isAttributeChanged($name)) {
                 $attributeTypes = [];
                 if (method_exists($model, 'attributeTypes')) {
                     $attributeTypes = $model->attributeTypes();
                 }
                 $type = null;
                 if (isset($attributeTypes[$name])) {
                     $type = $attributeTypes[$name];
                 }
                 // Default filter function
                 $filterFunc = isset($filters[$name]) && is_callable($filters[$name]) ? $filters[$name] : function (ActiveQuery $query, $name, $value, $type) {
                     /**
                      * @var string $name
                      * @var string|array $value
                      * @var string $type
                      */
                     $query->andFilterWhere(static::searchAttribute($name, $value, $type));
                 };
                 if (isset($columns[$name])) {
                     $name = $columns[$name];
                 }
                 call_user_func($filterFunc, $query, $name, $value, $type);
             }
         }
     }
     return $query;
 }

 /**
  * Default sort on find command.
  *
  * @return ActiveQuery
  */
 public static function find()
 {
     return parent::find()->orderBy(['sort_index' => SORT_ASC]);
 }

 public static function findNonDeleted($param)
 {
     return parent::find()->where(['and', ['deleted' => false], $param]);
 }

 public static function find()
 {
     return parent::find()->with('type');
 }

 /**
  * @inherit
  */
 public static function find()
 {
     return parent::find()->where(['status' => self::STATUS_ACTIVE, 'type' => static::TYPE]);
 }