Example usage for org.hibernate.criterion DetachedCriteria createAlias

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria createAlias.

Prototype

public DetachedCriteria createAlias(String associationPath, String alias)

Source Link

Document

Creates an association path alias within this DetachedCriteria.

Usage

From source file:org.gaixie.micrite.crm.dao.hibernate.CustomerDAOImpl.java

License:Open Source License

public int findByCreateDateSpacingCount(Date startDate, Date endDate, int customerSourceType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Carowner.class);
    criteria.createAlias("customerSource", "cs");
    if (0 != customerSourceType) {
        criteria.add(Expression.eq("cs.id", customerSourceType));
    }//from w w  w .j  a v  a2s .c o m
    criteria.add(Expression.between("creation_ts", startDate, endDate));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.crm.dao.hibernate.CustomerDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Carowner> findByCreateDateSpacingPerPage(Date startDate, Date endDate, int start, int limit,
        int customerSourceType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Carowner.class);
    criteria.createAlias("customerSource", "cs");
    if (0 != customerSourceType) {
        criteria.add(Expression.eq("cs.id", customerSourceType));
    }/*from www  . j  a v  a2s.  com*/
    criteria.add(Expression.between("creation_ts", startDate, endDate));
    return getHibernateTemplate().findByCriteria(criteria, start, limit);
}

From source file:org.gaixie.micrite.crm.dao.hibernate.CustomerDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(Carowner.class, queryBean);
    criteria.createAlias("customerSource", "cs");
    criteria.setProjection(Projections.projectionList().add(Projections.count("cs.name"))
            .add(Projections.groupProperty("cs.name")));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.gaixie.micrite.enterprise.dao.hibernate.EnterpriseDAOImpl.java

public int findByCreateDateSpacingCount(Date startDate, Date endDate, int EnterpriseSourceType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Enterprise.class);
    criteria.createAlias("enterpriseSource8", "cs");
    if (0 != EnterpriseSourceType) {
        criteria.add(Expression.eq("cs.id", EnterpriseSourceType));
    }/*ww  w . j  av  a  2 s.c  om*/
    criteria.add(Expression.between("createDate", startDate, endDate));
    criteria.add(Restrictions.ne("id", 1));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.enterprise.dao.hibernate.EnterpriseDAOImpl.java

@SuppressWarnings("unchecked")
public List<Enterprise> findByCreateDateSpacingPerPage(Date startDate, Date endDate, int start, int limit,
        int EnterpriseSourceType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Enterprise.class);
    criteria.createAlias("enterpriseSource8", "cs");
    if (0 != EnterpriseSourceType) {
        criteria.add(Expression.eq("cs.id", EnterpriseSourceType));
    }/*from w w w  .ja v a2 s  .  c o  m*/
    criteria.add(Expression.between("createDate", startDate, endDate));
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    return getHibernateTemplate().findByCriteria(criteria, start, limit);
}

From source file:org.gaixie.micrite.enterprise.dao.hibernate.EnterpriseDAOImpl.java

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(Enterprise.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.createAlias("qualification", "cs");
    criteria.setProjection(Projections.projectionList().add(Projections.count("cs.name"))
            .add(Projections.groupProperty("cs.name")));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.gaixie.micrite.patrolRiverSummary.dao.hibernate.PatrolRiverSummaryDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<PatrolRiverSummary> findByCreateDateSpacingPerPage(int start, int limit, int carType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(PatrolRiverSummary.class);
    criteria.add(Expression.eq("status", IPatrolRiverSummaryService.STATUS_NORMAL));
    criteria.addOrder(Order.desc("editDate"));
    criteria.createAlias("skillRank", "cs");
    if (0 != carType) {
        criteria.add(Expression.eq("cs.id", carType));
    }//from   w ww  .  ja v  a  2 s  .  c om
    List<PatrolRiverSummary> list = getHibernateTemplate().findByCriteria(criteria, start, limit);

    return list;
}

From source file:org.gaixie.micrite.patrolRiverSummary.dao.hibernate.PatrolRiverSummaryDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(PatrolRiverSummary.class, queryBean);
    criteria.add(Expression.eq("approveStatus", IPatrolRiverSummaryService.STATUS_NORMAL));
    criteria.addOrder(Order.desc("editDate"));
    criteria.createAlias("carType", "cs");
    criteria.setProjection(Projections.projectionList().add(Projections.count("cs.name"))
            .add(Projections.groupProperty("cs.name")));
    List<PatrolRiverSummary> list = getHibernateTemplate().findByCriteria(criteria);
    //        desidedExpiredFlag(list);
    return list;//  w  ww .  j  ava  2 s  .c  o m
}

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(River.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.createAlias("village", "cs");
    criteria.setProjection(Projections.projectionList().add(Projections.count("cs.vname"))
            .add(Projections.groupProperty("cs.vname")));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.generationcp.middleware.dao.dms.DmsProjectDao.java

License:Open Source License

private Criteria buildCoreCriteria(final Map<StudyFilters, String> parameters, final Order orderBy) {
    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());
    criteria.add(Restrictions.isNotNull("studyType"));

    criteria.add(Restrictions.ne(DmsProjectDao.DELETED, true));

    if (parameters.containsKey(StudyFilters.PROGRAM_ID)) {
        criteria.add(Restrictions.eq(StudyFilters.PROGRAM_ID.getParameter(),
                parameters.get(StudyFilters.PROGRAM_ID)));
    } else {/*from  ww  w  . java 2s . c o  m*/
        criteria.add(Restrictions.isNotNull(StudyFilters.PROGRAM_ID.getParameter()));
    }

    if (parameters.containsKey(StudyFilters.LOCATION_ID)) {
        // Find environments with specified location (saved in GeolocationProperty)
        final DetachedCriteria locationCriteria = DetachedCriteria.forClass(ExperimentModel.class);
        locationCriteria.add(Restrictions.eq("typeId", TermId.TRIAL_ENVIRONMENT_EXPERIMENT.getId()));
        locationCriteria.createAlias("geoLocation", "g");
        locationCriteria.createAlias("g.properties", "gp");
        locationCriteria.createAlias("project", "p");
        locationCriteria.createAlias("p.study", "st");
        locationCriteria.add(Restrictions.and(Restrictions.eq("gp.typeId", DmsProjectDao.LOCATION_ID),
                Restrictions.eq("gp.value", parameters.get(StudyFilters.LOCATION_ID))));
        locationCriteria.setProjection(Projections.property("st.projectId"));
        criteria.add(Property.forName("projectId").in(locationCriteria));
    }

    criteria.addOrder(orderBy);
    return criteria;
}