From 5311271ae590460b986e3e09edcdc665b73710ca Mon Sep 17 00:00:00 2001
From: polo <ordipolo@gmx.fr>
Date: Fri, 24 Oct 2025 02:27:19 +0200
Subject: =?UTF-8?q?entit=C3=A9=20pour=20table=20interm=C3=A9diaire=20?=
 =?UTF-8?q?=C3=A0=203=20champs=20entre=20NodeData=20et=20Asset,=20table=20?=
 =?UTF-8?q?Asset=20repens=C3=A9e?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 src/model/entities/NodeDataAsset.php | 55 ++++++++++++++++++++++++++++++++++++
 1 file changed, 55 insertions(+)
 create mode 100644 src/model/entities/NodeDataAsset.php

(limited to 'src/model/entities/NodeDataAsset.php')

diff --git a/src/model/entities/NodeDataAsset.php b/src/model/entities/NodeDataAsset.php
new file mode 100644
index 0000000..7f7008e
--- /dev/null
+++ b/src/model/entities/NodeDataAsset.php
@@ -0,0 +1,55 @@
+<?php
+// src/model/entities/NodeDataAsset.php
+//
+// entité intermédiaire avec 3 colonnes
+
+declare(strict_types=1);
+
+namespace App\Entity;
+
+use Doctrine\ORM\Mapping as ORM;
+
+#[ORM\Entity]
+#[ORM\Table(name: TABLE_PREFIX . 'nodedata_asset')]
+#[ORM\UniqueConstraint(name: 'unique_role_per_node', columns: ['node_data_id', 'role'])] // un rôle UNIQUE pour chaque node_data_id, excellent!
+class NodeDataAsset
+{
+    // clé primaire double
+    // inconvénient: impossible d'utiliser deux fois la même paire node_data/asset, même pour des rôles différents
+    #[ORM\Id]
+    #[ORM\ManyToOne(targetEntity: NodeData::class, inversedBy: 'nda_collection')]
+    #[ORM\JoinColumn(name: 'node_data_id', referencedColumnName: 'id_node_data', onDelete: 'CASCADE')]
+    private NodeData $node_data;
+
+    #[ORM\Id]
+    #[ORM\ManyToOne(targetEntity: Asset::class)]
+    #[ORM\JoinColumn(name: 'asset_id', referencedColumnName: 'id_asset', onDelete: 'CASCADE')]
+    private Asset $asset;
+
+    #[ORM\Column(type: 'string', length: 50)]
+    private string $role;
+
+    public function __construct(NodeData $node_data, Asset $asset, string $role){
+        $this->node_data = $node_data;
+        $this->asset = $asset;
+        $this->role = $role;
+    }
+
+    /*public function getNodeData(): NodeData
+    {
+        return $this->node_data;
+    }*/
+    public function getAsset(): Asset
+    {
+        return $this->asset;
+    }
+    public function setAsset(Asset $asset): self
+    {
+        $this->asset = $asset;
+        return $this;
+    }
+    public function getRole(): string
+    {
+        return $this->role;
+    }
+}
-- 
cgit v1.2.3