How to create your own DataGrid filter in SonataAdmin

Question

I have a transaction with numerous status codes. I want the user to be able to see these status codes as strings in SonataAdmin. The user should also be able to filter based on these status codes.

Entity Transaction { const TRANSACTION_STATUS_WAITING = 1; const TRANSACTION_STATUS_PENDING = 2; const TRANSACTION_STATUS_CONFIRMED = 3; /** * Set status * * @param smallint $status */ public function setStatus($status) { $this->status = $status; } /** * Get status * * @return smallint */ public function getStatus() { return $this->status; } public function getStatusAsString() { switch($this->status){ case(self::TRANSACTION_STATUS_WAITING): return "Waiting for Merchant"; case(self::TRANSACTION_STATUS_PENDING): return "Pending Confirmation"; case(self::TRANSACTION_STATUS_CONFIRMED): return "Confirmed"; } } } 

I set up my list of sonata cards as follows:

 protected function configureListFields(ListMapper $listMapper) { $listMapper ->addIdentifier('id') ->add('statusAsString', null, array('sortable' => true, 'label' => 'Status')) } 

which works great:

However, I cannot use the same as the filter.

If I try this:

 protected function configureDatagridFilters(DatagridMapper $datagridMapper) { $datagridMapper ->add('user') ->add('status') // Works well ->add('statusAsString', null, array('label' => 'Status')) // Doesn't work: ; } 

This does not work. It gives the following error →

 Notice: Undefined index: statusAsString in ..../Sonata\DoctrineORMAdminBundle\Guesser\FilterTypeGuesser.php 

How can I make it work?

Answer 1

This worked as a workaround for me. If anyone has a better solution, please share.

 $datagridMapper ->add('status', 'doctrine_orm_string', array(), 'choice', array('choices' => Transaction::getStatusList()) ); 

In the facility

 public static function getStatusList() { return array( self::TRANSACTION_STATUS_WAITING => "Waiting", self::TRANSACTION_STATUS_PENDING_CONFIRMATION => "Pending Confirmation", self::TRANSACTION_STATUS_CONFIRMED => "Confirmed", self::TRANSACTION_STATUS_PAYMENT_REQUESTED => "Payment Requested",); } 

Answer 2

Something like that

 protected function configureDatagridFilters(DatagridMapper $datagridMapper) { $datagridMapper ->add('codes', 'doctrine_orm_callback', array( 'label' => '', 'callback' => array($this, 'getCodesFilter'), 'field_type' => 'genemu_jquerychosen', 'field_options' => array( 'class' => 'Mtools\ClientBundle\Entity\Client', 'widget' => 'entity', 'multiple' => false, ) ); } public function getCodesFilter($queryBuilder, $alias, $field, $value) { if (!$value) { return; } $queryBuilder->leftJoin(sprintf('%s.codes', $alias), 'c'); $queryBuilder->andWhere('c.code = :code'); $queryBuilder->setParameter('code', $value['value']); }