Sort and filter contacts by group

In Oro 1.2 there was a Group filter and sorter in contact grid. In version 1.3 it is removed. Implementation from version 1.2 doesn’t work due to a bug. How can i add this filter/sorter?

Topic

[klipachParticipant]

There is no answer for a long time… so i found some solution, it is not perfect but it works. You can add filter functionality by adding custom filter class. Here is an example:

GroupFilter.php

<?php namespace Acme\DemoBundle\Filter; use Oro\Bundle\FilterBundle\Filter\EntityFilter; use Oro\Bundle\FilterBundle\Datasource\FilterDatasourceAdapterInterface; class GroupFilter extends EntityFilter { /** * {@inheritdoc} */ public function apply(FilterDatasourceAdapterInterface $ds, $data) { $data = $this->parseData($data); if (!$data) { return false; } $i = 1; foreach ($data['value'] as $group) { $ds->getQueryBuilder() ->andWhere('(:group' . $i . ' MEMBER OF c.groups )') ->setParameter('group' . $i, $group->getId()); $i++; } return true; } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

<?php   namespace Acme\DemoBundle\Filter;   use Oro\Bundle\FilterBundle\Filter\EntityFilter; use Oro\Bundle\FilterBundle\Datasource\FilterDatasourceAdapterInterface;   class GroupFilter extends EntityFilter {     /**      * {@inheritdoc}      */     public function apply(FilterDatasourceAdapterInterface $ds, $data)     {         $data = $this->parseData($data);           if (!$data) {             return false;         }           $i = 1;         foreach ($data['value'] as $group) {             $ds->getQueryBuilder()                 ->andWhere('(:group' . $i . ' MEMBER OF c.groups )')                 ->setParameter('group' . $i, $group->getId());             $i++;         }           return true;     } }

Register this filter in filters.yml

parameters: oro_filter.group_filter.class: Acme\DemoBundle\Filter\GroupFilter services: oro_filter.group_filter: class: %oro_filter.group_filter.class% arguments: - @form.factory - @oro_filter.filter_utility tags: - { name: oro_filter.extension.orm_filter.filter, type: group }

1 2 3 4 5 6 7 8 9 10 11

parameters:     oro_filter.group_filter.class:              Acme\DemoBundle\Filter\GroupFilter   services:     oro_filter.group_filter:         class: %oro_filter.group_filter.class%         arguments:             - @form.factory             - @oro_filter.filter_utility         tags:             - { name: oro_filter.extension.orm_filter.filter, type: group }

don’t forget to load filters.yml in DependencyInjection/AcmeDemoExtension.php

now you can use this filter in contact datagrid using eventListener like here https://github.com/orocrm/crm/blob/master/src/OroCRM/Bundle/CallBundle/EventListener/Datagrid/CallListener.php like

$config->offsetSetByPath( '[filters][columns][groupLabelsAsString]', array( 'type' => 'group', 'data_name' => 'contactGroup.id', 'enabled' => true, 'options' => array( 'field_options' => array( 'class' => 'OroCRMContactBundle:Group', 'property' => 'label', 'multiple' => true, ) ) ) );

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

$config->offsetSetByPath(     '[filters][columns][groupLabelsAsString]',         array(             'type' => 'group',              'data_name' => 'contactGroup.id',              'enabled' => true,              'options' =>                  array(                      'field_options' =>                          array(                              'class' => 'OroCRMContactBundle:Group',                              'property' => 'label',                              'multiple' => true,                          )                  )          )     );

or in datagrid.yml

groupLabelsAsString: type: group data_name: contactGroup.id enabled: true options: field_options: class: OroCRMContactBundle:Group property: label multiple: true

1 2 3 4 5 6 7 8 9 10 11

groupLabelsAsString:     type: group     data_name: contactGroup.id     enabled: true     options:         field_options:             class: OroCRMContactBundle:Group             property: label             multiple: true

[klipachParticipant]

Is there a better way to do such filtering?

[Author]

Replies