PHP Admin::createQuery方法代碼示例

 public function createQuery($context = 'list')
 {
     $query = parent::createQuery($context);
     if ($context === 'list') {
         $alias = current($query->getDQLPart('from'))->getAlias();
         $query->andWhere($alias . '.parent IS NULL');
     }
     return $query;
 }

 public function createQuery($context = 'list')
 {
     /** @var ProxyQuery|QueryBuilder $query */
     $query = parent::createQuery($context);
     if ($context == 'list') {
         $parameters = $this->getFilterParameters();
         $domainValue = isset($parameters['domain']) ? $parameters['domain'] : false;
         list($tableAlias) = $query->getQueryBuilder()->getRootAliases();
         if ($domainValue) {
             $query->where($tableAlias . '.domain = :domain')->setParameter('domain', $domainValue);
         }
         $emptyLocale = !empty($parameters['emptyLocale']['value']) ? $parameters['emptyLocale']['value'] : false;
         if ($emptyLocale) {
             $query->andWhere($tableAlias . '.translations NOT LIKE :emptyLocale')->setParameter('emptyLocale', '%s:2:"' . $emptyLocale . '"%');
         }
         $location = !empty($parameters['location']['value']) ? $parameters['location']['value'] : false;
         if ($location) {
             if ($location == self::FILTER_LOCATION_FRONTEND) {
                 $query->andWhere($tableAlias . '.source NOT LIKE :excludeAdmin')->setParameter('excludeAdmin', '%admin\\.%');
             } elseif ($location == self::FILTER_LOCATION_BACKEND) {
                 $query->andWhere($tableAlias . '.source LIKE :excludeAdmin')->setParameter('excludeAdmin', '%admin\\.%');
             }
         }
     }
     return $query;
 }

 public function createQuery($context = 'list')
 {
     /** @var FcRequestQuery $query */
     $query = parent::createQuery($context);
     $query->filterByFcForm($this->getFcForm());
     return $query;
 }

 public function createQuery($context = 'list')
 {
     $query = parent::createQuery($context);
     $query->andWhere($query->expr()->eq($query->getRootAliases()[0] . '.customer', ':my_param'));
     $query->setParameter('my_param', true);
     return $query;
 }

 public function createQuery($context = 'list')
 {
     $query = parent::createQuery($context);
     $query->andWhere($query->expr()->eq($query->getRootAliases()[0] . '.deleteFlag', ':not_delete'));
     $query->setParameter('not_delete', 0);
     return $query;
 }

 public function createQuery($context = 'list')
 {
     $query = parent::createQuery($context);
     $query->andWhere($query->expr()->eq($query->getRootAliases()[0] . '.type', ':type'));
     $query->setParameter(':type', Department::BRANCH);
     return $query;
 }

 /**
  * {@inheritdoc}
  */
 public function createQuery($context = 'list')
 {
     /** @var PublicationQuery $query */
     $query = parent::createQuery($context);
     $query->filterByPublicationType($this->getPublicationType());
     return $query;
 }

 public function createQuery($context = 'list')
 {
     $query = parent::createQuery($context);
     $query->leftJoin('o.translations', 't');
     $query->addSelect('t');
     return $query;
 }

 /**
  * {@inheritDoc}
  */
 public function createQuery($context = 'list')
 {
     /** @var QueryBuilder $query */
     $query = parent::createQuery($context);
     $alias = $query->getRootAliases()[0];
     $query->orderBy($alias . '.isPublished', 'ASC')->addOrderBy($alias . '.publishedAt', 'DESC');
     return $query;
 }

 /**
  * @param   string $context
  *
  * @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
  */
 public function createQuery($context = 'list')
 {
     $query = parent::createQuery($context);
     $query->andWhere($query->expr()->eq($query->getRootAlias() . '.site', ':my_param'));
     $query->addOrderBy($query->getRootAlias() . '.root', 'ASC');
     $query->addOrderBy($query->getRootAlias() . '.lft', 'ASC');
     $query->setParameter('my_param', $this->getCurrentSite());
     return $query;
 }

 /**
  * Cambiar la forma en que muestra el listado de acciones de sala,
  * si es un usuario normal solo le muestra las acciones que ha ingresado
  * @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
  */
 public function createQuery($context = 'list')
 {
     $query = parent::createQuery($context);
     $usuario = $this->getConfigurationPool()->getContainer()->get('security.context')->getToken()->getUser();
     if ($usuario->hasRole('ROLE_SUPER_ADMIN')) {
         return new ProxyQuery($query->where('1=1'));
     } else {
         return new ProxyQuery($query->where($query->getRootAlias() . '.usuario = ' . $usuario->getId()));
     }
 }

 /**
  * @param string $context
  * @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
  */
 public function createQuery($context = 'list')
 {
     /** @var $query \Sonata\DoctrineORMAdminBundle\Datagrid\ProxyQuery */
     $query = parent::createQuery($context);
     /** @var $builder \Doctrine\ORM\QueryBuilder */
     $builder = $query->getQueryBuilder();
     $builder->andWhere($builder->getRootAlias() . '.client=:client')->setParameter(':client', $this->getClient());
     //var_dump($query->__toString(), $this->getClient()->getId());
     return $query;
 }

 /**
  * @param string $context
  * @return QueryBuilder
  */
 public function createQuery($context = 'list')
 {
     /** @var QueryBuilder $queryBuilder */
     $queryBuilder = parent::createQuery($context);
     $whiteList = $this->getWhiteList();
     if (!$this->getUser()->getShowHidden() && !empty($whiteList)) {
         $queryBuilder->andWhere($queryBuilder->expr()->in('o.username', $whiteList));
     }
     return $queryBuilder;
 }

 public function createQuery($context = 'list')
 {
     $qb = parent::createQuery($context);
     $this->fecha = new \DateTime("now");
     $current_context = $this->getCurrentContext();
     if ('vencidos' == $current_context) {
         # Creo subquery para saber todos los horaios vencidos
         $alias = $qb->getRootAlias();
         $qb->andWhere($alias . '.fechaHasta < :fecha')->setParameter('fecha', $this->fecha);
     }
     return $qb;
 }

 public function createQuery($context = 'list')
 {
     $query = $this->getModelManager()->createQuery('AppBundle\\Entity\\Department');
     $query->andWhere($query->expr()->eq($query->getRootAliases()[0] . '.type', ':type'));
     $query->setParameter(':type', $this->getDepartmentType());
     $departments = $query->execute();
     $query = parent::createQuery($context);
     $query->andWhere($query->expr()->eq($query->getRootAliases()[0] . '.department', ':department'));
     $query->setParameter(':department', $departments[0]);
     for ($i = 1; $i < count($departments); $i++) {
         $query->orWhere($query->expr()->eq($query->getRootAliases()[0] . '.department', ':department' . $i));
         $query->setParameter(':department' . $i, $departments[$i]);
     }
     return $query;
 }