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
|
<?php
/*
** Copyright (C) 2001-2025 Zabbix SIA
**
** This program is free software: you can redistribute it and/or modify it under the terms of
** the GNU Affero General Public License as published by the Free Software Foundation, version 3.
**
** 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 Affero General Public License for more details.
**
** You should have received a copy of the GNU Affero General Public License along with this program.
** If not, see <https://www.gnu.org/licenses/>.
**/
/**
* Class to perform low level graph related actions.
*/
class CGraphManager {
/**
* Deletes graphs and related entities without permission check.
*
* @param array $graphids
*/
public static function delete(array $graphids) {
$del_graphids = [];
// Selecting all inherited graphs.
$parent_graphids = array_flip($graphids);
do {
$db_graphs = DBselect(
'SELECT g.graphid FROM graphs g WHERE '.dbConditionInt('g.templateid', array_keys($parent_graphids))
);
$del_graphids += $parent_graphids;
$parent_graphids = [];
while ($db_graph = DBfetch($db_graphs)) {
if (!array_key_exists($db_graph['graphid'], $del_graphids)) {
$parent_graphids[$db_graph['graphid']] = true;
}
}
} while ($parent_graphids);
$del_graphids = array_keys($del_graphids);
DB::delete('profiles', [
'idx' => 'web.latest.graphid',
'value_id' => $del_graphids
]);
DB::delete('widget_field', ['value_graphid' => $del_graphids]);
DB::delete('graph_discovery', ['graphid' => $del_graphids]);
DB::delete('graphs_items', ['graphid' => $del_graphids]);
DB::delete('graphs', ['graphid' => $del_graphids]);
}
}
|
