src/Mixstore/StoreBundle/Entity/UsecaseRepository.php

   1 <?php
   2
   3 namespace Mixstore\StoreBundle\Entity;
   4
   5 use Doctrine\ORM\EntityRepository;
   6
   7 class UsecaseRepository extends EntityRepository
   8 {
   9     function safeFindById($id)
  10     {
  11         if ($id > 0)
  12         {
  13             $qb = $this->createQueryBuilder('u');
  14             $qb->where('u.id = '.$id);
  15             $usecase = $qb->getQuery()->getResult()[0];
  16         }
  17         else
  18             $usecase = new Usecase();
  19
  20         return $usecase;
  21     }
  22
  23     function countByPkgId($pkgid)
  24     {
  25         return $this
  26             ->createQueryBuilder('u')
  27             ->select('COUNT(u.id) AS ucscount, AVG(u.grade) AS rating')
  28             ->where('u.package = '.$pkgid)
  29             ->getQuery()
  30             ->getResult()[0];
  31             //->getSingleScalarResult();
  32     }
  33 }