Executes query and returns a single row of result.
public one ( |
||
$db | the DB connection used to create the DB command. If `null`, the DB connection returned by [[modelClass]] will be used. | |
Результат | a single row of query result. Depending on the setting of [[asArray]], the query result may be either an array or an ActiveRecord object. `null` will be returned if the query results in nothing. |
public static function getActiveToken($token) { $activeQuery = new ActiveQuery(self::className()); $activeQuery->where('access_token = :token', [':token' => $token]); $activeQuery->andWhere('expires > now()'); $token = $activeQuery->one(); return $token; }
/** * @inheritdoc */ public function one($db = null) { $row = parent::one($db); if ($row !== null && $this->isMappableQuery()) { /** @var ActiveRecord|ActiveRecordTrait $className */ $className = $this->modelClass; $className::addRowToMap($row); } return $row; }
/** * @inheritdoc * @return Country|array|null */ public function one($db = null) { $memKey = 'mofei'; $result = Yii::$app->cache->get($memKey); if ($this->isCache && !empty($result)) { return $result; } else { $result = parent::one($db); if (!empty($result)) { Yii::$app->cache->set($memKey, $result, 5); } return $result; } }
public function setupCriteria() { $this->activeQuery->joinWith('content'); $this->activeQuery->joinWith('content.user'); $this->activeQuery->joinWith('content.space'); $this->activeQuery->limit($this->limit); $this->activeQuery->andWhere(['user.status' => User::STATUS_ENABLED]); $this->activeQuery->one(); /** * Handle Stream Mode (Normal Stream or Activity Stream) */ if ($this->mode == self::MODE_ACTIVITY) { $this->activeQuery->andWhere(['content.object_model' => \humhub\modules\activity\models\Activity::className()]); // Dont show own activities if ($this->user != null) { $this->activeQuery->leftJoin('activity', 'content.object_id=activity.id AND content.object_model=:activityModel', ['activityModel' => \humhub\modules\activity\models\Activity::className()]); $this->activeQuery->andWhere('content.user_id != :userId', array(':userId' => $this->user->id)); } } else { $this->activeQuery->andWhere(['!=', 'content.object_model', \humhub\modules\activity\models\Activity::className()]); } /** * Setup Sorting */ if ($this->sort == self::SORT_UPDATED_AT) { $this->activeQuery->orderBy('wall_entry.updated_at DESC'); if ($this->from != "") { $this->activeQuery->andWhere("wall_entry.updated_at < (SELECT updated_at FROM wall_entry wd WHERE wd.id=" . $this->from . ")"); } } else { $this->activeQuery->orderBy('wall_entry.id DESC'); if ($this->from != "") { $this->activeQuery->andWhere("wall_entry.id < " . $this->from); } } }
/** * @inheritdoc * @return Progressjobdetail|array|null */ public function one($db = null) { return parent::one($db); }
/** * @param Connection $db * @return ActiveRecord|null */ public function one($db = null) { $row = parent::one($db); return $row; }
/** * @return static|null ActiveRecord instance matching the condition, or `null` if nothing matches. */ public function findOne() { return $this->query->one(); }