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

Introduction

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

Prototype

public Criterion like(Object value);

Source Link

Usage

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;/* ww w  .  ja v a 2 s.  c  om*/
    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.ShoppingItemLocalServiceImpl.java

License:Open Source License

public List<ShoppingItem> searchItems(int status, String keyword, int start, int end) {

    String likeKeyword = StringUtil.quote(keyword, StringPool.PERCENT);
    DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(ShoppingItem.class);

    Junction junctionOR = RestrictionsFactoryUtil.disjunction();

    Property property = PropertyFactoryUtil.forName("userName");
    junctionOR.add(property.like(likeKeyword));

    property = PropertyFactoryUtil.forName("updateUserName");
    junctionOR.add(property.like(likeKeyword));

    property = PropertyFactoryUtil.forName("name");
    junctionOR.add(property.like(likeKeyword));

    property = PropertyFactoryUtil.forName("productCode");
    junctionOR.add(property.like(likeKeyword));

    dynamicQuery.add(junctionOR);// w w w . java2s. co m

    dynamicQuery.add(RestrictionsFactoryUtil.eq("status", status));

    List<ShoppingItem> searchList = new ArrayList<ShoppingItem>();
    try {
        searchList = ShoppingItemLocalServiceUtil.dynamicQuery(dynamicQuery, start, end);
    } catch (SystemException e) {
    }
    return searchList;
}

---

From source file:com.htmsd.slayer.service.impl.ShoppingItemLocalServiceImpl.java

License:Open Source License

public int searchCount(int status, String keyword) {

    String likeKeyword = StringUtil.quote(keyword, StringPool.PERCENT);
    DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(ShoppingItem.class);

    Junction junctionOR = RestrictionsFactoryUtil.disjunction();

    Property property = PropertyFactoryUtil.forName("userName");
    junctionOR.add(property.like(likeKeyword));

    property = PropertyFactoryUtil.forName("updateUserName");
    junctionOR.add(property.like(likeKeyword));

    property = PropertyFactoryUtil.forName("name");
    junctionOR.add(property.like(likeKeyword));

    property = PropertyFactoryUtil.forName("productCode");
    junctionOR.add(property.like(likeKeyword));

    dynamicQuery.add(junctionOR);/*w  w  w  .  java 2 s.com*/

    dynamicQuery.add(RestrictionsFactoryUtil.eq("status", status));
    int searchCount = 0;
    try {
        searchCount = (int) ShoppingItemLocalServiceUtil.dynamicQueryCount(dynamicQuery);
    } catch (SystemException e) {
    }
    return searchCount;

}

---

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)));
    }/* ww w . j a v a2 s.  com*/

    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)));
    }/*from  ww  w  .java 2  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.asset.publisher.web.internal.messaging.AssetEntriesCheckerUtil.java

License:Open Source License

public void checkAssetEntries() throws Exception {
    ActionableDynamicQuery actionableDynamicQuery = _portletPreferencesLocalService.getActionableDynamicQuery();

    actionableDynamicQuery.setAddCriteriaMethod(new ActionableDynamicQuery.AddCriteriaMethod() {

        @Override//from  w w w  .ja va 2 s  .c  om
        public void addCriteria(DynamicQuery dynamicQuery) {
            Property property = PropertyFactoryUtil.forName("portletId");

            dynamicQuery.add(property.like(
                    PortletIdCodec.encode(AssetPublisherPortletKeys.ASSET_PUBLISHER, StringPool.PERCENT)));
        }

    });
    actionableDynamicQuery.setPerformActionMethod(
            new ActionableDynamicQuery.PerformActionMethod<com.liferay.portal.kernel.model.PortletPreferences>() {

                @Override
                public void performAction(com.liferay.portal.kernel.model.PortletPreferences portletPreferences)
                        throws PortalException {

                    _checkAssetEntries(portletPreferences);
                }

            });

    actionableDynamicQuery.performActions();
}

---

From source file:com.liferay.bbb.service.impl.BBBMeetingLocalServiceImpl.java

License:Open Source License

protected DynamicQuery buildDynamicQuery(long groupId, long userId, String name, String description, int status,
        boolean andSearch) {

    DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(BBBMeeting.class, getClassLoader());

    if (groupId > 0) {
        Property property = PropertyFactoryUtil.forName("groupId");

        dynamicQuery.add(property.eq(groupId));
    }/*from   w  w  w .  j a  v  a 2  s .c o  m*/

    if (userId > 0) {
        Property property = PropertyFactoryUtil.forName("userId");

        dynamicQuery.add(property.eq(userId));
    }

    if (status != BBBMeetingConstants.STATUS_ANY) {
        Property property = PropertyFactoryUtil.forName("status");

        dynamicQuery.add(property.eq(status));
    }

    Junction junction = null;

    if (andSearch) {
        junction = RestrictionsFactoryUtil.conjunction();
    } else {
        junction = RestrictionsFactoryUtil.disjunction();
    }

    if (Validator.isNotNull(name)) {
        Property property = PropertyFactoryUtil.forName("name");

        String value = StringUtil.quote(name, StringPool.PERCENT);

        junction.add(property.like(value));
    }

    if (Validator.isNotNull(description)) {
        Property property = PropertyFactoryUtil.forName("description");

        String value = StringUtil.quote(description, StringPool.PERCENT);

        junction.add(property.like(value));
    }

    dynamicQuery.add(junction);

    return dynamicQuery;
}

---

From source file:com.liferay.calendar.web.internal.upgrade.v1_0_3.UpgradeEventsDisplayPortletId.java

License:Open Source License

@Override
protected void updateInstanceablePortletPreferences(final String oldRootPortletId,
        final String newRootPortletId) throws Exception {

    ActionableDynamicQuery actionableDynamicQuery = _portletPreferencesLocalService.getActionableDynamicQuery();

    actionableDynamicQuery.setAddCriteriaMethod(new ActionableDynamicQuery.AddCriteriaMethod() {

        @Override//from   w  ww  . j a va  2 s  . c  o  m
        public void addCriteria(DynamicQuery dynamicQuery) {
            Junction junction = RestrictionsFactoryUtil.disjunction();

            Property property = PropertyFactoryUtil.forName("portletId");

            junction.add(property.eq(oldRootPortletId));
            junction.add(property.like(oldRootPortletId + "_INSTANCE_%"));
            junction.add(property.like(oldRootPortletId + "_USER_%_INSTANCE_%"));

            dynamicQuery.add(junction);
        }

    });
    actionableDynamicQuery.setParallel(true);
    actionableDynamicQuery
            .setPerformActionMethod(new ActionableDynamicQuery.PerformActionMethod<PortletPreferences>() {

                @Override
                public void performAction(PortletPreferences portletPreference) throws PortalException {

                    updatePortletPreferences(portletPreference, oldRootPortletId, newRootPortletId);
                }

            });

    actionableDynamicQuery.performActions();
}

---

From source file:com.liferay.document.library.web.internal.lar.DLPortletDataHandler.java

License:Open Source License

protected ActionableDynamicQuery getRepositoryActionableDynamicQuery(
        final PortletDataContext portletDataContext) throws Exception {

    ExportActionableDynamicQuery exportActionableDynamicQuery = _repositoryLocalService
            .getExportActionableDynamicQuery(portletDataContext);

    final ActionableDynamicQuery.AddCriteriaMethod addCriteriaMethod = exportActionableDynamicQuery
            .getAddCriteriaMethod();/*from   w  w w.  j  a  va2  s .  c  o  m*/

    exportActionableDynamicQuery.setAddCriteriaMethod(new ActionableDynamicQuery.AddCriteriaMethod() {

        @Override
        public void addCriteria(DynamicQuery dynamicQuery) {
            addCriteriaMethod.addCriteria(dynamicQuery);

            Conjunction conjunction = RestrictionsFactoryUtil.conjunction();

            Property classNameIdProperty = PropertyFactoryUtil.forName("classNameId");

            long liferayRepositoryClassNameId = _portal.getClassNameId(LiferayRepositoryDefiner.CLASS_NAME);

            conjunction.add(classNameIdProperty.ne(liferayRepositoryClassNameId));

            long tempFileRepositoryClassNameId = _portal
                    .getClassNameId(TemporaryFileEntryRepositoryDefiner.CLASS_NAME);

            conjunction.add(classNameIdProperty.ne(tempFileRepositoryClassNameId));

            dynamicQuery.add(conjunction);

            Disjunction disjunction = RestrictionsFactoryUtil.disjunction();

            Property portletIdProperty = PropertyFactoryUtil.forName("portletId");

            disjunction.add(portletIdProperty.isNull());
            disjunction.add(portletIdProperty.eq(StringPool.BLANK));
            disjunction.add(portletIdProperty.eq(DLPortletKeys.DOCUMENT_LIBRARY_ADMIN));
            disjunction.add(portletIdProperty.like(DLPortletKeys.DOCUMENT_LIBRARY + "%"));

            dynamicQuery.add(disjunction);
        }

    });

    exportActionableDynamicQuery.setStagedModelType(new StagedModelType(
            _portal.getClassNameId(Repository.class.getName()), StagedModelType.REFERRER_CLASS_NAME_ID_ALL));

    return exportActionableDynamicQuery;
}

---

From source file:com.liferay.exportimport.web.internal.messaging.DraftExportImportConfigurationMessageListener.java

License:Open Source License

protected List<BackgroundTask> getParentBackgroundTasks(ExportImportConfiguration exportImportConfiguration)
        throws PortalException {

    DynamicQuery dynamicQuery = _backgroundTaskLocalService.dynamicQuery();

    Property completedProperty = PropertyFactoryUtil.forName("completed");

    dynamicQuery.add(completedProperty.eq(Boolean.TRUE));

    Property taskContextMapProperty = PropertyFactoryUtil.forName("taskContextMap");

    StringBundler sb = new StringBundler(7);

    sb.append(StringPool.PERCENT);/* www . j  a  v a  2  s .c om*/
    sb.append(StringPool.QUOTE);
    sb.append("exportImportConfigurationId");
    sb.append(StringPool.QUOTE);
    sb.append(StringPool.COLON);
    sb.append(exportImportConfiguration.getExportImportConfigurationId());
    sb.append(StringPool.PERCENT);

    dynamicQuery.add(taskContextMapProperty.like(sb.toString()));

    return _backgroundTaskLocalService.dynamicQuery(dynamicQuery);
}

---

• «
• 1
• 2
• »