Omines資料表自定義查詢不起作用

我正在使用捆綁包 Omines 在 Symfony 5 中創建資料表，并且我撰寫了一個自定義查詢。但是，當我這樣做時，視圖中的搜索不起作用。

我該如何解決？

這是我的代碼：

控制器

$table = $dataTableFactory->create()
            ->add('fullName', TextColumn::class, [
                'label' => 'Full Name',
                'propertyPath' => '[fullName]',
                'searchable' => true,
            ])
            ->createAdapter(ORMAdapter::class, [
                'entity' => Person::class,
                'hydrate' => AbstractQuery::HYDRATE_ARRAY,
                'query' => function (QueryBuilder $builder) {
                    $builder
                        ->select('p.id, CONCAT(p.firstName, \' \', p. middleName, \' \', p.lastName) AS fullName')
                        ->from(Person::class, 'p');
                },
            ])
            ->handleRequest($request);

        if ($table->isCallback()) {
            return $table->getResponse();
        }

        return $this->render('person/index.html.twig', [
            'datatable' => $table,
        ]);

資料表.html.twig

{% extends 'base.html.twig' %}

{% block stylesheets %}
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/bs5/jq-3.6.0/dt-1.11.2/b-2.0.0/fh-3.1.9/r-2.2.9/datatables.min.css"/>
{% endblock %}

{% block javascripts %}
    <script type="text/javascript" src="https://cdn.datatables.net/v/bs5/jq-3.6.0/dt-1.11.2/b-2.0.0/fh-3.1.9/r-2.2.9/datatables.min.js"></script>
    <script src="{{ asset('bundles/datatables/js/datatables.js') }}"></script>
    <script>
        $(function () {
            $('#table').initDataTables({{ datatable_settings(datatable) }}, {
                searching: true,
                fixedHeader: true,
                responsive: true,
            });
        });
    </script>
{% endblock %}

index.html.twig

{% extends 'datatables.html.twig' %}

{% block title %}List{% endblock %}

{% block body %}
    <div id="table">Loading...</div
{% endblock %}

編輯

搜索詞是 fullName 別名。我試過像這樣的自定義criteria_query：

 ->createAdapter(ORMAdapter::class, [
                'entity' => Person::class,
                'hydrate' => AbstractQuery::HYDRATE_ARRAY,
                'query' => function (QueryBuilder $builder) {
                    $builder
                        ->select('p.id, CONCAT(p.firstName, \' \', p. middleName, \' \', p.lastName) AS fullName')
                        ->from(Person::class, 'p');
                },
                'criteria' => [
                    function (QueryBuilder $builder) {
                        $builder->andWhere($builder->expr()->like('CONCAT(p.firstName, \' \', p.middleName, \' \', p.lastName)', ':fullName'))->setParameter('fullName', '%%');
                    },
                    new SearchCriteriaProvider(),
                ],
            ])

但我不確定如何檢索資料表搜索欄位的值以用作“%%”中的引數

uj5u.com熱心網友回復：

解決方案：

use Doctrine\ORM\AbstractQuery;
use Doctrine\ORM\QueryBuilder;
use Omines\DataTablesBundle\Adapter\Doctrine\ORMAdapter;
use Omines\DataTablesBundle\DataTableState;

....

->createAdapter(ORMAdapter::class, [
                'entity' => Person::class,
                'hydrate' => AbstractQuery::HYDRATE_ARRAY,
                'query' => function (QueryBuilder $builder) {
                    $builder
                        ->select('p.id, CONCAT(p.firstName, \' \', p. middleName, \' \', p.lastName) AS fullName')
                        ->from(Person::class, 'p');
                },
                'criteria' => [
                    function (QueryBuilder $builder, DataTableState $state) {
                        $term = strtolower($state->getGlobalSearch());
                        $builder->andWhere($builder->expr()->like('LOWER(CONCAT(p.firstName, \' \', p.middleName, \' \', p.lastName))', ':fullName'))->setParameter('fullName', '%' . $term . '%');
                    },
                    new SearchCriteriaProvider(),
                ],
            ])

標籤：symfony 数据表 教义

上一篇：Symfony5無法將代碼部署到服務器，權限問題

下一篇：SonataAdminBundle4.5ListView：再次直接鏈接到/edit而不是/show