/** Function to get the vtiger_role related vtiger_users
* @param $roleid -- RoleId :: Type varchar
* @returns $roleUsers-- Role Related User Array in the following format:
* $roleUsers=Array($userId1=>$userName,$userId2=>$userName,........,$userIdn=>$userName));
*/
function getRoleUsers($roleId)
{
global $log, $adb;
$log->debug("Entering getRoleUsers(" . $roleId . ") method ...");
$roleRelatedUsers = VTCacheUtils::lookupRole_RelatedUsers($roleId);
if ($roleRelatedUsers === false) {
$query = 'select vtiger_user2role.*,vtiger_users.* from vtiger_user2role inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid where roleid=?';
$result = $adb->pquery($query, array($roleId));
$num_rows = $adb->num_rows($result);
$roleRelatedUsers = array();
for ($i = 0; $i < $num_rows; $i++) {
$roleRelatedUsers[$adb->query_result($result, $i, 'userid')] = getFullNameFromQResult($result, $i, 'Users');
}
VTCacheUtils::updateRole_RelatedUsers($roleId, $roleRelatedUsers);
}
$log->debug("Exiting getRoleUsers method ...");
return $roleRelatedUsers;
}
