/** 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; }