mirror of
https://github.com/Cacti/cacti.git
synced 2026-10-23 03:27:02 +09:00
108 lines
4.1 KiB
PHP
108 lines
4.1 KiB
PHP
<?php
|
|
/*
|
|
+-------------------------------------------------------------------------+
|
|
| Copyright (C) 2004-2026 The Cacti Group |
|
|
| |
|
|
| 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. |
|
|
+-------------------------------------------------------------------------+
|
|
| Cacti: The Complete RRDTool-based Graphing Solution |
|
|
+-------------------------------------------------------------------------+
|
|
| This code is designed, written, and maintained by the Cacti Group. See |
|
|
| about.php and/or the AUTHORS file for specific developer information. |
|
|
+-------------------------------------------------------------------------+
|
|
| http://www.cacti.net/ |
|
|
+-------------------------------------------------------------------------+
|
|
*/
|
|
|
|
function get_graph_template_details(int $local_graph_id) : array {
|
|
$graph_local = db_fetch_row_prepared('SELECT gl.*, gt.name AS template_name, sqg.name AS query_name
|
|
FROM graph_local AS gl
|
|
LEFT JOIN graph_templates AS gt
|
|
ON gl.graph_template_id = gt.id
|
|
LEFT JOIN snmp_query_graph AS sqg
|
|
ON sqg.id = gl.snmp_query_graph_id
|
|
WHERE gl.id = ?',
|
|
[$local_graph_id]);
|
|
|
|
$aggregate = db_fetch_row_prepared('SELECT agt.id, agt.name
|
|
FROM aggregate_graphs AS ag
|
|
LEFT JOIN aggregate_graph_templates AS agt
|
|
ON ag.aggregate_template_id=agt.id
|
|
WHERE local_graph_id = ?',
|
|
[$local_graph_id]);
|
|
|
|
if (!empty($aggregate)) {
|
|
$url = CACTI_PATH_URL . 'aggregate_graphs.php?action=edit&id=';
|
|
|
|
if (!empty($aggregate['id'])) {
|
|
return [
|
|
'id' => $local_graph_id,
|
|
'name' => $aggregate['name'],
|
|
'graph_description' => __('Aggregated Device'),
|
|
'url' => $url . $local_graph_id,
|
|
'source' => GRAPH_SOURCE_AGGREGATE,
|
|
];
|
|
} else {
|
|
return [
|
|
'id' => $local_graph_id,
|
|
'name' => __('Not Templated'),
|
|
'graph_description' => __('Not Applicable'),
|
|
'url' => $url . $local_graph_id,
|
|
'source' => GRAPH_SOURCE_AGGREGATE,
|
|
];
|
|
}
|
|
} elseif ($graph_local['graph_template_id'] == 0) {
|
|
return [
|
|
'id' => $local_graph_id,
|
|
'name' => __('Not Templated'),
|
|
'url' => '',
|
|
'source' => GRAPH_SOURCE_PLAIN,
|
|
];
|
|
} elseif ($graph_local['snmp_query_id'] > 0 && $graph_local['snmp_query_graph_id'] > 0) {
|
|
$url = CACTI_PATH_URL . 'data_queries.php' .
|
|
'?action=item_edit' .
|
|
'&id=' . $graph_local['snmp_query_graph_id'] .
|
|
'&snmp_query_id=' . $graph_local['snmp_query_id'];
|
|
|
|
return [
|
|
'id' => $graph_local['snmp_query_graph_id'],
|
|
'name' => (!empty($graph_local['query_name']) ? $graph_local['query_name'] : __('Not Found')),
|
|
'url' => $url,
|
|
'source' => GRAPH_SOURCE_DATA_QUERY
|
|
];
|
|
} elseif ($graph_local['snmp_query_id'] > 0 && $graph_local['snmp_query_graph_id'] == 0) {
|
|
return [
|
|
'id' => 0,
|
|
'name' => __('Damaged Graph'),
|
|
'url' => '',
|
|
'source' => GRAPH_SOURCE_DATA_QUERY
|
|
];
|
|
} else {
|
|
if (!empty($graph_local['template_name'])) {
|
|
$url = CACTI_PATH_URL . 'graph_templates.php?action=template_edit&id=' . $graph_local['graph_template_id'];
|
|
|
|
return [
|
|
'id' => $graph_local['graph_template_id'],
|
|
'name' => $graph_local['template_name'],
|
|
'url' => $url,
|
|
'source' => GRAPH_SOURCE_TEMPLATE,
|
|
];
|
|
} else {
|
|
return [
|
|
'id' => 0,
|
|
'name' => __('Not Found'),
|
|
'url' => '',
|
|
'source' => GRAPH_SOURCE_TEMPLATE,
|
|
];
|
|
}
|
|
}
|
|
}
|