Hello, I tried to prepare an internal bundle for symfony 6 and ran into an issue:

PHP Fatal error:  Declaration of Omines\DataTablesBundle\DataTablesBundle::getContainerExtension() must be compatible with Symfony\Component\HttpKernel\Bundle\Bundle::getContainerExtension(): ?Symfony\Component\DependencyInjection\Extension\ExtensionInterface in /vendor/omines/datatables-bundle/src/DataTablesBundle.php on line 40

This issue, and the ones that would follow, was resolved by adding the required return types.

Additionally, running the tests locally with symfony 6 showed 3 more issues, 2 of which I could easily resolve by replacing static::$container with static::getContainer(). The other one however, I did not figure out. I don't think the test suites will be executed on symfony 6 with the current CI configuration, so that should not be a problem.

Please let me know if anything else should happen before this PR can be accepted / reviewed

Hello everyone. Im new to omines/datatables-bundle and I have problem displaying search.

I was studying your documentation and was not able to get it working. Ive created a table like this

$table = $dataTable->create()
          ->add('street', TextColumn::class, ["label" => "Street", "searchable" => true, "globalSearchable" => true])
          ->add('houseNumber', TextColumn::class, ["label" => "House number", "searchable" => true])
          ->add('postal', TextColumn::class, ["label" => "Postal Code", "searchable" => true])
          ->add('city', TextColumn::class, ["label" => "City", "searchable" => true])
          ->add('country', TextColumn::class, ["label" => "Country", "searchable" => true])
          ->createAdapter(ORMAdapter::class, [
            'entity' => CustomAddress::class,
          ])
          ->handleRequest($request);

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

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

Also, in my twig template

<div id="addresses">Loading...</div>
    <script src="{{ asset('bundles/datatables/js/datatables.js') }}"></script>
    <script>
        $(function() {
            $('#addresses').initDataTables({{ datatable_settings(datatable) }}, { searching: true });
        });
    </script>

The datatable works fine, sorting is working etc, but I dont see the search input field.How should I configure it to display it?

Hi, I've been searching around for a while now but I can't figure out how to pass custom parameters to the datatable upon building, so that every consecutive AJAX call would have those in the POST.

In my example, the user gets to a search page with a query parameter ?q=..., then the controller builds the datatable and embed this query in its options. The page is displayed, the AJAX call is performed, and I can retrieve this query to use it inside the criteria option of the adapter when the results are built.

I've tried searching for options on the PHP side but found none. Then I've tried using the preXhr in JS but it seems to be ignored by the custom wrapper of the bundle.

Any hint?

First of all thanks for nice approach to the problem.

However I'm kind of stuck at the moment, any chance to shed a light on following exception I'm facing?

Iterate with fetch join in class App\Entity\CategoryTranslation using association translatable not allowed.

This is custom query I use:

->createAdapter(ORMAdapter::class, [
    'entity' => Category::class,
    'query' => function (QueryBuilder $builder) {
        $builder
            ->select('c', 't')
            ->from(Category::class, 'c')
            ->leftJoin('c.translations', 't', Expr\Join::WITH, 't.locale = :locale')
            ->setParameter('locale', $this->locale)
        ;
    },

There is only one translation being shown in the listing at one time - can this be fixed by changing hydration type? I'm fairly new to doctrine as well, is possible to solve this kind of problem at all? I know that iterate has some limits, but maybe I'm missing something obvious.

Also I have a question regarding custom types - is possible to use repositories when creating an adapter?

Translations provided in options create conflict with JS datatables events. I'm not sure if the issue is caused by contents of translation keys or it is known issue with JS library. Unfortunately locale in format 'fr_FR' forces Symfony translations instead of CDN URL.

One possible solution can be:

$locale = $this->translator->getLocale();
$locale = \Locale::getPrimaryLanguage($locale);

This pull request aims to add a possibility to postpone rendering of a cell until the end. Using this, one can have a DataLoader that batches all calls that are needed to render a cell and make a single call instead of one per cell.

Hi,

I have problem with relation in DT.

My 2 entitys:

class TransportEntity extends BaseInstitutionEntity
{
    /**
     * @var Collection|null
     *
     * @ORM\OneToMany(targetEntity="TransportElementEntity", mappedBy="transport", cascade={"persist", "remove"})
     */
    private $elements;
}

class TransportElementEntity extends BaseInstitutionEntity
{
    /**
     * @var TransportEntity
     *
     * @ORM\ManyToOne(targetEntity="\App\Entity\PaintThis\TransportEntity", inversedBy="elements")
     * @Gedmo\Versioned
     */
    private $transport;
}

I try get count element in field in Table.

My table is:

->add(
    'number',
    TextColumn::class
)
->add(
    'dateArrive',
    DateTimeColumn::class
)
->add(
    'status',
    TextColumn::class
)
->add(
    'elements',
    TextColumn::class
)
->add(
    'id',
    TextColumn::class
);

createAdapter(
    ORMAdapter::class,
    [
        'entity' => TransportEntity::class,
        'query' => function (QueryBuilder $builder) use ($options) {
            $builder
                ->select('transport')
                ->addSelect('COUNT(elements.id)')
                ->from(TransportEntity::class, 'transport')
                ->leftJoin(TransportElementEntity::class, 'elements', Join::WITH, 'transport.id = elements.transport')
                ->groupBy('transport.id')
                ->orderBy('transport.id', 'DESC');
        },
    ]
)

How can i get get count elements in DT?

Hey. The bundle promises to be very good. More comfortable to use than stwe. I have a problem. In the case of ORM inheritance, the field option does not read data - the columns are empty. It also does not throw any exception. Am I doing something wrong, is there really no support? I solved this problem in such a way that I process context in a callback render, but it would be nice if support for inheritance would exist. P.S Sorry for my bad english

` // ... @ORM\InheritanceType("JOINED") abstract class Address { private $id; }

// ... class OrderAddress extends Address { }

class Order {

@ORM\ManyToOne(targetEntity=OrderAddress::class, cascade={"persist"}) private $address; }

// ... in Controller ->add('address', TextColumn::class, [ 'field' => 'address.id' // not working ])

`

hi. Im trying to add some additional filters for table:

$('#presidents').initDataTables({{ datatable_settings(datatable) }}, {
                    searching: true,
                    dom: '<"html5buttons"B>lTfgitp',
                    pagingType: "numbers",
                    ajax: {
                        data: function (d) {
                            d.environment_id = $('#environment').val();
                        }
                    }
                }).then(function (dt) {
                    dt.on('draw', function () {

                    })
                }); 

But as I can see

data: function (d) {
                            d.environment_id = 207;
                        }

was ignoring and requests sent without it. How I can fix it?

This Bundle only allows server side processing. This raises an issue when it comes to use the HTML5 export buttons. These buttons only export the current page (as the DOM is only aware of the current page).

This pull request aims to fix this limitation.

Usage

I suggest you look at the ExporterController and the exporter.html.twig file for a complete usage example.

How it works

Front-end

https://github.com/MaximePinot/datatables-bundle/blob/10e586c98cb3c4f2f167828a932ef9180551e33d/tests/Fixtures/AppBundle/Resources/views/exporter.html.twig#L11-L26

Adding an export button must be handled by the front-end developer as it is not the Bundle's concern to manage/render anything. As the Bundle still needs some specific parameters to be sent, I created a function that generates the function needed by the action option.

Back-end

Everything is handled automatically by the Bundle and its current structure (isCallback / getResponse) is not changed (see this piece of code).

To trigger an "export state", the request must be sent with a _exporter parameter (along with the usual _dt parameter) whose value is the name of the DataTable exporter (defined by the getName() method).

At the moment, I only created an Excel exporter. I think the Bundle should be shipped with a few common exporters such as PDF, CSV and HTML. I plan to add these three, but I want to be sure that my implementation is correct before.

Anyone can add a DataTable exporter to its project by creating a service class that implements the Omines\DataTablesBundle\Exporter\DataTableExporterInterface. The service must be tagged with datatables.exporter.

Documentation

I did not write any documentation yet. I first want to be sure that my implementation is correct. When this pull request is ready to be merged. I will add a commit that adds a Server side export section to the documentation.

Hi I have 2 tables related to each other with a ManyToOne relation. I wanted now to display in my datatable the data from the relationship and I thought I would make use of a join or so but that doesn't seem to work. Taking your example here: $table->createAdapter(ORMAdapter::class, [ 'entity' => Employee::class, 'query' => function (QueryBuilder $builder) { $builder ->select('e') ->addSelect('c') ->from(Employee::class, 'e') ->leftJoin('e.company', 'c') ; }, ]);
and assuming comapny has a field label I thought I could use than c.label to display the text but that doesn't work. Just getting an error that can't do anything with that field.

Do you have any idea what I could do? Maybe I'm doing something wrong as I'm very new in dev this could easily be especially as I'm not working daily with that.

Hi, i want to know how to apply the search to relationnal, i have project table and project_reference on other table and is link by OneToMany relation, for display the last and list of reference is ok, but when i want to search by reference DT return nothing

 ->add('references', TextColumn::class, [
                'label' => 'Référence',
                'field' => 'p.references',
                'searchable' => false
            ])
    
            ->add('oldRefe', TextColumn::class, [
                'label' => 'Old Refe',
                'raw' => true,
                'render' => function($value, $context) {
                    $str = '';
                    foreach ($context->getReferences( false ) as $ref) {
                        $str .= $ref->getReference() . ' ';
                    }
                    return $str;
                },
                'searchable' => true
            ])

And search result with example : 1234 search

How to apply the search to project reference code ? To return all project have this reference on project.references table ?

Thx

Added an adapter that lets you use a basic 'query' to create a datatable.

Usage example:

        use Doctrine\DBAL\Connection;

       ...

        $table = $this->dataTableFactory->create()
            ->createAdapter(QueryBuilderAdapter::class, [
                'queryBuilder' => $this->connection->createQueryBuilder()
                    ->select('*')
                    ->from('someTable')
            ])->...

Limitations:

• Support for column search has not been implemented. Global search, sorting etc. is working properly.

solved #243

Also updated the docs. Should not break any backward compatibility. Simply allows bundle users to extend the new abstract class and configure options using symfony's OptionResolver for DataTableTypes (similar to symfony formTypes)

I've created an ArrayObjectAdapter based on ArrayAdapter as usable replacement and/or enhancement of the existing ArrayAdapter.

It may be useful for other developers and maybe it could help to #7

Hello, maybe I didn't search docs deeply, but I am not able to get column filter displayed. I have this setup.

Controller:

 $userFilter = new ChoiceFilter();
        $userFilter->set([
            'choices' => ['foo' => 'bar', 'bar' => 'baz']
        ]);
        $table = $dataTableFactory->create()
        ->add('created_at', DateTimeColumn::class, ['label' => 'Datum', 'format' => 'j.n.Y H:i', "searchable" => false])
        ->add('userName', TextColumn::class, [
            'label' => 'Uživatel',
            "searchable" => true,
            'render' => function ($value, $context) {
                $user = $context->getUser();

                return $user ? $user->getFirstname().' '.$user->getLastname() : '';
            },
            'filter' => $userFilter
        ])->createAdapter(ORMAdapter::class, [
                'entity' => Copy::class,
            ])
            `->handleRequest($request);

datatables.yaml

# Latest documentation available at https://omines.github.io/datatables-bundle/#configuration
datatables:
    # Set options, as documented at https://datatables.net/reference/option/
    options:
        lengthMenu : [10, 25, 50, 100, 250, 500, 1000, 2500]
        pageLength: 50
        dom: "<'row' <'col-sm-12' ftr>><'row' <'col-sm-6'l><'col-sm-6 text-right'pi>>"
        searching: true

    template_parameters:
        # Example classes to integrate nicely with Bootstrap 3.x
        className: 'table table-striped table-bordered table-hover data-table'
        columnFilter: "both"

    # You can for example override this to "tables" to keep the translation domains separated nicely
    translation_domain: 'messages'

I am not able to see column filter. What is wrong? Setup or datatable template. Thanks for reply.

I noticed that there's an issue regarding query creation - in the event that only fields that do something during render are specified the table will fail to load outright and Doctrine will throw an error about expecting an expression, as the generated query looks like this:

SELECT FROM [entity] [alias]

The fix is simple, if nothing is being selected simply find the primary key and select that instead. The two COUNT calls seem to run just fine, as they search for ids by default so there's no issue there.