CODEWITHSUNDEEP
formscollectionssymfonyembed
alvaroveliz
alvaroveliz

Reputation: 71

Symfony 2 How do I embed collection form using some criterias

I have a problem using the embed collection forms because I want to filter the data displayed on the collection given. i.e.

<?php
Class Parent
{
    ... some attributes ...

    /**
     * @ORM\OneToMany(targetEntity="Child", mappedBy="parent", cascade={"all"})
     */
     private $children;

    ... some setters & getters ...

}

Class Child
{
    private $attribute1;

    private $attribute2;

    /**
     * @ORM\ManyToOne(targetEntity="Parent", inversedBy="children")
     * @ORM\JoinColumn(name="parent_id", referencedColumnName="id")
     */
     private $parent;

     ... some setters & getters ...
}

Then I build the form using:

class ParentChildType extends AbstractType
{
    public function buildForm(FormBuilder $builder, array $options)
    {
        $builder
        ->add('children', 'collection', array(
            'type' => ChildrenType(),
            'allow_add' => true,
        ));
    }
}
...
On controller:

    $parent = $this->getDoctrine()->getEntityManager()->getRepository('AcmeBundle:Parent')->find( $id );
    $forms = $this->createForm( new ParentChildType(), $parent)->createView();

    and then..

    return array('forms' => $forms->crateView());

My problem is when I want to filter the collection by $attribute1 and/or $attribute2 of Child model class.

There's a way to filter by a criteria for this collection forms?

Upvotes: 3

Views: 3245

Answers (2)

alvaroveliz
alvaroveliz

Reputation: 71

It's seems that I have to filter the object before using CreateQuery and then create the form using this filtered object. Like this:

$parent = $this->getDoctrine()->getEntityManager()->createQuery("
            SELECT p, c 
            FROM AcmeBundle:Parent p
            JOIN p.children c
            WHERE c.attribute1 = :attr1
              AND c.attribute2 = :attr2
           ")
           ->setParameter('attr1', <some_value>)
           ->setParameter('attr2', <some_value>)
           ->getOneOrNullResult();
$forms = $this->createForm( new ParentChildType(), $parent)->createView();
....
return array('forms' => $form->createView());

Upvotes: 4

Chopchop
Chopchop

Reputation: 2949

I point you to right direction (I hope) :

http://www.craftitonline.com/2011/08/symfony2-ajax-form-republish/

This article deals with field dependencies. for example, when you select a country, you have the towns that belongs to the country that appears in the list.

It's seems it looks like your problem

Upvotes: 0

Related Questions