List of usage examples for com.liferay.portal.kernel.dao.orm RestrictionsFactoryUtil ne
public static Criterion ne(String propertyName, Object value)
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);/* w w w. j av a 2 s . c om*/
return dynamicQuery(query);
}
From source file:com.htmsd.slayer.service.impl.ShoppingItemLocalServiceImpl.java
License:Open Source License
public int getByStatusCount(int status) { DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(ShoppingItem.class); dynamicQuery.add(RestrictionsFactoryUtil.ne("quantity", (long) 0)); dynamicQuery.add(RestrictionsFactoryUtil.eq("status", status)); long count = 0; try {// w w w . ja v a2 s . c o m count = shoppingItemLocalService.dynamicQueryCount(dynamicQuery); } catch (SystemException e) { e.printStackTrace(); } return (int) count; }
From source file:com.inikah.slayer.service.impl.MatchCriteriaLocalServiceImpl.java
License:Open Source License
/** * /*from ww w. j a va 2 s. co m*/ */ @SuppressWarnings("unchecked") public List<Profile> getMatches(long profileId) { List<Profile> matches = new ArrayList<Profile>(); Profile profile = null; try { profile = profileLocalService.fetchProfile(profileId); } catch (SystemException e) { e.printStackTrace(); } MatchCriteria matchCriteria = null; try { matchCriteria = fetchMatchCriteria(profileId); } catch (SystemException e) { e.printStackTrace(); } if (Validator.isNull(matchCriteria)) { return matches; } DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Profile.class, PortletClassLoaderUtil.getClassLoader()); // bride or grooms dynamicQuery.add(RestrictionsFactoryUtil.ne("bride", profile.isBride())); // minAge and maxAge int minValue = AgeUtil.getBornOnFigure(matchCriteria.getMaxAge(), AgeUtil.MAX); int maxValue = AgeUtil.getBornOnFigure(matchCriteria.getMinAge(), AgeUtil.MIN); dynamicQuery.add(RestrictionsFactoryUtil.between("bornOn", minValue, maxValue)); // exclude the profiles of the same user dynamicQuery.add(RestrictionsFactoryUtil.ne("userId", profile.getUserId())); // only pull profiles that are currently 'ACTIVE' dynamicQuery.add(RestrictionsFactoryUtil.eq("status", IConstants.PROFILE_STATUS_ACTIVE)); // marital status String maritalStatusCSV = matchCriteria.getMaritalStatus(); if (Validator.isNotNull(maritalStatusCSV)) { List<Integer> maritalStatusList = MyListUtil.getIntegers(maritalStatusCSV); dynamicQuery.add(RestrictionsFactoryUtil.in("maritalStatus", maritalStatusList)); int married = BridgeServiceUtil.getListTypeId(IConstants.LIST_MARITAL_STATUS, "married"); int divorced = BridgeServiceUtil.getListTypeId(IConstants.LIST_MARITAL_STATUS, "divorced"); int widow = BridgeServiceUtil.getListTypeId(IConstants.LIST_MARITAL_STATUS, "widow"); if ((maritalStatusList.contains(married) || maritalStatusList.contains(divorced) || maritalStatusList.contains(widow)) && matchCriteria.isWithNoChildren()) { dynamicQuery.add(RestrictionsFactoryUtil.eq("sons", 0)); dynamicQuery.add(RestrictionsFactoryUtil.eq("daughters", 0)); } } // mother tongue String motherTongueCSV = matchCriteria.getMotherTongue(); if (Validator.isNotNull(motherTongueCSV)) { dynamicQuery.add(RestrictionsFactoryUtil.in("motherTongue", MyListUtil.getIntegers(motherTongueCSV))); } // NEVER show "Single" profiles for Non-Single Profiles. if (!profile.isSingle()) { dynamicQuery.add(RestrictionsFactoryUtil.eq("allowNonSingleProposals", true)); } // exclude profiles that are "blocked" for this profile List<Long> blockedIds = InteractionLocalServiceUtil.getTargetIds(profileId, IConstants.INT_ACTION_BLOCKED); for (long targetId : blockedIds) { dynamicQuery.add(RestrictionsFactoryUtil.ne("profileId", targetId)); } try { matches = dynamicQuery(dynamicQuery); } catch (SystemException e) { e.printStackTrace(); } return matches; }
From source file:com.rivetlogic.service.impl.PeopleDirectoryServiceImpl.java
License:Open Source License
/** * Retrieves all the system users//w w w . j a v a 2 s .co m * * @return * @throws SystemException * @throws PortalException */ public PeopleDirectoryResult fetchAll() throws SystemException, PortalException { DynamicQuery userQuery = DynamicQueryFactoryUtil.forClass(User.class, PortalClassLoaderUtil.getClassLoader()); List<UserData> resultUsers = new ArrayList<UserData>(); Criterion criterion1 = null, criterion2 = null; criterion1 = RestrictionsFactoryUtil.eq(FIELD_STATUS, 0); criterion2 = RestrictionsFactoryUtil.ne(FIELD_EMAIL, DEFAULT_EMAIL); userQuery.add(criterion1); userQuery.add(criterion2); List<User> users = UserLocalServiceUtil.dynamicQuery(userQuery); for (User user : users) { resultUsers.add(processUserInformation(user)); } PeopleDirectoryResult usersPD = new PeopleDirectoryResult(); usersPD.setTotal(users.size()); usersPD.setUsers(resultUsers); usersPD.setActiveUsersCount(users.size()); return usersPD; }
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//from w w w . j a v a2s . 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.rivetlogic.service.impl.PeopleDirectoryServiceImpl.java
License:Open Source License
/** * Get the count of active users// w w w. j a v a2s . c o m * * @return * @throws PortalException * @throws SystemException */ public int getActiveUsersCount() throws PortalException, SystemException { DynamicQuery userQuery = DynamicQueryFactoryUtil.forClass(User.class, PortalClassLoaderUtil.getClassLoader()); Criterion criterion1 = null; Criterion criterion2 = null; criterion1 = RestrictionsFactoryUtil.eq(FIELD_STATUS, 0); criterion2 = RestrictionsFactoryUtil.ne(FIELD_EMAIL, DEFAULT_EMAIL); userQuery.add(criterion1); userQuery.add(criterion2); return (int) UserLocalServiceUtil.dynamicQueryCount(userQuery); }
From source file:com.slayer.service.impl.ProfileLocalServiceImpl.java
License:Open Source License
public List<Profile> getUserProfiles(long userId) { List<Profile> userProfiles = null; DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Profile.class); dynamicQuery.add(RestrictionsFactoryUtil.eq("userId", userId)); dynamicQuery.add(RestrictionsFactoryUtil.ne("status", IConstants.STATUS_DELETED)); dynamicQuery.addOrder(OrderFactoryUtil.desc("modifiedDate")); try {// w ww. j av a 2s. c o m userProfiles = dynamicQuery(dynamicQuery); } catch (SystemException e) { e.printStackTrace(); } return userProfiles; }
From source file:org.oep.cmon.portlet.quanlyvaitro.business.QuanLyVaiTroBusiness.java
License:Apache License
/** * This is function checkExistingVaiTro// ww w. j a va2 s.co m * Version: 1.0 * * History: * DATE AUTHOR DESCRIPTION * ------------------------------------------------- * 3-March-2013 Nam Dinh Create new * @param vaiTroId * @param ma * @throws Exception * @return boolean */ public static boolean checkExistingVaiTro(String vaiTroId, String ma) throws Exception { long count = 0; try { DynamicQuery query = DynamicQueryFactoryUtil.forClass(VaiTro.class); // This is a test line for display all request if there's no search // criteria Criterion criterion = null; criterion = RestrictionsFactoryUtil.eq("daXoa", Constants.ACTIVE); if (!Helpers.isEmpty(vaiTroId)) { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.ne("id", Long.valueOf(vaiTroId))); } if (!Helpers.isEmpty(ma)) { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq("ma", ma)); } query = query.add(criterion); query.setProjection(ProjectionFactoryUtil.rowCount()); Iterator<Long> resultsItr = VaiTroLocalServiceUtil.dynamicQuery(query).iterator(); if (resultsItr.hasNext()) { count = ((Long) resultsItr.next()).longValue(); } } catch (Exception se) { _log.error(se.getMessage(), se); throw se; } return (count > 0) ? true : false; }
From source file:org.politaktiv.communityselect.application.CommunitiesRepositoryImpl.java
License:Apache License
/** * Get all groups from type "public"//from w w w. j a v a 2 s . c o m * * @return list of groups */ private List<Group> getAllGroupsFromCompanyId(long companyId) { DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Group.class, PortalClassLoaderUtil.getClassLoader()); // only groups from actual company dynamicQuery.add(RestrictionsFactoryUtil.eq("companyId", companyId)); dynamicQuery.add(RestrictionsFactoryUtil.eq("classNameId", PortalUtil.getClassNameId(Group.class))); // but not the guest community dynamicQuery.add(RestrictionsFactoryUtil.ne("name", GroupConstants.GUEST)); // and not the control panel group dynamicQuery.add(RestrictionsFactoryUtil.ne("name", GroupConstants.CONTROL_PANEL)); // reverse order (newest groups first) dynamicQuery.addOrder(OrderFactoryUtil.desc("groupId")); try { return GroupLocalServiceUtil.dynamicQuery(dynamicQuery); } catch (SystemException e) { _log.error("error while trying to get public communities: " + e); return null; } }