Symfony2 custom form

Question

I have form with checkboxes loaded from database (I use entity field type). Checkboxes are regions and districts. I have following database schema:

+-----------------------------------+
| id | parent_id | name             |
+-----------------------------------+
| 1  | NULL      | Region           |
+-----------------------------------+
| 2  | 1         | District         |
+-----------------------------------+
| 3  | 1         | Another district |
+-----------------------------------+
| 4  | NULL      | Another region   |
+-----------------------------------+
| 5  | 4         | Next district    |
+-----------------------------------+

Problem is that I need following form. How to do that?

<b>Region</b><!-- Loaded from database -->
<!-- Dictricts ordered by name -->
<input type="checkbox" id="someId" value="3"><label for="someId">Another district</label>
<input type="checkbox" id="someId" value="2"><label for="someId">District</label>
<b>Another region</b><!-- Loaded from database -->
<!-- Dictricts ordered by name -->
<input type="checkbox" id="someId" value="5"><label for="someId">Next district</label>

Community · Accepted Answer · 2017-05-23 11:48:47Z

1

Thanks to this post I've solve this by custom rendering form template.

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Feb 7, 2012 at 12:36

kuboslav

1,4605 gold badges16 silver badges31 bronze badges

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

Comments

pécé · Accepted Answer · 2012-02-03 12:00:18Z

0

EntityType field with options :

multiple = true
expanded = true
property = 'name'
class = 'YourBundle:YourEntity'
query_builder = 'function (EntityRepository $er) {return $er->createQueryBuilder('r') ->where('r.parentId IS NOT NULL') ->orderBy('r.parentId', 'ASC')->orderBy('r.name', 'ASC');}'

answered Feb 3, 2012 at 12:00

pécé

12.7k5 gold badges52 silver badges55 bronze badges

4 Comments

kuboslav Over a year ago

This will not help. Result will be sorted by name but I need result which will be grouped by Region and Dictricts in each region sorted by name.

pécé Over a year ago

Do you define a reflexive relation on your entity (on parentId) ? Anyway, you can't do that with the native query_builder brought with EntityType field. You'll have to define a reflexive relation, get your entities well-sorted with INDEX BY DQL query, and send the results in the choices option...

kuboslav Over a year ago

Can you explain what is reflexive relation?

pécé Over a year ago

In this case, your Territory Entity is related on itself through the parentId property. Something like that with Annotation mapping : @ManyToOne(targetEntity="Territory") ; @JoinColumn(name="parent_id", referencedColumnName="id") on the parentId property. See doctrine-project.org/docs/orm/2.0/en/reference/…

Collectives™ on Stack Overflow

Symfony2 custom form

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related