Datagrid – filters – query_builder

Hi,

I have this in services.yml:

parameters: mekit_list.datagrid_helper.class: Mekit\Bundle\ListBundle\Datagrid\ListDatagridHelper services: mekit_list.datagrid_helper: class: %mekit_list.datagrid_helper.class%

1 2 3 4 5 6

parameters:     mekit_list.datagrid_helper.class:                          Mekit\Bundle\ListBundle\Datagrid\ListDatagridHelper   services:     mekit_list.datagrid_helper:         class: %mekit_list.datagrid_helper.class%

this in a datagrid:

... filters: columns: name: type: string data_name: a.name type: type: entity data_name: accountType.id options: field_options: class: MekitListBundle:ListItem property: label multiple: true query_builder: @mekit_list.datagrid_helper->getListItemQueryBuilder ...

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

...         filters:             columns:                 name:                     type:      string                     data_name: a.name                 type:                     type:      entity                     data_name: accountType.id                     options:                       field_options:                         class:     MekitListBundle:ListItem                         property:  label                         multiple: true                         query_builder: @mekit_list.datagrid_helper->getListItemQueryBuilder ...

and this in the helpe class defined in services:

<?php namespace Mekit\Bundle\ListBundle\Datagrid; use Doctrine\ORM\Query; use Doctrine\ORM\EntityRepository; class ListDatagridHelper { /** * @return callable */ public function getListItemQueryBuilder() { return function (EntityRepository $er) { $ListGroupName = "ACCOUNT_TYPE"; return $er->createQueryBuilder('li') ->innerJoin("li.listGroup", "lg") ->where('lg.name = :list_group_name') ->orderBy('li.label', 'ASC') ->setParameter('list_group_name', $ListGroupName); }; } }

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

<?php namespace Mekit\Bundle\ListBundle\Datagrid;   use Doctrine\ORM\Query; use Doctrine\ORM\EntityRepository;   class ListDatagridHelper {   /** * @return callable */ public function getListItemQueryBuilder() { return function (EntityRepository $er) { $ListGroupName = "ACCOUNT_TYPE"; return $er->createQueryBuilder('li') ->innerJoin("li.listGroup", "lg") ->where('lg.name = :list_group_name') ->orderBy('li.label', 'ASC') ->setParameter('list_group_name', $ListGroupName); }; }   }

As you can guess I’d like to remove the $ListGroupName = "ACCOUNT_TYPE"; from my helper class and define in in the filter section of my datagrid definition.

How would you do that?

tnx
a\

---

oro/platform(1.6.2) + oro/doctrine-extensions(1.0.7) + symfony/symfony(v2.3.27)

Topic

[Alexandr SmagaParticipant]

Hello @jakabadambalazs !

Expression processed by this resolver. So for now you can make decision based on one of following data: grid name, config key where expression placed and full array starting from parent node. It seems for me that only grid name is useful for you now.

We have plans to move on our new resolver from config component that allow to configure any count of parameters to pass to the method call, but it’s not in the nearest time, so any help on this is appreciated.

[jakabadambalazsParticipant]

Thanks, I have checked on SystemAwareResolver but suddenly (as many times before it has happened to me with Sf) I realized that I was over-complicating something that is quite simple really.

I have injected my ListItemRepository into the ‘helper’ service:

services: mekit_list.datagrid_helper: class: %mekit_list.datagrid_helper.class% arguments: - @mekit_list.list_item_repository mekit_list.list_item_repository: class: Doctrine\ORM\EntityRepository factory_service: doctrine.orm.entity_manager factory_method: getRepository arguments: - 'MekitListBundle:ListItem'

1 2 3 4 5 6 7 8 9 10 11 12 13 14

services:     mekit_list.datagrid_helper:         class: %mekit_list.datagrid_helper.class%         arguments:             - @mekit_list.list_item_repository       mekit_list.list_item_repository:         class: Doctrine\ORM\EntityRepository         factory_service: doctrine.orm.entity_manager         factory_method: getRepository         arguments:             - 'MekitListBundle:ListItem'

and I modified the above method with a ‘very ugly’ but functional version:

/** * @todo: works but very ugly! - we need custom type (extending entity type) where we can specify "group_name" explicitly * @return \Doctrine\ORM\QueryBuilder */ public function getListItemQueryBuilderForGroup() { $args = func_get_args(); if(isset($args) && isset($args[2]) && isset($args[2]["attr"]) && isset($args[2]["attr"]["group_name"])) { return($this->listItemRepository->getListItemQueryBuilder($args[2]["attr"]["group_name"])); } else { throw new \LogicException("Missing 'group_name' parameter in passed arguments: " . json_encode($args)); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14

/** * @todo: works but very ugly! - we need custom type (extending entity type) where we can specify "group_name" explicitly * @return \Doctrine\ORM\QueryBuilder */ public function getListItemQueryBuilderForGroup() { $args = func_get_args(); if(isset($args) && isset($args[2]) && isset($args[2]["attr"]) && isset($args[2]["attr"]["group_name"])) { return($this->listItemRepository->getListItemQueryBuilder($args[2]["attr"]["group_name"])); } else { throw new \LogicException("Missing 'group_name' parameter in passed arguments: " . json_encode($args)); } }

and now I can use it from datagrid.yml like this:

filters: columns: ... type: type: entity data_name: accountType.id options: field_options: class: MekitListBundle:ListItem property: label query_builder: @mekit_list.datagrid_helper->getListItemQueryBuilderForGroup attr: group_name: 'ACCOUNT_TYPE' multiple: true ...

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

filters:             columns:                 ...                 type:                     type:      entity                     data_name: accountType.id                     options:                       field_options:                         class:     MekitListBundle:ListItem                         property:  label                         query_builder: @mekit_list.datagrid_helper->getListItemQueryBuilderForGroup                         attr:                             group_name: 'ACCOUNT_TYPE'                         multiple: true                 ...

The thing is ‘ugly’ because I did not have time to create a specific type for this so I am using the ‘entity’ type and I am (improperly) relying on the ‘attr’ property.

but it works – just needs some polishing up

Thanks anyways. As for allowing to pass parameters to method call I would not know where to start – for now I am just getting a taste of OroPlatform and for me it seems a task bigger than my present capabilities.

Thanks for your help
a\

---

oro/platform(1.6.2) + oro/doctrine-extensions(1.0.7) + symfony/symfony(v2.3.27)

[Author]

Replies