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.rockagen.gnext.service.spring.AccountBillServImpl.java

License:Apache License

@Override
public List<AccountBill> loadListByAccount(long accountId) {
    QueryObject qo = new QueryObject();
    DetachedCriteria dc = qo.generateDetachedCriteria(AccountBill.class);
    dc.createAlias("account", "a");
    dc.add(Restrictions.eq("a.id", accountId));
    dc.addOrder(Order.desc("createdAt"));
    return find(qo);
}

---

From source file:com.rockagen.gnext.service.spring.AccountServImpl.java

License:Apache License

@Override
public List<Account> loadListByUid(long uid) {
    QueryObject qo = new QueryObject();
    DetachedCriteria dc = qo.generateDetachedCriteria(Account.class);
    dc.createAlias("user", "u");
    dc.add(Restrictions.eq("u.id", uid));
    dc.addOrder(Order.desc("updatedAt"));
    return find(qo);
}

---

From source file:com.rockagen.gnext.test.ServiceTest.java

License:Apache License

@Test
@Ignore// w  w w .  j a  va2s .  c  o m
public void testXX() {
    QueryObject qo = new QueryObject();
    DetachedCriteria dc = qo.generateDetachedCriteria(AuthGroup.class);
    dc.createAlias("users", "u");
    dc.add(Restrictions.eq("u.id", 20L));
    List<AuthGroup> ags = authGroupServ.find(qo);
    ags.forEach(x -> System.err.println(x.getDescr()));
}

---

From source file:com.rta.vsd.data.service.impl.OwnerInfoDataServiceImpl.java

/**
 * //from  w  w w. j  av a  2s  .  co  m
 * Gets the owner info from the latest plate details provided.
 * 
 * @author Eldon Barrows
 * @param dsContext
 * @param retrieveArabicData
 * @param plateDetails
 * @return 
 * @throws VSDDataAccessException
 */
public VsdOwnerInfo getOwnerInfoByLatestPlateDetails(DataServiceContext dsContext, boolean retrieveArabicData,
        VehiclePlate plateDetails) throws VSDDataAccessException {
    logger.info("getOwnerInfoByLatestPlateDetails -- START");
    try {
        Session session = (Session) dsContext.getInternalContext();
        DetachedCriteria dc = DetachedCriteria.forClass(VsdVehicleInfo.class, "vi")
                .add(Restrictions.eq("vi.isDeleted", IDataService.BOOL_FALSE))
                .createCriteria("vi.vsdOwnerInfos", "oi", Criteria.INNER_JOIN)
                .add(Restrictions.eq("oi.isDeleted", IDataService.BOOL_FALSE));
        dc.setProjection(Projections.max("vi.createdTimestamp"));
        if (plateDetails != null && plateDetails.getPlateCategory() != null
                && !plateDetails.getPlateCategory().equals("")) {
            dc.add(Restrictions.eq("vi.vehiclePlateCategory", plateDetails.getPlateCategory()));
        }
        if (plateDetails != null && plateDetails.getPlateCode() != null
                && !plateDetails.getPlateCode().equals("")) {
            dc.add(Restrictions.eq("vi.vehiclePlateCode", plateDetails.getPlateCode()));
        }
        if (plateDetails != null && plateDetails.getPlateNumber() != null
                && !plateDetails.getPlateNumber().equals("")) {
            dc.add(Restrictions.eq("vi.vehiclePlateNumber", plateDetails.getPlateNumber()));
        }
        if (plateDetails != null && plateDetails.getPlateSource() != null
                && !plateDetails.getPlateSource().equals("")) {
            dc.add(Restrictions.eq("vi.vehiclePlateSource", plateDetails.getPlateSource()));
        }

        Criteria crit = session.createCriteria(VsdVehicleInfo.class, "vInfo")
                .createCriteria("vInfo.vsdOwnerInfos", "oi", Criteria.INNER_JOIN,
                        Restrictions.eq("oi.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("vInfo.isDeleted", IDataService.BOOL_FALSE))
                .add(Property.forName("vInfo.createdTimestamp").in(dc));
        //                     crit.setProjection(Projections.property("vInfo.vehicleInfoId"));                     
        if (plateDetails != null && plateDetails.getPlateCategory() != null
                && !plateDetails.getPlateCategory().equals("")) {
            crit.add(Restrictions.eq("vInfo.vehiclePlateCategory", plateDetails.getPlateCategory()));
        }
        if (plateDetails != null && plateDetails.getPlateCode() != null
                && !plateDetails.getPlateCode().equals("")) {
            crit.add(Restrictions.eq("vInfo.vehiclePlateCode", plateDetails.getPlateCode()));
        }
        if (plateDetails != null && plateDetails.getPlateNumber() != null
                && !plateDetails.getPlateNumber().equals("")) {
            crit.add(Restrictions.eq("vInfo.vehiclePlateNumber", plateDetails.getPlateNumber()));
        }
        if (plateDetails != null && plateDetails.getPlateSource() != null
                && !plateDetails.getPlateSource().equals("")) {
            crit.add(Restrictions.eq("vInfo.vehiclePlateSource", plateDetails.getPlateSource()));
        }
        crit.addOrder(Order.desc("vInfo.createdTimestamp"));
        List<VsdVehicleInfo> vehicles = crit.list();
        if (vehicles == null || vehicles.isEmpty())
            return null;
        Long vehicleInfoId = (Long) vehicles.get(0).getVehicleInfoId();
        System.out.println("vehicleInfoId " + vehicleInfoId);
        VsdOwnerInfo ownerInfo = (VsdOwnerInfo) session.createCriteria(VsdOwnerInfo.class, "oi")
                .add(Restrictions.eq("oi.isDeleted", IDataService.BOOL_FALSE))
                .add(Restrictions.eq("oi.vehicleInfoId", vehicleInfoId)).uniqueResult();

        logger.info("getOwnerInfoByLatestPlateDetails -- END");
        return ownerInfo;
    } catch (Exception ex) {
        logger.error("An error occured in getOwnerInfoByLatestPlateDetails()");
        throw new VSDDataAccessException(ex.getMessage(), ex);
    }
}

---

From source file:com.rz.action.admin.DriverAction.java

public String list() {
    if (pager == null) {
        pager = new Pager();
    }//from   www  . jav a 2  s. co m
    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Driver.class);
    if (driverId != null) {
        detachedCriteria.add(Restrictions.eq("id", driverId));
    }

    loginAdmin = this.getLoginAdmin();
    if ("admin".equals(loginAdmin.getUsername())) {
        pager = driverService.findByPager(pager, detachedCriteria);
    } else {
        detachedCriteria.add(Restrictions.eq("company", loginAdmin.getCompany()));
        pager = driverService.findByPager(pager, detachedCriteria);
    }
    return LIST;
}

---

From source file:com.saituo.talk.modules.sys.utils.UserUtils.java

License:Open Source License

public static List<Office> getOfficeList() {
    @SuppressWarnings("unchecked")
    List<Office> officeList = (List<Office>) getCache(CACHE_OFFICE_LIST);
    if (officeList == null) {
        User user = getUser();/*from  ww  w .j av a2s.c o m*/
        // if (user.isAdmin()){
        // officeList = officeDao.findAllList();
        // }else{
        // officeList = officeDao.findAllChild(user.getOffice().getId(),
        // "%,"+user.getOffice().getId()+",%");
        // }
        DetachedCriteria dc = officeDao.createDetachedCriteria();
        dc.add(dataScopeFilter(user, dc.getAlias(), ""));
        dc.add(Restrictions.eq(Office.FIELD_DEL_FLAG, Office.DEL_FLAG_NORMAL));
        dc.addOrder(Order.asc("code"));
        officeList = officeDao.find(dc);
        putCache(CACHE_OFFICE_LIST, officeList);
    }
    return officeList;
}

---

From source file:com.salesmanager.core.service.catalog.impl.db.dao.CategoryDao.java

License:Open Source License

public Collection<Category> findByCategoryIds(Collection<Long> categoryIds) {

    try {//from w w  w  . j a  v  a2  s . co  m

        if (categoryIds == null)
            return null;

        DetachedCriteria crit = DetachedCriteria.forClass(Category.class);
        crit.add(Expression.in("categoryId", categoryIds));
        Collection result = this.getHibernateTemplate().findByCriteria(crit);

        return result;

    } catch (RuntimeException e) {
        log.error("get failed", e);
        throw e;
    }

}

---

From source file:com.salesmanager.core.service.catalog.impl.db.dao.CategoryDescriptionDao.java

License:Open Source License

public Collection<CategoryDescription> findByCategoryIds(Collection<Long> categoryIds) {

    try {/*from  w  ww . ja  v  a  2s  . co m*/

        if (categoryIds == null)
            return null;

        DetachedCriteria crit = DetachedCriteria.forClass(CategoryDescription.class);
        crit.add(Expression.in("id.categoryId", categoryIds));
        Collection result = this.getHibernateTemplate().findByCriteria(crit);

        return result;

    } catch (RuntimeException e) {
        log.error("get failed", e);
        throw e;
    }

}

---

From source file:com.salesmanager.core.service.reference.impl.dao.CoreModuleServiceDao.java

License:Open Source License

public Collection<CoreModuleService> findByServiceTypeAndSubTypeByRegion(int type, int subType, String region) {

    try {/*from w  w  w. j  av  a 2 s. co  m*/

        List countryList = new ArrayList();
        countryList.add(region);
        countryList.add(Constants.ALLCOUNTRY_ISOCODE);

        DetachedCriteria crit = DetachedCriteria.forClass(CoreModuleService.class);
        crit.add(Expression.in("countryIsoCode2", countryList));
        crit.add(Expression.eq("coreModuleServiceCode", type));
        crit.add(Expression.eq("coreModuleServiceSubtype", subType));
        crit.addOrder(org.hibernate.criterion.Order.desc("coreModuleServicePosition"));
        Collection result = this.getHibernateTemplate().findByCriteria(crit);

        List countrySpecificList = new ArrayList();
        Iterator i = result.iterator();
        while (i.hasNext()) {
            CoreModuleService cms = (CoreModuleService) i.next();
            if (cms.getCountryIsoCode2().equals(region)) {

                countrySpecificList.add(cms);
            }
        }

        if (countrySpecificList.size() > 0) {
            return countrySpecificList;
        } else {
            return result;
        }

    } catch (RuntimeException re) {
        // log.error("get failed", re);
        throw re;
    }
}

---

From source file:com.salesmanager.core.service.reference.impl.dao.CoreModuleServiceDao.java

License:Open Source License

public Collection<CoreModuleService> findByServiceTypeAndByRegion(int type, String region) {

    try {/*from   w ww  . j a va  2 s  .c om*/

        List countryList = new ArrayList();
        countryList.add(region);
        countryList.add(Constants.ALLCOUNTRY_ISOCODE);

        DetachedCriteria crit = DetachedCriteria.forClass(CoreModuleService.class);
        crit.add(Expression.in("countryIsoCode2", countryList));
        crit.add(Expression.eq("coreModuleServiceCode", type));
        crit.addOrder(org.hibernate.criterion.Order.desc("coreModuleServicePosition"));
        Collection result = this.getHibernateTemplate().findByCriteria(crit);

        List countrySpecificList = new ArrayList();
        Iterator i = result.iterator();
        while (i.hasNext()) {
            CoreModuleService cms = (CoreModuleService) i.next();
            if (cms.getCountryIsoCode2().equals(region)) {

                countrySpecificList.add(cms);
            }
        }

        if (countrySpecificList.size() > 0) {
            return countrySpecificList;
        } else {
            return result;
        }

    } catch (RuntimeException re) {
        throw re;
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »