Symfony EasyAdminBundle 3 重写 createIndexQuer

Question

EasyAdminBundle 文档上说例如，index() 操作调用名为 createIndexQueryBuilder() 的方法来创建用于获取索引列表上显示的结果的 Doctrine 查询构建器。如果您想自定义该列表，最好重写 createIndexQueryBuilder() 方法而不是整个 index() 方法。因此，让我们想象一下，当用户被删除时，我在用户实体中将字段 isDeleted 设置为 true。在索引页面中，我想仅显示 isDeleted = false 的用户。如何为此目的重写 createIndexQueryBuilder() ？这是方法 createIndexQueryBuilderpublic function createIndexQueryBuilder(SearchDto $searchDto, EntityDto $entityDto, FieldCollection $fields, FilterCollection $filters): QueryBuilder{    return $this->get(EntityRepository::class)->createQueryBuilder($searchDto, $entityDto, $fields, $filters);}我尝试像这样覆盖它，但没有成功public function createIndexQueryBuilder(SearchDto $searchDto, EntityDto $entityDto, FieldCollection $fields, FilterCollection $filters): QueryBuilder{    $response = $this->get(EntityRepository::class)->createQueryBuilder($searchDto, $entityDto, $fields, $filters);    $response->where('isDeleted', true);    return $response;}

Answer 1

您所需要的只是在 where 子句中添加entity.:)

public function createIndexQueryBuilder(SearchDto $searchDto, EntityDto $entityDto, FieldCollection $fields, FilterCollection $filters): QueryBuilder

{

    parent::createIndexQueryBuilder($searchDto, $entityDto, $fields, $filters);

    $response = $this->get(EntityRepository::class)->createQueryBuilder($searchDto, $entityDto, $fields, $filters);

    $response->where('entity.isDeleted = 1');

    return $response;

}

Answer 2

这对我的 EasyAdmin 4.x 有用

use EasyCorp\Bundle\EasyAdminBundle\Orm\EntityRepository;

class CampaignCrudController extends AbstractCrudController

{

    public function __construct(EntityRepository $entityRepository)

    {

        $this->entityRepository = $entityRepository;

    }

    public function createIndexQueryBuilder(SearchDto $searchDto, EntityDto $entityDto, FieldCollection $fields, FilterCollection $filters): ORMQueryBuilder

    {

        $response = $this->entityRepository->createQueryBuilder($searchDto, $entityDto, $fields, $filters);

        $response->andWhere('entity.user = :user')->setParameter('user', $this->getUser());

        return $response;

    }

Answer 3

EasyAdmin4解决方案

注意：关键字（别名）entity很重要

use Doctrine\ORM\QueryBuilder;

class ArticleCrudController extends AbstractCrudController

{

     ...

     public function configureFields(string $pageName): iterable

     {

          return [

                ...

                AssociationField::new('author')->setQueryBuilder(

                fn (QueryBuilder $queryBuilder) => $queryBuilder

                   ->leftJoin('entity.article', 'a')

                   ->andWhere('entity.isActive = 1')

                   ->andWhere('a.author is NULL')

                  ),

                ...

            ]

      }

      ...

}

Answer 4

对于每个使用接受的答案并通过搜索找到以下 QueryException 的人：

QueryException 

Too many parameters: the query defines 1 parameters and you bound 3

EntityCrudController 内的 EasyAdmin v3.x：

使用->andWhere()函数

使用实体。作为前缀（实际上，使用“实体”，不要替换为您的实体名称）

public function createIndexQueryBuilder(SearchDto $searchDto, EntityDto $entityDto, FieldCollection $fields, FilterCollection $filters): QueryBuilder

{

    $response = $this->get(EntityRepository::class)->createQueryBuilder($searchDto, $entityDto, $fields, $filters);

    $response->andWhere('entity.isDeleted = 1');   

    return $response;

}