public function search()
{
switch ($this->type) {
case 'name':
return PhotoActiveRecord::find()->where(['like', 'name', $this->text])->orderBy(['posted' => SORT_DESC])->asArray();
case 'tag':
$tags = TagsActiveRecord::find()->where(['like', 'tag', $this->text])->select(['photo'])->asArray();
return PhotoActiveRecord::find()->where(['in', 'id', $tags])->orderBy(['posted' => SORT_DESC])->asArray();
case 'users':
return (new Query())->from('user')->where(['like', 'fio', $this->text])->join('left join', 'photo', 'user.photo = photo.id')->select(['id' => 'user.id', 'thumbnail' => 'photo.thumbnail', 'name' => 'fio', 'username', 'pol', 'email', 'registerDate'])->orderBy(['registerDate' => SORT_DESC]);
case 'tags':
return TagsActiveRecord::find()->where(['like', 'tag', $this->text])->select(['id', 'tag'])->distinct()->asArray();
case 'comments':
return (new Query())->from('comments')->join('join', 'user', 'comments.userId = user.id')->select(['id' => 'comments.id', 'photoId', 'body', 'created', 'fio'])->orderBy(['created' => SORT_DESC]);
}
return null;
}
public static function userPhotos($userId)
{
return PhotoActiveRecord::find()->where(['userId' => $userId])->orderBy(['posted' => SORT_DESC])->asArray()->all();
}
