Billbucket
Billbucket

Reputation: 175

ManyToMany does not work with inheritance

I'm building an app that deals with givers and companies, that own givers. Both inherit a super-class called "Organization".

I want to add an unidirectional ManyToMany relationship between them, but when I ask doctrine to implement the database, and hydrate it with fixtures, I can't retrieve the givers owned by a company.

Doctrine hasn't even created a giver_company table whatsoever which could contain the relationship information as it is supposed to do.

Here is my code:

Organization

<?php
// src/Entity/Chain/Organization.php
namespace App\Entity\Chain;

use App\Entity\User;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;
use Symfony\Component\Validator\Constraints as Assert;

/**
 * @ORM\Entity
 * @ORM\InheritanceType("SINGLE_TABLE")
 * @ORM\DiscriminatorColumn(name="type", type="string")
 * @ORM\DiscriminatorMap({"association" = "Association", "super_association" = "SuperAssociation", "company" = "Company", "giver" = "Giver"})
 */

abstract class Organization
{

    /**
     * @ORM\Id
     * @ORM\GeneratedValue
     * @ORM\Column(type="integer")
     */
    private $id;

    /**
     * @ORM\Column(type="string", length=255)
     * @Assert\NotBlank()
     */
    private $name;

    /**
     * @ORM\Column(type="string", length=255, nullable=true)
     */
    private $address;

    /**
     * @ORM\Column(type="string", length=255, nullable=true)
     */
    private $city;

    /**
     * @ORM\Column(type="string", length=255, nullable=true)
     */
    private $zipcode;

    /**
     * @ORM\Column(type="string", length=255, nullable=true)
     */
    private $SIREN;

    /**
     * @ORM\Column(type="string", length=255, nullable=true)
     */
    private $phone;

    /**
     * @ORM\OneToOne(targetEntity="App\Entity\Photo")
     */
    private $photo;

    /**
     * @ORM\OneToMany(targetEntity="App\Entity\User", mappedBy="memberOf")
     */
    private $members ;

    /**
     * Organization constructor.
     */
    public function __construct()
    {
        $this->members = new ArrayCollection();
    }


    public function getId()
    {
        return $this->id;
    }

    public function getName()
    {
        return $this->name;
    }

    /**
     * @param mixed $name
     */
    public function setName($name): void
    {
        $this->name = $name;
    }

    public function getAddress()
    {
        return $this->address;
    }

    /**
     * @param mixed $address
     */
    public function setAddress($address): void
    {
        $this->address = $address;
    }

    public function getCity()
    {
        return $this->city;
    }

    /**
     * @param mixed $city
     */
    public function setCity($city): void
    {
        $this->city = $city;
    }

    public function getZipcode()
    {
        return $this->zipcode;
    }

    /**
     * @param mixed $zipcode
     */
    public function setZipcode($zipcode): void
    {
        $this->zipcode = $zipcode;
    }

    public function getSIREN()
    {
        return $this->SIREN;
    }

    /**
     * @param mixed $SIREN
     */
    public function setSIREN($SIREN): void
    {
        $this->SIREN = $SIREN;
    }

    public function getPhone()
    {
        return $this->phone;
    }

    /**
     * @param mixed $phone
     */
    public function setPhone($phone): void
    {
        $this->phone = $phone;
    }

    public function getPhoto()
    {
        return $this->photo;
    }

    /**
     * @param mixed $photo
     */
    public function setPhoto($photo): void
    {
        $this->photo = $photo;
    }

    public function getMembers()
    {
        return $this->members;
    }

    public function addMember(User $member)
    {
        if (!$this->members->contains($member)) {
            $this->members->add($member);
        }
    }

    public function removeMember(User $member){
        $this->members->remove($member);
    }
}

Giver

<?php
// src/Entity/Chain/Giver.php
namespace App\Entity\Chain;

use App\Entity\Photo;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity()
 */
class Giver extends Organization
{
    /**
     * @ORM\Id
     * @ORM\GeneratedValue
     * @ORM\Column(type="integer")
     */
    private $id;


    /**
     * @ORM\Column(type="string", length=255)
     */
    private $status ;


    /**
     * Giver constructor.
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * @return mixed
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * @return mixed
     */
    public function getStatus()
    {
        return $this->status;
    }

    /**
     * @param mixed $status
     */
    public function setStatus($status): void
    {
        $this->status = $status;
    }

}

Company

<?php
    // src/Entity/Chain/Company.php
    namespace App\Entity\Chain;

    use Doctrine\Common\Collections\ArrayCollection;
    use Doctrine\ORM\Mapping as ORM;

    /**
     * @ORM\Entity()
     */
    class Company extends Organization
    {
        /**
         * @ORM\Id
         * @ORM\GeneratedValue
         * @ORM\Column(type="integer")
         */
        private $id;

        /**
         * @ORM\Column(type="string", length=255, name="company_type")
         */
        private $type ;

        /*
         * @ORM\ManyToMany(targetEntity="App\Entity\Chain\Giver")
         */
        private $givers ;

        /**
         * Company constructor.
         */
        public function __construct()
        {
            parent::__construct();
            $this->givers = new ArrayCollection();
        }


        /**
         * @return mixed
         */
        public function getId()
        {
            return $this->id;
        }

        /**
         * @return mixed
         */
        public function getType()
        {
            return $this->type;
        }

        /**
         * @param mixed $type
         */
        public function setType($type): void
        {
            $this->type = $type;
        }



        public function getGivers()
        {
            return $this->givers;
        }

        public function addGiver(Giver $opening)
        {
            if (!$this->givers->contains($opening)) {
                $this->givers->add($opening);
            }
        }

        public function removeGiver(Giver $opening){
            $this->givers->remove($opening);
        }
    }

Upvotes: 1

Views: 185

Answers (1)

Jannes Botis
Jannes Botis

Reputation: 11242

Your DocBlock for givers in Company is missing an "*" at the beginning. PHPDoc

Change:

/*
* @ORM\ManyToMany(targetEntity="App\Entity\Chain\Giver")
*/
private $givers ;

to

/**
* @ORM\ManyToMany(targetEntity="App\Entity\Chain\Giver")
*/
private $givers ;

Upvotes: 1

Related Questions