Январь 2016 — ВВСки

Месяц: Январь 2016

Добавить право на бизнес-процесс Битрикса

28.01.2016 от admin·Нет комментариев

SET NAMES 'utf8';
SET CHARACTER SET utf8;

set @bp=158907;
set @user=6324;
set @need_permission = 'read';

set @permission = '';

select s.id
into @workflow
from b_bp_workflow_state s
where
s.document_id= @bp;

select permission
into @permission
from b_bp_workflow_permissions p
where p.workflow_id=@workflow
and p.object_id = concat('user_', cast(@user AS CHAR));

insert into b_bp_workflow_permissions (workflow_id, object_id, permission)
select @workflow, concat('user_', cast(@user AS CHAR(4))), @need_permission
from dual
where @permission != @need_permission;

select *
from b_bp_workflow_permissions p
where p.workflow_id=@workflow
and p.object_id = concat('user_', cast(@user AS CHAR))
order by id;

SET NAMES 'utf8';

SET CHARACTER SET utf8;

set @bp=158907;

set @user=6324;

set @need_permission = 'read';

set @permission = '';

select s.id

into @workflow

from b_bp_workflow_state s

where

s.document_id= @bp;

select permission

into @permission

from b_bp_workflow_permissions p

where p.workflow_id=@workflow

and p.object_id = concat('user_', cast(@user AS CHAR));

insert into b_bp_workflow_permissions (workflow_id, object_id, permission)

select @workflow, concat('user_', cast(@user AS CHAR(4))), @need_permission

from dual

where @permission != @need_permission;

select *

from b_bp_workflow_permissions p

where p.workflow_id=@workflow

and p.object_id = concat('user_', cast(@user AS CHAR))

order by id;