List of usage examples for com.liferay.portal.kernel.dao.orm Property eq
public Criterion eq(Object value);
From source file:br.com.prodevelopment.lapidarios.contato.service.persistence.EnderecoEmailExportActionableDynamicQuery.java
License:Open Source License
@Override protected void addCriteria(DynamicQuery dynamicQuery) { _portletDataContext.addDateRangeCriteria(dynamicQuery, "modifiedDate"); if (getStagedModelType().getReferrerClassNameId() >= 0) { Property classNameIdProperty = PropertyFactoryUtil.forName("classNameId"); dynamicQuery.add(classNameIdProperty.eq(getStagedModelType().getReferrerClassNameId())); }//from w w w . ja v a 2 s . c o m }
From source file:br.com.prodevelopment.lapidarios.evento.service.persistence.EventoAgendaExportActionableDynamicQuery.java
License:Open Source License
@Override protected void addCriteria(DynamicQuery dynamicQuery) { Criterion modifiedDateCriterion = _portletDataContext.getDateRangeCriteria("modifiedDate"); Criterion statusDateCriterion = _portletDataContext.getDateRangeCriteria("statusDate"); if ((modifiedDateCriterion != null) && (statusDateCriterion != null)) { Disjunction disjunction = RestrictionsFactoryUtil.disjunction(); disjunction.add(modifiedDateCriterion); disjunction.add(statusDateCriterion); dynamicQuery.add(disjunction);/*from w w w. j a v a 2s .c om*/ } if (getStagedModelType().getReferrerClassNameId() >= 0) { Property classNameIdProperty = PropertyFactoryUtil.forName("classNameId"); dynamicQuery.add(classNameIdProperty.eq(getStagedModelType().getReferrerClassNameId())); } Property workflowStatusProperty = PropertyFactoryUtil.forName("status"); if (_portletDataContext.isInitialPublication()) { dynamicQuery.add(workflowStatusProperty.ne(WorkflowConstants.STATUS_IN_TRASH)); } else { StagedModelDataHandler<?> stagedModelDataHandler = StagedModelDataHandlerRegistryUtil .getStagedModelDataHandler(EventoAgenda.class.getName()); dynamicQuery.add(workflowStatusProperty.in(stagedModelDataHandler.getExportableStatuses())); } }
From source file:br.com.prodevelopment.lapidarios.loja.service.persistence.LojaExportActionableDynamicQuery.java
License:Open Source License
@Override protected void addCriteria(DynamicQuery dynamicQuery) { Criterion modifiedDateCriterion = _portletDataContext.getDateRangeCriteria("modifiedDate"); Criterion statusDateCriterion = _portletDataContext.getDateRangeCriteria("statusDate"); if ((modifiedDateCriterion != null) && (statusDateCriterion != null)) { Disjunction disjunction = RestrictionsFactoryUtil.disjunction(); disjunction.add(modifiedDateCriterion); disjunction.add(statusDateCriterion); dynamicQuery.add(disjunction);//from w w w. ja v a2 s . c o m } if (getStagedModelType().getReferrerClassNameId() >= 0) { Property classNameIdProperty = PropertyFactoryUtil.forName("classNameId"); dynamicQuery.add(classNameIdProperty.eq(getStagedModelType().getReferrerClassNameId())); } Property workflowStatusProperty = PropertyFactoryUtil.forName("status"); if (_portletDataContext.isInitialPublication()) { dynamicQuery.add(workflowStatusProperty.ne(WorkflowConstants.STATUS_IN_TRASH)); } else { StagedModelDataHandler<?> stagedModelDataHandler = StagedModelDataHandlerRegistryUtil .getStagedModelDataHandler(Loja.class.getName()); dynamicQuery.add(workflowStatusProperty.in(stagedModelDataHandler.getExportableStatuses())); } }
From source file:br.com.thiagomoreira.liferay.plugins.fixvirtualhost.FixVirtualHostAction.java
License:Apache License
private void doRun(final long companyId) throws Exception { final String virtualHostOldPrefix = PropsUtil.get("virtual.host.old.prefix"); final String virtualHostNewPrefix = PropsUtil.get("virtual.host.new.prefix"); if (Validator.isNotNull(virtualHostOldPrefix) && !virtualHostOldPrefix.equals(virtualHostNewPrefix)) { Company company = CompanyLocalServiceUtil.getCompany(companyId); String companyVirtualHost = company.getVirtualHostname(); companyVirtualHost = fixVirtualHost(companyVirtualHost, virtualHostOldPrefix, virtualHostNewPrefix); if (Validator.isNotNull(companyVirtualHost)) { log.info("Updating company virtual host to: " + companyVirtualHost); CompanyLocalServiceUtil.updateCompany(companyId, companyVirtualHost, company.getMx(), company.getMaxUsers(), company.getActive()); }//from w w w . j av a 2s . c o m GroupActionableDynamicQuery actionableDynamicQuery = new GroupActionableDynamicQuery() { @Override protected void performAction(Object object) throws PortalException, SystemException { Group group = (Group) object; LayoutSet layoutSet = group.getPublicLayoutSet(); if (layoutSet != null) { String layoutVirtualHost = layoutSet.getVirtualHostname(); layoutVirtualHost = fixVirtualHost(layoutVirtualHost, virtualHostOldPrefix, virtualHostNewPrefix); if (Validator.isNotNull(layoutVirtualHost)) { log.info("Updating layout virtual host to: " + layoutVirtualHost); LayoutSetLocalServiceUtil.updateVirtualHost(group.getGroupId(), false, layoutVirtualHost); } } layoutSet = group.getPrivateLayoutSet(); if (layoutSet != null) { String layoutVirtualHost = layoutSet.getVirtualHostname(); layoutVirtualHost = fixVirtualHost(layoutVirtualHost, virtualHostOldPrefix, virtualHostNewPrefix); if (Validator.isNotNull(layoutVirtualHost)) { log.info("Updating layout virtual host to: " + layoutVirtualHost); LayoutSetLocalServiceUtil.updateVirtualHost(group.getGroupId(), true, layoutVirtualHost); } } } @Override protected void addCriteria(DynamicQuery dynamicQuery) { Property property = PropertyFactoryUtil.forName("site"); dynamicQuery.add(property.eq(true)); } }; actionableDynamicQuery.setCompanyId(companyId); actionableDynamicQuery.performActions(); } else { log.info("Skiiping executing due properties values virtual.host.old.prefix=" + virtualHostOldPrefix + " and virtual.host.new.prefix=" + virtualHostNewPrefix); } }
From source file:com.apstamp.liferay.service.impl.TemplateLocalServiceImpl.java
License:Open Source License
protected DynamicQuery buildTemplateDynamicQuery(long templateId, String clienteEmail, String empresaEmail, String clienteNome, String clienteEmpresa, String empresaNome, String empresaRepresentante, String projetoNome, String projetoTecnologia, String projetoTag, boolean andSearch) { Junction junction = null;/*w w w. j ava2 s . c o m*/ if (andSearch) junction = RestrictionsFactoryUtil.conjunction(); else junction = RestrictionsFactoryUtil.disjunction(); //campos do cliente if (templateId > 0) { Property property = PropertyFactoryUtil.forName("templateId"); junction.add(property.eq(Long.valueOf(templateId))); } if (Validator.isNotNull(clienteNome)) { Property property = PropertyFactoryUtil.forName("clienteNome"); String value = (new StringBuilder("%")).append(clienteNome).append("%").toString(); junction.add(property.like(value)); } if (Validator.isNotNull(clienteEmpresa)) { Property property = PropertyFactoryUtil.forName("clienteEmpresa"); String value = (new StringBuilder("%")).append(clienteEmpresa).append("%").toString(); junction.add(property.like(value)); } //campos da empresa if (Validator.isNotNull(empresaNome)) { Property property = PropertyFactoryUtil.forName("empresaNome"); String value = (new StringBuilder("%")).append(empresaNome).append("%").toString(); junction.add(property.like(value)); } if (Validator.isNotNull(empresaRepresentante)) { Property property = PropertyFactoryUtil.forName("empresaRepresentante"); String value = (new StringBuilder("%")).append(empresaRepresentante).append("%").toString(); junction.add(property.like(value)); } //campos projeto if (Validator.isNotNull(projetoNome)) { Property property = PropertyFactoryUtil.forName("projetoNome"); String value = (new StringBuilder("%")).append(projetoNome).append("%").toString(); junction.add(property.like(value)); } if (Validator.isNotNull(projetoTecnologia)) { Property property = PropertyFactoryUtil.forName("projetoTecnologia"); String value = (new StringBuilder("%")).append(projetoTecnologia).append("%").toString(); junction.add(property.like(value)); } if (Validator.isNotNull(projetoTag)) { Property property = PropertyFactoryUtil.forName("projetoTag"); String value = (new StringBuilder("%")).append(projetoTag).append("%").toString(); junction.add(property.like(value)); } if (Validator.isNotNull(clienteEmail)) { Property property = PropertyFactoryUtil.forName("clienteEmail"); String value = (new StringBuilder("%")).append(clienteEmail).append("%").toString(); junction.add(property.like(value)); } if (Validator.isNotNull(empresaEmail)) { Property property = PropertyFactoryUtil.forName("empresaEmail"); String value = (new StringBuilder("%")).append(empresaEmail).append("%").toString(); junction.add(property.like(value)); } DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Template.class, getClassLoader()); return dynamicQuery.add(junction); }
From source file:com.htmsd.slayer.service.impl.ShoppingOrderLocalServiceImpl.java
License:Open Source License
@SuppressWarnings("unchecked") public List<ShoppingOrder> searchShoppingOrder(int start, int end, long sellerId, boolean isSellerList, String keyword, String tabName) { _log.info("In searchShoppingOrder keyword is :-->> " + keyword); String likeKeyword = StringUtil.quote(keyword, StringPool.PERCENT); DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(ShoppingOrder.class); Junction junctionOR = RestrictionsFactoryUtil.disjunction(); Property property = PropertyFactoryUtil.forName("sellerName"); junctionOR.add(property.like(likeKeyword)); property = PropertyFactoryUtil.forName("userName"); junctionOR.add(property.like(likeKeyword)); if (CommonUtil.isNumeric(keyword)) { property = PropertyFactoryUtil.forName("quantity"); junctionOR.add(property.eq(Integer.valueOf(keyword))); }//from w w w . j a va 2s. c o m if (keyword.startsWith("HT")) { String orderId = keyword.substring(7, keyword.length()); _log.info("Order ItemId is ==>" + Long.valueOf(orderId)); junctionOR.add(RestrictionsFactoryUtil.eq("orderId", Long.valueOf(orderId))); } if (keyword.contains("-")) { Criterion criterion = PropertyFactoryUtil.forName("createDate") .between(getFromDateAndToDate(0, 0, 0, keyword), getFromDateAndToDate(23, 59, 59, keyword)); junctionOR.add(criterion); } dynamicQuery.add(junctionOR); if (isSellerList) { dynamicQuery.add(RestrictionsFactoryUtil.eq("sellerId", sellerId)); } else { dynamicQuery.add(RestrictionsFactoryUtil.eq("orderStatus", getOrderStatusByTabName(tabName))); } List<ShoppingOrder> searchList = new ArrayList<ShoppingOrder>(); try { searchList = ShoppingOrderLocalServiceUtil.dynamicQuery(dynamicQuery, start, end); } catch (SystemException e) { e.printStackTrace(); } return searchList; }
From source file:com.htmsd.slayer.service.impl.ShoppingOrderLocalServiceImpl.java
License:Open Source License
public int searchCount(long sellerId, boolean isSellerList, String tabName, String keyword) { _log.info("searchCount for Keyword :" + keyword); String likeKeyword = StringUtil.quote(keyword, StringPool.PERCENT); DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(ShoppingOrder.class); Junction junctionOR = RestrictionsFactoryUtil.disjunction(); Property property = PropertyFactoryUtil.forName("sellerName"); junctionOR.add(property.like(likeKeyword)); property = PropertyFactoryUtil.forName("userName"); junctionOR.add(property.like(likeKeyword)); if (CommonUtil.isNumeric(keyword)) { property = PropertyFactoryUtil.forName("quantity"); junctionOR.add(property.eq(Integer.valueOf(keyword))); }//w w w. j a v a2 s .c om if (keyword.startsWith("HT")) { String orderId = keyword.substring(7, keyword.length()); junctionOR.add(RestrictionsFactoryUtil.eq("orderId", Long.valueOf(orderId))); } if (keyword.contains("-")) { Criterion criterion = PropertyFactoryUtil.forName("createDate") .between(getFromDateAndToDate(0, 0, 0, keyword), getFromDateAndToDate(23, 59, 59, keyword)); junctionOR.add(criterion); } dynamicQuery.add(junctionOR); if (isSellerList) { dynamicQuery.add(RestrictionsFactoryUtil.eq("sellerId", sellerId)); } else { dynamicQuery.add(RestrictionsFactoryUtil.eq("orderStatus", getOrderStatusByTabName(tabName))); } int searchCount = 0; try { searchCount = (int) ShoppingOrderLocalServiceUtil.dynamicQueryCount(dynamicQuery); } catch (SystemException e) { e.printStackTrace(); } return searchCount; }
From source file:com.liferay.adaptive.media.blogs.web.internal.counter.BlogsAdaptiveMediaImageCounter.java
License:Open Source License
@Override public int countExpectedAdaptiveMediaImageEntries(long companyId) { DynamicQuery dynamicQuery = _dlFileEntryLocalService.dynamicQuery(); Property companyIdProperty = PropertyFactoryUtil.forName("companyId"); dynamicQuery.add(companyIdProperty.eq(companyId)); Property classNameIdProperty = PropertyFactoryUtil.forName("classNameId"); long classNameId = _classNameLocalService.getClassNameId(BlogsEntry.class.getName()); dynamicQuery.add(classNameIdProperty.eq(classNameId)); Property mimeTypeProperty = PropertyFactoryUtil.forName("mimeType"); dynamicQuery.add(mimeTypeProperty.in(AdaptiveMediaImageConstants.getSupportedMimeTypes())); return (int) _dlFileEntryLocalService.dynamicQueryCount(dynamicQuery); }
From source file:com.liferay.adaptive.media.blogs.web.internal.counter.BlogsAMImageCounter.java
License:Open Source License
@Override public int countExpectedAMImageEntries(long companyId) { DynamicQuery dynamicQuery = _dlFileEntryLocalService.dynamicQuery(); Property companyIdProperty = PropertyFactoryUtil.forName("companyId"); dynamicQuery.add(companyIdProperty.eq(companyId)); Property classNameIdProperty = PropertyFactoryUtil.forName("classNameId"); long classNameId = _classNameLocalService.getClassNameId(BlogsEntry.class.getName()); dynamicQuery.add(classNameIdProperty.eq(classNameId)); Property mimeTypeProperty = PropertyFactoryUtil.forName("mimeType"); dynamicQuery.add(mimeTypeProperty.in(_amImageMimeTypeProvider.getSupportedMimeTypes())); return (int) _dlFileEntryLocalService.dynamicQueryCount(dynamicQuery); }
From source file:com.liferay.adaptive.media.blogs.web.internal.optimizer.BlogsAdaptiveMediaImageOptimizer.java
License:Open Source License
private void _optimize(long companyId, String configurationEntryUuid, int total, AtomicInteger atomicCounter) { ActionableDynamicQuery actionableDynamicQuery = _dlFileEntryLocalService.getActionableDynamicQuery(); long classNameId = _classNameLocalService.getClassNameId(BlogsEntry.class.getName()); actionableDynamicQuery.setAddCriteriaMethod(new ActionableDynamicQuery.AddCriteriaMethod() { @Override/*from w w w .ja v a 2 s . c o m*/ public void addCriteria(DynamicQuery dynamicQuery) { Property companyIdProperty = PropertyFactoryUtil.forName("companyId"); dynamicQuery.add(companyIdProperty.eq(companyId)); Property classNameIdProperty = PropertyFactoryUtil.forName("classNameId"); dynamicQuery.add(classNameIdProperty.eq(classNameId)); Property mimeTypeProperty = PropertyFactoryUtil.forName("mimeType"); dynamicQuery.add(mimeTypeProperty.in(AdaptiveMediaImageConstants.getSupportedMimeTypes())); } }); actionableDynamicQuery .setPerformActionMethod(new ActionableDynamicQuery.PerformActionMethod<DLFileEntry>() { @Override public void performAction(DLFileEntry dlFileEntry) throws PortalException { FileEntry fileEntry = new LiferayFileEntry(dlFileEntry); try { _adaptiveMediaImageProcessor.process(fileEntry.getFileVersion(), configurationEntryUuid); _sendStatusMessage(atomicCounter.incrementAndGet(), total); } catch (PortalException pe) { _log.error("Unable to process file entry id " + fileEntry.getFileEntryId(), pe); } } }); try { actionableDynamicQuery.performActions(); } catch (PortalException pe) { _log.error(pe, pe); } }