PHP Sylius\Bundle\ResourceBundle\Doctrine\ORM EntityRepository::getQueryBuilder示例

示例#1

文件： TranslatableResourceRepository.php 项目： malukenho/Sylius

 /**
  * {@inheritdoc}
  */
 protected function getQueryBuilder()
 {
     $queryBuilder = parent::getQueryBuilder();
     $queryBuilder->addSelect('translation')->leftJoin($this->getAlias() . '.translations', 'translation');
     return $queryBuilder;
 }

示例#2

文件： OrderRepository.php 项目： bcremer/Sylius

 /**
  * {@inheritdoc}
  */
 protected function getQueryBuilder()
 {
     return parent::getQueryBuilder()->leftJoin('o.items', 'item')->addSelect('item');
 }

示例#3

文件： SubscriptionRepository.php 项目： Headd2k/SyliusSubscriptionBundle

 protected function getQueryBuilder()
 {
     $queryBuilder = parent::getQueryBuilder();
     return $queryBuilder->join($this->getAlias() . '.orderItem', 'i')->join('i.order', 'O')->andWhere($queryBuilder->expr()->isNotNull('O.completedAt'));
 }

示例#4

文件： ProductRepository.php 项目： bcremer/Sylius

 /**
  * {@inheritdoc}
  */
 protected function getQueryBuilder()
 {
     return parent::getQueryBuilder()->select($this->getAlias() . ', option, variant')->leftJoin($this->getAlias() . '.options', 'option')->leftJoin($this->getAlias() . '.variants', 'variant');
 }

示例#5

文件： TaxonomyRepository.php 项目： bcremer/Sylius

 /**
  * {@inheritdoc}
  */
 protected function getCollectionQueryBuilder()
 {
     return parent::getQueryBuilder()->select('taxonomy, root, taxons')->leftJoin('taxonomy.root', 'root')->leftJoin('root.children', 'taxons');
 }