function _workflow_access_get_affected_roles in Workflow 7.2
Same name and namespace in other branches
- 7 workflow_access/workflow_access.features.inc \_workflow_access_get_affected_roles()
Helper to find the roles needs by an export.
Return value
array A workflow_name-indexed hash of non-default roles in workflow_access for that workflow.
1 call to _workflow_access_get_affected_roles()
- workflow_access_features_export in workflow_access/
workflow_access.features.inc - Implements hook_features_export().
File
- workflow_access/
workflow_access.features.inc, line 15 - Workflow_access records are a **faux-exportable** component.
Code
function _workflow_access_get_affected_roles() {
$sql = <<<SQL
SELECT DISTINCT
w.name AS wname,
r.name AS rname
FROM {workflow_access} wa
INNER JOIN {workflow_states} ws ON wa.sid = ws.sid
INNER JOIN {workflows} w ON ws.wid = w.wid
INNER JOIN {role} r ON wa.rid = r.rid
SQL;
$roles = array();
foreach (db_query($sql) as $row) {
$roles[$row->wname][$row->rname] = $row->rname;
}
return $roles;
}