List of usage examples for org.hibernate Criteria createAlias
@Deprecated public Criteria createAlias(String associationPath, String alias, int joinType) throws HibernateException;
From source file:com.floreantpos.model.dao.MenuGroupDAO.java
License:Open Source License
@SuppressWarnings("unchecked") public boolean hasChildren(Terminal terminal, MenuGroup group, OrderType orderType) throws PosException { Session session = null;//from w w w. j av a 2 s . co m try { session = getSession(); Criteria criteria = session.createCriteria(MenuItem.class); criteria.add(Restrictions.eq(MenuItem.PROP_PARENT, group)); criteria.add(Restrictions.eq(MenuItem.PROP_VISIBLE, Boolean.TRUE)); // if(terminal!=null) { // criteria.add(Restrictions.eq(MenuItem., criteria)) // } criteria.setProjection(Projections.rowCount()); criteria.createAlias("orderTypeList", "type", CriteriaSpecification.LEFT_JOIN); criteria.add(Restrictions.or(Restrictions.isEmpty("orderTypeList"), Restrictions.eq("type.id", orderType.getId()))); int uniqueResult = (Integer) criteria.uniqueResult(); return uniqueResult > 0; } catch (Exception e) { e.printStackTrace(); throw new PosException(Messages.getString("MenuItemDAO.0")); //$NON-NLS-1$ } finally { if (session != null) { session.close(); } } }
From source file:com.floreantpos.model.dao.MenuItemDAO.java
License:Open Source License
public List<MenuItem> findByParent(Terminal terminal, MenuGroup menuGroup, Object selectedOrderType, boolean includeInvisibleItems) { Session session = null;//from ww w.j av a2 s .c om Criteria criteria = null; try { session = getSession(); criteria = session.createCriteria(MenuItem.class); if (menuGroup != null) { criteria.add(Restrictions.eq(MenuItem.PROP_PARENT, menuGroup)); } criteria.addOrder(Order.asc(MenuItem.PROP_SORT_ORDER)); if (!includeInvisibleItems) { criteria.add(Restrictions.eq(MenuItem.PROP_VISIBLE, Boolean.TRUE)); } if (selectedOrderType instanceof OrderType) { OrderType orderType = (OrderType) selectedOrderType; criteria.createAlias("orderTypeList", "type", CriteriaSpecification.LEFT_JOIN); criteria.add(Restrictions.or(Restrictions.isEmpty("orderTypeList"), Restrictions.eq("type.id", orderType.getId()))); } return criteria.list(); } catch (Exception e) { } return criteria.list(); }
From source file:com.hyzy.core.orm.hibernate.SimpleHibernateDao.java
License:Apache License
protected Criteria createAlias(Criteria criteria, String... aliasBeans) { if (aliasBeans != null && aliasBeans.length > 0) { for (int i = 0; i < aliasBeans.length; i++) { criteria.createAlias(aliasBeans[i], aliasBeans[i], CriteriaSpecification.LEFT_JOIN); }//from ww w . j ava2 s . c om } return criteria; }
From source file:com.ibm.asset.trails.dao.jpa.VSoftwareLparDAOJpa.java
public void paginatedList(DisplayTagList data, Account account, ReconSetting reconSetting, int startIndex, int objectsPerPage, String sort, String dir) { Criteria criteria = getHibernateSessionCriteria(); criteria.createAlias("hardwareLpar", "hl") .createAlias("hl.hardwareLparEff", "hle", CriteriaSpecification.LEFT_JOIN) .createAlias("hl.hardware", "h").createAlias("h.machineType", "mt") .createAlias("installedSoftwares", "is") .createAlias("is.scheduleF", "sf", CriteriaSpecification.LEFT_JOIN) .createAlias("sf.scope", "scope", CriteriaSpecification.LEFT_JOIN) .createAlias("is.softwareLpar", "sl").createAlias("is.alert", "aus") .createAlias("aus.reconcile", "r", CriteriaSpecification.LEFT_JOIN) .createAlias("r.usedLicenses", "ul", CriteriaSpecification.LEFT_JOIN) .createAlias("ul.license", "license", CriteriaSpecification.LEFT_JOIN) .createAlias("r.reconcileType", "rt", CriteriaSpecification.LEFT_JOIN) .createAlias("is.software", "sw") .createAlias("sw.manufacturer", "mf", CriteriaSpecification.LEFT_JOIN) .add(Restrictions.eq("account", account)); if (reconSetting.getReconcileType() != null) { criteria.add(Restrictions.eq("rt.id", reconSetting.getReconcileType())); }//ww w . j a va2s . c om if (StringUtils.isNotBlank(reconSetting.getAlertStatus())) { boolean open = false; if (reconSetting.getAlertStatus().equals("OPEN")) { open = true; criteria.add(Restrictions.eq("aus.open", open)); } else { criteria.add(Restrictions.and(Restrictions.eq("aus.open", false), Restrictions.eqProperty("is.id", "r.installedSoftware.id"))); } } else { criteria.add(Restrictions.or(Restrictions.eq("aus.open", true), Restrictions.and(Restrictions.eq("aus.open", false), Restrictions.eqProperty("is.id", "r.installedSoftware.id")))); } if (null != reconSetting.getAlertFrom() && reconSetting.getAlertFrom().intValue() >= 0) { criteria.add(Restrictions.ge("aus.alertAge", reconSetting.getAlertFrom())); } if (null != reconSetting.getAlertTo() && reconSetting.getAlertTo().intValue() >= 0) { criteria.add(Restrictions.le("aus.alertAge", reconSetting.getAlertTo())); } if (StringUtils.isNotBlank(reconSetting.getAssigned())) { if (reconSetting.getAssigned().equals("Assigned")) { criteria.add(Restrictions.ne("aus.remoteUser", "STAGING")); } if (reconSetting.getAssigned().equals("Unassigned")) { criteria.add(Restrictions.eq("aus.remoteUser", "STAGING")); } } if (StringUtils.isNotBlank(reconSetting.getAssignee())) { criteria.add(Restrictions.eq("aus.remoteUser", reconSetting.getAssignee()).ignoreCase()); } if (StringUtils.isNotBlank(reconSetting.getOwner())) { if (reconSetting.getOwner().equalsIgnoreCase("IBM")) { criteria.add(Restrictions.eq("h.owner", reconSetting.getOwner()).ignoreCase()); } else if (reconSetting.getOwner().equalsIgnoreCase("Customer")) { ArrayList<String> lalOwner = new ArrayList<String>(); lalOwner.add("CUST"); lalOwner.add("CUSTO"); criteria.add(Restrictions.in("h.owner", lalOwner)); } } // I'm not sure why the heck we aren't just getting a list of strings? if (reconSetting.getCountries().length > 0) { List<String> list = new ArrayList<String>(); for (int i = 0; i < reconSetting.getCountries().length; i++) { if (StringUtils.isNotBlank(reconSetting.getCountries()[i])) { list.add(reconSetting.getCountries()[i].toUpperCase()); } } if (list.size() > 0) { criteria.add(Restrictions.in("h.country", list)); } } if (reconSetting.getNames().length > 0) { List<String> list = new ArrayList<String>(); for (int i = 0; i < reconSetting.getNames().length; i++) { if (StringUtils.isNotBlank(reconSetting.getNames()[i])) { list.add(reconSetting.getNames()[i].toUpperCase()); } } if (list.size() > 0) { criteria.add(Restrictions.in("hl.name", list)); } } if (reconSetting.getSwcmIDs().length > 0) { List<String> list = new ArrayList<String>(); for (int i = 0; i < reconSetting.getSwcmIDs().length; i++) { if (StringUtils.isNotBlank(reconSetting.getSwcmIDs()[i])) { list.add(reconSetting.getSwcmIDs()[i].toUpperCase()); } } if (list.size() > 0) { criteria.add(Restrictions.in("license.extSrcId", list)); } } if (reconSetting.getSerialNumbers().length > 0) { List<String> list = new ArrayList<String>(); for (int i = 0; i < reconSetting.getSerialNumbers().length; i++) { if (StringUtils.isNotBlank(reconSetting.getSerialNumbers()[i])) { list.add(reconSetting.getSerialNumbers()[i].toUpperCase()); } } if (list.size() > 0) { criteria.add(Restrictions.in("h.serial", list)); } } if (reconSetting.getProductInfoNames().length > 0) { List<String> list = new ArrayList<String>(); for (int i = 0; i < reconSetting.getProductInfoNames().length; i++) { if (StringUtils.isNotBlank(reconSetting.getProductInfoNames()[i])) { list.add(reconSetting.getProductInfoNames()[i]); } } if (list.size() > 0) { criteria.add(Restrictions.in("sw.softwareName", list)); } } if (StringUtils.isNotBlank(reconSetting.getScope())) { if ("Not specified".equalsIgnoreCase(reconSetting.getScope())) { criteria.add(Restrictions.isNull("scope.description")); } else { criteria.add(Restrictions.eq("scope.description", reconSetting.getScope())); } } if (StringUtils.isNotBlank(reconSetting.getFinanResp())) { if ("Not Specified".trim().equalsIgnoreCase(reconSetting.getFinanResp())) { criteria.add(Restrictions.isNull("sf.SWFinanceResp")); } else { criteria.add(Restrictions.eq("sf.SWFinanceResp", reconSetting.getFinanResp())); } } criteria.setProjection(Projections.projectionList().add(Projections.property("aus.id").as("alertId")) .add(Projections.property("r.id").as("reconcileId")) .add(Projections.property("aus.alertAge").as("alertAgeI")) .add(Projections.property("is.id").as("installedSoftwareId")) .add(Projections.property("hl.name").as("hostname")) .add(Projections.property("sl.name").as("sl_hostname")) .add(Projections.property("hl.spla").as("spla")) .add(Projections.property("hl.sysplex").as("sysplex")) .add(Projections.property("hl.internetIccFlag").as("internetIccFlag")) .add(Projections.property("h.serial").as("serial")) .add(Projections.property("h.country").as("country")) .add(Projections.property("h.owner").as("owner")) .add(Projections.property("h.mastProcessorType").as("mastProcessorType")) .add(Projections.property("h.processorManufacturer").as("processorManufacturer")) .add(Projections.property("h.mastProcessorModel").as("mastProcessorModel")) .add(Projections.property("h.nbrCoresPerChip").as("nbrCoresPerChip")) .add(Projections.property("h.nbrOfChipsMax").as("nbrOfChipsMax")) .add(Projections.property("h.cpuLsprMips").as("cpuLsprMips")) .add(Projections.property("h.cpuIfl").as("cpuIFL")) .add(Projections.property("hl.partLsprMips").as("partLsprMips")) .add(Projections.property("h.cpuGartnerMips").as("cpuGartnerMips")) .add(Projections.property("hl.partGartnerMips").as("partGartnerMips")) .add(Projections.property("hl.effectiveThreads").as("effectiveThreads")) .add(Projections.property("hl.vcpu").as("vcpu")).add(Projections.property("h.cpuMsu").as("cpuMsu")) .add(Projections.property("hl.partMsu").as("partMsu")) .add(Projections.property("hl.serverType").as("lparServerType")) .add(Projections.property("h.shared").as("shared")) .add(Projections.property("h.multi_tenant").as("multi_tenant")) .add(Projections.property("mt.type").as("assetType")) .add(Projections.property("mt.name").as("assetName")) .add(Projections.property("h.hardwareStatus").as("hardwareStatus")) .add(Projections.property("hl.lparStatus").as("lparStatus")) .add(Projections.property("processorCount").as("processorCount")) .add(Projections.property("sw.softwareName").as("productInfoName")) .add(Projections.property("sw.softwareId").as("productInfoId")) .add(Projections.property("sw.pid").as("pid")) .add(Projections.property("mf.manufacturerName").as("manufacturerName")) .add(Projections.property("rt.name").as("reconcileTypeName")) .add(Projections.property("rt.id").as("reconcileTypeId")) .add(Projections.property("aus.remoteUser").as("assignee")) .add(Projections.property("h.processorCount").as("hardwareProcessorCount")) .add(Projections.property("hle.processorCount").as("hwLparEffProcessorCount")) .add(Projections.property("hl.osType").as("osType")) .add(Projections.property("hle.status").as("hwLparEffProcessorStatus")) .add(Projections.property("h.chips").as("chips"))); criteria.setResultTransformer(new AliasToBeanResultTransformer(ReconWorkspace.class)); criteria.addOrder(Order.desc("aus.open")); if (dir.equalsIgnoreCase("ASC")) { criteria.addOrder(Order.asc(sort)); } else { criteria.addOrder(Order.desc(sort)); } ArrayList<ReconWorkspace> list = new ArrayList<ReconWorkspace>(); ScrollableResults itemCursor = criteria.scroll(); itemCursor.beforeFirst(); if (itemCursor.next()) { itemCursor.scroll(startIndex); int i = 0; while (objectsPerPage > i++) { ReconWorkspace rw = (ReconWorkspace) itemCursor.get(0); if (null != rw.getHwLparEffProcessorStatus() && rw.getHwLparEffProcessorStatus().equalsIgnoreCase("INACTIVE")) { rw.setHwLparEffProcessorCount(0); } list.add(rw); if (!itemCursor.next()) break; } data.setList(list); itemCursor.last(); data.setFullListSize(itemCursor.getRowNumber() + 1); itemCursor.close(); addSchedulef2List(account, data.getList()); } else { data.setList(null); data.setFullListSize(0); itemCursor.close(); } }
From source file:com.inkubator.hrm.dao.impl.ApprovalDefinitionDaoImpl.java
private void doSearchApprovalDefinitionByParam(ApprovalDefinitionSearchParameter searchParameter, Criteria criteria) { if (searchParameter.getApprovalName() != null) { criteria.add(Restrictions.like("name", searchParameter.getApprovalName(), MatchMode.START)); }/* w ww .j a va2s . co m*/ if (searchParameter.getProcessName() != null) { criteria.add(Restrictions.like("processType", searchParameter.getProcessName(), MatchMode.START)); } if (searchParameter.getApproverPosition() != null) { criteria.createAlias("jabatanByApproverPosition", "ap", JoinType.INNER_JOIN); criteria.add(Restrictions.like("ap.name", searchParameter.getApproverPosition(), MatchMode.START)); } if (searchParameter.getApproverIndividual() != null) { criteria.createAlias("hrmUserByApproverIndividual", "au", JoinType.INNER_JOIN); criteria.add( Restrictions.like("au.realName", searchParameter.getApproverIndividual(), MatchMode.START)); } if (searchParameter.getOnBehalfApproverPosition() != null) { criteria.createAlias("jabatanByOnBehalfPosition", "ap", JoinType.INNER_JOIN); criteria.add(Restrictions.like("ap.name", searchParameter.getApproverPosition(), MatchMode.START)); } if (searchParameter.getOnBehaltAppriverIndividual() != null) { criteria.createAlias("hrmUserByOnBehalfIndividual", "au", JoinType.INNER_JOIN); criteria.add( Restrictions.like("au.realName", searchParameter.getApproverIndividual(), MatchMode.START)); } if (searchParameter.getApproverType() != null) { criteria.add(Restrictions.like("approverType", searchParameter.getApproverType(), MatchMode.START)); } criteria.add(Restrictions.isNotNull("id")); }
From source file:com.inkubator.hrm.dao.impl.BatchJobExecutionDaoImpl.java
@Override public List<BatchJobExecution> getByParam(BatchJobExecutionSearchParameter parameter, int firstResult, int maxResults, Order orderable) { Criteria criteria = getCurrentSession().createCriteria(getEntityClass()); criteria.createAlias("batchJobInstance", "batchJobInstance", JoinType.INNER_JOIN); if (parameter.getJobName() != null) { // criteria.createAlias("batchJobInstance", "bj", JoinType.INNER_JOIN); criteria.add(Restrictions.like("batchJobInstance.jobName", parameter.getJobName(), MatchMode.ANYWHERE)); }/*from w ww . j av a 2s.com*/ if (parameter.getStatus() != null) { criteria.add(Restrictions.like("BatchJobExecution", parameter.getStatus())); } criteria.addOrder(orderable); criteria.setFirstResult(firstResult); criteria.setMaxResults(maxResults); //criteria.setFetchMode("batchJobInstance", FetchMode.JOIN); return criteria.list(); }
From source file:com.inkubator.hrm.dao.impl.BatchJobExecutionDaoImpl.java
@Override public Long getTotalByParam(BatchJobExecutionSearchParameter parameter) { Criteria criteria = getCurrentSession().createCriteria(getEntityClass()); if (parameter.getJobName() != null) { criteria.createAlias("batchJobInstance", "bj", JoinType.INNER_JOIN); criteria.add(Restrictions.like("bj.jobName", parameter.getJobName(), MatchMode.ANYWHERE)); }/*from w ww . ja v a2 s .c o m*/ if (parameter.getStatus() != null) { criteria.add(Restrictions.like("BatchJobExecution", parameter.getStatus())); } return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult(); }
From source file:com.inkubator.hrm.dao.impl.BatchStepExecutionDaoImpl.java
@Override public List<BatchStepExecution> getExitMessageByJobId(Long id) { Criteria criteria = getCurrentSession().createCriteria(getEntityClass()); criteria.createAlias("batchJobExecution", "bs", JoinType.INNER_JOIN); criteria.add(Restrictions.eq("bs.jobExecutionId", id)); criteria.setFetchMode("batchJobExecution", FetchMode.JOIN); criteria.setFetchMode("batchJobExecution.batchJobInstance", FetchMode.JOIN); return criteria.list(); }
From source file:com.inkubator.hrm.dao.impl.BatchStepExecutionDaoImpl.java
@Override public Long getTotalExitMessageByParam(Long id) { Criteria criteria = getCurrentSession().createCriteria(getEntityClass()); criteria.createAlias("batchJobExecution", "bs", JoinType.INNER_JOIN); criteria.add(Restrictions.eq("bs.jobExecutionId", id)); criteria.setFetchMode("batchJobInstance", FetchMode.JOIN); criteria.setFetchMode("batchJobExecution", FetchMode.JOIN); return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult(); }
From source file:com.inkubator.hrm.dao.impl.BioDataDaoImpl.java
private void doSearchBioDataByParam(BioDataSearchParameter parameter, Criteria criteria) { if (parameter.getName() != null) { // criteria.add(Restrictions.like("firstName", parameter.getParameter(), MatchMode.ANYWHERE)); // Disjunction disjunction = Restrictions.disjunction(); // disjunction.add(Restrictions.like("firstName", parameter.getName(), MatchMode.ANYWHERE)); // disjunction.add(Restrictions.like("lastName", parameter.getName(), MatchMode.ANYWHERE)); // criteria.add(disjunction); criteria.createAlias("religion", "religion", JoinType.INNER_JOIN); criteria.createAlias("maritalStatus", "maritalStatus", JoinType.INNER_JOIN); criteria.add(Restrictions.ilike("combineName", parameter.getName().toLowerCase(), MatchMode.ANYWHERE)); }// w ww. j a v a2 s. c o m if (parameter.getEmailAddress() != null) { criteria.add(Restrictions.like("personalEmail", parameter.getEmailAddress(), MatchMode.ANYWHERE)); } if (parameter.getNickName() != null) { criteria.add(Restrictions.like("nickname", parameter.getNickName(), MatchMode.ANYWHERE)); } criteria.add(Restrictions.isNotNull("id")); }