/*
|
* 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.referentiel;
|
|
import com.megatim.apifdxweb.dao.ifaces.referentiel.TypeFichierDAO;
|
import com.megatim.fdxcommons.model.referentiel.TypeFichier;
|
import java.util.List;
|
import java.util.Optional;
|
import javax.ejb.Stateless;
|
import javax.inject.Inject;
|
import javax.persistence.EntityManager;
|
import javax.persistence.PersistenceContext;
|
import javax.persistence.Query;
|
|
/**
|
*
|
* @author ASUS
|
*/
|
@Stateless
|
public class TypeFichierDAOImpl implements TypeFichierDAO {
|
|
@PersistenceContext(unitName = "fdxPU")
|
protected EntityManager em;
|
|
public TypeFichierDAOImpl() {
|
}
|
|
@Override
|
public EntityManager getEntityManager() {
|
return em;
|
}
|
|
@Override
|
public Class<TypeFichier> getManagedEntityClass() {
|
return (TypeFichier.class);
|
}
|
|
@Override
|
public TypeFichier getById(String id) {
|
Query query = em.createQuery("SELECT t from TypeFichier t"
|
+ " LEFT JOIN FETCH t.routages LEFT JOIN FETCH t.validateurFichiers "
|
+ " LEFT JOIN FETCH t.validateurFichierConfigurations"
|
+ " WHERE t.code = :code");
|
query.setParameter("code", id);
|
|
Optional<TypeFichier> optionalTypeFichier = query.getResultList().stream().findFirst();
|
return optionalTypeFichier.isPresent() ? optionalTypeFichier.get() : null;
|
}
|
|
@Override
|
public List<TypeFichier> getByReferentiel(String referentielVersion) {
|
|
Query query = em.createQuery("SELECT t from TypeFichier t WHERE t.referentiel.version = :referentielVersion");
|
query.setParameter("referentielVersion", referentielVersion);
|
|
return query.getResultList();
|
|
}
|
}
|
