Card.java 文件源码

public static List<Object> countNbCardsByRejets(String userType, Date date) {
    EntityManager em = Card.entityManager();
    String sql = "SELECT nb_rejets, count(*) FROM card WHERE request_date>=:date GROUP BY nb_rejets";
    if (!userType.isEmpty()) {
        sql = "SELECT nb_rejets, count(*) FROM card, user_account WHERE card.user_account= user_account.id " + "AND request_date>=:date  AND user_type = :userType GROUP BY nb_rejets";
    }
    Query q = em.createNativeQuery(sql);
    q.setParameter("date", date);
    if (!userType.isEmpty()) {
        q.setParameter("userType", userType);
    }
    return q.getResultList();
}