List of usage examples for com.liferay.portal.kernel.dao.orm DynamicQuery setLimit
public void setLimit(int start, int end);
From source file:com.cmcti.cmts.domain.service.impl.CableModemLocalServiceImpl.java
License:Open Source License
@SuppressWarnings({ "rawtypes" })
public List getAvgValueForUpstream(long cmtsId, int ifIndex, int status) throws SystemException {
DynamicQuery query = dynamicQuery();
// restrictions
query.add(RestrictionsFactoryUtil.eq("cmtsId", cmtsId));
query.add(RestrictionsFactoryUtil.eq("ucIfIndex", ifIndex));
query.add(RestrictionsFactoryUtil.eq("status", status));
query.add(RestrictionsFactoryUtil.ne("dsSNR", 0));
query.add(RestrictionsFactoryUtil.ne("usPower", 0));
query.add(RestrictionsFactoryUtil.ne("dsSNR", 129));
query.add(RestrictionsFactoryUtil.ne("usPower", 129));
// projection
query.setProjection(ProjectionFactoryUtil.projectionList().add(ProjectionFactoryUtil.avg("microRef"))
.add(ProjectionFactoryUtil.avg("rxPower")).add(ProjectionFactoryUtil.avg("txPower"))
.add(ProjectionFactoryUtil.avg("usPower")).add(ProjectionFactoryUtil.avg("dsPower"))
.add(ProjectionFactoryUtil.avg("dsSNR")));
query.setLimit(0, 1);
return dynamicQuery(query);
}
From source file:com.cmcti.cmts.domain.service.impl.CableModemLocalServiceImpl.java
License:Open Source License
@SuppressWarnings("unchecked") public List<CableModem> findByMacAddress(String macAddress, int maxResults) throws SystemException { DynamicQuery query = dynamicQuery(); query.add(RestrictionsFactoryUtil.ilike("macAddress", "%" + macAddress + "%")); query.setLimit(0, maxResults); return dynamicQuery(query); }
From source file:com.cmcti.cmts.domain.service.impl.UpstreamChannelLocalServiceImpl.java
License:Open Source License
@SuppressWarnings("rawtypes") public List getSumCmCounts(DynamicQuery query) throws SystemException { // projection query.setProjection(/*from w w w . ja v a 2 s . c om*/ ProjectionFactoryUtil.projectionList().add(ProjectionFactoryUtil.sum("upChannelCmTotal")) .add(ProjectionFactoryUtil.sum("upChannelCmRegistered")) .add(ProjectionFactoryUtil.sum("upChannelCmActive"))); query.setLimit(0, 1); return dynamicQuery(query); }
From source file:com.hitss.layer.service.impl.FasePostulacionLocalServiceImpl.java
License:Open Source License
public FasePostulacion getLastPostulacion(Long solicitud, Long usuario) { DynamicQuery subQuery = DynamicQueryFactoryUtil.forClass(FasePostulacion.class, "child"); subQuery.setProjection(ProjectionFactoryUtil.max("child.fechamodifica")); subQuery.add(PropertyFactoryUtil.forName("child.solicitudRequerimientoId").eq(solicitud)); subQuery.add(PropertyFactoryUtil.forName("child.usuarioId").eq(usuario)); subQuery.setLimit(0, 1); DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(FasePostulacion.class, "fase"); dynamicQuery.add(PropertyFactoryUtil.forName("fase.fechamodifica").eq(subQuery)); dynamicQuery.add(PropertyFactoryUtil.forName("fase.solicitudRequerimientoId").eq(solicitud)); dynamicQuery.add(PropertyFactoryUtil.forName("fase.usuarioId").eq(usuario)); try {//from w ww . j a v a 2s . c om List<FasePostulacion> lstfasePostulacion = FasePostulacionLocalServiceUtil.dynamicQuery(dynamicQuery); _log.info("lstfasePostulacion:" + lstfasePostulacion); if (!lstfasePostulacion.isEmpty()) { return lstfasePostulacion.get(0); } } catch (SystemException e) { _log.error("FasePostulacionServiceImpl getLastPostulacion: " + e.getLocalizedMessage(), e); } return null; }
From source file:com.hitss.layer.service.impl.FasePostulacionLocalServiceImpl.java
License:Open Source License
public FasePostulacion getNotLastPostulacion(Long solicitud, Long usuario) { DynamicQuery subQuery = DynamicQueryFactoryUtil.forClass(FasePostulacion.class, "child"); subQuery.setProjection(ProjectionFactoryUtil.max("child.fechamodifica")); subQuery.add(PropertyFactoryUtil.forName("child.solicitudRequerimientoId").ne(solicitud)); subQuery.add(PropertyFactoryUtil.forName("child.usuarioId").eq(usuario)); subQuery.setLimit(0, 1); DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(FasePostulacion.class, "fase"); dynamicQuery.add(PropertyFactoryUtil.forName("fase.fechamodifica").eq(subQuery)); dynamicQuery.add(PropertyFactoryUtil.forName("fase.solicitudRequerimientoId").ne(solicitud)); dynamicQuery.add(PropertyFactoryUtil.forName("fase.usuarioId").eq(usuario)); try {//from w ww .jav a2 s . c om List<FasePostulacion> lstfasePostulacion = FasePostulacionLocalServiceUtil.dynamicQuery(dynamicQuery); _log.info("lstfasePostulacion:" + lstfasePostulacion); if (!lstfasePostulacion.isEmpty()) { return lstfasePostulacion.get(0); } } catch (SystemException e) { _log.error("FasePostulacionServiceImpl getLastPostulacion: " + e.getLocalizedMessage(), e); } return null; }
From source file:com.labimo.portlet.LicenseManage.java
@Override public void doView(RenderRequest renderRequest, RenderResponse renderResponse) throws PortletException, IOException { String action = (String) renderRequest.getAttribute("action"); System.out.println("action" + action); String screenName = (String) renderRequest.getAttribute("screenName"); System.out.println("screenName" + screenName); Boolean flag = false;/*w w w. ja v a 2 s .c o m*/ try { ThemeDisplay themeDisplay = (ThemeDisplay) renderRequest .getAttribute(com.liferay.portal.kernel.util.WebKeys.THEME_DISPLAY); User currentUser = PortalUtil.getUser(renderRequest); if (currentUser != null) { List<UserGroup> userGroups = UserGroupLocalServiceUtil.getUserUserGroups(themeDisplay.getUserId()); for (UserGroup group : userGroups) { System.out.println(group.getName()); if (manageGroup.equals(group.getName())) { flag = true; } } List<License> licenseList = new ArrayList<License>(); if (flag) { if (Validator.isBlank(screenName)) { licenseList = LicenseLocalServiceUtil.getLicenses(0, queryMax); } else { screenName = "%" + screenName + "%"; DynamicQuery userQuery = DynamicQueryFactoryUtil.forClass(User.class) .add(PropertyFactoryUtil.forName("screenName").like(screenName)); userQuery.setLimit(0, queryMax); List<User> userList = UserLocalServiceUtil.dynamicQuery(userQuery); List<Long> userIdList = new ArrayList<Long>(); for (User user : userList) { userIdList.add(user.getUserId()); } DynamicQuery query = DynamicQueryFactoryUtil.forClass(License.class) .add(PropertyFactoryUtil.forName("userId").in(userIdList)); licenseList = LicenseLocalServiceUtil.dynamicQuery(query); } } else { DynamicQuery query = DynamicQueryFactoryUtil.forClass(License.class) .add(PropertyFactoryUtil.forName("userId").eq(currentUser.getUserId())); licenseList = LicenseLocalServiceUtil.dynamicQuery(query); } System.out.println(licenseList.size()); renderRequest.setAttribute("licenseList", licenseList); } renderRequest.setAttribute("flag", flag); } catch (Exception e) { e.printStackTrace(); } System.out.println("flag" + flag); if (flag) { super.doView(renderRequest, renderResponse); } else { include("/userView.jsp", renderRequest, renderResponse); } }
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)); }/* w ww . ja v 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.exportimport.web.internal.messaging.DraftExportImportConfigurationMessageListener.java
License:Open Source License
@Override protected void doReceive(Message message) throws PortalException { if (ExportImportWebConfigurationValues.DRAFT_EXPORT_IMPORT_CONFIGURATION_CLEAN_UP_COUNT == -1) { return;//from w ww . ja v a 2 s.co m } final Date lastCreateDate; if (ExportImportWebConfigurationValues.DRAFT_EXPORT_IMPORT_CONFIGURATION_CLEAN_UP_COUNT == 0) { lastCreateDate = new Date(); } else { DynamicQuery dynamicQuery = _exportImportConfigurationLocalService.dynamicQuery(); addCommonCriterions(dynamicQuery); Order order = OrderFactoryUtil.desc("createDate"); dynamicQuery.addOrder(order); dynamicQuery.setLimit(QueryUtil.ALL_POS, ExportImportWebConfigurationValues.DRAFT_EXPORT_IMPORT_CONFIGURATION_CLEAN_UP_COUNT); dynamicQuery.setProjection(ProjectionFactoryUtil.property("createDate")); List<Date> createDates = _exportImportConfigurationLocalService.dynamicQuery(dynamicQuery); if (ListUtil.isEmpty(createDates)) { return; } lastCreateDate = createDates.get(createDates.size() - 1); } ActionableDynamicQuery actionableDynamicQuery = _exportImportConfigurationLocalService .getActionableDynamicQuery(); final Property createDate = PropertyFactoryUtil.forName("createDate"); actionableDynamicQuery.setAddCriteriaMethod(new ActionableDynamicQuery.AddCriteriaMethod() { @Override public void addCriteria(DynamicQuery dynamicQuery) { addCommonCriterions(dynamicQuery); dynamicQuery.add(createDate.lt(lastCreateDate)); } }); actionableDynamicQuery.setPerformActionMethod( new ActionableDynamicQuery.PerformActionMethod<ExportImportConfiguration>() { @Override public void performAction(ExportImportConfiguration exportImportConfiguration) throws PortalException { List<BackgroundTask> backgroundTasks = getParentBackgroundTasks(exportImportConfiguration); if (ListUtil.isEmpty(backgroundTasks)) { _exportImportConfigurationLocalService .deleteExportImportConfiguration(exportImportConfiguration); return; } // BackgroundTaskModelListener deletes the linked // configuration automatically for (BackgroundTask backgroundTask : backgroundTasks) { if (isLiveGroup(backgroundTask.getGroupId())) { continue; } _backgroundTaskLocalService.deleteBackgroundTask(backgroundTask.getBackgroundTaskId()); } } }); actionableDynamicQuery.performActions(); }
From source file:com.liferay.ruon.service.persistence.NetworkPersistenceImpl.java
License:Open Source License
public List<Object> findWithDynamicQuery(DynamicQuery dynamicQuery, int start, int end) throws SystemException { Session session = null;/*from w ww.j ava 2s. com*/ try { session = openSession(); dynamicQuery.setLimit(start, end); dynamicQuery.compile(session); return dynamicQuery.list(); } catch (Exception e) { throw processException(e); } finally { closeSession(session); } }
From source file:com.liferay.screens.service.impl.ScreensAssetEntryServiceImpl.java
License:Open Source License
@Override public JSONArray getAssetEntries(long companyId, long groupId, String portletItemName, Locale locale, int max) throws PortalException { DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(PortletItem.class); Property property = PropertyFactoryUtil.forName("name"); dynamicQuery.add(property.eq(portletItemName)); dynamicQuery.setLimit(0, 1); List<PortletItem> portletItems = portletItemLocalService.dynamicQuery(dynamicQuery); if (portletItems.isEmpty()) { throw new PortalException("No portlet items associated with portlet item name " + portletItemName); }//from ww w . j a va 2 s .c o m PortletItem portletItem = portletItems.get(0); PortletPreferences portletPreferences = portletPreferencesLocalService.getPreferences( portletItem.getCompanyId(), portletItem.getPortletItemId(), PortletKeys.PREFS_OWNER_TYPE_ARCHIVED, 0, portletItem.getPortletId()); String selectionStyle = GetterUtil.getString(portletPreferences.getValue("selectionStyle", null), "dynamic"); if (selectionStyle.equals("dynamic")) { if (max > 500) { max = 500; } List<Layout> layouts = layoutLocalService.getLayouts(companyId); if (!layouts.isEmpty()) { Layout layout = layouts.get(0); List<AssetEntry> assetEntries = _assetPublisherUtil.getAssetEntries(portletPreferences, layout, groupId, max, false); assetEntries = filterAssetEntries(assetEntries); return toJSONArray(assetEntries, locale); } else { return JSONFactoryUtil.createJSONArray(); } } else { try { PermissionChecker permissionChecker = PermissionCheckerFactoryUtil.create(getUser()); List<AssetEntry> assetEntries = _assetPublisherUtil.getAssetEntries(null, portletPreferences, permissionChecker, new long[] { groupId }, false, false, false); assetEntries = filterAssetEntries(assetEntries); return toJSONArray(assetEntries, locale); } catch (PortalException | SystemException e) { throw e; } catch (Exception e) { throw new PortalException(e); } } }