Query("SELECT NAME FROM b_operation WHERE MODULE_ID = 'iblock'");
while($ar = $rsOperations->Fetch())
$arDBOperations[$ar["NAME"]] = $ar["NAME"];
foreach($arFOp as $ar)
{
if(!isset($arDBOperations[$ar[0]]))
{
$DB->Query("
INSERT INTO b_operation
(NAME, MODULE_ID, BINDING)
VALUES
('".$ar[0]."', 'iblock', '".$ar[1]."')
", false, "FILE: ".__FILE__."
LINE: ".__LINE__);
}
}
$arDBTasks = array();
$rsTasks = $DB->Query("SELECT NAME FROM b_task WHERE MODULE_ID = 'iblock' AND SYS = 'Y'");
while($ar = $rsTasks->Fetch())
$arDBTasks[$ar["NAME"]] = $ar["NAME"];
foreach($arTasksF as $ar)
{
if(!isset($arDBTasks[$ar[0]]))
{
$DB->Query("
INSERT INTO b_task
(NAME, LETTER, MODULE_ID, SYS, BINDING)
VALUES
('".$ar[0]."', '".$ar[1]."', 'iblock', 'Y', '".$ar[2]."')
", 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");
}
?>