Multiple <count-property></count-property> in list

[GandonNicolas]

Hi,

I have a Workshop entity which is linked to a Registrations entity.

A Registrations has several states (registered, pending, cancelled).

In the list of Workshop that I display in admin, I would like to count the number of Registrations with state registered and the number of pending Registrations for each workshop.

To do this, I use the <count-property> tag in my config/lists/workshops.xml file.

But I've noticed that if I declare a tag like this :

<count-property name="nombre_inscription" visibility="yes" translation="Inscrits">
     <field-name>id</field-name>
     <entity-name>App\Entity\Inscription</entity-name>

     <joins>
          <join>
              <entity-name>App\Entity\Inscription</entity-name>
              <field-name>App\Entity\Atelier.inscriptions</field-name>
             <condition>App\Entity\Inscription.etat = 1</condition>
         </join>
     </joins>
</count-property>

All goes well. I can see the number of Registrations in the registered state (1). The result:

But if I try to add a second one:

        <count-property name="nombre_inscription" visibility="yes" translation="Inscrits">
            <field-name>id</field-name>
            <entity-name>App\Entity\Inscription</entity-name>

            <joins>
                <join>
                    <entity-name>App\Entity\Inscription</entity-name>
                    <field-name>App\Entity\Atelier.inscriptions</field-name>
                    <condition>App\Entity\Inscription.etat = 1</condition>
                </join>
            </joins>
        </count-property>

        <count-property name="nombre_liste_attente" visibility="yes" translation="Liste d'attente">
            <field-name>id</field-name>
            <entity-name>App\Entity\Inscription</entity-name>

            <joins>
                <join>
                    <entity-name>App\Entity\Inscription</entity-name>
                    <field-name>App\Entity\Atelier.inscriptions</field-name>
                    <condition>App\Entity\Inscription.etat = 2</condition>
                </join>
            </joins>
        </count-property>

The expected result is no longer good. The first tag is ignored and the result displayed is that of the second tag's condition :

Is my way of doing things correct?

Thanks in advance for any help

[alexander-schranz]

The entityName is mapped in the queryBuilder to the join alias of doctrine so you need change the query builder to have a unique name per join.

        <count-property name="nombre_inscription" visibility="yes" translation="Inscrits">
            <field-name>id</field-name>
+           <entity-name>Inscription_1</entity-name>

            <joins>
                <join>
+                   <entity-name>Inscription_1</entity-name>
                    <field-name>App\Entity\Atelier.inscriptions</field-name>
+                   <condition>Inscription_1.etat = 1</condition>
                </join>
            </joins>
        </count-property>

        <count-property name="nombre_liste_attente" visibility="yes" translation="Liste d'attente">
            <field-name>id</field-name>
+           <entity-name>Inscription_2</entity-name>

            <joins>
                <join>
+                   <entity-name>Inscription_2</entity-name>
                    <field-name>App\Entity\Atelier.inscriptions</field-name>
+                   <condition>Inscription.etat = 2</condition>
                </join>
            </joins>
        </count-property>

Entity-name is here sadly a little missleading.

[GandonNicolas]

Thank you for your reply, it works perfectly 👍