PHP QueryBuilder::distinct方法代码示例

 public function applyGreatestNPerGroupDate(QueryBuilder $qb)
 {
     $qb->distinct();
     $qb2 = $this->createQueryBuilder('ss')->select('MAX(ss.timestamp)')->where('DATE(ss.timestamp) = DATE(s.timestamp)');
     $qb->innerJoin($this->getEntityName(), 'sub', 'WITH', $qb->expr()->eq('s.timestamp', '(' . $qb2->getDQL() . ')'));
 }

 public function makeDistinct()
 {
     $this->queryBuilder->distinct();
 }

 /**
  * Applies the given joins for the query builder
  *
  * @param QueryBuilder $qb
  * @param array|null   $joins
  */
 public static function applyJoins(QueryBuilder $qb, $joins)
 {
     if (empty($joins)) {
         return;
     }
     $qb->distinct(true);
     $rootAlias = self::getSingleRootAlias($qb);
     foreach ($joins as $key => $val) {
         if (empty($val)) {
             $qb->leftJoin($rootAlias . '.' . $key, $key);
         } elseif (is_array($val)) {
             if (isset($val['join'])) {
                 $join = $val['join'];
                 if (false === strpos($join, '.')) {
                     $join = $rootAlias . '.' . $join;
                 }
             } else {
                 $join = $rootAlias . '.' . $key;
             }
             $condition = null;
             $conditionType = null;
             if (isset($val['condition'])) {
                 $condition = $val['condition'];
                 $conditionType = Expr\Join::WITH;
             }
             if (isset($val['conditionType'])) {
                 $conditionType = $val['conditionType'];
             }
             $qb->leftJoin($join, $key, $conditionType, $condition);
         } else {
             $qb->leftJoin($rootAlias . '.' . $val, $val);
         }
     }
 }

 /**
  * {@inheritdoc}
  */
 public function parse($value, QueryBuilder $qb)
 {
     if (!is_array($value)) {
         $value = Yaml::parse($value);
     }
     $processor = new Processor();
     $value = $processor->processConfiguration(new QueryConfiguration(), $value);
     if (!isset($value['from'])) {
         throw new \RuntimeException('Missing mandatory "from" section');
     }
     foreach ((array) $value['from'] as $from) {
         $qb->from($from['table'], $from['alias']);
     }
     if (isset($value['select'])) {
         foreach ($value['select'] as $select) {
             $qb->add('select', new Expr\Select($select), true);
         }
     }
     if (isset($value['distinct'])) {
         $qb->distinct((bool) $value['distinct']);
     }
     if (isset($value['groupBy'])) {
         $qb->groupBy($value['groupBy']);
     }
     if (isset($value['having'])) {
         $qb->having($value['having']);
     }
     $this->addJoin($qb, $value);
     $this->addWhere($qb, $value);
     $this->addOrder($qb, $value);
     return $qb;
 }

 /**
  * {@inheritdoc}
  */
 public function execute()
 {
     // emit listbuilder.create event
     $event = new ListBuilderCreateEvent($this);
     $this->eventDispatcher->dispatch(ListBuilderEvents::LISTBUILDER_CREATE, $event);
     $this->expressionFields = $this->getUniqueExpressionFieldDescriptors($this->expressions);
     // first create simplified id query
     // select ids with all necessary filter data
     $ids = $this->findIdsByGivenCriteria();
     // if no results are found - return
     if (count($ids) < 1) {
         return [];
     }
     // now select all data
     $this->queryBuilder = $this->em->createQueryBuilder()->from($this->entityName, $this->entityName);
     $this->assignJoins($this->queryBuilder);
     // Add all select fields
     foreach ($this->selectFields as $field) {
         $this->queryBuilder->addSelect($field->getSelect() . ' AS ' . $field->getName());
     }
     // group by
     $this->assignGroupBy($this->queryBuilder);
     // assign sort-fields
     $this->assignSortFields($this->queryBuilder);
     // use ids previously selected ids for query
     $select = $this->entityName . '.id';
     if (null !== $this->idField) {
         $select = $this->idField->getSelect();
     }
     $this->queryBuilder->where($select . ' IN (:ids)')->setParameter('ids', $ids);
     $this->queryBuilder->distinct($this->distinct);
     return $this->queryBuilder->getQuery()->getArrayResult();
 }

 /**
  * Recreate query builder and set state again.
  *
  * @return void
  */
 public function __wakeup()
 {
     if ($this->constraint !== null) {
         $this->queryBuilder->where($this->constraint);
     }
     if (is_array($this->orderings)) {
         $aliases = $this->queryBuilder->getRootAliases();
         foreach ($this->orderings as $propertyName => $order) {
             $this->queryBuilder->addOrderBy($aliases[0] . '.' . $propertyName, $order);
         }
     }
     if (is_array($this->joins)) {
         foreach ($this->joins as $joinAlias => $join) {
             $this->queryBuilder->leftJoin($join, $joinAlias);
         }
     }
     $this->queryBuilder->setFirstResult($this->offset);
     $this->queryBuilder->setMaxResults($this->limit);
     $this->queryBuilder->distinct($this->distinct);
     $this->queryBuilder->setParameters($this->parameters);
     unset($this->parameters);
 }