symfony form with entity type field and multiple entities

Question

I have two entities with some properties:

Category
- category name
- category description
Subcategory
- subcategory name
- subcategory description
- Category ID (ManyToOne relation)

There is a ManyToOne relation in the subcategory entity i.e. several subcategories can be connected to one category.

I would like to build a form with a dropdown listing all the subcategories, but I would like to display the name of category and subcategory, the list would look like so:

Category1 - Subcategory1
Category1 - Subcategory2
Category1 - Subcategory3
Category2 - Subcategory1
Category2 - Subcategory2
Category2 - Subcategory3
etc...

I'm thinking about creating a getter in the subcategory class that would return a concatenation of the category name and subcategory name, something like sprintf('%s - %s', $this->categoryName, $this->subcategoryName), but I can't see how I could access Category object properties using the subcategory class getter...

Any idea about the best practice to achieve this?

Thank you, JM

Jean-Marc Beaune · Accepted Answer · 2016-10-23 23:02:51Z

3

I managed to do this by building the form like so:

        $builder
         ->add('subcategoryName', EntityType::class, array(
          'class'    => 'AppBundle:subcategory',
          'query_builder' => function(EntityRepository $er) {
            return $er->createQueryBuilder('u')
                ->addSelect('t')
                ->join('u.category', 't' )
                ->orderBy('t.category', 'ASC')
                ->addOrderBy('u.subcategory', 'ASC');
          },
          'choice_label' => function($subcategoryname){
            return $categoryname->getcategory()->getcategoryname() . " - " . $subcategoryname->getsubcategoryName();
          },
          'multiple' => false,
          'expanded' => false,
            ))

I was only strugling a bit with the choice_label option.

/JM

answered Oct 23, 2016 at 23:02

Jean-Marc Beaune

311 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pedram shabani · Accepted Answer · 2019-03-10 09:26:03Z

0

You can use this method it is clear.when you have the IdCategory of Subcategory table, you access the fields Category table too

 ->add('idCategory', EntityType::class,array(
                'data'   =>  $options[0]['idCategory'],
                'class' => 'AppBundle:subcategory',
                'choice_label' => function (subcategory $subcategory) {
                    return $subcategory->getName() . '-' . $subcategory->getCategoryID()->getName().'-'.$subcategory->getCategoryID()->getDescription();
                },
                'attr' => array(
                    'label'    => 'Category ',
                    'class' => 'form-control'
                )
            ))

answered Mar 10, 2019 at 9:26

pedram shabani

1,6903 gold badges20 silver badges32 bronze badges

Collectives™ on Stack Overflow

symfony form with entity type field and multiple entities

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related