PHP Doctrine\ORM QueryBuilder::getSingleScalarResult Examples

Example #1

File: Product.php Project: kewaunited/xcart

 /**
  * Search count only routine.
  *
  * @param \Doctrine\ORM\QueryBuilder $qb Query builder routine
  *
  * @return \Doctrine\ORM\PersistentCollection|integer
  */
 public function searchCount(\Doctrine\ORM\QueryBuilder $qb)
 {
     $qb->select('COUNT(DISTINCT p.product_id)');
     $qb->orderBy('p.product_id');
     return intval($qb->getSingleScalarResult());
 }

Example #2

File: PBExport.php Project: kirkbauer2/kirkxc

 /**
  * Search count only routine.
  *
  * @param \Doctrine\ORM\QueryBuilder $qb Query builder routine
  *
  * @return \Doctrine\ORM\PersistentCollection|integer
  */
 public function searchCount(\Doctrine\ORM\QueryBuilder $qb)
 {
     $qb->select('COUNT(DISTINCT ' . $qb->getMainAlias() . '.id)');
     return intval($qb->getSingleScalarResult());
 }

Example #3

File: Profile.php Project: kirkbauer2/kirkxc

 /**
  * Search count only routine.
  *
  * @param \Doctrine\ORM\QueryBuilder $qb Query builder routine
  *
  * @return \Doctrine\ORM\PersistentCollection|integer
  */
 public function searchCount(\Doctrine\ORM\QueryBuilder $qb)
 {
     $qb->select('COUNT(DISTINCT p.profile_id)');
     return (int) $qb->getSingleScalarResult();
 }

Example #4

File: Currency.php Project: kirkbauer2/kirkxc

 /**
  * Search count only routine.
  *
  * @param \Doctrine\ORM\QueryBuilder $qb Query builder routine
  *
  * @return \Doctrine\ORM\PersistentCollection|integer
  */
 public function searchCount(\Doctrine\ORM\QueryBuilder $qb)
 {
     $qb->select('COUNT(DISTINCT c.currency_id)');
     return intval($qb->getSingleScalarResult());
 }

Example #5

File: VolumeDiscount.php Project: kewaunited/xcart

 /**
  * Search count only routine.
  *
  * @param \Doctrine\ORM\QueryBuilder $qb Query builder routine
  *
  * @return \Doctrine\ORM\PersistentCollection|integer
  */
 protected function searchCount(\Doctrine\ORM\QueryBuilder $qb)
 {
     $qb->select('COUNT(v.id)');
     return intval($qb->getSingleScalarResult());
 }

Example #6

File: Notification.php Project: kirkbauer2/kirkxc

 /**
  * Search count only routine.
  *
  * @param \Doctrine\ORM\QueryBuilder $qb Query builder routine
  *
  * @return \Doctrine\ORM\PersistentCollection|integer
  */
 public function searchCount(\Doctrine\ORM\QueryBuilder $qb)
 {
     $qb->select('COUNT(DISTINCT n.templatesDirectory)');
     return intval($qb->getSingleScalarResult());
 }