Multiple joins in a ManyToMany relation

Question

I have 3 entities, User, Parking and Voiture. User had a ManyToMany relation with parking while Parking has a OneToMany reamtion with voiture.

what I'm trying to do:

Get the cars (voitures) that belong to all parkings the currect user is related to

how I'm trying to do it:

Using querybuilder, but I still don't know how to make it work

here are my entities

Entity User:

id;
    }


    /**
     * @ORM\Column(type="string", length=191, unique=true)
     * @Assert\NotBlank()
     */
    private $username;


    /**
     * @ORM\ManyToMany(targetEntity="App\Entity\Parking", mappedBy="agents")
     */
    private $parkings;
    public function __construct()
    {
        $this->parkings = new ArrayCollection();
    }



    /**
     * @return Collection|Parking[]
     */
    public function getParkings(): Collection
    {
        return $this->parkings;
    }

    public function addParking(Parking $parking): self
    {
        if (!$this->parkings->contains($parking)) {
            $this->parkings[] = $parking;
            $parking->addAgent($this);
            return $this;
        }

        return $this;
    }

    public function removeParking(Parking $parking): self
    {
        if ($this->parkings->contains($parking)) {
            $this->parkings->removeElement($parking);
            $parking->removeAgent($this);
        }

        return $this;
    }
}

Entity Parking:

agents = new ArrayCollection();
        $this->voitures = new ArrayCollection();
    }

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


    /**
     * @return Collection|user[]
     */
    public function getAgents(): Collection
    {
        return $this->agents;
    }

    public function addAgent(user $agent): self
    {
        if (!$this->agents->contains($agent)) {
            $this->agents[] = $agent;
        }

        return $this;
    }

    public function removeAgent(user $agent): self
    {
        if ($this->agents->contains($agent)) {
            $this->agents->removeElement($agent);
        }

        return $this;
    }

    /**
     * @return Collection|Voiture[]
     */
    public function getVoitures(): Collection
    {
        return $this->voitures;
    }

    public function addVoiture(Voiture $voiture): self
    {
        if (!$this->voitures->contains($voiture)) {
            $this->voitures[] = $voiture;
            $voiture->setParking($this);
        }

        return $this;
    }

    public function removeVoiture(Voiture $voiture): self
    {
        if ($this->voitures->contains($voiture)) {
            $this->voitures->removeElement($voiture);
            // set the owning side to null (unless already changed)
            if ($voiture->getParking() === $this) {
                $voiture->setParking(null);
            }
        }

        return $this;
    }

}

And Entity Voiture

id;
    }

    public function getMatricule(): ?string
    {
        return $this->matricule;
    }

    public function setMatricule(string $matricule): self
    {
        $this->matricule = $matricule;

        return $this;
    }



    public function getParking(): ?Parking
    {
        return $this->parking;
    }

    public function setParking(?Parking $parking): self
    {
        $this->parking = $parking;

        return $this;
    }

}

ASSILI Taher · Accepted Answer

I propose to add an intermediate entity UserParking between User and Parking entities. So we have a OneToMany relationship between User and UserParking and a OneToMany relationship between Parking and UserParking instead of ManyToMany relationship between User and Parking.

The entities will be similar to code below:

Entity User:

id;
    }


    /**
     * @ORM\Column(type="string", length=191, unique=true)
     * @Assert\NotBlank()
     */
    private $username;


    /**
     * @ORM\OneToMany(targetEntity="App\Entity\UserParking", mappedBy="agent")
     * @ORM\JoinColumn(nullable=true)
     */
    private $user_parking;

// getter and setter
}

Entity Parking:



Entity UserParking

/**
 * UserParking
 *
 * @ORM\Table(name="user_parking")
 * @ORM\Entity(repositoryClass="App\Repository\UserParkingRepository")
 */
class UserParking
{
    /**
     * @var int
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    /**
     * @ORM\ManyToOne(targetEntity="App\Entity\User", inversedBy="user_parking")
     * @ORM\JoinColumn(nullable=false)
     */
    private $agent;

    /**
     * @ORM\ManyToOne(targetEntity="App\Entity\Parking", inversedBy="user_parking")
     * @ORM\JoinColumn(nullable=false)
     */
    private $parking;

    // getter and setter
}


And Entity Voiture



So to get the cars (voitures) that belong to all parkings the current user is related to you need to:

1- Get the current user object.

2- Get the UserParking array from the user object .

3- Get the Parking objects from the UserParking array.

4- Get the cars from the Parking objects.

The code will be similar to this:

$em = $this->getDoctrine()->getManager();

/* Get user from the session */
$user = $this->getUser();

$userParkings = $user->getUserParking();
$parkings = [];
foreach ($userParkings as $item) {
    $parking = $item->getParking();
    $parkings[count($parkings)] = $parking;
}
// you can get voitures from parkings

Multiple joins in a ManyToMany relation

Answers (2)

Related Questions