Example usage for org.hibernate.criterion Projections property

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections property.

Prototype

public static PropertyProjection property(String propertyName)

Source Link

Document

A property value projection

Usage

From source file:com.court.controller.ReportFormFxmlController.java

private List<LoanPayCheque> getCollectionInvoice() {
    Session s = HibernateUtil.getSessionFactory().openSession();
    Criteria c = s.createCriteria(LoanPayCheque.class);
    c.setProjection(Projections.property("invoCode"));
    c.setResultTransformer(Transformers.aliasToBean(LoanPayCheque.class));
    List<LoanPayCheque> list = c.list();
    s.close();//w ww .  j  a va2s .  com
    return list;
}

From source file:com.court.controller.ReportFormFxmlController.java

private List<String> getReceiptCodes(String rptType) {

    Session s = HibernateUtil.getSessionFactory().openSession();
    Criteria c = s.createCriteria(ReceiptPay.class);
    c.add(Restrictions.eq("paymentType", rptType));
    c.setProjection(Projections.property("receiptCode"));
    List<String> list = c.list();
    return list;/*from w  w  w  .  j a va2s. c  o  m*/

}

From source file:com.court.controller.UserManageFxmlController.java

private List<String> getAvailableUserRoles() {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria c = session.createCriteria(UserRole.class);
    List<String> roles = c.setProjection(Projections.property("roleName")).list();
    session.close();/*from w w  w .  ja v  a  2s  .  co m*/
    return roles;
}

From source file:com.court.controller.UserManageFxmlController.java

private List<String> getAvailableUserFullNames() {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria c = session.createCriteria(User.class);
    List<String> uFullNames = c.setProjection(Projections.property("fullName")).list();
    session.close();//  w  w  w  . jav a 2s  . co m
    return uFullNames;
}

From source file:com.cristian.tareask.daoImpl.MessageReceptorDaoImpl.java

@Override
public List<Integer> getAllMessageReceptorsByConversationUnique(Integer idConversation) {
    s = HibernateUtil.getSessionFactory().openSession();
    s.beginTransaction();//from   w  w  w.ja  va 2s . c  o  m
    Criteria c = s.createCriteria(MessageReceptor.class)
            .add(Restrictions.eq("emailConversation.id", idConversation))
            .setProjection(Projections.distinct(Projections.property("user.id")));
    return c.list();
}

From source file:com.cristian.tareask.daoImpl.MessageReceptorDaoImpl.java

@Override
public List<Integer> getAllMessageReceptorsByMessageUnique(Integer idMessage) {
    s = HibernateUtil.getSessionFactory().openSession();
    s.beginTransaction();//from   ww  w .ja v a 2s . c  o m
    Criteria c = s.createCriteria(MessageReceptor.class)
            .setProjection(Projections.distinct(Projections.property("user.id")))
            .add(Restrictions.eq("emailMessage.id", idMessage));
    return c.list();
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateApplicationChannelDao.java

License:Mozilla Public License

@Override
public Calendar getMostRecentScanTime(Integer channelId) {

    return (Calendar) sessionFactory.getCurrentSession().createCriteria(Scan.class)
            .addOrder(Order.desc("importTime")).setProjection(Projections.property("importTime"))
            .setMaxResults(1).uniqueResult();
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateScanDao.java

License:Mozilla Public License

@Override
public List<Integer> mapIDsThatNeedCountersInApps(List<Integer> appIds,
        Collection<Integer> findingIdRestrictions) {

    // get list of finding IDs to ScanRepeatFindingMapIDs
    ProjectionList list = Projections.projectionList().add(Projections.id()) // 0
            .add(Projections.property("findingAlias.id")); // 1
    List<Object[]> idArrayList = getBasicMapCriteria().createAlias("finding", "findingAlias")
            .setProjection(list).list();

    // move results into Java Map
    // needs to be int -> list<int> because you can have multiple maps to a single finding ID
    // and they all need counters
    Map<Integer, List<Integer>> findingIdToMapIdMap = map();
    for (Object[] integers : idArrayList) {
        if (integers[0] instanceof Integer && integers[1] instanceof Integer) {
            Integer findingId = (Integer) integers[1], mapId = (Integer) integers[0];
            if (!findingIdToMapIdMap.containsKey(findingId)) {
                findingIdToMapIdMap.put(findingId, listOf(Integer.class));
            }/*from   w  w w.  j  ava 2 s  .c  o  m*/

            findingIdToMapIdMap.get(findingId).add(mapId);
        }
    }

    // keep only valid finding IDs
    Set<Integer> keys = findingIdToMapIdMap.keySet();
    keys.retainAll(findingIdRestrictions);

    // map to the ScanRepeatFindingMap IDs
    List<Integer> mapIds = list();
    for (Integer key : keys) {
        mapIds.addAll(findingIdToMapIdMap.get(key));
    }
    return mapIds;
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateVulnerabilitySearchDao.java

License:Mozilla Public License

private List<Integer> getVulnIdList(VulnerabilitySearchParameters parameters) {
    Criteria criteria = VulnerabilitySearchCriteriaConstructor
            .getCriteriaWithRestrictions(sessionFactory.getCurrentSession(), parameters);

    criteria.setProjection(Projections.projectionList().add(Projections.property("id")));

    List<Integer> idList = (List<Integer>) criteria.list();
    return idList;
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.VulnerabilitySearchCriteriaConstructor.java

License:Mozilla Public License

private void addAppTags() {
    List<Integer> appIds;
    List<Integer> tagIds = list();

    if (parameters.getTags() != null) {
        for (Tag tag : parameters.getTags()) {
            if (tag.getId() != null) {
                tagIds.add(tag.getId());
            }/*from   w w w .  ja v a  2 s .  c o  m*/
        }
    }

    if (tagIds.isEmpty()) {
        LOG.debug("No tag IDs found in parameters.");
    } else {
        Criteria subCriteria = session.createCriteria(Tag.class);
        subCriteria.createAlias("applications", "applicationsAlias");
        subCriteria.add(Restrictions.in("id", tagIds));
        subCriteria.setProjection(Projections.property("applicationsAlias.id"));
        appIds = (List<Integer>) subCriteria.list();

        if (appIds.isEmpty())
            appIds.add(0);
        criteria.add(Restrictions.in("application.id", appIds));
        LOG.debug("Added applications with IDs " + appIds);
    }
}