public function getSubscription() { return $this->hasOne(DbSubscription::className(), ['subscription_id' => 'id']); }
/** * @param mixed $subscriber_id * @return array|models\DbSubscription */ public function getSubscriptions($subscriber_id = null) { /** @var $query \yii\db\ActiveQuery */ $query = models\DbSubscription::find()->current()->withQueue($this->id)->with(['categories']); if ($subscriber_id !== null) { $dbSubscriptions = $query->andWhere('subscriber_id=:subscriber_id', [':subscriber_id' => $subscriber_id]); } $dbSubscriptions = $query->all(); return models\DbSubscription::createSubscriptions($dbSubscriptions); }
/** * @param string $subscriber_id * @return DbMessageQuery $this */ public function withSubscriber($subscriber_id = null) { if ($subscriber_id === null) { $modelClass = $this->modelClass; $t = $modelClass::tableName(); $this->andWhere("{$t}.subscription_id IS NULL"); } else { $this->innerJoinWith('subscription'); $this->andWhere(DbSubscription::tableName() . '.subscriber_id=:subscriber_id', [':subscriber_id' => $subscriber_id]); } return $this; }