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

Introduction

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

Prototype

public static Criterion le(String propertyName, Object value) 

Source Link

Usage

From source file:com.rivetlogic.event.service.impl.EventLocalServiceImpl.java

License:Open Source License

private DynamicQuery getPastEventsDynamicQuery(boolean useOrder, long userId) {
    Date currentDate = new Date();
    Criterion criterion = RestrictionsFactoryUtil.le(EVENT_DATE_COLUMN, currentDate);
    criterion = RestrictionsFactoryUtil.and(criterion, getOwnerOrPublicEventsCriterion(userId));
    return getEventsDynamicQuery(criterion, useOrder);
}

---

From source file:com.vietnamobile.service.impl.OnlinetestEntryLocalServiceImpl.java

License:Open Source License

private DynamicQuery buildDynamicQuery(String title, String userName, Date fromDate, Date toDate,
        Class<?> clazz, boolean andSearch) {
    DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(clazz, getClassLoader());
    Junction junction = null;/*from w  w w  . j a  va2s  .com*/
    if (andSearch) {
        junction = RestrictionsFactoryUtil.conjunction();
    } else {
        junction = RestrictionsFactoryUtil.disjunction();
    }

    if (Validator.isNotNull(userName)) {
        Property property = PropertyFactoryUtil.forName("userName");
        String value = (new StringBuilder("%")).append(userName).append("%").toString();
        junction.add(property.like(value));

    }
    if (Validator.isNotNull(title)) {
        Property property = PropertyFactoryUtil.forName("title");
        String value = (new StringBuilder("%")).append(title).append("%").toString();
        junction.add(property.like(value));
    }
    if (Validator.isNotNull(fromDate) && Validator.isNull(toDate)) {
        dynamicQuery.add(RestrictionsFactoryUtil.ge("createDate", fromDate));
    }
    if (Validator.isNotNull(toDate) && Validator.isNull(fromDate)) {
        dynamicQuery.add(RestrictionsFactoryUtil.le("createDate", toDate));
    }
    if (Validator.isNotNull(fromDate) && Validator.isNotNull(toDate)) {
        dynamicQuery.add(RestrictionsFactoryUtil.between("createDate", fromDate, toDate));
    }

    return dynamicQuery.add(junction);
}

---

From source file:com.vietnamobile.service.impl.OnlinetestResultEntryLocalServiceImpl.java

License:Open Source License

private DynamicQuery buildDynamicQuery(long userId, long onlinetestEntryId, String userName, double score,
        Date fromDate, Date toDate, String examType, Class<?> clazz, boolean andSearch) {
    DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(clazz, getClassLoader());
    Junction junction = null;/*from  w  ww  . ja  va  2 s .  c om*/
    if (andSearch) {
        junction = RestrictionsFactoryUtil.conjunction();
    } else {
        junction = RestrictionsFactoryUtil.disjunction();
    }

    if (userId > 0) {
        Property property = PropertyFactoryUtil.forName("userId");
        junction.add(property.eq(Long.valueOf(userId)));
    }
    if (onlinetestEntryId > 0) {
        Property property = PropertyFactoryUtil.forName("onlineTestEntryId");
        junction.add(property.eq(Long.valueOf(onlinetestEntryId)));
    }
    if (Validator.isNotNull(userName)) {
        Property property = PropertyFactoryUtil.forName("userName");
        String value = (new StringBuilder("%")).append(userName).append("%").toString();
        junction.add(property.like(value));

    }
    if (Validator.isNotNull(examType)) {
        Property property = PropertyFactoryUtil.forName("examType");
        String value = (new StringBuilder("")).append(examType).toString();
        junction.add(property.eq(value));
    }
    if (score > 0) {
        Property property = PropertyFactoryUtil.forName("score");
        junction.add(property.eq(score));
    }
    if (Validator.isNotNull(fromDate) && Validator.isNull(toDate)) {
        dynamicQuery.add(RestrictionsFactoryUtil.ge("createDate", fromDate));
    }
    if (Validator.isNotNull(toDate) && Validator.isNull(fromDate)) {
        dynamicQuery.add(RestrictionsFactoryUtil.le("createDate", toDate));
    }
    if (Validator.isNotNull(fromDate) && Validator.isNotNull(toDate)) {
        dynamicQuery.add(RestrictionsFactoryUtil.between("createDate", fromDate, toDate));
    }

    return dynamicQuery.add(junction);
}

---

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

License:Open Source License

public void cleanUpWarrantsDeletedBefore(Date before) throws NoSuchWarrantException, SystemException {
    DynamicQuery dynamicQuery = createDynamicQuery()
            .add(RestrictionsFactoryUtil.eq("status", WarrantStateType.DELETED.name()))
            .add(RestrictionsFactoryUtil.le("modifiedDate", before));
    List<Warrant> warrants = dynamicQuery(dynamicQuery);
    for (Warrant warrant : warrants) {
        WarrantUtil.remove(warrant.getId());
    }/*from w  w  w.  java2  s . c  o  m*/
}

---

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  a2 s  .  co m
    if (to != null) {
        dynamicQuery = dynamicQuery.add(RestrictionsFactoryUtil.le("createDate", to));
    }
    return dynamicQuery(dynamicQuery);
}

---

From source file:it.smc.calendar.sync.calendar.util.CalendarUtil.java

License:Open Source License

public static List<CalendarBooking> getCalendarBookings(PermissionChecker permissionChecker, Calendar calendar,
        Date startDate, Date endDate) throws PortalException, SystemException {

    ClassLoader classLoader = ClassLoaderPool.getClassLoader("calendar-portlet");

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

    dynamicQuery.add(RestrictionsFactoryUtil.eq("calendarId", calendar.getCalendarId()));

    Integer[] status = { WorkflowConstants.STATUS_APPROVED, WorkflowConstants.STATUS_PENDING,
            9 /* CalendarBookingWorkflowConstants.STATUS_MAYBE */ };
    dynamicQuery.add(RestrictionsFactoryUtil.in("status", status));

    if (startDate != null) {
        dynamicQuery.add(RestrictionsFactoryUtil.ge("startTime", new Long(startDate.getTime())));
    }/* w  w  w. j  av a  2  s. c  o m*/

    if (endDate != null) {
        dynamicQuery.add(RestrictionsFactoryUtil.le("endTime", new Long(endDate.getTime())));
    }

    List<CalendarBooking> allCalendarBookings = CalendarBookingLocalServiceUtil.dynamicQuery(dynamicQuery);

    return filterCalendarBookings(allCalendarBookings, permissionChecker, ActionKeys.VIEW);
}

---

From source file:ru.inrecolan.statistics.service.impl.StatisticsLocalServiceImpl.java

License:Open Source License

 @SuppressWarnings("unchecked")
public List<Statistics> search(
      Date startDate, //from  w w w  . j  a  v a2s.co  m
       Date endDate,
       String url,
       boolean isAndOperator) {
      
    List<Statistics> audits = null;
   try {
      DynamicQuery auditQuery = DynamicQueryFactoryUtil.forClass(Statistics.class);
      Criterion sumCriterion = null;
      Criterion startDateCrit = RestrictionsFactoryUtil.ge("actionDate", startDate);
      Criterion endDateCrit = RestrictionsFactoryUtil.le("actionDate", endDate);               
      Criterion urlCrit = RestrictionsFactoryUtil.eq("url", url);
         
      if(isAndOperator) {
         if (isYearValid(startDate)) {
            if(sumCriterion == null) {
               sumCriterion = startDateCrit;
            }
         }
         if (isYearValid(endDate)) {
            if(sumCriterion == null) {
               sumCriterion = endDateCrit;
            } else {
               sumCriterion = RestrictionsFactoryUtil.and(sumCriterion, endDateCrit);
            };
         }
         if (url != null && !(url.equals(StringPool.BLANK))) {
            if(sumCriterion == null) {
               sumCriterion = urlCrit;
            } else {               
               sumCriterion = RestrictionsFactoryUtil.and(sumCriterion, urlCrit);
            }
         }      
      } else {
         if (isYearValid(startDate)) {
            if(sumCriterion == null) {
               sumCriterion = startDateCrit;
            }
         }
         if (isYearValid(endDate)) {
            if(sumCriterion == null) {
               sumCriterion = endDateCrit;
            } else {
               sumCriterion = RestrictionsFactoryUtil.or(sumCriterion, endDateCrit);
            };
         }
         if (url != null && !(url.equals(StringPool.BLANK))) {
            if(sumCriterion == null) {
               sumCriterion = urlCrit;
            } else {               
               sumCriterion = RestrictionsFactoryUtil.or(sumCriterion, urlCrit);
            }
         }               
      }
      if(sumCriterion != null) {
         auditQuery.add(sumCriterion);
      }
      audits = (List<Statistics>) StatisticsLocalServiceUtil
            .dynamicQuery(auditQuery);
   } catch (SystemException e) {
      _log.error("   ??     URL: " + e.getMessage());
   }
   return audits;
}

---