Filters and DataTransformer about lexikformfilterbundle HOT 5 CLOSED

<?php

namespace Your\Namespace;

use Doctrine\ORM\QueryBuilder;

use Lexik\Bundle\FormFilterBundle\Filter\ORM\Expr;
use Lexik\Bundle\FormFilterBundle\Filter\ORM\ORMFilter;

class ProductOptionFilter extends ORMFilter
{
    /**
     * {@inheritdoc}
     */
    public function getName()
    {
        return 'product_option_filter_field'; // this is the same name as ProductOptionFilterFieldType::getName()
    }

    /**
     * {@inheritdoc}
     */
    protected function apply(QueryBuilder $queryBuilder, Expr $expr, $field, array $values)
    {
        if (!empty($values['value'])) {
            // add your conditions here
        }
    }
}

$resolver->setDefaults(array(
            'invalid_message' => 'The selected productOption does not exist',
            'empty_value' => 'Choose an option',
            'choices' => $this->buildData(),
            'transformer_id' => 'lexik_form_filter.transformer.default',
        ))
                 ->setAllowedValues(array(
                'transformer_id' => array('lexik_form_filter.transformer.default'),
        ));

<?php

namespace Ecomm\Bundle\CatalogBundle\Form;

use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\FormBuilderInterface;
use Symfony\Component\OptionsResolver\OptionsResolverInterface;

use Ecomm\Bundle\CatalogBundle\Form\DataTransformer\ProductOptionFieldTransformer;

use Symfony\Component\DependencyInjection\ContainerInterface;



class ProductOptionFilterFieldType extends AbstractType
{

    /**
     * @var ServiceContainer
     */
    private $sc;


    public function __construct(ContainerInterface $container = null)
    {        
        $this->sc = $container;
    }


    public function buildForm(FormBuilderInterface $builder, array $options)
    {

        $transformer = new ProductOptionFieldTransformer($this->sc);        
        $builder->addModelTransformer($transformer);

    }

    public function setDefaultOptions(OptionsResolverInterface $resolver)
    {
        $resolver->setDefaults(array(
            'invalid_message' => 'The selected productOption does not exist',
            'empty_value' => 'Choose an option',
            'choices' => $this->buildData(),
            'transformer_id' => 'lexik_form_filter.transformer.default',
        ))
                 ->setAllowedValues(array(
                'transformer_id' => array('lexik_form_filter.transformer.default'),
        ));

    }

    private function buildData()
    {
        $em = $this->sc->get('doctrine')->getManager();
        $request = $this->sc->get('request');

        $choices = array();
        $productOptions = $em
            ->getRepository('EcommCatalogBundle:ProductOption')
            ->createQueryBuilder('c')
            ->select('c, ct')
            ->innerJoin('c.translations', 'ct')
            ->andWhere('ct.locale = :locale')
            ->setParameter('locale', $request->getLocale())
            ->orderBy('ct.name', 'ASC')
            ->getQuery()
            ->getResult();

        foreach ($productOptions as $productOption)
        {
            // I assume key is retrieved by getId
            $translation = $productOption->getTranslations();
            $choices[$productOption->getId()] = $translation[0]->getName();
        }

        return $choices;
    }

    public function getName()
    {
        return 'product_option_filter_field';
    }

    public function getParent()
    {
        return 'choice';
    }

}


<?php

namespace Ecomm\Bundle\CatalogBundle\Form;

use Doctrine\ORM\QueryBuilder;

use Lexik\Bundle\FormFilterBundle\Filter\ORM\Expr;
use Lexik\Bundle\FormFilterBundle\Filter\ORM\ORMFilter;

class ProductOptionFilter extends ORMFilter
{
    /**
     * {@inheritdoc}
     */
    public function getName()
    {
        return 'product_option_filter_field'; // this is the same name as ProductOptionFilterFieldType::getName()
    }

    /**
     * {@inheritdoc}
     */
    protected function apply(QueryBuilder $queryBuilder, Expr $expr, $field, array $values)
    {

        if (!empty($values['value']))
        {
            // add  the join if you need it and it not already added
            $alias = $queryBuilder->getRootAliases();
            $queryBuilder->innerJoin($alias[0].'.productOption', 'po');
            $queryBuilder->andWhere('po.id = :id')
            ->setParameter('id', $values['value']);
        }

    }
}