3 +--------------------------------------------------------------------+
4 | Copyright CiviCRM LLC. All rights reserved. |
6 | This work is published under the GNU AGPLv3 license with some |
7 | permitted exceptions and without any warranty. For full license |
8 | and copyright information, see https://civicrm.org/licensing |
9 +--------------------------------------------------------------------+
15 * @copyright CiviCRM LLC https://civicrm.org/licensing
21 class CRM_Core_Permission_DrupalBase
extends CRM_Core_Permission_Base
{
28 public function getContactEmails($uids) {
32 $uidString = implode(',', $uids);
35 FROM civicrm_contact c
36 INNER JOIN civicrm_email e ON ( c.id = e.contact_id AND e.is_primary = 1 )
37 INNER JOIN civicrm_uf_match uf ON ( c.id = uf.contact_id )
38 WHERE c.is_deceased = 0
40 AND uf.uf_id IN ( $uidString )
43 $dao = CRM_Core_DAO
::executeQuery($sql);
46 while ($dao->fetch()) {
47 $emails[] = $dao->email
;
50 return implode(', ', $emails);
54 * Given a roles array, check for access requirements
60 * true if yes, else false
62 public function checkGroupRole($array) {
63 if (function_exists('user_load') && isset($array)) {
64 $user = user_load($GLOBALS['user']->uid
);
65 //if giver roles found in user roles - return true
66 foreach ($array as $key => $value) {
67 if (in_array($value, $user->roles
)) {
78 public function isModulePermissionSupported() {
83 * Get all the contact emails for users that have a specific permission.
85 * @param string $permissionName
86 * Name of the permission we are interested in.
89 * a comma separated list of email addresses
91 public function permissionEmails($permissionName) {
94 if (isset($_cache[$permissionName])) {
95 return $_cache[$permissionName];
100 SELECT {users}.uid, {role_permission}.permission
103 ON {users}.uid = {users_roles}.uid
104 JOIN {role_permission}
105 ON {role_permission}.rid = {users_roles}.rid
106 WHERE {role_permission}.permission = '{$permissionName}'
107 AND {users}.status = 1
110 $result = db_query($sql);
111 foreach ($result as $record) {
112 $uids[] = $record->uid
;
115 $_cache[$permissionName] = self
::getContactEmails($uids);
116 return $_cache[$permissionName];
122 public function upgradePermissions($permissions) {
123 if (empty($permissions)) {
124 throw new CRM_Core_Exception("Cannot upgrade permissions: permission list missing");
126 $query = db_delete('role_permission')
127 ->condition('module', 'civicrm')
128 ->condition('permission', array_keys($permissions), 'NOT IN');