survos/api-grid-bundle

incorporate DatatablesNet, using twig and stimulus, twig_component requires ^2.2

1.5.103 2023-12-03 20:36 UTC

Requires

• php: ^8.1
• doctrine/doctrine-bundle: ^2.7
• doctrine/orm: ^2.12
• doctrine/persistence: ^2.0 || ^3.0
• survos/inspection-bundle: ^1.5.103
• symfony/config: ^6.3 || ^7.0
• symfony/dependency-injection: ^6.3 || ^7.0
• symfony/dom-crawler: ^6.3 || ^7.0
• symfony/http-kernel: ^6.3 || ^7.0
• symfony/options-resolver: ^6.3 || ^7.0
• symfony/ux-twig-component: ^2.13
• twig/twig: ^3.8

Requires (Dev)

• api-platform/core: ^3.2
• phpstan/phpstan: ^1.8
• roave/security-advisories: dev-latest
• symfony/browser-kit: ^6.3 || ^7.0
• symfony/framework-bundle: ^6.3 || ^7.0
• symfony/phpunit-bridge: ^6.3 || ^7.0
• symfony/twig-bundle: ^6.3 || ^7.0
• symfony/var-dumper: ^6.3 || ^7.0

Suggests

• api-platform/core: For javascript-based grid rendering
• friendsofsymfony/jsrouting-bundle: use path() in javascript grid rendering
• monolog/monolog: Allows more advanced logging of the application flow

MIT

• Tac Tacelosky

• symfony-ux
• symfony6

README

Use the DataTables.net javascript library with Symfony, Twig and API Platform. requires survos/grid-bundle, which loads the datatables libraries.

composer req survos/api-grid-bundle

Ideas

Import the datasets at https://domohelp.domo.com/hc/en-us/articles/360043931814-Fun-Sample-DataSets https://www.mytechylife.com/2015/09/29/next-and-previous-row-with-jquery-datatables/ https://github.com/lerocha/chinook-database http://2016.padjo.org/tutorials/sqlite-data-starterpacks/#more-info-simplefolks-for-simple-sql

Dev only...

composer config repositories.survos_grid_bundle '{"type": "vcs", "url": "[e-mail]:survos/SurvosApiGridBundle.git"}'

setup

Inorder to use api-grid we need to follow below:

1) Add Survos\CoreBundle\Traits\QueryBuilderHelperTrait in your repository class of the entity for which you want apiGrid

2) you need to set columns variable like below:

        {% set columns = [
        'code',
        'description',
        {name: 'code', sortable: true},
        'description',
        {name: 'countrycode', sortable: true,  browsable: true, searchable: true},
        {name: 'privacyPolicy', browsable: true},
        {name: 'projectLocale', browsable: true},
        ] %}

By default, sortable, browsable, searchable are false.

For those columns you want sortable add sortable: true

For those columns you want to add searchPanes add browsable: true

For those columns you want to add searchable: true

3) For search you need to include below

use Survos\ApiGrid\Api\Filter\MultiFieldSearchFilter;


#[ApiFilter(MultiFieldSearchFilter::class, properties: ['name', 'code'])]

Here name and code are columns in which you need to search

4) Use below for doctrine searchpane filters

First, make sure you have the necessary counts method by adding the helper trait to the repository class

class OfficialRepository extends ServiceEntityRepository implements QueryBuilderHelperInterface
{
    use QueryBuilderHelperTrait;

Then add the filterable properties to the entity class. You may want to index them to speed up the count query

use Survos\ApiGrid\Api\Filter\FacetsFieldSearchFilter;


#[ApiFilter(FacetsFieldSearchFilter::class, properties: ['gender','state'])]

5) Use below for doctrine order filters

use ApiPlatform\Doctrine\Orm\Filter\OrderFilter;


#[ApiFilter(OrderFilter::class, properties: ['id','objectCount','countryCode'])]