Example usage for com.liferay.portal.kernel.dao.orm Property eq

List of usage examples for com.liferay.portal.kernel.dao.orm Property eq

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.orm Property eq.

Prototype

public Criterion eq(Object value);

Source Link

Usage

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);
    }
}