[2.x] EntityType dans un CollectionType : Multiples requêtes identiques

Allez hop! J'ai une solution. Passer les éléments au formulaire directement sans query_builder.

Code:

$userForm = $this->createForm(new UserType($em->getRepository('RapotorAppBundle:City')->findAll()), $user);

Code:

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
37
38
39
<?php
 
namespace Rapotor\AppBundle\Form\Type;
 
use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\FormBuilder;
 
class UserType extends AbstractType
{
    protected $_cities;
 
    public function __construct($cities)
    {
        $this->_cities = $cities;
    }
 
    public function buildForm(FormBuilder $builder, array $options)
    {
        $builder->add('lastname');
        $builder->add('addresses', 'collection', array(
            'type'          => new AddressType($this->_cities),
            'allow_add'     => true,
            'allow_delete'  => true,
            'prototype'     => true,
        ));
    }
 
    public function getDefaultOptions(array $options)
    {
        return array(
            'data_class' => 'Rapotor\AppBundle\Entity\User',
        );
    }
 
    public function getName()
    {
        return 'user';
    }
}

Code:

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
37
38
39
40
41
<?php
 
namespace Rapotor\AppBundle\Form\Type;
 
use Symfony\Component\Form\AbstractType;
use Symfony\Component\Form\FormBuilder;
 
class AddressType extends AbstractType
{
    protected $_cityChoices;
 
    public function __construct($choices)
    {
        $this->_cityChoices = $choices;
    }
 
    public function buildForm(FormBuilder $builder, array $options)
    {
        $builder->add('street');
        $builder->add('number', 'integer');
        $builder->add('box', 'text', array('required' => false));
        $builder->add('city', 'entity', array(
            'class'         => 'Rapotor\AppBundle\Entity\City',
            'empty_value'   => '-- select --',
            'choices'       => $this->_cityChoices,
            //'query_builder' => function ($repository) { return $repository->createQueryBuilder('p')->orderBy('p.name', 'ASC'); },
        ));
    }
 
    public function getDefaultOptions(array $options)
    {
        return array(
            'data_class' => 'Rapotor\AppBundle\Entity\Address',
        );
    }
 
    public function getName()
    {
        return 'user_address';
    }
}