PHP LoginCidadao\CoreBundle\Entity CityRepository::createQueryBuilder Examples

Example #1

File: CityManager.php Project: redelivre/login-cidadao

 public function findByStateId($id)
 {
     $reviewed = City::REVIEWED_OK;
     return $this->repository->createQueryBuilder('c')->join('c.state', 's')->where('s.id = :id')->andWhere('c.reviewed = :reviewed')->orderBy('c.name')->setParameters(compact('id', 'reviewed'))->getQuery()->getResult();
 }