Example usage for org.hibernate.criterion DetachedCriteria add

Introduction

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

Prototype

public DetachedCriteria add(Criterion criterion)

Source Link

Document

Add a restriction

Usage

From source file:com.lohika.alp.reporter.fe.dao.TestMethodDAOImpl.java

License:Open Source License

@Override
public List<TestMethod> listTestMethod(TestMethodFilter filter, TestInstance testInstance) {

    DetachedCriteria criteria = getFilteredCriteria(filter);

    criteria.add(Expression.eq("testInstance", testInstance));

    return hibernateTemplate.findByCriteria(criteria);
}

From source file:com.lohika.alp.reporter.fe.dao.TestMethodDAOImpl.java

License:Open Source License

@Override
public List<TestMethod> listTestMethod(TestMethodFilter filter, Test test) {

    DetachedCriteria criteria = getFilteredCriteria(filter);

    criteria.add(Expression.eq("testInstance.test", test));

    return hibernateTemplate.findByCriteria(criteria);
}

From source file:com.lohika.alp.reporter.fe.dao.TestMethodDAOImpl.java

License:Open Source License

@Override
public List<TestMethod> listTestMethod(TestMethodFilter filter, Suite suite) {
    DetachedCriteria criteria = getFilteredCriteria(filter);

    criteria.add(Expression.eq("test.suite", suite));

    return hibernateTemplate.findByCriteria(criteria);
}

From source file:com.lzw.work.cms.manager.PreCarRegisterManager.java

/**
 * /*from w ww  . j a v a2 s.com*/
 */
public void getCarList() {

    Map userMap = (Map) ServletActionContext.getRequest().getSession().getAttribute("user");

    String stationCode = (String) userMap.get("StationCode");

    String userName = (String) userMap.get("UserName");

    String isAdmin = (String) userMap.get("IsAdmin");

    String clsbdh = ServletActionContext.getRequest().getParameter("clsbdh");

    Integer page = Integer.parseInt(ServletActionContext.getRequest().getParameter("page"));

    Integer rows = Integer.parseInt(ServletActionContext.getRequest().getParameter("rows"));

    DetachedCriteria dc = DetachedCriteria.forClass(bean.getClass());

    if (!"1".equals(isAdmin)) {
        dc.add(Restrictions.eq("stationCode", stationCode));
    }

    if (clsbdh != null && !"".equals(clsbdh)) {
        dc.add(Restrictions.like("clsbdh", "%" + clsbdh));
    }

    int first = (page - 1) * rows;

    dc.setProjection(Projections.rowCount());
    Long count = (Long) this.getHibernateTemplate().findByCriteria(dc).get(0);

    dc.setProjection(null);

    dc.addOrder(Order.desc("createdDate"));
    List list = this.getHibernateTemplate().findByCriteria(dc, first, rows);

    Map map = new HashMap();

    map.put("rows", list);
    map.put("total", count.intValue());

    JSONObject jo = JSONObject.fromObject(map);
    pw.print(jo);
}

From source file:com.medicfast.DAO.SenhaDAO.java

public Senha buscarProximaSenha() { // nao usado
    Session session = (Session) em.getDelegate();

    DetachedCriteria max = DetachedCriteria.forClass(Senha.class);
    max.add(Restrictions.eq("chamado", true));
    max.setProjection(Projections.max("numero"));

    Criteria c = session.createCriteria(Senha.class);
    c.add(Restrictions.eq("chamado", false));

    c.add(Property.forName("numero").eq(max));
    return (Senha) c.uniqueResult();
}

From source file:com.nowgroup.scsee.geo.state.HibernateStateRepository.java

License:MIT License

@SuppressWarnings("unchecked")
@Override/*from   ww w.  java2  s  .c o  m*/
public List<GeoState> getStatesByCountryId(int countryId) {
    DetachedCriteria dc = DetachedCriteria.forClass(GeoState.class);
    DetachedCriteria countryCriteria = dc.createCriteria("country");
    countryCriteria.add(Restrictions.eq("id", countryId));
    countryCriteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

    return (List<GeoState>) getHibernateTemplate().findByCriteria(dc);
}

From source file:com.opengamma.masterdb.batch.DbBatchMaster.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public Pair<List<MarketDataValue>, Paging> getMarketDataValues(final ObjectId marketDataId,
        final PagingRequest pagingRequest) {
    s_logger.info("Getting the batch data snapshot: {}", marketDataId);

    final Long marketDataPK = extractOid(marketDataId);

    return getTransactionTemplateRetrying(getMaxRetries())
            .execute(new TransactionCallback<Pair<List<MarketDataValue>, Paging>>() {
                @Override//from ww  w.  j a va2  s .  co  m
                public Pair<List<MarketDataValue>, Paging> doInTransaction(final TransactionStatus status) {

                    final DetachedCriteria criteria = DetachedCriteria.forClass(MarketDataValue.class);
                    criteria.add(Restrictions.eq("marketDataId", marketDataPK));
                    //
                    List<MarketDataValue> results = Collections.emptyList();
                    if (!pagingRequest.equals(PagingRequest.NONE)) {
                        results = getHibernateTemplate().findByCriteria(criteria, pagingRequest.getFirstItem(),
                                pagingRequest.getPagingSize());
                    }
                    //
                    Paging paging;
                    if (pagingRequest.equals(PagingRequest.ALL)) {
                        paging = Paging.of(pagingRequest, results);
                    } else {
                        criteria.setProjection(Projections.rowCount());
                        final Long totalCount = (Long) getHibernateTemplate().findByCriteria(criteria).get(0);
                        paging = Paging.of(pagingRequest, totalCount.intValue());
                    }
                    //
                    return Pair.of(results, paging);
                }
            });
}

From source file:com.opengamma.masterdb.batch.DbBatchMaster.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public Pair<List<RiskRun>, Paging> searchRiskRun(final BatchRunSearchRequest request) {
    s_logger.info("Searching BatchDocuments: ", request);

    final DetachedCriteria criteria = DetachedCriteria.forClass(RiskRun.class);

    if (request.getValuationTime() != null) {
        criteria.add(Restrictions.eq("valuationTime", request.getValuationTime()));
    }/*from   ww  w .ja  va 2s  .  co  m*/
    if (request.getVersionCorrection() != null) {
        criteria.add(Restrictions.eq("versionCorrection", request.getVersionCorrection()));
    }

    if (request.getMarketDataUid() != null) {
        criteria.createCriteria("marketData")
                .add(Restrictions.eq("baseUidScheme", request.getMarketDataUid().getScheme()))
                .add(Restrictions.eq("baseUidValue", request.getMarketDataUid().getValue()))
                .add(eqOrIsNull("baseUidVersion", request.getMarketDataUid().getVersion()));
        //.addOrder(Order.asc("baseUid"));
    }

    if (request.getViewDefinitionUid() != null) {
        criteria.add(Restrictions.eq("viewDefinitionUidScheme", request.getViewDefinitionUid().getScheme()))
                .add(Restrictions.eq("viewDefinitionUidValue", request.getViewDefinitionUid().getValue()))
                .add(eqOrIsNull("viewDefinitionUidVersion", request.getViewDefinitionUid().getVersion()));
        //.addOrder(Order.asc("viewDefinitionUid"));
    }

    return getTransactionTemplateRetrying(getMaxRetries())
            .execute(new TransactionCallback<Pair<List<RiskRun>, Paging>>() {
                @Override
                public Pair<List<RiskRun>, Paging> doInTransaction(final TransactionStatus status) {
                    //
                    final PagingRequest pagingRequest = request.getPagingRequest();
                    List<RiskRun> results = Collections.emptyList();
                    Paging paging;
                    if (!pagingRequest.equals(PagingRequest.NONE)) {
                        if (pagingRequest.equals(PagingRequest.ALL)) {
                            criteria.addOrder(Order.asc("valuationTime"));
                            results = getHibernateTemplate().findByCriteria(criteria,
                                    pagingRequest.getFirstItem(), pagingRequest.getPagingSize());
                            //
                            paging = Paging.of(pagingRequest, results);
                        } else {
                            criteria.setProjection(Projections.rowCount());
                            final Long totalCount = (Long) getHibernateTemplate().findByCriteria(criteria)
                                    .get(0);
                            paging = Paging.of(pagingRequest, totalCount.intValue());
                            //
                            criteria.setProjection(null);
                            criteria.setResultTransformer(Criteria.ROOT_ENTITY);
                            criteria.addOrder(Order.asc("valuationTime"));
                            results = getHibernateTemplate().findByCriteria(criteria,
                                    pagingRequest.getFirstItem(), pagingRequest.getPagingSize());
                        }
                    } else {
                        paging = Paging.of(PagingRequest.NONE, 0);
                    }
                    return Pair.of(results, paging);
                }
            });
}

From source file:com.opengamma.masterdb.batch.DbBatchWriter.java

License:Open Source License

public MarketData createOrGetMarketDataInTransaction(final UniqueId baseUid) {
    s_logger.info("Creating Market Data {} ", baseUid);
    MarketData marketData = getHibernateTemplate().execute(new HibernateCallback<MarketData>() {
        @Override//from   w  ww .  java 2s  . c  o m
        public MarketData doInHibernate(Session session) throws HibernateException, SQLException {

            final DetachedCriteria criteria = DetachedCriteria.forClass(MarketData.class);
            criteria.add(Restrictions.eq("baseUidScheme", baseUid.getScheme()))
                    .add(Restrictions.eq("baseUidValue", baseUid.getValue()))
                    .add(eqOrIsNull("baseUidVersion", baseUid.getVersion()));

            @SuppressWarnings("unchecked")
            List<MarketData> datas = getHibernateTemplate().findByCriteria(criteria, 0, 1);
            if (datas.size() > 0) {
                return datas.get(0);
            } else {
                return null;
            }
        }
    });
    if (marketData != null) {
        s_logger.info("Snapshot " + baseUid + " already exists. No need to create.");
    } else {
        marketData = new MarketData();
        marketData.setBaseUid(baseUid);
        getHibernateTemplate().save(marketData);
        getHibernateTemplate().flush();
    }
    return marketData;
}

From source file:com.ourlife.dev.modules.sys.service.SystemService.java

License:Open Source License

public Page<User> findUser(Page<User> page, User user) {
    DetachedCriteria dc = userDao.createDetachedCriteria();
    User currentUser = UserUtils.getUser();
    dc.createAlias("company", "company");
    if (user.getCompany() != null && user.getCompany().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("company.id", user.getCompany().getId()),
                Restrictions.like("company.parentIds", "%," + user.getCompany().getId() + ",%")));
    }//w w w .ja v  a2 s.c om
    dc.createAlias("office", "office");
    if (user.getOffice() != null && user.getOffice().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("office.id", user.getOffice().getId()),
                Restrictions.like("office.parentIds", "%," + user.getOffice().getId() + ",%")));
    }
    // ????
    if (!currentUser.isAdmin()) {
        dc.add(Restrictions.ne("id", 1L));
    }
    dc.add(dataScopeFilter(currentUser, "office", ""));
    // System.out.println(dataScopeFilterString(currentUser, "office", ""));
    if (StringUtils.isNotEmpty(user.getLoginName())) {
        dc.add(Restrictions.like("loginName", "%" + user.getLoginName() + "%"));
    }
    if (StringUtils.isNotEmpty(user.getName())) {
        dc.add(Restrictions.like("name", "%" + user.getName() + "%"));
    }
    dc.add(Restrictions.eq(User.DEL_FLAG, User.DEL_FLAG_NORMAL));
    if (!StringUtils.isNotEmpty(page.getOrderBy())) {
        dc.addOrder(Order.asc("company.code")).addOrder(Order.asc("office.code")).addOrder(Order.desc("id"));
    }
    return userDao.find(page, dc);
}