Example usage for com.liferay.portal.kernel.dao.orm CustomSQLParam CustomSQLParam

Introduction

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

Prototype

public CustomSQLParam(String sql, Object value) 

Source Link

Usage

From source file:com.liferay.invitation.invite.members.util.InviteMembersUserHelper.java

License:Open Source License

public List<User> getAvailableUsers(long companyId, long groupId, String keywords, int start, int end)
        throws Exception {

    LinkedHashMap usersParams = new LinkedHashMap();

    usersParams.put("usersInvited",
            new CustomSQLParam(CustomSQLUtil.get(getClass(),
                    "com.liferay.portal.service.persistence.UserFinder." + "filterByUsersGroupsGroupId"),
                    groupId));/*from   w w w. j  a va  2s  .co  m*/

    return _userLocalService.search(companyId, keywords, WorkflowConstants.STATUS_APPROVED, usersParams, start,
            end, new UserFirstNameComparator(true));
}

---

From source file:com.liferay.invitation.invite.members.util.InviteMembersUserHelper.java

License:Open Source License

public int getAvailableUsersCount(long companyId, long groupId, String keywords) throws Exception {

    LinkedHashMap usersParams = new LinkedHashMap();

    usersParams.put("usersInvited",
            new CustomSQLParam(CustomSQLUtil.get(getClass(),
                    "com.liferay.portal.service.persistence.UserFinder." + "filterByUsersGroupsGroupId"),
                    groupId));/*  w w w .  ja  v  a2  s . c  o  m*/

    return _userLocalService.searchCount(companyId, keywords, WorkflowConstants.STATUS_APPROVED, usersParams);
}

---

From source file:com.liferay.so.invitemembers.util.InviteMembersUtil.java

License:Open Source License

public static List<User> getAvailableUsers(long companyId, long groupId, String keywords, int start, int end)
        throws Exception {

    LinkedHashMap usersParams = new LinkedHashMap();

    usersParams.put("usersInvited",
            new CustomSQLParam(CustomSQLUtil
                    .get("com.liferay.portal.service.persistence.UserFinder." + "filterByUsersGroupsGroupId"),
                    groupId));/*from  w  ww . j av  a 2 s.  c  om*/

    return UserLocalServiceUtil.search(companyId, keywords, WorkflowConstants.STATUS_APPROVED, usersParams,
            start, end, new UserFirstNameComparator(true));
}

---

From source file:com.liferay.so.invitemembers.util.InviteMembersUtil.java

License:Open Source License

public static int getAvailableUsersCount(long companyId, long groupId, String keywords) throws Exception {

    LinkedHashMap usersParams = new LinkedHashMap();

    usersParams.put("usersInvited",
            new CustomSQLParam(CustomSQLUtil
                    .get("com.liferay.portal.service.persistence.UserFinder." + "filterByUsersGroupsGroupId"),
                    groupId));//from  w  w  w. j ava2  s.  c  om

    return UserLocalServiceUtil.searchCount(companyId, keywords, WorkflowConstants.STATUS_APPROVED,
            usersParams);
}

---

From source file:com.rivetlogic.util.PeopleDirectoryUtil.java

License:Open Source License

/**
 * Gets the user params./*  w w w  .jav  a 2s.co  m*/
 * 
 * @return the user params
 */
public static LinkedHashMap<String, Object> getUserParams() {

    LinkedHashMap<String, Object> userParams = new LinkedHashMap<String, Object>();
    userParams.put("contactFrom", new CustomSQLParam(
            "left join Phone on User_.userId = Phone.userId left join Address on User_.userId = Address.userId",
            null));
    return userParams;
}

---