/*
|
* 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.fdxconsultation.dao.impl.referentiel.historique;
|
|
import com.megatim.fdxcommons.dao.ifaces.referentiel.historique.ReferentielIntegrationHistoriqueDAO;
|
import com.megatim.fdxcommons.model.referentiel.historique.ReferentielIntegrationHistorique;
|
import com.megatim.fdxcommons.model.referentiel.historique.ReferentielIntegrationHistoriqueId;
|
import java.util.List;
|
import java.util.Optional;
|
import javax.ejb.Stateless;
|
import javax.persistence.EntityManager;
|
import javax.persistence.PersistenceContext;
|
|
/**
|
*
|
* @author ASUS
|
*/
|
@Stateless
|
public class ReferentielIntegrationHistoriqueDAOImpl implements ReferentielIntegrationHistoriqueDAO {
|
|
@PersistenceContext(unitName = "fdxConsultationPersistenceUnit")
|
protected EntityManager em;
|
|
@Override
|
public Class<ReferentielIntegrationHistorique> getManagedEntityClass() {
|
return ReferentielIntegrationHistorique.class;
|
}
|
|
@Override
|
public EntityManager getEntityManager() {
|
return em;
|
}
|
|
@Override
|
public ReferentielIntegrationHistorique getById(ReferentielIntegrationHistoriqueId id) {
|
Optional<ReferentielIntegrationHistorique> optRefInt = em
|
.createQuery("SELECT r FROM ReferentielIntegrationHistorique r"
|
+ " WHERE r.codeTypeFichier = :codeTypeFichier AND r.referentielVersion = :refVersion")
|
.setParameter("codeTypeFichier", id.getCodeTypeFichier())
|
.setParameter("refVersion", id.getReferentielVersion())
|
.getResultList()
|
.stream()
|
.findFirst();
|
|
return optRefInt.isPresent() ? optRefInt.get() : null;
|
}
|
|
@Override
|
public ReferentielIntegrationHistorique suitableIntegrationHistorique(String codeTypeFichier, String refVersion) {
|
Optional<ReferentielIntegrationHistorique> optRefInt = em
|
.createQuery("SELECT r FROM ReferentielIntegrationHistorique r"
|
+ " WHERE r.codeTypeFichier = :codeTypeFichier AND :refVersion MEMBER OF r.dependingReferentiels")
|
.setParameter("codeTypeFichier", codeTypeFichier)
|
.setParameter("refVersion", refVersion)
|
.getResultList()
|
.stream()
|
.findFirst();
|
|
return optRefInt.isPresent() ? optRefInt.get() : null;
|
}
|
|
@Override
|
public List<ReferentielIntegrationHistorique> suitableIntegrationHistorique(String refVersion) {
|
return em
|
.createQuery("SELECT r FROM ReferentielIntegrationHistorique r"
|
+ " WHERE :refVersion MEMBER OF r.dependingReferentiels")
|
.setParameter("refVersion", refVersion)
|
.getResultList();
|
}
|
}
|
