PHP Phosphorum\Models Users::getModelsManager Examples

Example #1

File: Expert.php Project: sitexa/forum

 public function getExpertQuery(Users $user)
 {
     if (!$this->query) {
         $this->query = $user->getModelsManager()->createBuilder()->columns(['p.categories_id', 'COUNT(*)'])->from(['r' => 'Phosphorum\\Models\\PostsReplies'])->join('Phosphorum\\Models\\Posts', null, 'p')->where('r.users_id = ?0 AND r.accepted = "Y"')->notInWhere('p.categories_id', $this->getNoBountyCategories())->groupBy('p.categories_id')->having('COUNT(*) >= 10')->getQuery();
     }
     return $this->query;
 }