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

Introduction

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

Prototype

public Criterion gt(Object value);

Source Link

Usage

From source file:com.liferay.calendar.service.impl.CalendarBookingLocalServiceImpl.java

License:Open Source License

@Override
public List<CalendarBooking> getCalendarBookings(long calendarId, long startTime, long endTime, int max) {

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

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

    dynamicQuery.add(property.eq(calendarId));

    if (startTime >= 0) {
        Property propertyStartTime = PropertyFactoryUtil.forName("startTime");

        dynamicQuery.add(propertyStartTime.gt(startTime));
    }//from  w  w  w  . j av a  2  s  .c o  m

    if (endTime >= 0) {
        Property propertyEndTime = PropertyFactoryUtil.forName("endTime");

        dynamicQuery.add(propertyEndTime.lt(endTime));
    }

    if (max > 0) {
        dynamicQuery.setLimit(0, max);
    }

    return dynamicQuery(dynamicQuery);
}

---

From source file:com.liferay.contenttargeting.reports.campaigncontent.service.impl.CampaignContentLocalServiceImpl.java

License:Open Source License

protected void addCampaignContentsFromAnalytics(Date date) throws PortalException, SystemException {

    // Retrieve analytics

    DynamicQuery dynamicQuery = _analyticsEventLocalService.dynamicQuery();

    Property referrerClassNameProperty = PropertyFactoryUtil.forName("referrerClassName");

    dynamicQuery.add(referrerClassNameProperty.eq(Campaign.class.getName()));

    Property createDateProperty = PropertyFactoryUtil.forName("createDate");

    dynamicQuery.add(createDateProperty.gt(date));

    ProjectionList projectionList = ProjectionFactoryUtil.projectionList();

    projectionList.add(ProjectionFactoryUtil.groupProperty("className"));
    projectionList.add(ProjectionFactoryUtil.groupProperty("classPK"));
    projectionList.add(ProjectionFactoryUtil.groupProperty("referrerClassPK"));

    dynamicQuery.setProjection(projectionList);

    List<Object[]> results = _analyticsEventLocalService.dynamicQuery(dynamicQuery);

    // Process analytics and store data

    for (Object[] result : results) {
        String className = GetterUtil.getString(result[0]);
        long classPK = GetterUtil.getLong(result[1]);
        long referrerClassPK = GetterUtil.getLong(result[2]);

        int contentViewCount = _analyticsEventLocalService.getAnalyticsEventsCount(className, classPK,
                Campaign.class.getName(), referrerClassPK, "view", date);

        if (contentViewCount == 0) {
            continue;
        }// ww w.j  av a 2 s  .  co m

        addCampaignContent(referrerClassPK, className, classPK, "view", contentViewCount);
    }
}

---

From source file:com.liferay.contenttargeting.reports.usersegmentcontent.service.impl.UserSegmentContentLocalServiceImpl.java

License:Open Source License

protected void addUserSegmentContentsFromAnalytics(Date date) throws PortalException, SystemException {

    // Retrieve analytics

    DynamicQuery dynamicQuery = _analyticsEventLocalService.dynamicQuery();

    Property referrerClassNameProperty = PropertyFactoryUtil.forName("referrerClassName");

    dynamicQuery.add(referrerClassNameProperty.eq(UserSegment.class.getName()));

    Property createDateProperty = PropertyFactoryUtil.forName("createDate");

    dynamicQuery.add(createDateProperty.gt(date));

    ProjectionList projectionList = ProjectionFactoryUtil.projectionList();

    projectionList.add(ProjectionFactoryUtil.groupProperty("className"));
    projectionList.add(ProjectionFactoryUtil.groupProperty("classPK"));
    projectionList.add(ProjectionFactoryUtil.groupProperty("referrerClassPK"));

    dynamicQuery.setProjection(projectionList);

    List<Object[]> results = _analyticsEventLocalService.dynamicQuery(dynamicQuery);

    // Process analytics and store data

    for (Object[] result : results) {
        String className = GetterUtil.getString(result[0]);
        long classPK = GetterUtil.getLong(result[1]);
        long referrerClassPK = GetterUtil.getLong(result[2]);

        int contentViewCount = _analyticsEventLocalService.getAnalyticsEventsCount(className, classPK,
                UserSegment.class.getName(), referrerClassPK, "view", date);

        if (contentViewCount == 0) {
            continue;
        }// w ww  . j a  v a  2 s . co m

        addUserSegmentContent(referrerClassPK, className, classPK, "view", contentViewCount);
    }
}

---

From source file:com.liferay.knowledgebase.service.impl.KBArticleLocalServiceImpl.java

License:Open Source License

protected DynamicQuery buildDynamicQuery(long groupId, String title, String content, int status, Date startDate,
        Date endDate, boolean andOperator) {

    Junction junction = null;/*  www.  j  a v a  2s.  co m*/

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

    Map<String, String> terms = new HashMap<String, String>();

    if (Validator.isNotNull(title)) {
        terms.put("title", title);
    }

    if (Validator.isNotNull(content)) {
        terms.put("content", content);
    }

    for (Map.Entry<String, String> entry : terms.entrySet()) {
        String key = entry.getKey();
        String value = entry.getValue();

        Disjunction disjunction = RestrictionsFactoryUtil.disjunction();

        for (String keyword : KnowledgeBaseUtil.splitKeywords(value)) {
            Criterion criterion = RestrictionsFactoryUtil.ilike(key,
                    StringUtil.quote(keyword, StringPool.PERCENT));

            disjunction.add(criterion);
        }

        junction.add(disjunction);
    }

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

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

    if ((endDate != null) && (startDate != null)) {
        Disjunction disjunction = RestrictionsFactoryUtil.disjunction();

        String[] propertyNames = { "createDate", "modifiedDate" };

        for (String propertyName : propertyNames) {
            Property property = PropertyFactoryUtil.forName(propertyName);

            Conjunction conjunction = RestrictionsFactoryUtil.conjunction();

            conjunction.add(property.gt(startDate));
            conjunction.add(property.lt(endDate));

            disjunction.add(conjunction);
        }

        junction.add(disjunction);
    }

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

    if (status == WorkflowConstants.STATUS_ANY) {
        Property property = PropertyFactoryUtil.forName("latest");

        dynamicQuery.add(property.eq(Boolean.TRUE));
    } else if (status == WorkflowConstants.STATUS_APPROVED) {
        Property property = PropertyFactoryUtil.forName("main");

        dynamicQuery.add(property.eq(Boolean.TRUE));
    }

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

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

    return dynamicQuery.add(junction);
}

---

From source file:com.liferay.knowledgebase.service.impl.KBStructureLocalServiceImpl.java

License:Open Source License

protected DynamicQuery buildDynamicQuery(long groupId, String title, String content, Date startDate,
        Date endDate, boolean andOperator) {

    Junction junction = null;/*from   w  ww . j a  va  2 s . c  o  m*/

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

    Map<String, String> terms = new HashMap<String, String>();

    if (Validator.isNotNull(title)) {
        terms.put("title", title);
    }

    if (Validator.isNotNull(content)) {
        String escapedContent = StringEscapeUtils.escapeXml(content);

        terms.put("content", content + StringPool.SPACE + escapedContent);
    }

    for (Map.Entry<String, String> entry : terms.entrySet()) {
        String key = entry.getKey();
        String value = entry.getValue();

        Disjunction disjunction = RestrictionsFactoryUtil.disjunction();

        for (String keyword : KnowledgeBaseUtil.parseKeywords(value)) {
            Criterion criterion = RestrictionsFactoryUtil.ilike(key,
                    StringUtil.quote(keyword, StringPool.PERCENT));

            disjunction.add(criterion);
        }

        junction.add(disjunction);
    }

    if ((endDate != null) && (startDate != null)) {
        Disjunction disjunction = RestrictionsFactoryUtil.disjunction();

        String[] propertyNames = { "createDate", "modifiedDate" };

        for (String propertyName : propertyNames) {
            Property property = PropertyFactoryUtil.forName(propertyName);

            Conjunction conjunction = RestrictionsFactoryUtil.conjunction();

            conjunction.add(property.gt(startDate));
            conjunction.add(property.lt(endDate));

            disjunction.add(conjunction);
        }

        junction.add(disjunction);
    }

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

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

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

    return dynamicQuery.add(junction);
}

---

From source file:com.liferay.knowledgebase.service.impl.KBTemplateLocalServiceImpl.java

License:Open Source License

protected DynamicQuery buildDynamicQuery(long groupId, String title, String content, Date startDate,
        Date endDate, boolean andOperator) {

    Junction junction = null;/* w  w  w  . j a v  a  2s  .c  o  m*/

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

    Map<String, String> terms = new HashMap<String, String>();

    if (Validator.isNotNull(title)) {
        terms.put("title", title);
    }

    if (Validator.isNotNull(content)) {
        terms.put("content", content);
    }

    for (Map.Entry<String, String> entry : terms.entrySet()) {
        String key = entry.getKey();
        String value = entry.getValue();

        Disjunction disjunction = RestrictionsFactoryUtil.disjunction();

        for (String keyword : KnowledgeBaseUtil.splitKeywords(value)) {
            Criterion criterion = RestrictionsFactoryUtil.ilike(key,
                    StringUtil.quote(keyword, StringPool.PERCENT));

            disjunction.add(criterion);
        }

        junction.add(disjunction);
    }

    if ((endDate != null) && (startDate != null)) {
        Disjunction disjunction = RestrictionsFactoryUtil.disjunction();

        String[] propertyNames = { "createDate", "modifiedDate" };

        for (String propertyName : propertyNames) {
            Property property = PropertyFactoryUtil.forName(propertyName);

            Conjunction conjunction = RestrictionsFactoryUtil.conjunction();

            conjunction.add(property.gt(startDate));
            conjunction.add(property.lt(endDate));

            disjunction.add(conjunction);
        }

        junction.add(disjunction);
    }

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

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

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

    return dynamicQuery.add(junction);
}

---

From source file:com.liferay.message.boards.comment.internal.MBDiscussionStagingHandler.java

License:Open Source License

@Override
public ActionableDynamicQuery getCommentExportActionableDynamicQuery(
        final PortletDataContext portletDataContext) {

    final ExportActionableDynamicQuery actionableDynamicQuery = MBMessageLocalServiceUtil
            .getExportActionableDynamicQuery(portletDataContext);

    actionableDynamicQuery.setAddCriteriaMethod(new ActionableDynamicQuery.AddCriteriaMethod() {

        @Override//from   w w w  .ja  v a  2 s . c  o  m
        public 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);
            }

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

            dynamicQuery.add(classNameIdProperty.gt(0L));

            Property parentMessageIdProperty = PropertyFactoryUtil.forName("parentMessageId");

            dynamicQuery.add(parentMessageIdProperty.gt(MBMessageConstants.DEFAULT_PARENT_MESSAGE_ID));

            Property statusProperty = PropertyFactoryUtil.forName("status");

            if (portletDataContext.isInitialPublication()) {
                dynamicQuery.add(statusProperty.ne(WorkflowConstants.STATUS_IN_TRASH));
            } else {
                StagedModelDataHandler<?> stagedModelDataHandler = StagedModelDataHandlerRegistryUtil
                        .getStagedModelDataHandler(MBMessage.class.getName());

                dynamicQuery.add(statusProperty.in(stagedModelDataHandler.getExportableStatuses()));
            }
        }

    });

    return actionableDynamicQuery;
}

---

From source file:com.liferay.sync.internal.messaging.DLSyncEventMessageListener.java

License:Open Source License

@Activate
protected void activate() {
    ActionableDynamicQuery actionableDynamicQuery = _dlSyncEventLocalService.getActionableDynamicQuery();

    actionableDynamicQuery.setAddCriteriaMethod(new ActionableDynamicQuery.AddCriteriaMethod() {

        @Override//from   w  w  w.  j  a v  a2s .  c o m
        public void addCriteria(DynamicQuery dynamicQuery) {
            Property modifiedTimeProperty = PropertyFactoryUtil.forName("modifiedTime");

            dynamicQuery.add(modifiedTimeProperty.gt(_syncDLObjectLocalService.getLatestModifiedTime()));
        }

    });

    actionableDynamicQuery
            .setPerformActionMethod(new ActionableDynamicQuery.PerformActionMethod<DLSyncEvent>() {

                @Override
                public void performAction(DLSyncEvent dlSyncEvent) throws PortalException {

                    try {
                        processDLSyncEvent(dlSyncEvent.getModifiedTime(), dlSyncEvent.getEvent(),
                                dlSyncEvent.getType(), dlSyncEvent.getTypePK());
                    } catch (Exception e) {
                        _log.error(e, e);
                    }
                }

            });

    try {
        actionableDynamicQuery.performActions();
    } catch (Exception e) {
        _log.error(e, e);
    }
}

---