From 23a46b4be35277e06ec89f48730eeb694e686be8 Mon Sep 17 00:00:00 2001
From: Kenmegne <stephanie.kenmegne@gmail.com>
Date: Thu, 18 Jun 2026 15:40:06 +0000
Subject: [PATCH] add fdx-commons and fdx-consultation

---
 fdx-consultation/fdxconsultation-dao-ifaces/src/main/java/com/megatim/fdxconsultation/dao/ifaces/referentiel/RoutageDAO.java |   73 ++++++++++++++++++++++++++++++++++++
 1 files changed, 73 insertions(+), 0 deletions(-)

diff --git a/fdx-consultation/fdxconsultation-dao-ifaces/src/main/java/com/megatim/fdxconsultation/dao/ifaces/referentiel/RoutageDAO.java b/fdx-consultation/fdxconsultation-dao-ifaces/src/main/java/com/megatim/fdxconsultation/dao/ifaces/referentiel/RoutageDAO.java
new file mode 100644
index 0000000..1244a66
--- /dev/null
+++ b/fdx-consultation/fdxconsultation-dao-ifaces/src/main/java/com/megatim/fdxconsultation/dao/ifaces/referentiel/RoutageDAO.java
@@ -0,0 +1,73 @@
+package com.megatim.fdxconsultation.dao.ifaces.referentiel;
+
+import com.megatim.fdxcommons.model.referentiel.Participant;
+import com.megatim.fdxcommons.model.referentiel.Routage;
+import com.megatim.fdxcommons.model.referentiel.RoutageId;
+import javax.persistence.EntityManager;
+import com.megatim.fdxconsultation.dao.ifaces.abstracts.CustomDAOWithCriteriaEntityIfaces;
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Optional;
+
+/**
+ *
+ * @author ASUS
+ */
+public interface RoutageDAO extends CustomDAOWithCriteriaEntityIfaces<Routage, RoutageId> {
+
+    @Override
+    EntityManager getEntityManager();
+
+    @Override
+    public Routage getById(RoutageId id);
+
+    public default List<Participant> getParticipantsForSend(String versionReferentiel, String codeTypeFichier) {
+        List<Participant> participantsEnvoi = new ArrayList<>();
+        Optional<Routage> optRoutage = getEntityManager().createQuery("SELECT r FROM Routage r "
+                + "LEFT JOIN r.participantsEnvoi p "
+                + "LEFT JOIN r.noeudsEnvoi n "
+                + "LEFT JOIN r.groupeParticipantsEnvoi gp LEFT JOIN gp.participants pa "
+                + "LEFT JOIN r.groupeNoeudsEnvoi gn LEFT JOIN gn.noeuds no "
+                + "WHERE r.referentiel.version = :versionReferentiel AND r.typeFichier.code = :codeTypeFichier ")
+                .setParameter("versionReferentiel", versionReferentiel)
+                .setParameter("codeTypeFichier", codeTypeFichier)
+                .getResultList().stream().findFirst();
+
+        if (optRoutage.isPresent()) {
+            Routage routage = optRoutage.get();
+            participantsEnvoi.addAll(routage.getParticipantsEnvoi());
+            routage.getNoeudsEnvoi().stream().forEach(n -> {
+                participantsEnvoi.add(n.getParticipant());
+            });
+            routage.getGroupeNoeudsEnvoi().stream().forEach(gn -> gn.getNoeuds().stream().forEach(n -> participantsEnvoi.add(n.getParticipant())));
+            routage.getGroupeParticipantsEnvoi().stream().forEach(gp -> participantsEnvoi.addAll(gp.getParticipants()));
+        }
+
+        return participantsEnvoi;
+    }
+
+    default List<Participant> getParticipantForReceive(String versionReferentiel, String codeTypeFichier) {
+        List<Participant> participantsReception = new ArrayList<>();
+        Optional<Routage> optRoutage = getEntityManager().createQuery("SELECT r FROM Routage r "
+                + "LEFT JOIN r.participantsReception p "
+                + "LEFT JOIN r.noeudsReception n "
+                + "LEFT JOIN r.groupeParticipantsReception gp LEFT JOIN gp.participants pa "
+                + "LEFT JOIN r.groupeNoeudsReception gn LEFT JOIN gn.noeuds no "
+                + "WHERE r.referentiel.version = :versionReferentiel AND r.typeFichier.code = :codeTypeFichier ")
+                .setParameter("versionReferentiel", versionReferentiel)
+                .setParameter("codeTypeFichier", codeTypeFichier)
+                .getResultList().stream().findFirst();
+
+        if (optRoutage.isPresent()) {
+            Routage routage = optRoutage.get();
+            participantsReception.addAll(routage.getParticipantsReception());
+            routage.getNoeudsReception().stream().forEach(n -> {
+                participantsReception.add(n.getParticipant());
+            });
+            routage.getGroupeNoeudsReception().stream().forEach(gn -> gn.getNoeuds().stream().forEach(n -> participantsReception.add(n.getParticipant())));
+            routage.getGroupeParticipantsReception().stream().forEach(gp -> participantsReception.addAll(gp.getParticipants()));
+        }
+
+        return participantsReception;
+    }
+}

--
Gitblit v1.10.0