/** * @param ServiceManager $serviceManager * @return Form */ public function setServiceManager(ServiceManager $serviceManager) { $this->serviceManager = $serviceManager; $this->entityManager = $serviceManager->get('doctrine.entitymanager.orm_default'); $this->queryBuilder = $this->entityManager->createQueryBuilder(); return $this; }
public function getUsersActives() { $lastKeepalive = new \DateTime("now"); $lastKeepalive->modify("-" . $this->sessionLifeTime . " seconds"); $query = $this->em->createQueryBuilder()->select('u')->from('CdiUser\\Entity\\User', 'u')->where('u.lastKeepalive > :lk ')->setParameter("lk", $lastKeepalive); $colUsers = $query->getQuery()->getResult(); if ($colUsers) { return $colUsers; } else { return null; } }
/** * * @param Doctrine\ORM\EntityManager $em * @param string $entityName * @param OutputInterface $output * @return integer */ private function countSaveEntity($em, $entityName, $output) { $output->write("<info>Counting " . $entityName . "</info> "); $count = $em->createQueryBuilder()->select('count(entity.id)')->from($entityName, 'entity')->getQuery()->getSingleScalarResult(); $output->writeln(" <info> Result : " . $count . "</info>"); $output->writeln("<info>Saving count result to OjsJournalBundle:Sums"); $this->saveSum($em, $entityName, $count); return $count; }
/** * {@inheritdoc} */ public function showMessages($queueName) { $results = []; if ($this->isExists($queueName)) { $qb = $this->em->createQueryBuilder(); $qb->select('m.id, m.body, m.created, m.ended, m.failed')->from('Heri\\Bundle\\JobQueueBundle\\Entity\\Message', 'm')->leftJoin('m.queue', 'Queue')->where($qb->expr()->eq('Queue.name', ':name'))->setParameter('name', $queueName); $query = $qb->getQuery(); $results = $query->getResult(\Doctrine\ORM\Query::HYDRATE_ARRAY); } return $results; }
public function catalogo3Action() { $this->view->fabricantes = $this->_fabricante->findAll(); $id = $this->_getParam('id', false); if ($id) { $this->view->id = $id; $this->view->fabricante = $this->_fabricante->find($id); $qb = $this->em->createQueryBuilder()->select('p, f')->from("\\Models\\Entity\\Producto", 'p')->leftJoin('p.Fabricante', 'f')->orderBy('p.name', 'ASC')->where('p.id > 25')->andWhere('f.id = ' . $id); $q = $qb->getQuery(); $this->view->Productos25 = $q->execute(); $this->view->Productos25Array = $q->getArrayResult(); } }
/** * Gets the Doctrine Query object to be used by the validator. * If no select object was supplied to the constructor, * then it will auto-generate one from the given table, * schema, field, and adapter options. * * @return Doctrine\ORM\Query The Query object which will be used */ public function getQuery($value) { if (null === $this->_query) { $this->getEntityManager(); $qb = $this->_em->createQueryBuilder(); $qb->add('select', 'e')->add('from', $this->_entity . ' e'); $where = null; if ($this->_exclude !== null) { if (is_array($this->_exclude)) { $excludeClause = $qb->expr()->neq('e.' . $this->_exclude['field'], ':exclude'); $qb->setParameter('exclude', $this->_exclude['value']); } else { $excludeClause = $qb->expr()->neq($this->_exclude); } $qb->add('where', $qb->expr()->andx($qb->expr()->eq('e.' . $this->_field, ':field'), $excludeClause)); } else { $qb->add('where', $qb->expr()->eq('e.' . $this->_field, ':field')); } $qb->setParameter('field', $value); $qb->setMaxResults(1); $this->_query = $qb->getQuery(); } return $this->_query; }
/** * Return a Doctrine\Orm\QueryBuilder. * * @return Doctrine\Orm\QueryBuilder */ protected function getQueryBuilder() { return $this->em->createQueryBuilder(); }
/** * Construct the Doctrine query. * * @return Doctrine\ORM\Query */ protected function _getQuery() { $qb = $this->em->createQueryBuilder()->select('e.' . $this->credentialField . ', e')->from($this->entityName, 'e')->where('e.' . $this->identityField . ' = ?1'); return $qb->getQuery(); }