93 search results for andWhere

Code

Learn Symfony 3

 >

Doctrine Collections: ManyToMany, Forms & other Complex Relations

 >

Collection Filtering: The Easy Way
26 lines | src/AppBundle/Repository/GenusRepository.php
// ... lines 1 - 7
class GenusRepository extends EntityRepository
{
/**
* @return Genus[]
*/
public function findAllPublishedOrderedByRecentlyActive()
{
return $this->createQueryBuilder('genus')
->andWhere('genus.isPublished = :isPublished')
->setParameter('isPublished', true)
->leftJoin('genus.notes', 'genus_note')
->orderBy('genus_note.createdAt', 'DESC')
->leftJoin('genus.genusScientists', 'genusScientist')
->addSelect('genusScientist')
->getQuery()
->execute();
}
}
See Code Block in Script
Code

Learn Symfony 5

 >

Go Pro with Doctrine Queries (Legacy)

 >

Reusing Queries with the Query Builder
66 lines | src/AppBundle/Entity/CategoryRepository.php
// ... lines 1 - 26
public function search($term)
{
$qb = $this->createQueryBuilder('cat')
->andWhere('cat.name LIKE :searchTerm
OR cat.iconKey LIKE :searchTerm
OR fc.fortune LIKE :searchTerm');
$this->addFortuneCookieJoinAndSelect($qb);
return $qb
->setParameter('searchTerm', '%'.$term.'%')
->getQuery()
->execute();
}
// ... lines 40 - 66
See Code Block in Script
Code

Learn Symfony 6

 >

Go Pro with Doctrine Queries

 >

WHERE IN()
120 lines | src/Repository/CategoryRepository.php
// ... lines 1 - 41
public function search(string $term): array
{
// ... lines 44 - 46
return $this->addFortuneCookieJoinAndSelect($qb)
->andWhere('category.name LIKE :searchTerm OR category.name IN (:termList) OR category.iconKey LIKE :searchTerm OR fortuneCookie.fortune LIKE :searchTerm')
// ... line 49
->setParameter('termList', $termList)
// ... lines 51 - 52
}
// ... lines 54 - 120
See Code Block in Script
Code

Learn Symfony 6

 >

Go Pro with Doctrine Queries

 >

Selecting Specific Fields
80 lines | src/Repository/FortuneCookieRepository.php
// ... lines 1 - 17
class FortuneCookieRepository extends ServiceEntityRepository
{
// ... lines 20 - 24
public function countNumberPrintedForCategory(Category $category): int
{
$result = $this->createQueryBuilder('fortuneCookie')
->select('SUM(fortuneCookie.numberPrinted) AS fortunesPrinted')
->andWhere('fortuneCookie.category = :category')
->setParameter('category', $category)
->getQuery()
->getSingleScalarResult();
return (int) $result;
}
// ... lines 36 - 78
}
See Code Block in Script
Code

Learn APIs

 >

API Platform 3 Part 2: Security for your Treasures

 >

404 On Unpublished Items
40 lines | src/ApiPlatform/DragonTreasureIsPublishedExtension.php
// ... lines 1 - 11
class DragonTreasureIsPublishedExtension implements QueryCollectionExtensionInterface, QueryItemExtensionInterface
{
// ... lines 14 - 28
private function addIsPublishedWhere(string $resourceClass, QueryBuilder $queryBuilder): void
{
if (DragonTreasure::class !== $resourceClass) {
return;
}
$rootAlias = $queryBuilder->getRootAliases()[0];
$queryBuilder->andWhere(sprintf('%s.isPublished = :isPublished', $rootAlias))
->setParameter('isPublished', true);
}
}
See Code Block in Script
Code

Learn APIs

 >

API Platform 3 Part 2: Security for your Treasures

 >

404 On Unpublished Items
40 lines | src/ApiPlatform/DragonTreasureIsPublishedExtension.php
// ... lines 1 - 11
class DragonTreasureIsPublishedExtension implements QueryCollectionExtensionInterface, QueryItemExtensionInterface
{
// ... lines 14 - 23
/**
* @param string $resourceClass
* @param QueryBuilder $queryBuilder
* @return void
*/
private function addIsPublishedWhere(string $resourceClass, QueryBuilder $queryBuilder): void
{
// ... lines 31 - 34
$rootAlias = $queryBuilder->getRootAliases()[0];
$queryBuilder->andWhere(sprintf('%s.isPublished = :isPublished', $rootAlias))
->setParameter('isPublished', true);
}
}
See Code Block in Script
Code

Learn APIs

 >

API Platform 3 Part 2: Security for your Treasures

 >

Query Extension: Auto-Filter a Collection
24 lines | src/ApiPlatform/DragonTreasureIsPublishedExtension.php
// ... lines 1 - 10
class DragonTreasureIsPublishedExtension implements QueryCollectionExtensionInterface
{
public function applyToCollection(QueryBuilder $queryBuilder, QueryNameGeneratorInterface $queryNameGenerator, string $resourceClass, Operation $operation = null, array $context = []): void
{
if (DragonTreasure::class !== $resourceClass) {
return;
}
$rootAlias = $queryBuilder->getRootAliases()[0];
$queryBuilder->andWhere(sprintf('%s.isPublished = :isPublished', $rootAlias))
->setParameter('isPublished', true);
}
}
See Code Block in Script
Code

Learn Symfony 6

 >

Doctrine, Symfony 6 & the Database

 >

The Query Builder
67 lines | src/Repository/VinylMixRepository.php
// ... lines 1 - 16
class VinylMixRepository extends ServiceEntityRepository
{
// ... lines 19 - 41
/**
* @return VinylMix[] Returns an array of VinylMix objects
*/
public function findByExampleField($value): array
{
return $this->createQueryBuilder('v')
->andWhere('v.exampleField = :val')
->setParameter('val', $value)
->orderBy('v.id', 'ASC')
->setMaxResults(10)
->getQuery()
->getResult()
;
}
// ... lines 56 - 65
}
See Code Block in Script
Code

Learn Symfony 5

 >

Mastering Doctrine Relations

 >

Joining Across a ManyToMany
58 lines | src/Repository/QuestionRepository.php
// ... lines 1 - 15
class QuestionRepository extends ServiceEntityRepository
{
// ... lines 18 - 25
public function findAllAskedOrderedByNewest()
{
return $this->addIsAskedQueryBuilder()
->orderBy('q.askedAt', 'DESC')
->getQuery()
->getResult()
;
}
private function addIsAskedQueryBuilder(QueryBuilder $qb = null): QueryBuilder
{
return $this->getOrCreateQueryBuilder($qb)
->andWhere('q.askedAt IS NOT NULL');
}
// ... lines 40 - 56
}
See Code Block in Script
Code

Learn Symfony 5

 >

API Platform 2 Part 3: Custom Resources

 >

Custom Filter Logic for Entities
38 lines | src/ApiPlatform/CheeseSearchFilter.php
// ... lines 1 - 8
class CheeseSearchFilter extends AbstractFilter
{
protected function filterProperty(string $property, $value, QueryBuilder $queryBuilder, QueryNameGeneratorInterface $queryNameGenerator, string $resourceClass, string $operationName = null)
{
// ... lines 13 - 17
// a param name that is guaranteed unique in this query
$valueParameter = $queryNameGenerator->generateParameterName('search');
$queryBuilder->andWhere(sprintf('%s.title LIKE :%s OR %s.description LIKE :%s', $alias, $valueParameter, $alias, $valueParameter))
->setParameter($valueParameter, '%'.$value.'%');
}
// ... lines 23 - 36
}
See Code Block in Script
Code

Learn Symfony 5

 >

API Platform 2 Part 3: Custom Resources

 >

Custom Filter Logic for Entities
38 lines | src/ApiPlatform/CheeseSearchFilter.php
// ... lines 1 - 8
class CheeseSearchFilter extends AbstractFilter
{
protected function filterProperty(string $property, $value, QueryBuilder $queryBuilder, QueryNameGeneratorInterface $queryNameGenerator, string $resourceClass, string $operationName = null)
{
// ... lines 13 - 17
// a param name that is guaranteed unique in this query
$valueParameter = $queryNameGenerator->generateParameterName('search');
$queryBuilder->andWhere(sprintf('%s.title LIKE :%s OR %s.description LIKE :%s', $alias, $valueParameter, $alias, $valueParameter))
// ... line 21
}
// ... lines 23 - 36
}
See Code Block in Script
Code

Learn Symfony 5

 >

API Platform Part 2: Security

 >

Automatic 404 on Unpublished Items
45 lines | src/ApiPlatform/CheeseListingIsPublishedExtension.php
// ... lines 1 - 11
class CheeseListingIsPublishedExtension implements QueryCollectionExtensionInterface, QueryItemExtensionInterface
{
// ... lines 14 - 20
public function applyToCollection(QueryBuilder $queryBuilder, QueryNameGeneratorInterface $queryNameGenerator, string $resourceClass, string $operationName = null)
{
$this->addWhere($queryBuilder, $resourceClass);
}
// ... lines 25 - 30
private function addWhere(QueryBuilder $queryBuilder, string $resourceClass): void
{
if ($resourceClass !== CheeseListing::class) {
return;
}
if ($this->security->isGranted('ROLE_ADMIN')) {
return;
}
$rootAlias = $queryBuilder->getRootAliases()[0];
$queryBuilder->andWhere(sprintf('%s.isPublished = :isPublished', $rootAlias))
->setParameter('isPublished', true);
}
}
See Code Block in Script
Code

Learn Symfony 6

 >

EasyAdmin! For an Awesomely Powerful Admin Area

 >

Multiple Cruds for a Single Entity?
20 lines | src/Controller/Admin/QuestionPendingApprovalCrudController.php
// ... lines 1 - 4
use Doctrine\ORM\QueryBuilder;
use EasyCorp\Bundle\EasyAdminBundle\Collection\FieldCollection;
use EasyCorp\Bundle\EasyAdminBundle\Collection\FilterCollection;
use EasyCorp\Bundle\EasyAdminBundle\Dto\EntityDto;
use EasyCorp\Bundle\EasyAdminBundle\Dto\SearchDto;
class QuestionPendingApprovalCrudController extends QuestionCrudController
{
public function createIndexQueryBuilder(SearchDto $searchDto, EntityDto $entityDto, FieldCollection $fields, FilterCollection $filters): QueryBuilder
{
return parent::createIndexQueryBuilder($searchDto, $entityDto, $fields, $filters)
->andWhere('entity.isApproved = :approved')
->setParameter('approved', false);
}
}
See Code Block in Script
1 2 3 4 5