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-impl/src/main/java/com/megatim/apifdxweb/dao/impl/tmp/TokenTmpDAOImpl.java |   75 +++++++++++++++++++++++++++++++++++++
 1 files changed, 75 insertions(+), 0 deletions(-)

diff --git a/apifdxweb/api/apifdxweb-dao-impl/src/main/java/com/megatim/apifdxweb/dao/impl/tmp/TokenTmpDAOImpl.java b/apifdxweb/api/apifdxweb-dao-impl/src/main/java/com/megatim/apifdxweb/dao/impl/tmp/TokenTmpDAOImpl.java
new file mode 100644
index 0000000..4db84e7
--- /dev/null
+++ b/apifdxweb/api/apifdxweb-dao-impl/src/main/java/com/megatim/apifdxweb/dao/impl/tmp/TokenTmpDAOImpl.java
@@ -0,0 +1,75 @@
+/*
+ * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
+ * Click nbfs://nbhost/SystemFileSystem/Templates/Classes/Class.java to edit this template
+ */
+package com.megatim.apifdxweb.dao.impl.tmp;
+
+import com.megatim.apifdxweb.dao.ifaces.tmp.TokenTmpDAO;
+import com.megatim.apifdxweb.model.tmp.StatutTmp;
+import com.megatim.apifdxweb.model.tmp.TokenTmp;
+import java.time.LocalDateTime;
+import java.util.List;
+import java.util.Optional;
+import javax.ejb.Stateless;
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+import javax.persistence.Query;
+
+/**
+ *
+ * @author ASUS
+ */
+@Stateless
+public class TokenTmpDAOImpl implements TokenTmpDAO {
+
+    @PersistenceContext(unitName = "fdxPU")
+    protected EntityManager em;
+
+    @Override
+    public Class<TokenTmp> getManagedEntityClass() {
+        return TokenTmp.class;
+    }
+
+    @Override
+    public EntityManager getEntityManager() {
+        return em;
+    }
+
+    @Override
+    public TokenTmp getById(String id) {
+        Query query = em.createQuery("SELECT t from TokenTmp t  WHERE t.id = :id");
+        query.setParameter("id", id);
+
+        Optional<TokenTmp> optionalTokenTmp = query.getResultList().stream().findFirst();
+        return optionalTokenTmp.isPresent() ? optionalTokenTmp.get() : null;
+    }
+
+    @Override
+    public List<TokenTmp> getByStatutTmp(StatutTmp statutTmp) {
+        Query query = em.createQuery("SELECT t from TokenTmp t  WHERE t.statutTmp = :statut");
+        query.setParameter("statut", statutTmp);
+        return query.getResultList();
+    }
+
+    @Override
+    public List<TokenTmp> getExpiredToken() {
+        Query query = em.createQuery("SELECT t from TokenTmp t  WHERE t.dateExpiration <= :now OR t.statutTmp = :statut");
+        query.setParameter("now", LocalDateTime.now());
+        query.setParameter("statut", StatutTmp.EXPIRE);
+
+        return query.getResultList();
+    }
+
+    @Override
+    public TokenTmp getByParticipantAndTypeFichier(String codeParticipant, String codeTypeFichier) {
+        Optional<TokenTmp> optTokenTmp = em.createQuery("SELECT t from TokenTmp t  "
+                + "WHERE t.codeParticipant = :codeParticipant AND t.codeTypeFichier = :codeTypeFichier AND t.statutTmp = :statut AND t.dateExpiration > :now")
+                .setParameter("codeParticipant", codeParticipant)
+                .setParameter("codeTypeFichier", codeTypeFichier)
+                .setParameter("statut", StatutTmp.EN_COURS)
+                .setParameter("now", LocalDateTime.now())
+                .getResultList().stream().findFirst();
+
+        return optTokenTmp.isPresent() ? optTokenTmp.get() : null;
+    }
+}

--
Gitblit v1.10.0