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
---
apifdxweb/api/apifdxweb-dao-ifaces/src/main/java/com/megatim/apifdxweb/dao/ifaces/referentiel/RoutageDAO.java | 104 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 104 insertions(+), 0 deletions(-)
diff --git a/apifdxweb/api/apifdxweb-dao-ifaces/src/main/java/com/megatim/apifdxweb/dao/ifaces/referentiel/RoutageDAO.java b/apifdxweb/api/apifdxweb-dao-ifaces/src/main/java/com/megatim/apifdxweb/dao/ifaces/referentiel/RoutageDAO.java
new file mode 100644
index 0000000..66534fa
--- /dev/null
+++ b/apifdxweb/api/apifdxweb-dao-ifaces/src/main/java/com/megatim/apifdxweb/dao/ifaces/referentiel/RoutageDAO.java
@@ -0,0 +1,104 @@
+package com.megatim.apifdxweb.dao.ifaces.referentiel;
+
+import com.megatim.apifdxweb.model.searchentities.RoutageSearch;
+import com.megatim.fdxcommons.dao.ifaces.abstracts.CustomDAOIfaces;
+import com.megatim.fdxcommons.model.referentiel.Participant;
+import com.megatim.fdxcommons.model.referentiel.Routage;
+import com.megatim.fdxcommons.model.referentiel.RoutageId;
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Optional;
+import javax.persistence.EntityManager;
+import javax.persistence.Query;
+
+/**
+ *
+ * @author ASUS
+ */
+public interface RoutageDAO extends CustomDAOIfaces<Routage, RoutageId, RoutageSearch> {
+
+ @Override
+ EntityManager getEntityManager();
+
+ @Override
+ public default Class<Routage> getManagedEntityClass() {
+ return (Routage.class);
+ }
+
+ @Override
+ public default Routage getById(RoutageId id) {
+ Query query = getEntityManager().createQuery("SELECT r FROM Routage r"
+ + " LEFT JOIN FETCH r.groupeNoeudsEnvoi LEFT JOIN FETCH r.groupeNoeudsReception"
+ + " LEFT JOIN FETCH r.groupeParticipantsEnvoi LEFT JOIN FETCH r.groupeParticipantsReception"
+ + " LEFT JOIN FETCH r.noeudsEnvoi LEFT JOIN FETCH r.noeudsReception"
+ + " LEFT JOIN FETCH r.groupeNoeudsReception LEFT JOIN FETCH r.participantsReception"
+ + " LEFT JOIN FETCH r.groupeParticipantsReception LEFT JOIN FETCH r.participantsEnvoi"
+ + " WHERE r.referentiel.version = :referentielVersion AND r.typeFichier.code = :codeTypeFichier");
+
+ query.setParameter("codeTypeFichier", id.getTypeFichier());
+ query.setParameter("referentielVersion", id.getReferentiel());
+
+ Optional<Routage> optionalRoutage = query.getResultList().stream().findFirst();
+
+ if (optionalRoutage.isPresent()) {
+ return optionalRoutage.get();
+ } else {
+ return null;
+ }
+ }
+
+ 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;
+ }
+
+ Long countRoutageByReferentielTypeFichierForParticipantForReceive(String versionReferentiel, String codeTypeFichier, Participant participant);
+
+ Long countRoutageByReferentielTypeFichierForParticipantForSend(String versionReferentiel, String codeTypeFichier, Participant participant);
+
+}
--
Gitblit v1.10.0