With SonataAdminBundle. Configure filter on a two step related entity

Question

I'd like to know weather is possible and how to configure a filter for the list view as the following with SonataAdminBundle in Symfony 2

Say I have entities Order, pointing to entities User, pointing to entities Company. I want to configure filters both for filtering by User and also for filtering by Company (User's Company) The first is straight forward. The second is what I try to clearify.

In the class OrderAdmin I would overwrite configureDatagridFilters as:

protected function configureDatagridFilters(DatagridMapper $datagridMapper)
{
     $datagridMapper
         ->add('created_at')
         //... some other filters on Order fields, as usual

         // the filter on User, provided 'user', no ploblem
         ->add('user')

         // and the filter by Company 
         ->add('user.company') // this doesn't work, of course
    ;
}

That syntax for the company filter is inpired by sonta docs: http://sonata-project.org/bundles/doctrine-orm-admin/2-0/doc/reference/filter_field_definition.html

Is not intended for what I try to acomplish, but cannot find where to look at.

Hope someone has a clue on this.

Thanks

score 16 · Accepted Answer · edited May 23 '17 at 12:17

Finally I found an answer guided by this other question: How can I create a custom DataGrid filter in SonataAdmin and a closer read of the sonata admin docs link I pasted in my question.

In case someone have this issue and taking the previous example:

protected function configureDatagridFilters(DatagridMapper $datagridMapper)
{
   $datagridMapper

      //... whatever filter

      // and the filter by Company 

      ->add('company', 'doctrine_orm_callback', array(
            'callback'   => array($this, 'callbackFilterCompany'),
            'field_type' => 'checkbox'
            ),
    'choice', 
    array('choices' => $this -> getCompanyChoices())
;
}

where the method getCompanyChoices retrieves an associative array of company ids => company names (for instance). And the method callbackFilterCompany is as follows

public function callbackFilterCompany ($queryBuilder, $alias, $field, $value)
{
    if(!is_array($value) or !array_key_exists('value', $value) 
        or empty($value['value'])){

        return;

    }

    $queryBuilder
    ->leftJoin(sprintf('%s.user', $alias), 'u')
    ->leftJoin('u.company', 'c')
    ->andWhere('c.id = :id')
    ->setParameter('id', $value['value'])
    ;

    return true;
}

This helped me with a minor change: instead of empty($value['value']) I would prefer is_null($value['value']) because empty(int(0)) is evaluated to true. Thanks a lot for your solution. — Calin Blaga, Mar 02 '17 at 08:34

score 2 · Answer 2 · answered Jun 16 '14 at 09:32

2

It is well documented on the official website : http://sonata-project.org/bundles/doctrine-orm-admin/master/doc/reference/filter_field_definition.html

answered Jun 16 '14 at 09:32

Damien Ingrand

193
10

1

yeah, I guess that in nov 2012 that was not the case yet ;-) – javigzz Jun 23 '14 at 20:15
1

but it is now, so why downvote it.. it's still a correct relevant answer – NDM May 27 '15 at 18:39

With SonataAdminBundle. Configure filter on a two step related entity

2 Answers2