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

Introduction

Here is the source code for nc.noumea.mairie.appock.dao.impl.AppUserDaoImpl.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 java.util.List;

import javax.persistence.Query;

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

import nc.noumea.mairie.appock.core.security.AppUser;
import nc.noumea.mairie.appock.dao.AppUserDao;
import nc.noumea.mairie.appock.dao.PersistentManager;
import nc.noumea.mairie.appock.enums.Role;

@Repository("appUserDao")
public class AppUserDaoImpl implements AppUserDao {

    @Autowired
    protected PersistentManager<AppUser> persistentManager;

    @SuppressWarnings("unchecked")
    @Override
    public List<AppUser> findAllWithRole(Role role) {
        String orderBy = " ORDER BY u.actif desc, u.nom, u.prenom asc";
        String requeteJpa = "SELECT u FROM AppUser u INNER JOIN u.listeRole r " //
                + " WHERE r=:role " //
                + orderBy;
        Query query = persistentManager.getEntityManager().createQuery(requeteJpa);
        query.setParameter("role", role);
        return query.getResultList();
    }
}