The problem is that users pertaining to a Organization/Community role is mistakenly read from a UserRole table while it must be retrieved from UserGroupRole table. So what you have to do is changing AnnouncementEntryLocalServiceImpl class and more precisely the notifyUser() method. I bring here part of this method between "altered by Rose System" comments here (lines 10-23):
else if (className.equals(Organization.class.getName())) {
Organization organization =
organizationPersistence.findByPrimaryKey(classPK);
toName = organization.getName();
params.put("usersOrgs", classPK);
}
//altered By Rose System
else if (className.equals(Role.class.getName()) && RoleUtil.findByPrimaryKey(classPK).getType() == 1 ) {
Role role = rolePersistence.findByPrimaryKey(classPK);
toName = role.getName();
params.put("usersRoles", classPK);
}
else if (className.equals(Role.class.getName()) && RoleUtil.findByPrimaryKey(classPK).getType() != 1){
Role role = rolePersistence.findByPrimaryKey(classPK);
toName = role.getName();
params.put("userGroupRole2", classPK);
}
//altered by Rose System
else if (className.equals(UserGroup.class.getName())) {
UserGroup userGroup = userGroupPersistence.findByPrimaryKey(
classPK);
toName = userGroup.getName();
params.put("usersUserGroups", classPK);
}
You also have to change getWhere and getJoing methods of UserFinderImpl class. here is the
getWhere change (lines 6-10):
else if (key.equals("usersRoles")) {
join = CustomSQLUtil.get(JOIN_BY_USERS_ROLES);
}
//altered by Rose System
else if (key.equals("userGroupRole2")) {
join = CustomSQLUtil.get(JOIN_BY_USER_GROUP_ROLE_2);
}
//altered by Rose System
else if (key.equals("usersUserGroups")) {
join = CustomSQLUtil.get(JOIN_BY_USERS_USER_GROUPS);
}
BTW, don't forget to define JOIN_BY_USER_GROUP_ROLE_2 variable in the class.
here is also the slight modification of getJoin (lines 5-9):
else if (key.equals("userGroupRole")) {
join = CustomSQLUtil.get(JOIN_BY_USER_GROUP_ROLE);
}
//rose system
else if (key.equals("userGroupRole2")) {
join = CustomSQLUtil.get(JOIN_BY_USER_GROUP_ROLE_2);
}
//rose system
else if (key.equals("usersGroups")) {
join = CustomSQLUtil.get(JOIN_BY_USERS_GROUPS);
}
you also have to add the new query to portal.xml as follows:
<sql id="com.liferay.portal.service.persistence.UserFinder.joinByUserGroupRole2">
INNER JOIN
UserGroupRole ON
(UserGroupRole.userId = User_.userId)
WHERE
(UserGroupRole.roleId = ?)
</sql>
As you see this query uses UserGroupRole to retrieve the users of a community/organization
role.
I hope this helps.
