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;
}
