How to use datagrid binded parameter as route parameter?

Hi,

I tried to use a binded parameter as a parameter for a delete route. But i do not want to select the column id as in the select list because i get a group by it.

I need something like this:

YAML

query: select: - pv.id - > MAX(CASE WHEN (ev.id IS NULL) THEN 0 ELSE ev.status END) as available from: - { table: %panel_views.entity.class%, alias: pv } join: left: - join: pv.reservations alias: r - join: pv.events alias: ev where: and: - :reservation MEMBER OF pv.reservations bind_parameters: - reservation ... properties: id: ~ rid: reservation # HERE IS THE PROBLEM delete_link: type: url route: xxx_reservation_api_delete_reservation_pview params: rid: rid id: id

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 33 34 35

query:                 select:                     - pv.id                     - >                         MAX(CASE WHEN (ev.id IS NULL) THEN                             0                           ELSE                             ev.status                           END) as available                 from:                     - { table: %panel_views.entity.class%, alias: pv }                 join:                     left:                         -                             join: pv.reservations                             alias: r                         -                             join: pv.events                             alias: ev                   where:                     and:                         - :reservation MEMBER OF pv.reservations             bind_parameters:                 - reservation ...         properties:             id: ~             rid: reservation   # HERE IS THE PROBLEM             delete_link:                 type:         url                 route:        xxx_reservation_api_delete_reservation_pview                 params:                     rid: rid                     id: id

It could be done like this:

YAML

query: select: - pv.id - r.id as rid - > MAX(CASE WHEN (ev.id IS NULL) THEN 0 ELSE ev.status END) as available from: - { table: %panel_views.entity.class%, alias: pv } join: left: - join: pv.reservations alias: r - join: pv.events alias: ev where: and: - :reservation MEMBER OF pv.reservations bind_parameters: - reservation ... properties: id: ~ rid: r.id delete_link: type: url route: xxx_reservation_api_delete_reservation_pview params: rid: rid id: id

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 33 34 35 36

query:                 select:                     - pv.id                     - r.id as rid                     - >                         MAX(CASE WHEN (ev.id IS NULL) THEN                             0                           ELSE                             ev.status                           END) as available                 from:                     - { table: %panel_views.entity.class%, alias: pv }                 join:                     left:                         -                             join: pv.reservations                             alias: r                         -                             join: pv.events                             alias: ev                   where:                     and:                         - :reservation MEMBER OF pv.reservations             bind_parameters:                 - reservation ...         properties:             id: ~             rid: r.id             delete_link:                 type:         url                 route:        xxx_reservation_api_delete_reservation_pview                 params:                     rid: rid                     id: id

But this will group by pv.id and r.id and i need only by pv.id.

Thanks for any suggestions!

Topic

[Mike KudelyaParticipant]

Hi

You can create listener:

services.yml (after ‘oro_datagrid.datagrid.build.before.’ please set name of your grid):

YAML

custom_oro.listener.datagrid.contact: class: %custom_oro.listener.datagrid.contact.class% tags: - { name: kernel.event_listener, event: oro_datagrid.datagrid.build.before.contacts-grid, method: onBuildBefore }

1 2 3 4

custom_oro.listener.datagrid.contact:         class: %custom_oro.listener.datagrid.contact.class%         tags:             - { name: kernel.event_listener, event: oro_datagrid.datagrid.build.before.contacts-grid, method: onBuildBefore }

GridListener.php

PHP

<?php namespace Custom\Bundle\OroBundle\EventListener; use Oro\Bundle\DataGridBundle\Datagrid\Common\DatagridConfiguration; use Oro\Bundle\DataGridBundle\Datagrid\ParameterBag; use Oro\Bundle\DataGridBundle\Event\BuildBefore; class ContactGridListener { /** * @param BuildBefore $event */ public function onBuildBefore(BuildBefore $event) { $datagrid = $event->getDatagrid(); $this->applyFilters($event->getConfig(), $datagrid->getParameters()); } /** * @param DatagridConfiguration $config * @param ParameterBag $parameters */ protected function applyFilters(DatagridConfiguration $config, ParameterBag $parameters) { $myParameter = $parameters->get('abc', []); $datagridParameters = $config->offsetGetByPath('[properties][delete_link][params]', []); $datagridParameters['rid'] = $myParameter; $config->offsetSetByPath('[properties][delete_link][params]', $datagridParameters); } }

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 33

<?php   namespace Custom\Bundle\OroBundle\EventListener;   use Oro\Bundle\DataGridBundle\Datagrid\Common\DatagridConfiguration; use Oro\Bundle\DataGridBundle\Datagrid\ParameterBag; use Oro\Bundle\DataGridBundle\Event\BuildBefore;   class ContactGridListener {     /**      * @param BuildBefore $event      */     public function onBuildBefore(BuildBefore $event)     {         $datagrid = $event->getDatagrid();         $this->applyFilters($event->getConfig(), $datagrid->getParameters());     }       /**      * @param DatagridConfiguration $config      * @param ParameterBag $parameters      */     protected function applyFilters(DatagridConfiguration $config, ParameterBag $parameters)     {         $myParameter = $parameters->get('abc', []);           $datagridParameters = $config->offsetGetByPath('[properties][delete_link][params]', []);         $datagridParameters['rid'] = $myParameter;         $config->offsetSetByPath('[properties][delete_link][params]', $datagridParameters);       } }

twig template:

XHTML

{{ dataGrid.renderGrid(gridName, {abc: 123}, renderParams) }}

1	{{ dataGrid.renderGrid(gridName, {abc: 123}, renderParams) }}

[Author]

Replies