nc.noumea.mairie.appock.dao.impl.ArticleCatalogueDaoImpl.java Source code

Introduction

Here is the source code for nc.noumea.mairie.appock.dao.impl.ArticleCatalogueDaoImpl.java

Source

package nc.noumea.mairie.appock.dao.impl;

/*-
 * #%L
 * Logiciel de Gestion des approvisionnements et des stocks des fournitures administratives de la Mairie de Nouma
 * %%
 * Copyright (C) 2017 Mairie de Nouma, Nouvelle-Caldonie
 * %%
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public
 * License along with this program.  If not, see
 * <http://www.gnu.org/licenses/gpl-3.0.html>.
 * #L%
 */

import javax.persistence.NoResultException;
import javax.persistence.Query;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import nc.noumea.mairie.appock.core.utility.AppockUtil;
import nc.noumea.mairie.appock.dao.ArticleCatalogueDao;
import nc.noumea.mairie.appock.dao.PersistentManager;
import nc.noumea.mairie.appock.entity.ArticleCatalogue;
import nc.noumea.mairie.appock.entity.Catalogue;

@Repository("articleCatalogueDao")
public class ArticleCatalogueDaoImpl implements ArticleCatalogueDao {

    @Autowired
    protected PersistentManager<ArticleCatalogue> persistentManager;

    @Override
    public ArticleCatalogue findByReferenceAndCatalogue(String reference, Catalogue catalogue) {
        // @formatter:off
        String jpaQuery = "   SELECT articleCatalogue FROM ArticleCatalogue articleCatalogue "
                + "         left join articleCatalogue.sousFamille sousFamille "
                + "         left join sousFamille.famille famille "
                + "         left join famille.catalogue catalogue "
                + "       WHERE articleCatalogue.reference = :reference " + "         AND catalogue = :catalogue";
        // @formatter:on

        Query query = persistentManager.getEntityManager().createQuery(jpaQuery);

        AppockUtil.setParameter(query, "reference", reference);
        AppockUtil.setParameter(query, "catalogue", catalogue);

        try {
            return (ArticleCatalogue) query.getSingleResult();
        } catch (NoResultException e) {
            return null;
        }
    }
}