README

Symfony Datatables

Symfony bridge for JS DataTables: builds Doctrine Criteria for filtering, search, ordering and pagination from the request, and serializes the server-side response as JSON.

Documentation

Full documentation is available at trinetus.gitlab.io/symfony-datatables.

Requirements

• PHP 8.0+
• Symfony 6 or 7 (serializer, http-foundation, property-access)
• Doctrine Collections 1.6+ or 2.0+

Installation

composer require trinetus/symfony-datatables

Quick Start

Use the trait in a controller and let it build the Doctrine Criteria from the request:

use Doctrine\Common\Collections\Criteria;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Trinetus\SymfonyDatatables\Traits\DatatablesControllerTrait;

class ProductController extends AbstractController
{
    use DatatablesControllerTrait;

    public function list(Request $request, ProductRepository $repository): Response
    {
        $this->setRequest($request);

        $criteria = $this->getFilterCriteria();
        $criteria = $this->getSearchCriteria(['title', 'description'], $criteria);

        $query = $repository->findByCriteria($criteria);
        $totalRecords = $repository->countFromQuery($query);

        $rows = $query->addCriteria($this->getPaginationCriteria())->getQuery()->getResult();

        return $this->datatablesJson($rows, $totalRecords);
    }
}

See Usage for the request parameters, repository helpers, and serialization options.

Links

• Documentation
• Upgrade to Symfony 6/7
• Changelog

License

The MIT License. See LICENSE for details.