Query("
INSERT INTO b_operation
(NAME,MODULE_ID,DESCRIPTION,BINDING)
VALUES
('".$ar[0]."','".$ar[1]."','".$ar[2]."','".$ar[3]."')
", false, "FILE: ".__FILE__."
LINE: ".__LINE__);
foreach($arTasksF as $ar)
$DB->Query("
INSERT INTO b_task
(NAME,LETTER,MODULE_ID,SYS,DESCRIPTION,BINDING)
VALUES
('".$ar[0]."','".$ar[1]."','".$ar[2]."','".$ar[3]."','".$ar[4]."','".$ar[5]."')
", false, "FILE: ".__FILE__."
LINE: ".__LINE__);
// ############ b_group_task ###########
$sql_str = "
INSERT INTO b_group_task
(GROUP_ID,TASK_ID)
SELECT MG.GROUP_ID, T.ID
FROM
b_task T
INNER JOIN b_module_group MG ON MG.G_ACCESS = T.LETTER
WHERE
T.SYS = 'Y'
AND T.BINDING = 'module'
AND MG.MODULE_ID = 'security'
AND T.MODULE_ID = MG.MODULE_ID
";
$z = $DB->Query($sql_str, false, "FILE: ".__FILE__."
LINE: ".__LINE__);
// ############ b_task_operation ###########
foreach($arOInT as $tname => $arOp)
{
$sql_str = "
INSERT INTO b_task_operation
(TASK_ID,OPERATION_ID)
SELECT T.ID TASK_ID, O.ID OPERATION_ID
FROM
b_task T
,b_operation O
WHERE
T.SYS='Y'
AND T.NAME='".$tname."'
AND O.NAME in ('".implode("','", $arOp)."')
AND O.NAME not in (
SELECT O2.NAME
FROM
b_task T2
inner join b_task_operation TO2 on TO2.TASK_ID = T2.ID
inner join b_operation O2 on O2.ID = TO2.OPERATION_ID
WHERE
T2.SYS='Y'
AND T2.NAME='".$tname."'
)
";
$z = $DB->Query($sql_str, false, "FILE: ".__FILE__."
LINE: ".__LINE__);
}
global $CACHE_MANAGER;
if(is_object($CACHE_MANAGER))
{
$CACHE_MANAGER->CleanDir("b_task");
$CACHE_MANAGER->CleanDir("b_task_operation");
}
?>