Many-To-Many relation between User and Custom entities

I need to create Many-To-Many relation between User and Room (custom extended entity) entities. Then I need to display grid with Users on Room update page, and grid with Rooms on User update page. I have 2 ideas how to do that, but in each of them I had problems.

Create migration script and add entity via ->addManyToManyRelation(). – But here I faced with problem, that I use e.g. User->getRooms(), because I can’t add this function to User entity class.
Rewrite OroUserBundle and rewrite User entity class. – But here I faced with problem, that when I copy /Entity/User.php file to my custom bundle and when I run php app/console doctrine:schema:update --dump-sql, it display error, that ‘oro_user’ table already exist.

What is the best way to add Many-To-Many relation between User and Custom entities?

Topic

[Vova SorokaParticipant]

Hello,

The right way is to create extended many-to-many relation in a migration script.
The ExtendExtension::addManyToManyRelation is intended to do it. But in your case you need bidirectional relation, because you want to display related entities on both owning and target sides.
Unfortunately, it is not possible to create a bidirectional relation using a migration script. I’ve reported this issue. We’ll try to prepare a fix ASAP.

[musicthebeeParticipant]

Hi

Any update on this? I am running into the same issue with a build from November and wondering if this has been fixed in the latest source.

Thanks
M

[archy_boldParticipant]

This is also something that’s tripped me up. An update on how to achieve it would be great.

[Vova SorokaParticipant]

Hi all,

Sorry for the late message.
The bidirectional relations have been already implemented. Please see details in https://github.com/orocrm/platform/blob/master/src/Oro/Bundle/EntityExtendBundle/Resources/doc/relations.md

[archy_boldParticipant]

Ah cool. Is there more to adding relations through the EntityExtendBundle? I’ve managed to add the relation but when I call getSubscriptions on my model, I always get null. Even with data in the database.

Should the extended model have annotations for Doctrine or do I need to define them in my own model?

My extended entity class looks as follows:

PHP

<?php namespace Extend\Entity; abstract class EX_TrueConnectivityLtdOroCrmBundle_Customer extends \Oro\Bundle\BusinessEntitiesBundle\Entity\BasePerson implements \Oro\Bundle\EntityExtendBundle\Entity\ExtendEntityInterface { protected $subscriptions; protected $ac_last_contact_date_out; protected $ac_last_contact_date_in; protected $ac_last_contact_date; protected $ac_contact_count_out; protected $ac_contact_count_in; protected $ac_contact_count; public function setSubscriptions($value) { $this->subscriptions = $value; return $this; } public function setAcLastContactDateOut($value) { $this->ac_last_contact_date_out = $value; return $this; } public function setAcLastContactDateIn($value) { $this->ac_last_contact_date_in = $value; return $this; } public function setAcLastContactDate($value) { $this->ac_last_contact_date = $value; return $this; } public function setAcContactCountOut($value) { $this->ac_contact_count_out = $value; return $this; } public function setAcContactCountIn($value) { $this->ac_contact_count_in = $value; return $this; } public function setAcContactCount($value) { $this->ac_contact_count = $value; return $this; } public function getSubscriptions() { return $this->subscriptions; } public function getAcLastContactDateOut() { return $this->ac_last_contact_date_out; } public function getAcLastContactDateIn() { return $this->ac_last_contact_date_in; } public function getAcLastContactDate() { return $this->ac_last_contact_date; } public function getAcContactCountOut() { return $this->ac_contact_count_out; } public function getAcContactCountIn() { return $this->ac_contact_count_in; } public function getAcContactCount() { return $this->ac_contact_count; } public function __construct() { parent::__construct(); } }

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 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89

<?php   namespace Extend\Entity;   abstract class EX_TrueConnectivityLtdOroCrmBundle_Customer extends \Oro\Bundle\BusinessEntitiesBundle\Entity\BasePerson implements \Oro\Bundle\EntityExtendBundle\Entity\ExtendEntityInterface {     protected $subscriptions;     protected $ac_last_contact_date_out;     protected $ac_last_contact_date_in;     protected $ac_last_contact_date;     protected $ac_contact_count_out;     protected $ac_contact_count_in;     protected $ac_contact_count;       public function setSubscriptions($value)     {         $this->subscriptions = $value; return $this;     }       public function setAcLastContactDateOut($value)     {         $this->ac_last_contact_date_out = $value; return $this;     }       public function setAcLastContactDateIn($value)     {         $this->ac_last_contact_date_in = $value; return $this;     }       public function setAcLastContactDate($value)     {         $this->ac_last_contact_date = $value; return $this;     }       public function setAcContactCountOut($value)     {         $this->ac_contact_count_out = $value; return $this;     }       public function setAcContactCountIn($value)     {         $this->ac_contact_count_in = $value; return $this;     }       public function setAcContactCount($value)     {         $this->ac_contact_count = $value; return $this;     }       public function getSubscriptions()     {         return $this->subscriptions;     }       public function getAcLastContactDateOut()     {         return $this->ac_last_contact_date_out;     }       public function getAcLastContactDateIn()     {         return $this->ac_last_contact_date_in;     }       public function getAcLastContactDate()     {         return $this->ac_last_contact_date;     }       public function getAcContactCountOut()     {         return $this->ac_contact_count_out;     }       public function getAcContactCountIn()     {         return $this->ac_contact_count_in;     }       public function getAcContactCount()     {         return $this->ac_contact_count;     }       public function __construct()     {         parent::__construct();     } }

[Author]

Replies