Example usage for org.hibernate.criterion DetachedCriteria createAlias

List of usage examples for org.hibernate.criterion DetachedCriteria createAlias

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. 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: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 .  j  av  a  2s.  com
    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);
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public ArrayList<Employeegroupmap> getEmployeegroupmapByEmployeeID(String employeeId) throws ExceptionWrapper {
    ArrayList<Employeegroupmap> employeegroupmapArrayList = new ArrayList<Employeegroupmap>();
    try {//from  w w  w.  j  av a2  s . c om
        DetachedCriteria criteria = DetachedCriteria.forClass(Employeegroupmap.class);
        criteria.createAlias("employee", "emp");
        criteria.add(Restrictions.eq("emp.employeeId", Long.valueOf(employeeId)));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("groups", FetchMode.JOIN);
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            employeegroupmapArrayList.add((Employeegroupmap) item);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return employeegroupmapArrayList;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.EmployeeDataAccessor.java

public ArrayList<Employeelicensemapping> getEmployeeLicenseMapByEmployeeId(String employeeId)
        throws ExceptionWrapper {
    ArrayList<Employeelicensemapping> employeelicensemappingArrayList = new ArrayList<Employeelicensemapping>();
    try {/*ww w. ja  v a2 s .c  o m*/
        DetachedCriteria criteria = DetachedCriteria.forClass(Employeelicensemapping.class);
        criteria.createAlias("employee", "emp");
        criteria.add(Restrictions.eq("emp.employeeId", Long.valueOf(employeeId)));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("licensemaster", FetchMode.JOIN);
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            employeelicensemappingArrayList.add((Employeelicensemapping) item);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return employeelicensemappingArrayList;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.ImageNowLicenseDataAccessor.java

public LinkedHashMap<String, Imagenowlicenses> getAllImageNowLicenses() throws ExceptionWrapper {
    LinkedHashMap<String, Imagenowlicenses> imagenowlicensesLinkedHashMap = new LinkedHashMap<String, Imagenowlicenses>();
    try {//ww w . j  a  va2s .c om
        DetachedCriteria criteria = DetachedCriteria.forClass(Imagenowlicenses.class);
        criteria.createAlias("employeeByRequestedByEmployeeId", "emp");
        criteria.createAlias("groups", "group");
        criteria.addOrder(Order.asc("licenseRequestedOn"));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("group", FetchMode.JOIN);
        criteria.addOrder(Order.asc("licenseRequestedOn"));
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            Imagenowlicenses imagenowlicenses = (Imagenowlicenses) item;
            imagenowlicensesLinkedHashMap.put(imagenowlicenses.getImageNowLicenseRequestId(), imagenowlicenses);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return imagenowlicensesLinkedHashMap;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.ImageNowLicenseDataAccessor.java

public LinkedHashMap<String, Imagenowlicenses> getAllImageNowLicensesByRequestor(String employeeUID)
        throws ExceptionWrapper {
    LinkedHashMap<String, Imagenowlicenses> imagenowlicensesLinkedHashMap = new LinkedHashMap<String, Imagenowlicenses>();
    try {/*  w ww.j av  a2  s  .  co m*/
        DetachedCriteria criteria = DetachedCriteria.forClass(Imagenowlicenses.class);
        criteria.createAlias("employeeByRequestedByEmployeeId", "emp");
        criteria.createAlias("groups", "group");
        criteria.add(Restrictions.eq("emp.employeeUid", employeeUID));
        criteria.addOrder(Order.asc("licenseRequestedOn"));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("group", FetchMode.JOIN);
        for (Object item : hibernateTemplate.findByCriteria(criteria)) {
            Imagenowlicenses imagenowlicenses = (Imagenowlicenses) item;
            imagenowlicensesLinkedHashMap.put(imagenowlicenses.getImageNowLicenseRequestId(), imagenowlicenses);
        }
    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
    return imagenowlicensesLinkedHashMap;
}

From source file:com.perceptive.epm.perkolcentral.dataaccessor.ImageNowLicenseDataAccessor.java

public Imagenowlicenses getAllImageNowLicensesByRequestId(String requestId) throws ExceptionWrapper {

    try {/*w ww.j av  a2  s  .c o  m*/
        DetachedCriteria criteria = DetachedCriteria.forClass(Imagenowlicenses.class);
        criteria.createAlias("employeeByRequestedByEmployeeId", "emp");
        criteria.createAlias("groups", "group");
        criteria.add(Restrictions.eq("imageNowLicenseRequestId", requestId.trim()));
        criteria.setFetchMode("emp", FetchMode.JOIN);
        criteria.setFetchMode("group", FetchMode.JOIN);

        return (Imagenowlicenses) hibernateTemplate.findByCriteria(criteria).get(0);

    } catch (Exception ex) {
        throw new ExceptionWrapper(ex);
    }
}

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//from www  .ja  va 2s.  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.sccl.attech.modules.sys.service.LogService.java

License:Open Source License

public Page<Log> find(Page<Log> page, Map<String, Object> paramMap) {
    DetachedCriteria dc = logDao.createDetachedCriteria();

    //      Long createById = StringUtils.toLong(paramMap.get("createById"));
    //      if (createById > 0){
    //         dc.add(Restrictions.eq("createBy.id", createById));
    //      }//from  w  ww.j a v  a2  s .  co  m
    String type = ObjectUtils.toString(paramMap.get("type"));
    if ("0".equals(type)) {//???
        dc.add(Restrictions.eq("type", type));
    } else {
        String manageName = ObjectUtils.toString(paramMap.get("manageName"));
        if (StringUtils.isNotBlank(manageName)) {
            dc.createAlias("createBy", "createBy");
            dc.add(Restrictions.like("createBy.name", "%" + EncodedUtil.decodeValue(manageName) + "%"));
        }
        dc.createAlias("company", "company");
        String companyId = ObjectUtils.toString(paramMap.get("companyId"));
        if (StringUtils.isNotBlank(companyId)) {

            dc.add(Restrictions.eq("company.id", companyId));
        }

        String requestUri = ObjectUtils.toString(paramMap.get("requestUri"));
        if (StringUtils.isNotBlank(requestUri)) {
            dc.add(Restrictions.like("requestUri", "%" + requestUri + "%"));
        }

        String exception = ObjectUtils.toString(paramMap.get("exception"));
        if (StringUtils.isNotBlank(exception)) {
            dc.add(Restrictions.eq("type", Log.TYPE_EXCEPTION));
        }

        if (StringUtils.isNotBlank(type)) {
            dc.add(Restrictions.eq("type", type));
        }

        Date beginDate = DateUtils.parseDate(paramMap.get("start"));
        if (beginDate == null) {
            beginDate = DateUtils.setDays(new Date(), 1);
            paramMap.put("beginDate", DateUtils.formatDate(beginDate, "yyyy-MM-dd"));
        }
        Date endDate = DateUtils.parseDate(paramMap.get("end"));
        if (endDate == null) {
            endDate = DateUtils.addDays(DateUtils.addMonths(beginDate, 1), -1);
            paramMap.put("endDate", DateUtils.formatDate(endDate, "yyyy-MM-dd"));
        }
        dc.createAlias("office", "office");
        User currentUser = UserUtils.getUser();
        dc.add(Restrictions.or(dataScopeFilter(currentUser, "office", "createBy"),
                Restrictions.eq("type", "0")));
        dc.add(Restrictions.between("createDate", beginDate, endDate));
    }
    dc.addOrder(Order.desc("createDate"));
    return logDao.find(page, dc);
}