PHP Doctrine\ORM QueryBuilder::andwhere Examples

Example #1

File: UserRepository.php Project: chadyred/crm

 protected function enabled(QueryBuilder $qb, $enabled = true)
 {
     $qb->andwhere('securityUser.enabled = :enabled')->setParameter('enabled', $enabled);
     return $qb;
 }

Example #2

File: AccountRepository.php Project: chadyred/crm

 protected function state(QueryBuilder $qb, $states = array())
 {
     $i = 0;
     $cond = '';
     foreach ($states as $state) {
         if ($i != 0) {
             $cond .= ' OR ';
         }
         $i++;
         $cond .= 'account.state = :state' . $i;
         $qb->setParameter('state' . $i, $state);
     }
     $qb->andwhere($cond);
     return $qb;
 }