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

Introduction

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

Prototype

public static Criterion gt(String propertyName, Object value) 

Source Link

Usage

From source file:com.liferay.events.global.mobile.service.impl.MessageLocalServiceImpl.java

License:Open Source License

public List<Message> getContactMessages(String eventId, long contactId, long beginDate)
        throws PortalException, SystemException {

    DynamicQuery q = DynamicQueryFactoryUtil.forClass(Message.class, Message.class.getClassLoader());
    q.add(RestrictionsFactoryUtil.eq("eventId", eventId));
    q.add(RestrictionsFactoryUtil.or(RestrictionsFactoryUtil.eq("fromId", contactId),
            RestrictionsFactoryUtil.eq("toId", contactId)));
    if (beginDate > 0) {
        q.add(RestrictionsFactoryUtil.gt("createDate", new Date(beginDate)));
    }/*from ww w .ja  v a 2 s .c o m*/

    return dynamicQuery(q);

}

---

From source file:com.liferay.mail.service.impl.MessageLocalServiceImpl.java

License:Open Source License

public Message getRemoteMessage(long folderId, boolean oldest) throws PortalException {

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

    dynamicQuery.add(RestrictionsFactoryUtil.eq("folderId", folderId));
    dynamicQuery.add(RestrictionsFactoryUtil.gt("remoteMessageId", new Long(0)));

    if (oldest) {
        dynamicQuery.addOrder(OrderFactoryUtil.asc("remoteMessageId"));
    } else {//from   www  .  j  a  v  a  2s  . c  o  m
        dynamicQuery.addOrder(OrderFactoryUtil.desc("remoteMessageId"));
    }

    List<Message> messages = messagePersistence.findWithDynamicQuery(dynamicQuery, 0, 1);

    if (messages.isEmpty()) {
        throw new NoSuchMessageException();
    }

    return messages.get(0);
}

---

From source file:com.rivetlogic.service.impl.PeopleDirectoryServiceImpl.java

License:Open Source License

/**
 * Retrieves all the system users from the given date
 *
 * @param modifiedDate modified date//  w  w  w .j  ava2s.com
 * @param start Page beginning
 * @param end Page end
 *
 * @return
 * @throws SystemException
 * @throws PortalException
 */

public PeopleDirectoryResult usersFetchByDate(Timestamp modifiedDate, int start, int end)
        throws SystemException, PortalException {
    DynamicQuery userQuery = DynamicQueryFactoryUtil.forClass(User.class,
            PortalClassLoaderUtil.getClassLoader());

    List<UserData> resultUsers = new ArrayList<UserData>();

    Date date = new Date(modifiedDate.getTime());

    Criterion criterion1 = null, criterion2 = null, criterion3 = null, criterionBundled = null;
    criterion1 = RestrictionsFactoryUtil.gt(FIELD_MODIFIED_DATE, date);
    criterion2 = RestrictionsFactoryUtil.eq(FIELD_STATUS, 0);
    criterion3 = RestrictionsFactoryUtil.ne(FIELD_EMAIL, DEFAULT_EMAIL);
    criterionBundled = RestrictionsFactoryUtil.and(criterion1, criterion2);
    userQuery.add(criterionBundled);
    userQuery.add(criterion3);
    List<User> users = UserLocalServiceUtil.dynamicQuery(userQuery, start, end);

    for (User user : users) {
        resultUsers.add(processUserInformation(user));
    }

    PeopleDirectoryResult usersPD = new PeopleDirectoryResult();

    usersPD.setTotal(users.size());
    usersPD.setUsers(resultUsers);
    usersPD.setActiveUsersCount(this.getActiveUsersCount());
    return usersPD;
}

---

From source file:com.warrantchange.service.impl.WarrantLocalServiceImpl.java

License:Open Source License

public List<Warrant> findWarrantsByCreateDate(Date from, Date to) throws SystemException {
    DynamicQuery dynamicQuery = createDynamicQuery()
            .add(RestrictionsFactoryUtil.eq("status", WarrantStateType.CREATED.name()))
            .add(RestrictionsFactoryUtil.eq("expirationWarningSent", false));
    if (from != null) {
        dynamicQuery = dynamicQuery.add(RestrictionsFactoryUtil.gt("createDate", from));
    }/*from w  w w .j  a  v  a  2s.  com*/
    if (to != null) {
        dynamicQuery = dynamicQuery.add(RestrictionsFactoryUtil.le("createDate", to));
    }
    return dynamicQuery(dynamicQuery);
}

---

From source file:de.fraunhofer.fokus.movepla.service.impl.ApplicationLocalServiceImpl.java

License:Open Source License

public List<Application> getMostViewdApplications() {

    try {/*from   w ww .  ja  va  2s. c  o  m*/
        DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Application.class);

        Criterion criterion = RestrictionsFactoryUtil.gt("detailsViewed", new Long(0));
        dynamicQuery.add(criterion);

        Order defaultOrder = OrderFactoryUtil.desc("detailsViewed");
        dynamicQuery.addOrder(defaultOrder);

        return dynamicQuery(dynamicQuery);
    } catch (SystemException e) {
        e.printStackTrace();
    }
    return null;
}

---

From source file:de.fraunhofer.fokus.movepla.service.impl.ApplicationLocalServiceImpl.java

License:Open Source License

public List<Application> getMostViewdApplications(int end) {

    try {//from   w  ww .j av  a 2  s .co m
        DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Application.class);

        Criterion criterion = RestrictionsFactoryUtil.gt("detailsViewed", new Long(0));
        dynamicQuery.add(criterion);

        Order defaultOrder = OrderFactoryUtil.desc("detailsViewed");
        dynamicQuery.addOrder(defaultOrder);
        dynamicQuery.setLimit(0, end);

        return dynamicQuery(dynamicQuery);
    } catch (SystemException e) {
        e.printStackTrace();
    }
    return null;
}

---

From source file:de.fraunhofer.fokus.movepla.service.impl.ApplicationLocalServiceImpl.java

License:Open Source License

public List<Application> getMostViewdApplications(int from, int end) {

    try {// ww w  .  java  2s  .co m
        DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Application.class);

        Criterion criterion = RestrictionsFactoryUtil.gt("detailsViewed", new Long(0));
        dynamicQuery.add(criterion);

        Order defaultOrder = OrderFactoryUtil.desc("detailsViewed");
        dynamicQuery.addOrder(defaultOrder);
        dynamicQuery.setLimit(from, end);

        return dynamicQuery(dynamicQuery);
    } catch (SystemException e) {
        e.printStackTrace();
    }
    return null;
}

---

From source file:de.fraunhofer.fokus.movepla.service.impl.ApplicationLocalServiceImpl.java

License:Open Source License

public List<Application> getMostClickedApplications() {

    try {/*w w w  .  j  av  a2  s  .  c o m*/
        DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Application.class);

        Criterion criterion = RestrictionsFactoryUtil.gt("linkClicked", new Long(0));
        dynamicQuery.add(criterion);

        Order defaultOrder = OrderFactoryUtil.desc("linkClicked");
        dynamicQuery.addOrder(defaultOrder);

        return dynamicQuery(dynamicQuery);
    } catch (SystemException e) {
        e.printStackTrace();
    }
    return null;
}

---

From source file:de.fraunhofer.fokus.movepla.service.impl.ApplicationLocalServiceImpl.java

License:Open Source License

public List<Application> getMostClickedApplications(int end) {

    try {// w  w w .  j a  v a2s  . c om
        DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Application.class);

        Criterion criterion = RestrictionsFactoryUtil.gt("linkClicked", new Long(0));
        dynamicQuery.add(criterion);

        Order defaultOrder = OrderFactoryUtil.desc("linkClicked");
        dynamicQuery.addOrder(defaultOrder);
        dynamicQuery.setLimit(0, end);

        return dynamicQuery(dynamicQuery);
    } catch (SystemException e) {
        e.printStackTrace();
    }
    return null;
}

---

From source file:de.fraunhofer.fokus.movepla.service.impl.ApplicationLocalServiceImpl.java

License:Open Source License

public List<Application> getMostClickedApplications(int from, int end) {

    try {/*  w  ww  .  j  a v a2  s  .c om*/
        DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Application.class);

        Criterion criterion = RestrictionsFactoryUtil.gt("linkClicked", new Long(0));
        dynamicQuery.add(criterion);

        Order defaultOrder = OrderFactoryUtil.desc("linkClicked");
        dynamicQuery.addOrder(defaultOrder);
        dynamicQuery.setLimit(0, end);

        return dynamicQuery(dynamicQuery);
    } catch (SystemException e) {
        e.printStackTrace();
    }
    return null;
}

---

• «
• 1
• 2
• »