Symfony 6中为多对多关联表添加额外字段的咨询

默认的ManyToMany关联无法直接给自动生成的中间表添加自定义字段，你需要把中间表转换成独立实体，通过OneToMany与ManyToOne的组合关联来实现需求。具体操作步骤如下：

1. 创建中间实体 ClientOffre #

这个实体对应原有的clients_offre表，同时新增commentaire字段：

// src/Entity/ClientOffre.php
namespace App\Entity;

use App\Entity\Client;
use App\Entity\Offre;
use Doctrine\ORM\Mapping as ORM;

#[ORM\Entity]
#[ORM\Table(name: 'clients_offre')] // 保留原中间表名称
class ClientOffre
{
    #[ORM\Id]
    #[ORM\GeneratedValue]
    #[ORM\Column(type: 'integer')]
    private ?int $id = null;

    #[ORM\ManyToOne(targetEntity: Client::class, inversedBy: 'clientOffres')]
    #[ORM\JoinColumn(name: 'CLIENTID', referencedColumnName: 'clientid', nullable: false)]
    private ?Client $client = null;

    #[ORM\ManyToOne(targetEntity: Offre::class, inversedBy: 'clientOffres')]
    #[ORM\JoinColumn(name: 'OFFREID', referencedColumnName: 'offreid', nullable: false)]
    private ?Offre $offre = null;

    #[ORM\Column(type: 'text', nullable: true)] // 根据需求调整字段类型，比如string
    private ?string $commentaire = null;

    // 生成Getter和Setter方法
    public function getId(): ?int
    {
        return $this->id;
    }

    public function getClient(): ?Client
    {
        return $this->client;
    }

    public function setClient(?Client $client): self
    {
        $this->client = $client;
        return $this;
    }

    public function getOffre(): ?Offre
    {
        return $this->offre;
    }

    public function setOffre(?Offre $offre): self
    {
        $this->offre = $offre;
        return $this;
    }

    public function getCommentaire(): ?string
    {
        return $this->commentaire;
    }

    public function setCommentaire(?string $commentaire): self
    {
        $this->commentaire = $commentaire;
        return $this;
    }
}

2. 修改Client实体的关联关系 #

替换原来的ManyToMany关联，改为OneToMany指向中间实体：

// src/Entity/Client.php
namespace App\Entity;

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

#[ORM\Entity]
class Client
{
    // 保留原有的其他字段和代码...

    // 替换原$offres字段
    #[ORM\OneToMany(mappedBy: 'client', targetEntity: ClientOffre::class, cascade: ['persist', 'remove'])]
    private Collection $clientOffres;

    public function __construct()
    {
        $this->clientOffres = new ArrayCollection();
    }

    // 添加关联操作方法
    public function addClientOffre(ClientOffre $clientOffre): self
    {
        if (!$this->clientOffres->contains($clientOffre)) {
            $this->clientOffres->add($clientOffre);
            $clientOffre->setClient($this);
        }
        return $this;
    }

    public function removeClientOffre(ClientOffre $clientOffre): self
    {
        if ($this->clientOffres->removeElement($clientOffre)) {
            if ($clientOffre->getClient() === $this) {
                $clientOffre->setClient(null);
            }
        }
        return $this;
    }

    // 兼容旧代码的getOffres方法（可选）
    public function getOffres(): Collection
    {
        return $this->clientOffres->map(fn(ClientOffre $clientOffre) => $clientOffre->getOffre());
    }
}

3. 修改Offre实体的关联关系 #

同样替换原ManyToMany关联为OneToMany指向中间实体：

// src/Entity/Offre.php
namespace App\Entity;

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

#[ORM\Entity]
class Offre
{
    // 保留原有的其他字段和代码...

    // 替换原$clients字段
    #[ORM\OneToMany(mappedBy: 'offre', targetEntity: ClientOffre::class, cascade: ['persist', 'remove'])]
    private Collection $clientOffres;

    public function __construct()
    {
        $this->clientOffres = new ArrayCollection();
    }

    // 添加关联操作方法
    public function addClientOffre(ClientOffre $clientOffre): self
    {
        if (!$this->clientOffres->contains($clientOffre)) {
            $this->clientOffres->add($clientOffre);
            $clientOffre->setOffre($this);
        }
        return $this;
    }

    public function removeClientOffre(ClientOffre $clientOffre): self
    {
        if ($this->clientOffres->removeElement($clientOffre)) {
            if ($clientOffre->getOffre() === $this) {
                $clientOffre->setOffre(null);
            }
        }
        return $this;
    }

    // 兼容旧代码的getClients方法（可选）
    public function getClients(): Collection
    {
        return $this->clientOffres->map(fn(ClientOffre $clientOffre) => $clientOffre->getClient());
    }
}

4. 生成并执行数据库迁移 #

运行以下命令生成迁移脚本：

php bin/console make:migration

检查生成的迁移文件确认逻辑无误后，执行迁移更新数据库：

php bin/console doctrine:migrations:migrate

使用示例 #

关联Client与Offre并设置commentaire：

// 假设已通过EntityManager获取$client和$offre实例
$clientOffre = new ClientOffre();
$clientOffre->setOffre($offre);
$clientOffre->setCommentaire("客户选择此优惠的备注信息");

$client->addClientOffre($clientOffre);

$entityManager = $this->getDoctrine()->getManager();
$entityManager->persist($clientOffre);
$entityManager->flush();

内容的提问来源于stack exchange，提问作者Souyette