1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
<?php declare(strict_types = 0);
/*
** Zabbix
** Copyright (C) 2001-2022 Zabbix SIA
**
** This program is free software; you can redistribute it and/or modify
** it under the terms of the GNU General Public License as published by
** the Free Software Foundation; either version 2 of the License, or
** (at your option) any later version.
**
** This program is distributed in the hope that it will be useful,
** but WITHOUT ANY WARRANTY; without even the implied warranty of
** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
** GNU General Public License for more details.
**
** You should have received a copy of the GNU General Public License
** along with this program; if not, write to the Free Software
** Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
**/
/**
* Class to perform low level discovery rule related actions.
*/
class CDiscoveryRuleManager {
/**
* Deletes discovery rule and related entities without permission check.
*
* @param array $ruleids
*/
public static function delete(array $ruleids): void {
// Get child discovery rules.
$parent_itemids = $ruleids;
$child_ruleids = [];
do {
$db_items = DBselect('SELECT i.itemid FROM items i WHERE '.dbConditionInt('i.templateid', $parent_itemids));
$parent_itemids = [];
while ($db_item = DBfetch($db_items)) {
$parent_itemids[$db_item['itemid']] = $db_item['itemid'];
$child_ruleids[$db_item['itemid']] = $db_item['itemid'];
}
} while ($parent_itemids);
$ruleids = array_merge($ruleids, $child_ruleids);
// Delete item prototypes.
$iprototypeids = [];
$db_items = DBselect(
'SELECT i.itemid'.
' FROM item_discovery id,items i'.
' WHERE i.itemid=id.itemid'.
' AND '.dbConditionInt('parent_itemid', $ruleids)
);
while ($item = DBfetch($db_items)) {
$iprototypeids[$item['itemid']] = $item['itemid'];
}
if ($iprototypeids) {
CItemPrototypeManager::delete($iprototypeids);
}
// Delete host prototypes.
$db_host_prototypes = DBfetchArrayAssoc(DBselect(
'SELECT hd.hostid,h.host'.
' FROM host_discovery hd,hosts h'.
' WHERE hd.hostid=h.hostid'.
' AND '.dbConditionInt('hd.parent_itemid', $ruleids)
), 'hostid');
if ($db_host_prototypes) {
CHostPrototype::deleteForce($db_host_prototypes);
}
// Delete LLD rules.
DB::delete('item_tag', ['itemid' => $ruleids]);
DB::delete('item_preproc', ['itemid' => $ruleids]);
DB::update('items', [
'values' => ['templateid' => 0],
'where' => ['itemid' => $ruleids]
]);
DB::delete('items', ['itemid' => $ruleids]);
$insert = [];
foreach ($ruleids as $ruleid) {
$insert[] = [
'tablename' => 'events',
'field' => 'lldruleid',
'value' => $ruleid
];
}
DB::insertBatch('housekeeper', $insert);
}
}
|